Loading...
HomeMy WebLinkAbout2015-11 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET NOVEMBER 2015 122 ASSETS FIRE DEPT. INVESTMENTS 322,648 PREPAID EXPENSES 11,731 ADVALOREM PROPERTY TAXES RECEIVABLE 856,185 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 346 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,422 TOTAL ASSETS 1,193,332 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 856,530 ACCOUNTS AND OTHER PAYABLES 87,373 TOTAL LIABILITIES 943,903 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 533,497 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (284,069) TOTAL FUND BALANCE 249,428 TOTAL LIABILITIES AND FUND BALANCE 1,193,332 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 14:22 12/10/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2015 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- 404,346.00- 122-40010-000-000 Property Taxes/MUD Fire 889,963.00- 889,963.00- 45,226.19- 50,476.46- 5.672 839,486.54- 122-40011-000-000 Property Taxes/Fire-Delinquent 224.27- 348.91- 348.91 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 750.00- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 57.81- 124.81- 2.774 4,375.19- Subtotal: 1,299,559.00- 1,299,559.00- 45,508.27- 50,950.18- 3.921 1,248,608.82- 122-42014-000-000 Fire Plan Review>6,000 sq ft 5,000.00- 5,000.00- 400.00- 1,200.00- 24.000 3,800.00- Subtotal: 5,000.00- 5,000.00- 400.00- 1,200.00- 24.000 3,800.00- 122-43400-000-000 Fire Inspections 825.00- 825.00- 175.00- 325.00- 39.394 500.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,825.00- 10,825.00- 175.00- 325.00- 3.002 10,500.00- 122-49900-000-000 Miscellaneous Income 50,000.00- 50,000.00- 800.00- 2,900.00- 5.800 47,100.00- Subtotal: 50,000.00- 50,000.00- 800.00- 2,900.00- 5.800 47,100.00- Program number: 1,365,384.00- 1,365,384.00- 46,883.27- 55,375.18- 4.056 1,310,008.82- Department number: Fire Revenues 1,365,384.00- 1,365,384.00- 46,883.27- 55,375.18- 4.056 1,310,008.82- Revenues Subtotal ----------- 1,365,384.00- 1,365,384.00- 46,883.27- 55,375.18- 4.056 1,310,008.82- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 14:22 12/10/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2015 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 37,428.89 59,273.85 11.663 448,952.15 122-50010-045-000 Overtime 48,735.00 48,735.00 4,311.89 9,729.05 19.963 39,005.95 122-50011-045-000 DPS Holiday Pay 15,852.00 15,852.00 14,643.90 14,643.90 92.379 1,208.10 122-50016-045-000 Longevity 5,761.00 5,761.00 5,761.00 122-50017-045-000 Certification 4,200.00 4,200.00 362.50 440.13 10.479 3,759.87 122-50020-045-000 Retirement 75,571.00 75,571.00 7,681.20 11,382.96 15.063 64,188.04 122-50026-045-000 Medical Insurance 65,546.00 65,546.00 4,684.57 7,196.58 10.979 58,349.42 122-50027-045-000 Dental Insurance 4,885.00 4,885.00 384.82 618.42 12.660 4,266.58 122-50028-045-000 Vision Insurance 859.00 859.00 187.83 232.73 27.093 626.27 122-50029-045-000 Life Insurance & Other 4,585.00 4,585.00 233.20 443.73 9.678 4,141.27 122-50030-045-000 Social Security Taxes 36,132.00 36,132.00 3,317.24 4,890.20 13.534 31,241.80 122-50035-045-000 Medicare Taxes 8,450.00 8,450.00 775.65 1,143.40 13.531 7,306.60 122-50040-045-000 Unemployment Taxes 1,724.00 1,724.00 .61 1.06 .061 1,722.94 122-50045-045-000 Workman's Compensation 9,379.00 9,379.00 9,379.00 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 250.00 Subtotal: 790,155.00 790,155.00 74,012.30 109,996.01 13.921 680,158.99 122-55030-045-000 Software & Support 6,661.00 6,661.00 462.50 6.943 6,198.50 122-55045-045-000 Legal 2,000.00 2,000.00 2,000.00 122-55080-045-000 Maintenance & Repairs 16,370.00 16,370.00 681.55 3,235.10 19.762 13,134.90 122-55090-045-000 Vehicle Maintenance 10,000.00 10,000.00 2,873.45 2,907.59 29.076 7,092.41 Subtotal: 35,031.00 35,031.00 3,555.00 6,605.19 18.855 28,425.81 122-60005-045-000 Telephone 50.00 50.00 11.65 11.65 23.300 38.35 122-60010-045-000 Communications/Mobiles 6,653.00 6,653.00 791.93 6,037.99 90.756 615.01 122-60020-045-000 Electricity/Gas 7,412.00 7,412.00 450.74 274.09 3.698 7,137.91 122-60025-045-000 Water 1,200.00 1,200.00 610.20 351.65 29.304 848.35 122-60026-045-000 Cable 1,920.00 1,920.00 286.92 440.02 22.918 1,479.98 122-60030-045-000 Rent And/Or Usage 214,379.00 214,379.00 214,379.00 122-60035-045-000 Postage 50.00 50.00 50.00 122-60055-045-000 Insurance 14,077.00 14,077.00 1,173.09 2,346.18 16.667 11,730.82 122-60066-045-000 Publications/Books/Subscrips 350.00 350.00 350.00 122-60070-045-000 Dues & Memberships 15,582.00 15,582.00 1,651.59 10.599 13,930.41 122-60080-045-000 Schools & Training 7,880.00 7,880.00 85.00 425.00 5.393 7,455.00 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 4,081.00 163.89 4.016 3,917.11 122-60110-045-000 Physicals/Testing 4,700.00 4,700.00 4,700.00 122-60125-045-000 Advertising 500.00 500.00 500.00 122-60160-045-000 Programs & Special Projects 7,500.00 7,500.00 14.77 688.39 9.179 6,811.61 122-60180-045-000 Fire Inspection/Enforcement 500.00 500.00 165.29 33.058 334.71 122-60195-045-000 Flags & Repair 3,184.00 3,184.00 77.00 162.00 5.088 3,022.00 122-60245-045-000 Miscellaneous Expense 1,001.00 1,001.00 7.50 .749 993.50 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 14:22 12/10/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 292,019.00 292,019.00 3,501.30 12,725.24 4.358 279,293.76 122-65005-045-000 Fuel & Lube 15,122.00 15,122.00 306.89 796.34 5.266 14,325.66 122-65010-045-000 Uniforms 3,140.00 3,140.00 671.51 752.83 23.975 2,387.17 122-65015-045-000 Protective Clothing 9,000.00 9,000.00 9,000.00 122-65030-045-000 Chemicals 600.00 600.00 600.00 122-65035-045-000 Small Tools 2,000.00 2,000.00 2,000.00 122-65055-045-000 Hardware 750.00 750.00 750.00 122-65085-045-000 Office Supplies 500.00 500.00 500.00 122-65105-045-000 Printing 498.00 498.00 498.00 Subtotal: 31,610.00 31,610.00 978.40 1,549.17 4.901 30,060.83 122-69050-045-000 Radios 8,000.00 8,000.00 8,000.00 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 216,569.00 216,569.00 208,568.60 96.306 8,000.40 Program number: 1,365,384.00 1,365,384.00 82,047.00 339,444.21 24.861 1,025,939.79 Department number: Fire 1,365,384.00 1,365,384.00 82,047.00 339,444.21 24.861 1,025,939.79 Expenditures Subtotal ----------- 1,365,384.00 1,365,384.00 82,047.00 339,444.21 24.861 1,025,939.79 Fund number: 122 Trophy Club MUD Fire Dept. 35,163.73 284,069.03 284,069.03- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2015 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 .00 .00 _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 .00 ** (404,346.00) Budgeted (404,346.00) Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 404 11/02/2015 Property Taxes (5,250.27) (1,008.23) (6,258.50) GL 405 11/03/2015 Property Taxes (3,491.42) (9,749.92) GL 406 11/04/2015 Property Taxes (1,145.78) (10,895.70) GL 407 11/05/2015 Property Taxes (1,999.73) (12,895.43) GL 408 11/06/2015 Property Taxes (527.65) (13,423.08) GL 409 11/09/2015 Property Taxes (2,983.60) (16,406.68) GL 410 11/10/2015 Property Taxes (3,341.43) (19,748.11) GL 411 11/12/2015 Property Taxes (590.73) (20,338.84) GL 412 11/13/2015 Property Taxes (3,445.32) (23,784.16) GL 413 11/16/2015 Property Taxes (1,296.05) (25,080.21) GL 414 11/17/2015 Property Taxes (1,740.70) (26,820.91) GL 415 11/18/2015 Property Taxes (392.92) (27,213.83) GL 416 11/19/2015 Property Taxes (1,600.46) (28,814.29) GL 417 11/20/2015 Property Taxes (1,747.00) (30,561.29) GL 418 11/23/2015 Property Taxes (1,777.84) (32,339.13) GL 419 11/24/2015 Property Taxes (13,774.91) (46,114.04) GL 420 11/25/2015 Property Taxes (508.25) (46,622.29) GL 421 11/30/2015 Property Taxes (3,854.22) (50,476.51) GL 424 11/30/2015 Correct JE191 10/15 Prop Taxes .05 (50,476.46) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (45,226.19) (50,476.46) ** (889,963.00) Budgeted (839,486.54) Remaining 6 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 404 11/02/2015 Property Taxes (124.64) 11.57 (113.07) GL 405 11/03/2015 Property Taxes (5.44) (118.51) GL 414 11/17/2015 Property Taxes (89.85) (208.36) GL 421 11/30/2015 Property Taxes (140.55) (348.91) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (224.27) (348.91) ** .00 Budgeted 348.91 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 .00 ** (750.00) Budgeted (750.00) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 404 11/02/2015 Property Taxes (67.00) (2.16) (69.16) GL 405 11/03/2015 Property Taxes (2.09) (71.25) GL 407 11/05/2015 Property Taxes (1.07) (72.32) GL 431 11/05/2015 Property Taxes .06 (72.26) GL 410 11/10/2015 Property Taxes (1.76) (74.02) GL 414 11/17/2015 Property Taxes (19.77) (93.79) GL 417 11/20/2015 Property Taxes (.29) (94.08) GL 421 11/30/2015 Property Taxes (30.68) (124.76) GL 424 11/30/2015 Correct JE191 10/15 Prop Taxes (.05) (124.81) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (57.81) (124.81) ** (4,500.00) Budgeted (4,375.19) Remaining 3 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (800.00) (400.00) (1,200.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (1,200.00) ** (5,000.00) Budgeted (3,800.00) Remaining 24 % Used Account: 122-43400-000-000 Fire Inspections 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (150.00) (175.00) (325.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (175.00) (325.00) ** (825.00) Budgeted (500.00) Remaining 39 % Used Account: 122-43415-000-000 Denton County Pledge-Fire .00 .00 _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (2,100.00) (800.00) (2,900.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (800.00) (2,900.00) ** (50,000.00) Budgeted (47,100.00) Remaining 6 % Used Department Totals: ------------------------------------------------------------------------------------------------ (55,375.18) ** (1,365,384.00) Budgeted (1,310,008.82) Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2015 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 380 11/06/2015 Fire Dept P/R 11/6/15 21,844.96 18,568.32 40,413.28 GL 384 11/20/2015 FD Payroll 11/20/15 18,860.57 59,273.85 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 37,428.89 59,273.85 ** 508,226.00 Budgeted 448,952.15 Remaining 12 % Used Account: 122-50010-045-000 Overtime 384 11/20/2015 FD Payroll 11/20/15 5,417.16 4,311.89 9,729.05 GL _______________ Account: 122-50010-045-000 Overtime Totals: 4,311.89 9,729.05 ** 48,735.00 Budgeted 39,005.95 Remaining 20 % Used Account: 122-50011-045-000 DPS Holiday Pay 384 11/20/2015 FD Payroll 11/20/15 366.22 366.22 GL 385 11/20/2015 FD Holiday Pay 14,277.68 14,643.90 GL _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: 14,643.90 14,643.90 ** 15,852.00 Budgeted 1,208.10 Remaining 92 % Used Account: 122-50016-045-000 Longevity .00 .00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 .00 ** 5,761.00 Budgeted 5,761.00 Remaining 0 % Used Account: 122-50017-045-000 Certification 380 11/06/2015 Fire Dept P/R 11/6/15 77.63 362.50 440.13 GL _______________ Account: 122-50017-045-000 Certification Totals: 362.50 440.13 ** 4,200.00 Budgeted 3,759.87 Remaining 10 % Used Account: 122-50020-045-000 Retirement 380 11/06/2015 Fire Dept P/R 11/6/15 3,701.76 2,537.36 6,239.12 GL 384 11/20/2015 FD Payroll 11/20/15 3,193.54 9,432.66 GL 385 11/20/2015 FD Holiday Pay 1,950.30 11,382.96 GL _______________ Account: 122-50020-045-000 Retirement Totals: 7,681.20 11,382.96 ** 75,571.00 Budgeted 64,188.04 Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2015 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 380 11/06/2015 Fire Dept P/R 11/6/15 2,512.01 2,765.00 5,277.01 GL 384 11/20/2015 FD Payroll 11/20/15 1,919.57 7,196.58 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,684.57 7,196.58 ** 65,546.00 Budgeted 58,349.42 Remaining 11 % Used Account: 122-50027-045-000 Dental Insurance 380 11/06/2015 Fire Dept P/R 11/6/15 233.60 192.42 426.02 GL 384 11/20/2015 FD Payroll 11/20/15 192.40 618.42 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 384.82 618.42 ** 4,885.00 Budgeted 4,266.58 Remaining 13 % Used Account: 122-50028-045-000 Vision Insurance 380 11/06/2015 Fire Dept P/R 11/6/15 44.90 150.75 195.65 GL 384 11/20/2015 FD Payroll 11/20/15 37.08 232.73 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 187.83 232.73 ** 859.00 Budgeted 626.27 Remaining 27 % Used Account: 122-50029-045-000 Life Insurance & Other 380 11/06/2015 Fire Dept P/R 11/6/15 210.53 59.76 270.29 GL 384 11/20/2015 FD Payroll 11/20/15 173.44 443.73 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 233.20 443.73 ** 4,585.00 Budgeted 4,141.27 Remaining 10 % Used Account: 122-50030-045-000 Social Security Taxes 380 11/06/2015 Fire Dept P/R 11/6/15 1,572.96 1,073.18 2,646.14 GL 384 11/20/2015 FD Payroll 11/20/15 1,358.87 4,005.01 GL 385 11/20/2015 FD Holiday Pay 885.19 4,890.20 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 3,317.24 4,890.20 ** 36,132.00 Budgeted 31,241.80 Remaining 14 % Used Account: 122-50035-045-000 Medicare Taxes 380 11/06/2015 Fire Dept P/R 11/6/15 367.75 250.91 618.66 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 384 11/20/2015 FD Payroll 11/20/15 367.75 317.73 936.39 GL 385 11/20/2015 FD Holiday Pay 207.01 1,143.40 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 775.65 1,143.40 ** 8,450.00 Budgeted 7,306.60 Remaining 14 % Used Account: 122-50040-045-000 Unemployment Taxes 380 11/06/2015 Fire Dept P/R 11/6/15 .45 .13 .58 GL 384 11/20/2015 FD Payroll 11/20/15 .48 1.06 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: .61 1.06 ** 1,724.00 Budgeted 1,722.94 Remaining 0 % Used Account: 122-50045-045-000 Workman's Compensation .00 .00 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 .00 ** 9,379.00 Budgeted 9,379.00 Remaining 0 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test .00 .00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support 462.50 .00 462.50 _______________ Account: 122-55030-045-000 Software & Support Totals: .00 462.50 ** 6,661.00 Budgeted 6,198.50 Remaining 7 % Used Account: 122-55045-045-000 Legal .00 .00 _______________ Account: 122-55045-045-000 Legal Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 322 11/24/2015 November A/P Bay door repair 2,553.55 170.00 2,723.55 OVERHEAD DOOR FORT WORTH 1229 AP 437 11/27/2015 PCards 10-27 to 11-27-015 THE HOME DEPOT 6581 16.57 2,740.12 THE HOME DEPOT 6581 PC 437 11/27/2015 PCards 10-27 to 11-27-015 THE HOME DEPOT 6581 3.43 2,743.55 THE HOME DEPOT 6581 PC 437 11/27/2015 PCards 10-27 to 11-27-015 THE HOME DEPOT 6581 26.90 2,770.45 THE HOME DEPOT 6581 PC 437 11/27/2015 PCards 10-27 to 11-27-015 JUSTIN SAW AND ENGINE 60.49 2,830.94 JUSTIN SAW AND ENGINE PC 437 11/27/2015 PCards 10-27 to 11-27-015 FILTERS FAST 188.92 3,019.86 FILTERS FAST PC 432 11/30/2015 November A/P Service on sign transformer 8/ 178.00 3,197.86 VALLELUNGA ENTERPRISES LLC 1282 AP 452 11/30/2015 November A/P Rug cleaning 37.24 3,235.10 G & K SERVICES AP 452 11/30/2015 November A/P Rug Cleaning 37.24 3,272.34 G & K SERVICES AP 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (37.24) 3,235.10 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 681.55 3,235.10 ** 16,370.00 Budgeted 13,134.90 Remaining 20 % Used Account: 122-55090-045-000 Vehicle Maintenance 437 11/27/2015 PCards 10-27 to 11-27-015 TCI #627 34.14 2,873.45 2,907.59 TCI #627 PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 2,873.45 2,907.59 ** 10,000.00 Budgeted 7,092.41 Remaining 29 % Used Account: 122-60005-045-000 Telephone 437 11/27/2015 PCards 10-27 to 11-27-015 ATT*BUS PHONE PMT 5.94 5.94 ATT*BUS PHONE PMT PC 437 11/27/2015 PCards 10-27 to 11-27-015 ATT*BUS PHONE PMT 5.71 11.65 ATT*BUS PHONE PMT PC _______________ Account: 122-60005-045-000 Telephone Totals: 11.65 11.65 ** 50.00 Budgeted 38.35 Remaining 23 % Used Account: 122-60010-045-000 Communications/Mobiles 380 11/06/2015 Fire Dept P/R 11/6/15 5,246.06 75.00 5,321.06 GL 438 11/30/2015 November A/P October Verizon and Sungard bi 114.10 5,435.16 TOWN OF TROPHY CLUB 1279 AP 438 11/30/2015 November A/P October Verizon and Sungard bi 400.00 5,835.16 TOWN OF TROPHY CLUB 1279 AP 438 11/30/2015 November A/P October Verizon and Sungard bi 202.83 6,037.99 TOWN OF TROPHY CLUB 1279 AP _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 791.93 6,037.99 ** 6,653.00 Budgeted 615.01 Remaining 91 % Used Account: 122-60020-045-000 Electricity/Gas 253 11/10/2015 Nov A/P Electricity 10/9-11/8/15 (176.65) 831.78 655.13 HUDSON ENERGY SERVICES, LLC 1184 AP 300 11/20/2015 November A/P Gas for fire station 10/20 to 69.71 724.84 ATMOS ENERGY 1198 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (176.65) (450.75) 274.09 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 450.74 274.09 ** 7,412.00 Budgeted 7,137.91 Remaining 4 % Used Account: 122-60025-045-000 Water 322 11/24/2015 November A/P Water bills October (258.55) 233.18 (25.37) TROPHY CLUB MUD (WATER BILLS) 1233 AP 322 11/24/2015 November A/P Water bills October 283.92 258.55 TROPHY CLUB MUD (WATER BILLS) 1233 AP 432 11/30/2015 November A/P November Water Bills 46.66 305.21 TROPHY CLUB MUD (WATER BILLS) 1281 AP 432 11/30/2015 November A/P November Water Bills 139.55 444.76 TROPHY CLUB MUD (WATER BILLS) 1281 AP 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (93.11) 351.65 AR _______________ Account: 122-60025-045-000 Water Totals: 610.20 351.65 ** 1,200.00 Budgeted 848.35 Remaining 29 % Used Account: 122-60026-045-000 Cable 437 11/27/2015 PCards 10-27 to 11-27-015 ATT*BILL PAYMENT 153.10 128.50 281.60 ATT*BILL PAYMENT PC 437 11/27/2015 PCards 10-27 to 11-27-015 ATT*BILL PAYMENT 158.42 440.02 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 286.92 440.02 ** 1,920.00 Budgeted 1,479.98 Remaining 23 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 214,379.00 Budgeted 214,379.00 Remaining 0 % Used Account: 122-60035-045-000 Postage .00 .00 _______________ Account: 122-60035-045-000 Postage Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 133 11/01/2015 Prepaid Insurance, W/C Nov 1,173.09 1,173.09 2,346.18 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,173.09 2,346.18 ** 14,077.00 Budgeted 11,730.82 Remaining 17 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 1,651.59 .00 1,651.59 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 1,651.59 ** 15,582.00 Budgeted 13,930.41 Remaining 11 % Used Account: 122-60080-045-000 Schools & Training 216 11/04/2015 November A/P State testing/certification Ta 340.00 85.00 425.00 TX COMM ON FIRE PROTECTION 1170 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 85.00 425.00 ** 7,880.00 Budgeted 7,455.00 Remaining 5 % 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 163.89 .00 163.89 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 163.89 ** 4,081.00 Budgeted 3,917.11 Remaining 4 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 4,700.00 Budgeted 4,700.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 437 11/27/2015 PCards 10-27 to 11-27-015 RANDALLS STORE00017897 673.62 14.77 688.39 RANDALLS STORE00017897 PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 14.77 688.39 ** 7,500.00 Budgeted 6,811.61 Remaining 9 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 165.29 .00 165.29 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 165.29 ** 500.00 Budgeted 334.71 Remaining 33 % Used Account: 122-60195-045-000 Flags & Repair 452 11/30/2015 November A/P Flags 85.00 154.00 239.00 SYMONDS FLAGS & POLES AP 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (77.00) 162.00 AR _______________ Account: 122-60195-045-000 Flags & Repair Totals: 77.00 162.00 ** 3,184.00 Budgeted 3,022.00 Remaining 5 % Used Account: 122-60245-045-000 Miscellaneous Expense 7.50 .00 7.50 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 7.50 ** 1,001.00 Budgeted 993.50 Remaining 1 % Used Account: 122-65005-045-000 Fuel & Lube 351 11/30/2015 Nov A/P November fuel 489.45 306.89 796.34 US Bank Voyager Fleet Systems 1241 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 306.89 796.34 ** 15,122.00 Budgeted 14,325.66 Remaining 5 % Used Account: 122-65010-045-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 322 11/24/2015 November A/P Crosstech jacket - Evans 81.32 307.93 389.25 RED THE UNIFORM TAILOR 1230 AP 437 11/27/2015 PCards 10-27 to 11-27-015 REDBACK, USA 183.90 573.15 REDBACK, USA PC 437 11/27/2015 PCards 10-27 to 11-27-015 NUSHOE 90.00 663.15 NUSHOE PC 437 11/27/2015 PCards 10-27 to 11-27-015 NUSHOE 90.00 753.15 NUSHOE PC 351 11/30/2015 Nov A/P Uniforms 162.64 915.79 RED THE UNIFORM TAILOR 1240 AP 432 11/30/2015 November A/P Boots 225.98 1,141.77 RED THE UNIFORM TAILOR 1274 AP 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (388.94) 752.83 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 671.51 752.83 ** 3,140.00 Budgeted 2,387.17 Remaining 24 % Used Account: 122-65015-045-000 Protective Clothing .00 .00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools .00 .00 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-65055-045-000 Hardware .00 .00 _______________ Account: 122-65055-045-000 Hardware Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 122-65085-045-000 Office Supplies .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2015 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 Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 498.00 Budgeted 498.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 8,000.00 Budgeted 8,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 339,444.21 ** 1,365,384.00 Budgeted 1,025,939.79 Remaining 25 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ 284,069.03 .00 Budgeted (284,069.03) Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET NOVEMBER 2015 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 11/30/15 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 750,655 - - 750,655 CD-BANK OF THE WEST/THB DEPOSIT 35,000 35,000 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,509,461 - - 1,509,461 INVESTMENTS-TEXPOOL 1,169,753 326,020 - 1,495,773 PREPAID EXPENSES 52,614 - - 52,614 ADVALOREM PROPERTY TAXES RECEIVABLE 57,168 - - 57,168 UTILITY AND OTHER ACCOUNTS RECEIVABLE 812,351 - - 812,351 - TOTAL ASSETS 4,387,601 326,020 - 4,713,621 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 57,168 - - 57,168 ACCOUNTS AND OTHER PAYABLES 603,196 - - 603,196 CUSTOMER DEPOSITS 310,922 - - 310,922 - TOTAL LIABILITIES 971,286 - - 971,286 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 326,020 326,020 NON-SPENDABLE FUND BALANCE 30,686 30,686 ASSIGNED FUND BALANCE 407,000 - 407,000 UNASSIGNED FUND BALANCE 1,703,065 - 8,032 1,711,097 COMMITTED FUND BALANCE 1,159,233 - - 1,159,233 NET REVENUES / EXPENDITURES 116,331 - (8,032) 108,299 - TOTAL FUND BALANCE 3,416,315 326,020 - 3,742,335 - TOTAL LIABILITIES AND FUND BALANCE 4,387,601 326,020 - 4,713,621 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 14:22 12/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2015 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- 2,955.80- 3,298.93- 5.670 54,882.07- 135-40002-000-000 Property Taxes/Delinquent 43.14- 72.90- 72.90 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 10.49- 21.41- 3.294 628.59- 135-40025-000-000 PID Surcharges 146,125.00- 146,125.00- 12,368.19- 24,739.19- 16.930 121,385.81- Subtotal: 204,956.00- 204,956.00- 15,377.62- 28,132.43- 13.726 176,823.57- 135-47000-000-000 Water 5,080,244.00- 5,080,244.00- 239,184.79- 678,032.99- 13.346 4,402,211.01- 135-47005-000-000 Sewer 2,413,776.00- 2,413,776.00- 153,767.93- 359,623.08- 14.899 2,054,152.92- 135-47025-000-000 Penalties 90,985.00- 90,985.00- 12,112.42- 24,680.44- 27.126 66,304.56- 135-47030-000-000 Service Charges 9,000.00- 9,000.00- 1,625.00- 3,275.00- 36.389 5,725.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 350.00- 650.00- 32.500 1,350.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 900.00- 1,800.00- 32.727 3,700.00- 135-47070-000-000 TCCC Effluent Charges 61,330.00- 61,330.00- 3.50- 5,957.70- 9.714 55,372.30- Subtotal: 7,662,835.00- 7,662,835.00- 407,943.64- 1,074,019.21- 14.016 6,588,815.79- 135-48005-000-000 Utility Fees 69,000.00- 69,000.00- 18,400.00- 39,100.00- 56.667 29,900.00- Subtotal: 69,000.00- 69,000.00- 18,400.00- 39,100.00- 56.667 29,900.00- 135-49010-000-000 Interest Income 6,000.00- 6,000.00- 739.53- 1,492.14- 24.869 4,507.86- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 1,821.06- 16.667 9,104.94- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,166.66- 16.667 5,833.34- 135-49035-000-000 Prior Year Reserves 8,020.00- 8,020.00- 8,020.00- 135-49075-000-000 Oversize Meter Reimbursement 15,778.00- 15,778.00- 8,923.80- 14,068.80- 89.167 1,709.20- 135-49141-000-000 Interfund Transfer In 8,034.36- 8,034.36- 8,034.36 135-49900-000-000 Miscellaneous Income 63,249.00- 63,249.00- 96.11- 423.83- .670 62,825.17- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 2.00- 10.000 18.00- Subtotal: 110,993.00- 110,993.00- 19,287.66- 27,008.85- 24.334 83,984.15- Program number: 8,047,784.00- 8,047,784.00- 461,008.92- 1,168,260.49- 14.517 6,879,523.51- Department number: Revenues 8,047,784.00- 8,047,784.00- 461,008.92- 1,168,260.49- 14.517 6,879,523.51- Revenues Subtotal ----------- 8,047,784.00- 8,047,784.00- 461,008.92- 1,168,260.49- 14.517 6,879,523.51- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 14:22 12/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2015 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 265,614.00 16,860.38 26,932.29 10.140 238,681.71 135-50010-010-000 Overtime 19,500.00 19,500.00 1,547.72 2,000.93 10.261 17,499.07 135-50016-010-000 Longevity 2,945.00 2,945.00 2,945.00 2,945.00 100.000 135-50017-010-000 Certification 4,200.00 4,200.00 175.00 350.00 8.333 3,850.00 135-50020-010-000 Retirement 25,558.00 25,558.00 1,918.15 2,871.53 11.235 22,686.47 135-50026-010-000 Medical Insurance 51,398.00 51,398.00 3,269.05 5,200.06 10.117 46,197.94 135-50027-010-000 Dental Insurance 3,999.00 3,999.00 267.98 426.27 10.659 3,572.73 135-50028-010-000 Vision Insurance 910.00 910.00 59.92 95.32 10.475 814.68 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 162.77 383.52 13.682 2,419.48 135-50030-010-000 Social Security Taxes 18,565.00 18,565.00 1,305.44 1,964.62 10.582 16,600.38 135-50035-010-000 Medicare Taxes 4,341.00 4,341.00 305.30 459.45 10.584 3,881.55 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 .94 .94 .076 1,241.06 135-50045-010-000 Workman's Compensation 14,754.00 14,754.00 1,229.35 2,458.68 16.664 12,295.32 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 300.00 Subtotal: 417,429.00 417,429.00 30,047.00 46,325.06 11.098 371,103.94 135-55005-010-000 Engineering 5,000.00 5,000.00 5,000.00 135-55080-010-000 Maintenance & Repairs 85,000.00 85,000.00 5,863.89 17,050.46 20.059 67,949.54 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 799.50 1,684.74 21.059 6,315.26 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 207.70 537.70 9.776 4,962.30 Subtotal: 107,000.00 107,000.00 6,871.09 19,272.90 18.012 87,727.10 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 397.58 795.16 14.725 4,604.84 135-60020-010-000 Electricity 166,823.00 166,823.00 14,532.16 19,403.57 11.631 147,419.43 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 5,773.00 5,773.00 333.00 684.00 11.848 5,089.00 135-60090-010-000 Safety Program 400.00 400.00 21.00 21.00 5.250 379.00 135-60100-010-000 Travel & per diem 1,400.00 1,400.00 14.25 1.018 1,385.75 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 49,275.00 49,275.00 6,503.50 6,503.50 13.198 42,771.50 135-60150-010-000 Wholesale Water 2,948,742.00 2,948,742.00 234,717.97 234,717.97 7.960 2,714,024.03 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 267.08 570.49 16.300 2,929.51 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 256,772.29 262,709.94 8.244 2,924,053.06 135-65005-010-000 Fuel & Lube 35,947.00 35,947.00 652.64 1,869.28 5.200 34,077.72 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 14:22 12/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2015 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 651.23 651.23 14.133 3,956.77 135-65030-010-000 Chemicals 12,000.00 12,000.00 317.83 1,655.78 13.798 10,344.22 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 115,000.00 115,000.00 38,580.00 51,265.00 44.578 63,735.00 135-65053-010-000 Meter Change Out Program 50,000.00 50,000.00 50,000.00 Subtotal: 219,755.00 219,755.00 40,201.70 55,441.29 25.229 164,313.71 135-69005-010-000 Capital Outlays 201,000.00 201,000.00 5,777.00 49,025.85 24.391 151,974.15 135-69008-010-000 Short Term Debt-Principal 130,720.00 130,720.00 130,720.00 135-69009-010-000 Short Term Debt-Interest 1,209.00 1,209.00 1,209.00 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 80,986.69 80,986.69 63.790 45,971.31 Subtotal: 534,887.00 534,887.00 86,763.69 205,012.54 38.328 329,874.46 Program number: 4,465,834.00 4,465,834.00 420,655.77 588,761.73 13.184 3,877,072.27 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 14:22 12/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 11/2015 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 80.00 1.600 4,920.00 Subtotal: 5,000.00 5,000.00 80.00 1.600 4,920.00 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 80.00 .800 9,920.00 Department number: Water 4,475,834.00 4,475,834.00 420,655.77 588,841.73 13.156 3,886,992.27 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 14:22 12/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2015 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 24,797.25 39,517.47 11.237 312,153.53 135-50010-020-000 Overtime 19,500.00 19,500.00 1,919.16 2,696.89 13.830 16,803.11 135-50016-020-000 Longevity 6,125.00 6,125.00 6,125.00 6,125.00 100.000 135-50017-020-000 Certification 7,200.00 7,200.00 550.00 1,100.00 15.278 6,100.00 135-50020-020-000 Retirement 33,652.00 33,652.00 2,975.19 4,405.05 13.090 29,246.95 135-50026-020-000 Medical Insurance 65,989.00 65,989.00 4,686.75 7,510.22 11.381 58,478.78 135-50027-020-000 Dental Insurance 4,184.00 4,184.00 299.51 480.07 11.474 3,703.93 135-50028-020-000 Vision Insurance 972.00 972.00 69.00 110.60 11.379 861.40 135-50029-020-000 Life Insurance & Other 3,655.00 3,655.00 296.54 585.90 16.030 3,069.10 135-50030-020-000 Social Security Taxes 24,665.00 24,665.00 1,907.68 2,817.53 11.423 21,847.47 135-50035-020-000 Medicare Taxes 5,768.00 5,768.00 446.14 658.91 11.424 5,109.09 135-50040-020-000 Unemployment Taxes 1,449.00 1,449.00 1,449.00 135-50045-020-000 Workman's Compensation 9,317.00 9,317.00 776.43 1,552.87 16.667 7,764.13 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 650.00 Subtotal: 535,097.00 535,097.00 44,848.65 67,798.96 12.670 467,298.04 135-55070-020-000 Independent Labor 50,000.00 50,000.00 50,000.00 135-55080-020-000 Maintenance & Repairs 72,600.00 72,600.00 4,347.97 11,597.58 15.975 61,002.42 135-55090-020-000 Vehicle Maintenance 5,000.00 5,000.00 101.16 145.88 2.918 4,854.12 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 500.00 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 766.84 3,579.43 6.508 51,420.57 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 1,864.00 3,798.00 10.851 31,202.00 Subtotal: 218,100.00 218,100.00 7,079.97 19,120.89 8.767 198,979.11 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 485.08 743.64 13.771 4,656.36 135-60020-020-000 Electricity 161,582.00 161,582.00 11,177.89 11,624.94 7.194 149,957.06 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 400.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 3,771.00 3,771.00 3,771.00 135-60090-020-000 Safety Program 550.00 550.00 39.00 39.00 7.091 511.00 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 1,600.00 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60135-020-000 TCEQ Fees & Permits 37,150.00 37,150.00 9,439.28 25.409 27,710.72 135-60245-020-000 Miscellaneous Expenses 297.00 297.00 297.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 119,706.00 119,706.00 119,706.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 444,831.00 444,831.00 444,831.00 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 30,834.00 61,668.00 50.000 61,668.00 Subtotal: 908,423.00 908,423.00 42,535.97 83,514.86 9.193 824,908.14 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 14:22 12/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2015 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 685.67 1,353.38 4.227 30,667.62 135-65010-020-000 Uniforms 4,241.00 4,241.00 784.74 1,881.76 44.371 2,359.24 135-65030-020-000 Chemicals 27,000.00 27,000.00 3,211.88 6,156.37 22.801 20,843.63 135-65035-020-000 Small Tools 2,000.00 2,000.00 2,000.00 135-65040-020-000 Safety Equipment 750.00 750.00 414.59 414.59 55.279 335.41 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 278.96 2,941.17 22.624 10,058.83 Subtotal: 79,012.00 79,012.00 5,375.84 12,747.27 16.133 66,264.73 135-69005-020-000 Capital Outlays 150,000.00 150,000.00 150,000.00 135-69008-020-000 Short Term Debt-Principal 21,280.00 21,280.00 21,280.00 135-69009-020-000 Short Term Debt-Interest 197.00 197.00 197.00 Subtotal: 171,477.00 171,477.00 171,477.00 Program number: 1,912,109.00 1,912,109.00 99,840.43 183,181.98 9.580 1,728,927.02 Department number: Wastewater 1,912,109.00 1,912,109.00 99,840.43 183,181.98 9.580 1,728,927.02 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 14:22 12/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60020-021-000 Electricity .01 .01 .01- Subtotal: .01 .01 .01- Program number: .01 .01 .01- Department number: Collection .01 .01 .01- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 14:22 12/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2015 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 500.00 4.000 12,000.00 135-50030-026-000 Social Security Taxes 775.00 775.00 31.00 4.000 744.00 135-50035-026-000 Medicare Taxes 181.00 181.00 7.25 4.006 173.75 135-50040-026-000 Unemployment Taxes 230.00 230.00 .50 .217 229.50 135-50045-026-000 Workman's Compensation 37.00 37.00 3.08 6.17 16.676 30.83 Subtotal: 13,723.00 13,723.00 3.08 544.92 3.971 13,178.08 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.00 135-60075-026-000 Meetings 1,200.00 1,200.00 6.00 6.00 .500 1,194.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 550.00 550.00 13.750 3,450.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 50.48 2.524 1,949.52 Subtotal: 12,850.00 12,850.00 556.00 606.48 4.720 12,243.52 Program number: 26,573.00 26,573.00 559.08 1,151.40 4.333 25,421.60 Department number: Board of Directors 26,573.00 26,573.00 559.08 1,151.40 4.333 25,421.60 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 14:22 12/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2015 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 488,508.00 37,243.09 59,597.26 12.200 428,910.74 135-50010-030-000 Overtime 1,000.00 1,000.00 13.94 47.58 4.758 952.42 135-50016-030-000 Longevity 3,823.00 3,823.00 3,822.50 3,822.50 99.987 .50 135-50020-030-000 Retirement 43,202.00 43,202.00 3,660.17 5,654.96 13.090 37,547.04 135-50026-030-000 Medical Insurance 68,196.00 68,196.00 5,166.33 8,277.34 12.138 59,918.66 135-50027-030-000 Dental Insurance 4,807.00 4,807.00 364.24 583.59 12.140 4,223.41 135-50028-030-000 Vision Insurance 1,114.00 1,114.00 84.38 135.25 12.141 978.75 135-50029-030-000 Life Insurance & Other 4,431.00 4,431.00 391.82 761.24 17.180 3,669.76 135-50030-030-000 Social Security Taxes 30,823.00 30,823.00 2,394.81 3,706.66 12.026 27,116.34 135-50035-030-000 Medicare Taxes 7,599.00 7,599.00 560.09 866.88 11.408 6,732.12 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 1,449.00 135-50045-030-000 Workman's Compensation 1,554.00 1,554.00 147.89 295.78 19.033 1,258.22 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 219.05 966.11 19.322 4,033.89 Subtotal: 662,006.00 662,006.00 54,068.31 84,715.15 12.797 577,290.85 135-55030-030-000 Software & Support 78,483.00 78,483.00 1,640.26 4,454.16 5.675 74,028.84 135-55070-030-000 Independent Labor 12,000.00 12,000.00 595.00 4.958 11,405.00 135-55080-030-000 Maintenance & Repairs 29,500.00 29,500.00 3,343.00 4,723.50 16.012 24,776.50 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 280.89 736.78 10.525 6,263.22 135-55120-030-000 Cleaning Services 10,125.00 10,125.00 259.00- 325.75 3.217 9,799.25 135-55160-030-000 Professional Outside Services 61,075.00 61,075.00 51,075.00 83.627 10,000.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 592.10 1,246.60 15.202 6,953.40 Subtotal: 206,583.00 206,583.00 5,597.25 63,156.79 30.572 143,426.21 135-60005-030-000 Telephone 16,349.00 16,349.00 1,875.01 2,470.51 15.111 13,878.49 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 337.99 675.98 16.289 3,474.02 135-60020-030-000 Electricity/Gas 10,768.00 10,768.00 10,768.00 135-60025-030-000 Water 1,500.00 1,500.00 304.82 191.94 12.796 1,308.06 135-60035-030-000 Postage 28,932.00 28,932.00 1,775.98 4,307.52 14.888 24,624.48 135-60040-030-000 Service Charges & Fees 44,000.00 44,000.00 6,079.34 12,783.42 29.053 31,216.58 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 3,500.00 135-60055-030-000 Insurance 52,797.00 52,797.00 2,822.75 5,612.00 10.629 47,185.00 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 100.00 200.00 3.333 5,800.00 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 5,000.00 5,000.00 61.65 61.65 1.233 4,938.35 135-60080-030-000 Schools & Training 9,935.00 9,935.00 459.00 459.00 4.620 9,476.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 277.09 391.00 7.241 5,009.00 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 7,500.00 7,500.00 7,500.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 14:22 12/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2015 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 675.36 9.005 6,824.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 42.92 367.91 2.102 17,133.09 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 226,882.00 226,882.00 14,136.55 28,196.29 12.428 198,685.71 135-65010-030-000 Uniforms 1,855.00 1,855.00 1,855.00 135-65055-030-000 Hardware 29,594.00 29,594.00 29,594.00 135-65085-030-000 Office Supplies 9,000.00 9,000.00 452.61 452.61 5.029 8,547.39 135-65090-030-000 Printer Supplies & Maintenance 4,003.00 4,003.00 221.30 5.528 3,781.70 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 335.91 1,020.41 20.408 3,979.59 135-65105-030-000 Printing 4,800.00 4,800.00 4,800.00 Subtotal: 54,252.00 54,252.00 788.52 1,694.32 3.123 52,557.68 135-69005-030-000 Capital Outlays 56,000.00 56,000.00 56,000.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 369.84 526.78 11.452 4,073.22 Subtotal: 60,600.00 60,600.00 369.84 526.78 .869 60,073.22 Program number: 1,210,323.00 1,210,323.00 74,960.47 178,289.33 14.731 1,032,033.67 Department number: Administration 1,210,323.00 1,210,323.00 74,960.47 178,289.33 14.731 1,032,033.67 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 14:22 12/10/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/2015 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 92,546.50 93,230.00 24.145 292,900.00 135-55055-039-000 Auditing 22,750.00 22,750.00 5,000.00 21.978 17,750.00 135-55060-039-000 Appraisal 10,265.00 10,265.00 2,235.39 2,235.39 21.777 8,029.61 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 422,945.00 422,945.00 94,781.89 100,465.39 23.754 322,479.61 Program number: 422,945.00 422,945.00 94,781.89 100,465.39 23.754 322,479.61 Department number: Non Departmental 422,945.00 422,945.00 94,781.89 100,465.39 23.754 322,479.61 Expenditures Subtotal ----------- 8,047,784.00 8,047,784.00 690,797.65 1,051,929.84 13.071 6,995,854.16 Fund number: 135 MUD 1 General Fund 229,788.73 116,330.65- 116,330.65 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 14:22 12/10/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 11/2015 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 16 14:22 12/10/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 11/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 1.02- 2.77- 2.77 Subtotal: 1.02- 2.77- 2.77 Program number: 1.02- 2.77- 2.77 Department number: 1.02- 2.77- 2.77 Revenues Subtotal ----------- 1.02- 2.77- 2.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 14:22 12/10/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 11/2015 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 8,034.36- Subtotal: 8,034.36 8,034.36 8,034.36- Program number: 8,034.36 8,034.36 8,034.36- Department number: Wastewater 8,034.36 8,034.36 8,034.36- Expenditures Subtotal ----------- 8,034.36 8,034.36 8,034.36- Fund number: 507 MUD 1 Capital Projects 8,033.34 8,031.59 8,031.59- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2015 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 404 11/02/2015 Property Taxes (343.13) (65.89) (409.02) GL 405 11/03/2015 Property Taxes (228.18) (637.20) GL 406 11/04/2015 Property Taxes (74.88) (712.08) GL 407 11/05/2015 Property Taxes (130.69) (842.77) GL 408 11/06/2015 Property Taxes (34.49) (877.26) GL 409 11/09/2015 Property Taxes (195.00) (1,072.26) GL 410 11/10/2015 Property Taxes (218.38) (1,290.64) GL 411 11/12/2015 Property Taxes (38.61) (1,329.25) GL 412 11/13/2015 Property Taxes (225.17) (1,554.42) GL 413 11/16/2015 Property Taxes (84.70) (1,639.12) GL 414 11/17/2015 Property Taxes (113.77) (1,752.89) GL 415 11/18/2015 Property Taxes (25.68) (1,778.57) GL 416 11/19/2015 Property Taxes (104.60) (1,883.17) GL 417 11/20/2015 Property Taxes (114.18) (1,997.35) GL 418 11/23/2015 Property Taxes (116.19) (2,113.54) GL 419 11/24/2015 Property Taxes (900.27) (3,013.81) GL 420 11/25/2015 Property Taxes (33.22) (3,047.03) GL 421 11/30/2015 Property Taxes (251.90) (3,298.93) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (2,955.80) (3,298.93) ** (58,181.00) Budgeted (54,882.07) Remaining 6 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 404 11/02/2015 Property Taxes (29.76) 2.22 (27.54) GL 405 11/03/2015 Property Taxes (1.05) (28.59) GL 414 11/17/2015 Property Taxes (17.28) (45.87) GL 421 11/30/2015 Property Taxes (27.03) (72.90) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (43.14) (72.90) ** .00 Budgeted 72.90 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 404 11/02/2015 Property Taxes (10.92) (.32) (11.24) GL 405 11/03/2015 Property Taxes (.28) (11.52) GL 407 11/05/2015 Property Taxes (.07) (11.59) GL 410 11/10/2015 Property Taxes (.12) (11.71) GL 414 11/17/2015 Property Taxes (3.79) (15.50) GL 417 11/20/2015 Property Taxes (.02) (15.52) GL 421 11/30/2015 Property Taxes (5.89) (21.41) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (10.49) (21.41) ** (650.00) Budgeted (628.59) Remaining 3 % Used Account: 135-40025-000-000 PID Surcharges 355 11/09/2015 UB 11/9/15 Bill adj UB20151109-20151109 User: (12,371.00) 2.81 (12,368.19) UB 346 11/30/2015 UB 11/30/15 Billing UB20151130-20151130 User: (12,371.00) (24,739.19) UB _______________ Account: 135-40025-000-000 PID Surcharges Totals: (12,368.19) (24,739.19) ** (146,125.00) Budgeted (121,385.81) Remaining 17 % Used Account: 135-47000-000-000 Water 348 11/06/2015 UB 11/6/15 Billing adjustment UB20151106-20151106 User: (438,848.20) 116.97 (438,731.23) UB 355 11/09/2015 UB 11/9/15 Bill adj UB20151109-20151109 User: 14.66 (438,716.57) UB 357 11/10/2015 UB 11/10/15 Bill adjustment UB20151110-20151110 User: 12.99 (438,703.58) UB 346 11/30/2015 UB 11/30/15 Billing UB20151130-20151130 User: (239,329.41) (678,032.99) UB _______________ Account: 135-47000-000-000 Water Totals: (239,184.79) (678,032.99) ** (5,080,244.00) Budgeted (4,402,211.01) Remaining 13 % Used Account: 135-47005-000-000 Sewer 348 11/06/2015 UB 11/6/15 Billing adjustment UB20151106-20151106 User: (205,855.15) 65.69 (205,789.46) UB 355 11/09/2015 UB 11/9/15 Bill adj UB20151109-20151109 User: 12.01 (205,777.45) UB 357 11/10/2015 UB 11/10/15 Bill adjustment UB20151110-20151110 User: 15.35 (205,762.10) UB 346 11/30/2015 UB 11/30/15 Billing UB20151130-20151130 User: (153,860.98) (359,623.08) UB _______________ Account: 135-47005-000-000 Sewer Totals: (153,767.93) (359,623.08) ** (2,413,776.00) Budgeted (2,054,152.92) Remaining 15 % Used Account: 135-47025-000-000 Penalties 347 11/02/2015 UB 11/2/15 Penalty UB20151102-20151102 User: (12,568.02) 164.42 (12,403.60) UB 359 11/13/2015 UB 11/13/15 Penalty removals UB20151113-20151113 User: 116.74 (12,286.86) UB 361 11/17/2015 UB 11/17/15 Penalty removals UB20151117-20151117 User: 462.92 (11,823.94) UB 314 11/23/2015 UB 11/23/2015 Penalties UB20151123-20151123 User: (13,144.40) (24,968.34) UB 368 11/30/2015 UB 11/30/15 Penalty removals UB20151130-20151130 User: 287.90 (24,680.44) UB _______________ Account: 135-47025-000-000 Penalties Totals: (12,112.42) (24,680.44) ** (90,985.00) Budgeted (66,304.56) Remaining 27 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47030-000-000 Service Charges 347 11/02/2015 UB 11/2/15 Penalty UB20151102-20151102 User: (1,650.00) 25.00 (1,625.00) UB 221 11/05/2015 UB 11/5/15 Cut Off List Fees UB20151105-20151105 User: (1,400.00) (3,025.00) UB 349 11/05/2015 UB 11/5/15 NSF Check fee UB20151105-20151105 User: (25.00) (3,050.00) UB 353 11/09/2015 UB 11/9/15 NSF Check fees UB20151109-20151109 User: (50.00) (3,100.00) UB 364 11/16/2015 UB 11/16/15 NSF Check fee UB20151116-20151116 User: (25.00) (3,125.00) UB 369 11/19/2015 UB 11/19/15 NSF Check fees UB20151119-20151119 User: (25.00) (3,150.00) UB 366 11/20/2015 UB 11/20/15 Returned check fee UB20151120-20151120 User: (50.00) (3,200.00) UB 362 11/23/2015 UB 11/23/15 NSF Check fee UB20151123-20151123 User: (75.00) (3,275.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,625.00) (3,275.00) ** (9,000.00) Budgeted (5,725.00) Remaining 36 % Used Account: 135-47035-000-000 Plumbing Inspections 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (300.00) (350.00) (650.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (350.00) (650.00) ** (2,000.00) Budgeted (1,350.00) Remaining 33 % Used Account: 135-47045-000-000 Sewer Inspections 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (900.00) (900.00) (1,800.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (900.00) (1,800.00) ** (5,500.00) Budgeted (3,700.00) Remaining 33 % Used Account: 135-47070-000-000 TCCC Effluent Charges 346 11/30/2015 UB 11/30/15 Billing UB20151130-20151130 User: (5,954.20) (3.50) (5,957.70) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (3.50) (5,957.70) ** (61,330.00) Budgeted (55,372.30) Remaining 10 % Used Account: 135-48005-000-000 Utility Fees 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (20,700.00) (18,400.00) (39,100.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (18,400.00) (39,100.00) ** (69,000.00) Budgeted (29,900.00) Remaining 57 % Used Account: 135-49010-000-000 Interest Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 391 11/30/2015 Bank Interest/November (752.61) (11.12) (763.73) GL 391 11/30/2015 Bank Interest/November (176.88) (940.61) GL 391 11/30/2015 Bank Interest/November (320.43) (1,261.04) GL 391 11/30/2015 Bank Interest/November (231.10) (1,492.14) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (739.53) (1,492.14) ** (6,000.00) Budgeted (4,507.86) Remaining 25 % Used Account: 135-49016-000-000 Cell Tower Revenue 425 11/02/2015 AT&T Cell Tower Revenue (910.53) (910.53) (1,821.06) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (1,821.06) ** (10,926.00) Budgeted (9,104.94) Remaining 17 % Used Account: 135-49018-000-000 Building Rent Income 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (583.33) (583.33) (1,166.66) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,166.66) ** (7,000.00) Budgeted (5,833.34) Remaining 17 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (8,020.00) Budgeted (8,020.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (5,145.00) (8,923.80) (14,068.80) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (8,923.80) (14,068.80) ** (15,778.00) Budgeted (1,709.20) Remaining 89 % Used Account: 135-49141-000-000 Interfund Transfer In 454 11/30/2015 Close Cap Proj Fund 507 to GF (8,034.36) (8,034.36) GL _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: (8,034.36) (8,034.36) ** .00 Budgeted 8,034.36 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49900-000-000 Miscellaneous Income 358 11/12/2015 UB 11/12/15 ADjustmen UB20151112-20151112 User: (327.72) 38.01 (289.71) UB 372 11/19/2015 UB 11/19/15 adjustments UB20151119-20151119 User: (1.17) (290.88) UB 332 11/25/2015 Billed McClendon Inv 1374 AR 20151125-20151125 User: (114.00) (404.88) AR 346 11/30/2015 UB 11/30/15 Billing UB20151130-20151130 User: (18.95) (423.83) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (96.11) (423.83) ** (63,249.00) Budgeted (62,825.17) Remaining 1 % Used Account: 135-49901-000-000 Records Management Revenue (2.00) .00 (2.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (2.00) ** (20.00) Budgeted (18.00) Remaining 10 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,168,260.49) ** (8,047,784.00) Budgeted (6,879,523.51) Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2015 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 204 11/06/2015 MUD P/R 11/6/15 Salaries & Wages 10,071.91 8,523.41 18,595.32 PR 281 11/20/2015 MUD Payroll 11/20/15 Salaries & Wages 8,336.97 26,932.29 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 16,860.38 26,932.29 ** 265,614.00 Budgeted 238,681.71 Remaining 10 % Used Account: 135-50010-010-000 Overtime 204 11/06/2015 MUD P/R 11/6/15 Overtime 453.21 996.63 1,449.84 PR 281 11/20/2015 MUD Payroll 11/20/15 Overtime 551.09 2,000.93 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,547.72 2,000.93 ** 19,500.00 Budgeted 17,499.07 Remaining 10 % Used Account: 135-50016-010-000 Longevity 297 11/23/2015 Longevity 11/23/15 Longevity 2,945.00 2,945.00 PR _______________ Account: 135-50016-010-000 Longevity Totals: 2,945.00 2,945.00 ** 2,945.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 281 11/20/2015 MUD Payroll 11/20/15 Certification 175.00 175.00 350.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 350.00 ** 4,200.00 Budgeted 3,850.00 Remaining 8 % Used Account: 135-50020-010-000 Retirement 204 11/06/2015 MUD P/R 11/6/15 Retirement 953.38 848.23 1,801.61 PR 281 11/20/2015 MUD Payroll 11/20/15 Retirement 807.52 2,609.13 PR 297 11/23/2015 Longevity 11/23/15 Retirement 262.40 2,871.53 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,918.15 2,871.53 ** 25,558.00 Budgeted 22,686.47 Remaining 11 % Used Account: 135-50026-010-000 Medical Insurance 204 11/06/2015 MUD P/R 11/6/15 Medical Insurance 1,931.01 1,634.55 3,565.56 PR 281 11/20/2015 MUD Payroll 11/20/15 Medical Insurance 1,634.50 5,200.06 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,269.05 5,200.06 ** 51,398.00 Budgeted 46,197.94 Remaining 10 % Used Account: 135-50027-010-000 Dental Insurance 204 11/06/2015 MUD P/R 11/6/15 Dental Insurance 158.29 133.99 292.28 PR 281 11/20/2015 MUD Payroll 11/20/15 Dental Insurance 133.99 426.27 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 267.98 426.27 ** 3,999.00 Budgeted 3,572.73 Remaining 11 % Used Account: 135-50028-010-000 Vision Insurance 204 11/06/2015 MUD P/R 11/6/15 Vision Insurance 35.40 29.94 65.34 PR 281 11/20/2015 MUD Payroll 11/20/15 Vision Insurance 29.98 95.32 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 59.92 95.32 ** 910.00 Budgeted 814.68 Remaining 10 % Used Account: 135-50029-010-000 Life Insurance & Other 117 11/01/2015 November A/P Dental, vision, other insuranc 220.75 154.33 375.08 METLIFE GROUP BENEFITS 1120 AP 322 11/24/2015 November A/P Café 125 Admin Fees 8.44 383.52 BenefitMall 1222 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 162.77 383.52 ** 2,803.00 Budgeted 2,419.48 Remaining 14 % Used Account: 135-50030-010-000 Social Security Taxes 204 11/06/2015 MUD P/R 11/6/15 Social Security Taxes 659.18 577.32 1,236.50 PR 281 11/20/2015 MUD Payroll 11/20/15 Social Security Taxes 545.53 1,782.03 PR 297 11/23/2015 Longevity 11/23/15 Social Security Taxes 182.59 1,964.62 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,305.44 1,964.62 ** 18,565.00 Budgeted 16,600.38 Remaining 11 % Used Account: 135-50035-010-000 Medicare Taxes 204 11/06/2015 MUD P/R 11/6/15 Medicare Taxes 154.15 135.02 289.17 PR 281 11/20/2015 MUD Payroll 11/20/15 Medicare Taxes 127.58 416.75 PR 297 11/23/2015 Longevity 11/23/15 Medicare Taxes 42.70 459.45 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 305.30 459.45 ** 4,341.00 Budgeted 3,881.55 Remaining 11 % Used Account: 135-50040-010-000 Unemployment Taxes 281 11/20/2015 MUD Payroll 11/20/15 Unemployment Taxes .94 .94 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .94 .94 ** 1,242.00 Budgeted 1,241.06 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 133 11/01/2015 Prepaid Insurance, W/C Nov 1,229.33 1,229.35 2,458.68 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,229.35 2,458.68 ** 14,754.00 Budgeted 12,295.32 Remaining 17 % 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 .00 .00 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering 214 11/05/2015 Solana Waterline App 1 billed AR 20151105-20151105 User: (210,905.17) (210,905.17) AR 245 11/05/2015 Recode JE214/Solana Land bill 210,905.17 .00 GL _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 253 11/10/2015 Nov A/P Driveway repair 1103 Portland 11,186.57 3,156.75 14,343.32 REY-MAR CONSTRUCTION 1187 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 322 11/24/2015 November A/P Water Parts 11,186.57 1,678.20 16,021.52 HD SUPPLY WATERWORKS, LTD. 1224 AP 322 11/24/2015 November A/P Water parts 135.00 16,156.52 HD SUPPLY WATERWORKS, LTD. 1224 AP 322 11/24/2015 November A/P Water parts 632.70 16,789.22 HD SUPPLY WATERWORKS, LTD. 1224 AP 322 11/24/2015 November A/P Marker flags 65.00 16,854.22 HD SUPPLY WATERWORKS, LTD. 1224 AP 437 11/27/2015 PCards 10-27 to 11-27-015 KELLER OUTDOOR POWER I 52.95 16,907.17 KELLER OUTDOOR POWER I PC 437 11/27/2015 PCards 10-27 to 11-27-015 ROANOKE AUTO SUPPLY LT 1.12 16,908.29 ROANOKE AUTO SUPPLY LT PC 437 11/27/2015 PCards 10-27 to 11-27-015 THE HOME DEPOT 6581 142.17 17,050.46 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 5,863.89 17,050.46 ** 85,000.00 Budgeted 67,949.54 Remaining 20 % Used Account: 135-55090-010-000 Vehicle Maintenance 437 11/27/2015 PCards 10-27 to 11-27-015 KWIK KAR LUBE & TUNE O 885.24 25.50 910.74 KWIK KAR LUBE & TUNE O PC 437 11/27/2015 PCards 10-27 to 11-27-015 DISCOUNT TIRE TXD 75 774.00 1,684.74 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 799.50 1,684.74 ** 8,000.00 Budgeted 6,315.26 Remaining 21 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 432 11/30/2015 November A/P Lab analysis 330.00 207.70 537.70 LOWER COLORADO RIVER AUTHORITY 1265 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 207.70 537.70 ** 5,500.00 Budgeted 4,962.30 Remaining 10 % Used Account: 135-60010-010-000 Communications/Mobiles 300 11/20/2015 November A/P Cell phones 397.58 397.58 795.16 VERIZON WIRELESS 1218 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 397.58 795.16 ** 5,400.00 Budgeted 4,604.84 Remaining 15 % Used Account: 135-60020-010-000 Electricity 253 11/10/2015 Nov A/P Electricity 10/8-11/6/15 4,871.41 197.77 5,069.18 HUDSON ENERGY SERVICES, LLC 1184 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 253 11/10/2015 Nov A/P Electricity 10/9-11/9/15 4,871.41 56.72 5,125.90 HUDSON ENERGY SERVICES, LLC 1184 AP 300 11/20/2015 November A/P Electricity 10/9-11/9/15 14,277.67 19,403.57 HUDSON ENERGY SERVICES, LLC 1202 AP _______________ Account: 135-60020-010-000 Electricity Totals: 14,532.16 19,403.57 ** 166,823.00 Budgeted 147,419.43 Remaining 12 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 300 11/20/2015 November A/P CSI Test Application 351.00 111.00 462.00 TX COMMISSION ENVIRONMENTAL QU 1216 AP 322 11/24/2015 November A/P Driving records 18.00 480.00 TX DEPT OF PUBLIC SAFETY 1234 AP 325 11/24/2015 Recode TxDPS Check 1234 per JM (18.00) 462.00 GL 437 11/27/2015 PCards 10-27 to 11-27-015 TCEQ IND RENEWAL L 111.00 573.00 TCEQ IND RENEWAL L PC 437 11/27/2015 PCards 10-27 to 11-27-015 TCEQ IND RENEWAL L 111.00 684.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 333.00 684.00 ** 5,773.00 Budgeted 5,089.00 Remaining 12 % Used Account: 135-60090-010-000 Safety Program 325 11/24/2015 Recode TxDPS Check 1234 per JM 21.00 21.00 GL _______________ Account: 135-60090-010-000 Safety Program Totals: 21.00 21.00 ** 400.00 Budgeted 379.00 Remaining 5 % Used Account: 135-60100-010-000 Travel & per diem 14.25 .00 14.25 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 14.25 ** 1,400.00 Budgeted 1,385.75 Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 300 11/20/2015 November A/P Balance due - regulatory asses 23.40 23.40 TX COMMISSION ENVIRONMENTAL QU 1215 AP 300 11/20/2015 November A/P Water System Fee 0610018 FY16 6,480.10 6,503.50 TX COMMISSION ENVIRONMENTAL QU 1217 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 6,503.50 6,503.50 ** 49,275.00 Budgeted 42,771.50 Remaining 13 % Used Account: 135-60150-010-000 Wholesale Water 432 11/30/2015 November A/P October Wholesale Water 234,717.97 234,717.97 CITY OF FORT WORTH 1250 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 234,717.97 234,717.97 ** 2,948,742.00 Budgeted 2,714,024.03 Remaining 8 % 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 437 11/27/2015 PCards 10-27 to 11-27-015 TEX-TURF 303.41 35.78 339.19 TEX-TURF PC 437 11/27/2015 PCards 10-27 to 11-27-015 TEX ART STONE 69.30 408.49 TEX ART STONE PC 437 11/27/2015 PCards 10-27 to 11-27-015 DENTON SAND & GRAVEL, 162.00 570.49 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 267.08 570.49 ** 3,500.00 Budgeted 2,929.51 Remaining 16 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 351 11/30/2015 Nov A/P November fuel 1,216.64 652.64 1,869.28 US Bank Voyager Fleet Systems 1241 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 652.64 1,869.28 ** 35,947.00 Budgeted 34,077.72 Remaining 5 % Used Account: 135-65010-010-000 Uniforms 437 11/27/2015 PCards 10-27 to 11-27-015 RED WING SHOES #652 175.00 175.00 RED WING SHOES #652 PC 437 11/27/2015 PCards 10-27 to 11-27-015 RED WING SHOES #652 143.99 318.99 RED WING SHOES #652 PC 437 11/27/2015 PCards 10-27 to 11-27-015 RED WING SHOES #652 157.24 476.23 RED WING SHOES #652 PC 437 11/27/2015 PCards 10-27 to 11-27-015 RED WING SHOES #652 175.00 651.23 RED WING SHOES #652 PC _______________ Account: 135-65010-010-000 Uniforms Totals: 651.23 651.23 ** 4,608.00 Budgeted 3,956.77 Remaining 14 % Used Account: 135-65030-010-000 Chemicals 322 11/24/2015 November A/P Chlorine 1,337.95 317.83 1,655.78 DPC INDUSTRIES, INC 1223 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 317.83 1,655.78 ** 12,000.00 Budgeted 10,344.22 Remaining 14 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65050-010-000 Meter Expense 300 11/20/2015 November A/P Meters 12,685.00 38,580.00 51,265.00 ATLAS UTILITY SUPPLY CO. 1197 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 38,580.00 51,265.00 ** 115,000.00 Budgeted 63,735.00 Remaining 45 % Used Account: 135-65053-010-000 Meter Change Out Program .00 .00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used Account: 135-69005-010-000 Capital Outlays 294 11/01/2015 McClendon App #4 PB,PO, TL 43,248.85 577.70 43,826.55 GL 300 11/20/2015 November A/P Pay App #4 PB, PO, TL 5,199.30 49,025.85 MCCLENDON CONSTRUCTION CO INC 1206 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 5,777.00 49,025.85 ** 201,000.00 Budgeted 151,974.15 Remaining 24 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 130,720.00 Budgeted 130,720.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 1,209.00 Budgeted 1,209.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 253 11/10/2015 Nov A/P Ground Storage #2 West Annual 45,775.00 45,775.00 UTILITY SERVICE CO, INC. 1191 AP 253 11/10/2015 Nov A/P 400,000 Hydropillar King Road 35,211.69 80,986.69 UTILITY SERVICE CO, INC. 1191 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 80,986.69 80,986.69 ** 126,958.00 Budgeted 45,971.31 Remaining 64 % Used Account: 135-55135-010-001 Lab Analysis for PID 80.00 .00 80.00 _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 80.00 ** 5,000.00 Budgeted 4,920.00 Remaining 2 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 588,841.73 ** 4,475,834.00 Budgeted 3,886,992.27 Remaining 13 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2015 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 204 11/06/2015 MUD P/R 11/6/15 Salaries & Wages 14,720.22 12,478.38 27,198.60 PR 281 11/20/2015 MUD Payroll 11/20/15 Salaries & Wages 12,318.87 39,517.47 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 24,797.25 39,517.47 ** 351,671.00 Budgeted 312,153.53 Remaining 11 % Used Account: 135-50010-020-000 Overtime 204 11/06/2015 MUD P/R 11/6/15 Overtime 777.73 1,218.00 1,995.73 PR 281 11/20/2015 MUD Payroll 11/20/15 Overtime 701.16 2,696.89 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,919.16 2,696.89 ** 19,500.00 Budgeted 16,803.11 Remaining 14 % Used Account: 135-50016-020-000 Longevity 297 11/23/2015 Longevity 11/23/15 Longevity 6,125.00 6,125.00 PR _______________ Account: 135-50016-020-000 Longevity Totals: 6,125.00 6,125.00 ** 6,125.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 281 11/20/2015 MUD Payroll 11/20/15 Certification 550.00 550.00 1,100.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 550.00 1,100.00 ** 7,200.00 Budgeted 6,100.00 Remaining 15 % Used Account: 135-50020-020-000 Retirement 204 11/06/2015 MUD P/R 11/6/15 Retirement 1,429.86 1,220.35 2,650.21 PR 281 11/20/2015 MUD Payroll 11/20/15 Retirement 1,209.10 3,859.31 PR 297 11/23/2015 Longevity 11/23/15 Retirement 545.74 4,405.05 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,975.19 4,405.05 ** 33,652.00 Budgeted 29,246.95 Remaining 13 % Used Account: 135-50026-020-000 Medical Insurance 204 11/06/2015 MUD P/R 11/6/15 Medical Insurance 2,823.47 2,343.40 5,166.87 PR 281 11/20/2015 MUD Payroll 11/20/15 Medical Insurance 2,343.35 7,510.22 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,686.75 7,510.22 ** 65,989.00 Budgeted 58,478.78 Remaining 11 % Used Account: 135-50027-020-000 Dental Insurance 204 11/06/2015 MUD P/R 11/6/15 Dental Insurance 180.56 149.75 330.31 PR 281 11/20/2015 MUD Payroll 11/20/15 Dental Insurance 149.76 480.07 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 299.51 480.07 ** 4,184.00 Budgeted 3,703.93 Remaining 11 % Used Account: 135-50028-020-000 Vision Insurance 204 11/06/2015 MUD P/R 11/6/15 Vision Insurance 41.60 34.48 76.08 PR 281 11/20/2015 MUD Payroll 11/20/15 Vision Insurance 34.52 110.60 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 69.00 110.60 ** 972.00 Budgeted 861.40 Remaining 11 % Used Account: 135-50029-020-000 Life Insurance & Other 117 11/01/2015 November A/P Dental, vision, other insuranc 289.36 262.76 552.12 METLIFE GROUP BENEFITS 1120 AP 322 11/24/2015 November A/P Café 125 Admin Fees 33.78 585.90 BenefitMall 1222 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 296.54 585.90 ** 3,655.00 Budgeted 3,069.10 Remaining 16 % Used Account: 135-50030-020-000 Social Security Taxes 204 11/06/2015 MUD P/R 11/6/15 Social Security Taxes 909.85 775.46 1,685.31 PR 281 11/20/2015 MUD Payroll 11/20/15 Social Security Taxes 752.48 2,437.79 PR 297 11/23/2015 Longevity 11/23/15 Social Security Taxes 379.74 2,817.53 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,907.68 2,817.53 ** 24,665.00 Budgeted 21,847.47 Remaining 11 % Used Account: 135-50035-020-000 Medicare Taxes 204 11/06/2015 MUD P/R 11/6/15 Medicare Taxes 212.77 181.34 394.11 PR 281 11/20/2015 MUD Payroll 11/20/15 Medicare Taxes 175.98 570.09 PR 297 11/23/2015 Longevity 11/23/15 Medicare Taxes 88.82 658.91 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 446.14 658.91 ** 5,768.00 Budgeted 5,109.09 Remaining 11 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,449.00 Budgeted 1,449.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 133 11/01/2015 Prepaid Insurance, W/C Nov 776.44 776.43 1,552.87 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 776.43 1,552.87 ** 9,317.00 Budgeted 7,764.13 Remaining 17 % 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 .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 650.00 Budgeted 650.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor .00 .00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 253 11/10/2015 Nov A/P Effluent meters 7,249.61 355.00 7,604.61 DHS AUTOMATION, INC 1181 AP 253 11/10/2015 Nov A/P Gaskets 22.50 7,627.11 ATLAS UTILITY SUPPLY CO. 1178 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 322 11/24/2015 November A/P Install pump #2 7,249.61 621.00 8,248.11 NORTH TEXAS PUMP CO. 1228 AP 322 11/24/2015 November A/P LS#3 inspect pump 255.00 8,503.11 NORTH TEXAS PUMP CO. 1228 AP 437 11/27/2015 PCards 10-27 to 11-27-015 THE HOME DEPOT 6581 120.45 8,623.56 THE HOME DEPOT 6581 PC 437 11/27/2015 PCards 10-27 to 11-27-015 USA BLUE BOOK 220.80 8,844.36 USA BLUE BOOK PC 437 11/27/2015 PCards 10-27 to 11-27-015 MICHAELS KEYS 66.50 8,910.86 MICHAELS KEYS PC 437 11/27/2015 PCards 10-27 to 11-27-015 THE HOME DEPOT 587 20.57 8,931.43 THE HOME DEPOT 587 PC 437 11/27/2015 PCards 10-27 to 11-27-015 THE HOME DEPOT 6581 9.35 8,940.78 THE HOME DEPOT 6581 PC 437 11/27/2015 PCards 10-27 to 11-27-015 WW GRAINGER 2,656.80 11,597.58 WW GRAINGER PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 4,347.97 11,597.58 ** 72,600.00 Budgeted 61,002.42 Remaining 16 % Used Account: 135-55090-020-000 Vehicle Maintenance 437 11/27/2015 PCards 10-27 to 11-27-015 AUTOZONE #4206 44.72 101.16 145.88 AUTOZONE #4206 PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 101.16 145.88 ** 5,000.00 Budgeted 4,854.12 Remaining 3 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 322 11/24/2015 November A/P Sludge hauling 2,812.59 766.84 3,579.43 L.H. CHANEY MATERIALS, INC. 1227 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 766.84 3,579.43 ** 55,000.00 Budgeted 51,420.57 Remaining 7 % Used Account: 135-55135-020-000 Lab Analysis 216 11/04/2015 November A/P Lab analysis 1,934.00 176.00 2,110.00 OXIDOR LABORATORIES LLC 1169 AP 253 11/10/2015 Nov A/P Testing 246.00 2,356.00 OXIDOR LABORATORIES LLC 1186 AP 300 11/20/2015 November A/P Lab analysis 176.00 2,532.00 OXIDOR LABORATORIES LLC 1210 AP 300 11/20/2015 November A/P Lab analysis 246.00 2,778.00 OXIDOR LABORATORIES LLC 1210 AP 300 11/20/2015 November A/P Lab analysis 176.00 2,954.00 OXIDOR LABORATORIES LLC 1210 AP 432 11/30/2015 November A/P 8/24/15 Lab analysis 246.00 3,200.00 OXIDOR LABORATORIES LLC 1270 AP 432 11/30/2015 November A/P 8/25/15 Lab analysis 176.00 3,376.00 OXIDOR LABORATORIES LLC 1270 AP 432 11/30/2015 November A/P Lab analysis 246.00 3,622.00 OXIDOR LABORATORIES LLC 1270 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 432 11/30/2015 November A/P Lab analysis 1,934.00 176.00 3,798.00 OXIDOR LABORATORIES LLC 1270 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,864.00 3,798.00 ** 35,000.00 Budgeted 31,202.00 Remaining 11 % Used Account: 135-60010-020-000 Communications/Mobiles 300 11/20/2015 November A/P Cell phones 258.56 409.32 667.88 VERIZON WIRELESS 1218 AP 437 11/27/2015 PCards 10-27 to 11-27-015 PHONE TECH 75.76 743.64 PHONE TECH PC _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 485.08 743.64 ** 5,400.00 Budgeted 4,656.36 Remaining 14 % Used Account: 135-60020-020-000 Electricity 253 11/10/2015 Nov A/P Electricity 10/8-11/6/15 447.05 57.90 504.95 HUDSON ENERGY SERVICES, LLC 1184 AP 253 11/10/2015 Nov A/P Electricity 10/8-11/6/15 37.54 542.49 HUDSON ENERGY SERVICES, LLC 1184 AP 253 11/10/2015 Nov A/P Electricity 10/9-11/9/15 96.84 639.33 HUDSON ENERGY SERVICES, LLC 1184 AP 300 11/20/2015 November A/P Electricity 10/9-11/9/15 467.81 1,107.14 HUDSON ENERGY SERVICES, LLC 1202 AP 300 11/20/2015 November A/P Electricity 10/9-11/9/15 10,186.79 11,293.93 HUDSON ENERGY SERVICES, LLC 1202 AP 432 11/30/2015 November A/P Electricity 10/27-11/25/15 176.65 11,470.58 TRI COUNTY ELECTRIC 1280 AP 432 11/30/2015 November A/P Electricity 10/27-11/25/15 301.36 11,771.94 TRI COUNTY ELECTRIC 1280 AP 432 11/30/2015 November A/P Electricity 10/27-11/25/15 27.69 11,799.63 TRI COUNTY ELECTRIC 1280 AP 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (174.69) 11,624.94 AR _______________ Account: 135-60020-020-000 Electricity Totals: 11,177.89 11,624.94 ** 161,582.00 Budgeted 149,957.06 Remaining 7 % 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 .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 322 11/24/2015 November A/P Driving records 36.00 36.00 TX DEPT OF PUBLIC SAFETY 1234 AP 325 11/24/2015 Recode TxDPS Check 1234 per JM (36.00) .00 GL _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 3,771.00 Budgeted 3,771.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program 325 11/24/2015 Recode TxDPS Check 1234 per JM 39.00 39.00 GL _______________ Account: 135-60090-020-000 Safety Program Totals: 39.00 39.00 ** 550.00 Budgeted 511.00 Remaining 7 % Used Account: 135-60100-020-000 Travel & per diem .00 .00 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 9,439.28 .00 9,439.28 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 9,439.28 ** 37,150.00 Budgeted 27,710.72 Remaining 25 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 297.00 Budgeted 297.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2015 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-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 .00 .00 _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 .00 ** 119,706.00 Budgeted 119,706.00 Remaining 0 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S .00 .00 _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 .00 ** 444,831.00 Budgeted 444,831.00 Remaining 0 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 207 11/03/2015 TXP Trans to Rev Bond Reserve 30,834.00 30,834.00 61,668.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 30,834.00 61,668.00 ** 123,336.00 Budgeted 61,668.00 Remaining 50 % Used Account: 135-65005-020-000 Fuel & Lube 351 11/30/2015 Nov A/P November fuel 667.71 685.67 1,353.38 US Bank Voyager Fleet Systems 1241 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 685.67 1,353.38 ** 32,021.00 Budgeted 30,667.62 Remaining 4 % Used Account: 135-65010-020-000 Uniforms 437 11/27/2015 PCards 10-27 to 11-27-015 RED WING SHOES #652 1,097.02 157.24 1,254.26 RED WING SHOES #652 PC 437 11/27/2015 PCards 10-27 to 11-27-015 PANDA EMBROIDERY 627.50 1,881.76 PANDA EMBROIDERY PC _______________ Account: 135-65010-020-000 Uniforms Totals: 784.74 1,881.76 ** 4,241.00 Budgeted 2,359.24 Remaining 44 % Used Account: 135-65030-020-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 437 11/27/2015 PCards 10-27 to 11-27-015 AQUAFIX INC. 2,944.49 1,144.32 4,088.81 AQUAFIX INC. PC 437 11/27/2015 PCards 10-27 to 11-27-015 AQUAFIX INC. 696.88 4,785.69 AQUAFIX INC. PC 437 11/27/2015 PCards 10-27 to 11-27-015 AQUAFIX INC. 1,370.68 6,156.37 AQUAFIX INC. PC _______________ Account: 135-65030-020-000 Chemicals Totals: 3,211.88 6,156.37 ** 27,000.00 Budgeted 20,843.63 Remaining 23 % Used Account: 135-65035-020-000 Small Tools .00 .00 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment 437 11/27/2015 PCards 10-27 to 11-27-015 JIM HENRY ENTERPRISES 87.91 87.91 JIM HENRY ENTERPRISES PC 437 11/27/2015 PCards 10-27 to 11-27-015 THE HOME DEPOT 6581 43.92 131.83 THE HOME DEPOT 6581 PC 437 11/27/2015 PCards 10-27 to 11-27-015 WW GRAINGER 282.76 414.59 WW GRAINGER PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 414.59 414.59 ** 750.00 Budgeted 335.41 Remaining 55 % Used Account: 135-65045-020-000 Lab Supplies 432 11/30/2015 November A/P Bottles for e.coli 2,662.21 278.96 2,941.17 IDEXX DISTRIBUTION, INC 1259 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 278.96 2,941.17 ** 13,000.00 Budgeted 10,058.83 Remaining 23 % Used Account: 135-69005-020-000 Capital Outlays .00 .00 _______________ Account: 135-69005-020-000 Capital Outlays Totals: .00 .00 ** 150,000.00 Budgeted 150,000.00 Remaining 0 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 21,280.00 Budgeted 21,280.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 197.00 Budgeted 197.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 183,181.98 ** 1,912,109.00 Budgeted 1,728,927.02 Remaining 10 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-021-000 Electricity 466 11/30/2015 A/R Adjustment AR 20151130-20151130 User: .01 .01 AR _______________ Account: 135-60020-021-000 Electricity Totals: .01 .01 ** .00 Budgeted (.01) Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ .01 ** .00 Budgeted (.01) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2015 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 500.00 .00 500.00 _______________ Account: 135-50005-026-000 Salaries & Wages Totals: .00 500.00 ** 12,500.00 Budgeted 12,000.00 Remaining 4 % Used Account: 135-50030-026-000 Social Security Taxes 31.00 .00 31.00 _______________ Account: 135-50030-026-000 Social Security Taxes Totals: .00 31.00 ** 775.00 Budgeted 744.00 Remaining 4 % Used Account: 135-50035-026-000 Medicare Taxes 7.25 .00 7.25 _______________ Account: 135-50035-026-000 Medicare Taxes Totals: .00 7.25 ** 181.00 Budgeted 173.75 Remaining 4 % Used Account: 135-50040-026-000 Unemployment Taxes .50 .00 .50 _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .00 .50 ** 230.00 Budgeted 229.50 Remaining 0 % Used Account: 135-50045-026-000 Workman's Compensation 133 11/01/2015 Prepaid Insurance, W/C Nov 3.09 3.08 6.17 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 3.08 6.17 ** 37.00 Budgeted 30.83 Remaining 17 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2015 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-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings 437 11/27/2015 PCards 10-27 to 11-27-015 WAL-MART #5247 6.00 6.00 WAL-MART #5247 PC _______________ Account: 135-60075-026-000 Meetings Totals: 6.00 6.00 ** 1,200.00 Budgeted 1,194.00 Remaining 1 % Used Account: 135-60080-026-000 Schools & Training 205 11/03/2015 November A/P Mid-winter Conference - Carr 275.00 275.00 AWBD 1167 AP 205 11/03/2015 November A/P Mid-winter Conference - Twomey 275.00 550.00 AWBD 1167 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 550.00 550.00 ** 4,000.00 Budgeted 3,450.00 Remaining 14 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses 50.48 .00 50.48 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 50.48 ** 2,000.00 Budgeted 1,949.52 Remaining 3 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 1,151.40 ** 26,573.00 Budgeted 25,421.60 Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2015 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 204 11/06/2015 MUD P/R 11/6/15 Salaries & Wages 22,354.17 18,625.44 40,979.61 PR 281 11/20/2015 MUD Payroll 11/20/15 Salaries & Wages 18,617.65 59,597.26 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 37,243.09 59,597.26 ** 488,508.00 Budgeted 428,910.74 Remaining 12 % Used Account: 135-50010-030-000 Overtime 204 11/06/2015 MUD P/R 11/6/15 Overtime 33.64 9.95 43.59 PR 281 11/20/2015 MUD Payroll 11/20/15 Overtime 3.99 47.58 PR _______________ Account: 135-50010-030-000 Overtime Totals: 13.94 47.58 ** 1,000.00 Budgeted 952.42 Remaining 5 % Used Account: 135-50016-030-000 Longevity 297 11/23/2015 Longevity 11/23/15 Longevity 3,822.50 3,822.50 PR _______________ Account: 135-50016-030-000 Longevity Totals: 3,822.50 3,822.50 ** 3,823.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 204 11/06/2015 MUD P/R 11/6/15 Retirement 1,994.79 1,660.41 3,655.20 PR 281 11/20/2015 MUD Payroll 11/20/15 Retirement 1,659.19 5,314.39 PR 297 11/23/2015 Longevity 11/23/15 Retirement 340.57 5,654.96 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,660.17 5,654.96 ** 43,202.00 Budgeted 37,547.04 Remaining 13 % Used Account: 135-50026-030-000 Medical Insurance 204 11/06/2015 MUD P/R 11/6/15 Medical Insurance 3,111.01 2,583.19 5,694.20 PR 281 11/20/2015 MUD Payroll 11/20/15 Medical Insurance 2,583.14 8,277.34 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,166.33 8,277.34 ** 68,196.00 Budgeted 59,918.66 Remaining 12 % Used Account: 135-50027-030-000 Dental Insurance 204 11/06/2015 MUD P/R 11/6/15 Dental Insurance 219.35 182.11 401.46 PR 281 11/20/2015 MUD Payroll 11/20/15 Dental Insurance 182.13 583.59 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2015 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: 364.24 583.59 ** 4,807.00 Budgeted 4,223.41 Remaining 12 % Used Account: 135-50028-030-000 Vision Insurance 204 11/06/2015 MUD P/R 11/6/15 Vision Insurance 50.87 42.16 93.03 PR 281 11/20/2015 MUD Payroll 11/20/15 Vision Insurance 42.22 135.25 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 84.38 135.25 ** 1,114.00 Budgeted 978.75 Remaining 12 % Used Account: 135-50029-030-000 Life Insurance & Other 117 11/01/2015 November A/P Dental, vision, other insuranc 369.42 354.48 723.90 METLIFE GROUP BENEFITS 1120 AP 322 11/24/2015 November A/P Café 125 Admin Fees 37.78 761.68 BenefitMall 1222 AP 456 11/30/2015 Clear Ins Liab due to rounding (.44) 761.24 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 391.82 761.24 ** 4,431.00 Budgeted 3,669.76 Remaining 17 % Used Account: 135-50030-030-000 Social Security Taxes 204 11/06/2015 MUD P/R 11/6/15 Social Security Taxes 1,311.85 1,084.72 2,396.57 PR 281 11/20/2015 MUD Payroll 11/20/15 Social Security Taxes 1,073.10 3,469.67 PR 297 11/23/2015 Longevity 11/23/15 Social Security Taxes 236.99 3,706.66 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,394.81 3,706.66 ** 30,823.00 Budgeted 27,116.34 Remaining 12 % Used Account: 135-50035-030-000 Medicare Taxes 204 11/06/2015 MUD P/R 11/6/15 Medicare Taxes 306.79 253.69 560.48 PR 281 11/20/2015 MUD Payroll 11/20/15 Medicare Taxes 250.97 811.45 PR 297 11/23/2015 Longevity 11/23/15 Medicare Taxes 55.43 866.88 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 560.09 866.88 ** 7,599.00 Budgeted 6,732.12 Remaining 11 % Used Account: 135-50040-030-000 Unemployment Taxes .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 .00 ** 1,449.00 Budgeted 1,449.00 Remaining 0 % Used Account: 135-50045-030-000 Workman's Compensation 133 11/01/2015 Prepaid Insurance, W/C Nov 147.89 147.89 295.78 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 147.89 295.78 ** 1,554.00 Budgeted 1,258.22 Remaining 19 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 426 11/05/2015 Employee family flu shot 747.06 (15.00) 732.06 GL 437 11/27/2015 PCards 10-27 to 11-27-015 RANDALLS STORE00017897 62.79 794.85 RANDALLS STORE00017897 PC 437 11/27/2015 PCards 10-27 to 11-27-015 WAL-MART #0266 11.51 806.36 WAL-MART #0266 PC 437 11/27/2015 PCards 10-27 to 11-27-015 DOVE CREEK CAFE 159.75 966.11 DOVE CREEK CAFE PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 219.05 966.11 ** 5,000.00 Budgeted 4,033.89 Remaining 19 % Used Account: 135-55030-030-000 Software & Support 300 11/20/2015 November A/P Internet 12/1-12/31/15 2,813.90 1,163.56 3,977.46 WHOLESALE CARRIER SERVICES INC 1221 AP 437 11/27/2015 PCards 10-27 to 11-27-015 ATT*BILL PAYMENT 176.04 4,153.50 ATT*BILL PAYMENT PC 437 11/27/2015 PCards 10-27 to 11-27-015 ATT*BILL PAYMENT 101.97 4,255.47 ATT*BILL PAYMENT PC 437 11/27/2015 PCards 10-27 to 11-27-015 ATT*BILL PAYMENT 90.20 4,345.67 ATT*BILL PAYMENT PC 437 11/27/2015 PCards 10-27 to 11-27-015 ATT*BILL PAYMENT 108.49 4,454.16 ATT*BILL PAYMENT PC _______________ Account: 135-55030-030-000 Software & Support Totals: 1,640.26 4,454.16 ** 78,483.00 Budgeted 74,028.84 Remaining 6 % Used Account: 135-55070-030-000 Independent Labor 595.00 .00 595.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 595.00 ** 12,000.00 Budgeted 11,405.00 Remaining 5 % Used Account: 135-55080-030-000 Maintenance & Repairs 322 11/24/2015 November A/P Repair sofet on admin bldg 1,380.50 340.00 1,720.50 TK CONTRACTORS LLC 1232 AP 351 11/30/2015 Nov A/P Stone Edging Install 1,713.00 3,433.50 WATTS ELLISON LLC 1242 AP 351 11/30/2015 Nov A/P November mowing 1,290.00 4,723.50 WATTS ELLISON LLC 1242 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 3,343.00 4,723.50 ** 29,500.00 Budgeted 24,776.50 Remaining 16 % Used Account: 135-55100-030-000 Building Maint & Supplies 300 11/20/2015 November A/P Thermostat repair 455.89 150.00 605.89 BRANDON R REED 1199 AP 452 11/30/2015 November A/P Rug cleaning 130.89 736.78 G & K SERVICES AP 452 11/30/2015 November A/P Rug cleaning 130.89 867.67 G & K SERVICES AP 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (130.89) 736.78 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 280.89 736.78 ** 7,000.00 Budgeted 6,263.22 Remaining 11 % Used Account: 135-55120-030-000 Cleaning Services 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: 584.75 (259.00) 325.75 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: (259.00) 325.75 ** 10,125.00 Budgeted 9,799.25 Remaining 3 % Used Account: 135-55160-030-000 Professional Outside Services 51,075.00 .00 51,075.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 51,075.00 ** 61,075.00 Budgeted 10,000.00 Remaining 84 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2015 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 452 11/30/2015 November A/P Utility Billing November 654.50 592.10 1,246.60 DATAPROSE LLC AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 592.10 1,246.60 ** 8,200.00 Budgeted 6,953.40 Remaining 15 % Used Account: 135-60005-030-000 Telephone 216 11/04/2015 November A/P Answering service 11/16-12/13/ 595.50 199.30 794.80 KEYSTONE PARK SECRETARIAL 1168 AP 437 11/27/2015 PCards 10-27 to 11-27-015 ATT*BUS PHONE PMT 440.46 1,235.26 ATT*BUS PHONE PMT PC 437 11/27/2015 PCards 10-27 to 11-27-015 ATT*BUS PHONE PMT 833.15 2,068.41 ATT*BUS PHONE PMT PC 437 11/27/2015 PCards 10-27 to 11-27-015 ATT*BUS PHONE PMT 828.44 2,896.85 ATT*BUS PHONE PMT PC 437 11/27/2015 PCards 10-27 to 11-27-015 ATT*BUS PHONE PMT 468.56 3,365.41 ATT*BUS PHONE PMT PC 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (894.90) 2,470.51 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,875.01 2,470.51 ** 16,349.00 Budgeted 13,878.49 Remaining 15 % Used Account: 135-60010-030-000 Communications/Mobiles 281 11/20/2015 MUD Payroll 11/20/15 Communications/Mobiles 337.99 300.00 637.99 PR 300 11/20/2015 November A/P Cell phones 37.99 675.98 VERIZON WIRELESS 1218 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 337.99 675.98 ** 4,150.00 Budgeted 3,474.02 Remaining 16 % Used Account: 135-60020-030-000 Electricity/Gas .00 .00 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 .00 ** 10,768.00 Budgeted 10,768.00 Remaining 0 % Used Account: 135-60025-030-000 Water 322 11/24/2015 November A/P Water bills October (112.88) 225.76 112.88 TROPHY CLUB MUD (WATER BILLS) 1233 AP 432 11/30/2015 November A/P November Water Bills 158.12 271.00 TROPHY CLUB MUD (WATER BILLS) 1281 AP 470 11/30/2015 Bill Town Inv 1376-1386 AR 20151130-20151130 User: (79.06) 191.94 AR _______________ Account: 135-60025-030-000 Water Totals: 304.82 191.94 ** 1,500.00 Budgeted 1,308.06 Remaining 13 % Used Account: 135-60035-030-000 Postage . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 452 11/30/2015 November A/P Utility Billing November 2,531.54 1,775.98 4,307.52 DATAPROSE LLC AP _______________ Account: 135-60035-030-000 Postage Totals: 1,775.98 4,307.52 ** 28,932.00 Budgeted 24,624.48 Remaining 15 % Used Account: 135-60040-030-000 Service Charges & Fees 436 11/03/2015 Credit card fees 6,704.08 5,881.29 12,585.37 GL 436 11/03/2015 Credit card fees 118.45 12,703.82 GL 206 11/06/2015 ExpertPay payment fee 11/6/15 1.50 12,705.32 GL 291 11/13/2015 Bank Analysis Fee- October 76.60 12,781.92 GL 430 11/20/2015 Expertpay Payment fee 11/20/15 1.50 12,783.42 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 6,079.34 12,783.42 ** 44,000.00 Budgeted 31,216.58 Remaining 29 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 133 11/01/2015 Prepaid Insurance, W/C Nov 2,789.25 2,756.00 5,545.25 GL 222 11/04/2015 Void AP Ch#1135 bond cancelled Notary Bond - Slaght (33.25) 5,512.00 CNA SURETY 1135 AP 253 11/10/2015 Nov A/P Notary/Schultz 50.00 5,562.00 VICTOR O SCHINNERER & CO, INC 1192 AP 300 11/20/2015 November A/P Notary - Laurie Slaght 50.00 5,612.00 VICTOR O SCHINNERER & CO, INC 1219 AP _______________ Account: 135-60055-030-000 Insurance Totals: 2,822.75 5,612.00 ** 52,797.00 Budgeted 47,185.00 Remaining 11 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 300 11/20/2015 November A/P Annual membership NCTCOG 10/15 100.00 100.00 200.00 N CENTRAL TX COG 1207 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2015 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: 100.00 200.00 ** 6,000.00 Budgeted 5,800.00 Remaining 3 % Used Account: 135-60075-030-000 Meetings .00 .00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60079-030-000 Public Education 437 11/27/2015 PCards 10-27 to 11-27-015 AMAZON.COM 61.65 61.65 AMAZON.COM PC _______________ Account: 135-60079-030-000 Public Education Totals: 61.65 61.65 ** 5,000.00 Budgeted 4,938.35 Remaining 1 % Used Account: 135-60080-030-000 Schools & Training 322 11/24/2015 November A/P Driving records 6.00 6.00 TX DEPT OF PUBLIC SAFETY 1234 AP 325 11/24/2015 Recode TxDPS Check 1234 per JM (6.00) .00 GL 437 11/27/2015 PCards 10-27 to 11-27-015 SEQUOIA CPE 149.00 149.00 SEQUOIA CPE PC 437 11/27/2015 PCards 10-27 to 11-27-015 TEXAS SECRETARY OF STA 310.00 459.00 TEXAS SECRETARY OF STA PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 459.00 459.00 ** 9,935.00 Budgeted 9,476.00 Remaining 5 % Used Account: 135-60100-030-000 Travel & per diem 204 11/06/2015 MUD P/R 11/6/15 Travel & per diem 113.91 11.50 125.41 PR 300 11/20/2015 November A/P TCEQ Conference 265.59 391.00 JENNIFER MCKNIGHT 1205 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 277.09 391.00 ** 5,400.00 Budgeted 5,009.00 Remaining 7 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2015 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 .00 .00 _______________ Account: 135-60115-030-000 Elections Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 675.36 .00 675.36 _______________ Account: 135-60125-030-000 Advertising Totals: .00 675.36 ** 7,500.00 Budgeted 6,824.64 Remaining 9 % 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 437 11/27/2015 PCards 10-27 to 11-27-015 JUSTINFAMILYPHARMACY 324.99 12.93 337.92 JUSTINFAMILYPHARMACY PC 437 11/27/2015 PCards 10-27 to 11-27-015 JUSTIN FAMILY MEDICAL 20.00 357.92 JUSTIN FAMILY MEDICAL PC 437 11/27/2015 PCards 10-27 to 11-27-015 RINGCENTRAL, INC 9.99 367.91 RINGCENTRAL, INC PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 42.92 367.91 ** 17,501.00 Budgeted 17,133.09 Remaining 2 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniforms .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 1,855.00 Budgeted 1,855.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65055-030-000 Hardware .00 .00 _______________ Account: 135-65055-030-000 Hardware Totals: .00 .00 ** 29,594.00 Budgeted 29,594.00 Remaining 0 % Used Account: 135-65085-030-000 Office Supplies 300 11/20/2015 November A/P Office Supplies 8.40 8.40 OFFICE DEPOT, INC 1209 AP 300 11/20/2015 November A/P Office supplies 71.04 79.44 OFFICE DEPOT, INC 1209 AP 351 11/30/2015 Nov A/P Office Supplies 53.51 132.95 OFFICE DEPOT, INC 1239 AP 351 11/30/2015 Nov A/P Office Supplies 199.95 332.90 OFFICE DEPOT, INC 1239 AP 351 11/30/2015 Nov A/P Office Supplies 20.19 353.09 OFFICE DEPOT, INC 1239 AP 351 11/30/2015 Nov A/P Office Supplies 99.52 452.61 OFFICE DEPOT, INC 1239 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 452.61 452.61 ** 9,000.00 Budgeted 8,547.39 Remaining 5 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 221.30 .00 221.30 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 221.30 ** 4,003.00 Budgeted 3,781.70 Remaining 6 % Used Account: 135-65095-030-000 Maintenance Supplies 437 11/27/2015 PCards 10-27 to 11-27-015 AMAZON MKTPLACE PMTS 684.50 27.48 711.98 AMAZON MKTPLACE PMTS PC 437 11/27/2015 PCards 10-27 to 11-27-015 AMAZON MKTPLACE PMTS 140.00 851.98 AMAZON MKTPLACE PMTS PC 437 11/27/2015 PCards 10-27 to 11-27-015 SAMSCLUB #4795 171.32 1,023.30 SAMSCLUB #4795 PC 437 11/27/2015 PCards 10-27 to 11-27-015 AMAZON MKTPLACE PMTS (2.89) 1,020.41 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 335.91 1,020.41 ** 5,000.00 Budgeted 3,979.59 Remaining 20 % Used Account: 135-65105-030-000 Printing .00 .00 _______________ Account: 135-65105-030-000 Printing Totals: .00 .00 ** 4,800.00 Budgeted 4,800.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2015 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-69005-030-000 Capital Outlays Totals: .00 .00 ** 56,000.00 Budgeted 56,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 300 11/20/2015 November A/P Copier lease 156.94 240.00 396.94 EVERBANK COMMERCIAL FINANCE 1201 AP 322 11/24/2015 November A/P Copier Maintenance 129.84 526.78 KYOCERA DOCUMENT SOLUTIONS 1226 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 369.84 526.78 ** 4,600.00 Budgeted 4,073.22 Remaining 11 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 178,289.33 ** 1,210,323.00 Budgeted 1,032,033.67 Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/2015 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 282 11/17/2015 Nov A/P Legal 683.50 80,000.00 80,683.50 THE LISTON LAW FIRM, P.C. 1195 AP 300 11/20/2015 November A/P WWTP Site Plan Legal Services 1,140.00 81,823.50 THE LISTON LAW FIRM, P.C. 1213 AP 300 11/20/2015 November A/P FW Waterline Legal Services Oc 120.00 81,943.50 THE LISTON LAW FIRM, P.C. 1213 AP 300 11/20/2015 November A/P General Legal Services October 2,640.00 84,583.50 THE LISTON LAW FIRM, P.C. 1213 AP 300 11/20/2015 November A/P PUC Rate Challenge - Legal Ser 1,620.75 86,204.25 THE LISTON LAW FIRM, P.C. 1213 AP 300 11/20/2015 November A/P Legal services October 252.50 86,456.75 Norton Rose Fulbright US LLP 1208 AP 300 11/20/2015 November A/P Legal services - October 599.00 87,055.75 WHITAKER CHALK SWINDLE 1220 AP 328 11/25/2015 Nov A/P WWTP-WCP Contract 1,806.00 88,861.75 THE LISTON LAW FIRM, P.C. 1235 AP 451 11/30/2015 Nov A/P Nov Legal 3,435.75 92,297.50 THE LISTON LAW FIRM, P.C. AP 451 11/30/2015 Nov A/P Nov Legal 270.00 92,567.50 THE LISTON LAW FIRM, P.C. AP 451 11/30/2015 Nov A/P Legal 482.50 93,050.00 THE LISTON LAW FIRM, P.C. AP 451 11/30/2015 Nov A/P Nov Legal 90.00 93,140.00 THE LISTON LAW FIRM, P.C. AP 451 11/30/2015 Nov A/P Nov Legal 90.00 93,230.00 THE LISTON LAW FIRM, P.C. AP _______________ Account: 135-55045-039-000 Legal Totals: 92,546.50 93,230.00 ** 386,130.00 Budgeted 292,900.00 Remaining 24 % Used Account: 135-55055-039-000 Auditing 5,000.00 .00 5,000.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 5,000.00 ** 22,750.00 Budgeted 17,750.00 Remaining 22 % Used Account: 135-55060-039-000 Appraisal 300 11/20/2015 November A/P Annual fee 2,235.39 2,235.39 TARRANT APPRAISAL DISTRICT 1211 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,235.39 2,235.39 ** 10,265.00 Budgeted 8,029.61 Remaining 22 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 3,800.00 Budgeted 3,800.00 Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 100,465.39 ** 422,945.00 Budgeted 322,479.61 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (116,330.65) .00 Budgeted 116,330.65 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 11/2015 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 52 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 11/2015 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 391 11/30/2015 Bank Interest/November (1.75) (1.02) (2.77) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (1.02) (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 53 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 11/2015 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) 454 11/30/2015 Close Cap Proj Fund 507 to GF 8,034.36 8,034.36 GL _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: 8,034.36 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 NOVEMBER 2015 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,379,320 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,379,320 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,378,563 NET REVENUES / EXPENDITURES 757 TOTAL FUND BALANCE 4,379,320 TOTAL LIABILITIES AND FUND BALANCE 4,379,320 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 14:22 12/10/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 11/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 397.56- 756.81- 756.81 Subtotal: 397.56- 756.81- 756.81 Program number: 397.56- 756.81- 756.81 Department number: Revenues 397.56- 756.81- 756.81 Revenues Subtotal ----------- 397.56- 756.81- 756.81 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 397.56- 756.81- 756.81 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 11/2015 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 391 11/30/2015 Bank Interest/November (359.25) (397.56) (756.81) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (397.56) (756.81) ** .00 Budgeted 756.81 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (756.81) ** .00 Budgeted 756.81 Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (756.81) .00 Budgeted 756.81 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET NOVEMBER 2015 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 8,473,300 ACCOUNTS RECEIVABLE - TOTAL ASSETS 8,473,300 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 180,782 TOTAL LIABILITIES 180,782 FUND BALANCE ASSIGNED FUND BALANCE 8,334,104 NET REVENUES / EXPENDITURES (41,586) TOTAL FUND BALANCE 8,292,518 TOTAL LIABILITIES AND FUND BALANCE 8,473,300 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 14:22 12/10/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 11/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 770.56- 1,470.82- 1,470.82 Subtotal: 770.56- 1,470.82- 1,470.82 Program number: 770.56- 1,470.82- 1,470.82 Department number: Revenues 770.56- 1,470.82- 1,470.82 Revenues Subtotal ----------- 770.56- 1,470.82- 1,470.82 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 14:22 12/10/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 11/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 43,056.95 43,056.95 43,056.95- Subtotal: 43,056.95 43,056.95 43,056.95- Program number: 43,056.95 43,056.95 43,056.95- Department number: Wastewater 43,056.95 43,056.95 43,056.95- Expenditures Subtotal ----------- 43,056.95 43,056.95 43,056.95- Fund number: 518 2015 Revenue Bond Const Fund 42,286.39 41,586.13 41,586.13- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 11/2015 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 391 11/30/2015 Bank Interest/November (700.26) (770.56) (1,470.82) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (770.56) (1,470.82) ** .00 Budgeted 1,470.82 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,470.82) ** .00 Budgeted 1,470.82 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 11/2015 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 300 11/20/2015 November A/P WWTP Town Permitting 34,351.95 34,351.95 THE WALLACE GROUP, INC. 1214 AP 300 11/20/2015 November A/P WWTP Plat 8,705.00 43,056.95 THE WALLACE GROUP, INC. 1214 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 43,056.95 43,056.95 ** .00 Budgeted (43,056.95) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 43,056.95 ** .00 Budgeted (43,056.95) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ 41,586.13 .00 Budgeted (41,586.13) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET NOVEMBER 2015 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 133,650 ACCOUNTS RECEIVABLE - TOTAL ASSETS 133,650 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 71,962 NET REVENUES / EXPENDITURES 61,688 TOTAL FUND BALANCE 133,650 TOTAL LIABILITIES AND FUND BALANCE 133,650 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 14:22 12/10/15 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 11/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 11.95- 20.02- 20.02 528-49141-000-000 Interfund Transfer In-Gen Fund 123,336.00- 123,336.00- 30,834.00- 61,668.00- 50.000 61,668.00- Subtotal: 123,336.00- 123,336.00- 30,845.95- 61,688.02- 50.016 61,647.98- Program number: 123,336.00- 123,336.00- 30,845.95- 61,688.02- 50.016 61,647.98- Department number: 123,336.00- 123,336.00- 30,845.95- 61,688.02- 50.016 61,647.98- Revenues Subtotal ----------- 123,336.00- 123,336.00- 30,845.95- 61,688.02- 50.016 61,647.98- Fund number: 528 2015 Revenue Bond Reserve Fund 123,336.00- 123,336.00- 30,845.95- 61,688.02- 50.016 61,647.98- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 57 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 11/2015 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 391 11/30/2015 Bank Interest/November (8.07) (11.95) (20.02) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (11.95) (20.02) ** .00 Budgeted 20.02 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund 207 11/03/2015 TXP Trans to Rev Bond Reserve (30,834.00) (30,834.00) (61,668.00) GL _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: (30,834.00) (61,668.00) ** (123,336.00) Budgeted (61,668.00) Remaining 50 % Used Department Totals: ------------------------------------------------------------------------------------------------ (61,688.02) ** (123,336.00) Budgeted (61,647.98) Remaining 50 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (61,688.02) (123,336.00) Budgeted (61,647.98) Remaining 50 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET NOVEMBER 2015 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 57,468 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 640,179 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 702,494 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 640,179 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 640,179 FUND BALANCE ASSIGNED FUND BALANCE 24,173 NET REVENUES / EXPENDITURES 38,142 TOTAL FUND BALANCE 62,315 TOTAL LIABILITIES AND FUND BALANCE 702,494 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 14:22 12/10/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/2015 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- 33,941.61- 37,881.68- 5.672 630,016.32- 533-40002-000-000 Property Taxes/Delinquent 2,300.00- 2,300.00- 119.76- 194.06- 8.437 2,105.94- 533-40015-000-000 Property Taxes/P & I 1,800.00- 1,800.00- 28.31- 61.45- 3.414 1,738.55- Subtotal: 671,998.00- 671,998.00- 34,089.68- 38,137.19- 5.675 633,860.81- 533-49010-000-000 Interest Income 140.00- 140.00- 3.24- 4.89- 3.493 135.11- 533-49015-000-000 Lease/Rental Income 214,379.00- 214,379.00- 214,379.00- 533-49141-000-000 Interfund Trans In-PID Surchg 119,706.00- 119,706.00- 119,706.00- Subtotal: 334,225.00- 334,225.00- 3.24- 4.89- .001 334,220.11- Program number: 1,006,223.00- 1,006,223.00- 34,092.92- 38,142.08- 3.791 968,080.92- Department number: Revenues 1,006,223.00- 1,006,223.00- 34,092.92- 38,142.08- 3.791 968,080.92- Revenues Subtotal ----------- 1,006,223.00- 1,006,223.00- 34,092.92- 38,142.08- 3.791 968,080.92- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 14:22 12/10/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/2015 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 2,550.00 533-70025-051-000 Bond Interest Expense-Tax 316,983.00 316,983.00 316,983.00 533-70035-051-000 Bond Principal Payment-Tax 685,000.00 685,000.00 685,000.00 Subtotal: 1,004,533.00 1,004,533.00 1,004,533.00 Program number: 1,004,533.00 1,004,533.00 1,004,533.00 Department number: Administration 1,004,533.00 1,004,533.00 1,004,533.00 Expenditures Subtotal ----------- 1,004,533.00 1,004,533.00 1,004,533.00 Fund number: 533 MUD 1 I&S Consolidated 1,690.00- 1,690.00- 34,092.92- 38,142.08- 2,256.928 36,452.08 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 58 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/2015 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 404 11/02/2015 Property Taxes (3,940.07) (756.64) (4,696.71) GL 405 11/03/2015 Property Taxes (2,620.26) (7,316.97) GL 406 11/04/2015 Property Taxes (859.89) (8,176.86) GL 407 11/05/2015 Property Taxes (1,500.76) (9,677.62) GL 408 11/06/2015 Property Taxes (396.01) (10,073.63) GL 409 11/09/2015 Property Taxes (2,239.15) (12,312.78) GL 410 11/10/2015 Property Taxes (2,507.71) (14,820.49) GL 411 11/12/2015 Property Taxes (443.33) (15,263.82) GL 412 11/13/2015 Property Taxes (2,585.71) (17,849.53) GL 413 11/16/2015 Property Taxes (972.67) (18,822.20) GL 414 11/17/2015 Property Taxes (1,306.34) (20,128.54) GL 415 11/18/2015 Property Taxes (294.88) (20,423.42) GL 416 11/19/2015 Property Taxes (1,201.13) (21,624.55) GL 417 11/20/2015 Property Taxes (1,311.10) (22,935.65) GL 418 11/23/2015 Property Taxes (1,334.22) (24,269.87) GL 419 11/24/2015 Property Taxes (10,337.85) (34,607.72) GL 420 11/25/2015 Property Taxes (381.43) (34,989.15) GL 421 11/30/2015 Property Taxes (2,892.53) (37,881.68) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (33,941.61) (37,881.68) ** (667,898.00) Budgeted (630,016.32) Remaining 6 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 404 11/02/2015 Property Taxes (74.30) 6.18 (68.12) GL 405 11/03/2015 Property Taxes (2.91) (71.03) GL 414 11/17/2015 Property Taxes (47.98) (119.01) GL 421 11/30/2015 Property Taxes (75.05) (194.06) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (119.76) (194.06) ** (2,300.00) Budgeted (2,105.94) Remaining 8 % Used Account: 533-40015-000-000 Property Taxes/P & I 404 11/02/2015 Property Taxes (33.14) (.74) (33.88) GL 405 11/03/2015 Property Taxes (.61) (34.49) GL 414 11/17/2015 Property Taxes (10.56) (45.05) GL 421 11/30/2015 Property Taxes (16.40) (61.45) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (28.31) (61.45) ** (1,800.00) Budgeted (1,738.55) Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 59 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-49010-000-000 Interest Income 391 11/30/2015 Bank Interest/November (1.65) (3.24) (4.89) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (3.24) (4.89) ** (140.00) Budgeted (135.11) Remaining 3 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (214,379.00) Budgeted (214,379.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg .00 .00 _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 .00 ** (119,706.00) Budgeted (119,706.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (38,142.08) ** (1,006,223.00) Budgeted (968,080.92) Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 60 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/2015 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 .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,550.00 Budgeted 2,550.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 316,983.00 Budgeted 316,983.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 685,000.00 Budgeted 685,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 1,004,533.00 Budgeted 1,004,533.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (38,142.08) (1,690.00) Budgeted 36,452.08 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET NOVEMBER 2015 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 15,071 ACCOUNTS RECEIVABLE - TOTAL ASSETS 15,071 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,068 NET REVENUES / EXPENDITURES 3 TOTAL FUND BALANCE 15,071 TOTAL LIABILITIES AND FUND BALANCE 15,071 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 14:22 12/10/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 11/2015 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- 1.41- 2.68- 38.286 4.32- 534-49143-000-000 Interfund Transfer In-WW Sales 444,831.00- 444,831.00- 444,831.00- Subtotal: 444,838.00- 444,838.00- 1.41- 2.68- .001 444,835.32- Program number: 444,838.00- 444,838.00- 1.41- 2.68- .001 444,835.32- Department number: Revenues 444,838.00- 444,838.00- 1.41- 2.68- .001 444,835.32- Revenues Subtotal ----------- 444,838.00- 444,838.00- 1.41- 2.68- .001 444,835.32- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 25 14:22 12/10/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 11/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 234,838.00 234,838.00 234,838.00 534-70045-051-000 Revenue Bond Principal Expense 210,000.00 210,000.00 210,000.00 Subtotal: 444,838.00 444,838.00 444,838.00 Program number: 444,838.00 444,838.00 444,838.00 Department number: Administration 444,838.00 444,838.00 444,838.00 Expenditures Subtotal ----------- 444,838.00 444,838.00 444,838.00 Fund number: 534 2015 Revenue Bond I&S 1.41- 2.68- 2.68 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 61 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 11/2015 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 391 11/30/2015 Bank Interest/November (1.27) (1.41) (2.68) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (1.41) (2.68) ** (7.00) Budgeted (4.32) Remaining 38 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales .00 .00 _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 .00 ** (444,831.00) Budgeted (444,831.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2.68) ** (444,838.00) Budgeted (444,835.32) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 62 14:22 12/10/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 11/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 234,838.00 Budgeted 234,838.00 Remaining 0 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 210,000.00 Budgeted 210,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 444,838.00 Budgeted 444,838.00 Remaining 0 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (2.68) .00 Budgeted 2.68 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (39,653.49) **** (125,026.00) Budgeted (85,372.51) Remaining 32 % Used ******* End of Report *********