Loading...
HomeMy WebLinkAbout2016-02 February Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET FEBRUARY 2016 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,034,215 PREPAID EXPENSES 8,212 ADVALOREM PROPERTY TAXES RECEIVABLE 54,226 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE 3,373 TOTAL ASSETS 1,100,026 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 54,226 ACCOUNTS AND OTHER PAYABLES 7,312 TOTAL LIABILITIES 61,538 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 533,497 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 504,991 TOTAL FUND BALANCE 1,038,488 TOTAL LIABILITIES AND FUND BALANCE 1,100,026 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 11:27 03/09/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 404,346.00- 404,346.00- 371,290.86- 371,290.86- 91.825 33,055.14- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 345.54- 345.54- 345.54 122-40010-000-000 Property Taxes/MUD Fire 889,963.00- 889,963.00- 66,348.07- 861,088.88- 96.756 28,874.12- 122-40011-000-000 Property Taxes/Fire-Delinquent 1,227.01- 2,222.72- 2,222.72 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- 1,795.76- 2,128.21- 47.294 2,371.79- Subtotal: 1,299,559.00- 1,299,559.00- 441,007.24- 1,237,076.21- 95.192 62,482.79- 122-42014-000-000 Fire Plan Review>6,000 sq ft 5,000.00- 5,000.00- 800.00- 3,600.00- 72.000 1,400.00- Subtotal: 5,000.00- 5,000.00- 800.00- 3,600.00- 72.000 1,400.00- 122-43400-000-000 Fire Inspections 825.00- 825.00- 150.00- 775.00- 93.939 50.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- 150.00- 775.00- 7.159 10,050.00- 122-49026-000-000 Proceeds from Sale of Assets 55,800.00- 55,800.00 122-49900-000-000 Miscellaneous Income 50,000.00- 50,000.00- 1,600.00- 7,700.00- 15.400 42,300.00- Subtotal: 50,000.00- 50,000.00- 1,600.00- 63,500.00- 127.000 13,500.00 Program number: 1,365,384.00- 1,365,384.00- 443,557.24- 1,304,951.21- 95.574 60,432.79- Department number: Fire Revenues 1,365,384.00- 1,365,384.00- 443,557.24- 1,304,951.21- 95.574 60,432.79- Revenues Subtotal ----------- 1,365,384.00- 1,365,384.00- 443,557.24- 1,304,951.21- 95.574 60,432.79- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 11:27 03/09/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 508,226.00 508,226.00 38,313.37 187,784.84 36.949 320,441.16 122-50010-045-000 Overtime 48,735.00 48,735.00 4,761.01 25,738.94 52.814 22,996.06 122-50011-045-000 DPS Holiday Pay 15,852.00 15,852.00 73.63 14,717.53 92.843 1,134.47 122-50016-045-000 Longevity 5,761.00 5,761.00 5,730.00 99.462 31.00 122-50017-045-000 Certification 4,200.00 4,200.00 1,190.13 28.336 3,009.87 122-50020-045-000 Retirement 75,571.00 75,571.00 4,855.87 29,829.34 39.472 45,741.66 122-50026-045-000 Medical Insurance 65,546.00 65,546.00 4,806.44 21,152.91 32.272 44,393.09 122-50027-045-000 Dental Insurance 4,885.00 4,885.00 789.95 2,154.95 44.114 2,730.05 122-50028-045-000 Vision Insurance 859.00 859.00 73.97 449.37 52.313 409.63 122-50029-045-000 Life Insurance & Other 4,585.00 4,585.00 348.68 1,468.05 32.019 3,116.95 122-50030-045-000 Social Security Taxes 36,132.00 36,132.00 2,489.52 13,689.23 37.887 22,442.77 122-50035-045-000 Medicare Taxes 8,450.00 8,450.00 582.08 3,200.72 37.878 5,249.28 122-50040-045-000 Unemployment Taxes 1,724.00 1,724.00 77.18 206.09 11.954 1,517.91 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 54.00 21.600 196.00 Subtotal: 790,155.00 790,155.00 57,171.70 307,366.10 38.899 482,788.90 122-55030-045-000 Software & Support 6,661.00 6,661.00 462.50 2,312.50 34.717 4,348.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 6,130.32 13,288.40 81.175 3,081.60 122-55090-045-000 Vehicle Maintenance 10,000.00 10,000.00 2,170.56 5,698.95 56.990 4,301.05 Subtotal: 35,031.00 35,031.00 8,763.38 21,299.85 60.803 13,731.15 122-60005-045-000 Telephone 50.00 50.00 17.38 34.760 32.62 122-60010-045-000 Communications/Mobiles 6,653.00 6,653.00 227.01 4,898.73 73.632 1,754.27 122-60020-045-000 Electricity/Gas 7,412.00 7,412.00 477.55 1,766.08 23.827 5,645.92 122-60025-045-000 Water 1,200.00 1,200.00 99.30 672.06 56.005 527.94 122-60026-045-000 Cable 1,920.00 1,920.00 248.03- 765.83 39.887 1,154.17 122-60030-045-000 Rent And/Or Usage 214,379.00 214,379.00 214,379.00 214,379.00 100.000 122-60035-045-000 Postage 50.00 50.00 7.97 15.940 42.03 122-60055-045-000 Insurance 14,077.00 14,077.00 1,173.08 10,239.18 72.737 3,837.82 122-60066-045-000 Publications/Books/Subscrips 350.00 350.00 172.05 172.05 49.157 177.95 122-60070-045-000 Dues & Memberships 15,582.00 15,582.00 335.00 15,456.59 99.195 125.41 122-60080-045-000 Schools & Training 7,880.00 7,880.00 592.00 2,298.39 29.167 5,581.61 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 122-60100-045-000 Travel & per diem 4,081.00 4,081.00 933.34 22.870 3,147.66 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 688.39 9.179 6,811.61 122-60180-045-000 Fire Inspection/Enforcement 500.00 500.00 359.29 71.858 140.71 122-60195-045-000 Flags & Repair 3,184.00 3,184.00 47.50 257.00 8.072 2,927.00 122-60245-045-000 Miscellaneous Expense 1,001.00 1,001.00 174.40 391.64 39.125 609.36 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 11:27 03/09/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 292,019.00 292,019.00 217,428.86 253,302.92 86.742 38,716.08 122-65005-045-000 Fuel & Lube 15,122.00 15,122.00 284.64 1,867.81 12.352 13,254.19 122-65010-045-000 Uniforms 3,140.00 3,140.00 251.39 2,727.22 86.854 412.78 122-65015-045-000 Protective Clothing 9,000.00 9,000.00 1,615.79 2,456.76 27.297 6,543.24 122-65030-045-000 Chemicals 600.00 600.00 600.00 122-65035-045-000 Small Tools 2,000.00 2,000.00 123.75 1,829.79 91.490 170.21 122-65055-045-000 Hardware 750.00 750.00 195.42 195.42 26.056 554.58 122-65085-045-000 Office Supplies 500.00 500.00 60.26 60.26 12.052 439.74 122-65105-045-000 Printing 498.00 498.00 498.00 Subtotal: 31,610.00 31,610.00 2,531.25 9,137.26 28.906 22,472.74 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-69255-045-000 Airpacks 285.81 285.81 285.81- 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 285.81 208,854.41 96.438 7,714.59 Program number: 1,365,384.00 1,365,384.00 286,181.00 799,960.54 58.589 565,423.46 Department number: Fire 1,365,384.00 1,365,384.00 286,181.00 799,960.54 58.589 565,423.46 Expenditures Subtotal ----------- 1,365,384.00 1,365,384.00 286,181.00 799,960.54 58.589 565,423.46 Fund number: 122 Trophy Club MUD Fire Dept. 157,376.24- 504,990.67- 504,990.67 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 910 02/09/2016 VOID FOR BANK CHANGE (92.60) (92.60) Oncor Electric Delivery 35043 AP 947 02/12/2016 PID Fire Assessment FY2016 PID Fire Assessmnt current yr (371,064.19) (371,156.79) GL 947 02/12/2016 PID Fire Assessment FY2016 Out of District Fire Assessmen (226.67) (371,383.46) GL 980 02/22/2016 Replace lost outstanding cks Replace lost check # 35043 92.60 (371,290.86) Oncor Electric Delivery 1562 AP _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (371,290.86) (371,290.86) ** (404,346.00) Budgeted (33,055.14) Remaining 92 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 947 02/12/2016 PID Fire Assessment FY2016 Fire Assessment delinquent (345.54) (345.54) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (345.54) (345.54) ** .00 Budgeted 345.54 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1070 02/01/2016 Property Taxes/Assessments (794,740.81) (5,141.84) (799,882.65) GL 1071 02/02/2016 Property Taxes/Assessments (7,615.60) (807,498.25) GL 1072 02/03/2016 Property Taxes/Assessments (22,396.48) (829,894.73) GL 1073 02/04/2016 Property Taxes/Assessments (5,698.88) (835,593.61) GL 1076 02/05/2016 Property Taxes/Assessments (16,353.31) (851,946.92) GL 1077 02/08/2016 Property Taxes/Assessments (4,430.53) (856,377.45) GL 1081 02/09/2016 Property Taxes/Assessments (637.28) (857,014.73) GL 1082 02/10/2016 Property Taxes/Assessments (611.00) (857,625.73) GL 1083 02/11/2016 Property Taxes/Assessments (317.77) (857,943.50) GL 1085 02/12/2016 Property Taxes/Assessments 107.09 (857,836.41) GL 1086 02/16/2016 Property Taxes/Assessments (214.87) (858,051.28) GL 1087 02/17/2016 Property Taxes/Assessments (817.22) (858,868.50) GL 1088 02/18/2016 Property Taxes/Assessments (51.53) (858,920.03) GL 1089 02/19/2016 Property Taxes/Assessments (126.73) (859,046.76) GL 1090 02/22/2016 Property Taxes/Assessments (59.35) (859,106.11) GL 1091 02/23/2016 Property Taxes/Assessments (312.91) (859,419.02) GL 1094 02/24/2016 Property Taxes/Assessments (585.18) (860,004.20) GL 1095 02/25/2016 Property Taxes/Assessments (179.72) (860,183.92) GL 1096 02/26/2016 Property Taxes/Assessments (12.34) (860,196.26) GL 1097 02/29/2016 Property Taxes/Assessments (892.62) (861,088.88) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (66,348.07) (861,088.88) ** (889,963.00) Budgeted (28,874.12) Remaining 97 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1072 02/03/2016 Property Taxes/Assessments (995.71) (1,224.94) (2,220.65) GL 1073 02/04/2016 Property Taxes/Assessments (2.07) (2,222.72) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (1,227.01) (2,222.72) ** .00 Budgeted 2,222.72 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I .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 1071 02/02/2016 Property Taxes/Assessments (332.45) (4.30) (336.75) GL 1072 02/03/2016 Property Taxes/Assessments (553.73) (890.48) GL 1073 02/04/2016 Property Taxes/Assessments (.52) (891.00) GL 1076 02/05/2016 Property Taxes/Assessments (5.84) (896.84) GL 1081 02/09/2016 Property Taxes/Assessments (34.54) (931.38) GL 1082 02/10/2016 Property Taxes/Assessments (37.90) (969.28) GL 1083 02/11/2016 Property Taxes/Assessments (22.25) (991.53) GL 1085 02/12/2016 Property Taxes/Assessments (978.91) (1,970.44) GL 1086 02/16/2016 Property Taxes/Assessments (15.03) (1,985.47) GL 1087 02/17/2016 Property Taxes/Assessments (7.95) (1,993.42) GL 1088 02/18/2016 Property Taxes/Assessments (3.61) (1,997.03) GL 1089 02/19/2016 Property Taxes/Assessments (8.57) (2,005.60) GL 1090 02/22/2016 Property Taxes/Assessments (2.15) (2,007.75) GL 1091 02/23/2016 Property Taxes/Assessments (18.98) (2,026.73) GL 1094 02/24/2016 Property Taxes/Assessments (28.11) (2,054.84) GL 1095 02/25/2016 Property Taxes/Assessments (12.58) (2,067.42) GL 1096 02/26/2016 Property Taxes/Assessments (.87) (2,068.29) GL 1097 02/29/2016 Property Taxes/Assessments (59.92) (2,128.21) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (1,795.76) (2,128.21) ** (4,500.00) Budgeted (2,371.79) Remaining 47 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (2,800.00) (800.00) (3,600.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (800.00) (3,600.00) ** (5,000.00) Budgeted (1,400.00) Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-43400-000-000 Fire Inspections 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (625.00) (150.00) (775.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (150.00) (775.00) ** (825.00) Budgeted (50.00) Remaining 94 % 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-49026-000-000 Proceeds from Sale of Assets (55,800.00) .00 (55,800.00) _______________ Account: 122-49026-000-000 Proceeds from Sale of Assets Totals: .00 (55,800.00) ** .00 Budgeted 55,800.00 Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (6,100.00) (1,600.00) (7,700.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (1,600.00) (7,700.00) ** (50,000.00) Budgeted (42,300.00) Remaining 15 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,304,951.21) ** (1,365,384.00) Budgeted (60,432.79) Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 1051 02/12/2016 Fire Payroll 2/12/16 149,471.47 18,650.23 168,121.70 GL 1055 02/26/2016 Fire Payroll 2/26/16 19,663.14 187,784.84 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 38,313.37 187,784.84 ** 508,226.00 Budgeted 320,441.16 Remaining 37 % Used Account: 122-50010-045-000 Overtime 1051 02/12/2016 Fire Payroll 2/12/16 20,977.93 4,761.01 25,738.94 GL _______________ Account: 122-50010-045-000 Overtime Totals: 4,761.01 25,738.94 ** 48,735.00 Budgeted 22,996.06 Remaining 53 % Used Account: 122-50011-045-000 DPS Holiday Pay 1055 02/26/2016 Fire Payroll 2/26/16 14,643.90 73.63 14,717.53 GL _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: 73.63 14,717.53 ** 15,852.00 Budgeted 1,134.47 Remaining 93 % Used Account: 122-50016-045-000 Longevity 5,730.00 .00 5,730.00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 5,730.00 ** 5,761.00 Budgeted 31.00 Remaining 99 % Used Account: 122-50017-045-000 Certification 1,190.13 .00 1,190.13 _______________ Account: 122-50017-045-000 Certification Totals: .00 1,190.13 ** 4,200.00 Budgeted 3,009.87 Remaining 28 % Used Account: 122-50020-045-000 Retirement 1051 02/12/2016 Fire Payroll 2/12/16 24,973.47 2,592.64 27,566.11 GL 1055 02/26/2016 Fire Payroll 2/26/16 2,263.23 29,829.34 GL _______________ Account: 122-50020-045-000 Retirement Totals: 4,855.87 29,829.34 ** 75,571.00 Budgeted 45,741.66 Remaining 39 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 1051 02/12/2016 Fire Payroll 2/12/16 16,346.47 2,782.35 19,128.82 GL 1055 02/26/2016 Fire Payroll 2/26/16 2,024.09 21,152.91 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,806.44 21,152.91 ** 65,546.00 Budgeted 44,393.09 Remaining 32 % Used Account: 122-50027-045-000 Dental Insurance 1051 02/12/2016 Fire Payroll 2/12/16 1,365.00 194.43 1,559.43 GL 1051 02/12/2016 Fire Payroll 2/12/16 400.00 1,959.43 GL 1055 02/26/2016 Fire Payroll 2/26/16 195.52 2,154.95 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 789.95 2,154.95 ** 4,885.00 Budgeted 2,730.05 Remaining 44 % Used Account: 122-50028-045-000 Vision Insurance 1051 02/12/2016 Fire Payroll 2/12/16 375.40 36.84 412.24 GL 1055 02/26/2016 Fire Payroll 2/26/16 37.13 449.37 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 73.97 449.37 ** 859.00 Budgeted 409.63 Remaining 52 % Used Account: 122-50029-045-000 Life Insurance & Other 1051 02/12/2016 Fire Payroll 2/12/16 1,119.37 173.87 1,293.24 GL 1055 02/26/2016 Fire Payroll 2/26/16 174.81 1,468.05 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 348.68 1,468.05 ** 4,585.00 Budgeted 3,116.95 Remaining 32 % Used Account: 122-50030-045-000 Social Security Taxes 1051 02/12/2016 Fire Payroll 2/12/16 11,199.71 1,366.53 12,566.24 GL 1055 02/26/2016 Fire Payroll 2/26/16 1,122.99 13,689.23 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,489.52 13,689.23 ** 36,132.00 Budgeted 22,442.77 Remaining 38 % Used Account: 122-50035-045-000 Medicare Taxes 1051 02/12/2016 Fire Payroll 2/12/16 2,618.64 319.50 2,938.14 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1055 02/26/2016 Fire Payroll 2/26/16 2,618.64 262.58 3,200.72 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 582.08 3,200.72 ** 8,450.00 Budgeted 5,249.28 Remaining 38 % Used Account: 122-50040-045-000 Unemployment Taxes 1051 02/12/2016 Fire Payroll 2/12/16 128.91 58.61 187.52 GL 1055 02/26/2016 Fire Payroll 2/26/16 18.57 206.09 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 77.18 206.09 ** 1,724.00 Budgeted 1,517.91 Remaining 12 % 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 54.00 .00 54.00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 54.00 ** 250.00 Budgeted 196.00 Remaining 22 % Used Account: 122-55030-045-000 Software & Support 1074 02/29/2016 Feb A/P Verizon, Gexa, Charter 1,850.00 462.50 2,312.50 TOWN OF TROPHY CLUB 1648 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 2,312.50 ** 6,661.00 Budgeted 4,348.50 Remaining 35 % 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 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 935 02/12/2016 February A/P Flow testing per NFPA of SCBA' 7,158.08 2,895.20 10,053.28 MUNICIPAL EMERGENCY SERVICES 1525 AP 935 02/12/2016 February A/P Annual ladder test 999.00 11,052.28 CONSOLIDATED FLEET SERVICES 1495 AP 1066 02/26/2016 PCards 1/27/16-2/26/16 SAMS CLUB #4795 266.87 11,319.15 SAMS CLUB #4795 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 TRACTOR SUPPLY COMPANY 90.97 11,410.12 TRACTOR SUPPLY COMPANY PC 1066 02/26/2016 PCards 1/27/16-2/26/16 SAMSCLUB #4795 27.04 11,437.16 SAMSCLUB #4795 PC 1074 02/29/2016 Feb A/P Rug Service/Feb 37.24 11,474.40 G & K SERVICES 1612 AP 1074 02/29/2016 Feb A/P Rug Service/Feb 37.24 11,511.64 G & K SERVICES 1612 AP 1074 02/29/2016 Feb A/P Repair HVAC thermostat 170.00 11,681.64 BRANDON R REED 1602 AP 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (37.24) 11,644.40 AR 1125 02/29/2016 Feb A/P Changed lamps, cord reel 1,644.00 13,288.40 FREEMAN ELECTRIC COMPANY INC 1656 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 6,130.32 13,288.40 ** 16,370.00 Budgeted 3,081.60 Remaining 81 % Used Account: 122-55090-045-000 Vehicle Maintenance 1074 02/29/2016 Feb A/P E681 repair 3,528.39 2,170.56 5,698.95 SIDDONS-MARTIN EMERGENCY GROUP 1645 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 2,170.56 5,698.95 ** 10,000.00 Budgeted 4,301.05 Remaining 57 % Used Account: 122-60005-045-000 Telephone 17.38 .00 17.38 _______________ Account: 122-60005-045-000 Telephone Totals: .00 17.38 ** 50.00 Budgeted 32.62 Remaining 35 % Used Account: 122-60010-045-000 Communications/Mobiles 1051 02/12/2016 Fire Payroll 2/12/16 4,671.72 75.00 4,746.72 GL 1074 02/29/2016 Feb A/P Verizon, Gexa, Charter 152.01 4,898.73 TOWN OF TROPHY CLUB 1648 AP _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 227.01 4,898.73 ** 6,653.00 Budgeted 1,754.27 Remaining 74 % Used Account: 122-60020-045-000 Electricity/Gas 935 02/12/2016 February A/P Elec 1/11/16-2/10/16 1,288.53 713.48 2,002.01 HUDSON ENERGY SERVICES, LLC 1508 AP 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (477.55) 1,524.46 AR 1125 02/29/2016 Feb A/P Fire Station gas 1/19/16-2/15/ 241.62 1,766.08 ATMOS ENERGY 1654 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 477.55 1,766.08 ** 7,412.00 Budgeted 5,645.92 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60025-045-000 Water 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: 572.76 (99.29) 473.47 AR 1125 02/29/2016 Feb A/P Feb Water-Fire Station 151.93 625.40 TROPHY CLUB MUD (WATER BILLS) 1671 AP 1125 02/29/2016 Feb A/P Fire Station Irrigatiion 46.66 672.06 TROPHY CLUB MUD (WATER BILLS) 1671 AP _______________ Account: 122-60025-045-000 Water Totals: 99.30 672.06 ** 1,200.00 Budgeted 527.94 Remaining 56 % Used Account: 122-60026-045-000 Cable 944 02/08/2016 Firefighter cable Nov-Feb 1,013.86 (535.28) 478.58 GL 1066 02/26/2016 PCards 1/27/16-2/26/16 ATT*BILL PAYMENT 128.66 607.24 ATT*BILL PAYMENT PC 1066 02/26/2016 PCards 1/27/16-2/26/16 ATT*BILL PAYMENT 158.59 765.83 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: (248.03) 765.83 ** 1,920.00 Budgeted 1,154.17 Remaining 40 % Used Account: 122-60030-045-000 Rent And/Or Usage 1029 02/18/2016 FD Rent to MUD 1 I&S 214,379.00 214,379.00 GL _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: 214,379.00 214,379.00 ** 214,379.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 7.97 .00 7.97 _______________ Account: 122-60035-045-000 Postage Totals: .00 7.97 ** 50.00 Budgeted 42.03 Remaining 16 % Used Account: 122-60055-045-000 Insurance 136 02/01/2016 Prepaid Insurance, W/C Feb 9,066.10 1,173.08 10,239.18 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,173.08 10,239.18 ** 14,077.00 Budgeted 3,837.82 Remaining 73 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 1066 02/26/2016 PCards 1/27/16-2/26/16 INT'L CODE COUNCIL INC 172.05 172.05 INT'L CODE COUNCIL INC PC _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: 172.05 172.05 ** 350.00 Budgeted 177.95 Remaining 49 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60070-045-000 Dues & Memberships 1066 02/26/2016 PCards 1/27/16-2/26/16 STATE FIREMEN'S & FIRE 15,121.59 335.00 15,456.59 STATE FIREMEN'S & FIRE PC _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 335.00 15,456.59 ** 15,582.00 Budgeted 125.41 Remaining 99 % Used Account: 122-60080-045-000 Schools & Training 935 02/12/2016 February A/P TCC Live Fire Training 1,706.39 555.00 2,261.39 NORTH EAST FIRE DEPT ASSOC 1528 AP 985 02/22/2016 Feb A/P Firefighter 1 37.00 2,298.39 TARRANT COUNTY COLLEGE 1585 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 592.00 2,298.39 ** 7,880.00 Budgeted 5,581.61 Remaining 29 % 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 933.34 .00 933.34 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 933.34 ** 4,081.00 Budgeted 3,147.66 Remaining 23 % 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 .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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 688.39 .00 688.39 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 688.39 ** 7,500.00 Budgeted 6,811.61 Remaining 9 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 359.29 .00 359.29 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 359.29 ** 500.00 Budgeted 140.71 Remaining 72 % Used Account: 122-60195-045-000 Flags & Repair 985 02/22/2016 Feb A/P Flag repair 209.50 95.00 304.50 SYMONDS FLAGS & POLES 1584 AP 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (47.50) 257.00 AR _______________ Account: 122-60195-045-000 Flags & Repair Totals: 47.50 257.00 ** 3,184.00 Budgeted 2,927.00 Remaining 8 % Used Account: 122-60245-045-000 Miscellaneous Expense 1066 02/26/2016 PCards 1/27/16-2/26/16 VINNYS ITALIAN RESTAUR 217.24 45.00 262.24 VINNYS ITALIAN RESTAUR PC 1074 02/29/2016 Feb A/P 2 Badges 129.40 391.64 CW NIELSEN MANUFACTURING, INC 1605 AP _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 174.40 391.64 ** 1,001.00 Budgeted 609.36 Remaining 39 % Used Account: 122-65005-045-000 Fuel & Lube 1074 02/29/2016 Feb A/P 1/25/16-2/24/16 Fuel purchases 1,583.17 284.64 1,867.81 US Bank Voyager Fleet Systems 1650 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 284.64 1,867.81 ** 15,122.00 Budgeted 13,254.19 Remaining 12 % Used Account: 122-65010-045-000 Uniforms 935 02/12/2016 February A/P Shirt, Boots 2,475.83 322.77 2,798.60 RED THE UNIFORM TAILOR 1532 AP 1066 02/26/2016 PCards 1/27/16-2/26/16 NUSHOE 90.00 2,888.60 NUSHOE PC 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (161.38) 2,727.22 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 251.39 2,727.22 ** 3,140.00 Budgeted 412.78 Remaining 87 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-65015-045-000 Protective Clothing 935 02/12/2016 February A/P Boots 840.97 325.00 1,165.97 CASCO INDUSTRIES INC 1489 AP 985 02/22/2016 Feb A/P NFPA1851 Adv Cleaning & testin 709.13 1,875.10 Gear Cleaning Solutions, LLC 1575 AP 989 02/22/2016 Feb A/P NFPA Adv Cleaning and Testing 581.66 2,456.76 Gear Cleaning Solutions, LLC 1588 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 1,615.79 2,456.76 ** 9,000.00 Budgeted 6,543.24 Remaining 27 % 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 1066 02/26/2016 PCards 1/27/16-2/26/16 AUTO DESIGNS 1,706.04 123.75 1,829.79 AUTO DESIGNS PC _______________ Account: 122-65035-045-000 Small Tools Totals: 123.75 1,829.79 ** 2,000.00 Budgeted 170.21 Remaining 91 % Used Account: 122-65055-045-000 Hardware 935 02/12/2016 February A/P Rugged book for IPAD Air 2 195.42 195.42 TOWN OF TROPHY CLUB 1540 AP _______________ Account: 122-65055-045-000 Hardware Totals: 195.42 195.42 ** 750.00 Budgeted 554.58 Remaining 26 % Used Account: 122-65085-045-000 Office Supplies 1066 02/26/2016 PCards 1/27/16-2/26/16 STAPLES 00112821 60.26 60.26 STAPLES 00112821 PC _______________ Account: 122-65085-045-000 Office Supplies Totals: 60.26 60.26 ** 500.00 Budgeted 439.74 Remaining 12 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-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-69255-045-000 Airpacks 1074 02/29/2016 Feb A/P Airpack Mask 285.81 285.81 MUNICIPAL EMERGENCY SERVICES 1632 AP _______________ Account: 122-69255-045-000 Airpacks Totals: 285.81 285.81 ** .00 Budgeted (285.81) Remaining 0 % 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: ------------------------------------------------------------------------------------------------ 799,960.54 ** 1,365,384.00 Budgeted 565,423.46 Remaining 59 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (504,990.67) .00 Budgeted 504,990.67 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET FEBRUARY 2016 0 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 2/29/16 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 495,943 - - 495,943 CD-BANK OF THE WEST/THB DEPOSIT 35,000 35,000 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,510,402 - - 1,510,402 INVESTMENTS-TEXPOOL 1,423,784 326,020 - 1,749,804 PREPAID EXPENSES 37,875 - - 37,875 ADVALOREM PROPERTY TAXES RECEIVABLE 1,494 - - 1,494 UTILITY AND OTHER ACCOUNTS RECEIVABLE 561,681 - - 561,681 - TOTAL ASSETS 4,066,779 326,020 - 4,392,799 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,494 - - 1,494 ACCOUNTS AND OTHER PAYABLES 948,408 - - 948,408 CUSTOMER DEPOSITS 314,897 - - 314,897 - TOTAL LIABILITIES 1,264,799 - - 1,264,799 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,592,494 - 8,032 1,600,526 COMMITTED FUND BALANCE 1,159,233 - - 1,159,233 NET REVENUES / EXPENDITURES (387,433) - (8,032) (395,465) - TOTAL FUND BALANCE 2,801,980 326,020 - 3,128,000 - TOTAL LIABILITIES AND FUND BALANCE 4,066,779 326,020 - 4,392,799 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 11:27 03/09/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 58,181.00- 58,181.00- 4,336.22- 56,277.18- 96.728 1,903.82- 135-40002-000-000 Property Taxes/Delinquent 140.62- 275.22- 275.22 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 138.33- 182.86- 28.132 467.14- 135-40025-000-000 PID Surcharges 146,125.00- 146,125.00- 24,739.19- 16.930 121,385.81- Subtotal: 204,956.00- 204,956.00- 4,615.17- 81,474.45- 39.752 123,481.55- 135-47000-000-000 Water 5,080,244.00- 5,080,244.00- 245,197.23- 1,380,534.68- 27.175 3,699,709.32- 135-47005-000-000 Sewer 2,413,776.00- 2,413,776.00- 166,910.10- 833,962.71- 34.550 1,579,813.29- 135-47025-000-000 Penalties 90,985.00- 90,985.00- 5,171.46- 46,683.64- 51.309 44,301.36- 135-47030-000-000 Service Charges 9,000.00- 9,000.00- 1,475.00- 6,950.00- 77.222 2,050.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 150.00- 1,500.00- 75.000 500.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 450.00- 4,350.00- 79.091 1,150.00- 135-47070-000-000 TCCC Effluent Charges 61,330.00- 61,330.00- 574.70- 6,587.70- 10.741 54,742.30- Subtotal: 7,662,835.00- 7,662,835.00- 419,928.49- 2,280,568.73- 29.761 5,382,266.27- 135-48005-000-000 Utility Fees 69,000.00- 69,000.00- 55,200.00- 80.000 13,800.00- Subtotal: 69,000.00- 69,000.00- 55,200.00- 80.000 13,800.00- 135-49010-000-000 Interest Income 6,000.00- 6,000.00- 1,239.29- 4,660.01- 77.667 1,339.99- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 4,552.65- 41.668 6,373.35- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 2,916.65- 41.666 4,083.35- 135-49026-000-000 Proceeds from Sale of Assets 15,070.00- 15,070.00 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,232.00- 32,247.80- 204.385 16,469.80 135-49141-000-000 Interfund Transfer In 8,034.36- 8,034.36 135-49900-000-000 Miscellaneous Income 63,249.00- 63,249.00- 227.45- 1,086.00- 1.717 62,163.00- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 20.40- 102.000 .40 Subtotal: 110,993.00- 110,993.00- 11,192.60- 68,587.87- 61.795 42,405.13- Program number: 8,047,784.00- 8,047,784.00- 435,736.26- 2,485,831.05- 30.888 5,561,952.95- Department number: Revenues 8,047,784.00- 8,047,784.00- 435,736.26- 2,485,831.05- 30.888 5,561,952.95- Revenues Subtotal ----------- 8,047,784.00- 8,047,784.00- 435,736.26- 2,485,831.05- 30.888 5,561,952.95- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 11:27 03/09/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 265,614.00 265,614.00 16,425.27 84,393.23 31.773 181,220.77 135-50010-010-000 Overtime 19,500.00 19,500.00 671.35 5,354.08 27.457 14,145.92 135-50016-010-000 Longevity 2,945.00 2,945.00 2,945.00 100.000 135-50017-010-000 Certification 4,200.00 4,200.00 200.00 925.00 22.024 3,275.00 135-50020-010-000 Retirement 25,558.00 25,558.00 1,509.99 8,277.89 32.389 17,280.11 135-50026-010-000 Medical Insurance 51,398.00 51,398.00 3,161.15 15,298.61 29.765 36,099.39 135-50027-010-000 Dental Insurance 3,999.00 3,999.00 240.77 1,139.33 28.490 2,859.67 135-50028-010-000 Vision Insurance 910.00 910.00 53.98 257.26 28.270 652.74 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 197.09 960.75 34.276 1,842.25 135-50030-010-000 Social Security Taxes 18,565.00 18,565.00 1,062.23 5,753.38 30.990 12,811.62 135-50035-010-000 Medicare Taxes 4,341.00 4,341.00 248.43 1,345.53 30.996 2,995.47 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 15.10 37.10 2.987 1,204.90 135-50045-010-000 Workman's Compensation 14,754.00 14,754.00 1,229.35 3,832.23 25.974 10,921.77 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 25,014.71 130,755.84 31.324 286,673.16 135-55005-010-000 Engineering 5,000.00 5,000.00 7,755.00 13,395.00 267.900 8,395.00- 135-55080-010-000 Maintenance & Repairs 85,000.00 85,000.00 8,369.30 51,333.72 60.393 33,666.28 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 43.00 2,813.22 35.165 5,186.78 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 341.77 484.22 13.835 3,015.78 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 431.47 1,694.17 30.803 3,805.83 Subtotal: 107,000.00 107,000.00 16,940.54 69,720.33 65.159 37,279.67 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 347.05 1,837.00 34.019 3,563.00 135-60020-010-000 Electricity 166,823.00 166,823.00 9,810.65 49,685.31 29.783 117,137.69 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 500.00 500.00 11.00 11.00 2.200 489.00 135-60080-010-000 Schools & Training 5,773.00 5,773.00 240.00 1,075.00 18.621 4,698.00 135-60090-010-000 Safety Program 400.00 400.00 248.97 62.243 151.03 135-60100-010-000 Travel & per diem 1,400.00 1,400.00 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 10,501.40 21.312 38,773.60 135-60150-010-000 Wholesale Water 2,948,742.00 2,948,742.00 122,971.57 587,269.08 19.916 2,361,472.92 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 463.36 1,489.85 42.567 2,010.15 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 133,843.63 652,131.86 20.464 2,534,631.14 135-65005-010-000 Fuel & Lube 35,947.00 35,947.00 1,787.73 7,060.34 19.641 28,886.66 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 11:27 03/09/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 4,608.00 4,608.00 161.49 2,006.73 43.549 2,601.27 135-65030-010-000 Chemicals 12,000.00 12,000.00 1,183.20 5,357.83 44.649 6,642.17 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 187.99 18.799 812.01 135-65050-010-000 Meter Expense 115,000.00 115,000.00 68,200.00 87,005.34 75.657 27,994.66 135-65053-010-000 Meter Change Out Program 50,000.00 50,000.00 32,625.00 77,325.00 154.650 27,325.00- Subtotal: 219,755.00 219,755.00 103,957.42 178,943.23 81.429 40,811.77 135-69005-010-000 Capital Outlays 201,000.00 201,000.00 153,611.95 215,637.80 107.282 14,637.80- 135-69008-010-000 Short Term Debt-Principal 130,720.00 130,720.00 130,700.34 130,700.34 99.985 19.66 135-69009-010-000 Short Term Debt-Interest 1,209.00 1,209.00 1,222.40 1,222.40 101.108 13.40- 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 118,774.42 93.554 8,183.58 Subtotal: 534,887.00 534,887.00 285,534.69 541,334.96 101.205 6,447.96- Program number: 4,465,834.00 4,465,834.00 565,290.99 1,572,886.22 35.220 2,892,947.78 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 11:27 03/09/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 207.70 527.70 10.554 4,472.30 Subtotal: 5,000.00 5,000.00 207.70 527.70 10.554 4,472.30 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 207.70 527.70 5.277 9,472.30 Department number: Water 4,475,834.00 4,475,834.00 565,498.69 1,573,413.92 35.154 2,902,420.08 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 11:27 03/09/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 351,671.00 351,671.00 28,502.41 139,750.18 39.739 211,920.82 135-50010-020-000 Overtime 19,500.00 19,500.00 3,804.79 13,341.57 68.418 6,158.43 135-50016-020-000 Longevity 6,125.00 6,125.00 6,125.00 100.000 135-50017-020-000 Certification 7,200.00 7,200.00 625.00 2,975.00 41.319 4,225.00 135-50020-020-000 Retirement 33,652.00 33,652.00 2,874.98 14,334.87 42.597 19,317.13 135-50026-020-000 Medical Insurance 65,989.00 65,989.00 5,531.97 25,200.75 38.189 40,788.25 135-50027-020-000 Dental Insurance 4,184.00 4,184.00 347.91 1,510.44 36.100 2,673.56 135-50028-020-000 Vision Insurance 972.00 972.00 78.05 344.75 35.468 627.25 135-50029-020-000 Life Insurance & Other 3,655.00 3,655.00 356.03 1,633.09 44.681 2,021.91 135-50030-020-000 Social Security Taxes 24,665.00 24,665.00 1,841.93 9,211.42 37.346 15,453.58 135-50035-020-000 Medicare Taxes 5,768.00 5,768.00 430.79 2,154.26 37.348 3,613.74 135-50040-020-000 Unemployment Taxes 1,449.00 1,449.00 27.82 66.12 4.563 1,382.88 135-50045-020-000 Workman's Compensation 9,317.00 9,317.00 776.43 1,567.66 16.826 7,749.34 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 238.45 79.483 61.55 135-50070-020-000 Employee Relations 650.00 650.00 180.88 180.88 27.828 469.12 Subtotal: 535,097.00 535,097.00 45,378.99 218,634.44 40.859 316,462.56 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 16,267.28 32,312.17 44.507 40,287.83 135-55090-020-000 Vehicle Maintenance 5,000.00 5,000.00 843.50 1,229.38 24.588 3,770.62 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 5,508.55 14,702.16 26.731 40,297.84 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 4,422.77 14,270.77 40.774 20,729.23 Subtotal: 218,100.00 218,100.00 27,042.10 62,514.48 28.663 155,585.52 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 544.56 2,455.97 45.481 2,944.03 135-60020-020-000 Electricity 161,582.00 161,582.00 10,919.34 46,827.60 28.981 114,754.40 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 830.00 22.010 2,941.00 135-60090-020-000 Safety Program 550.00 550.00 192.79 35.053 357.21 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 136.93- 624.35 39.022 975.65 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 5,920.00 15,359.28 41.344 21,790.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 185,515.60 185,515.60 41.705 259,315.40 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 61,668.00 50.000 61,668.00 Subtotal: 908,423.00 908,423.00 202,762.57 313,473.59 34.507 594,949.41 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 11:27 03/09/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 32,021.00 32,021.00 568.31 5,388.02 16.827 26,632.98 135-65010-020-000 Uniforms 4,241.00 4,241.00 19.99 2,503.53 59.032 1,737.47 135-65030-020-000 Chemicals 27,000.00 27,000.00 1,149.98 11,808.25 43.734 15,191.75 135-65035-020-000 Small Tools 2,000.00 2,000.00 170.10 220.50 11.025 1,779.50 135-65040-020-000 Safety Equipment 750.00 750.00 576.59 76.879 173.41 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 463.84 5,289.15 40.686 7,710.85 Subtotal: 79,012.00 79,012.00 2,372.22 25,786.04 32.636 53,225.96 135-69005-020-000 Capital Outlays 150,000.00 150,000.00 9,000.00 33,198.75 22.133 116,801.25 135-69008-020-000 Short Term Debt-Principal 21,280.00 21,280.00 21,276.80 21,276.80 99.985 3.20 135-69009-020-000 Short Term Debt-Interest 197.00 197.00 199.00 199.00 101.015 2.00- Subtotal: 171,477.00 171,477.00 30,475.80 54,674.55 31.884 116,802.45 Program number: 1,912,109.00 1,912,109.00 308,031.68 675,083.10 35.306 1,237,025.90 Department number: Wastewater 1,912,109.00 1,912,109.00 308,031.68 675,083.10 35.306 1,237,025.90 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 11:27 03/09/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 12,500.00 12,500.00 1,000.00 3,100.00 24.800 9,400.00 135-50030-026-000 Social Security Taxes 775.00 775.00 62.00 192.20 24.800 582.80 135-50035-026-000 Medicare Taxes 181.00 181.00 14.50 44.95 24.834 136.05 135-50040-026-000 Unemployment Taxes 230.00 230.00 1.00 3.10 1.348 226.90 135-50045-026-000 Workman's Compensation 37.00 37.00 3.08 28.41 76.784 8.59 Subtotal: 13,723.00 13,723.00 1,080.58 3,368.66 24.548 10,354.34 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 10.98 10.98 2.196 489.02 135-60075-026-000 Meetings 1,200.00 1,200.00 6.00 .500 1,194.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 550.00 13.750 3,450.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 883.89 1,602.43 32.049 3,397.57 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 894.87 2,219.89 17.275 10,630.11 Program number: 26,573.00 26,573.00 1,975.45 5,588.55 21.031 20,984.45 Department number: Board of Directors 26,573.00 26,573.00 1,975.45 5,588.55 21.031 20,984.45 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 11:27 03/09/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 488,508.00 488,508.00 37,275.30 190,042.20 38.903 298,465.80 135-50010-030-000 Overtime 1,000.00 1,000.00 16.98 127.60 12.760 872.40 135-50016-030-000 Longevity 3,823.00 3,823.00 3,822.50 99.987 .50 135-50020-030-000 Retirement 43,202.00 43,202.00 3,255.61 17,150.47 39.698 26,051.53 135-50026-030-000 Medical Insurance 68,196.00 68,196.00 5,310.72 25,285.07 37.077 42,910.93 135-50027-030-000 Dental Insurance 4,807.00 4,807.00 378.79 1,705.41 35.478 3,101.59 135-50028-030-000 Vision Insurance 1,114.00 1,114.00 87.14 393.91 35.360 720.09 135-50029-030-000 Life Insurance & Other 4,431.00 4,431.00 396.29 1,932.92 43.623 2,498.08 135-50030-030-000 Social Security Taxes 30,823.00 30,823.00 2,126.02 11,249.96 36.499 19,573.04 135-50035-030-000 Medicare Taxes 7,599.00 7,599.00 497.22 2,631.03 34.623 4,967.97 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 16.67 53.86 3.717 1,395.14 135-50045-030-000 Workman's Compensation 1,554.00 1,554.00 147.89 1,031.45 66.374 522.55 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 2,860.56 57.211 2,139.44 Subtotal: 662,006.00 662,006.00 49,508.63 258,286.94 39.016 403,719.06 135-55030-030-000 Software & Support 78,483.00 78,483.00 3,477.95 12,277.89 15.644 66,205.11 135-55070-030-000 Independent Labor 12,000.00 12,000.00 12,923.23 107.694 923.23- 135-55080-030-000 Maintenance & Repairs 29,500.00 29,500.00 1,965.00 9,689.66 32.846 19,810.34 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 3,030.77 4,116.83 58.812 2,883.17 135-55120-030-000 Cleaning Services 10,125.00 10,125.00 259.00- 2,080.00 20.543 8,045.00 135-55160-030-000 Professional Outside Services 61,075.00 61,075.00 1,502.50 53,072.50 86.897 8,002.50 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 2,540.87 30.986 5,659.13 Subtotal: 206,583.00 206,583.00 9,717.22 96,700.98 46.810 109,882.02 135-60005-030-000 Telephone 16,349.00 16,349.00 442.03 5,379.11 32.902 10,969.89 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 337.99 1,689.95 40.722 2,460.05 135-60020-030-000 Electricity/Gas 10,768.00 10,768.00 1,236.16 3,711.28 34.466 7,056.72 135-60025-030-000 Water 1,500.00 1,500.00 82.16 388.89 25.926 1,111.11 135-60035-030-000 Postage 28,932.00 28,932.00 381.07 9,305.13 32.162 19,626.87 135-60040-030-000 Service Charges & Fees 44,000.00 44,000.00 3,830.65 26,974.75 61.306 17,025.25 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 3,216.78- 1,075.05 30.716 2,424.95 135-60055-030-000 Insurance 52,797.00 52,797.00 2,907.00 14,031.00 26.575 38,766.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 110.00 5,006.25 83.438 993.75 135-60075-030-000 Meetings 400.00 400.00 29.00 7.250 371.00 135-60079-030-000 Public Education 5,000.00 5,000.00 902.54 1,484.19 29.684 3,515.81 135-60080-030-000 Schools & Training 9,935.00 9,935.00 564.50 2,421.50 24.373 7,513.50 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 343.91 2,232.24 41.338 3,167.76 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 12 11:27 03/09/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 7,500.00 7,500.00 61.74 .823 7,438.26 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.00- 4,073.98 23.279 13,427.02 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 656.38 26.255 1,843.62 Subtotal: 226,882.00 226,882.00 7,879.23 78,520.44 34.608 148,361.56 135-65010-030-000 Uniforms 1,855.00 1,855.00 23.00 1.240 1,832.00 135-65055-030-000 Hardware 29,594.00 29,594.00 15,773.84 21,645.69 73.142 7,948.31 135-65085-030-000 Office Supplies 9,000.00 9,000.00 995.56 2,973.75 33.042 6,026.25 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 555.52 1,871.99 37.440 3,128.01 135-65105-030-000 Printing 4,800.00 4,800.00 4,800.00 Subtotal: 54,252.00 54,252.00 17,324.92 26,735.73 49.281 27,516.27 135-69005-030-000 Capital Outlays 56,000.00 56,000.00 4,730.50 6,158.00 10.996 49,842.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 298.68 1,442.35 31.355 3,157.65 Subtotal: 60,600.00 60,600.00 5,029.18 7,600.35 12.542 52,999.65 Program number: 1,210,323.00 1,210,323.00 89,459.18 467,844.44 38.655 742,478.56 Department number: Administration 1,210,323.00 1,210,323.00 89,459.18 467,844.44 38.655 742,478.56 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 11:27 03/09/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 386,130.00 386,130.00 18,124.95 120,596.39 31.232 265,533.61 135-55055-039-000 Auditing 22,750.00 22,750.00 24,039.38 105.668 1,289.38- 135-55060-039-000 Appraisal 10,265.00 10,265.00 4,229.90 41.207 6,035.10 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,468.82 64.969 1,331.18 Subtotal: 422,945.00 422,945.00 18,124.95 151,334.49 35.781 271,610.51 Program number: 422,945.00 422,945.00 18,124.95 151,334.49 35.781 271,610.51 Department number: Non Departmental 422,945.00 422,945.00 18,124.95 151,334.49 35.781 271,610.51 Expenditures Subtotal ----------- 8,047,784.00 8,047,784.00 983,089.95 2,873,264.50 35.703 5,174,519.50 Fund number: 135 MUD 1 General Fund 547,353.69 387,433.45 387,433.45- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 11:27 03/09/16 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 11:27 03/09/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 2.77- 2.77 Subtotal: 2.77- 2.77 Program number: 2.77- 2.77 Department number: 2.77- 2.77 Revenues Subtotal ----------- 2.77- 2.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 11:27 03/09/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 8,034.36- Subtotal: 8,034.36 8,034.36- Program number: 8,034.36 8,034.36- Department number: Wastewater 8,034.36 8,034.36- Expenditures Subtotal ----------- 8,034.36 8,034.36- Fund number: 507 MUD 1 Capital Projects 8,031.59 8,031.59- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 1070 02/01/2016 Property Taxes/Assessments (51,940.96) (336.05) (52,277.01) GL 1071 02/02/2016 Property Taxes/Assessments (497.72) (52,774.73) GL 1072 02/03/2016 Property Taxes/Assessments (1,463.74) (54,238.47) GL 1073 02/04/2016 Property Taxes/Assessments (372.45) (54,610.92) GL 1076 02/05/2016 Property Taxes/Assessments (1,068.78) (55,679.70) GL 1077 02/08/2016 Property Taxes/Assessments (289.56) (55,969.26) GL 1081 02/09/2016 Property Taxes/Assessments (41.65) (56,010.91) GL 1082 02/10/2016 Property Taxes/Assessments (39.93) (56,050.84) GL 1083 02/11/2016 Property Taxes/Assessments (20.77) (56,071.61) GL 1085 02/12/2016 Property Taxes/Assessments 7.00 (56,064.61) GL 1086 02/16/2016 Property Taxes/Assessments (14.04) (56,078.65) GL 1087 02/17/2016 Property Taxes/Assessments (53.41) (56,132.06) GL 1088 02/18/2016 Property Taxes/Assessments (3.37) (56,135.43) GL 1089 02/19/2016 Property Taxes/Assessments (8.28) (56,143.71) GL 1090 02/22/2016 Property Taxes/Assessments (3.88) (56,147.59) GL 1091 02/23/2016 Property Taxes/Assessments (20.45) (56,168.04) GL 1094 02/24/2016 Property Taxes/Assessments (38.24) (56,206.28) GL 1095 02/25/2016 Property Taxes/Assessments (11.75) (56,218.03) GL 1096 02/26/2016 Property Taxes/Assessments (.81) (56,218.84) GL 1097 02/29/2016 Property Taxes/Assessments (58.34) (56,277.18) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (4,336.22) (56,277.18) ** (58,181.00) Budgeted (1,903.82) Remaining 97 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1072 02/03/2016 Property Taxes/Assessments (134.60) (140.22) (274.82) GL 1073 02/04/2016 Property Taxes/Assessments (.40) (275.22) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (140.62) (275.22) ** .00 Budgeted 275.22 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1071 02/02/2016 Property Taxes/Assessments (44.53) (.28) (44.81) GL 1072 02/03/2016 Property Taxes/Assessments (57.09) (101.90) GL 1073 02/04/2016 Property Taxes/Assessments (.10) (102.00) GL 1076 02/05/2016 Property Taxes/Assessments (.39) (102.39) GL 1081 02/09/2016 Property Taxes/Assessments (2.26) (104.65) GL 1082 02/10/2016 Property Taxes/Assessments (2.48) (107.13) GL 1083 02/11/2016 Property Taxes/Assessments (1.45) (108.58) GL 1085 02/12/2016 Property Taxes/Assessments (63.98) (172.56) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1086 02/16/2016 Property Taxes/Assessments (44.53) (.99) (173.55) GL 1087 02/17/2016 Property Taxes/Assessments (.52) (174.07) GL 1088 02/18/2016 Property Taxes/Assessments (.23) (174.30) GL 1089 02/19/2016 Property Taxes/Assessments (.56) (174.86) GL 1090 02/22/2016 Property Taxes/Assessments (.14) (175.00) GL 1091 02/23/2016 Property Taxes/Assessments (1.24) (176.24) GL 1094 02/24/2016 Property Taxes/Assessments (1.84) (178.08) GL 1095 02/25/2016 Property Taxes/Assessments (.82) (178.90) GL 1096 02/26/2016 Property Taxes/Assessments (.05) (178.95) GL 1097 02/29/2016 Property Taxes/Assessments (3.91) (182.86) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (138.33) (182.86) ** (650.00) Budgeted (467.14) Remaining 28 % Used Account: 135-40025-000-000 PID Surcharges (24,739.19) .00 (24,739.19) _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 (24,739.19) ** (146,125.00) Budgeted (121,385.81) Remaining 17 % Used Account: 135-47000-000-000 Water 1027 02/18/2016 UB 2/18/16 Account adjustment UB20160218-20160218 User: (1,135,337.45) 71.03 (1,135,266.42) UB 1019 02/29/2016 UB February billing UB20160229-20160229 User: (245,268.26) (1,380,534.68) UB _______________ Account: 135-47000-000-000 Water Totals: (245,197.23) (1,380,534.68) ** (5,080,244.00) Budgeted (3,699,709.32) Remaining 27 % Used Account: 135-47005-000-000 Sewer 1027 02/18/2016 UB 2/18/16 Account adjustment UB20160218-20160218 User: (667,052.61) 52.71 (666,999.90) UB 1019 02/29/2016 UB February billing UB20160229-20160229 User: (166,962.81) (833,962.71) UB _______________ Account: 135-47005-000-000 Sewer Totals: (166,910.10) (833,962.71) ** (2,413,776.00) Budgeted (1,579,813.29) Remaining 35 % Used Account: 135-47025-000-000 Penalties 998 02/23/2016 UB 2/23/16 Penalties UB20160223-20160223 User: (41,512.18) (5,297.44) (46,809.62) UB 1035 02/29/2016 UB 2/29/16 Penalties UB20160229-20160229 User: 125.98 (46,683.64) UB _______________ Account: 135-47025-000-000 Penalties Totals: (5,171.46) (46,683.64) ** (90,985.00) Budgeted (44,301.36) Remaining 51 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47030-000-000 Service Charges 884 02/09/2016 UB 2/09/2016 Cut off list UB20160209-20160209 User: (5,475.00) (900.00) (6,375.00) UB 1022 02/10/2016 UB 2/10/16 After Hours Fee UB20160210-20160210 User: (500.00) (6,875.00) UB 1023 02/10/2016 UB 2/10/16 NSF Check fee UB20160210-20160210 User: (25.00) (6,900.00) UB 1025 02/12/2016 UB 12/12/16 NSF Check fee UB20160212-20160212 User: (25.00) (6,925.00) UB 1032 02/23/2016 UB 2/23/16 NSF Check UB20160223-20160223 User: (25.00) (6,950.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,475.00) (6,950.00) ** (9,000.00) Budgeted (2,050.00) Remaining 77 % Used Account: 135-47035-000-000 Plumbing Inspections 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (1,350.00) (150.00) (1,500.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (1,500.00) ** (2,000.00) Budgeted (500.00) Remaining 75 % Used Account: 135-47045-000-000 Sewer Inspections 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (3,900.00) (450.00) (4,350.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (4,350.00) ** (5,500.00) Budgeted (1,150.00) Remaining 79 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1019 02/29/2016 UB February billing UB20160229-20160229 User: (6,013.00) (574.70) (6,587.70) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (574.70) (6,587.70) ** (61,330.00) Budgeted (54,742.30) Remaining 11 % Used Account: 135-48005-000-000 Utility Fees (55,200.00) .00 (55,200.00) _______________ Account: 135-48005-000-000 Utility Fees Totals: .00 (55,200.00) ** (69,000.00) Budgeted (13,800.00) Remaining 80 % Used Account: 135-49010-000-000 Interest Income 922 02/10/2016 Bank Analysis Fee- Jan & Feb Feb 16 Interest (3,420.72) (3.43) (3,424.15) GL 1100 02/29/2016 Bank Interest/Feb (656.08) (4,080.23) GL 1100 02/29/2016 Bank Interest/Feb (320.63) (4,400.86) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1100 02/29/2016 Bank Interest/Feb (3,420.72) (259.15) (4,660.01) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,239.29) (4,660.01) ** (6,000.00) Budgeted (1,339.99) Remaining 78 % Used Account: 135-49016-000-000 Cell Tower Revenue 943 02/08/2016 AT&T Cell Tower Revenue (3,642.12) (910.53) (4,552.65) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (4,552.65) ** (10,926.00) Budgeted (6,373.35) Remaining 42 % Used Account: 135-49018-000-000 Building Rent Income 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (2,333.32) (583.33) (2,916.65) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,916.65) ** (7,000.00) Budgeted (4,083.35) Remaining 42 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets (15,070.00) .00 (15,070.00) _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (15,070.00) ** .00 Budgeted 15,070.00 Remaining 0 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (8,020.00) Budgeted (8,020.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (24,015.80) (8,232.00) (32,247.80) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (8,232.00) (32,247.80) ** (15,778.00) Budgeted 16,469.80 Remaining 204 % Used Account: 135-49141-000-000 Interfund Transfer In (8,034.36) .00 (8,034.36) . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (8,034.36) ** .00 Budgeted 8,034.36 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1030 02/18/2016 UB 2/18/16 Credit adjustments UB20160218-20160218 User: (858.55) (.63) (859.18) UB 1046 02/19/2016 Lone Star Metals/stainless scr (144.45) (1,003.63) GL 1019 02/29/2016 UB February billing UB20160229-20160229 User: (82.37) (1,086.00) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (227.45) (1,086.00) ** (63,249.00) Budgeted (62,163.00) Remaining 2 % Used Account: 135-49901-000-000 Records Management Revenue (20.40) .00 (20.40) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (20.40) ** (20.00) Budgeted .40 Remaining 102 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,485,831.05) ** (8,047,784.00) Budgeted (5,561,952.95) Remaining 31 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 919 02/12/2016 MUD Payroll 2/12/16 Salaries & Wages 67,967.96 8,217.51 76,185.47 PR 994 02/26/2016 MUD Payroll 2/26/16 Salaries & Wages 8,207.76 84,393.23 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 16,425.27 84,393.23 ** 265,614.00 Budgeted 181,220.77 Remaining 32 % Used Account: 135-50010-010-000 Overtime 919 02/12/2016 MUD Payroll 2/12/16 Overtime 4,682.73 233.70 4,916.43 PR 994 02/26/2016 MUD Payroll 2/26/16 Overtime 437.65 5,354.08 PR _______________ Account: 135-50010-010-000 Overtime Totals: 671.35 5,354.08 ** 19,500.00 Budgeted 14,145.92 Remaining 27 % Used Account: 135-50016-010-000 Longevity 2,945.00 .00 2,945.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,945.00 ** 2,945.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 994 02/26/2016 MUD Payroll 2/26/16 Certification 725.00 200.00 925.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 925.00 ** 4,200.00 Budgeted 3,275.00 Remaining 22 % Used Account: 135-50020-010-000 Retirement 919 02/12/2016 MUD Payroll 2/12/16 Retirement 6,767.90 737.79 7,505.69 PR 994 02/26/2016 MUD Payroll 2/26/16 Retirement 772.20 8,277.89 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,509.99 8,277.89 ** 25,558.00 Budgeted 17,280.11 Remaining 32 % Used Account: 135-50026-010-000 Medical Insurance 919 02/12/2016 MUD Payroll 2/12/16 Medical Insurance 12,137.46 1,580.60 13,718.06 PR 994 02/26/2016 MUD Payroll 2/26/16 Medical Insurance 1,580.55 15,298.61 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,161.15 15,298.61 ** 51,398.00 Budgeted 36,099.39 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 919 02/12/2016 MUD Payroll 2/12/16 Dental Insurance 898.56 120.39 1,018.95 PR 994 02/26/2016 MUD Payroll 2/26/16 Dental Insurance 120.38 1,139.33 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 240.77 1,139.33 ** 3,999.00 Budgeted 2,859.67 Remaining 28 % Used Account: 135-50028-010-000 Vision Insurance 919 02/12/2016 MUD Payroll 2/12/16 Vision Insurance 203.28 27.01 230.29 PR 994 02/26/2016 MUD Payroll 2/26/16 Vision Insurance 26.97 257.26 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.98 257.26 ** 910.00 Budgeted 652.74 Remaining 28 % Used Account: 135-50029-010-000 Life Insurance & Other 741 02/01/2016 Feb A/P Feb Dental, Vision, Vol Life, 763.66 187.38 951.04 METLIFE GROUP BENEFITS 1432 AP 985 02/22/2016 Feb A/P Café 125 Adm charge/January 9.71 960.75 BenefitMall 1571 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 197.09 960.75 ** 2,803.00 Budgeted 1,842.25 Remaining 34 % Used Account: 135-50030-010-000 Social Security Taxes 919 02/12/2016 MUD Payroll 2/12/16 Social Security Taxes 4,691.15 519.53 5,210.68 PR 994 02/26/2016 MUD Payroll 2/26/16 Social Security Taxes 542.70 5,753.38 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,062.23 5,753.38 ** 18,565.00 Budgeted 12,811.62 Remaining 31 % Used Account: 135-50035-010-000 Medicare Taxes 919 02/12/2016 MUD Payroll 2/12/16 Medicare Taxes 1,097.10 121.50 1,218.60 PR 994 02/26/2016 MUD Payroll 2/26/16 Medicare Taxes 126.93 1,345.53 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 248.43 1,345.53 ** 4,341.00 Budgeted 2,995.47 Remaining 31 % Used Account: 135-50040-010-000 Unemployment Taxes 919 02/12/2016 MUD Payroll 2/12/16 Unemployment Taxes 22.00 8.45 30.45 PR 994 02/26/2016 MUD Payroll 2/26/16 Unemployment Taxes 6.65 37.10 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 15.10 37.10 ** 1,242.00 Budgeted 1,204.90 Remaining 3 % Used Account: 135-50045-010-000 Workman's Compensation 136 02/01/2016 Prepaid Insurance, W/C Feb 2,602.88 1,229.35 3,832.23 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,229.35 3,832.23 ** 14,754.00 Budgeted 10,921.77 Remaining 26 % 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 1074 02/29/2016 Feb A/P WWTP Town Permitting 5,640.00 7,755.00 13,395.00 THE WALLACE GROUP, INC. 1647 AP _______________ Account: 135-55005-010-000 Engineering Totals: 7,755.00 13,395.00 ** 5,000.00 Budgeted (8,395.00) Remaining 268 % Used Account: 135-55080-010-000 Maintenance & Repairs 911 02/09/2016 VOID FOR BANK CHANGE 42,964.42 (750.00) 42,214.42 GREAT SOUTHWEST METERS INC 35071 AP 921 02/09/2016 CHECK CASHED BEFORE ACCT CLOSD 750.00 42,964.42 GREAT SOUTHWEST METERS INC 35071 AP 936 02/12/2016 February A/P Well #2 6,948.00 49,912.42 MILLICAN WELL SERVICE, LLC 1524 AP 1066 02/26/2016 PCards 1/27/16-2/26/16 ROANOKE AUTO SUPPLY LT 124.00 50,036.42 ROANOKE AUTO SUPPLY LT PC 1066 02/26/2016 PCards 1/27/16-2/26/16 MACARTHUR GAUGE INC 50.00 50,086.42 MACARTHUR GAUGE INC PC 1066 02/26/2016 PCards 1/27/16-2/26/16 THE HOME DEPOT 6581 19.90 50,106.32 THE HOME DEPOT 6581 PC 1074 02/29/2016 Feb A/P Nitrogen bottle 6mo lease 42.00 50,148.32 ALLIED WELDING SUPPLY, INC 1598 AP 1074 02/29/2016 Feb A/P 1" meter spuds 803.40 50,951.72 HD SUPPLY WATERWORKS, LTD. 1615 AP 1074 02/29/2016 Feb A/P 100 ft 1" poly pipe 36.00 50,987.72 HD SUPPLY WATERWORKS, LTD. 1615 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1125 02/29/2016 Feb A/P Concrete/212 Skyline 42,964.42 346.00 51,333.72 LATTIMORE MATERIALS CO 1660 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 8,369.30 51,333.72 ** 85,000.00 Budgeted 33,666.28 Remaining 60 % Used Account: 135-55090-010-000 Vehicle Maintenance 1066 02/26/2016 PCards 1/27/16-2/26/16 7-11 STORE 32921 2,770.22 8.00 2,778.22 7-11 STORE 32921 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 DENTON CNTY VEHREG 15.25 2,793.47 DENTON CNTY VEHREG PC 1066 02/26/2016 PCards 1/27/16-2/26/16 DENTON CO TX MOTOR VEH 1.00 2,794.47 DENTON CO TX MOTOR VEH PC 1066 02/26/2016 PCards 1/27/16-2/26/16 DENTON CO TX MOTOR VEH 16.75 2,811.22 DENTON CO TX MOTOR VEH PC 1066 02/26/2016 PCards 1/27/16-2/26/16 AUTO RENEWAL STICK 2.00 2,813.22 AUTO RENEWAL STICK PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 43.00 2,813.22 ** 8,000.00 Budgeted 5,186.78 Remaining 35 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 986 02/22/2016 Feb A/P Forks for Backhoe 142.45 198.00 340.45 HOLT CAT 1578 AP 1066 02/26/2016 PCards 1/27/16-2/26/16 ROANOKE AUTO SUPPLY LT 93.77 434.22 ROANOKE AUTO SUPPLY LT PC 1074 02/29/2016 Feb A/P Bal due freight backhoe forks 50.00 484.22 HOLT CAT 1617 AP _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 341.77 484.22 ** 3,500.00 Budgeted 3,015.78 Remaining 14 % Used Account: 135-55135-010-000 Lab Analysis 1125 02/29/2016 Feb A/P TCEQ Samples-MUD 1,262.70 431.47 1,694.17 LOWER COLORADO RIVER AUTHORITY 1662 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 431.47 1,694.17 ** 5,500.00 Budgeted 3,805.83 Remaining 31 % Used Account: 135-60010-010-000 Communications/Mobiles 1074 02/29/2016 Feb A/P Cells 1,489.95 347.05 1,837.00 VERIZON WIRELESS 1651 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 347.05 1,837.00 ** 5,400.00 Budgeted 3,563.00 Remaining 34 % Used Account: 135-60020-010-000 Electricity 935 02/12/2016 February A/P Elec 1/9/16-2/9/16 39,874.66 95.53 39,970.19 HUDSON ENERGY SERVICES, LLC 1508 AP 985 02/22/2016 Feb A/P Electricity 1/11/16-2/10/16 56.37 40,026.56 HUDSON ENERGY SERVICES, LLC 1579 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 985 02/22/2016 Feb A/P Electricity 1/11/6-2/10/16 39,874.66 9,658.75 49,685.31 HUDSON ENERGY SERVICES, LLC 1579 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,810.65 49,685.31 ** 166,823.00 Budgeted 117,137.69 Remaining 30 % 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 935 02/12/2016 February A/P CDL Medical Waiver fee 11.00 11.00 Paul Sayre 1531 AP _______________ Account: 135-60070-010-000 Dues & Memberships Totals: 11.00 11.00 ** 500.00 Budgeted 489.00 Remaining 2 % Used Account: 135-60080-010-000 Schools & Training 1066 02/26/2016 PCards 1/27/16-2/26/16 TRWA 00 OF 00 835.00 240.00 1,075.00 TRWA 00 OF 00 PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 240.00 1,075.00 ** 5,773.00 Budgeted 4,698.00 Remaining 19 % Used Account: 135-60090-010-000 Safety Program 248.97 .00 248.97 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 248.97 ** 400.00 Budgeted 151.03 Remaining 62 % Used Account: 135-60100-010-000 Travel & per diem 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 Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 10,501.40 .00 10,501.40 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 10,501.40 ** 49,275.00 Budgeted 38,773.60 Remaining 21 % Used Account: 135-60150-010-000 Wholesale Water 1074 02/29/2016 Feb A/P Wholesale Water 464,297.51 122,971.57 587,269.08 CITY OF FORT WORTH 1603 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 122,971.57 587,269.08 ** 2,948,742.00 Budgeted 2,361,472.92 Remaining 20 % 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 1066 02/26/2016 PCards 1/27/16-2/26/16 TEX-TURF 1,026.49 70.74 1,097.23 TEX-TURF PC 1066 02/26/2016 PCards 1/27/16-2/26/16 DENTON SAND & GRAVEL, 84.00 1,181.23 DENTON SAND & GRAVEL, PC 1066 02/26/2016 PCards 1/27/16-2/26/16 DENTON SAND & GRAVEL, 84.00 1,265.23 DENTON SAND & GRAVEL, PC 1066 02/26/2016 PCards 1/27/16-2/26/16 TRACTOR SUPPLY COMPANY 193.90 1,459.13 TRACTOR SUPPLY COMPANY PC 1066 02/26/2016 PCards 1/27/16-2/26/16 THE HOME DEPOT 6581 24.90 1,484.03 THE HOME DEPOT 6581 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 THE HOME DEPOT 6581 5.82 1,489.85 THE HOME DEPOT 6581 PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 463.36 1,489.85 ** 3,500.00 Budgeted 2,010.15 Remaining 43 % 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 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-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 894 02/09/2016 VOID FOR BANK CHANGE 5,272.61 (27.70) 5,244.91 SYN-TECH SYSTEMS, INC 32148 AP 935 02/12/2016 February A/P Disposal of used oil 109.00 5,353.91 DFW Waste Oil Service, Inc 1498 AP 980 02/22/2016 Replace lost outstanding cks Replace lost Check 32148 27.70 5,381.61 SYN-TECH SYSTEMS, INC 1567 AP 1066 02/26/2016 PCards 1/27/16-2/26/16 SHELL OIL 575409723QPS 38.58 5,420.19 SHELL OIL 575409723QPS PC 1066 02/26/2016 PCards 1/27/16-2/26/16 7-ELEVEN 32921 42.37 5,462.56 7-ELEVEN 32921 PC 1074 02/29/2016 Feb A/P High service pump oil 907.35 6,369.91 LUBRICATION ENGINEERS, INC 1628 AP 1074 02/29/2016 Feb A/P 1/25/16-2/24/16 Fuel purchases 566.79 6,936.70 US Bank Voyager Fleet Systems 1650 AP 1074 02/29/2016 Feb A/P Oil change F350 80.56 7,017.26 TWO WILSONS INDUSTRIES, INC 1649 AP 1074 02/29/2016 Feb A/P Oil change 2011 F150 43.08 7,060.34 TWO WILSONS INDUSTRIES, INC 1649 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,787.73 7,060.34 ** 35,947.00 Budgeted 28,886.66 Remaining 20 % Used Account: 135-65010-010-000 Uniforms 1066 02/26/2016 PCards 1/27/16-2/26/16 RED WING SHOES #652 1,845.24 161.49 2,006.73 RED WING SHOES #652 PC _______________ Account: 135-65010-010-000 Uniforms Totals: 161.49 2,006.73 ** 4,608.00 Budgeted 2,601.27 Remaining 44 % Used Account: 135-65030-010-000 Chemicals 985 02/22/2016 Feb A/P Chemicals 4,174.63 737.59 4,912.22 HACH COMPANY 1577 AP 1074 02/29/2016 Feb A/P Flask for testing 21.85 4,934.07 HACH COMPANY 1614 AP 1074 02/29/2016 Feb A/P Chlorine 423.76 5,357.83 DPC INDUSTRIES, INC 1607 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,183.20 5,357.83 ** 12,000.00 Budgeted 6,642.17 Remaining 45 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65040-010-000 Safety Equipment 187.99 .00 187.99 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 187.99 ** 1,000.00 Budgeted 812.01 Remaining 19 % Used Account: 135-65050-010-000 Meter Expense 935 02/12/2016 February A/P Meters 18,805.34 4,500.00 23,305.34 ATLAS UTILITY SUPPLY CO. 1484 AP 985 02/22/2016 Feb A/P Meters for Wonderland Plaza 8,710.44 32,015.78 ATLAS UTILITY SUPPLY CO. 1570 AP 985 02/22/2016 Feb A/P Meter heads 1,700.00 33,715.78 ATLAS UTILITY SUPPLY CO. 1570 AP 985 02/22/2016 Feb A/P Meter heads 170.00 33,885.78 ATLAS UTILITY SUPPLY CO. 1570 AP 1047 02/24/2016 Wonderland Plaza/Meters (8,880.44) 25,005.34 GL 1074 02/29/2016 Feb A/P 1" meters 62,000.00 87,005.34 ATLAS UTILITY SUPPLY CO. 1599 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 68,200.00 87,005.34 ** 115,000.00 Budgeted 27,994.66 Remaining 76 % Used Account: 135-65053-010-000 Meter Change Out Program 985 02/22/2016 Feb A/P 5/8" meters and profile heads 44,700.00 32,625.00 77,325.00 ATLAS UTILITY SUPPLY CO. 1570 AP _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: 32,625.00 77,325.00 ** 50,000.00 Budgeted (27,325.00) Remaining 155 % Used Account: 135-69005-010-000 Capital Outlays 954 02/01/2016 McClendon App 5/Retainage 62,025.85 6,014.38 68,040.23 GL 935 02/12/2016 February A/P Pin Oak Court 54,129.38 122,169.61 MCCLENDON CONSTRUCTION CO INC 1520 AP 936 02/12/2016 February A/P Mobilize & expose 8" valve & r 5,894.03 128,063.64 REY-MAR CONSTRUCTION 1533 AP 985 02/22/2016 Feb A/P 2016 Dodge Ram 1500 Quad Cab 23,894.00 151,957.64 Grapevine Dodge Chrysler Jeep 1576 AP 985 02/22/2016 Feb A/P New Backhoe 62,856.16 214,813.80 HOLT CAT 1578 AP 1074 02/29/2016 Feb A/P Decals/Truck 109 55.00 214,868.80 M-KAM LTD. 1629 AP 1074 02/29/2016 Feb A/P Lights for Truck 109 769.00 215,637.80 PROFESSIONAL SAFETY SYSTEMS 1638 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 153,611.95 215,637.80 ** 201,000.00 Budgeted (14,637.80) Remaining 107 % Used Account: 135-69008-010-000 Short Term Debt-Principal 985 02/22/2016 Feb A/P Final payment 445K note 130,700.34 130,700.34 FIRST FINANCIAL BANK 1573 AP _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: 130,700.34 130,700.34 ** 130,720.00 Budgeted 19.66 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69009-010-000 Short Term Debt-Interest 985 02/22/2016 Feb A/P Final payment 445K note 1,222.40 1,222.40 FIRST FINANCIAL BANK 1573 AP _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: 1,222.40 1,222.40 ** 1,209.00 Budgeted (13.40) Remaining 101 % 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 118,774.42 .00 118,774.42 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 118,774.42 ** 126,958.00 Budgeted 8,183.58 Remaining 94 % Used Account: 135-55135-010-001 Lab Analysis for PID 1125 02/29/2016 Feb A/P TCEQ Samples-PID 320.00 207.70 527.70 LOWER COLORADO RIVER AUTHORITY 1662 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 207.70 527.70 ** 5,000.00 Budgeted 4,472.30 Remaining 11 % 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: ------------------------------------------------------------------------------------------------ 1,573,413.92 ** 4,475,834.00 Budgeted 2,902,420.08 Remaining 35 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 919 02/12/2016 MUD Payroll 2/12/16 Salaries & Wages 111,247.77 14,279.62 125,527.39 PR 994 02/26/2016 MUD Payroll 2/26/16 Salaries & Wages 14,222.79 139,750.18 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 28,502.41 139,750.18 ** 351,671.00 Budgeted 211,920.82 Remaining 40 % Used Account: 135-50010-020-000 Overtime 919 02/12/2016 MUD Payroll 2/12/16 Overtime 9,536.78 1,581.09 11,117.87 PR 994 02/26/2016 MUD Payroll 2/26/16 Overtime 2,223.70 13,341.57 PR _______________ Account: 135-50010-020-000 Overtime Totals: 3,804.79 13,341.57 ** 19,500.00 Budgeted 6,158.43 Remaining 68 % Used Account: 135-50016-020-000 Longevity 6,125.00 .00 6,125.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,125.00 ** 6,125.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 994 02/26/2016 MUD Payroll 2/26/16 Certification 2,350.00 625.00 2,975.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 625.00 2,975.00 ** 7,200.00 Budgeted 4,225.00 Remaining 41 % Used Account: 135-50020-020-000 Retirement 919 02/12/2016 MUD Payroll 2/12/16 Retirement 11,459.89 1,384.63 12,844.52 PR 994 02/26/2016 MUD Payroll 2/26/16 Retirement 1,490.35 14,334.87 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,874.98 14,334.87 ** 33,652.00 Budgeted 19,317.13 Remaining 43 % Used Account: 135-50026-020-000 Medical Insurance 919 02/12/2016 MUD Payroll 2/12/16 Medical Insurance 19,668.78 2,765.99 22,434.77 PR 994 02/26/2016 MUD Payroll 2/26/16 Medical Insurance 2,765.98 25,200.75 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,531.97 25,200.75 ** 65,989.00 Budgeted 40,788.25 Remaining 38 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 919 02/12/2016 MUD Payroll 2/12/16 Dental Insurance 1,162.53 173.97 1,336.50 PR 994 02/26/2016 MUD Payroll 2/26/16 Dental Insurance 173.94 1,510.44 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 347.91 1,510.44 ** 4,184.00 Budgeted 2,673.56 Remaining 36 % Used Account: 135-50028-020-000 Vision Insurance 919 02/12/2016 MUD Payroll 2/12/16 Vision Insurance 266.70 39.05 305.75 PR 994 02/26/2016 MUD Payroll 2/26/16 Vision Insurance 39.00 344.75 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 78.05 344.75 ** 972.00 Budgeted 627.25 Remaining 35 % Used Account: 135-50029-020-000 Life Insurance & Other 741 02/01/2016 Feb A/P Feb Dental, Vision, Vol Life, 1,277.06 322.90 1,599.96 METLIFE GROUP BENEFITS 1432 AP 985 02/22/2016 Feb A/P Café 125 Adm charge/January 29.13 1,629.09 BenefitMall 1571 AP 985 02/22/2016 Feb A/P Balance due December Café 125 4.00 1,633.09 BenefitMall 1571 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 356.03 1,633.09 ** 3,655.00 Budgeted 2,021.91 Remaining 45 % Used Account: 135-50030-020-000 Social Security Taxes 919 02/12/2016 MUD Payroll 2/12/16 Social Security Taxes 7,369.49 894.55 8,264.04 PR 994 02/26/2016 MUD Payroll 2/26/16 Social Security Taxes 947.38 9,211.42 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,841.93 9,211.42 ** 24,665.00 Budgeted 15,453.58 Remaining 37 % Used Account: 135-50035-020-000 Medicare Taxes 919 02/12/2016 MUD Payroll 2/12/16 Medicare Taxes 1,723.47 209.22 1,932.69 PR 994 02/26/2016 MUD Payroll 2/26/16 Medicare Taxes 221.57 2,154.26 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 430.79 2,154.26 ** 5,768.00 Budgeted 3,613.74 Remaining 37 % Used Account: 135-50040-020-000 Unemployment Taxes 919 02/12/2016 MUD Payroll 2/12/16 Unemployment Taxes 38.30 15.88 54.18 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 994 02/26/2016 MUD Payroll 2/26/16 Unemployment Taxes 38.30 11.94 66.12 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 27.82 66.12 ** 1,449.00 Budgeted 1,382.88 Remaining 5 % Used Account: 135-50045-020-000 Workman's Compensation 136 02/01/2016 Prepaid Insurance, W/C Feb 791.23 776.43 1,567.66 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 776.43 1,567.66 ** 9,317.00 Budgeted 7,749.34 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 1066 02/26/2016 PCards 1/27/16-2/26/16 DICKEYS TX094 117.88 117.88 DICKEYS TX094 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 MR. JIM S PIZZA #148 63.00 180.88 MR. JIM S PIZZA #148 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 180.88 180.88 ** 650.00 Budgeted 469.12 Remaining 28 % 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 982 02/22/2016 Feb A/P 24" SS line repair 16,044.89 10,209.23 26,254.12 REY-MAR CONSTRUCTION 1569 AP 1066 02/26/2016 PCards 1/27/16-2/26/16 THE HOME DEPOT 6581 84.69 26,338.81 THE HOME DEPOT 6581 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 THE HOME DEPOT 6581 27.18 26,365.99 THE HOME DEPOT 6581 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 THE HOME DEPOT 6581 7.97 26,373.96 THE HOME DEPOT 6581 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 BEST BUY 00001487 149.98 26,523.94 BEST BUY 00001487 PC 1074 02/29/2016 Feb A/P Lake A Replace with 10hp pump 5,788.23 32,312.17 NORTH TEXAS PUMP CO. 1634 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 16,267.28 32,312.17 ** 72,600.00 Budgeted 40,287.83 Remaining 45 % Used Account: 135-55090-020-000 Vehicle Maintenance 1066 02/26/2016 PCards 1/27/16-2/26/16 MUSTANG ELITE CAR 385.88 61.50 447.38 MUSTANG ELITE CAR PC 1066 02/26/2016 PCards 1/27/16-2/26/16 GREEN EQUIPMENT CO 782.00 1,229.38 GREEN EQUIPMENT CO PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 843.50 1,229.38 ** 5,000.00 Budgeted 3,770.62 Remaining 25 % 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 1074 02/29/2016 Feb A/P Sludge haul off 9,193.61 909.22 10,102.83 L.H. CHANEY MATERIALS, INC. 1622 AP 1074 02/29/2016 Feb A/P Sludge haul off 735.57 10,838.40 L.H. CHANEY MATERIALS, INC. 1622 AP 1074 02/29/2016 Feb A/P Sludge haul off 512.49 11,350.89 L.H. CHANEY MATERIALS, INC. 1622 AP 1125 02/29/2016 Feb A/P Sludge haul off 2,392.62 13,743.51 L.H. CHANEY MATERIALS, INC. 1659 AP 1125 02/29/2016 Feb A/P Sludge Haul off 958.65 14,702.16 L.H. CHANEY MATERIALS, INC. 1659 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 5,508.55 14,702.16 ** 55,000.00 Budgeted 40,297.84 Remaining 27 % Used Account: 135-55135-020-000 Lab Analysis 940 02/12/2016 Feb A/P Testing 9,848.00 246.00 10,094.00 OXIDOR LABORATORIES LLC 1582 AP 940 02/12/2016 Feb A/P Annual Sludge Testing 1,357.50 11,451.50 OXIDOR LABORATORIES LLC 1582 AP 1074 02/29/2016 Feb A/P Testing 246.00 11,697.50 OXIDOR LABORATORIES LLC 1636 AP 1074 02/29/2016 Feb A/P Testing 246.00 11,943.50 OXIDOR LABORATORIES LLC 1636 AP 1074 02/29/2016 Feb A/P Testing 176.00 12,119.50 OXIDOR LABORATORIES LLC 1636 AP 1074 02/29/2016 Feb A/P Testing 246.00 12,365.50 OXIDOR LABORATORIES LLC 1636 AP 1125 02/29/2016 Feb A/P Testing 176.00 12,541.50 OXIDOR LABORATORIES LLC 1665 AP 1125 02/29/2016 Feb A/P Testing 290.00 12,831.50 OXIDOR LABORATORIES LLC 1665 AP 1125 02/29/2016 Feb A/P Testing 359.27 13,190.77 IDEXX DISTRIBUTION, INC 1658 AP 1125 02/29/2016 Feb A/P Bio-monitoring 1,080.00 14,270.77 HUTHER AND ASSOCIATES,INC 1657 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55135-020-000 Lab Analysis Totals: 4,422.77 14,270.77 ** 35,000.00 Budgeted 20,729.23 Remaining 41 % Used Account: 135-60010-020-000 Communications/Mobiles 1074 02/29/2016 Feb A/P Cells 1,911.41 544.56 2,455.97 VERIZON WIRELESS 1651 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 544.56 2,455.97 ** 5,400.00 Budgeted 2,944.03 Remaining 45 % Used Account: 135-60020-020-000 Electricity 935 02/12/2016 February A/P Elec 1/9/16-2/9/16 35,908.26 64.98 35,973.24 HUDSON ENERGY SERVICES, LLC 1508 AP 935 02/12/2016 February A/P Elec 1/9/16-2/9/16 46.23 36,019.47 HUDSON ENERGY SERVICES, LLC 1508 AP 935 02/12/2016 February A/P Elec 1/11/16-2/10/16 95.87 36,115.34 HUDSON ENERGY SERVICES, LLC 1508 AP 1074 02/29/2016 Feb A/P Electricity 1/11-2/10/16 614.32 36,729.66 HUDSON ENERGY SERVICES, LLC 1618 AP 1074 02/29/2016 Feb A/P Electricity 1/11-2/10/16 9,950.69 46,680.35 HUDSON ENERGY SERVICES, LLC 1618 AP 1074 02/29/2016 Feb A/P Electricity 1/11/16-2/10/16 324.26 47,004.61 MP2 ENERGY TEXAS LLC 1631 AP 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (623.76) 46,380.85 AR 1125 02/29/2016 Feb A/P Elec 1/27-2/26/16 162.16 46,543.01 TRI COUNTY ELECTRIC 1670 AP 1125 02/29/2016 Feb A/P Elec 1/27-2/26/16 27.69 46,570.70 TRI COUNTY ELECTRIC 1670 AP 1125 02/29/2016 Feb A/P Elec 1/27-2/26/16 256.90 46,827.60 TRI COUNTY ELECTRIC 1670 AP _______________ Account: 135-60020-020-000 Electricity Totals: 10,919.34 46,827.60 ** 161,582.00 Budgeted 114,754.40 Remaining 29 % 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 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 899 02/09/2016 VOID FOR BANK CHANGE 830.00 (30.00) 800.00 Fort Worth Water Department 33674 AP 980 02/22/2016 Replace lost outstanding cks Replace lost check # 33674 30.00 830.00 Fort Worth Water Dept 1550 AP _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 830.00 ** 3,771.00 Budgeted 2,941.00 Remaining 22 % Used Account: 135-60090-020-000 Safety Program 192.79 .00 192.79 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 192.79 ** 550.00 Budgeted 357.21 Remaining 35 % Used Account: 135-60100-020-000 Travel & per diem 897 02/09/2016 VOID FOR BANK CHANGE 761.28 (11.48) 749.80 NTTA 33642 AP 945 02/12/2016 L Holt/Reimb Travel Advance (136.93) 612.87 GL 980 02/22/2016 Replace lost outstanding cks Replace lost check # 33642 11.48 624.35 NTTA 1561 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: (136.93) 624.35 ** 1,600.00 Budgeted 975.65 Remaining 39 % 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 1007 02/26/2016 February A/P Water Quality Permit WW WQ0011 9,439.28 2,015.00 11,454.28 TX COMMISSION ENVIRONMENTAL QU 1589 AP 1074 02/29/2016 Feb A/P WWTP Permit Renewal Applicatio 3,905.00 15,359.28 THE WALLACE GROUP, INC. 1647 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 5,920.00 15,359.28 ** 37,150.00 Budgeted 21,790.72 Remaining 41 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S .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 879 02/04/2016 O&M to Rev Bond I&S/Int pmt 117,618.75 117,618.75 GL 1028 02/18/2016 Texpool xfer to Rev Bond I&S 67,896.85 185,515.60 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 185,515.60 185,515.60 ** 444,831.00 Budgeted 259,315.40 Remaining 42 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 61,668.00 .00 61,668.00 _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: .00 61,668.00 ** 123,336.00 Budgeted 61,668.00 Remaining 50 % Used Account: 135-65005-020-000 Fuel & Lube 1074 02/29/2016 Feb A/P 1/25/16-2/24/16 Fuel purchases 4,819.71 568.31 5,388.02 US Bank Voyager Fleet Systems 1650 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 568.31 5,388.02 ** 32,021.00 Budgeted 26,632.98 Remaining 17 % Used Account: 135-65010-020-000 Uniforms 1066 02/26/2016 PCards 1/27/16-2/26/16 ACADEMY SPORTS #81 2,483.54 19.99 2,503.53 ACADEMY SPORTS #81 PC _______________ Account: 135-65010-020-000 Uniforms Totals: 19.99 2,503.53 ** 4,241.00 Budgeted 1,737.47 Remaining 59 % Used Account: 135-65030-020-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1066 02/26/2016 PCards 1/27/16-2/26/16 THE HOME DEPOT 6581 10,658.27 69.98 10,728.25 THE HOME DEPOT 6581 PC 1125 02/29/2016 Feb A/P Polymer for belt press 1,080.00 11,808.25 POLYDYNE, INC 1667 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 1,149.98 11,808.25 ** 27,000.00 Budgeted 15,191.75 Remaining 44 % Used Account: 135-65035-020-000 Small Tools 1066 02/26/2016 PCards 1/27/16-2/26/16 PRYOR TOOLS INC 50.40 110.19 160.59 PRYOR TOOLS INC PC 1066 02/26/2016 PCards 1/27/16-2/26/16 THE HOME DEPOT 6581 59.91 220.50 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 170.10 220.50 ** 2,000.00 Budgeted 1,779.50 Remaining 11 % Used Account: 135-65040-020-000 Safety Equipment 576.59 .00 576.59 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 576.59 ** 750.00 Budgeted 173.41 Remaining 77 % Used Account: 135-65045-020-000 Lab Supplies 1125 02/29/2016 Feb A/P Gloves 4,825.31 162.00 4,987.31 LOU'S GLOVES INCORPORATED 1661 AP 1125 02/29/2016 Feb A/P Calibrate MCC 301.84 5,289.15 METTLER TOLEDO INTERNATIONAL 1663 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 463.84 5,289.15 ** 13,000.00 Budgeted 7,710.85 Remaining 41 % Used Account: 135-69005-020-000 Capital Outlays 935 02/12/2016 February A/P Lift Sta 3 & 5 Scada upgrade 24,198.75 9,000.00 33,198.75 DHS AUTOMATION, INC 1499 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 9,000.00 33,198.75 ** 150,000.00 Budgeted 116,801.25 Remaining 22 % Used Account: 135-69008-020-000 Short Term Debt-Principal 985 02/22/2016 Feb A/P Final payment 445K note 21,276.80 21,276.80 FIRST FINANCIAL BANK 1573 AP _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: 21,276.80 21,276.80 ** 21,280.00 Budgeted 3.20 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69009-020-000 Short Term Debt-Interest 985 02/22/2016 Feb A/P Final payment 445K note 199.00 199.00 FIRST FINANCIAL BANK 1573 AP _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: 199.00 199.00 ** 197.00 Budgeted (2.00) Remaining 101 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 675,083.10 ** 1,912,109.00 Budgeted 1,237,025.90 Remaining 35 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 919 02/12/2016 MUD Payroll 2/12/16 Salaries & Wages 2,100.00 500.00 2,600.00 PR 994 02/26/2016 MUD Payroll 2/26/16 Salaries & Wages 500.00 3,100.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,000.00 3,100.00 ** 12,500.00 Budgeted 9,400.00 Remaining 25 % Used Account: 135-50030-026-000 Social Security Taxes 919 02/12/2016 MUD Payroll 2/12/16 Social Security Taxes 130.20 31.00 161.20 PR 994 02/26/2016 MUD Payroll 2/26/16 Social Security Taxes 31.00 192.20 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 62.00 192.20 ** 775.00 Budgeted 582.80 Remaining 25 % Used Account: 135-50035-026-000 Medicare Taxes 919 02/12/2016 MUD Payroll 2/12/16 Medicare Taxes 30.45 7.25 37.70 PR 994 02/26/2016 MUD Payroll 2/26/16 Medicare Taxes 7.25 44.95 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 14.50 44.95 ** 181.00 Budgeted 136.05 Remaining 25 % Used Account: 135-50040-026-000 Unemployment Taxes 919 02/12/2016 MUD Payroll 2/12/16 Unemployment Taxes 2.10 .50 2.60 PR 994 02/26/2016 MUD Payroll 2/26/16 Unemployment Taxes .50 3.10 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.00 3.10 ** 230.00 Budgeted 226.90 Remaining 1 % Used Account: 135-50045-026-000 Workman's Compensation 136 02/01/2016 Prepaid Insurance, W/C Feb 25.33 3.08 28.41 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 3.08 28.41 ** 37.00 Budgeted 8.59 Remaining 77 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships 1066 02/26/2016 PCards 1/27/16-2/26/16 OFFICE DEPOT #406 10.98 10.98 OFFICE DEPOT #406 PC _______________ Account: 135-60070-026-000 Dues & Memberships Totals: 10.98 10.98 ** 500.00 Budgeted 489.02 Remaining 2 % Used Account: 135-60075-026-000 Meetings 6.00 .00 6.00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 6.00 ** 1,200.00 Budgeted 1,194.00 Remaining 1 % Used Account: 135-60080-026-000 Schools & Training 550.00 .00 550.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 550.00 ** 4,000.00 Budgeted 3,450.00 Remaining 14 % Used Account: 135-60100-026-000 Travel & per diem 935 02/12/2016 February A/P AWBD Expenses 718.54 816.19 1,534.73 Neil Twomey 1526 AP 985 02/22/2016 Feb A/P Bal Due-AWBD Expenses 67.70 1,602.43 KEVIN CARR 1580 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 883.89 1,602.43 ** 5,000.00 Budgeted 3,397.57 Remaining 32 % 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: ------------------------------------------------------------------------------------------------ 5,588.55 ** 26,573.00 Budgeted 20,984.45 Remaining 21 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 919 02/12/2016 MUD Payroll 2/12/16 Salaries & Wages 152,766.90 18,632.51 171,399.41 PR 994 02/26/2016 MUD Payroll 2/26/16 Salaries & Wages 18,642.79 190,042.20 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 37,275.30 190,042.20 ** 488,508.00 Budgeted 298,465.80 Remaining 39 % Used Account: 135-50010-030-000 Overtime 919 02/12/2016 MUD Payroll 2/12/16 Overtime 110.62 2.65 113.27 PR 994 02/26/2016 MUD Payroll 2/26/16 Overtime 14.33 127.60 PR _______________ Account: 135-50010-030-000 Overtime Totals: 16.98 127.60 ** 1,000.00 Budgeted 872.40 Remaining 13 % Used Account: 135-50016-030-000 Longevity 3,822.50 .00 3,822.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,822.50 ** 3,823.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 919 02/12/2016 MUD Payroll 2/12/16 Retirement 13,894.86 1,626.86 15,521.72 PR 994 02/26/2016 MUD Payroll 2/26/16 Retirement 1,628.75 17,150.47 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,255.61 17,150.47 ** 43,202.00 Budgeted 26,051.53 Remaining 40 % Used Account: 135-50026-030-000 Medical Insurance 919 02/12/2016 MUD Payroll 2/12/16 Medical Insurance 19,974.35 2,655.37 22,629.72 PR 994 02/26/2016 MUD Payroll 2/26/16 Medical Insurance 2,655.35 25,285.07 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,310.72 25,285.07 ** 68,196.00 Budgeted 42,910.93 Remaining 37 % Used Account: 135-50027-030-000 Dental Insurance 919 02/12/2016 MUD Payroll 2/12/16 Dental Insurance 1,326.62 189.41 1,516.03 PR 994 02/26/2016 MUD Payroll 2/26/16 Dental Insurance 189.38 1,705.41 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 378.79 1,705.41 ** 4,807.00 Budgeted 3,101.59 Remaining 35 % Used Account: 135-50028-030-000 Vision Insurance 919 02/12/2016 MUD Payroll 2/12/16 Vision Insurance 306.77 43.60 350.37 PR 994 02/26/2016 MUD Payroll 2/26/16 Vision Insurance 43.54 393.91 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 87.14 393.91 ** 1,114.00 Budgeted 720.09 Remaining 35 % Used Account: 135-50029-030-000 Life Insurance & Other 741 02/01/2016 Feb A/P Feb Dental, Vision, Vol Life, 1,536.63 363.39 1,900.02 METLIFE GROUP BENEFITS 1432 AP 985 02/22/2016 Feb A/P Café 125 Adm charge/January 29.16 1,929.18 BenefitMall 1571 AP 985 02/22/2016 Feb A/P Balance due December Café 125 4.00 1,933.18 BenefitMall 1571 AP 1103 02/29/2016 Clear Ins/Rounding Feb (.26) 1,932.92 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 396.29 1,932.92 ** 4,431.00 Budgeted 2,498.08 Remaining 44 % Used Account: 135-50030-030-000 Social Security Taxes 919 02/12/2016 MUD Payroll 2/12/16 Social Security Taxes 9,123.94 1,068.43 10,192.37 PR 994 02/26/2016 MUD Payroll 2/26/16 Social Security Taxes 1,057.59 11,249.96 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,126.02 11,249.96 ** 30,823.00 Budgeted 19,573.04 Remaining 36 % Used Account: 135-50035-030-000 Medicare Taxes 919 02/12/2016 MUD Payroll 2/12/16 Medicare Taxes 2,133.81 249.88 2,383.69 PR 994 02/26/2016 MUD Payroll 2/26/16 Medicare Taxes 247.34 2,631.03 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 497.22 2,631.03 ** 7,599.00 Budgeted 4,967.97 Remaining 35 % Used Account: 135-50040-030-000 Unemployment Taxes 919 02/12/2016 MUD Payroll 2/12/16 Unemployment Taxes 37.19 12.07 49.26 PR 994 02/26/2016 MUD Payroll 2/26/16 Unemployment Taxes 4.60 53.86 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 16.67 53.86 ** 1,449.00 Budgeted 1,395.14 Remaining 4 % Used Account: 135-50045-030-000 Workman's Compensation 136 02/01/2016 Prepaid Insurance, W/C Feb 883.56 147.89 1,031.45 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 147.89 1,031.45 ** 1,554.00 Budgeted 522.55 Remaining 66 % 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 2,860.56 .00 2,860.56 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 2,860.56 ** 5,000.00 Budgeted 2,139.44 Remaining 57 % Used Account: 135-55030-030-000 Software & Support 940 02/12/2016 Feb A/P Internet 8,799.94 1,101.17 9,901.11 WHOLESALE CARRIER SERVICES INC 1587 AP 985 02/22/2016 Feb A/P Support and Mudule renewals 2,060.18 11,961.29 STW INC 1583 AP 1066 02/26/2016 PCards 1/27/16-2/26/16 ATT*BILL PAYMENT 166.46 12,127.75 ATT*BILL PAYMENT PC 1066 02/26/2016 PCards 1/27/16-2/26/16 ATT*BILL PAYMENT 150.14 12,277.89 ATT*BILL PAYMENT PC _______________ Account: 135-55030-030-000 Software & Support Totals: 3,477.95 12,277.89 ** 78,483.00 Budgeted 66,205.11 Remaining 16 % Used Account: 135-55070-030-000 Independent Labor 904 02/09/2016 VOID FOR BANK CHANGE Replace lost Check # 34186 12,923.23 (48.75) 12,874.48 MIGUEL CRUZ 34186 AP 980 02/22/2016 Replace lost outstanding cks Replace lost Check # 34186 48.75 12,923.23 MIGUEL CRUZ 1559 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 12,923.23 ** 12,000.00 Budgeted (923.23) Remaining 108 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-030-000 Maintenance & Repairs 935 02/12/2016 February A/P Roof repair 7,724.66 1,965.00 9,689.66 TK CONTRACTORS LLC 1538 AP 985 02/22/2016 Feb A/P Mowing 576.00 10,265.66 WATTS ELLISON LLC 1586 AP 1002 02/22/2016 Void A/P Ck 1586/D&D Mowing Mowing (576.00) 9,689.66 WATTS ELLISON LLC 1586 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 1,965.00 9,689.66 ** 29,500.00 Budgeted 19,810.34 Remaining 33 % Used Account: 135-55100-030-000 Building Maint & Supplies 935 02/12/2016 February A/P Door keys 1,086.06 87.50 1,173.56 MICHAEL'S KEYS INC. 1522 AP 1066 02/26/2016 PCards 1/27/16-2/26/16 AMAZON MKTPLACE PMTS 48.24 1,221.80 AMAZON MKTPLACE PMTS PC 1066 02/26/2016 PCards 1/27/16-2/26/16 AMAZON MKTPLACE PMTS 280.00 1,501.80 AMAZON MKTPLACE PMTS PC 1074 02/29/2016 Feb A/P Rug Service/Feb 130.89 1,632.69 G & K SERVICES 1612 AP 1074 02/29/2016 Feb A/P Rug Service/Feb 130.89 1,763.58 G & K SERVICES 1612 AP 1074 02/29/2016 Feb A/P MUD Building Generator 4,968.27 6,731.85 WORLDWIDE POWER PRODUCTS 1653 AP 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: (2,615.02) 4,116.83 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 3,030.77 4,116.83 ** 7,000.00 Budgeted 2,883.17 Remaining 59 % Used Account: 135-55120-030-000 Cleaning Services 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: 2,339.00 (259.00) 2,080.00 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: (259.00) 2,080.00 ** 10,125.00 Budgeted 8,045.00 Remaining 21 % Used Account: 135-55160-030-000 Professional Outside Services 1074 02/29/2016 Feb A/P Boundary Survey 51,570.00 1,502.50 53,072.50 THE WALLACE GROUP, INC. 1647 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 1,502.50 53,072.50 ** 61,075.00 Budgeted 8,002.50 Remaining 87 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2,540.87 .00 2,540.87 _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: .00 2,540.87 ** 8,200.00 Budgeted 5,659.13 Remaining 31 % Used Account: 135-60005-030-000 Telephone 1066 02/26/2016 PCards 1/27/16-2/26/16 RINGCENTRAL, INC 4,937.08 9.99 4,947.07 RINGCENTRAL, INC PC 1066 02/26/2016 PCards 1/27/16-2/26/16 ATT*BUS PHONE PMT 432.04 5,379.11 ATT*BUS PHONE PMT PC _______________ Account: 135-60005-030-000 Telephone Totals: 442.03 5,379.11 ** 16,349.00 Budgeted 10,969.89 Remaining 33 % Used Account: 135-60010-030-000 Communications/Mobiles 994 02/26/2016 MUD Payroll 2/26/16 Communications/Mobiles 1,351.96 300.00 1,651.96 PR 1074 02/29/2016 Feb A/P Cells 37.99 1,689.95 VERIZON WIRELESS 1651 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 337.99 1,689.95 ** 4,150.00 Budgeted 2,460.05 Remaining 41 % Used Account: 135-60020-030-000 Electricity/Gas 1074 02/29/2016 Feb A/P Verizon, Gexa, Charter 2,475.12 1,236.16 3,711.28 TOWN OF TROPHY CLUB 1648 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,236.16 3,711.28 ** 10,768.00 Budgeted 7,056.72 Remaining 34 % Used Account: 135-60025-030-000 Water 1111 02/29/2016 Feb A/R Billing Town AR 20160229-20160229 User: 306.73 (82.15) 224.58 AR 1125 02/29/2016 Feb A/P Feb Water MUD & PS Bldgs 164.31 388.89 TROPHY CLUB MUD (WATER BILLS) 1671 AP _______________ Account: 135-60025-030-000 Water Totals: 82.16 388.89 ** 1,500.00 Budgeted 1,111.11 Remaining 26 % Used Account: 135-60035-030-000 Postage 935 02/12/2016 February A/P Overnight letter 8,924.06 8.74 8,932.80 FEDERAL EXPRESS CORP 1502 AP 935 02/12/2016 February A/P Bulk mail Water operator job n 367.09 9,299.89 U.S. POSTAL SERVICE 1543 AP 1074 02/29/2016 Feb A/P Overnight letter 5.24 9,305.13 FEDERAL EXPRESS CORP 1609 AP _______________ Account: 135-60035-030-000 Postage Totals: 381.07 9,305.13 ** 28,932.00 Budgeted 19,626.87 Remaining 32 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60040-030-000 Service Charges & Fees 1065 02/02/2016 Credit Card fees/January 23,144.10 66.16 23,210.26 GL 1065 02/02/2016 Credit Card fees/January 3,653.43 26,863.69 GL 922 02/10/2016 Bank Analysis Fee- Jan & Feb Jan 16 Fee 58.84 26,922.53 GL 922 02/10/2016 Bank Analysis Fee- Jan & Feb Feb 16 Fee 49.22 26,971.75 GL 1107 02/12/2016 Child Support Fee 1.50 26,973.25 GL 997 02/26/2016 Expert Pay Child Support Fee 1.50 26,974.75 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,830.65 26,974.75 ** 44,000.00 Budgeted 17,025.25 Remaining 61 % Used Account: 135-60050-030-000 Bad Debt Expense 822 02/02/2016 UB 1/4/16 Write offs UB20160104-20160104 User: 4,291.83 (3,216.78) 1,075.05 GL _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: (3,216.78) 1,075.05 ** 3,500.00 Budgeted 2,424.95 Remaining 31 % Used Account: 135-60055-030-000 Insurance 136 02/01/2016 Prepaid Insurance, W/C Feb 11,124.00 2,756.00 13,880.00 GL 935 02/12/2016 February A/P Jennifer Bond 3/19/16-3/19/19 130.00 14,010.00 VICTOR O SCHINNERER & CO, INC 1544 AP 1074 02/29/2016 Feb A/P Jennifer McKnight Notary Bond 21.00 14,031.00 OFC OF THE SECRETARY OF STATE 1635 AP _______________ Account: 135-60055-030-000 Insurance Totals: 2,907.00 14,031.00 ** 52,797.00 Budgeted 38,766.00 Remaining 27 % 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 1074 02/29/2016 Feb A/P Coffee and membership renewal 4,896.25 110.00 5,006.25 COSTCO WHOLESALE 1604 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 110.00 5,006.25 ** 6,000.00 Budgeted 993.75 Remaining 83 % Used Account: 135-60075-030-000 Meetings . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 29.00 .00 29.00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 29.00 ** 400.00 Budgeted 371.00 Remaining 7 % Used Account: 135-60079-030-000 Public Education 1066 02/26/2016 PCards 1/27/16-2/26/16 WWW.ANYPROMO.COM 581.65 168.95 750.60 WWW.ANYPROMO.COM PC 1066 02/26/2016 PCards 1/27/16-2/26/16 NEW RESOURCES GROUP, I 205.80 956.40 NEW RESOURCES GROUP, I PC 1066 02/26/2016 PCards 1/27/16-2/26/16 AMAZON MKTPLACE PMTS 57.94 1,014.34 AMAZON MKTPLACE PMTS PC 1066 02/26/2016 PCards 1/27/16-2/26/16 CANVA.COM 1.00 1,015.34 CANVA.COM PC 1066 02/26/2016 PCards 1/27/16-2/26/16 WM SUPERCENTER #266 45.29 1,060.63 WM SUPERCENTER #266 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 FOTOLIA - UE593N5OXVLM 56.00 1,116.63 FOTOLIA - UE593N5OXVLM PC 1066 02/26/2016 PCards 1/27/16-2/26/16 AMAZON MKTPLACE PMTS 6.99 1,123.62 AMAZON MKTPLACE PMTS PC 1066 02/26/2016 PCards 1/27/16-2/26/16 AMAZON MKTPLACE PMTS 190.70 1,314.32 AMAZON MKTPLACE PMTS PC 1066 02/26/2016 PCards 1/27/16-2/26/16 AMAZON MKTPLACE PMTS 138.20 1,452.52 AMAZON MKTPLACE PMTS PC 1066 02/26/2016 PCards 1/27/16-2/26/16 AMAZON MKTPLACE PMTS 26.88 1,479.40 AMAZON MKTPLACE PMTS PC 1066 02/26/2016 PCards 1/27/16-2/26/16 AMAZON MKTPLACE PMTS 4.79 1,484.19 AMAZON MKTPLACE PMTS PC _______________ Account: 135-60079-030-000 Public Education Totals: 902.54 1,484.19 ** 5,000.00 Budgeted 3,515.81 Remaining 30 % Used Account: 135-60080-030-000 Schools & Training 812 02/01/2016 Feb A/P STW Conf/Gonzales 1,857.00 400.00 2,257.00 STW INC 1478 AP 1066 02/26/2016 PCards 1/27/16-2/26/16 TRWA 00 OF 00 125.00 2,382.00 TRWA 00 OF 00 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 SEQUOIA CPE 39.50 2,421.50 SEQUOIA CPE PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 564.50 2,421.50 ** 9,935.00 Budgeted 7,513.50 Remaining 24 % Used Account: 135-60100-030-000 Travel & per diem 919 02/12/2016 MUD Payroll 2/12/16 Travel & per diem 1,888.33 142.01 2,030.34 PR 994 02/26/2016 MUD Payroll 2/26/16 Travel & per diem 3.67 2,034.01 PR 1066 02/26/2016 PCards 1/27/16-2/26/16 MCDONALD'S F32779 6.70 2,040.71 MCDONALD'S F32779 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 LAQUINTA INNS 173.66 2,214.37 LAQUINTA INNS PC 1066 02/26/2016 PCards 1/27/16-2/26/16 STARBUCKS #14860 GEORG 4.60 2,218.97 STARBUCKS #14860 GEORG PC 1066 02/26/2016 PCards 1/27/16-2/26/16 PELONS/508 13.27 2,232.24 PELONS/508 PC _______________ Account: 135-60100-030-000 Travel & per diem Totals: 343.91 2,232.24 ** 5,400.00 Budgeted 3,167.76 Remaining 41 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections .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 61.74 .00 61.74 _______________ Account: 135-60125-030-000 Advertising Totals: .00 61.74 ** 7,500.00 Budgeted 7,438.26 Remaining 1 % 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 1053 02/29/2016 Void CK 1075/Sec of State Notary bonds - Laurie Slaght, 4,115.98 (42.00) 4,073.98 OFC OF THE SECRETARY OF STATE 1075 AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: (42.00) 4,073.98 ** 17,501.00 Budgeted 13,427.02 Remaining 23 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 656.38 .00 656.38 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 656.38 ** 2,500.00 Budgeted 1,843.62 Remaining 26 % Used Account: 135-65010-030-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 23.00 .00 23.00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 23.00 ** 1,855.00 Budgeted 1,832.00 Remaining 1 % Used Account: 135-65055-030-000 Hardware 1074 02/29/2016 Feb A/P Laptop reading kit 5,871.85 15,773.84 21,645.69 ATLAS UTILITY SUPPLY CO. 1599 AP _______________ Account: 135-65055-030-000 Hardware Totals: 15,773.84 21,645.69 ** 29,594.00 Budgeted 7,948.31 Remaining 73 % Used Account: 135-65085-030-000 Office Supplies 985 02/22/2016 Feb A/P Laser Check paper 1,978.19 533.19 2,511.38 FORMS ONE 1574 AP 1066 02/26/2016 PCards 1/27/16-2/26/16 OFFICE DEPOT #406 (228.99) 2,282.39 OFFICE DEPOT #406 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 OFFICE DEPOT #406 234.98 2,517.37 OFFICE DEPOT #406 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 OFFICE DEPOT #406 35.67 2,553.04 OFFICE DEPOT #406 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 DESKTOP SUPPLIES.COM 324.22 2,877.26 DESKTOP SUPPLIES.COM PC 1066 02/26/2016 PCards 1/27/16-2/26/16 AMER ASSOC NOTARIESWE 41.85 2,919.11 AMER ASSOC NOTARIESWE PC 1125 02/29/2016 Feb A/P Office Supplies 50.95 2,970.06 OFFICE DEPOT, INC 1664 AP 1125 02/29/2016 Feb A/P Office Supplies 3.69 2,973.75 OFFICE DEPOT, INC 1664 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 995.56 2,973.75 ** 9,000.00 Budgeted 6,026.25 Remaining 33 % 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 1066 02/26/2016 PCards 1/27/16-2/26/16 AMAZON MKTPLACE PMTS 1,316.47 32.95 1,349.42 AMAZON MKTPLACE PMTS PC 1066 02/26/2016 PCards 1/27/16-2/26/16 AMAZON MKTPLACE PMTS 20.90 1,370.32 AMAZON MKTPLACE PMTS PC 1066 02/26/2016 PCards 1/27/16-2/26/16 SAMSCLUB #4795 265.47 1,635.79 SAMSCLUB #4795 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 WM SUPERCENTER #266 15.84 1,651.63 WM SUPERCENTER #266 PC 1066 02/26/2016 PCards 1/27/16-2/26/16 SAMSCLUB #8268 162.38 1,814.01 SAMSCLUB #8268 PC 1074 02/29/2016 Feb A/P Coffee and membership renewal 57.98 1,871.99 COSTCO WHOLESALE 1604 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 555.52 1,871.99 ** 5,000.00 Budgeted 3,128.01 Remaining 37 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-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 1066 02/26/2016 PCards 1/27/16-2/26/16 Bathroom remodel 1,427.50 638.00 2,065.50 IN *ASBESTOS INSPECTOR PC 1074 02/29/2016 Feb A/P Restroom Renovations/Jan 4,092.50 6,158.00 THE WALLACE GROUP, INC. 1647 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 4,730.50 6,158.00 ** 56,000.00 Budgeted 49,842.00 Remaining 11 % Used Account: 135-69170-030-000 Copier Lease Installments 935 02/12/2016 February A/P Copier lease 1,143.67 165.00 1,308.67 EVERBANK COMMERCIAL FINANCE 1501 AP 1074 02/29/2016 Feb A/P Copier 133.68 1,442.35 KYOCERA DOCUMENT SOLUTIONS 1621 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 298.68 1,442.35 ** 4,600.00 Budgeted 3,157.65 Remaining 31 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 467,844.44 ** 1,210,323.00 Budgeted 742,478.56 Remaining 39 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 1074 02/29/2016 Feb A/P Jan Legal-General 102,471.44 4,408.20 106,879.64 THE LISTON LAW FIRM, P.C. 1646 AP 1074 02/29/2016 Feb A/P Jan Legal-PUC 1,301.24 108,180.88 THE LISTON LAW FIRM, P.C. 1646 AP 1074 02/29/2016 Feb A/P Jan legal-JSB Agreement 1,143.00 109,323.88 THE LISTON LAW FIRM, P.C. 1646 AP 1074 02/29/2016 Feb A/P Legal/WWTP WCP Contract 3,376.50 112,700.38 THE LISTON LAW FIRM, P.C. 1646 AP 1074 02/29/2016 Feb A/P Feb Legal 480.00 113,180.38 FREEMAN & CORBETT 1611 AP 1125 02/29/2016 Feb A/P Feb Legal 4,417.25 117,597.63 THE LISTON LAW FIRM, P.C. 1669 AP 1125 02/29/2016 Feb A/P Feb Legal 2,340.75 119,938.38 THE LISTON LAW FIRM, P.C. 1669 AP 1125 02/29/2016 Feb A/P Feb Legal 319.75 120,258.13 THE LISTON LAW FIRM, P.C. 1669 AP 1125 02/29/2016 Feb A/P Reimb PUC Hearing expenses 338.26 120,596.39 Pamela Liston 1666 AP _______________ Account: 135-55045-039-000 Legal Totals: 18,124.95 120,596.39 ** 386,130.00 Budgeted 265,533.61 Remaining 31 % Used Account: 135-55055-039-000 Auditing 24,039.38 .00 24,039.38 _______________ Account: 135-55055-039-000 Auditing Totals: .00 24,039.38 ** 22,750.00 Budgeted (1,289.38) Remaining 106 % Used Account: 135-55060-039-000 Appraisal 4,229.90 .00 4,229.90 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 4,229.90 ** 10,265.00 Budgeted 6,035.10 Remaining 41 % Used Account: 135-55065-039-000 Tax Admin Fees 2,468.82 .00 2,468.82 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,468.82 ** 3,800.00 Budgeted 1,331.18 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 151,334.49 ** 422,945.00 Budgeted 271,610.51 Remaining 36 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 387,433.45 .00 Budgeted (387,433.45) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (75,000.00) .00 (75,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (75,000.00) ** .00 Budgeted 75,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (156,420.00) ** .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ (156,420.00) .00 Budgeted 156,420.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income (2.77) .00 (2.77) _______________ Account: 507-49010-000-000 Interest Income Totals: .00 (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 .00 8,034.36 _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: .00 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 8,031.59 .00 Budgeted (8,031.59) Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET FEBRUARY 2016 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,382,055 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,382,055 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,378,563 NET REVENUES / EXPENDITURES 3,492 TOTAL FUND BALANCE 4,382,055 TOTAL LIABILITIES AND FUND BALANCE 4,382,055 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 11:27 03/09/16 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,047.91- 3,492.42- 3,492.42 Subtotal: 1,047.91- 3,492.42- 3,492.42 Program number: 1,047.91- 3,492.42- 3,492.42 Department number: Revenues 1,047.91- 3,492.42- 3,492.42 Revenues Subtotal ----------- 1,047.91- 3,492.42- 3,492.42 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,047.91- 3,492.42- 3,492.42 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 1100 02/29/2016 Bank Interest/Feb (2,444.51) (1,047.91) (3,492.42) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,047.91) (3,492.42) ** .00 Budgeted 3,492.42 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (3,492.42) ** .00 Budgeted 3,492.42 Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (3,492.42) .00 Budgeted 3,492.42 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET FEBRUARY 2016 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 7,558,300 ACCOUNTS RECEIVABLE - TOTAL ASSETS 7,558,300 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 151,877 TOTAL LIABILITIES 151,877 FUND BALANCE ASSIGNED FUND BALANCE 8,334,104 NET REVENUES / EXPENDITURES (927,681) TOTAL FUND BALANCE 7,406,423 TOTAL LIABILITIES AND FUND BALANCE 7,558,300 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 11:27 03/09/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 1,849.76- 6,540.78- 6,540.78 Subtotal: 1,849.76- 6,540.78- 6,540.78 Program number: 1,849.76- 6,540.78- 6,540.78 Department number: Revenues 1,849.76- 6,540.78- 6,540.78 Revenues Subtotal ----------- 1,849.76- 6,540.78- 6,540.78 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 11:27 03/09/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 176,517.24 934,221.76 934,221.76- Subtotal: 176,517.24 934,221.76 934,221.76- Program number: 176,517.24 934,221.76 934,221.76- Department number: Wastewater 176,517.24 934,221.76 934,221.76- Expenditures Subtotal ----------- 176,517.24 934,221.76 934,221.76- Fund number: 518 2015 Revenue Bond Const Fund 174,667.48 927,680.98 927,680.98- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-49010-000-000 Interest Income 1100 02/29/2016 Bank Interest/Feb (4,691.02) (1,849.76) (6,540.78) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (1,849.76) (6,540.78) ** .00 Budgeted 6,540.78 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (6,540.78) ** .00 Budgeted 6,540.78 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-69005-020-000 Capital Outlays 1068 02/24/2016 Webber-Cadagua App4 retainage 757,704.52 17,472.72 775,177.24 GL 1007 02/26/2016 February A/P Contractor Application for Pmt 157,254.52 932,431.76 WEBBER-CADAGUA PARTNERS 1590 AP 1074 02/29/2016 Feb A/P WWTP Preliminary/Final Plat 1,790.00 934,221.76 THE WALLACE GROUP, INC. 1647 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 176,517.24 934,221.76 ** .00 Budgeted (934,221.76) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 934,221.76 ** .00 Budgeted (934,221.76) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ 927,680.98 .00 Budgeted (927,680.98) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET FEBRUARY 2016 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 133,733 ACCOUNTS RECEIVABLE - TOTAL ASSETS 133,733 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 71,962 NET REVENUES / EXPENDITURES 61,771 TOTAL FUND BALANCE 133,733 TOTAL LIABILITIES AND FUND BALANCE 133,733 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 11:27 03/09/16 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 31.97- 103.49- 103.49 528-49141-000-000 Interfund Transfer In-Gen Fund 123,336.00- 123,336.00- 61,668.00- 50.000 61,668.00- Subtotal: 123,336.00- 123,336.00- 31.97- 61,771.49- 50.084 61,564.51- Program number: 123,336.00- 123,336.00- 31.97- 61,771.49- 50.084 61,564.51- Department number: 123,336.00- 123,336.00- 31.97- 61,771.49- 50.084 61,564.51- Revenues Subtotal ----------- 123,336.00- 123,336.00- 31.97- 61,771.49- 50.084 61,564.51- Fund number: 528 2015 Revenue Bond Reserve Fund 123,336.00- 123,336.00- 31.97- 61,771.49- 50.084 61,564.51- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 1100 02/29/2016 Bank Interest/Feb (71.52) (31.97) (103.49) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (31.97) (103.49) ** .00 Budgeted 103.49 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund (61,668.00) .00 (61,668.00) _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: .00 (61,668.00) ** (123,336.00) Budgeted (61,668.00) Remaining 50 % Used Department Totals: ------------------------------------------------------------------------------------------------ (61,771.49) ** (123,336.00) Budgeted (61,564.51) Remaining 50 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (61,771.49) (123,336.00) Budgeted (61,564.51) Remaining 50 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET FEBRUARY 2016 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 720,566 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 34,647 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 760,059 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 34,647 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 34,647 FUND BALANCE ASSIGNED FUND BALANCE 24,173 NET REVENUES / EXPENDITURES 701,239 TOTAL FUND BALANCE 725,412 TOTAL LIABILITIES AND FUND BALANCE 760,059 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 11:27 03/09/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 667,898.00- 667,898.00- 49,793.33- 646,234.20- 96.756 21,663.80- 533-40002-000-000 Property Taxes/Delinquent 2,300.00- 2,300.00- 538.19- 930.51- 40.457 1,369.49- 533-40015-000-000 Property Taxes/P & I 1,800.00- 1,800.00- 462.24- 581.43- 32.302 1,218.57- Subtotal: 671,998.00- 671,998.00- 50,793.76- 647,746.14- 96.391 24,251.86- 533-49010-000-000 Interest Income 140.00- 140.00- 170.89- 305.58- 218.271 165.58 533-49015-000-000 Lease/Rental Income 214,379.00- 214,379.00- 214,379.00- 214,379.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 119,706.00- 119,706.00- 119,706.00- Subtotal: 334,225.00- 334,225.00- 214,549.89- 214,684.58- 64.234 119,540.42- Program number: 1,006,223.00- 1,006,223.00- 265,343.65- 862,430.72- 85.710 143,792.28- Department number: Revenues 1,006,223.00- 1,006,223.00- 265,343.65- 862,430.72- 85.710 143,792.28- Revenues Subtotal ----------- 1,006,223.00- 1,006,223.00- 265,343.65- 862,430.72- 85.710 143,792.28- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 11:27 03/09/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 2,500.00 2,500.00 98.039 50.00 533-70025-051-000 Bond Interest Expense-Tax 316,983.00 316,983.00 158,691.25 158,691.25 50.063 158,291.75 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 161,191.25 161,191.25 16.046 843,341.75 Program number: 1,004,533.00 1,004,533.00 161,191.25 161,191.25 16.046 843,341.75 Department number: Administration 1,004,533.00 1,004,533.00 161,191.25 161,191.25 16.046 843,341.75 Expenditures Subtotal ----------- 1,004,533.00 1,004,533.00 161,191.25 161,191.25 16.046 843,341.75 Fund number: 533 MUD 1 I&S Consolidated 1,690.00- 1,690.00- 104,152.40- 701,239.47- ############### 699,549.47 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 1070 02/01/2016 Property Taxes/Assessments (596,440.87) (3,858.89) (600,299.76) GL 1071 02/02/2016 Property Taxes/Assessments (5,715.44) (606,015.20) GL 1072 02/03/2016 Property Taxes/Assessments (16,808.21) (622,823.41) GL 1073 02/04/2016 Property Taxes/Assessments (4,276.91) (627,100.32) GL 1076 02/05/2016 Property Taxes/Assessments (12,272.85) (639,373.17) GL 1077 02/08/2016 Property Taxes/Assessments (3,325.25) (642,698.42) GL 1081 02/09/2016 Property Taxes/Assessments (478.25) (643,176.67) GL 1082 02/10/2016 Property Taxes/Assessments (458.54) (643,635.21) GL 1083 02/11/2016 Property Taxes/Assessments (238.48) (643,873.69) GL 1085 02/12/2016 Property Taxes/Assessments 80.36 (643,793.33) GL 1086 02/16/2016 Property Taxes/Assessments (161.25) (643,954.58) GL 1087 02/17/2016 Property Taxes/Assessments (613.29) (644,567.87) GL 1088 02/18/2016 Property Taxes/Assessments (38.67) (644,606.54) GL 1089 02/19/2016 Property Taxes/Assessments (95.11) (644,701.65) GL 1090 02/22/2016 Property Taxes/Assessments (44.53) (644,746.18) GL 1091 02/23/2016 Property Taxes/Assessments (234.83) (644,981.01) GL 1094 02/24/2016 Property Taxes/Assessments (439.16) (645,420.17) GL 1095 02/25/2016 Property Taxes/Assessments (134.88) (645,555.05) GL 1096 02/26/2016 Property Taxes/Assessments (9.26) (645,564.31) GL 1097 02/29/2016 Property Taxes/Assessments (669.89) (646,234.20) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (49,793.33) (646,234.20) ** (667,898.00) Budgeted (21,663.80) Remaining 97 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1072 02/03/2016 Property Taxes/Assessments (392.32) (537.08) (929.40) GL 1073 02/04/2016 Property Taxes/Assessments (1.11) (930.51) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (538.19) (930.51) ** (2,300.00) Budgeted (1,369.49) Remaining 40 % Used Account: 533-40015-000-000 Property Taxes/P & I 1072 02/03/2016 Property Taxes/Assessments (119.19) (248.03) (367.22) GL 1073 02/04/2016 Property Taxes/Assessments (.28) (367.50) GL 1081 02/09/2016 Property Taxes/Assessments (25.92) (393.42) GL 1082 02/10/2016 Property Taxes/Assessments (28.45) (421.87) GL 1083 02/11/2016 Property Taxes/Assessments (16.69) (438.56) GL 1085 02/12/2016 Property Taxes/Assessments (25.53) (464.09) GL 1086 02/16/2016 Property Taxes/Assessments (11.29) (475.38) GL 1087 02/17/2016 Property Taxes/Assessments (5.97) (481.35) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 57 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1088 02/18/2016 Property Taxes/Assessments (119.19) (2.71) (484.06) GL 1089 02/19/2016 Property Taxes/Assessments (6.43) (490.49) GL 1090 02/22/2016 Property Taxes/Assessments (1.58) (492.07) GL 1091 02/23/2016 Property Taxes/Assessments (13.22) (505.29) GL 1094 02/24/2016 Property Taxes/Assessments (21.11) (526.40) GL 1095 02/25/2016 Property Taxes/Assessments (9.44) (535.84) GL 1096 02/26/2016 Property Taxes/Assessments (.64) (536.48) GL 1097 02/29/2016 Property Taxes/Assessments (44.95) (581.43) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (462.24) (581.43) ** (1,800.00) Budgeted (1,218.57) Remaining 32 % Used Account: 533-49010-000-000 Interest Income 1100 02/29/2016 Bank Interest/Feb (134.69) (170.89) (305.58) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (170.89) (305.58) ** (140.00) Budgeted 165.58 Remaining 218 % Used Account: 533-49015-000-000 Lease/Rental Income 1029 02/18/2016 FD Rent to MUD 1 I&S (214,379.00) (214,379.00) GL _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: (214,379.00) (214,379.00) ** (214,379.00) Budgeted .00 Remaining 100 % 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: ------------------------------------------------------------------------------------------------ (862,430.72) ** (1,006,223.00) Budgeted (143,792.28) Remaining 86 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 58 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 1108 02/25/2016 Paying Agent Fees Unl Tax Bonds, Series 2010 750.00 750.00 GL 1108 02/25/2016 Paying Agent Fees Unl Tax Ref Bonds Series 2012 500.00 1,250.00 GL 1108 02/25/2016 Paying Agent Fees Unl Tax Bonds Series 2010 Dupe 750.00 2,000.00 GL 1108 02/25/2016 Paying Agent Fees Unl Tax Ref Bond Ser 2012 Dupe 500.00 2,500.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 2,500.00 2,500.00 ** 2,550.00 Budgeted 50.00 Remaining 98 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 1109 02/25/2016 Bond Payments Unl Tax Bonds Series 2014 74,362.50 74,362.50 GL 1109 02/25/2016 Bond Payments Unl Tax Ref Bonds Series 2013 24,012.50 98,375.00 GL 1109 02/25/2016 Bond Payments Unl Tax Bonds Series 2010 35,641.25 134,016.25 GL 1109 02/25/2016 Bond Payments Unl Tax Ref Bonds Series 2012 24,675.00 158,691.25 GL _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: 158,691.25 158,691.25 ** 316,983.00 Budgeted 158,291.75 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 685,000.00 Budgeted 685,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 161,191.25 ** 1,004,533.00 Budgeted 843,341.75 Remaining 16 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (701,239.47) (1,690.00) Budgeted 699,549.47 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET FEBRUARY 2016 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 83,006 ACCOUNTS RECEIVABLE - TOTAL ASSETS 83,006 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,068 NET REVENUES / EXPENDITURES 67,937 TOTAL FUND BALANCE 83,006 TOTAL LIABILITIES AND FUND BALANCE 83,006 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 11:27 03/09/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 2/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 7.00- 7.00- 31.84- 40.37- 576.714 33.37 534-49143-000-000 Interfund Transfer In-WW Sales 444,831.00- 444,831.00- 185,515.60- 185,515.60- 41.705 259,315.40- Subtotal: 444,838.00- 444,838.00- 185,547.44- 185,555.97- 41.713 259,282.03- Program number: 444,838.00- 444,838.00- 185,547.44- 185,555.97- 41.713 259,282.03- Department number: Revenues 444,838.00- 444,838.00- 185,547.44- 185,555.97- 41.713 259,282.03- Revenues Subtotal ----------- 444,838.00- 444,838.00- 185,547.44- 185,555.97- 41.713 259,282.03- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 11:27 03/09/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 2/2016 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 117,618.75 117,618.75 50.085 117,219.25 534-70045-051-000 Revenue Bond Principal Expense 210,000.00 210,000.00 210,000.00 Subtotal: 444,838.00 444,838.00 117,618.75 117,618.75 26.441 327,219.25 Program number: 444,838.00 444,838.00 117,618.75 117,618.75 26.441 327,219.25 Department number: Administration 444,838.00 444,838.00 117,618.75 117,618.75 26.441 327,219.25 Expenditures Subtotal ----------- 444,838.00 444,838.00 117,618.75 117,618.75 26.441 327,219.25 Fund number: 534 2015 Revenue Bond I&S 67,928.69- 67,937.22- 67,937.22 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 59 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 1100 02/29/2016 Bank Interest/Feb (8.53) (31.84) (40.37) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (31.84) (40.37) ** (7.00) Budgeted 33.37 Remaining 577 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 879 02/04/2016 O&M to Rev Bond I&S/Int pmt (117,618.75) (117,618.75) GL 1028 02/18/2016 Texpool xfer to Rev Bond I&S (67,896.85) (185,515.60) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (185,515.60) (185,515.60) ** (444,831.00) Budgeted (259,315.40) Remaining 42 % Used Department Totals: ------------------------------------------------------------------------------------------------ (185,555.97) ** (444,838.00) Budgeted (259,282.03) Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 60 11:27 03/09/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 2/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70040-051-000 Revenue Bond Interest Expense 1109 02/25/2016 Bond Payments Rev Bond Series 2015 117,618.75 117,618.75 GL _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 117,618.75 117,618.75 ** 234,838.00 Budgeted 117,219.25 Remaining 50 % 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: ------------------------------------------------------------------------------------------------ 117,618.75 ** 444,838.00 Budgeted 327,219.25 Remaining 26 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (67,937.22) .00 Budgeted 67,937.22 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (172,705.25) **** (125,026.00) Budgeted 47,679.25 Remaining 138 % Used ******* End of Report *********