Loading...
HomeMy WebLinkAbout2015-09 Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET SEPTEMBER 2015 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 567,989 PREPAID EXPENSES 4,944 ADVALOREM PROPERTY TAXES RECEIVABLE 16,477 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 346 UTILITY AND OTHER ACCOUNTS RECEIVABLE 5,877 TOTAL ASSETS 595,633 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 16,823 ACCOUNTS AND OTHER PAYABLES 12,044 TOTAL LIABILITIES 28,867 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 528,911 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 37,855 TOTAL FUND BALANCE 566,766 TOTAL LIABILITIES AND FUND BALANCE 595,633 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 19:26 10/07/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 357,462.00- 357,462.00- 257.48- 356,903.14- 99.844 558.86- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 8,401.96- 8,401.96 122-40010-000-000 Property Taxes/MUD Fire 872,859.00- 872,859.00- 2,211.69- 873,241.05- 100.044 382.05 122-40011-000-000 Property Taxes/Fire-Delinquent 199.77- 4,255.27- 4,255.27 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 33.47- 3,337.49- 444.999 2,587.49 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 537.94- 4,284.27- 95.206 215.73- Subtotal: 1,235,571.00- 1,235,571.00- 3,240.35- 1,250,423.18- 101.202 14,852.18 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 1,600.00- 8,400.00- 140.000 2,400.00 Subtotal: 6,000.00- 6,000.00- 1,600.00- 8,400.00- 140.000 2,400.00 122-43400-000-000 Fire Inspections 700.00- 950.00- 300.00- 1,575.00- 165.789 625.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,700.00- 10,950.00- 300.00- 11,575.00- 105.708 625.00 122-49000-000-000 Capital Lease-Oth Fin Sources 807,316.00- 807,316.14- 100.000 .14 122-49035-000-000 Prior Year Reserves 125,669.00- 198,468.00- 125,670.00- 63.320 72,798.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 9,000.00- 3,200.00- 16,903.99- 187.822 7,903.99 Subtotal: 131,669.00- 1,014,784.00- 3,200.00- 949,890.13- 93.605 64,893.87- Program number: 1,383,940.00- 2,267,305.00- 8,340.35- 2,220,288.31- 97.926 47,016.69- Department number: Fire Revenues 1,383,940.00- 2,267,305.00- 8,340.35- 2,220,288.31- 97.926 47,016.69- Revenues Subtotal ----------- 1,383,940.00- 2,267,305.00- 8,340.35- 2,220,288.31- 97.926 47,016.69- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 19:26 10/07/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 469,067.00 469,067.00 37,217.42 459,392.57 97.938 9,674.43 122-50010-045-000 Overtime 46,745.00 46,745.00 3,092.30 41,588.74 88.969 5,156.26 122-50011-045-000 DPS Holiday Pay 14,930.00 14,930.00 14,525.69 97.292 404.31 122-50016-045-000 Longevity 5,505.00 5,505.00 5,318.72 96.616 186.28 122-50017-045-000 Certification 4,800.00 4,800.00 362.50 4,844.00 100.917 44.00- 122-50020-045-000 Retirement 91,396.00 75,327.00 5,389.30 71,320.55 94.681 4,006.45 122-50026-045-000 Medical Insurance 59,169.00 59,169.00 4,685.24 55,116.12 93.150 4,052.88 122-50027-045-000 Dental Insurance 4,390.00 4,390.00 351.91 4,210.63 95.914 179.37 122-50028-045-000 Vision Insurance 811.00 811.00 60.94 732.32 90.298 78.68 122-50029-045-000 Life Insurance & Other 4,030.00 4,030.00 299.16 3,671.49 91.104 358.51 122-50030-045-000 Social Security Taxes 33,421.00 33,421.00 2,312.93 30,052.91 89.922 3,368.09 122-50035-045-000 Medicare Taxes 7,292.00 7,292.00 540.79 7,026.86 96.364 265.14 122-50040-045-000 Unemployment Taxes 1,657.00 1,657.00 8.22 262.81- -15.861 1,919.81 122-50045-045-000 Workman's Compensation 8,692.00 8,692.00 658.99 7,907.92 90.979 784.08 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 182.50 73.000 67.50 122-50075-045-000 Tuition Reimbursement 300.00 300.00 300.00 Subtotal: 752,455.00 736,386.00 54,979.70 705,628.21 95.823 30,757.79 122-55030-045-000 Software & Support 7,378.00 7,378.00 462.50 5,593.16 75.809 1,784.84 122-55045-045-000 Legal 1,500.00 2,100.00 2,040.00 97.143 60.00 122-55080-045-000 Maintenance & Repairs 18,552.00 14,552.00 5,272.04 15,885.41 109.163 1,333.41- 122-55090-045-000 Vehicle Maintenance 12,000.00 16,000.00 4,486.99 15,492.86 96.830 507.14 122-55160-045-000 Professional Outside Services 27,438.00 10,017.00 11,912.20 43.415 15,525.80 Subtotal: 39,430.00 67,468.00 20,238.53 50,923.63 75.478 16,544.37 122-60005-045-000 Telephone 50.00 75.00 51.30 68.400 23.70 122-60010-045-000 Communications/Mobiles 5,000.00 6,413.00 167.48 4,520.01 70.482 1,892.99 122-60020-045-000 Electricity/Gas 9,026.00 9,026.00 590.62 5,672.06 62.841 3,353.94 122-60025-045-000 Water 1,200.00 2,200.00 148.90 1,575.50 71.614 624.50 122-60026-045-000 Cable 1,920.00 1,920.00 292.69 1,981.79 103.218 61.79- 122-60030-045-000 Rent And/Or Usage 211,829.00 211,829.00 211,829.00 100.000 122-60035-045-000 Postage 100.00 100.00 16.43 16.430 83.57 122-60055-045-000 Insurance 12,179.00 12,179.00 940.08 11,281.00 92.627 898.00 122-60066-045-000 Publications/Books/Subscrips 200.00 220.00 219.05 99.568 .95 122-60070-045-000 Dues & Memberships 15,180.00 15,689.00 15,632.85 99.642 56.15 122-60080-045-000 Schools & Training 4,280.00 4,280.00 4,012.59 93.752 267.41 122-60096-045-000 Emergency Management 1,400.00 1,400.00 1,220.00 87.143 180.00 122-60100-045-000 Travel & per diem 13,577.00 13,577.00 754.80 8,690.96 64.012 4,886.04 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 5,100.00 5,100.00 826.15 16.199 4,273.85 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 1,492.30 3,948.75 87.750 551.25 122-60180-045-000 Fire Inspection/Enforcement 1,000.00 1,000.00 194.00 19.400 806.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 19:26 10/07/15 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 237.50 792.35 39.618 1,207.65 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 154.92 728.91 72.891 271.09 Subtotal: 291,541.00 294,508.00 4,779.29 273,192.70 92.762 21,315.30 122-65005-045-000 Fuel & Lube 10,454.00 8,829.00 562.22 5,575.87 63.154 3,253.13 122-65010-045-000 Uniforms 2,000.00 3,000.00 2,408.30 80.277 591.70 122-65015-045-000 Protective Clothing 5,200.00 35,200.00 11,525.88 27,703.33 78.703 7,496.67 122-65030-045-000 Chemicals 200.00 200.00 133.51 66.755 66.49 122-65035-045-000 Small Tools 2,500.00 2,500.00 321.78 1,446.16 57.846 1,053.84 122-65055-045-000 Hardware 9,000.00 9,000.00 6,160.50 6,160.50 68.450 2,839.50 122-65085-045-000 Office Supplies 500.00 500.00 150.33 230.31 46.062 269.69 122-65105-045-000 Printing 548.00 548.00 38.17 6.965 509.83 Subtotal: 30,402.00 59,777.00 18,720.71 43,696.15 73.099 16,080.85 122-69005-045-000 Capital Outlays 1,057,316.00 1,057,316.14 100.000 .14- 122-69008-045-000 Short Term Debt-Principal 158,262.00 122-69009-045-000 Short Term Debt-Interest 50,000.00 122-69050-045-000 Radios 23,500.00 23,500.00 23,490.76 99.961 9.24 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 17,950.00 17,950.00 100.000 122-69255-045-000 Airpacks 20,400.00 10,400.00 10,235.38 98.417 164.62 Subtotal: 270,112.00 1,109,166.00 1,108,992.28 99.984 173.72 Program number: 1,383,940.00 2,267,305.00 98,718.23 2,182,432.97 96.257 84,872.03 Department number: Fire 1,383,940.00 2,267,305.00 98,718.23 2,182,432.97 96.257 84,872.03 Expenditures Subtotal ----------- 1,383,940.00 2,267,305.00 98,718.23 2,182,432.97 96.257 84,872.03 Fund number: 122 Trophy Club MUD Fire Dept. 90,377.88 37,855.34- 37,855.34 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 2249 09/10/2015 Property Taxes/Assessments (356,645.66) (257.48) (356,903.14) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (257.48) (356,903.14) ** (357,462.00) Budgeted (558.86) Remaining 100 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (8,401.96) .00 (8,401.96) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (8,401.96) ** .00 Budgeted 8,401.96 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 2243 09/02/2015 Property Taxes/Assessments (871,029.36) (37.69) (871,067.05) GL 2244 09/03/2015 Property Taxes/Assessments (2,180.55) (873,247.60) GL 2245 09/04/2015 Property Taxes/Assessments (23.31) (873,270.91) GL 2248 09/08/2015 Property Taxes/Assessments (2.41) (873,273.32) GL 2249 09/10/2015 Property Taxes/Assessments (139.23) (873,412.55) GL 2251 09/14/2015 Property Taxes/Assessments (10.42) (873,422.97) GL 2252 09/15/2015 Property Taxes/Assessments 234.71 (873,188.26) GL 2253 09/21/2015 Property Taxes/Assessments (23.18) (873,211.44) GL 2254 09/22/2015 Property Taxes/Assessments (3.47) (873,214.91) GL 2255 09/23/2015 Property Taxes/Assessments (2.08) (873,216.99) GL 2256 09/25/2015 Property Taxes/Assessments (16.24) (873,233.23) GL 2257 09/29/2015 Property Taxes/Assessments (7.82) (873,241.05) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (2,211.69) (873,241.05) ** (872,859.00) Budgeted 382.05 Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2244 09/03/2015 Property Taxes/Assessments (4,055.50) (247.61) (4,303.11) GL 2252 09/15/2015 Property Taxes/Assessments 47.84 (4,255.27) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (199.77) (4,255.27) ** .00 Budgeted 4,255.27 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 2249 09/10/2015 Property Taxes/Assessments (3,304.02) (33.47) (3,337.49) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (33.47) (3,337.49) ** (750.00) Budgeted 2,587.49 Remaining 445 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 2243 09/02/2015 Property Taxes/Assessments (3,746.33) (2.63) (3,748.96) GL 2244 09/03/2015 Property Taxes/Assessments (493.53) (4,242.49) GL 2245 09/04/2015 Property Taxes/Assessments (.17) (4,242.66) GL 2248 09/08/2015 Property Taxes/Assessments (.48) (4,243.14) GL 2249 09/10/2015 Property Taxes/Assessments (26.46) (4,269.60) GL 2251 09/14/2015 Property Taxes/Assessments (2.09) (4,271.69) GL 2253 09/21/2015 Property Taxes/Assessments (8.50) (4,280.19) GL 2254 09/22/2015 Property Taxes/Assessments (1.28) (4,281.47) GL 2255 09/23/2015 Property Taxes/Assessments (.17) (4,281.64) GL 2256 09/25/2015 Property Taxes/Assessments (1.30) (4,282.94) GL 2257 09/29/2015 Property Taxes/Assessments (1.33) (4,284.27) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (537.94) (4,284.27) ** (4,500.00) Budgeted (215.73) Remaining 95 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (6,800.00) (1,600.00) (8,400.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (1,600.00) (8,400.00) ** (6,000.00) Budgeted 2,400.00 Remaining 140 % Used Account: 122-43400-000-000 Fire Inspections 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (1,275.00) (300.00) (1,575.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (300.00) (1,575.00) ** (950.00) Budgeted 625.00 Remaining 166 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49000-000-000 Capital Lease-Oth Fin Sources . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (807,316.14) .00 (807,316.14) _______________ Account: 122-49000-000-000 Capital Lease-Oth Fin Sources Totals: .00 (807,316.14) ** (807,316.00) Budgeted .14 Remaining 100 % Used Account: 122-49035-000-000 Prior Year Reserves (125,670.00) .00 (125,670.00) _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 (125,670.00) ** (198,468.00) Budgeted (72,798.00) Remaining 63 % Used Account: 122-49900-000-000 Miscellaneous Income 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (13,703.99) (3,200.00) (16,903.99) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (3,200.00) (16,903.99) ** (9,000.00) Budgeted 7,903.99 Remaining 188 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,220,288.31) ** (2,267,305.00) Budgeted (47,016.69) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 2175 09/11/2015 FD Payroll 9/11/15 422,175.15 18,606.51 440,781.66 GL 2217 09/25/2015 Fire Payroll 18,610.91 459,392.57 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 37,217.42 459,392.57 ** 469,067.00 Budgeted 9,674.43 Remaining 98 % Used Account: 122-50010-045-000 Overtime 2217 09/25/2015 Fire Payroll 38,496.44 3,092.30 41,588.74 GL _______________ Account: 122-50010-045-000 Overtime Totals: 3,092.30 41,588.74 ** 46,745.00 Budgeted 5,156.26 Remaining 89 % Used Account: 122-50011-045-000 DPS Holiday Pay 14,525.69 .00 14,525.69 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 14,525.69 ** 14,930.00 Budgeted 404.31 Remaining 97 % Used Account: 122-50016-045-000 Longevity 5,318.72 .00 5,318.72 _______________ Account: 122-50016-045-000 Longevity Totals: .00 5,318.72 ** 5,505.00 Budgeted 186.28 Remaining 97 % Used Account: 122-50017-045-000 Certification 2175 09/11/2015 FD Payroll 9/11/15 4,481.50 362.50 4,844.00 GL _______________ Account: 122-50017-045-000 Certification Totals: 362.50 4,844.00 ** 4,800.00 Budgeted (44.00) Remaining 101 % Used Account: 122-50020-045-000 Retirement 2175 09/11/2015 FD Payroll 9/11/15 65,931.25 2,473.12 68,404.37 GL 2217 09/25/2015 Fire Payroll 2,916.18 71,320.55 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,389.30 71,320.55 ** 75,327.00 Budgeted 4,006.45 Remaining 95 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 2175 09/11/2015 FD Payroll 9/11/15 50,430.88 2,652.70 53,083.58 GL 2217 09/25/2015 Fire Payroll 2,032.54 55,116.12 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,685.24 55,116.12 ** 59,169.00 Budgeted 4,052.88 Remaining 93 % Used Account: 122-50027-045-000 Dental Insurance 2175 09/11/2015 FD Payroll 9/11/15 3,858.72 175.06 4,033.78 GL 2217 09/25/2015 Fire Payroll 176.85 4,210.63 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 351.91 4,210.63 ** 4,390.00 Budgeted 179.37 Remaining 96 % Used Account: 122-50028-045-000 Vision Insurance 2175 09/11/2015 FD Payroll 9/11/15 671.38 30.29 701.67 GL 2217 09/25/2015 Fire Payroll 30.65 732.32 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 60.94 732.32 ** 811.00 Budgeted 78.68 Remaining 90 % Used Account: 122-50029-045-000 Life Insurance & Other 2175 09/11/2015 FD Payroll 9/11/15 3,372.33 148.95 3,521.28 GL 2217 09/25/2015 Fire Payroll 150.21 3,671.49 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 299.16 3,671.49 ** 4,030.00 Budgeted 358.51 Remaining 91 % Used Account: 122-50030-045-000 Social Security Taxes 2175 09/11/2015 FD Payroll 9/11/15 27,739.98 1,068.56 28,808.54 GL 2217 09/25/2015 Fire Payroll 1,244.37 30,052.91 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,312.93 30,052.91 ** 33,421.00 Budgeted 3,368.09 Remaining 90 % Used Account: 122-50035-045-000 Medicare Taxes 2175 09/11/2015 FD Payroll 9/11/15 6,486.07 249.85 6,735.92 GL 2217 09/25/2015 Fire Payroll 290.94 7,026.86 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 540.79 7,026.86 ** 7,292.00 Budgeted 265.14 Remaining 96 % Used Account: 122-50040-045-000 Unemployment Taxes 2175 09/11/2015 FD Payroll 9/11/15 (271.03) 3.70 (267.33) GL 2217 09/25/2015 Fire Payroll 4.52 (262.81) GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 8.22 (262.81) ** 1,657.00 Budgeted 1,919.81 Remaining -16 % Used Account: 122-50045-045-000 Workman's Compensation 202 09/01/2015 Sep TML Ins & Workers Comp 7,248.93 658.99 7,907.92 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 658.99 7,907.92 ** 8,692.00 Budgeted 784.08 Remaining 91 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 182.50 .00 182.50 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 182.50 ** 250.00 Budgeted 67.50 Remaining 73 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support 2242 09/30/2015 Sept A/P Invoices pd Oct TML,Shi,Verizon,Gexa,Symonds,N 5,130.66 462.50 5,593.16 TOWN OF TROPHY CLUB AP _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 5,593.16 ** 7,378.00 Budgeted 1,784.84 Remaining 76 % Used Account: 122-55045-045-000 Legal 2,040.00 .00 2,040.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-55045-045-000 Legal Totals: .00 2,040.00 ** 2,100.00 Budgeted 60.00 Remaining 97 % Used Account: 122-55080-045-000 Maintenance & Repairs 2122 09/14/2015 September A/P Fix storm damage to ridge cap 10,613.37 1,660.00 12,273.37 BENCO CONSTRUCTION SERVICESINC 35346 AP 2177 09/24/2015 August A/P Quarterly testing & service 268.75 12,542.12 AUGUST INDUSTRIES, INC 35370 AP 2177 09/24/2015 August A/P Hose testing 1,625.00 14,167.12 WATERWAY NORTH TEXAS INC 35391 AP 2177 09/24/2015 August A/P Repair bay door 480.00 14,647.12 OVERHEAD DOOR FORT WORTH 35386 AP 2177 09/24/2015 August A/P Minimum fee emergency repair t 450.00 15,097.12 BENCO CONSTRUCTION SERVICESINC 35371 AP 2219 09/30/2015 September A/P Repair bay doors 170.00 15,267.12 OVERHEAD DOOR FORT WORTH 1020 AP 2219 09/30/2015 September A/P Replace capacitor 159.00 15,426.12 Gardner Mechanical, LLC 1010 AP 2219 09/30/2015 September A/P Rug cleaning 37.24 15,463.36 G & K SERVICES 1009 AP 2219 09/30/2015 September A/P Rug cleaning 37.24 15,500.60 G & K SERVICES 1009 AP 2241 09/30/2015 PCards 8/27/15-9/28/15 SAMS CLUB #4795 150.41 15,651.01 SAMS CLUB #4795 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 THE HOME DEPOT 6581 16.48 15,667.49 THE HOME DEPOT 6581 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 PART STORE 118.28 15,785.77 PART STORE PC 2241 09/30/2015 PCards 8/27/15-9/28/15 SAMS CLUB #4795 136.88 15,922.65 SAMS CLUB #4795 PC 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (37.24) 15,885.41 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 5,272.04 15,885.41 ** 14,552.00 Budgeted (1,333.41) Remaining 109 % Used Account: 122-55090-045-000 Vehicle Maintenance 2177 09/24/2015 August A/P Vehicle Maintenance 11,005.87 3,630.89 14,636.76 SIDDONS-MARTIN EMERGENCY GROUP 35388 AP 2242 09/30/2015 Sept A/P Invoices pd Oct Vehicle Maint 2007 Pumper 856.10 15,492.86 SIDDONS-MARTIN EMERGENCY GROUP AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 4,486.99 15,492.86 ** 16,000.00 Budgeted 507.14 Remaining 97 % Used Account: 122-55160-045-000 Professional Outside Services 2177 09/24/2015 August A/P Fire Department Operational As 1,895.20 10,017.00 11,912.20 EMERGENCY SERVICES CONSULTING 35374 AP _______________ Account: 122-55160-045-000 Professional Outside Services Totals: 10,017.00 11,912.20 ** 27,438.00 Budgeted 15,525.80 Remaining 43 % Used Account: 122-60005-045-000 Telephone 51.30 .00 51.30 . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60005-045-000 Telephone Totals: .00 51.30 ** 75.00 Budgeted 23.70 Remaining 68 % Used Account: 122-60010-045-000 Communications/Mobiles 2175 09/11/2015 FD Payroll 9/11/15 4,352.53 75.00 4,427.53 GL 2242 09/30/2015 Sept A/P Invoices pd Oct TML,Shi,Verizon,Gexa,Symonds,N 92.48 4,520.01 TOWN OF TROPHY CLUB AP _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 167.48 4,520.01 ** 6,413.00 Budgeted 1,892.99 Remaining 70 % Used Account: 122-60020-045-000 Electricity/Gas 2177 09/24/2015 August A/P Electricity 8/11-9/10/15 5,081.44 1,116.05 6,197.49 HUDSON ENERGY SERVICES, LLC 35378 AP 2219 09/30/2015 September A/P Gas for fire station 8/20-9/17 65.20 6,262.69 ATMOS ENERGY 1003 AP 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (590.63) 5,672.06 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 590.62 5,672.06 ** 9,026.00 Budgeted 3,353.94 Remaining 63 % Used Account: 122-60025-045-000 Water 2242 09/30/2015 Sept A/P Invoices pd Oct September Water 1,426.60 297.80 1,724.40 TROPHY CLUB MUD (WATER BILLS) AP 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (148.90) 1,575.50 AR _______________ Account: 122-60025-045-000 Water Totals: 148.90 1,575.50 ** 2,200.00 Budgeted 624.50 Remaining 72 % Used Account: 122-60026-045-000 Cable 2241 09/30/2015 PCards 8/27/15-9/28/15 ATT*BILL PAYMENT 1,689.10 158.42 1,847.52 ATT*BILL PAYMENT PC 2241 09/30/2015 PCards 8/27/15-9/28/15 ATT*BILL PAYMENT 134.27 1,981.79 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 292.69 1,981.79 ** 1,920.00 Budgeted (61.79) Remaining 103 % Used Account: 122-60030-045-000 Rent And/Or Usage 211,829.00 .00 211,829.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 211,829.00 ** 211,829.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60035-045-000 Postage 16.43 .00 16.43 _______________ Account: 122-60035-045-000 Postage Totals: .00 16.43 ** 100.00 Budgeted 83.57 Remaining 16 % Used Account: 122-60055-045-000 Insurance 202 09/01/2015 Sep TML Ins & Workers Comp 10,340.92 940.08 11,281.00 GL _______________ Account: 122-60055-045-000 Insurance Totals: 940.08 11,281.00 ** 12,179.00 Budgeted 898.00 Remaining 93 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 219.05 .00 219.05 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 219.05 ** 220.00 Budgeted .95 Remaining 100 % Used Account: 122-60070-045-000 Dues & Memberships 15,632.85 .00 15,632.85 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 15,632.85 ** 15,689.00 Budgeted 56.15 Remaining 100 % Used Account: 122-60080-045-000 Schools & Training 4,012.59 .00 4,012.59 _______________ Account: 122-60080-045-000 Schools & Training Totals: .00 4,012.59 ** 4,280.00 Budgeted 267.41 Remaining 94 % Used Account: 122-60096-045-000 Emergency Management 1,220.00 .00 1,220.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,220.00 ** 1,400.00 Budgeted 180.00 Remaining 87 % Used Account: 122-60100-045-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2241 09/30/2015 PCards 8/27/15-9/28/15 HOLIDAY INNS 7,936.16 188.70 8,124.86 HOLIDAY INNS PC 2241 09/30/2015 PCards 8/27/15-9/28/15 HOLIDAY INNS 188.70 8,313.56 HOLIDAY INNS PC 2241 09/30/2015 PCards 8/27/15-9/28/15 HOLIDAY INNS 188.70 8,502.26 HOLIDAY INNS PC 2241 09/30/2015 PCards 8/27/15-9/28/15 HOLIDAY INNS 188.70 8,690.96 HOLIDAY INNS PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 754.80 8,690.96 ** 13,577.00 Budgeted 4,886.04 Remaining 64 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 826.15 .00 826.15 _______________ Account: 122-60125-045-000 Advertising Totals: .00 826.15 ** 5,100.00 Budgeted 4,273.85 Remaining 16 % Used Account: 122-60160-045-000 Programs & Special Projects 2241 09/30/2015 PCards 8/27/15-9/28/15 PROMOTIONS NOW 2,456.45 220.00 2,676.45 PROMOTIONS NOW PC 2241 09/30/2015 PCards 8/27/15-9/28/15 POSITIVE PROMO00 OF 00 906.21 3,582.66 POSITIVE PROMO00 OF 00 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 FORAND BALLOON IMPRINT 86.89 3,669.55 FORAND BALLOON IMPRINT PC 2241 09/30/2015 PCards 8/27/15-9/28/15 BARREL-O-MONKEYS 279.20 3,948.75 BARREL-O-MONKEYS PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 1,492.30 3,948.75 ** 4,500.00 Budgeted 551.25 Remaining 88 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 194.00 .00 194.00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 194.00 ** 1,000.00 Budgeted 806.00 Remaining 19 % Used Account: 122-60195-045-000 Flags & Repair 2237 09/30/2015 September A/P Onsite flag repair 554.85 190.00 744.85 SYMONDS FLAGS & POLES 1024 AP 2242 09/30/2015 Sept A/P Invoices pd Oct TML,Shi,Verizon,Gexa,Symonds,N 47.50 792.35 TOWN OF TROPHY CLUB AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60195-045-000 Flags & Repair Totals: 237.50 792.35 ** 2,000.00 Budgeted 1,207.65 Remaining 40 % Used Account: 122-60245-045-000 Miscellaneous Expense 2241 09/30/2015 PCards 8/27/15-9/28/15 HOT AND CREAMY DONUTS 573.99 30.00 603.99 HOT AND CREAMY DONUTS PC 2241 09/30/2015 PCards 8/27/15-9/28/15 HOT AND CREAMY DONUTS 20.00 623.99 HOT AND CREAMY DONUTS PC 2241 09/30/2015 PCards 8/27/15-9/28/15 SAMS CLUB #4795 104.92 728.91 SAMS CLUB #4795 PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 154.92 728.91 ** 1,000.00 Budgeted 271.09 Remaining 73 % Used Account: 122-65005-045-000 Fuel & Lube 2241 09/30/2015 PCards 8/27/15-9/28/15 RANDALLS FUEL 10017895 5,013.65 109.70 5,123.35 RANDALLS FUEL 10017895 PC 2242 09/30/2015 Sept A/P Invoices pd Oct 8/25-9/24/15 Fuel 452.52 5,575.87 US Bank Voyager Fleet Systems AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 562.22 5,575.87 ** 8,829.00 Budgeted 3,253.13 Remaining 63 % Used Account: 122-65010-045-000 Uniforms 2,408.30 .00 2,408.30 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 2,408.30 ** 3,000.00 Budgeted 591.70 Remaining 80 % Used Account: 122-65015-045-000 Protective Clothing 2177 09/24/2015 August A/P 6 pr pants and coats 16,177.45 11,200.88 27,378.33 CASCO INDUSTRIES INC 35372 AP 2177 09/24/2015 August A/P Structural Boot 325.00 27,703.33 CASCO INDUSTRIES INC 35372 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 11,525.88 27,703.33 ** 35,200.00 Budgeted 7,496.67 Remaining 79 % Used Account: 122-65030-045-000 Chemicals 133.51 .00 133.51 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 133.51 ** 200.00 Budgeted 66.49 Remaining 67 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-65035-045-000 Small Tools 2177 09/24/2015 August A/P SCBA & Helmet IDs T681 1,124.38 250.00 1,374.38 JEFFREY JOSEPH THOMAS 35379 AP 2241 09/30/2015 PCards 8/27/15-9/28/15 THE HOME DEPOT 6581 24.90 1,399.28 THE HOME DEPOT 6581 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 WM SUPERCENTER #5247 46.88 1,446.16 WM SUPERCENTER #5247 PC _______________ Account: 122-65035-045-000 Small Tools Totals: 321.78 1,446.16 ** 2,500.00 Budgeted 1,053.84 Remaining 58 % Used Account: 122-65055-045-000 Hardware 2242 09/30/2015 Sept A/P Invoices pd Oct TML,Shi,Verizon,Gexa,Symonds,N 6,160.50 6,160.50 TOWN OF TROPHY CLUB AP _______________ Account: 122-65055-045-000 Hardware Totals: 6,160.50 6,160.50 ** 9,000.00 Budgeted 2,839.50 Remaining 68 % Used Account: 122-65085-045-000 Office Supplies 2242 09/30/2015 Sept A/P Invoices pd Oct Fire Office Supplies 79.98 150.33 230.31 OFFICE DEPOT, INC AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 150.33 230.31 ** 500.00 Budgeted 269.69 Remaining 46 % Used Account: 122-65105-045-000 Printing 38.17 .00 38.17 _______________ Account: 122-65105-045-000 Printing Totals: .00 38.17 ** 548.00 Budgeted 509.83 Remaining 7 % Used Account: 122-69005-045-000 Capital Outlays 1,057,316.14 .00 1,057,316.14 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 1,057,316.14 ** 1,057,316.00 Budgeted (.14) Remaining 100 % Used Account: 122-69050-045-000 Radios 23,490.76 .00 23,490.76 _______________ Account: 122-69050-045-000 Radios Totals: .00 23,490.76 ** 23,500.00 Budgeted 9.24 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-69195-045-000 GASB34/Reserve for Replacement 17,950.00 .00 17,950.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 17,950.00 ** 17,950.00 Budgeted .00 Remaining 100 % Used Account: 122-69255-045-000 Airpacks 10,235.38 .00 10,235.38 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 10,235.38 ** 10,400.00 Budgeted 164.62 Remaining 98 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 2,182,432.97 ** 2,267,305.00 Budgeted 84,872.03 Remaining 96 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (37,855.34) .00 Budgeted 37,855.34 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET SEPTEMBER 2015 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 9/30/15 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 908,832 - - 908,831 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,543,870 - - 1,543,870 INVESTMENTS-TEXPOOL 1,310,935 169,600 21,462 1,501,997 PREPAID EXPENSES 26,007 - - 26,007 ADVALOREM PROPERTY TAXES RECEIVABLE 2,359 - - 2,359 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,083,656 - - 1,083,656 - TOTAL ASSETS 4,876,259 169,600 21,462 5,067,321 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,359 - - 2,359 ACCOUNTS AND OTHER PAYABLES 828,716 - 13,431 842,147 CUSTOMER DEPOSITS 306,282 - - 306,282 - TOTAL LIABILITIES 1,137,357 - 13,431 1,150,788 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 260,697 260,697 NON-SPENDABLE FUND BALANCE 13,980 13,980 ASSIGNED FUND BALANCE 1,409,006 10,268 1,419,274 UNASSIGNED FUND BALANCE 725,069 - - 725,069 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES 1,590,845 (91,097) (2,237) 1,497,514 - TOTAL FUND BALANCE 3,738,902 169,600 8,032 3,916,533 - TOTAL LIABILITIES AND FUND BALANCE 4,876,259 169,600 21,462 5,067,321 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 19:26 10/07/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 167,857.00- 167,857.00- 425.33- 167,935.30- 100.047 78.30 135-40002-000-000 Property Taxes/Delinquent 21.69- 464.35- 464.35 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 96.67- 726.70- 80.744 173.30- 135-40025-000-000 PID Surcharges 133,997.00- 133,997.00- 12,246.40- 141,216.30- 105.388 7,219.30 Subtotal: 302,754.00- 302,754.00- 12,790.09- 310,342.65- 102.507 7,588.65 135-47000-000-000 Water 5,286,045.00- 4,747,789.00- 589,252.18- 3,692,104.44- 77.765 1,055,684.56- 135-47005-000-000 Sewer 2,270,982.00- 2,270,982.00- 258,496.13- 2,138,029.59- 94.146 132,952.41- 135-47025-000-000 Penalties 63,416.00- 80,000.00- 15,747.44- 100,639.28- 125.799 20,639.28 135-47030-000-000 Service Charges 8,000.00- 10,000.00- 1,025.00- 10,599.00- 105.990 599.00 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 300.00- 2,450.00- 122.500 450.00 135-47045-000-000 Sewer Inspections 5,000.00- 5,000.00- 900.00- 7,350.00- 147.000 2,350.00 135-47070-000-000 TCCC Effluent Charges 86,815.00- 86,815.00- 14,501.90- 67,063.50- 77.249 19,751.50- Subtotal: 7,722,258.00- 7,202,586.00- 880,222.65- 6,018,235.81- 83.557 1,184,350.19- 135-48005-000-000 Utility Fees 184,000.00- 184,000.00- 16,100.00- 239,200.00- 130.000 55,200.00 Subtotal: 184,000.00- 184,000.00- 16,100.00- 239,200.00- 130.000 55,200.00 135-49010-000-000 Interest Income 5,000.00- 5,000.00- 560.13- 6,117.27- 122.345 1,117.27 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 10,926.36- 107.501 762.36 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.37- 7,000.00- 100.000 135-49030-000-000 Vending Revenue 351.00- 135-49035-000-000 Prior Year Reserves 929,603.00- 929,603.00- 135-49036-000-000 GASB Reserves 74,706.00- 74,706.00- 74,706.00- 100.000 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 42,000.00- 5,145.00- 58,023.40- 138.151 16,023.40 135-49141-000-000 Interfund Transfer In 19,607.00- 36,766.50- 187.517 17,159.50 135-49145-000-000 Intergov Transfer In 1,074,337.15- 1,074,337.15 135-49900-000-000 Miscellaneous Income 54,000.00- 68,994.00- 274.10- 108,904.62- 157.847 39,910.62 135-49901-000-000 Records Management Revenue 100.00- 100.00- 4.00- 18.20- 18.200 81.80- Subtotal: 235,321.00- 1,157,174.00- 7,477.13- 1,376,799.50- 118.979 219,625.50 Program number: 8,444,333.00- 8,846,514.00- 916,589.87- 7,944,577.96- 89.805 901,936.04- Department number: Revenues 8,444,333.00- 8,846,514.00- 916,589.87- 7,944,577.96- 89.805 901,936.04- Revenues Subtotal ----------- 8,444,333.00- 8,846,514.00- 916,589.87- 7,944,577.96- 89.805 901,936.04- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 19:26 10/07/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 301,101.00 244,578.00 26,395.16 221,838.29 90.702 22,739.71 135-50010-010-000 Overtime 19,500.00 17,768.00 3,018.93 16,317.53 91.837 1,450.47 135-50016-010-000 Longevity 5,343.00 2,705.00 2,705.00 100.000 135-50017-010-000 Certification 4,800.00 3,900.00 225.00 2,725.00 69.872 1,175.00 135-50020-010-000 Retirement 29,349.00 23,987.00 2,640.86 21,734.88 90.611 2,252.12 135-50026-010-000 Medical Insurance 44,988.00 39,487.00 5,231.86 36,698.48 92.938 2,788.52 135-50027-010-000 Dental Insurance 3,288.00 4,188.00 412.71 2,927.45 69.901 1,260.55 135-50028-010-000 Vision Insurance 834.00 990.00 93.49 677.28 68.412 312.72 135-50029-010-000 Life Insurance & Other 3,074.00 3,074.00 469.92 2,480.40 80.690 593.60 135-50030-010-000 Social Security Taxes 21,135.00 17,192.00 1,795.97 14,867.56 86.480 2,324.44 135-50035-010-000 Medicare Taxes 4,943.00 4,021.00 420.03 3,477.11 86.474 543.89 135-50040-010-000 Unemployment Taxes 1,242.00 1,242.00 1.08 24.17 1.946 1,217.83 135-50045-010-000 Workman's Compensation 16,020.00 16,020.00 857.90 8,974.91 56.023 7,045.09 135-50060-010-000 Pre-emp Physicals/Testing 1,000.00 1,300.00 1,037.25 79.788 262.75 135-50070-010-000 Employee Relations 300.00 300.00 43.41 191.59 63.863 108.41 Subtotal: 456,917.00 380,752.00 41,606.32 336,676.90 88.424 44,075.10 135-55005-010-000 Engineering 10,000.00 110,000.00 3,000.00- 4,290.00- -3.900 114,290.00 135-55080-010-000 Maintenance & Repairs 71,242.00 81,113.00 2,047.63 62,170.70 76.647 18,942.30 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 7,465.80 93.323 534.20 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 4,700.00 589.45 4,416.61 93.970 283.39 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 340.00 4,312.50 78.409 1,187.50 Subtotal: 98,242.00 209,313.00 22.92- 74,075.61 35.390 135,237.39 135-60010-010-000 Communications/Mobiles 4,913.00 4,913.00 398.18 3,997.07 81.357 915.93 135-60020-010-000 Electricity 170,765.00 150,765.00 20,816.62 136,540.76 90.565 14,224.24 135-60066-010-000 Publications/Books/Subscripts 500.00 750.00 738.50 98.467 11.50 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 4,138.00 1,738.00 1,353.00 77.848 385.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,500.00 700.00 240.29 34.327 459.71 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 23,917.91 48.540 25,357.09 135-60150-010-000 Wholesale Water 2,928,308.00 2,928,308.00 333,045.20 1,787,312.93 61.036 1,140,995.07 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 2,500.00 136.33 1,582.78 63.311 917.22 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 2,300.00 1,823.49 79.282 476.51 Subtotal: 3,169,249.00 3,144,099.00 354,396.33 1,957,506.73 62.260 1,186,592.27 135-65005-010-000 Fuel & Lube 29,172.00 14,173.00 1,134.02 12,517.27 88.318 1,655.73 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 19:26 10/07/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,620.00 3,620.00 3,184.80 87.978 435.20 135-65030-010-000 Chemicals 7,000.00 11,000.00 840.56 10,195.30 92.685 804.70 135-65035-010-000 Small Tools 1,200.00 1,200.00 357.18 994.82 82.902 205.18 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 457.01 45.701 542.99 135-65050-010-000 Meter Expense 161,500.00 133,000.00 119,269.34 89.676 13,730.66 Subtotal: 203,492.00 163,993.00 2,331.76 146,618.54 89.405 17,374.46 135-69005-010-000 Capital Outlays 1,089,006.00 1,394,997.00 122,820.14 416,294.92 29.842 978,702.08 135-69008-010-000 Short Term Debt-Principal 129,000.00 129,000.00 129,000.00 100.000 135-69009-010-000 Short Term Debt-Interest 3,612.00 3,612.00 3,631.54 100.541 19.54- 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 151,507.00 151,507.00 126,957.76 83.797 24,549.24 Subtotal: 1,448,125.00 1,754,116.00 122,820.14 750,884.22 42.807 1,003,231.78 Program number: 5,376,025.00 5,652,273.00 521,131.63 3,265,762.00 57.778 2,386,511.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 19:26 10/07/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 80.00 2,862.60 57.252 2,137.40 Subtotal: 5,000.00 5,000.00 80.00 2,862.60 57.252 2,137.40 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 2,418.75 48.375 2,581.25 Subtotal: 5,000.00 5,000.00 2,418.75 48.375 2,581.25 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 80.00 5,281.35 52.814 4,718.65 Department number: Water 5,386,025.00 5,662,273.00 521,211.63 3,271,043.35 57.769 2,391,229.65 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 19:26 10/07/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 305,744.00 307,875.00 33,472.19 305,551.50 99.245 2,323.50 135-50010-020-000 Overtime 19,500.00 26,500.00 2,655.01 27,621.80 104.233 1,121.80- 135-50016-020-000 Longevity 5,617.00 5,617.00 5,615.00 99.964 2.00 135-50017-020-000 Certification 6,600.00 6,600.00 550.00 6,600.00 100.000 135-50020-020-000 Retirement 29,948.00 30,317.00 3,267.95 30,826.11 101.679 509.11- 135-50026-020-000 Medical Insurance 61,001.00 56,244.00 6,550.03 57,601.67 102.414 1,357.67- 135-50027-020-000 Dental Insurance 4,146.00 3,696.00 418.46 3,682.48 99.634 13.52 135-50028-020-000 Vision Insurance 990.00 912.00 96.40 852.79 93.508 59.21 135-50029-020-000 Life Insurance & Other 3,194.00 3,194.00 769.30 3,903.87 122.225 709.87- 135-50030-020-000 Social Security Taxes 21,680.00 21,812.00 2,042.89 19,403.04 88.956 2,408.96 135-50035-020-000 Medicare Taxes 5,070.00 5,101.00 477.80 4,523.09 88.671 577.91 135-50040-020-000 Unemployment Taxes 1,242.00 1,242.00 13.90 1.119 1,228.10 135-50045-020-000 Workman's Compensation 16,020.00 16,020.00 857.90 8,974.91 56.023 7,045.09 135-50060-020-000 Pre-emp Physicals/Testing 150.00 300.00 189.00 63.000 111.00 135-50070-020-000 Employee Relations 550.00 650.00 523.15 80.485 126.85 Subtotal: 481,452.00 486,080.00 51,157.93 475,882.31 97.902 10,197.69 135-55080-020-000 Maintenance & Repairs 58,000.00 75,162.00 8,062.07 96,046.15 127.786 20,884.15- 135-55090-020-000 Vehicle Maintenance 3,000.00 4,000.00 16.48 3,539.73 88.493 460.27 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 1,000.00 803.29 80.329 196.71 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 3,659.28 46,758.90 85.016 8,241.10 135-55135-020-000 Lab Analysis 25,000.00 27,000.00 2,110.00 26,355.50 97.613 644.50 Subtotal: 141,500.00 162,162.00 13,847.83 173,503.57 106.994 11,341.57- 135-60010-020-000 Communications/Mobiles 4,662.00 5,500.00 359.94 5,273.60 95.884 226.40 135-60020-020-000 Electricity 149,292.00 145,500.00 924.58 135,126.68 92.871 10,373.32 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 134.85 33.713 265.15 135-60070-020-000 Dues & Memberships 250.00 325.00 307.00 94.462 18.00 135-60080-020-000 Schools & Training 4,065.00 3,065.00 1,526.00 49.788 1,539.00 135-60090-020-000 Safety Program 550.00 550.00 550.00 135-60100-020-000 Travel & per diem 1,600.00 2,000.00 431.52 2,257.41 112.871 257.41- 135-60105-020-000 Rent/Lease Equipment 9,000.00 2,000.00 1.00 .050 1,999.00 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 9,019.00 52.589 8,131.00 135-60245-020-000 Miscellaneous Expenses 300.00 300.00 19.47 6.490 280.53 135-60285-020-000 Lawn Equipment & Maintenance 500.00 1,000.00 784.59 78.459 215.41 135-60331-020-000 Interfund Transfer Out-Tax I&S 65,255.00 30,645.00 46.962 34,610.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 136,989.00 136,989.00 100.000 135-60333-020-000 Interfund Transfer Out-Reserve 71,946.00 10,278.00 71,946.00 100.000 Subtotal: 187,769.00 451,980.00 11,994.04 394,029.60 87.179 57,950.40 135-65005-020-000 Fuel & Lube 36,328.00 20,328.00 991.03 17,163.79 84.434 3,164.21 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 19:26 10/07/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-020-000 Uniforms 2,778.00 2,778.00 2,598.44 93.536 179.56 135-65030-020-000 Chemicals 30,000.00 24,000.00 3,311.31 21,409.33 89.206 2,590.67 135-65035-020-000 Small Tools 2,000.00 1,500.00 76.99 1,504.19 100.279 4.19- 135-65040-020-000 Safety Equipment 750.00 750.00 625.68 83.424 124.32 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 12,341.13 94.932 658.87 Subtotal: 84,856.00 62,356.00 4,379.33 55,642.56 89.234 6,713.44 135-69005-020-000 Capital Outlays 150,000.00 142,000.00 1,900.00- 196,760.42 138.564 54,760.42- 135-69007-020-000 LTD Payment from WW Sales 357,538.00 135-69008-020-000 Short Term Debt-Principal 56,991.00 56,991.00 56,991.00 100.000 135-69009-020-000 Short Term Debt-Interest 2,011.00 2,011.00 1,951.94 97.063 59.06 Subtotal: 566,540.00 201,002.00 1,900.00- 255,703.36 127.214 54,701.36- Program number: 1,462,117.00 1,363,580.00 79,479.13 1,354,761.40 99.353 8,818.60 Department number: Wastewater 1,462,117.00 1,363,580.00 79,479.13 1,354,761.40 99.353 8,818.60 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 19:26 10/07/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 15,000.00 2,400.00 14,900.00 99.333 100.00 135-50030-026-000 Social Security Taxes 620.00 930.00 148.80 923.80 99.333 6.20 135-50035-026-000 Medicare Taxes 145.00 218.00 34.80 216.05 99.106 1.95 135-50040-026-000 Unemployment Taxes 230.00 230.00 2.40 67.08 29.165 162.92 135-50045-026-000 Workman's Compensation 36.00 36.00 2.94 35.28 98.000 .72 Subtotal: 11,031.00 16,414.00 2,588.94 16,142.21 98.344 271.79 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 7.000 465.00 135-60075-026-000 Meetings 1,200.00 950.00 275.64 29.015 674.36 135-60080-026-000 Schools & Training 4,000.00 4,000.00 2,950.00 73.750 1,050.00 135-60100-026-000 Travel & per diem 5,000.00 4,250.00 3,478.88 81.856 771.12 135-60245-026-000 Miscellaneous Expenses 1,000.00 2,000.00 14.19 1,658.93 82.947 341.07 Subtotal: 11,850.00 11,850.00 14.19 8,398.45 70.873 3,451.55 Program number: 22,881.00 28,264.00 2,603.13 24,540.66 86.827 3,723.34 Department number: Board of Directors 22,881.00 28,264.00 2,603.13 24,540.66 86.827 3,723.34 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 19:26 10/07/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 477,578.00 470,732.00 50,365.79 464,344.67 98.643 6,387.33 135-50010-030-000 Overtime 1,000.00 1,000.00 91.80 607.83 60.783 392.17 135-50016-030-000 Longevity 3,283.00 3,283.00 3,282.50 99.985 .50 135-50020-030-000 Retirement 42,840.00 42,184.00 4,495.73 41,787.38 99.060 396.62 135-50026-030-000 Medical Insurance 65,015.00 62,000.00 7,221.65 61,098.50 98.546 901.50 135-50027-030-000 Dental Insurance 4,944.00 4,494.00 509.13 3,754.40 83.543 739.60 135-50028-030-000 Vision Insurance 1,158.00 1,116.00 117.89 1,012.38 90.715 103.62 135-50029-030-000 Life Insurance & Other 4,333.00 4,333.00 692.23 4,708.26 108.661 375.26- 135-50030-030-000 Social Security Taxes 30,079.00 29,654.00 2,912.22 27,363.02 92.274 2,290.98 135-50035-030-000 Medicare Taxes 7,422.00 7,317.00 681.09 6,399.40 87.459 917.60 135-50040-030-000 Unemployment Taxes 1,449.00 1,449.00 143.56 9.908 1,305.44 135-50045-030-000 Workman's Compensation 1,636.00 1,636.00 87.30 1,047.60 64.034 588.40 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 38.00 7.600 462.00 135-50070-030-000 Employee Relations 5,000.00 4,300.00 105.53 2,795.82 65.019 1,504.18 Subtotal: 646,237.00 633,998.00 67,280.36 618,383.32 97.537 15,614.68 135-55030-030-000 Software & Support 75,588.00 121,635.00 2,300.29 112,322.87 92.344 9,312.13 135-55070-030-000 Independent Labor 8,000.00 32,550.00 1,995.00 36,206.32 111.233 3,656.32- 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 534.94 11.888 3,965.06 135-55100-030-000 Building Maint & Supplies 6,500.00 7,000.00 130.89 6,367.61 90.966 632.39 135-55120-030-000 Cleaning Services 8,100.00 8,100.00 627.53 6,902.83 85.220 1,197.17 135-55160-030-000 Professional Outside Services 58,000.00 61,950.00 1,985.00 22,102.45 35.678 39,847.55 135-55161-030-000 Town Personnel Contract 6,170.00 26,170.00 26,170.00 100.000 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 1,093.98 7,282.45 88.810 917.55 Subtotal: 175,258.00 270,305.00 8,132.69 217,889.47 80.609 52,415.53 135-60005-030-000 Telephone 13,361.00 13,361.00 350.72 10,977.21 82.159 2,383.79 135-60010-030-000 Communications/Mobiles 4,056.00 4,056.00 337.99 4,053.23 99.932 2.77 135-60020-030-000 Electricity/Gas 14,978.00 12,000.00 1,873.93 10,383.55 86.530 1,616.45 135-60025-030-000 Water 1,500.00 1,500.00 124.01 922.12 61.475 577.88 135-60035-030-000 Postage 28,500.00 30,500.00 1,812.10 29,393.86 96.373 1,106.14 135-60040-030-000 Service Charges & Fees 32,000.00 45,000.00 5,448.67 45,819.71 101.822 819.71- 135-60050-030-000 Bad Debt Expense 6,200.00 3,000.00 1,711.95 57.065 1,288.05 135-60055-030-000 Insurance 48,751.00 48,751.00 4,063.01 49,110.37 100.737 359.37- 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,600.00 1,223.77 76.486 376.23 135-60070-030-000 Dues & Memberships 5,000.00 6,000.00 4,557.95 75.966 1,442.05 135-60075-030-000 Meetings 400.00 400.00 60.11 15.028 339.89 135-60079-030-000 Public Education 5,000.00 4,078.00 3,384.79 83.001 693.21 135-60080-030-000 Schools & Training 10,235.00 7,235.00 2,938.00 40.608 4,297.00 135-60100-030-000 Travel & per diem 5,400.00 4,000.00 48.36 2,017.79 50.445 1,982.21 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 19:26 10/07/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 1,289.22 1,289.22- 135-60125-030-000 Advertising 2,500.00 7,255.00 613.62 6,368.92 87.787 886.08 135-60235-030-000 Security 1,350.00 1,350.00 59.85 4.433 1,290.15 135-60245-030-000 Miscellaneous Expenses 17,500.00 17,500.00 10,731.70 61.324 6,768.30 135-60270-030-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 100.000 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 14,000.00 14,000.00 100.000 135-60360-030-000 Furniture/Equipment < $5000 10,475.00 11,036.00 1,303.48 6,339.44 57.443 4,696.56 Subtotal: 218,406.00 242,822.00 15,975.89 215,343.54 88.684 27,478.46 135-65010-030-000 Uniforms 1,855.00 1,855.00 1,043.00 56.226 812.00 135-65055-030-000 Hardware 75,966.00 35,226.00 34,312.29 97.406 913.71 135-65085-030-000 Office Supplies 9,000.00 9,000.00 313.93 8,030.99 89.233 969.01 135-65090-030-000 Printer Supplies & Maintenance 4,732.00 4,732.00 2,760.80 58.343 1,971.20 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 388.14 4,323.20 86.464 676.80 135-65097-030-000 Vending Machine Supplies 200.00 200.00 200.00 135-65105-030-000 Printing 4,800.00 3,000.00 1,332.56 44.419 1,667.44 Subtotal: 101,553.00 59,013.00 702.07 51,802.84 87.782 7,210.16 135-69005-030-000 Capital Outlays 125,000.00 62,000.00 61,821.66 99.712 178.34 135-69170-030-000 Copier Lease Installments 4,236.00 4,236.00 77.30 3,484.72 82.264 751.28 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 16,329.00 16,329.00 100.000 Subtotal: 145,565.00 82,565.00 77.30 81,635.38 98.874 929.62 Program number: 1,287,019.00 1,288,703.00 92,168.31 1,185,054.55 91.957 103,648.45 Department number: Administration 1,287,019.00 1,288,703.00 92,168.31 1,185,054.55 91.957 103,648.45 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 19:26 10/07/15 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 250,000.00 467,403.00 31,247.01 484,191.93 103.592 16,788.93- 135-55055-039-000 Auditing 22,491.00 22,491.00 5,000.00 21,836.00 97.088 655.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 1,882.21 9,846.37 98.464 153.63 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,456.40 64.642 1,343.60 Subtotal: 286,291.00 503,694.00 38,129.22 518,330.70 102.906 14,636.70- Program number: 286,291.00 503,694.00 38,129.22 518,330.70 102.906 14,636.70- Department number: Non Departmental 286,291.00 503,694.00 38,129.22 518,330.70 102.906 14,636.70- Expenditures Subtotal ----------- 8,444,333.00 8,846,514.00 733,591.42 6,353,730.66 71.822 2,492,783.34 Fund number: 135 MUD 1 General Fund 182,998.45- 1,590,847.30- 1,590,847.30 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 19:26 10/07/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 91,329.00- 91,329.00 137-49146-000-000 Intergov Transfer-Fire Dept 17,950.00- 17,950.00 Subtotal: 109,279.00- 109,279.00 Program number: 109,279.00- 109,279.00 Department number: 109,279.00- 109,279.00 Revenues Subtotal ----------- 109,279.00- 109,279.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 19:26 10/07/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-030-000 GASB Replacement 74,706.00 74,706.00- Subtotal: 74,706.00 74,706.00- Program number: 74,706.00 74,706.00- Department number: Administration 74,706.00 74,706.00- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 19:26 10/07/15 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-69195-045-000 GASB Replacement 125,670.00 125,670.00- Subtotal: 125,670.00 125,670.00- Program number: 125,670.00 125,670.00- Department number: Fire Department 125,670.00 125,670.00- Expenditures Subtotal ----------- 200,376.00 200,376.00- Fund number: 137 MUD 1 Consolidated GASB 91,097.00 91,097.00- . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 19:26 10/07/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 1.48- 13.43- 13.43 Subtotal: 1.48- 13.43- 13.43 Program number: 1.48- 13.43- 13.43 Department number: 1.48- 13.43- 13.43 Revenues Subtotal ----------- 1.48- 13.43- 13.43 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 19:26 10/07/15 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Rep/Ind Crk Waterline 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Subtotal: 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Program number: 3 Indian Creek Waterline 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Department number: Water 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Expenditures Subtotal ----------- 3,348.00 3,348.00 2,250.00 67.204 1,098.00 Fund number: 507 MUD 1 Capital Projects 3,348.00 3,348.00 1.48- 2,236.57 66.803 1,111.43 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 2243 09/02/2015 Property Taxes/Assessments (167,509.97) (7.25) (167,517.22) GL 2244 09/03/2015 Property Taxes/Assessments (419.35) (167,936.57) GL 2245 09/04/2015 Property Taxes/Assessments (4.48) (167,941.05) GL 2248 09/08/2015 Property Taxes/Assessments (.46) (167,941.51) GL 2249 09/10/2015 Property Taxes/Assessments (26.78) (167,968.29) GL 2251 09/14/2015 Property Taxes/Assessments (2.00) (167,970.29) GL 2252 09/15/2015 Property Taxes/Assessments 45.14 (167,925.15) GL 2253 09/21/2015 Property Taxes/Assessments (4.46) (167,929.61) GL 2254 09/22/2015 Property Taxes/Assessments (.67) (167,930.28) GL 2255 09/23/2015 Property Taxes/Assessments (.40) (167,930.68) GL 2256 09/25/2015 Property Taxes/Assessments (3.12) (167,933.80) GL 2257 09/29/2015 Property Taxes/Assessments (1.50) (167,935.30) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (425.33) (167,935.30) ** (167,857.00) Budgeted 78.30 Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 2244 09/03/2015 Property Taxes/Assessments (442.66) (26.50) (469.16) GL 2252 09/15/2015 Property Taxes/Assessments 4.81 (464.35) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (21.69) (464.35) ** .00 Budgeted 464.35 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 2243 09/02/2015 Property Taxes/Assessments (630.03) (.51) (630.54) GL 2244 09/03/2015 Property Taxes/Assessments (88.14) (718.68) GL 2245 09/04/2015 Property Taxes/Assessments (.03) (718.71) GL 2248 09/08/2015 Property Taxes/Assessments (.09) (718.80) GL 2249 09/10/2015 Property Taxes/Assessments (5.08) (723.88) GL 2251 09/14/2015 Property Taxes/Assessments (.41) (724.29) GL 2253 09/21/2015 Property Taxes/Assessments (1.63) (725.92) GL 2254 09/22/2015 Property Taxes/Assessments (.24) (726.16) GL 2255 09/23/2015 Property Taxes/Assessments (.03) (726.19) GL 2256 09/25/2015 Property Taxes/Assessments (.25) (726.44) GL 2257 09/29/2015 Property Taxes/Assessments (.26) (726.70) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (96.67) (726.70) ** (900.00) Budgeted (173.30) Remaining 81 % Used Account: 135-40025-000-000 PID Surcharges . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2235 09/30/2015 UB 9/30/15 Billing UB20150930-20150930 User: (128,969.90) (12,246.40) (141,216.30) UB _______________ Account: 135-40025-000-000 PID Surcharges Totals: (12,246.40) (141,216.30) ** (133,997.00) Budgeted 7,219.30 Remaining 105 % Used Account: 135-47000-000-000 Water 2235 09/30/2015 UB 9/30/15 Billing UB20150930-20150930 User: (3,102,852.26) (589,252.18) (3,692,104.44) UB _______________ Account: 135-47000-000-000 Water Totals: (589,252.18) (3,692,104.44) ** (4,747,789.00) Budgeted (1,055,684.56) Remaining 78 % Used Account: 135-47005-000-000 Sewer 2235 09/30/2015 UB 9/30/15 Billing UB20150930-20150930 User: (1,879,533.46) (258,496.13) (2,138,029.59) UB _______________ Account: 135-47005-000-000 Sewer Totals: (258,496.13) (2,138,029.59) ** (2,270,982.00) Budgeted (132,952.41) Remaining 94 % Used Account: 135-47025-000-000 Penalties 2210 09/10/2015 UB 9/10/15 Penalty removals UB20150910-20150910 User: (84,891.84) 158.93 (84,732.91) UB 2167 09/22/2015 UB 9/22/15 Penalties UB20150922-20150922 User: (16,699.05) (101,431.96) UB 2234 09/30/2015 UB 9/30/15 Penalties UB20150930-20150930 User: 792.68 (100,639.28) UB _______________ Account: 135-47025-000-000 Penalties Totals: (15,747.44) (100,639.28) ** (80,000.00) Budgeted 20,639.28 Remaining 126 % Used Account: 135-47030-000-000 Service Charges 2099 09/10/2015 UB 9/10/15 Cut off fees UB20150910-20150910 User: (9,574.00) (850.00) (10,424.00) UB 2211 09/18/2015 UB 9/18/15 NSF Check Fee UB20150918-20150918 User: (25.00) (10,449.00) UB 2213 09/21/2015 UB 9/21/15 NSF Check Fee UB20150921-20150921 User: (25.00) (10,474.00) UB 2215 09/24/2015 UB 9/24/15 NSF Check Fee UB20150924-20150924 User: (125.00) (10,599.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,025.00) (10,599.00) ** (10,000.00) Budgeted 599.00 Remaining 106 % Used Account: 135-47035-000-000 Plumbing Inspections 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (2,150.00) (300.00) (2,450.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (300.00) (2,450.00) ** (2,000.00) Budgeted 450.00 Remaining 123 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47045-000-000 Sewer Inspections 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (6,450.00) (900.00) (7,350.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (900.00) (7,350.00) ** (5,000.00) Budgeted 2,350.00 Remaining 147 % Used Account: 135-47070-000-000 TCCC Effluent Charges 2235 09/30/2015 UB 9/30/15 Billing UB20150930-20150930 User: (52,561.60) (14,501.90) (67,063.50) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (14,501.90) (67,063.50) ** (86,815.00) Budgeted (19,751.50) Remaining 77 % Used Account: 135-48005-000-000 Utility Fees 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (223,100.00) (16,100.00) (239,200.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (16,100.00) (239,200.00) ** (184,000.00) Budgeted 55,200.00 Remaining 130 % Used Account: 135-49010-000-000 Interest Income 2246 09/30/2015 Bank Interest/September (5,557.14) (103.18) (5,660.32) GL 2246 09/30/2015 Bank Interest/September (143.13) (5,803.45) GL 2246 09/30/2015 Bank Interest/September (309.98) (6,113.43) GL 2246 09/30/2015 Bank Interest/September (3.84) (6,117.27) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (560.13) (6,117.27) ** (5,000.00) Budgeted 1,117.27 Remaining 122 % Used Account: 135-49016-000-000 Cell Tower Revenue 2134 09/01/2015 AT&T Cell Tower Revenue (10,015.83) (910.53) (10,926.36) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (10,926.36) ** (10,164.00) Budgeted 762.36 Remaining 108 % Used Account: 135-49018-000-000 Building Rent Income 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (6,416.63) (583.37) (7,000.00) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.37) (7,000.00) ** (7,000.00) Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (929,603.00) Budgeted (929,603.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves (74,706.00) .00 (74,706.00) _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 (74,706.00) ** (74,706.00) Budgeted .00 Remaining 100 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (52,878.40) (5,145.00) (58,023.40) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (5,145.00) (58,023.40) ** (42,000.00) Budgeted 16,023.40 Remaining 138 % Used Account: 135-49141-000-000 Interfund Transfer In (36,766.50) .00 (36,766.50) _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (36,766.50) ** (19,607.00) Budgeted 17,159.50 Remaining 188 % Used Account: 135-49145-000-000 Intergov Transfer In (1,074,337.15) .00 (1,074,337.15) _______________ Account: 135-49145-000-000 Intergov Transfer In Totals: .00 (1,074,337.15) ** .00 Budgeted 1,074,337.15 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 2135 09/01/2015 Open Records Request-Lamont (108,630.52) (2.00) (108,632.52) GL 2187 09/25/2015 Adjust Accts Receivable (246.97) (108,879.49) GL 2235 09/30/2015 UB 9/30/15 Billing UB20150930-20150930 User: (25.08) (108,904.57) UB 2250 09/30/2015 Expert Pay Test Deposit (.05) (108,904.62) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (274.10) (108,904.62) ** (68,994.00) Budgeted 39,910.62 Remaining 158 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49901-000-000 Records Management Revenue 2136 09/01/2015 Open Records Req-Sanders (14.20) (2.00) (16.20) GL 2222 09/25/2015 Open records Request/Mayer (2.00) (18.20) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (4.00) (18.20) ** (100.00) Budgeted (81.80) Remaining 18 % Used Department Totals: ------------------------------------------------------------------------------------------------ (7,944,577.96) ** (8,846,514.00) Budgeted (901,936.04) Remaining 90 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 2089 09/11/2015 MUD Payroll 9/11/15 Salaries & Wages 195,443.13 9,738.37 205,181.50 PR 2168 09/25/2015 MUD Payroll 9/25/15 Salaries & Wages 9,911.72 215,093.22 PR 2262 09/30/2015 Accrue Sept Wages 6,745.07 221,838.29 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 26,395.16 221,838.29 ** 244,578.00 Budgeted 22,739.71 Remaining 91 % Used Account: 135-50010-010-000 Overtime 2089 09/11/2015 MUD Payroll 9/11/15 Overtime 13,298.60 1,355.09 14,653.69 PR 2168 09/25/2015 MUD Payroll 9/25/15 Overtime 797.24 15,450.93 PR 2262 09/30/2015 Accrue Sept Wages 866.60 16,317.53 PR _______________ Account: 135-50010-010-000 Overtime Totals: 3,018.93 16,317.53 ** 17,768.00 Budgeted 1,450.47 Remaining 92 % Used Account: 135-50016-010-000 Longevity 2,705.00 .00 2,705.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,705.00 ** 2,705.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 2168 09/25/2015 MUD Payroll 9/25/15 Certification 2,500.00 225.00 2,725.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 225.00 2,725.00 ** 3,900.00 Budgeted 1,175.00 Remaining 70 % Used Account: 135-50020-010-000 Retirement 2089 09/11/2015 MUD Payroll 9/11/15 Retirement 19,094.02 988.43 20,082.45 PR 2168 09/25/2015 MUD Payroll 9/25/15 Retirement 974.23 21,056.68 PR 2262 09/30/2015 Accrue Sept Wages 678.20 21,734.88 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,640.86 21,734.88 ** 23,987.00 Budgeted 2,252.12 Remaining 91 % Used Account: 135-50026-010-000 Medical Insurance 2089 09/11/2015 MUD Payroll 9/11/15 Medical Insurance 31,466.62 1,946.94 33,413.56 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2168 09/25/2015 MUD Payroll 9/25/15 Medical Insurance 31,466.62 1,946.88 35,360.44 PR 2262 09/30/2015 Accrue Sept Wages 1,338.04 36,698.48 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 5,231.86 36,698.48 ** 39,487.00 Budgeted 2,788.52 Remaining 93 % Used Account: 135-50027-010-000 Dental Insurance 2089 09/11/2015 MUD Payroll 9/11/15 Dental Insurance 2,514.74 151.51 2,666.25 PR 2168 09/25/2015 MUD Payroll 9/25/15 Dental Insurance 151.51 2,817.76 PR 2262 09/30/2015 Accrue Sept Wages 109.69 2,927.45 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 412.71 2,927.45 ** 4,188.00 Budgeted 1,260.55 Remaining 70 % Used Account: 135-50028-010-000 Vision Insurance 2089 09/11/2015 MUD Payroll 9/11/15 Vision Insurance 583.79 34.46 618.25 PR 2168 09/25/2015 MUD Payroll 9/25/15 Vision Insurance 34.51 652.76 PR 2262 09/30/2015 Accrue Sept Wages 24.52 677.28 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 93.49 677.28 ** 990.00 Budgeted 312.72 Remaining 68 % Used Account: 135-50029-010-000 Life Insurance & Other 2008 09/01/2015 September A/P Dental, vision, misc insurance 2,010.48 212.31 2,222.79 METLIFE GROUP BENEFITS 35292 AP 2219 09/30/2015 September A/P Café 125 Admin 8.44 2,231.23 BenefitMall 1004 AP 2242 09/30/2015 Sept A/P Invoices pd Oct TML,Shi,Verizon,Gexa,Symonds,N 249.17 2,480.40 TOWN OF TROPHY CLUB AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 469.92 2,480.40 ** 3,074.00 Budgeted 593.60 Remaining 81 % Used Account: 135-50030-010-000 Social Security Taxes 2089 09/11/2015 MUD Payroll 9/11/15 Social Security Taxes 13,071.59 675.53 13,747.12 PR 2168 09/25/2015 MUD Payroll 9/25/15 Social Security Taxes 661.52 14,408.64 PR 2262 09/30/2015 Accrue Sept Wages 458.92 14,867.56 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,795.97 14,867.56 ** 17,192.00 Budgeted 2,324.44 Remaining 86 % Used Account: 135-50035-010-000 Medicare Taxes . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2089 09/11/2015 MUD Payroll 9/11/15 Medicare Taxes 3,057.08 157.97 3,215.05 PR 2168 09/25/2015 MUD Payroll 9/25/15 Medicare Taxes 154.71 3,369.76 PR 2262 09/30/2015 Accrue Sept Wages 107.35 3,477.11 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 420.03 3,477.11 ** 4,021.00 Budgeted 543.89 Remaining 86 % Used Account: 135-50040-010-000 Unemployment Taxes 2089 09/11/2015 MUD Payroll 9/11/15 Unemployment Taxes 23.09 1.06 24.15 PR 2168 09/25/2015 MUD Payroll 9/25/15 Unemployment Taxes .02 24.17 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 1.08 24.17 ** 1,242.00 Budgeted 1,217.83 Remaining 2 % Used Account: 135-50045-010-000 Workman's Compensation 202 09/01/2015 Sep TML Ins & Workers Comp 8,117.01 857.90 8,974.91 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 857.90 8,974.91 ** 16,020.00 Budgeted 7,045.09 Remaining 56 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1,037.25 .00 1,037.25 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 1,037.25 ** 1,300.00 Budgeted 262.75 Remaining 80 % Used Account: 135-50070-010-000 Employee Relations 2241 09/30/2015 PCards 8/27/15-9/28/15 WHATABURGER 754 Q26 148.18 43.41 191.59 WHATABURGER 754 Q26 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 43.41 191.59 ** 300.00 Budgeted 108.41 Remaining 64 % Used Account: 135-55005-010-000 Engineering 2196 09/15/2015 Maguire Solana Land Inv 1348 AR 20150915-20150915 User: (1,290.00) (3,000.00) (4,290.00) AR _______________ Account: 135-55005-010-000 Engineering Totals: (3,000.00) (4,290.00) ** 110,000.00 Budgeted 114,290.00 Remaining -4 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-010-000 Maintenance & Repairs 2122 09/14/2015 September A/P Welding legs to frame for gene 60,123.07 400.00 60,523.07 MENA'S WELDING SERVICES, LLC 35357 AP 2122 09/14/2015 September A/P Vac trailer repair 403.77 60,926.84 CLS SEWER EQUIPMENT CO INC 35347 AP 2177 09/24/2015 August A/P 3" Gaskets 13.50 60,940.34 ATLAS UTILITY SUPPLY CO. 35369 AP 2177 09/24/2015 August A/P 2" Pump 600.38 61,540.72 HD SUPPLY WATERWORKS, LTD. 35377 AP 2241 09/30/2015 PCards 8/27/15-9/28/15 THE WILSON BOHANNAN CO 486.48 62,027.20 THE WILSON BOHANNAN CO PC 2241 09/30/2015 PCards 8/27/15-9/28/15 JMS RUSSEL METALS CORP 143.50 62,170.70 JMS RUSSEL METALS CORP PC _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 2,047.63 62,170.70 ** 81,113.00 Budgeted 18,942.30 Remaining 77 % Used Account: 135-55090-010-000 Vehicle Maintenance 7,465.80 .00 7,465.80 _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 7,465.80 ** 8,000.00 Budgeted 534.20 Remaining 93 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2122 09/14/2015 September A/P Vac truck repair 3,827.16 589.45 4,416.61 CLS SEWER EQUIPMENT CO INC 35347 AP _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 589.45 4,416.61 ** 4,700.00 Budgeted 283.39 Remaining 94 % Used Account: 135-55135-010-000 Lab Analysis 2122 09/14/2015 September A/P Water samples 3,972.50 340.00 4,312.50 TARRANT CTY PUBLIC HEALTH LAB 35361 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 340.00 4,312.50 ** 5,500.00 Budgeted 1,187.50 Remaining 78 % Used Account: 135-60010-010-000 Communications/Mobiles 2122 09/14/2015 September A/P Cell phones 8/2-9/1/15 3,598.89 398.18 3,997.07 VERIZON WIRELESS 35366 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 398.18 3,997.07 ** 4,913.00 Budgeted 915.93 Remaining 81 % Used Account: 135-60020-010-000 Electricity 2122 09/14/2015 September A/P Electricity 8/10/-9/9/15 115,724.14 57.64 115,781.78 HUDSON ENERGY SERVICES, LLC 35351 AP 2122 09/14/2015 September A/P Electricity 8/10-9/9/15 97.26 115,879.04 HUDSON ENERGY SERVICES, LLC 35351 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2177 09/24/2015 August A/P Electricity 8/11-9/10/15 115,724.14 2,775.71 118,654.75 HUDSON ENERGY SERVICES, LLC 35378 AP 2177 09/24/2015 August A/P Electricity 8/11-9/10/15 17,886.01 136,540.76 HUDSON ENERGY SERVICES, LLC 35378 AP _______________ Account: 135-60020-010-000 Electricity Totals: 20,816.62 136,540.76 ** 150,765.00 Budgeted 14,224.24 Remaining 91 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 738.50 .00 738.50 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 738.50 ** 750.00 Budgeted 11.50 Remaining 98 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 1,353.00 .00 1,353.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 1,353.00 ** 1,738.00 Budgeted 385.00 Remaining 78 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 240.29 .00 240.29 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 240.29 ** 700.00 Budgeted 459.71 Remaining 34 % Used Account: 135-60105-010-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 23,917.91 .00 23,917.91 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 23,917.91 ** 49,275.00 Budgeted 25,357.09 Remaining 49 % Used Account: 135-60150-010-000 Wholesale Water 2219 09/30/2015 September A/P Wholesale Water August 1,454,267.73 333,045.20 1,787,312.93 CITY OF FORT WORTH 1005 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 333,045.20 1,787,312.93 ** 2,928,308.00 Budgeted 1,140,995.07 Remaining 61 % 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 2241 09/30/2015 PCards 8/27/15-9/28/15 FORT WORTH GRASS AND S 1,446.45 46.33 1,492.78 FORT WORTH GRASS AND S PC 2241 09/30/2015 PCards 8/27/15-9/28/15 DENTON SAND & GRAVEL, 90.00 1,582.78 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 136.33 1,582.78 ** 2,500.00 Budgeted 917.22 Remaining 63 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,823.49 .00 1,823.49 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 1,823.49 ** 2,300.00 Budgeted 476.51 Remaining 79 % Used Account: 135-65005-010-000 Fuel & Lube 2242 09/30/2015 Sept A/P Invoices pd Oct 8/25-9/24/15 Fuel 11,383.25 1,134.02 12,517.27 US Bank Voyager Fleet Systems AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,134.02 12,517.27 ** 14,173.00 Budgeted 1,655.73 Remaining 88 % Used Account: 135-65010-010-000 Uniforms 3,184.80 .00 3,184.80 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 3,184.80 ** 3,620.00 Budgeted 435.20 Remaining 88 % Used Account: 135-65030-010-000 Chemicals 2122 09/14/2015 September A/P Chemicals 9,354.74 224.78 9,579.52 HACH COMPANY 35350 AP 2122 09/14/2015 September A/P Chemicals 116.30 9,695.82 HACH COMPANY 35350 AP 2219 09/30/2015 September A/P Chemicals 45.18 9,741.00 HACH COMPANY 1014 AP 2219 09/30/2015 September A/P Pipet tip 47.70 9,788.70 HACH COMPANY 1014 AP 2242 09/30/2015 Sept A/P Invoices pd Oct Chlorine 406.60 10,195.30 DPC INDUSTRIES, INC AP _______________ Account: 135-65030-010-000 Chemicals Totals: 840.56 10,195.30 ** 11,000.00 Budgeted 804.70 Remaining 93 % Used Account: 135-65035-010-000 Small Tools 2241 09/30/2015 PCards 8/27/15-9/28/15 THE HOME DEPOT 6581 637.64 322.85 960.49 THE HOME DEPOT 6581 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 THE HOME DEPOT 6581 34.33 994.82 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-010-000 Small Tools Totals: 357.18 994.82 ** 1,200.00 Budgeted 205.18 Remaining 83 % Used Account: 135-65040-010-000 Safety Equipment 457.01 .00 457.01 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 457.01 ** 1,000.00 Budgeted 542.99 Remaining 46 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65050-010-000 Meter Expense 119,269.34 .00 119,269.34 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 119,269.34 ** 133,000.00 Budgeted 13,730.66 Remaining 90 % Used Account: 135-69005-010-000 Capital Outlays 2060 09/02/2015 September A/P Wire up Generator 293,474.78 3,471.10 296,945.88 DHS AUTOMATION, INC 35309 AP 2108 09/10/2015 Correct Pebble Beach Retainage 1,900.00 298,845.88 GL 2122 09/14/2015 September A/P Waterline replacement PO, PB, 389.10 299,234.98 TEAGUE, NALL & PERKINS,INC 35363 AP 2239 09/30/2015 McClendon App 2 Retainage 11,631.30 310,866.28 GL 2242 09/30/2015 Sept A/P Invoices pd Oct Waterline Replacement Pebble B 746.94 311,613.22 TEAGUE, NALL & PERKINS,INC AP 2242 09/30/2015 Sept A/P Invoices pd Oct Pebble Beach, Pin Oak Ct, Timb 104,681.70 416,294.92 MCCLENDON CONSTRUCTION CO INC AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 122,820.14 416,294.92 ** 1,394,997.00 Budgeted 978,702.08 Remaining 30 % Used Account: 135-69008-010-000 Short Term Debt-Principal 129,000.00 .00 129,000.00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 129,000.00 ** 129,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt-Interest 3,631.54 .00 3,631.54 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 3,631.54 ** 3,612.00 Budgeted (19.54) 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 126,957.76 .00 126,957.76 . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 126,957.76 ** 151,507.00 Budgeted 24,549.24 Remaining 84 % Used Account: 135-55135-010-001 Lab Analysis for PID 2122 09/14/2015 September A/P Water samples 2,782.60 80.00 2,862.60 TARRANT CTY PUBLIC HEALTH LAB 35361 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 2,862.60 ** 5,000.00 Budgeted 2,137.40 Remaining 57 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID 2,418.75 .00 2,418.75 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 2,418.75 ** 5,000.00 Budgeted 2,581.25 Remaining 48 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 3,271,043.35 ** 5,662,273.00 Budgeted 2,391,229.65 Remaining 58 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 2089 09/11/2015 MUD Payroll 9/11/15 Salaries & Wages 272,079.31 11,916.35 283,995.66 PR 2168 09/25/2015 MUD Payroll 9/25/15 Salaries & Wages 11,841.35 295,837.01 PR 2171 09/25/2015 Supplemental P/R 9/25/15 Salaries & Wages 250.00 296,087.01 PR 2220 09/30/2015 Transfer Interim pay to OT (325.00) 295,762.01 GL 2262 09/30/2015 Accrue Sept Wages 9,789.49 305,551.50 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 33,472.19 305,551.50 ** 307,875.00 Budgeted 2,323.50 Remaining 99 % Used Account: 135-50010-020-000 Overtime 2089 09/11/2015 MUD Payroll 9/11/15 Overtime 24,966.79 1,082.86 26,049.65 PR 2168 09/25/2015 MUD Payroll 9/25/15 Overtime 946.84 26,996.49 PR 2220 09/30/2015 Transfer Interim pay to OT 325.00 27,321.49 GL 2262 09/30/2015 Accrue Sept Wages 300.31 27,621.80 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,655.01 27,621.80 ** 26,500.00 Budgeted (1,121.80) Remaining 104 % Used Account: 135-50016-020-000 Longevity 5,615.00 .00 5,615.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 5,615.00 ** 5,617.00 Budgeted 2.00 Remaining 100 % Used Account: 135-50017-020-000 Certification 2168 09/25/2015 MUD Payroll 9/25/15 Certification 6,050.00 550.00 6,600.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 550.00 6,600.00 ** 6,600.00 Budgeted .00 Remaining 100 % Used Account: 135-50020-020-000 Retirement 2089 09/11/2015 MUD Payroll 9/11/15 Retirement 27,558.16 1,158.23 28,716.39 PR 2168 09/25/2015 MUD Payroll 9/25/15 Retirement 1,188.43 29,904.82 PR 2171 09/25/2015 Supplemental P/R 9/25/15 Retirement 22.28 29,927.10 PR 2262 09/30/2015 Accrue Sept Wages 899.01 30,826.11 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,267.95 30,826.11 ** 30,317.00 Budgeted (509.11) Remaining 102 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50026-020-000 Medical Insurance 2089 09/11/2015 MUD Payroll 9/11/15 Medical Insurance 51,051.64 2,343.40 53,395.04 PR 2168 09/25/2015 MUD Payroll 9/25/15 Medical Insurance 2,343.35 55,738.39 PR 2262 09/30/2015 Accrue Sept Wages 1,863.28 57,601.67 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 6,550.03 57,601.67 ** 56,244.00 Budgeted (1,357.67) Remaining 102 % Used Account: 135-50027-020-000 Dental Insurance 2089 09/11/2015 MUD Payroll 9/11/15 Dental Insurance 3,264.02 149.75 3,413.77 PR 2168 09/25/2015 MUD Payroll 9/25/15 Dental Insurance 149.76 3,563.53 PR 2262 09/30/2015 Accrue Sept Wages 118.95 3,682.48 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 418.46 3,682.48 ** 3,696.00 Budgeted 13.52 Remaining 100 % Used Account: 135-50028-020-000 Vision Insurance 2089 09/11/2015 MUD Payroll 9/11/15 Vision Insurance 756.39 34.48 790.87 PR 2168 09/25/2015 MUD Payroll 9/25/15 Vision Insurance 34.52 825.39 PR 2262 09/30/2015 Accrue Sept Wages 27.40 852.79 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 96.40 852.79 ** 912.00 Budgeted 59.21 Remaining 94 % Used Account: 135-50029-020-000 Life Insurance & Other 2008 09/01/2015 September A/P Dental, vision, misc insurance 3,134.57 255.58 3,390.15 METLIFE GROUP BENEFITS 35292 AP 2219 09/30/2015 September A/P Café 125 Admin 33.78 3,423.93 BenefitMall 1004 AP 2242 09/30/2015 Sept A/P Invoices pd Oct TML,Shi,Verizon,Gexa,Symonds,N 479.94 3,903.87 TOWN OF TROPHY CLUB AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 769.30 3,903.87 ** 3,194.00 Budgeted (709.87) Remaining 122 % Used Account: 135-50030-020-000 Social Security Taxes 2089 09/11/2015 MUD Payroll 9/11/15 Social Security Taxes 17,360.15 732.24 18,092.39 PR 2168 09/25/2015 MUD Payroll 9/25/15 Social Security Taxes 738.09 18,830.48 PR 2171 09/25/2015 Supplemental P/R 9/25/15 Social Security Taxes 15.50 18,845.98 PR 2262 09/30/2015 Accrue Sept Wages 557.06 19,403.04 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,042.89 19,403.04 ** 21,812.00 Budgeted 2,408.96 Remaining 89 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50035-020-000 Medicare Taxes 2089 09/11/2015 MUD Payroll 9/11/15 Medicare Taxes 4,045.29 171.25 4,216.54 PR 2168 09/25/2015 MUD Payroll 9/25/15 Medicare Taxes 172.61 4,389.15 PR 2171 09/25/2015 Supplemental P/R 9/25/15 Medicare Taxes 3.63 4,392.78 PR 2262 09/30/2015 Accrue Sept Wages 130.31 4,523.09 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 477.80 4,523.09 ** 5,101.00 Budgeted 577.91 Remaining 89 % Used Account: 135-50040-020-000 Unemployment Taxes 13.90 .00 13.90 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 13.90 ** 1,242.00 Budgeted 1,228.10 Remaining 1 % Used Account: 135-50045-020-000 Workman's Compensation 202 09/01/2015 Sep TML Ins & Workers Comp 8,117.01 857.90 8,974.91 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 857.90 8,974.91 ** 16,020.00 Budgeted 7,045.09 Remaining 56 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 189.00 .00 189.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 189.00 ** 300.00 Budgeted 111.00 Remaining 63 % Used Account: 135-50070-020-000 Employee Relations 523.15 .00 523.15 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 523.15 ** 650.00 Budgeted 126.85 Remaining 80 % Used Account: 135-55080-020-000 Maintenance & Repairs 2123 09/14/2015 September A/P Bar screen repair 87,984.08 2,561.11 90,545.19 REY-MAR CONSTRUCTION 35360 AP 2182 09/24/2015 September A/P Hydromatic Pump Repair 5,317.14 95,862.33 NORTH TEXAS PUMP CO. 35394 AP 2241 09/30/2015 PCards 8/27/15-9/28/15 THE HOME DEPOT 6581 44.82 95,907.15 THE HOME DEPOT 6581 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 THE HOME DEPOT 6581 42.90 95,950.05 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2241 09/30/2015 PCards 8/27/15-9/28/15 USA BLUE BOOK 87,984.08 8.89 95,958.94 USA BLUE BOOK PC 2241 09/30/2015 PCards 8/27/15-9/28/15 WW GRAINGER 87.21 96,046.15 WW GRAINGER PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 8,062.07 96,046.15 ** 75,162.00 Budgeted (20,884.15) Remaining 128 % Used Account: 135-55090-020-000 Vehicle Maintenance 2241 09/30/2015 PCards 8/27/15-9/28/15 AUTOZONE #4206 3,523.25 16.48 3,539.73 AUTOZONE #4206 PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 16.48 3,539.73 ** 4,000.00 Budgeted 460.27 Remaining 88 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 803.29 .00 803.29 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 803.29 ** 1,000.00 Budgeted 196.71 Remaining 80 % Used Account: 135-55125-020-000 Dumpster Services 2177 09/24/2015 August A/P Sludge Hauling 43,099.62 1,351.16 44,450.78 L.H. CHANEY MATERIALS, INC. 35381 AP 2177 09/24/2015 August A/P Sludge Hauling 1,534.94 45,985.72 L.H. CHANEY MATERIALS, INC. 35381 AP 2237 09/30/2015 September A/P Sludge hauling 773.18 46,758.90 L.H. CHANEY MATERIALS, INC. 1016 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,659.28 46,758.90 ** 55,000.00 Budgeted 8,241.10 Remaining 85 % Used Account: 135-55135-020-000 Lab Analysis 2060 09/02/2015 September A/P Lab analysis 24,245.50 246.00 24,491.50 OXIDOR LABORATORIES LLC 35337 AP 2060 09/02/2015 September A/P Lab analysis 176.00 24,667.50 OXIDOR LABORATORIES LLC 35337 AP 2122 09/14/2015 September A/P Lab analysis 246.00 24,913.50 OXIDOR LABORATORIES LLC 35359 AP 2122 09/14/2015 September A/P Lab analysis 176.00 25,089.50 OXIDOR LABORATORIES LLC 35359 AP 2177 09/24/2015 August A/P Lab analysis 246.00 25,335.50 OXIDOR LABORATORIES LLC 35387 AP 2177 09/24/2015 August A/P Lab analysis 176.00 25,511.50 OXIDOR LABORATORIES LLC 35387 AP 2177 09/24/2015 August A/P Lab analysis 246.00 25,757.50 OXIDOR LABORATORIES LLC 35387 AP 2177 09/24/2015 August A/P Lab analysis 176.00 25,933.50 OXIDOR LABORATORIES LLC 35387 AP 2219 09/30/2015 September A/P Lab analysis 246.00 26,179.50 OXIDOR LABORATORIES LLC 1021 AP 2219 09/30/2015 September A/P Lab analysis 176.00 26,355.50 OXIDOR LABORATORIES LLC 1021 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,110.00 26,355.50 ** 27,000.00 Budgeted 644.50 Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60010-020-000 Communications/Mobiles 2122 09/14/2015 September A/P Cell phones 8/2-9/1/15 4,913.66 359.94 5,273.60 VERIZON WIRELESS 35366 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 359.94 5,273.60 ** 5,500.00 Budgeted 226.40 Remaining 96 % Used Account: 135-60020-020-000 Electricity 2122 09/14/2015 September A/P Electricity 07/28-08/27/15 134,202.10 325.29 134,527.39 TRI COUNTY ELECTRIC 35365 AP 2122 09/14/2015 September A/P Electricity 8/10-9/9/15 37.53 134,564.92 HUDSON ENERGY SERVICES, LLC 35351 AP 2122 09/14/2015 September A/P Electricity 7/28-8/27/15 172.78 134,737.70 TRI COUNTY ELECTRIC 35365 AP 2122 09/14/2015 September A/P Electricity 7/28-8/27/15 27.72 134,765.42 TRI COUNTY ELECTRIC 35365 AP 2123 09/14/2015 September A/P Electricity 8/11-9/10/15 487.06 135,252.48 HUDSON ENERGY SERVICES, LLC 35351 AP 2177 09/24/2015 August A/P Electricity 8/11-9/10/15 101.36 135,353.84 HUDSON ENERGY SERVICES, LLC 35378 AP 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (227.16) 135,126.68 AR _______________ Account: 135-60020-020-000 Electricity Totals: 924.58 135,126.68 ** 145,500.00 Budgeted 10,373.32 Remaining 93 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 134.85 .00 134.85 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 134.85 ** 400.00 Budgeted 265.15 Remaining 34 % Used Account: 135-60070-020-000 Dues & Memberships 307.00 .00 307.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 307.00 ** 325.00 Budgeted 18.00 Remaining 94 % Used Account: 135-60080-020-000 Schools & Training 1,526.00 .00 1,526.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 1,526.00 ** 3,065.00 Budgeted 1,539.00 Remaining 50 % Used Account: 135-60090-020-000 Safety Program .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 2177 09/24/2015 August A/P Tolls 1,825.89 8.02 1,833.91 NTTA 35384 AP 2241 09/30/2015 PCards 8/27/15-9/28/15 UBER TECHNOLOGIES INC 6.00 1,839.91 UBER TECHNOLOGIES INC PC 2241 09/30/2015 PCards 8/27/15-9/28/15 ARBYS 7683 17.84 1,857.75 ARBYS 7683 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 ARBYS 7683 5.34 1,863.09 ARBYS 7683 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 COURTYARD BY MARRIOTT 12.53 1,875.62 COURTYARD BY MARRIOTT PC 2241 09/30/2015 PCards 8/27/15-9/28/15 COURTYARD BY MARRIOTT 143.04 2,018.66 COURTYARD BY MARRIOTT PC 2241 09/30/2015 PCards 8/27/15-9/28/15 COURTYARD BY MARRIOTT 202.10 2,220.76 COURTYARD BY MARRIOTT PC 2241 09/30/2015 PCards 8/27/15-9/28/15 COURTYARD BY MARRIOTT 18.43 2,239.19 COURTYARD BY MARRIOTT PC 2241 09/30/2015 PCards 8/27/15-9/28/15 COURTYARD BY MARRIOTT 2.39 2,241.58 COURTYARD BY MARRIOTT PC 2241 09/30/2015 PCards 8/27/15-9/28/15 COURTYARD BY MARRIOTT 4.77 2,246.35 COURTYARD BY MARRIOTT PC 2241 09/30/2015 PCards 8/27/15-9/28/15 WAFFLE HOUSE 0700 11.06 2,257.41 WAFFLE HOUSE 0700 PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 431.52 2,257.41 ** 2,000.00 Budgeted (257.41) Remaining 113 % Used Account: 135-60105-020-000 Rent/Lease Equipment 1.00 .00 1.00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 1.00 ** 2,000.00 Budgeted 1,999.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 9,019.00 .00 9,019.00 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 9,019.00 ** 17,150.00 Budgeted 8,131.00 Remaining 53 % Used Account: 135-60245-020-000 Miscellaneous Expenses 19.47 .00 19.47 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 19.47 ** 300.00 Budgeted 280.53 Remaining 6 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 784.59 .00 784.59 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 784.59 ** 1,000.00 Budgeted 215.41 Remaining 78 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 30,645.00 .00 30,645.00 _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 30,645.00 ** 65,255.00 Budgeted 34,610.00 Remaining 47 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 136,989.00 .00 136,989.00 _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 136,989.00 ** 136,989.00 Budgeted .00 Remaining 100 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 2107 09/02/2015 Texpool xfer to Rev Bond Reser 61,668.00 10,278.00 71,946.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 71,946.00 ** 71,946.00 Budgeted .00 Remaining 100 % Used Account: 135-65005-020-000 Fuel & Lube 2241 09/30/2015 PCards 8/27/15-9/28/15 MUSTANG ELITE CAR WASH 16,172.76 36.00 16,208.76 MUSTANG ELITE CAR WASH PC 2241 09/30/2015 PCards 8/27/15-9/28/15 MUSTANG ELITE CAR WASH 140.98 16,349.74 MUSTANG ELITE CAR WASH PC 2242 09/30/2015 Sept A/P Invoices pd Oct 8/25-9/24/15 Fuel 814.05 17,163.79 US Bank Voyager Fleet Systems AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 991.03 17,163.79 ** 20,328.00 Budgeted 3,164.21 Remaining 84 % Used Account: 135-65010-020-000 Uniforms 2,598.44 .00 2,598.44 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 2,598.44 ** 2,778.00 Budgeted 179.56 Remaining 94 % Used Account: 135-65030-020-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2177 09/24/2015 August A/P Chemicals 18,098.02 168.13 18,266.15 HACH COMPANY 35376 AP 2241 09/30/2015 PCards 8/27/15-9/28/15 AQUAFIX INC. 691.58 18,957.73 AQUAFIX INC. PC 2241 09/30/2015 PCards 8/27/15-9/28/15 POLYDYNE INC 1,080.00 20,037.73 POLYDYNE INC PC 2241 09/30/2015 PCards 8/27/15-9/28/15 AQUAFIX INC. 1,371.60 21,409.33 AQUAFIX INC. PC _______________ Account: 135-65030-020-000 Chemicals Totals: 3,311.31 21,409.33 ** 24,000.00 Budgeted 2,590.67 Remaining 89 % Used Account: 135-65035-020-000 Small Tools 2241 09/30/2015 PCards 8/27/15-9/28/15 THE HOME DEPOT 6581 1,427.20 43.62 1,470.82 THE HOME DEPOT 6581 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 MCDONNELL BUILDING MAT 33.37 1,504.19 MCDONNELL BUILDING MAT PC _______________ Account: 135-65035-020-000 Small Tools Totals: 76.99 1,504.19 ** 1,500.00 Budgeted (4.19) Remaining 100 % Used Account: 135-65040-020-000 Safety Equipment 625.68 .00 625.68 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 625.68 ** 750.00 Budgeted 124.32 Remaining 83 % Used Account: 135-65045-020-000 Lab Supplies 12,341.13 .00 12,341.13 _______________ Account: 135-65045-020-000 Lab Supplies Totals: .00 12,341.13 ** 13,000.00 Budgeted 658.87 Remaining 95 % Used Account: 135-69005-020-000 Capital Outlays 2108 09/10/2015 Correct Pebble Beach Retainage 198,660.42 (1,900.00) 196,760.42 GL 2121 09/14/2015 Webber Appl #1 Retainage 44,523.05 241,283.47 GL 2131 09/14/2015 Reverse JE2121/Incorrect entry (44,523.05) 196,760.42 GL _______________ Account: 135-69005-020-000 Capital Outlays Totals: (1,900.00) 196,760.42 ** 142,000.00 Budgeted (54,760.42) Remaining 139 % Used Account: 135-69008-020-000 Short Term Debt-Principal 56,991.00 .00 56,991.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 56,991.00 ** 56,991.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest 1,951.94 .00 1,951.94 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 1,951.94 ** 2,011.00 Budgeted 59.06 Remaining 97 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,354,761.40 ** 1,363,580.00 Budgeted 8,818.60 Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 2089 09/11/2015 MUD Payroll 9/11/15 Salaries & Wages 12,500.00 1,000.00 13,500.00 PR 2168 09/25/2015 MUD Payroll 9/25/15 Salaries & Wages 500.00 14,000.00 PR 2262 09/30/2015 Accrue Sept Wages 900.00 14,900.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 2,400.00 14,900.00 ** 15,000.00 Budgeted 100.00 Remaining 99 % Used Account: 135-50030-026-000 Social Security Taxes 2089 09/11/2015 MUD Payroll 9/11/15 Social Security Taxes 775.00 62.00 837.00 PR 2168 09/25/2015 MUD Payroll 9/25/15 Social Security Taxes 31.00 868.00 PR 2262 09/30/2015 Accrue Sept Wages 55.80 923.80 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 148.80 923.80 ** 930.00 Budgeted 6.20 Remaining 99 % Used Account: 135-50035-026-000 Medicare Taxes 2089 09/11/2015 MUD Payroll 9/11/15 Medicare Taxes 181.25 14.50 195.75 PR 2168 09/25/2015 MUD Payroll 9/25/15 Medicare Taxes 7.25 203.00 PR 2262 09/30/2015 Accrue Sept Wages 13.05 216.05 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 34.80 216.05 ** 218.00 Budgeted 1.95 Remaining 99 % Used Account: 135-50040-026-000 Unemployment Taxes 2089 09/11/2015 MUD Payroll 9/11/15 Unemployment Taxes 64.68 1.00 65.68 PR 2168 09/25/2015 MUD Payroll 9/25/15 Unemployment Taxes .50 66.18 PR 2262 09/30/2015 Accrue Sept Wages .90 67.08 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 2.40 67.08 ** 230.00 Budgeted 162.92 Remaining 29 % Used Account: 135-50045-026-000 Workman's Compensation 202 09/01/2015 Sep TML Ins & Workers Comp 32.34 2.94 35.28 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 35.28 ** 36.00 Budgeted .72 Remaining 98 % Used Account: 135-60066-026-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 35.00 .00 35.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 275.64 .00 275.64 _______________ Account: 135-60075-026-000 Meetings Totals: .00 275.64 ** 950.00 Budgeted 674.36 Remaining 29 % Used Account: 135-60080-026-000 Schools & Training 2,950.00 .00 2,950.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 2,950.00 ** 4,000.00 Budgeted 1,050.00 Remaining 74 % Used Account: 135-60100-026-000 Travel & per diem 3,478.88 .00 3,478.88 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 3,478.88 ** 4,250.00 Budgeted 771.12 Remaining 82 % Used Account: 135-60245-026-000 Miscellaneous Expenses 2241 09/30/2015 PCards 8/27/15-9/28/15 RANDALLS STORE00017897 1,644.74 8.20 1,652.94 RANDALLS STORE00017897 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 RANDALLS STORE00017897 5.99 1,658.93 RANDALLS STORE00017897 PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 14.19 1,658.93 ** 2,000.00 Budgeted 341.07 Remaining 83 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 24,540.66 ** 28,264.00 Budgeted 3,723.34 Remaining 87 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 2089 09/11/2015 MUD Payroll 9/11/15 Salaries & Wages 413,978.88 17,994.31 431,973.19 PR 2168 09/25/2015 MUD Payroll 9/25/15 Salaries & Wages 17,960.76 449,933.95 PR 2262 09/30/2015 Accrue Sept Wages 14,410.72 464,344.67 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 50,365.79 464,344.67 ** 470,732.00 Budgeted 6,387.33 Remaining 99 % Used Account: 135-50010-030-000 Overtime 2089 09/11/2015 MUD Payroll 9/11/15 Overtime 516.03 3.05 519.08 PR 2168 09/25/2015 MUD Payroll 9/25/15 Overtime 59.03 578.11 PR 2262 09/30/2015 Accrue Sept Wages 29.72 607.83 PR _______________ Account: 135-50010-030-000 Overtime Totals: 91.80 607.83 ** 1,000.00 Budgeted 392.17 Remaining 61 % Used Account: 135-50016-030-000 Longevity 3,282.50 .00 3,282.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,282.50 ** 3,283.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 2089 09/11/2015 MUD Payroll 9/11/15 Retirement 37,291.65 1,603.55 38,895.20 PR 2168 09/25/2015 MUD Payroll 9/25/15 Retirement 1,605.57 40,500.77 PR 2262 09/30/2015 Accrue Sept Wages 1,286.61 41,787.38 PR _______________ Account: 135-50020-030-000 Retirement Totals: 4,495.73 41,787.38 ** 42,184.00 Budgeted 396.62 Remaining 99 % Used Account: 135-50026-030-000 Medical Insurance 2089 09/11/2015 MUD Payroll 9/11/15 Medical Insurance 53,876.85 2,583.19 56,460.04 PR 2168 09/25/2015 MUD Payroll 9/25/15 Medical Insurance 2,583.14 59,043.18 PR 2262 09/30/2015 Accrue Sept Wages 2,055.32 61,098.50 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 7,221.65 61,098.50 ** 62,000.00 Budgeted 901.50 Remaining 99 % Used Account: 135-50027-030-000 Dental Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2089 09/11/2015 MUD Payroll 9/11/15 Dental Insurance 3,245.27 182.11 3,427.38 PR 2168 09/25/2015 MUD Payroll 9/25/15 Dental Insurance 182.13 3,609.51 PR 2262 09/30/2015 Accrue Sept Wages 144.89 3,754.40 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 509.13 3,754.40 ** 4,494.00 Budgeted 739.60 Remaining 84 % Used Account: 135-50028-030-000 Vision Insurance 2089 09/11/2015 MUD Payroll 9/11/15 Vision Insurance 894.49 42.16 936.65 PR 2168 09/25/2015 MUD Payroll 9/25/15 Vision Insurance 42.22 978.87 PR 2262 09/30/2015 Accrue Sept Wages 33.51 1,012.38 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 117.89 1,012.38 ** 1,116.00 Budgeted 103.62 Remaining 91 % Used Account: 135-50029-030-000 Life Insurance & Other 2008 09/01/2015 September A/P Dental, vision, misc insurance 4,016.03 335.64 4,351.67 METLIFE GROUP BENEFITS 35292 AP 2219 09/30/2015 September A/P Café 125 Admin 33.78 4,385.45 BenefitMall 1004 AP 2242 09/30/2015 Sept A/P Invoices pd Oct TML,Shi,Verizon,Gexa,Symonds,N 323.47 4,708.92 TOWN OF TROPHY CLUB AP 2265 09/30/2015 Other Ins/Rounding (.66) 4,708.26 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 692.23 4,708.26 ** 4,333.00 Budgeted (375.26) Remaining 109 % Used Account: 135-50030-030-000 Social Security Taxes 2089 09/11/2015 MUD Payroll 9/11/15 Social Security Taxes 24,450.80 1,045.17 25,495.97 PR 2168 09/25/2015 MUD Payroll 9/25/15 Social Security Taxes 1,035.78 26,531.75 PR 2262 09/30/2015 Accrue Sept Wages 831.27 27,363.02 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,912.22 27,363.02 ** 29,654.00 Budgeted 2,290.98 Remaining 92 % Used Account: 135-50035-030-000 Medicare Taxes 2089 09/11/2015 MUD Payroll 9/11/15 Medicare Taxes 5,718.31 244.43 5,962.74 PR 2168 09/25/2015 MUD Payroll 9/25/15 Medicare Taxes 242.24 6,204.98 PR 2262 09/30/2015 Accrue Sept Wages 194.42 6,399.40 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 681.09 6,399.40 ** 7,317.00 Budgeted 917.60 Remaining 87 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-030-000 Unemployment Taxes 143.56 .00 143.56 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 143.56 ** 1,449.00 Budgeted 1,305.44 Remaining 10 % Used Account: 135-50045-030-000 Workman's Compensation 202 09/01/2015 Sep TML Ins & Workers Comp 960.30 87.30 1,047.60 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 87.30 1,047.60 ** 1,636.00 Budgeted 588.40 Remaining 64 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 38.00 .00 38.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 38.00 ** 500.00 Budgeted 462.00 Remaining 8 % Used Account: 135-50070-030-000 Employee Relations 2241 09/30/2015 PCards 8/27/15-9/28/15 ESCAPE DONUT 2,690.29 31.57 2,721.86 ESCAPE DONUT PC 2241 09/30/2015 PCards 8/27/15-9/28/15 PARKING GARAGE 4.00 2,725.86 PARKING GARAGE PC 2241 09/30/2015 PCards 8/27/15-9/28/15 WAL-MART #0266 4.97 2,730.83 WAL-MART #0266 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 TLF GREENWOOD FLORIST 64.99 2,795.82 TLF GREENWOOD FLORIST PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 105.53 2,795.82 ** 4,300.00 Budgeted 1,504.18 Remaining 65 % Used Account: 135-55030-030-000 Software & Support 2122 09/14/2015 September A/P Internet 10/1-10/31/15 110,022.58 1,163.56 111,186.14 WHOLESALE CARRIER SERVICES INC 35368 AP 2177 09/24/2015 August A/P Software & support August 759.00 111,945.14 STW INC 35389 AP 2241 09/30/2015 PCards 8/27/15-9/28/15 ATT*BILL PAYMENT 90.20 112,035.34 ATT*BILL PAYMENT PC 2241 09/30/2015 PCards 8/27/15-9/28/15 ATT*BILL PAYMENT 106.51 112,141.85 ATT*BILL PAYMENT PC 2241 09/30/2015 PCards 8/27/15-9/28/15 DNH*GODADDY.COM 181.02 112,322.87 DNH*GODADDY.COM PC _______________ Account: 135-55030-030-000 Software & Support Totals: 2,300.29 112,322.87 ** 121,635.00 Budgeted 9,312.13 Remaining 92 % Used Account: 135-55070-030-000 Independent Labor . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2122 09/14/2015 September A/P Water Study 34,211.32 1,995.00 36,206.32 THE WALLACE GROUP, INC. 35364 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 1,995.00 36,206.32 ** 32,550.00 Budgeted (3,656.32) Remaining 111 % Used Account: 135-55080-030-000 Maintenance & Repairs 534.94 .00 534.94 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 534.94 ** 4,500.00 Budgeted 3,965.06 Remaining 12 % Used Account: 135-55100-030-000 Building Maint & Supplies 2219 09/30/2015 September A/P Rug cleaning 6,236.72 130.89 6,367.61 G & K SERVICES 1009 AP 2219 09/30/2015 September A/P Rug cleaning 130.89 6,498.50 G & K SERVICES 1009 AP 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (130.89) 6,367.61 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 130.89 6,367.61 ** 7,000.00 Budgeted 632.39 Remaining 91 % Used Account: 135-55120-030-000 Cleaning Services 2122 09/14/2015 September A/P Janitorial Services August 201 6,275.30 627.53 6,902.83 MEMBER'S BUILDING MAINTENANCE 35356 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 627.53 6,902.83 ** 8,100.00 Budgeted 1,197.17 Remaining 85 % Used Account: 135-55160-030-000 Professional Outside Services 2122 09/14/2015 September A/P Boundary survey of golf course 20,117.45 1,985.00 22,102.45 THE WALLACE GROUP, INC. 35364 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 1,985.00 22,102.45 ** 61,950.00 Budgeted 39,847.55 Remaining 36 % Used Account: 135-55161-030-000 Town Personnel Contract 26,170.00 .00 26,170.00 _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: .00 26,170.00 ** 26,170.00 Budgeted .00 Remaining 100 % Used Account: 135-55165-030-000 Collection Fees . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 2122 09/14/2015 September A/P Monthly Utility Billing 6,188.47 1,093.98 7,282.45 DATAPROSE LLC 35349 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,093.98 7,282.45 ** 8,200.00 Budgeted 917.55 Remaining 89 % Used Account: 135-60005-030-000 Telephone 2177 09/24/2015 August A/P Answering Service 9/21-10/18/1 10,626.49 194.30 10,820.79 KEYSTONE PARK SECRETARIAL 35380 AP 2241 09/30/2015 PCards 8/27/15-9/28/15 RINGCENTRAL, INC 9.99 10,830.78 RINGCENTRAL, INC PC 2241 09/30/2015 PCards 8/27/15-9/28/15 ATT*BUS PHONE PMT 509.78 11,340.56 ATT*BUS PHONE PMT PC 2242 09/30/2015 Sept A/P Invoices pd Oct TML,Shi,Verizon,Gexa,Symonds,N 82.50 11,423.06 TOWN OF TROPHY CLUB AP 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (445.85) 10,977.21 AR _______________ Account: 135-60005-030-000 Telephone Totals: 350.72 10,977.21 ** 13,361.00 Budgeted 2,383.79 Remaining 82 % Used Account: 135-60010-030-000 Communications/Mobiles 2122 09/14/2015 September A/P Cell phones 8/2-9/1/15 3,715.24 37.99 3,753.23 VERIZON WIRELESS 35366 AP 2168 09/25/2015 MUD Payroll 9/25/15 Communications/Mobiles 300.00 4,053.23 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 337.99 4,053.23 ** 4,056.00 Budgeted 2.77 Remaining 100 % Used Account: 135-60020-030-000 Electricity/Gas 2242 09/30/2015 Sept A/P Invoices pd Oct TML,Shi,Verizon,Gexa,Symonds,N 8,509.62 968.39 9,478.01 TOWN OF TROPHY CLUB AP 2242 09/30/2015 Sept A/P Invoices pd Oct TML,Shi,Verizon,Gexa,Symonds,N 905.54 10,383.55 TOWN OF TROPHY CLUB AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,873.93 10,383.55 ** 12,000.00 Budgeted 1,616.45 Remaining 87 % Used Account: 135-60025-030-000 Water 2242 09/30/2015 Sept A/P Invoices pd Oct September Water 798.11 248.01 1,046.12 TROPHY CLUB MUD (WATER BILLS) AP 2271 09/30/2015 Bill Town Inv 1349-1358 AR 20150901-20150930 User: (124.00) 922.12 AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60025-030-000 Water Totals: 124.01 922.12 ** 1,500.00 Budgeted 577.88 Remaining 61 % Used Account: 135-60035-030-000 Postage 2122 09/14/2015 September A/P Monthly Utility Billing 27,581.76 1,777.84 29,359.60 DATAPROSE LLC 35349 AP 2177 09/24/2015 August A/P Overnight letters 29.27 29,388.87 FEDERAL EXPRESS CORP 35375 AP 2237 09/30/2015 September A/P Overnight letter 4.99 29,393.86 FEDERAL EXPRESS CORP 1008 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,812.10 29,393.86 ** 30,500.00 Budgeted 1,106.14 Remaining 96 % Used Account: 135-60040-030-000 Service Charges & Fees 2247 09/10/2015 Bank Analysis Fee- August 40,371.04 250.00 40,621.04 GL 2261 09/30/2015 Credit Card Fees/UB 87.74 40,708.78 GL 2261 09/30/2015 Credit Card Fees/UB 5,110.93 45,819.71 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 5,448.67 45,819.71 ** 45,000.00 Budgeted (819.71) Remaining 102 % Used Account: 135-60050-030-000 Bad Debt Expense 1,711.95 .00 1,711.95 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 1,711.95 ** 3,000.00 Budgeted 1,288.05 Remaining 57 % Used Account: 135-60055-030-000 Insurance 202 09/01/2015 Sep TML Ins & Workers Comp 45,047.36 4,063.01 49,110.37 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,063.01 49,110.37 ** 48,751.00 Budgeted (359.37) Remaining 101 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 1,223.77 .00 1,223.77 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 1,223.77 ** 1,600.00 Budgeted 376.23 Remaining 76 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-030-000 Dues & Memberships 4,557.95 .00 4,557.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,557.95 ** 6,000.00 Budgeted 1,442.05 Remaining 76 % Used Account: 135-60075-030-000 Meetings 60.11 .00 60.11 _______________ Account: 135-60075-030-000 Meetings Totals: .00 60.11 ** 400.00 Budgeted 339.89 Remaining 15 % Used Account: 135-60079-030-000 Public Education 3,384.79 .00 3,384.79 _______________ Account: 135-60079-030-000 Public Education Totals: .00 3,384.79 ** 4,078.00 Budgeted 693.21 Remaining 83 % Used Account: 135-60080-030-000 Schools & Training 2,938.00 .00 2,938.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 2,938.00 ** 7,235.00 Budgeted 4,297.00 Remaining 41 % Used Account: 135-60100-030-000 Travel & per diem 2089 09/11/2015 MUD Payroll 9/11/15 Travel & per diem 1,969.43 4.95 1,974.38 PR 2168 09/25/2015 MUD Payroll 9/25/15 Travel & per diem 14.09 1,988.47 PR 2262 09/30/2015 Accrue Sept Wages 29.32 2,017.79 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 48.36 2,017.79 ** 4,000.00 Budgeted 1,982.21 Remaining 50 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60115-030-000 Elections 1,289.22 .00 1,289.22 _______________ Account: 135-60115-030-000 Elections Totals: .00 1,289.22 ** .00 Budgeted (1,289.22) Remaining 0 % Used Account: 135-60125-030-000 Advertising 2219 09/30/2015 September A/P Legal ad - Notice of Public He 5,755.30 613.62 6,368.92 STAR-TELEGRAM OPERATING LTD 1023 AP _______________ Account: 135-60125-030-000 Advertising Totals: 613.62 6,368.92 ** 7,255.00 Budgeted 886.08 Remaining 88 % Used Account: 135-60235-030-000 Security 59.85 .00 59.85 _______________ Account: 135-60235-030-000 Security Totals: .00 59.85 ** 1,350.00 Budgeted 1,290.15 Remaining 4 % Used Account: 135-60245-030-000 Miscellaneous Expenses 10,731.70 .00 10,731.70 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 10,731.70 ** 17,500.00 Budgeted 6,768.30 Remaining 61 % Used Account: 135-60270-030-000 4th of July Celebration 10,000.00 .00 10,000.00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 14,000.00 .00 14,000.00 _______________ Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) Totals: .00 14,000.00 ** 14,000.00 Budgeted .00 Remaining 100 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2122 09/14/2015 September A/P New PC - KS 5,035.96 963.50 5,999.46 M3 Networks 35355 AP 2122 09/14/2015 September A/P Office chairs for RG & LS 339.98 6,339.44 OFFICE DEPOT, INC 35358 AP _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 1,303.48 6,339.44 ** 11,036.00 Budgeted 4,696.56 Remaining 57 % Used Account: 135-65010-030-000 Uniforms 1,043.00 .00 1,043.00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 1,043.00 ** 1,855.00 Budgeted 812.00 Remaining 56 % Used Account: 135-65055-030-000 Hardware 34,312.29 .00 34,312.29 _______________ Account: 135-65055-030-000 Hardware Totals: .00 34,312.29 ** 35,226.00 Budgeted 913.71 Remaining 97 % Used Account: 135-65085-030-000 Office Supplies 2177 09/24/2015 August A/P Office supplies 7,717.06 101.51 7,818.57 OFFICE DEPOT, INC 35385 AP 2219 09/30/2015 September A/P Office supplies 126.93 7,945.50 OFFICE DEPOT, INC 1019 AP 2241 09/30/2015 PCards 8/27/15-9/28/15 OFFICE DEPOT #406 27.75 7,973.25 OFFICE DEPOT #406 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 OFFICE DEPOT #406 8.34 7,981.59 OFFICE DEPOT #406 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 AMAZON MKTPLACE PMTS 35.90 8,017.49 AMAZON MKTPLACE PMTS PC 2241 09/30/2015 PCards 8/27/15-9/28/15 AMAZON MKTPLACE PMTS 13.50 8,030.99 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65085-030-000 Office Supplies Totals: 313.93 8,030.99 ** 9,000.00 Budgeted 969.01 Remaining 89 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 2,760.80 .00 2,760.80 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 2,760.80 ** 4,732.00 Budgeted 1,971.20 Remaining 58 % Used Account: 135-65095-030-000 Maintenance Supplies 2241 09/30/2015 PCards 8/27/15-9/28/15 AMAZON MKTPLACE PMTS 3,935.06 83.82 4,018.88 AMAZON MKTPLACE PMTS PC 2241 09/30/2015 PCards 8/27/15-9/28/15 WAL-MART #0266 14.07 4,032.95 WAL-MART #0266 PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2241 09/30/2015 PCards 8/27/15-9/28/15 SAMS CLUB #4795 3,935.06 253.32 4,286.27 SAMS CLUB #4795 PC 2241 09/30/2015 PCards 8/27/15-9/28/15 AMAZON MKTPLACE PMTS 36.93 4,323.20 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 388.14 4,323.20 ** 5,000.00 Budgeted 676.80 Remaining 86 % Used Account: 135-65097-030-000 Vending Machine Supplies .00 .00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65105-030-000 Printing 1,332.56 .00 1,332.56 _______________ Account: 135-65105-030-000 Printing Totals: .00 1,332.56 ** 3,000.00 Budgeted 1,667.44 Remaining 44 % Used Account: 135-69005-030-000 Capital Outlays 61,821.66 .00 61,821.66 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 61,821.66 ** 62,000.00 Budgeted 178.34 Remaining 100 % Used Account: 135-69170-030-000 Copier Lease Installments 2242 09/30/2015 Sept A/P Invoices pd Oct TML,Shi,Verizon,Gexa,Symonds,N 3,407.42 77.30 3,484.72 TOWN OF TROPHY CLUB AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 77.30 3,484.72 ** 4,236.00 Budgeted 751.28 Remaining 82 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement 16,329.00 .00 16,329.00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 16,329.00 ** 16,329.00 Budgeted .00 Remaining 100 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 1,185,054.55 ** 1,288,703.00 Budgeted 103,648.45 Remaining 92 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 2177 09/24/2015 August A/P August Legal 452,944.92 3,503.78 456,448.70 WHITAKER CHALK SWINDLE 35392 AP 2177 09/24/2015 August A/P August Legal 5,447.50 461,896.20 WHITAKER CHALK SWINDLE 35392 AP 2177 09/24/2015 August A/P August Legal 13,775.00 475,671.20 Norton Rose Fulbright US LLP 35383 AP 2242 09/30/2015 Sept A/P Invoices pd Oct August Legal 8,520.73 484,191.93 THE LISTON LAW FIRM, P.C. AP _______________ Account: 135-55045-039-000 Legal Totals: 31,247.01 484,191.93 ** 467,403.00 Budgeted (16,788.93) Remaining 104 % Used Account: 135-55055-039-000 Auditing 2122 09/14/2015 September A/P Audit retainer FYE 9/30/15 16,836.00 5,000.00 21,836.00 LAFOLLETT & ABBOTT PLLC 35354 AP _______________ Account: 135-55055-039-000 Auditing Totals: 5,000.00 21,836.00 ** 22,491.00 Budgeted 655.00 Remaining 97 % Used Account: 135-55060-039-000 Appraisal 2067 09/03/2015 September A/P Fourth Qtr Allocation 7,964.16 1,882.21 9,846.37 DENTON CENTRAL APPRAISAL DISTR 35308 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,882.21 9,846.37 ** 10,000.00 Budgeted 153.63 Remaining 98 % Used Account: 135-55065-039-000 Tax Admin Fees 2,456.40 .00 2,456.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,456.40 ** 3,800.00 Budgeted 1,343.60 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 518,330.70 ** 503,694.00 Budgeted (14,636.70) Remaining 103 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (1,590,847.30) .00 Budgeted 1,590,847.30 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (91,329.00) .00 (91,329.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (91,329.00) ** .00 Budgeted 91,329.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (17,950.00) .00 (17,950.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (17,950.00) ** .00 Budgeted 17,950.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (109,279.00) ** .00 Budgeted 109,279.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 30 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-030-000 GASB Replacement 74,706.00 .00 74,706.00 _______________ Account: 137-69195-030-000 GASB Replacement Totals: .00 74,706.00 ** .00 Budgeted (74,706.00) Remaining 0 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 74,706.00 ** .00 Budgeted (74,706.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: 45 Fire Department Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-69195-045-000 GASB Replacement 125,670.00 .00 125,670.00 _______________ Account: 137-69195-045-000 GASB Replacement Totals: .00 125,670.00 ** .00 Budgeted (125,670.00) Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 125,670.00 ** .00 Budgeted (125,670.00) Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ 91,097.00 .00 Budgeted (91,097.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income 2246 09/30/2015 Bank Interest/September (11.95) (1.48) (13.43) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (1.48) (13.43) ** .00 Budgeted 13.43 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (13.43) ** .00 Budgeted 13.43 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline 2,250.00 .00 2,250.00 _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: .00 2,250.00 ** 3,348.00 Budgeted 1,098.00 Remaining 67 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,250.00 ** 3,348.00 Budgeted 1,098.00 Remaining 67 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 2,236.57 3,348.00 Budgeted 1,111.43 Remaining 67 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET SEPTEMBER 2015 517 ASSETS TAX BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 4,378,563 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,378,563 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 4,378,563 TOTAL FUND BALANCE 4,378,563 TOTAL LIABILITIES AND FUND BALANCE 4,378,563 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 19:26 10/07/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 305.96- 1,979.06- 1,979.06 517-49105-000-000 Bond Proceeds 5,765,000.00- 5,765,000.00 Subtotal: 305.96- 5,766,979.06- 5,766,979.06 Program number: 305.96- 5,766,979.06- 5,766,979.06 Department number: Revenues 305.96- 5,766,979.06- 5,766,979.06 Revenues Subtotal ----------- 305.96- 5,766,979.06- 5,766,979.06 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 19:26 10/07/15 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-60135-020-000 TCEQ Permits & Fees 14,376.56 14,376.56- 517-60335-020-000 Intergov Transfer Out (GF) 1,074,337.15 1,074,337.15- Subtotal: 1,088,713.71 1,088,713.71- 517-69005-020-000 Capital Outlays 151,502.50 151,502.50- Subtotal: 151,502.50 151,502.50- 517-70020-020-000 Bond Issuance 148,200.00 148,200.00- Subtotal: 148,200.00 148,200.00- Program number: 1,388,416.21 1,388,416.21- Department number: Wastewater 1,388,416.21 1,388,416.21- Expenditures Subtotal ----------- 1,388,416.21 1,388,416.21- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 305.96- 4,378,562.85- 4,378,562.85 . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 2246 09/30/2015 Bank Interest/September (1,673.10) (305.96) (1,979.06) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (305.96) (1,979.06) ** .00 Budgeted 1,979.06 Remaining 0 % Used Account: 517-49105-000-000 Bond Proceeds (5,765,000.00) .00 (5,765,000.00) _______________ Account: 517-49105-000-000 Bond Proceeds Totals: .00 (5,765,000.00) ** .00 Budgeted 5,765,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5,766,979.06) ** .00 Budgeted 5,766,979.06 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-60135-020-000 TCEQ Permits & Fees 14,376.56 .00 14,376.56 _______________ Account: 517-60135-020-000 TCEQ Permits & Fees Totals: .00 14,376.56 ** .00 Budgeted (14,376.56) Remaining 0 % Used Account: 517-60335-020-000 Intergov Transfer Out (GF) 1,074,337.15 .00 1,074,337.15 _______________ Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: .00 1,074,337.15 ** .00 Budgeted (1,074,337.15) Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 151,502.50 .00 151,502.50 _______________ Account: 517-69005-020-000 Capital Outlays Totals: .00 151,502.50 ** .00 Budgeted (151,502.50) Remaining 0 % Used Account: 517-70020-020-000 Bond Issuance 148,200.00 .00 148,200.00 _______________ Account: 517-70020-020-000 Bond Issuance Totals: .00 148,200.00 ** .00 Budgeted (148,200.00) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,388,416.21 ** .00 Budgeted (1,388,416.21) Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (4,378,562.85) .00 Budgeted 4,378,562.85 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET SEPTEMBER 2015 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 8,535,193 ACCOUNTS RECEIVABLE 570 TOTAL ASSETS 8,535,763 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 61,523 TOTAL LIABILITIES 61,523 FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 8,474,240 TOTAL FUND BALANCE 8,474,240 TOTAL LIABILITIES AND FUND BALANCE 8,535,763 . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 19:26 10/07/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 608.51- 3,368.53- 3,368.53 518-49105-000-000 Bond Proceeds 9,230,000.00- 9,230,000.00 Subtotal: 608.51- 9,233,368.53- 9,233,368.53 Program number: 608.51- 9,233,368.53- 9,233,368.53 Department number: Revenues 608.51- 9,233,368.53- 9,233,368.53 Revenues Subtotal ----------- 608.51- 9,233,368.53- 9,233,368.53 . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 19:26 10/07/15 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-60125-020-000 Advertising 660.99 660.99- 518-60135-020-000 TCEQ Fees & Permits 23,017.46 23,017.46- Subtotal: 23,678.45 23,678.45- 518-69005-020-000 Capital Outlays 455,070.08 545,181.27 545,181.27- Subtotal: 455,070.08 545,181.27 545,181.27- 518-70020-020-000 Bond Issuance Costs 190,269.00 190,269.00- Subtotal: 190,269.00 190,269.00- Program number: 455,070.08 759,128.72 759,128.72- Department number: Wastewater 455,070.08 759,128.72 759,128.72- Expenditures Subtotal ----------- 455,070.08 759,128.72 759,128.72- Fund number: 518 2015 Revenue Bond Const Fund 454,461.57 8,474,239.81- 8,474,239.81 . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-49010-000-000 Interest Income 2246 09/30/2015 Bank Interest/September (2,760.02) (608.51) (3,368.53) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (608.51) (3,368.53) ** .00 Budgeted 3,368.53 Remaining 0 % Used Account: 518-49105-000-000 Bond Proceeds (9,230,000.00) .00 (9,230,000.00) _______________ Account: 518-49105-000-000 Bond Proceeds Totals: .00 (9,230,000.00) ** .00 Budgeted 9,230,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (9,233,368.53) ** .00 Budgeted 9,233,368.53 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-60125-020-000 Advertising 660.99 .00 660.99 _______________ Account: 518-60125-020-000 Advertising Totals: .00 660.99 ** .00 Budgeted (660.99) Remaining 0 % Used Account: 518-60135-020-000 TCEQ Fees & Permits 23,017.46 .00 23,017.46 _______________ Account: 518-60135-020-000 TCEQ Fees & Permits Totals: .00 23,017.46 ** .00 Budgeted (23,017.46) Remaining 0 % Used Account: 518-69005-020-000 Capital Outlays 2122 09/14/2015 September A/P WWTP Improvements Appl #1 90,111.19 400,707.45 490,818.64 WEBBER-CADAGUA PARTNERS 35367 AP 2122 09/14/2015 September A/P WWTP Improvements 9,839.58 500,658.22 THE WALLACE GROUP, INC. 35364 AP 2132 09/14/2015 Correct JE2121/Webber App #1 44,523.05 545,181.27 GL _______________ Account: 518-69005-020-000 Capital Outlays Totals: 455,070.08 545,181.27 ** .00 Budgeted (545,181.27) Remaining 0 % Used Account: 518-70020-020-000 Bond Issuance Costs 190,269.00 .00 190,269.00 _______________ Account: 518-70020-020-000 Bond Issuance Costs Totals: .00 190,269.00 ** .00 Budgeted (190,269.00) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 759,128.72 ** .00 Budgeted (759,128.72) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ (8,474,239.81) .00 Budgeted 8,474,239.81 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET SEPTEMBER 2015 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 71,962 ACCOUNTS RECEIVABLE - TOTAL ASSETS 71,962 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 71,962 TOTAL FUND BALANCE 71,962 TOTAL LIABILITIES AND FUND BALANCE 71,962 . glbase_tbam rgonzale Trophy Club MUD #1 Page 23 19:26 10/07/15 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 5.05- 16.03- 16.03 528-49141-000-000 Interfund Transfer In-Gen Fund 71,946.00- 10,278.00- 71,946.00- 100.000 Subtotal: 71,946.00- 10,283.05- 71,962.03- 100.022 16.03 Program number: 71,946.00- 10,283.05- 71,962.03- 100.022 16.03 Department number: 71,946.00- 10,283.05- 71,962.03- 100.022 16.03 Revenues Subtotal ----------- 71,946.00- 10,283.05- 71,962.03- 100.022 16.03 Fund number: 528 2015 Revenue Bond Reserve Fund 71,946.00- 10,283.05- 71,962.03- 100.022 16.03 . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 2246 09/30/2015 Bank Interest/September (10.98) (5.05) (16.03) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (5.05) (16.03) ** .00 Budgeted 16.03 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund 2107 09/02/2015 Texpool xfer to Rev Bond Reser (61,668.00) (10,278.00) (71,946.00) GL _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: (10,278.00) (71,946.00) ** (71,946.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (71,962.03) ** (71,946.00) Budgeted 16.03 Remaining 100 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (71,962.03) (71,946.00) Budgeted 16.03 Remaining 100 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET SEPTEMBER 2015 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 19,326 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 9,853 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 34,025 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 9,853 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 9,853 FUND BALANCE ASSIGNED FUND BALANCE 14,752 NET REVENUES / EXPENDITURES 9,420 TOTAL FUND BALANCE 24,172 TOTAL LIABILITIES AND FUND BALANCE 34,025 . glbase_tbam rgonzale Trophy Club MUD #1 Page 24 19:26 10/07/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 466,019.00- 466,019.00- 1,180.97- 466,285.56- 100.057 266.56 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 89.84- 1,907.66- 76.306 592.34- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 275.81- 2,021.32- 126.333 421.32 Subtotal: 470,119.00- 470,119.00- 1,546.62- 470,214.54- 100.020 95.54 533-48005-000-000 Reserve Funds/PID Utility Fees 100,000.00- 14,000.00- 14,000.00- 100.000 533-48015-000-000 WW Sales Rev Trnsf for Debt 357,538.00- Subtotal: 457,538.00- 14,000.00- 14,000.00- 100.000 533-49010-000-000 Interest Income 375.00- 375.00- 1.36- 3,506.69- 935.117 3,131.69 533-49015-000-000 Lease/Rental Income 211,829.00- 211,829.00- 211,829.00- 100.000 533-49110-000-000 Premium on Bonds Sold 4,957.90- 4,957.90 533-49141-000-000 Interfund Trans In-PID Surchg 65,255.00- 30,645.00- 46.962 34,610.00- Subtotal: 212,204.00- 277,459.00- 1.36- 250,938.59- 90.442 26,520.41- Program number: 1,139,861.00- 761,578.00- 1,547.98- 735,153.13- 96.530 26,424.87- Department number: Revenues 1,139,861.00- 761,578.00- 1,547.98- 735,153.13- 96.530 26,424.87- Revenues Subtotal ----------- 1,139,861.00- 761,578.00- 1,547.98- 735,153.13- 96.530 26,424.87- . glbase_tbam rgonzale Trophy Club MUD #1 Page 25 19:26 10/07/15 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 500.00 1,750.00 68.627 800.00 533-70025-051-000 Bond Interest Expense-Tax 403,103.00 283,984.00 283,983.06 100.000 .94 533-70035-051-000 Bond Principal Payment-Tax 440,000.00 440,000.00 440,000.00 100.000 533-70040-051-000 Bond Interest Expense-Revenue 292,283.00 Subtotal: 1,137,936.00 726,534.00 500.00 725,733.06 99.890 800.94 Program number: 1,137,936.00 726,534.00 500.00 725,733.06 99.890 800.94 Department number: Administration 1,137,936.00 726,534.00 500.00 725,733.06 99.890 800.94 Expenditures Subtotal ----------- 1,137,936.00 726,534.00 500.00 725,733.06 99.890 800.94 Fund number: 533 MUD 1 I&S Consolidated 1,925.00- 35,044.00- 1,047.98- 9,420.07- 26.881 25,623.93- . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 2243 09/02/2015 Property Taxes/Assessments (465,104.59) (20.13) (465,124.72) GL 2244 09/03/2015 Property Taxes/Assessments (1,164.36) (466,289.08) GL 2245 09/04/2015 Property Taxes/Assessments (12.45) (466,301.53) GL 2248 09/08/2015 Property Taxes/Assessments (1.28) (466,302.81) GL 2249 09/10/2015 Property Taxes/Assessments (74.34) (466,377.15) GL 2251 09/14/2015 Property Taxes/Assessments (5.55) (466,382.70) GL 2252 09/15/2015 Property Taxes/Assessments 125.34 (466,257.36) GL 2253 09/21/2015 Property Taxes/Assessments (12.38) (466,269.74) GL 2254 09/22/2015 Property Taxes/Assessments (1.86) (466,271.60) GL 2255 09/23/2015 Property Taxes/Assessments (1.11) (466,272.71) GL 2256 09/25/2015 Property Taxes/Assessments (8.67) (466,281.38) GL 2257 09/29/2015 Property Taxes/Assessments (4.18) (466,285.56) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,180.97) (466,285.56) ** (466,019.00) Budgeted 266.56 Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 2244 09/03/2015 Property Taxes/Assessments (1,817.82) (103.89) (1,921.71) GL 2252 09/15/2015 Property Taxes/Assessments 14.05 (1,907.66) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (89.84) (1,907.66) ** (2,500.00) Budgeted (592.34) Remaining 76 % Used Account: 533-40015-000-000 Property Taxes/P & I 2243 09/02/2015 Property Taxes/Assessments (1,745.51) (1.41) (1,746.92) GL 2244 09/03/2015 Property Taxes/Assessments (254.50) (2,001.42) GL 2245 09/04/2015 Property Taxes/Assessments (.09) (2,001.51) GL 2248 09/08/2015 Property Taxes/Assessments (.26) (2,001.77) GL 2249 09/10/2015 Property Taxes/Assessments (14.12) (2,015.89) GL 2251 09/14/2015 Property Taxes/Assessments (1.10) (2,016.99) GL 2253 09/21/2015 Property Taxes/Assessments (2.47) (2,019.46) GL 2254 09/22/2015 Property Taxes/Assessments (.37) (2,019.83) GL 2255 09/23/2015 Property Taxes/Assessments (.09) (2,019.92) GL 2256 09/25/2015 Property Taxes/Assessments (.70) (2,020.62) GL 2257 09/29/2015 Property Taxes/Assessments (.70) (2,021.32) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (275.81) (2,021.32) ** (1,600.00) Budgeted 421.32 Remaining 126 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (14,000.00) .00 (14,000.00) _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 (14,000.00) ** (14,000.00) Budgeted .00 Remaining 100 % Used Account: 533-49010-000-000 Interest Income 2246 09/30/2015 Bank Interest/September (3,505.33) (1.36) (3,506.69) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (1.36) (3,506.69) ** (375.00) Budgeted 3,131.69 Remaining 935 % Used Account: 533-49015-000-000 Lease/Rental Income (211,829.00) .00 (211,829.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (211,829.00) ** (211,829.00) Budgeted .00 Remaining 100 % Used Account: 533-49110-000-000 Premium on Bonds Sold (4,957.90) .00 (4,957.90) _______________ Account: 533-49110-000-000 Premium on Bonds Sold Totals: .00 (4,957.90) ** .00 Budgeted 4,957.90 Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg (30,645.00) .00 (30,645.00) _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 (30,645.00) ** (65,255.00) Budgeted (34,610.00) Remaining 47 % Used Department Totals: ------------------------------------------------------------------------------------------------ (735,153.13) ** (761,578.00) Budgeted (26,424.87) Remaining 97 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 2206 09/17/2015 Paying Agent Fee TCMUD1-13 1,250.00 500.00 1,750.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 500.00 1,750.00 ** 2,550.00 Budgeted 800.00 Remaining 69 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 283,983.06 .00 283,983.06 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 283,983.06 ** 283,984.00 Budgeted .94 Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax 440,000.00 .00 440,000.00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 440,000.00 ** 440,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 725,733.06 ** 726,534.00 Budgeted 800.94 Remaining 100 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (9,420.07) (35,044.00) Budgeted (25,623.93) Remaining 27 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET SEPTEMBER 2015 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 15,068 ACCOUNTS RECEIVABLE - TOTAL ASSETS 15,068 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 15,068 TOTAL FUND BALANCE 15,068 TOTAL LIABILITIES AND FUND BALANCE 15,068 . glbase_tbam rgonzale Trophy Club MUD #1 Page 26 19:26 10/07/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 1.06- 10,452.98- 10,452.98 534-49110-000-000 Bond Premium 4,615.00- 4,615.00 534-49143-000-000 Interfund Transfer In-WW Sales 136,989.00- 136,989.00- 100.000 Subtotal: 136,989.00- 1.06- 152,056.98- 110.999 15,067.98 Program number: 136,989.00- 1.06- 152,056.98- 110.999 15,067.98 Department number: Revenues 136,989.00- 1.06- 152,056.98- 110.999 15,067.98 Revenues Subtotal ----------- 136,989.00- 1.06- 152,056.98- 110.999 15,067.98 . glbase_tbam rgonzale Trophy Club MUD #1 Page 27 19:26 10/07/15 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/2015 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 136,989.00 136,988.54 100.000 .46 Subtotal: 136,989.00 136,988.54 100.000 .46 Program number: 136,989.00 136,988.54 100.000 .46 Department number: Administration 136,989.00 136,988.54 100.000 .46 Expenditures Subtotal ----------- 136,989.00 136,988.54 100.000 .46 Fund number: 534 2015 Revenue Bond I&S 1.06- 15,068.44- 15,068.44 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 63 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 2246 09/30/2015 Bank Interest/September (10,451.92) (1.06) (10,452.98) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (1.06) (10,452.98) ** .00 Budgeted 10,452.98 Remaining 0 % Used Account: 534-49110-000-000 Bond Premium (4,615.00) .00 (4,615.00) _______________ Account: 534-49110-000-000 Bond Premium Totals: .00 (4,615.00) ** .00 Budgeted 4,615.00 Remaining 0 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales (136,989.00) .00 (136,989.00) _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 (136,989.00) ** (136,989.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (152,056.98) ** (136,989.00) Budgeted 15,067.98 Remaining 111 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 64 19:26 10/07/15 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/2015 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70040-051-000 Revenue Bond Interest Expense 136,988.54 .00 136,988.54 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 136,988.54 ** 136,989.00 Budgeted .46 Remaining 100 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 136,988.54 ** 136,989.00 Budgeted .46 Remaining 100 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (15,068.44) .00 Budgeted 15,068.44 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (14,484,622.27) **** (103,642.00) Budgeted 14,380,980.27 Remaining ########## ******* End of Report *********