The URL can be used to link to this page

Home My WebLink About2016-10 October Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 2016 122 ASSETS FIRE DEPT. CASH IN BANK 17,563 INVESTMENTS 361,323 PREPAID EXPENSES 16,513 ADVALOREM PROPERTY TAXES RECEIVABLE 1,040,926 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,135 TOTAL ASSETS 1,437,460 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,040,926 ACCOUNTS AND OTHER PAYABLES 39,106 TOTAL LIABILITIES 1,080,032 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 521,108 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (163,680) TOTAL FUND BALANCE 357,428 TOTAL LIABILITIES AND FUND BALANCE 1,437,460 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 11:47 12/14/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 112.02- 112.02- 112.02 122-40010-000-000 Property Taxes/MUD Fire 1,035,810.00- 1,035,810.00- 5,262.22- 5,262.22- .508 1,030,547.78- 122-40011-000-000 Property Taxes/Fire-Delinquent 784.28- 784.28- 784.28 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 229.27- 229.27- 5.095 4,270.73- Subtotal: 1,040,310.00- 1,040,310.00- 6,387.79- 6,387.79- .614 1,033,922.21- Program number: 1,040,310.00- 1,040,310.00- 6,387.79- 6,387.79- .614 1,033,922.21- Department number: Fire Revenues 1,040,310.00- 1,040,310.00- 6,387.79- 6,387.79- .614 1,033,922.21- Revenues Subtotal ----------- 1,040,310.00- 1,040,310.00- 6,387.79- 6,387.79- .614 1,033,922.21- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 11:47 12/14/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60030-045-000 Rent And/Or Usage 216,754.00 216,754.00 216,754.00 122-60055-045-000 Insurance 16,513.00 16,513.00 16,513.00 122-60337-045-000 Transfer to Town/Fire Budget 581,638.00 581,638.00 42,919.00 42,919.00 7.379 538,719.00 Subtotal: 814,905.00 814,905.00 42,919.00 42,919.00 5.267 771,986.00 122-69005-045-000 Capital Outlays 16,836.00 16,836.00 16,836.00 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 127,148.60 100.000 .40 Subtotal: 225,405.00 225,405.00 127,148.60 127,148.60 56.409 98,256.40 Program number: 1,040,310.00 1,040,310.00 170,067.60 170,067.60 16.348 870,242.40 Department number: Fire 1,040,310.00 1,040,310.00 170,067.60 170,067.60 16.348 870,242.40 Expenditures Subtotal ----------- 1,040,310.00 1,040,310.00 170,067.60 170,067.60 16.348 870,242.40 Fund number: 122 Trophy Club MUD Fire Dept. 163,679.81 163,679.81 163,679.81- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 189 10/21/2016 Town/ESD final assessment Sept (112.02) (112.02) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (112.02) (112.02) ** .00 Budgeted 112.02 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 221 10/07/2016 Property Taxes (1,089.16) (1,089.16) GL 222 10/11/2016 Property Taxes (193.56) (1,282.72) GL 223 10/12/2016 Property Taxes (803.71) (2,086.43) GL 224 10/13/2016 Property Taxes (216.81) (2,303.24) GL 225 10/17/2016 Property Taxes (161.56) (2,464.80) GL 226 10/18/2016 Property Taxes (794.17) (3,258.97) GL 227 10/19/2016 Property Taxes (88.63) (3,347.60) GL 228 10/20/2016 Property Taxes (411.60) (3,759.20) GL 229 10/24/2016 Property Taxes (397.09) (4,156.29) GL 230 10/27/2016 Property Taxes (2.24) (4,158.53) GL 231 10/28/2016 Property Taxes (664.80) (4,823.33) GL 232 10/31/2016 Property Taxes (438.89) (5,262.22) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (5,262.22) (5,262.22) ** (1,035,810.00) Budgeted (1,030,547.78) Remaining 1 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 219 10/03/2016 Property Taxes (.74) (.74) GL 220 10/04/2016 Property Taxes (132.37) (133.11) GL 221 10/07/2016 Property Taxes (388.31) (521.42) GL 222 10/11/2016 Property Taxes (137.18) (658.60) GL 223 10/12/2016 Property Taxes (116.11) (774.71) GL 225 10/17/2016 Property Taxes (48.93) (823.64) GL 227 10/19/2016 Property Taxes 39.36 (784.28) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (784.28) (784.28) ** .00 Budgeted 784.28 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 220 10/04/2016 Property Taxes (11.73) (11.73) GL 221 10/07/2016 Property Taxes (81.66) (93.39) GL 222 10/11/2016 Property Taxes (28.81) (122.20) GL 223 10/12/2016 Property Taxes (91.32) (213.52) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 225 10/17/2016 Property Taxes (15.41) (228.93) GL 230 10/27/2016 Property Taxes (.34) (229.27) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (229.27) (229.27) ** (4,500.00) Budgeted (4,270.73) Remaining 5 % Used Department Totals: ----------------------------------- (6,387.79) ** (6,387.79) Monthly Total (1,040,310.00) Budgeted (1,033,922.21) Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 216,754.00 Budgeted 216,754.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance .00 .00 _______________ Account: 122-60055-045-000 Insurance Totals: .00 .00 ** 16,513.00 Budgeted 16,513.00 Remaining 0 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 102 10/20/2016 Oct A/P Oct Fire Budget payment 42,919.00 42,919.00 TOWN OF TROPHY CLUB 2460 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 42,919.00 42,919.00 ** 581,638.00 Budgeted 538,719.00 Remaining 7 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 16,836.00 Budgeted 16,836.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 81,420.00 Budgeted 81,420.00 Remaining 0 % Used Account: 122-69305-045-000 Capital Leases 43 10/11/2016 October A/P Ladder Truck Lease T-681 127,148.60 127,148.60 PNC Bank, N.A. 2427 AP _______________ Account: 122-69305-045-000 Capital Leases Totals: 127,148.60 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 170,067.60 ** 170,067.60 Monthly Total 1,040,310.00 Budgeted 870,242.40 Remaining 16 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: ----------------------------------- 163,679.81 163,679.81 Monthly Total .00 Budgeted (163,679.81) Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET OCTOBER 2016 GENERAL FUND GASB COMBINED BALANCE @ 10/31/16 ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 491,222 - 491,222 CASH IN BANK-SAVINGS-CASH RESERVE 180,187 - 180,187 CD-BANK OF THE WEST/THB DEPOSIT 35,158 - 35,158 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 712,301 - 712,301 INVESTMENTS-TEXPOOL 1,043,637 276,750 1,320,387 PREPAID EXPENSES 85,249 - 85,249 ADVALOREM PROPERTY TAXES RECEIVABLE 62,093 - 62,093 UTILITY AND OTHER ACCOUNTS RECEIVABLE 944,671 - 944,671 TOTAL ASSETS 3,555,118 276,750 3,831,868 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 62,093 - 62,093 ACCOUNTS AND OTHER PAYABLES 669,684 - 662,134 CUSTOMER DEPOSITS 317,025 - 317,025 - TOTAL LIABILITIES 1,048,802 - 1,048,802 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 276,750 276,750 NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 181,897 181,897 UNASSIGNED FUND BALANCE 1,946,225 - 1,946,225 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 374,708 - 374,708 - TOTAL FUND BALANCE 2,506,316 276,750 2,783,066 TOTAL LIABILITIES AND FUND BALANCE 3,555,118 276,750 3,831,868 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 11:47 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 60,977.00- 60,977.00- 309.58- 309.58- .508 60,667.42- 135-40002-000-000 Property Taxes/Delinquent 56.11- 56.11- 56.11 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 18.30- 18.30- 2.815 631.70- 135-40025-000-000 PID Surcharges 148,291.00- 148,291.00- 148,291.00- Subtotal: 209,918.00- 209,918.00- 383.99- 383.99- .183 209,534.01- 135-47000-000-000 Water 6,436,734.00- 6,436,734.00- 425,128.37- 425,128.37- 6.605 6,011,605.63- 135-47005-000-000 Sewer 2,629,524.00- 2,629,524.00- 192,335.18- 192,335.18- 7.314 2,437,188.82- 135-47025-000-000 Penalties 119,260.00- 119,260.00- 13,727.13- 13,727.13- 11.510 105,532.87- 135-47030-000-000 Service Charges 11,400.00- 11,400.00- 1,475.00- 1,475.00- 12.939 9,925.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 350.00- 350.00- 17.500 1,650.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 300.00- 300.00- 5.455 5,200.00- 135-47070-000-000 TCCC Effluent Charges 61,188.00- 61,188.00- 5,539.50- 5,539.50- 9.053 55,648.50- Subtotal: 9,265,606.00- 9,265,606.00- 638,855.18- 638,855.18- 6.895 8,626,750.82- 135-49010-000-000 Interest Income 8,001.00- 8,001.00- 938.96- 938.96- 11.736 7,062.04- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 910.53- 8.334 10,015.47- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 583.33- 8.333 6,416.67- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49075-000-000 Oversize Meter Reimbursement 21,609.00- 21,609.00- 2,783.00- 2,783.00- 12.879 18,826.00- 135-49900-000-000 Miscellaneous Income 20,000.00- 20,000.00- 2,019.06- 2,019.06- 10.095 17,980.94- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 20.00- Subtotal: 69,556.00- 69,556.00- 7,234.88- 7,234.88- 10.402 62,321.12- Program number: 9,545,080.00- 9,545,080.00- 646,474.05- 646,474.05- 6.773 8,898,605.95- Department number: Revenues 9,545,080.00- 9,545,080.00- 646,474.05- 646,474.05- 6.773 8,898,605.95- Revenues Subtotal ----------- 9,545,080.00- 9,545,080.00- 646,474.05- 646,474.05- 6.773 8,898,605.95- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 11:47 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 271,143.00 271,143.00 9,211.93 9,211.93 3.397 261,931.07 135-50010-010-000 Overtime 19,500.00 19,500.00 718.32 718.32 3.684 18,781.68 135-50016-010-000 Longevity 3,270.00 3,270.00 3,270.00 135-50017-010-000 Certification 4,800.00 4,800.00 225.00 225.00 4.688 4,575.00 135-50020-010-000 Retirement 27,151.00 27,151.00 886.57 886.57 3.265 26,264.43 135-50026-010-000 Medical Insurance 55,914.00 55,914.00 1,597.56 1,597.56 2.857 54,316.44 135-50027-010-000 Dental Insurance 4,159.00 4,159.00 121.36 121.36 2.918 4,037.64 135-50028-010-000 Vision Insurance 910.00 910.00 27.21 27.21 2.990 882.79 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 200.95 200.95 7.169 2,602.05 135-50030-010-000 Social Security Taxes 19,021.00 19,021.00 626.75 626.75 3.295 18,394.25 135-50035-010-000 Medicare Taxes 4,448.00 4,448.00 146.59 146.59 3.296 4,301.41 135-50040-010-000 Unemployment Taxes 1,026.00 1,026.00 1,026.00 135-50045-010-000 Workman's Compensation 13,152.00 13,152.00 13,152.00 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 1,300.00 135-50070-010-000 Employee Relations 300.00 300.00 300.00 Subtotal: 428,897.00 428,897.00 13,762.24 13,762.24 3.209 415,134.76 135-55005-010-000 Engineering 5,000.00 5,000.00 5,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 3,734.24 3,734.24 3.734 96,265.76 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 8,000.00 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 415.40 415.40 7.553 5,084.60 Subtotal: 125,000.00 125,000.00 4,149.64 4,149.64 3.320 120,850.36 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 5,400.00 135-60020-010-000 Electricity 172,737.00 172,737.00 4,387.42 4,387.42 2.540 168,349.58 135-60066-010-000 Publications/Books/Subscripts 750.00 750.00 750.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 4,222.00 4,222.00 265.00 265.00 6.277 3,957.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,500.00 1,500.00 1,500.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 50,176.00 50,176.00 50,176.00 135-60150-010-000 Wholesale Water 2,998,802.00 2,998,802.00 2,998,802.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 5,000.00 5,000.00 750.00 750.00 15.000 4,250.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 14,750.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 297,011.00 297,011.00 297,011.00 135-60333-010-000 Interfund Transfer Out-Reserve 64,920.00 64,920.00 64,920.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 11:47 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,820,368.00 3,820,368.00 5,402.42 5,402.42 .141 3,814,965.58 135-65005-010-000 Fuel & Lube 33,011.00 33,011.00 511.78 511.78 1.550 32,499.22 135-65010-010-000 Uniforms 4,608.00 4,608.00 4,608.00 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,956.29 1,956.29 9.781 18,043.71 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 115,000.00 115,000.00 8,066.26 8,066.26 7.014 106,933.74 135-65053-010-000 Meter Change Out Program 81,500.00 81,500.00 81,500.00 Subtotal: 256,319.00 256,319.00 10,534.33 10,534.33 4.110 245,784.67 135-69005-010-000 Capital Outlays 502,421.00 502,421.00 71,330.60 71,330.60 14.197 431,090.40 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 135-69281-010-000 Water Tank Inspection Contract 118,775.00 118,775.00 118,775.00 Subtotal: 696,196.00 696,196.00 71,330.60 71,330.60 10.246 624,865.40 135-70040-010-000 Bond Related Expenses 4,635.00 4,635.00 4,635.00- Subtotal: 4,635.00 4,635.00 4,635.00- Program number: 5,326,780.00 5,326,780.00 109,814.23 109,814.23 2.062 5,216,965.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 11:47 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 10,000.00 Department number: Water 5,336,780.00 5,336,780.00 109,814.23 109,814.23 2.058 5,226,965.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 11:47 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 391,102.00 391,102.00 14,834.86 14,834.86 3.793 376,267.14 135-50010-020-000 Overtime 29,500.00 29,500.00 1,126.78 1,126.78 3.820 28,373.22 135-50016-020-000 Longevity 6,635.00 6,635.00 6,635.00 135-50017-020-000 Certification 7,800.00 7,800.00 625.00 625.00 8.013 7,175.00 135-50020-020-000 Retirement 39,584.00 39,584.00 1,448.01 1,448.01 3.658 38,135.99 135-50026-020-000 Medical Insurance 73,022.00 73,022.00 2,777.83 2,777.83 3.804 70,244.17 135-50027-020-000 Dental Insurance 4,592.00 4,592.00 174.62 174.62 3.803 4,417.38 135-50028-020-000 Vision Insurance 1,031.00 1,031.00 39.17 39.17 3.799 991.83 135-50029-020-000 Life Insurance & Other 4,485.00 4,485.00 352.95 352.95 7.870 4,132.05 135-50030-020-000 Social Security Taxes 27,886.00 27,886.00 935.64 935.64 3.355 26,950.36 135-50035-020-000 Medicare Taxes 6,522.00 6,522.00 218.82 218.82 3.355 6,303.18 135-50040-020-000 Unemployment Taxes 1,197.00 1,197.00 1,197.00 135-50045-020-000 Workman's Compensation 11,347.00 11,347.00 11,347.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 650.00 650.00 650.00 Subtotal: 605,653.00 605,653.00 22,533.68 22,533.68 3.721 583,119.32 135-55005-020-000 Engineering 70,000.00 70,000.00 70,000.00 135-55070-020-000 Independent Labor 20,000.00 20,000.00 6,182.00 6,182.00 30.910 13,818.00 135-55080-020-000 Maintenance & Repairs 83,100.00 83,100.00 873.20 873.20 1.051 82,226.80 135-55085-020-000 Generator Maint. and Repair 20,000.00 20,000.00 20,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 815.87 815.87 20.397 3,184.13 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 500.00 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 3,549.00 3,549.00 6.453 51,451.00 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 1,688.00 1,688.00 6.752 23,312.00 Subtotal: 277,600.00 277,600.00 13,108.07 13,108.07 4.722 264,491.93 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 5,400.00 135-60020-020-000 Electricity 158,627.00 158,627.00 3,387.39 3,387.39 2.135 155,239.61 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 400.00 135-60070-020-000 Dues & Memberships 250.00 250.00 250.00 135-60080-020-000 Schools & Training 4,195.00 4,195.00 4,195.00 135-60090-020-000 Safety Program 550.00 550.00 34.60 34.60 6.291 515.40 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 35.85 35.85 2.241 1,564.15 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 9,888.02 9,888.02 57.656 7,261.98 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 6,621.00 6,621.00 590.00 590.00 8.911 6,031.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 11,600.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,492.00 120,492.00 120,492.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 595,638.00 595,638.00 595,638.00 135-60333-020-000 Interfund Transfer Out-Reserve 123,492.00 123,492.00 123,492.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 11:47 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 Subtotal: 1,255,465.00 1,255,465.00 13,935.86 13,935.86 1.110 1,241,529.14 135-65005-020-000 Fuel & Lube 28,088.00 28,088.00 392.56 392.56 1.398 27,695.44 135-65010-020-000 Uniforms 4,459.00 4,459.00 3,076.94 3,076.94 69.005 1,382.06 135-65030-020-000 Chemicals 25,000.00 25,000.00 2,548.72 2,548.72 10.195 22,451.28 135-65035-020-000 Small Tools 2,000.00 2,000.00 782.54 782.54 39.127 1,217.46 135-65040-020-000 Safety Equipment 750.00 750.00 750.00 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 216.12 216.12 1.544 13,783.88 Subtotal: 74,297.00 74,297.00 7,016.88 7,016.88 9.444 67,280.12 135-69005-020-000 Capital Outlays 485,000.00 485,000.00 14,827.55 14,827.55 3.057 470,172.45 Subtotal: 485,000.00 485,000.00 14,827.55 14,827.55 3.057 470,172.45 Program number: 2,698,015.00 2,698,015.00 71,422.04 71,422.04 2.647 2,626,592.96 Department number: Wastewater 2,698,015.00 2,698,015.00 71,422.04 71,422.04 2.647 2,626,592.96 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 11:47 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50045-026-000 Workman's Compensation 32.00 32.00 32.00 Subtotal: 32.00 32.00 32.00 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.00 135-60075-026-000 Meetings 1,200.00 1,200.00 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,125.00 1,125.00 28.125 2,875.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 2,000.00 Subtotal: 12,850.00 12,850.00 1,125.00 1,125.00 8.755 11,725.00 Program number: 12,882.00 12,882.00 1,125.00 1,125.00 8.733 11,757.00 Department number: Board of Directors 12,882.00 12,882.00 1,125.00 1,125.00 8.733 11,757.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 11:47 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 519,883.00 519,883.00 14,328.56 14,328.56 2.756 505,554.44 135-50010-030-000 Overtime 1,000.00 1,000.00 182.80 182.80 18.280 817.20 135-50016-030-000 Longevity 3,890.00 3,890.00 3,890.00 135-50020-030-000 Retirement 47,768.00 47,768.00 1,062.93 1,062.93 2.225 46,705.07 135-50026-030-000 Medical Insurance 84,289.00 84,289.00 1,691.19 1,691.19 2.006 82,597.81 135-50027-030-000 Dental Insurance 5,981.00 5,981.00 120.38 120.38 2.013 5,860.62 135-50028-030-000 Vision Insurance 1,312.00 1,312.00 26.97 26.97 2.056 1,285.03 135-50029-030-000 Life Insurance & Other 5,890.00 5,890.00 128.18 128.18 2.176 5,761.82 135-50030-030-000 Social Security Taxes 32,777.00 32,777.00 720.18 720.18 2.197 32,056.82 135-50035-030-000 Medicare Taxes 8,084.00 8,084.00 168.43 168.43 2.083 7,915.57 135-50040-030-000 Unemployment Taxes 1,368.00 1,368.00 18.90 18.90 1.382 1,349.10 135-50045-030-000 Workman's Compensation 1,784.00 1,784.00 1,784.00 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 4,960.00 4,960.00 4,960.00 Subtotal: 719,486.00 719,486.00 18,448.52 18,448.52 2.564 701,037.48 135-55030-030-000 Software & Support 67,791.00 67,791.00 1,540.25 1,540.25 2.272 66,250.75 135-55070-030-000 Independent Labor 12,000.00 12,000.00 12,000.00 135-55080-030-000 Maintenance & Repairs 7,000.00 7,000.00 7,000.00 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 130.89 130.89 1.870 6,869.11 135-55120-030-000 Cleaning Services 10,429.00 10,429.00 259.00- 259.00- -2.483 10,688.00 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 57,332.00 57,332.00 90.536 5,993.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 8,200.00 Subtotal: 185,945.00 185,945.00 58,744.14 58,744.14 31.592 127,200.86 135-60005-030-000 Telephone 17,532.00 17,532.00 1,035.94 1,035.94 5.909 16,496.06 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 150.00 150.00 3.614 4,000.00 135-60020-030-000 Electricity/Gas 12,631.00 12,631.00 12,631.00 135-60025-030-000 Water 1,500.00 1,500.00 95.26 95.26 6.351 1,404.74 135-60035-030-000 Postage 28,932.00 28,932.00 1,412.61 1,412.61 4.883 27,519.39 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,657.51 4,657.51 8.383 50,902.49 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 3,500.00 135-60055-030-000 Insurance 55,692.00 55,692.00 55,692.00 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 6,000.00 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 8,754.00 8,754.00 8,754.00 135-60080-030-000 Schools & Training 7,840.00 7,840.00 7,840.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 51.57 51.57 .955 5,348.43 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 11:47 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 7,500.00 7,500.00 7,500.00 135-60125-030-000 Advertising 7,500.00 7,500.00 300.00 300.00 4.000 7,200.00 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,500.00 17,500.00 17,500.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 246,041.00 246,041.00 7,702.89 7,702.89 3.131 238,338.11 135-65010-030-000 Uniforms 1,855.00 1,855.00 1,855.00 135-65055-030-000 Hardware 9,444.00 9,444.00 9,444.00 135-65085-030-000 Office Supplies 9,000.00 9,000.00 194.20 194.20 2.158 8,805.80 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 2,000.00 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 131.92 131.92 2.638 4,868.08 135-65105-030-000 Printing 4,800.00 4,800.00 4,800.00 Subtotal: 32,099.00 32,099.00 326.12 326.12 1.016 31,772.88 135-69005-030-000 Capital Outlays 107,001.00 107,001.00 1,127.92 1,127.92 1.054 105,873.08 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 165.00 165.00 3.587 4,435.00 Subtotal: 111,601.00 111,601.00 1,292.92 1,292.92 1.159 110,308.08 Program number: 1,295,172.00 1,295,172.00 86,514.59 86,514.59 6.680 1,208,657.41 Department number: Administration 1,295,172.00 1,295,172.00 86,514.59 86,514.59 6.680 1,208,657.41 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 11:47 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 150,000.00 150,000.00 360.00 360.00 .240 149,640.00 135-55055-039-000 Auditing 23,860.00 23,860.00 23,860.00 135-55060-039-000 Appraisal 11,115.00 11,115.00 2,529.84 2,529.84 22.761 8,585.16 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 188,775.00 188,775.00 2,889.84 2,889.84 1.531 185,885.16 Program number: 188,775.00 188,775.00 2,889.84 2,889.84 1.531 185,885.16 Department number: Non Departmental 188,775.00 188,775.00 2,889.84 2,889.84 1.531 185,885.16 Expenditures Subtotal ----------- 9,531,624.00 9,531,624.00 271,765.70 271,765.70 2.851 9,259,858.30 Fund number: 135 MUD 1 General Fund 13,456.00- 13,456.00- 374,708.35- 374,708.35- 2,784.693 361,252.35 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 221 10/07/2016 Property Taxes (64.08) (64.08) GL 222 10/11/2016 Property Taxes (11.39) (75.47) GL 223 10/12/2016 Property Taxes (47.28) (122.75) GL 224 10/13/2016 Property Taxes (12.76) (135.51) GL 225 10/17/2016 Property Taxes (9.50) (145.01) GL 226 10/18/2016 Property Taxes (46.72) (191.73) GL 227 10/19/2016 Property Taxes (5.21) (196.94) GL 228 10/20/2016 Property Taxes (24.22) (221.16) GL 229 10/24/2016 Property Taxes (23.36) (244.52) GL 230 10/27/2016 Property Taxes (.13) (244.65) GL 231 10/28/2016 Property Taxes (39.11) (283.76) GL 232 10/31/2016 Property Taxes (25.82) (309.58) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (309.58) (309.58) ** (60,977.00) Budgeted (60,667.42) Remaining 1 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 219 10/03/2016 Property Taxes (.05) (.05) GL 220 10/04/2016 Property Taxes (9.55) (9.60) GL 221 10/07/2016 Property Taxes (25.50) (35.10) GL 222 10/11/2016 Property Taxes (8.97) (44.07) GL 223 10/12/2016 Property Taxes (11.41) (55.48) GL 225 10/17/2016 Property Taxes (3.20) (58.68) GL 227 10/19/2016 Property Taxes 2.57 (56.11) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (56.11) (56.11) ** .00 Budgeted 56.11 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 220 10/04/2016 Property Taxes (1.03) (1.03) GL 221 10/07/2016 Property Taxes (5.38) (6.41) GL 222 10/11/2016 Property Taxes (1.88) (8.29) GL 223 10/12/2016 Property Taxes (8.98) (17.27) GL 225 10/17/2016 Property Taxes (1.01) (18.28) GL 230 10/27/2016 Property Taxes (.02) (18.30) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (18.30) (18.30) ** (650.00) Budgeted (631.70) Remaining 3 % Used Account: 135-40025-000-000 PID Surcharges . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (148,291.00) Budgeted (148,291.00) Remaining 0 % Used Account: 135-47000-000-000 Water 459 10/01/2016 Rev UB Accrued Rec & Town Liab 80,074.07 80,074.07 GL 139 10/31/2016 UB Billing 10/31/2016 UB20161031-20161031 User: (505,202.44) (425,128.37) UB _______________ Account: 135-47000-000-000 Water Totals: (425,128.37) (425,128.37) ** (6,436,734.00) Budgeted (6,011,605.63) Remaining 7 % Used Account: 135-47005-000-000 Sewer 459 10/01/2016 Rev UB Accrued Rec & Town Liab 37,497.02 37,497.02 GL 139 10/31/2016 UB Billing 10/31/2016 UB20161031-20161031 User: (229,832.20) (192,335.18) UB _______________ Account: 135-47005-000-000 Sewer Totals: (192,335.18) (192,335.18) ** (2,629,524.00) Budgeted (2,437,188.82) Remaining 7 % Used Account: 135-47025-000-000 Penalties 153 10/18/2016 10/18/2016 Penaltys UB20161018-20161018 User: 176.41 176.41 UB 111 10/21/2016 10/21/16 UB Penalties UB20161021-20161021 User: (14,332.09) (14,155.68) UB 157 10/28/2016 10/28/16 Penalties UB20161028-20161028 User: 428.55 (13,727.13) UB _______________ Account: 135-47025-000-000 Penalties Totals: (13,727.13) (13,727.13) ** (119,260.00) Budgeted (105,532.87) Remaining 12 % Used Account: 135-47030-000-000 Service Charges 23 10/06/2016 10/06/16 Disconnect day UB20161006-20161006 User: (1,375.00) (1,375.00) UB 151 10/07/2016 10/07/2016 Adjustment Fee UB20161007-20161007 User: (25.00) (1,400.00) UB 154 10/19/2016 10/19/2016 Adjustment UB20161019-20161019 User: (25.00) (1,425.00) UB 239 10/21/2016 UB 10/21/16 NSF fee UB20161021-20161021 User: (25.00) (1,450.00) UB 241 10/24/2016 UB 10/24/16 NSF Check fee UB20161024-20161024 User: (25.00) (1,475.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,475.00) (1,475.00) ** (11,400.00) Budgeted (9,925.00) Remaining 13 % Used Account: 135-47035-000-000 Plumbing Inspections . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 16 10/05/2016 Permitting 10/5/16 2701 A Trophy Club Drive (50.00) (50.00) CR 16 10/05/2016 Permitting 10/5/16 2430 A Trophy Club Drive (50.00) (100.00) CR 16 10/05/2016 Permitting 10/5/16 2513 A Trophy Club Drive (50.00) (150.00) CR 16 10/05/2016 Permitting 10/5/16 2601 A Trophy Club Drive (50.00) (200.00) CR 16 10/05/2016 Permitting 10/5/16 2700 A Trophy Club Drive (50.00) (250.00) CR 386 10/31/2016 Town A/R Billing(Shared Exp) AR 20161001-20161031 User: (100.00) (350.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (350.00) (350.00) ** (2,000.00) Budgeted (1,650.00) Remaining 18 % Used Account: 135-47045-000-000 Sewer Inspections 386 10/31/2016 Town A/R Billing(Shared Exp) AR 20161001-20161031 User: (300.00) (300.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (300.00) ** (5,500.00) Budgeted (5,200.00) Remaining 5 % Used Account: 135-47070-000-000 TCCC Effluent Charges 139 10/31/2016 UB Billing 10/31/2016 UB20161031-20161031 User: (5,539.50) (5,539.50) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (5,539.50) (5,539.50) ** (61,188.00) Budgeted (55,648.50) Remaining 9 % Used Account: 135-49010-000-000 Interest Income 190 10/31/2016 Texpool Oct Interest (580.16) (580.16) GL 237 10/31/2016 Bank of West Interest (151.21) (731.37) GL 237 10/31/2016 Bank of West Interest (207.59) (938.96) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (938.96) (938.96) ** (8,001.00) Budgeted (7,062.04) Remaining 12 % Used Account: 135-49016-000-000 Cell Tower Revenue 185 10/06/2016 AT&T Cell Tower Revenue (910.53) (910.53) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (910.53) ** (10,926.00) Budgeted (10,015.47) Remaining 8 % Used Account: 135-49018-000-000 Building Rent Income 386 10/31/2016 Town A/R Billing(Shared Exp) AR 20161001-20161031 User: (583.33) (583.33) AR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (583.33) ** (7,000.00) Budgeted (6,416.67) Remaining 8 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 16 10/05/2016 Permitting 10/5/16 2701 A Trophy Club Drive (343.00) (343.00) CR 16 10/05/2016 Permitting 10/5/16 2430 A Trophy Club Drive (725.00) (1,068.00) CR 16 10/05/2016 Permitting 10/5/16 2513 A Trophy Club Drive (343.00) (1,411.00) CR 16 10/05/2016 Permitting 10/5/16 2601 A Trophy Club Drive (343.00) (1,754.00) CR 16 10/05/2016 Permitting 10/5/16 2700 A Trophy Club Drive (343.00) (2,097.00) CR 386 10/31/2016 Town A/R Billing(Shared Exp) AR 20161001-20161031 User: (686.00) (2,783.00) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (2,783.00) (2,783.00) ** (21,609.00) Budgeted (18,826.00) Remaining 13 % Used Account: 135-49900-000-000 Miscellaneous Income 186 10/13/2016 Lone Star Metals/Sell of scrap (22.75) (22.75) GL 187 10/21/2016 AT&T Refund Directory Asst fee (363.75) (386.50) GL 139 10/31/2016 UB Billing 10/31/2016 UB20161031-20161031 User: (32.56) (419.06) UB 386 10/31/2016 Town A/R Billing(Shared Exp) AR 20161001-20161031 User: (1,600.00) (2,019.06) AR _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (2,019.06) (2,019.06) ** (20,000.00) Budgeted (17,980.94) Remaining 10 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (20.00) Budgeted (20.00) Remaining 0 % Used Department Totals: ----------------------------------- (646,474.05) ** (646,474.05) Monthly Total (9,545,080.00) Budgeted (8,898,605.95) Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (8,825.45) (8,825.45) GL 10 10/07/2016 MUD Payroll 10/7/16 Salaries & Wages 8,825.45 .00 PR 85 10/21/2016 Supplemental P/R Tenure checks Salaries & Wages 175.76 175.76 PR 83 10/21/2016 MUD Payroll 10/21/16 Salaries & Wages 9,036.17 9,211.93 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 9,211.93 9,211.93 ** 271,143.00 Budgeted 261,931.07 Remaining 3 % Used Account: 135-50010-010-000 Overtime 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (407.70) (407.70) GL 10 10/07/2016 MUD Payroll 10/7/16 Overtime 521.93 114.23 PR 83 10/21/2016 MUD Payroll 10/21/16 Overtime 604.09 718.32 PR _______________ Account: 135-50010-010-000 Overtime Totals: 718.32 718.32 ** 19,500.00 Budgeted 18,781.68 Remaining 4 % Used Account: 135-50016-010-000 Longevity .00 .00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 .00 ** 3,270.00 Budgeted 3,270.00 Remaining 0 % Used Account: 135-50017-010-000 Certification 83 10/21/2016 MUD Payroll 10/21/16 Certification 225.00 225.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 225.00 225.00 ** 4,800.00 Budgeted 4,575.00 Remaining 5 % Used Account: 135-50020-010-000 Retirement 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (806.05) (806.05) GL 10 10/07/2016 MUD Payroll 10/7/16 Retirement 816.03 9.98 PR 85 10/21/2016 Supplemental P/R Tenure checks Retirement 15.35 25.33 PR 83 10/21/2016 MUD Payroll 10/21/16 Retirement 861.24 886.57 PR _______________ Account: 135-50020-010-000 Retirement Totals: 886.57 886.57 ** 27,151.00 Budgeted 26,264.43 Remaining 3 % Used Account: 135-50026-010-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (1,563.59) (1,563.59) GL 10 10/07/2016 MUD Payroll 10/7/16 Medical Insurance 1,580.60 17.01 PR 83 10/21/2016 MUD Payroll 10/21/16 Medical Insurance 1,580.55 1,597.56 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,597.56 1,597.56 ** 55,914.00 Budgeted 54,316.44 Remaining 3 % Used Account: 135-50027-010-000 Dental Insurance 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (119.41) (119.41) GL 10 10/07/2016 MUD Payroll 10/7/16 Dental Insurance 120.39 .98 PR 83 10/21/2016 MUD Payroll 10/21/16 Dental Insurance 120.38 121.36 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 121.36 121.36 ** 4,159.00 Budgeted 4,037.64 Remaining 3 % Used Account: 135-50028-010-000 Vision Insurance 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (26.77) (26.77) GL 10 10/07/2016 MUD Payroll 10/7/16 Vision Insurance 27.01 .24 PR 83 10/21/2016 MUD Payroll 10/21/16 Vision Insurance 26.97 27.21 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 27.21 27.21 ** 910.00 Budgeted 882.79 Remaining 3 % Used Account: 135-50029-010-000 Life Insurance & Other 43 10/11/2016 October A/P Oct. Dental, Vision, Life & Ot 191.24 191.24 METLIFE GROUP BENEFITS 2426 AP 81 10/18/2016 October AP CAFE 125 adm fees 9.71 200.95 BenefitMall 2447 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 200.95 200.95 ** 2,803.00 Budgeted 2,602.05 Remaining 7 % Used Account: 135-50030-010-000 Social Security Taxes 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (564.17) (564.17) GL 10 10/07/2016 MUD Payroll 10/7/16 Social Security Taxes 575.39 11.22 PR 85 10/21/2016 Supplemental P/R Tenure checks Social Security Taxes 10.90 22.12 PR 83 10/21/2016 MUD Payroll 10/21/16 Social Security Taxes 604.63 626.75 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 626.75 626.75 ** 19,021.00 Budgeted 18,394.25 Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50035-010-000 Medicare Taxes 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (131.93) (131.93) GL 10 10/07/2016 MUD Payroll 10/7/16 Medicare Taxes 134.56 2.63 PR 85 10/21/2016 Supplemental P/R Tenure checks Medicare Taxes 2.55 5.18 PR 83 10/21/2016 MUD Payroll 10/21/16 Medicare Taxes 141.41 146.59 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 146.59 146.59 ** 4,448.00 Budgeted 4,301.41 Remaining 3 % Used Account: 135-50040-010-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 .00 ** 1,026.00 Budgeted 1,026.00 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation .00 .00 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 .00 ** 13,152.00 Budgeted 13,152.00 Remaining 0 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 1,300.00 Budgeted 1,300.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations .00 .00 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-010-000 Maintenance & Repairs 81 10/18/2016 October AP Chlorine analyzer 432.00 432.00 HD SUPPLY FACILITIES MAINT LTD 2452 AP 131 10/28/2016 October AP Probe Reads 162.00 594.00 HD SUPPLY FACILITIES MAINT LTD 2490 AP 131 10/28/2016 October AP Water plant gate 95.00 689.00 Alan's Gates, Inc. 2478 AP 176 10/31/2016 Oct A/P Meter risers & angle stops 3,045.24 3,734.24 HD SUPPLY WATERWORKS, LTD. 2491 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 3,734.24 3,734.24 ** 100,000.00 Budgeted 96,265.76 Remaining 4 % Used Account: 135-55085-010-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance .00 .00 _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 .00 ** 8,000.00 Budgeted 8,000.00 Remaining 0 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 176 10/31/2016 Oct A/P TCEQ Samples/MUD 207.70 207.70 LOWER COLORADO RIVER AUTHORITY 2500 AP 198 10/31/2016 Oct A/P TCEQ Water Samples/PID 207.70 415.40 LOWER COLORADO RIVER AUTHORITY 2543 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 415.40 415.40 ** 5,500.00 Budgeted 5,084.60 Remaining 8 % Used Account: 135-60010-010-000 Communications/Mobiles .00 .00 _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: .00 .00 ** 5,400.00 Budgeted 5,400.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-010-000 Electricity 66 10/14/2016 October AP Electricity 10/1-10/10/16 1,527.94 1,527.94 HUDSON ENERGY SERVICES, LLC 2453 AP 131 10/28/2016 October AP Electricity 10/1-10/10/16 2,859.48 4,387.42 HUDSON ENERGY SERVICES, LLC 2492 AP _______________ Account: 135-60020-010-000 Electricity Totals: 4,387.42 4,387.42 ** 172,737.00 Budgeted 168,349.58 Remaining 3 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 194 10/26/2016 Oct A/P TRWA 265.00 265.00 TRWA PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 265.00 265.00 ** 4,222.00 Budgeted 3,957.00 Remaining 6 % 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 .00 .00 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60105-010-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 .00 .00 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 .00 ** 50,176.00 Budgeted 50,176.00 Remaining 0 % Used Account: 135-60150-010-000 Wholesale Water .00 .00 _______________ Account: 135-60150-010-000 Wholesale Water Totals: .00 .00 ** 2,998,802.00 Budgeted 2,998,802.00 Remaining 0 % 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 176 10/31/2016 Oct A/P October Mowing 750.00 750.00 WATTS ELLISON LLC 2516 AP _______________ Account: 135-60280-010-000 Property Maintenance Totals: 750.00 750.00 ** 5,000.00 Budgeted 4,250.00 Remaining 15 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 14,750.00 Budgeted 14,750.00 Remaining 0 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: .00 .00 ** 297,011.00 Budgeted 297,011.00 Remaining 0 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve .00 .00 _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: .00 .00 ** 64,920.00 Budgeted 64,920.00 Remaining 0 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 196 10/31/2016 Oct A/P 10/1-10/24/16 Fuel Purchases 511.78 511.78 US Bank Voyager Fleet Systems 2542 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 511.78 511.78 ** 33,011.00 Budgeted 32,499.22 Remaining 2 % Used Account: 135-65010-010-000 Uniforms .00 .00 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 .00 ** 4,608.00 Budgeted 4,608.00 Remaining 0 % Used Account: 135-65030-010-000 Chemicals 81 10/18/2016 October AP Chemicals 1,208.21 1,208.21 HACH COMPANY 2450 AP 81 10/18/2016 October AP Testing supplies 61.65 1,269.86 HACH COMPANY 2450 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 131 10/28/2016 October AP Lab supplies 50.79 1,320.65 HACH COMPANY 2489 AP 131 10/28/2016 October AP Chlorine 635.64 1,956.29 DPC INDUSTRIES, INC 2482 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,956.29 1,956.29 ** 20,000.00 Budgeted 18,043.71 Remaining 10 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 81 10/18/2016 October AP Fireline meter 4,382.00 4,382.00 ATLAS UTILITY SUPPLY CO. 2445 AP 81 10/18/2016 October AP Meters-Vet Clinic 1,524.26 5,906.26 ATLAS UTILITY SUPPLY CO. 2445 AP 81 10/18/2016 October AP Meter 630.00 6,536.26 ATLAS UTILITY SUPPLY CO. 2445 AP 81 10/18/2016 October AP meter 1,530.00 8,066.26 ATLAS UTILITY SUPPLY CO. 2445 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 8,066.26 8,066.26 ** 115,000.00 Budgeted 106,933.74 Remaining 7 % Used Account: 135-65053-010-000 Meter Change Out Program .00 .00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 .00 ** 81,500.00 Budgeted 81,500.00 Remaining 0 % Used Account: 135-69005-010-000 Capital Outlays 174 10/31/2016 Fryer App 3 LAS Bldg Retainage 10,739.00 10,739.00 GL 176 10/31/2016 Oct A/P LAS Bldg App 3 60,591.60 71,330.60 FRYER CONSTRUCTION COMPANY 2487 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 71,330.60 71,330.60 ** 502,421.00 Budgeted 431,090.40 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69195-010-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 75,000.00 Budgeted 75,000.00 Remaining 0 % Used Account: 135-69281-010-000 Water Tank Inspection Contract .00 .00 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 .00 ** 118,775.00 Budgeted 118,775.00 Remaining 0 % Used Account: 135-70040-010-000 Bond Related Expenses 78 10/18/2016 Oct A/P TCMUD Water & Sewer Revenue Bo 4,635.00 4,635.00 ATTORNEY GENERAL/STATE OF TX 2446 AP _______________ Account: 135-70040-010-000 Bond Related Expenses Totals: 4,635.00 4,635.00 ** .00 Budgeted (4,635.00) Remaining 0 % Used Account: 135-55135-010-001 Lab Analysis for PID .00 .00 _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ----------------------------------- 109,814.23 ** 109,814.23 Monthly Total 5,336,780.00 Budgeted 5,226,965.77 Remaining 2 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (14,481.74) (14,481.74) GL 10 10/07/2016 MUD Payroll 10/7/16 Salaries & Wages 14,489.35 7.61 PR 85 10/21/2016 Supplemental P/R Tenure checks Salaries & Wages 117.17 124.78 PR 83 10/21/2016 MUD Payroll 10/21/16 Salaries & Wages 14,710.08 14,834.86 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,834.86 14,834.86 ** 391,102.00 Budgeted 376,267.14 Remaining 4 % Used Account: 135-50010-020-000 Overtime 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (579.87) (579.87) GL 10 10/07/2016 MUD Payroll 10/7/16 Overtime 638.48 58.61 PR 83 10/21/2016 MUD Payroll 10/21/16 Overtime 1,068.17 1,126.78 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,126.78 1,126.78 ** 29,500.00 Budgeted 28,373.22 Remaining 4 % Used Account: 135-50016-020-000 Longevity .00 .00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 .00 ** 6,635.00 Budgeted 6,635.00 Remaining 0 % Used Account: 135-50017-020-000 Certification 83 10/21/2016 MUD Payroll 10/21/16 Certification 625.00 625.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 625.00 625.00 ** 7,800.00 Budgeted 7,175.00 Remaining 8 % Used Account: 135-50020-020-000 Retirement 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (1,314.89) (1,314.89) GL 10 10/07/2016 MUD Payroll 10/7/16 Retirement 1,320.66 5.77 PR 85 10/21/2016 Supplemental P/R Tenure checks Retirement 10.23 16.00 PR 83 10/21/2016 MUD Payroll 10/21/16 Retirement 1,432.01 1,448.01 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,448.01 1,448.01 ** 39,584.00 Budgeted 38,135.99 Remaining 4 % Used Account: 135-50026-020-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (2,754.14) (2,754.14) GL 10 10/07/2016 MUD Payroll 10/7/16 Medical Insurance 2,765.99 11.85 PR 83 10/21/2016 MUD Payroll 10/21/16 Medical Insurance 2,765.98 2,777.83 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,777.83 2,777.83 ** 73,022.00 Budgeted 70,244.17 Remaining 4 % Used Account: 135-50027-020-000 Dental Insurance 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (173.29) (173.29) GL 10 10/07/2016 MUD Payroll 10/7/16 Dental Insurance 173.97 .68 PR 83 10/21/2016 MUD Payroll 10/21/16 Dental Insurance 173.94 174.62 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 174.62 174.62 ** 4,592.00 Budgeted 4,417.38 Remaining 4 % Used Account: 135-50028-020-000 Vision Insurance 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (38.88) (38.88) GL 10 10/07/2016 MUD Payroll 10/7/16 Vision Insurance 39.05 .17 PR 83 10/21/2016 MUD Payroll 10/21/16 Vision Insurance 39.00 39.17 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 39.17 39.17 ** 1,031.00 Budgeted 991.83 Remaining 4 % Used Account: 135-50029-020-000 Life Insurance & Other 43 10/11/2016 October A/P Oct. Dental, Vision, Life & Ot 325.82 325.82 METLIFE GROUP BENEFITS 2426 AP 81 10/18/2016 October AP CAFE 125 adm fees 27.13 352.95 BenefitMall 2447 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 352.95 352.95 ** 4,485.00 Budgeted 4,132.05 Remaining 8 % Used Account: 135-50030-020-000 Social Security Taxes 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (824.17) (824.17) GL 10 10/07/2016 MUD Payroll 10/7/16 Social Security Taxes 845.30 21.13 PR 85 10/21/2016 Supplemental P/R Tenure checks Social Security Taxes 7.27 28.40 PR 83 10/21/2016 MUD Payroll 10/21/16 Social Security Taxes 907.24 935.64 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 935.64 935.64 ** 27,886.00 Budgeted 26,950.36 Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50035-020-000 Medicare Taxes 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (192.77) (192.77) GL 10 10/07/2016 MUD Payroll 10/7/16 Medicare Taxes 197.71 4.94 PR 85 10/21/2016 Supplemental P/R Tenure checks Medicare Taxes 1.70 6.64 PR 83 10/21/2016 MUD Payroll 10/21/16 Medicare Taxes 212.18 218.82 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 218.82 218.82 ** 6,522.00 Budgeted 6,303.18 Remaining 3 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,197.00 Budgeted 1,197.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation .00 .00 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 .00 ** 11,347.00 Budgeted 11,347.00 Remaining 0 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 650.00 Budgeted 650.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .00 .00 _______________ Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55070-020-000 Independent Labor 81 10/18/2016 October AP Installation of SCADA on trail 1,710.00 1,710.00 DHS AUTOMATION, INC 2448 AP 81 10/18/2016 October AP Kit for Lift Station #7 4,472.00 6,182.00 XYLEM WATER SOLUTIONS USA INC 2458 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 6,182.00 6,182.00 ** 20,000.00 Budgeted 13,818.00 Remaining 31 % Used Account: 135-55080-020-000 Maintenance & Repairs 194 10/26/2016 Oct A/P THE HOME DEPOT #6581 308.30 308.30 THE HOME DEPOT #6581 PC 194 10/26/2016 Oct A/P STUART HOSE & PIPE-FT 564.90 873.20 STUART HOSE & PIPE-FT PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 873.20 873.20 ** 83,100.00 Budgeted 82,226.80 Remaining 1 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 194 10/26/2016 Oct A/P MUSTANG ELITE CAR WASH 10.99 10.99 MUSTANG ELITE CAR WASH PC 194 10/26/2016 Oct A/P MUSTANG ELITE CAR 265.96 276.95 MUSTANG ELITE CAR PC 194 10/26/2016 Oct A/P MUSTANG ELITE CAR 152.98 429.93 MUSTANG ELITE CAR PC 194 10/26/2016 Oct A/P MUSTANG ELITE CAR WASH 39.00 468.93 MUSTANG ELITE CAR WASH PC 194 10/26/2016 Oct A/P MUSTANG ELITE CAR 335.95 804.88 MUSTANG ELITE CAR PC 194 10/26/2016 Oct A/P MUSTANG ELITE CAR WASH 10.99 815.87 MUSTANG ELITE CAR WASH PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 815.87 815.87 ** 4,000.00 Budgeted 3,184.13 Remaining 20 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 131 10/28/2016 October AP Sludge Haul Off 2,535.00 2,535.00 L.H. CHANEY MATERIALS, INC. 2497 AP 131 10/28/2016 October AP Over payment on Invoice# 12674 (338.00) 2,197.00 L.H. CHANEY MATERIALS, INC. 2497 AP 131 10/28/2016 October AP Sludge haul Off overpayment In (338.00) 1,859.00 L.H. CHANEY MATERIALS, INC. 2497 AP 131 10/28/2016 October AP Sludge haul off 1,690.00 3,549.00 L.H. CHANEY MATERIALS, INC. 2497 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,549.00 3,549.00 ** 55,000.00 Budgeted 51,451.00 Remaining 6 % Used Account: 135-55135-020-000 Lab Analysis 66 10/14/2016 October AP Testing 176.00 176.00 OXIDOR LABORATORIES LLC 2454 AP 66 10/14/2016 October AP Testing 246.00 422.00 OXIDOR LABORATORIES LLC 2454 AP 66 10/14/2016 October AP Testing 176.00 598.00 OXIDOR LABORATORIES LLC 2454 AP 66 10/14/2016 October AP Testing 246.00 844.00 OXIDOR LABORATORIES LLC 2454 AP 131 10/28/2016 October AP Chemicals 246.00 1,090.00 OXIDOR LABORATORIES LLC 2505 AP 131 10/28/2016 October AP Lab Analysis 176.00 1,266.00 OXIDOR LABORATORIES LLC 2505 AP 131 10/28/2016 October AP Lab analysis 176.00 1,442.00 OXIDOR LABORATORIES LLC 2505 AP 131 10/28/2016 October AP Lab Analysis 246.00 1,688.00 OXIDOR LABORATORIES LLC 2505 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,688.00 1,688.00 ** 25,000.00 Budgeted 23,312.00 Remaining 7 % Used Account: 135-60010-020-000 Communications/Mobiles .00 .00 _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: .00 .00 ** 5,400.00 Budgeted 5,400.00 Remaining 0 % Used Account: 135-60020-020-000 Electricity 66 10/14/2016 October AP Electricity 10/1-10/7/16 14.12 14.12 HUDSON ENERGY SERVICES, LLC 2453 AP 66 10/14/2016 October AP Electricity 10/1-10/7/16 15.26 29.38 HUDSON ENERGY SERVICES, LLC 2453 AP 66 10/14/2016 October AP Electricity 10/1-10/10 31.93 61.31 HUDSON ENERGY SERVICES, LLC 2453 AP 131 10/28/2016 October AP Electricity 10/1-10/30/16 109.87 171.18 MP2 ENERGY TEXAS LLC 2502 AP 131 10/28/2016 October AP Electricity 10/1-10/10/16 170.29 341.47 ENGIE Resources LLC 2483 AP 131 10/28/2016 October AP Electricity 10/1-10/10/16 158.01 499.48 HUDSON ENERGY SERVICES, LLC 2492 AP 131 10/28/2016 October AP Electricity 10/1-10/10/16 3,097.70 3,597.18 HUDSON ENERGY SERVICES, LLC 2492 AP 386 10/31/2016 Town A/R Billing(Shared Exp) AR 20161001-20161031 User: (209.79) 3,387.39 AR _______________ Account: 135-60020-020-000 Electricity Totals: 3,387.39 3,387.39 ** 158,627.00 Budgeted 155,239.61 Remaining 2 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 4,195.00 Budgeted 4,195.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program 194 10/26/2016 Oct A/P SALAD BOWL 10 34.60 34.60 SALAD BOWL 10 PC _______________ Account: 135-60090-020-000 Safety Program Totals: 34.60 34.60 ** 550.00 Budgeted 515.40 Remaining 6 % Used Account: 135-60100-020-000 Travel & per diem 131 10/28/2016 October AP Tolls-Samples to the lab 35.85 35.85 NTTA 2503 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 35.85 35.85 ** 1,600.00 Budgeted 1,564.15 Remaining 2 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 176 10/31/2016 Oct A/P WW Permit Fee 9,888.02 9,888.02 TX COMMISSION ENVIRONMENTAL QU 2513 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 9,888.02 9,888.02 ** 17,150.00 Budgeted 7,261.98 Remaining 58 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 176 10/31/2016 Oct A/P October Mowing 590.00 590.00 WATTS ELLISON LLC 2516 AP _______________ Account: 135-60280-020-000 Property Maintenance Totals: 590.00 590.00 ** 6,621.00 Budgeted 6,031.00 Remaining 9 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 11,600.00 Budgeted 11,600.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S .00 .00 _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 .00 ** 120,492.00 Budgeted 120,492.00 Remaining 0 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S .00 .00 _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 .00 ** 595,638.00 Budgeted 595,638.00 Remaining 0 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: .00 .00 ** 123,492.00 Budgeted 123,492.00 Remaining 0 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 196 10/31/2016 Oct A/P 10/1-10/24/16 Fuel Purchases 392.56 392.56 US Bank Voyager Fleet Systems 2542 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 392.56 392.56 ** 28,088.00 Budgeted 27,695.44 Remaining 1 % Used Account: 135-65010-020-000 Uniforms 66 10/14/2016 October AP Uniforms 1,223.50 1,223.50 PANDA EMBROIDERY 2455 AP 194 10/26/2016 Oct A/P TRACTOR SUPPLY COMPANY 64.99 1,288.49 TRACTOR SUPPLY COMPANY PC 194 10/26/2016 Oct A/P TRACTOR SUPPLY COMPANY 219.97 1,508.46 TRACTOR SUPPLY COMPANY PC 194 10/26/2016 Oct A/P BOOT BARN #150 131.74 1,640.20 BOOT BARN #150 PC 194 10/26/2016 Oct A/P BOOT BARN #150 165.74 1,805.94 BOOT BARN #150 PC 194 10/26/2016 Oct A/P ACADEMY SPORTS #81 223.90 2,029.84 ACADEMY SPORTS #81 PC 194 10/26/2016 Oct A/P TRACTOR SUPPLY COMPANY 119.99 2,149.83 TRACTOR SUPPLY COMPANY PC 194 10/26/2016 Oct A/P WAL-MART #5247 18.00 2,167.83 WAL-MART #5247 PC 194 10/26/2016 Oct A/P ACADEMY SPORTS #81 114.95 2,282.78 ACADEMY SPORTS #81 PC 194 10/26/2016 Oct A/P ACADEMY SPORTS #76 142.98 2,425.76 ACADEMY SPORTS #76 PC 194 10/26/2016 Oct A/P RED WING SHOES #652 161.49 2,587.25 RED WING SHOES #652 PC 194 10/26/2016 Oct A/P ACADEMY SPORTS #76 (24.89) 2,562.36 ACADEMY SPORTS #76 PC 194 10/26/2016 Oct A/P ACADEMY SPORTS #141 19.99 2,582.35 ACADEMY SPORTS #141 PC 194 10/26/2016 Oct A/P ACADEMY.COM 24.89 2,607.24 ACADEMY.COM PC 194 10/26/2016 Oct A/P BOOT BARN #150 289.98 2,897.22 BOOT BARN #150 PC 194 10/26/2016 Oct A/P ACADEMY SPORTS #81 129.94 3,027.16 ACADEMY SPORTS #81 PC 194 10/26/2016 Oct A/P ACADEMY.COM 24.89 3,052.05 ACADEMY.COM PC 194 10/26/2016 Oct A/P ACADEMY.COM 24.89 3,076.94 ACADEMY.COM PC _______________ Account: 135-65010-020-000 Uniforms Totals: 3,076.94 3,076.94 ** 4,459.00 Budgeted 1,382.06 Remaining 69 % Used Account: 135-65030-020-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 81 10/18/2016 October AP HTH 1,850.00 1,850.00 HARCROS CHEMICALS INC 2451 AP 194 10/26/2016 Oct A/P IN *AQUAFIX, INC. 698.72 2,548.72 IN *AQUAFIX, INC. PC _______________ Account: 135-65030-020-000 Chemicals Totals: 2,548.72 2,548.72 ** 25,000.00 Budgeted 22,451.28 Remaining 10 % Used Account: 135-65035-020-000 Small Tools 43 10/11/2016 October A/P Printer-Karl 449.98 449.98 M3 Networks 2425 AP 194 10/26/2016 Oct A/P THE HOME DEPOT #6581 279.34 729.32 THE HOME DEPOT #6581 PC 194 10/26/2016 Oct A/P THE HOME DEPOT #6581 53.22 782.54 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 782.54 782.54 ** 2,000.00 Budgeted 1,217.46 Remaining 39 % Used Account: 135-65040-020-000 Safety Equipment .00 .00 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-65045-020-000 Lab Supplies 194 10/26/2016 Oct A/P OFFICE DEPOT #406 36.48 36.48 OFFICE DEPOT #406 PC 131 10/28/2016 October AP chemicals 179.64 216.12 IDEXX DISTRIBUTION, INC 2493 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 216.12 216.12 ** 14,000.00 Budgeted 13,783.88 Remaining 2 % Used Account: 135-69005-020-000 Capital Outlays 66 10/14/2016 October AP 20 hp influent pump 14,827.55 14,827.55 XYLEM WATER SOLUTIONS USA INC 2458 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 14,827.55 14,827.55 ** 485,000.00 Budgeted 470,172.45 Remaining 3 % Used Department 20 Totals: ----------------------------------- 71,422.04 ** 71,422.04 Monthly Total 2,698,015.00 Budgeted 2,626,592.96 Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (1,300.00) (1,300.00) GL 10 10/07/2016 MUD Payroll 10/7/16 Salaries & Wages 1,300.00 .00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-50030-026-000 Social Security Taxes 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (80.60) (80.60) GL 10 10/07/2016 MUD Payroll 10/7/16 Social Security Taxes 80.60 .00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-50035-026-000 Medicare Taxes 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (18.85) (18.85) GL 10 10/07/2016 MUD Payroll 10/7/16 Medicare Taxes 18.85 .00 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-50045-026-000 Workman's Compensation .00 .00 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 .00 ** 32.00 Budgeted 32.00 Remaining 0 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 43 10/11/2016 October A/P AWBD conf-Carr 285.00 285.00 AWBD 2412 AP 43 10/11/2016 October A/P AWBD Conf-Rose 285.00 570.00 AWBD 2412 AP 194 10/26/2016 Oct A/P NCTCOG RTC TRAINING 270.00 840.00 NCTCOG RTC TRAINING PC 176 10/31/2016 Oct A/P AWBD Mid-Winter Conf-Hase 285.00 1,125.00 AWBD 2479 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 1,125.00 1,125.00 ** 4,000.00 Budgeted 2,875.00 Remaining 28 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: ----------------------------------- 1,125.00 ** 1,125.00 Monthly Total 12,882.00 Budgeted 11,757.00 Remaining 9 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (11,497.20) (11,497.20) GL 10 10/07/2016 MUD Payroll 10/7/16 Salaries & Wages 11,497.20 .00 PR 66 10/14/2016 October AP Temp front desk 640.00 640.00 TRINITY EMPLOYMENT SOLUTIONS 2456 AP 85 10/21/2016 Supplemental P/R Tenure checks Salaries & Wages 292.93 932.93 PR 83 10/21/2016 MUD Payroll 10/21/16 Salaries & Wages 11,699.63 12,632.56 PR 131 10/28/2016 October AP Temp receptionist 512.00 13,144.56 TRINITY EMPLOYMENT SOLUTIONS 2511 AP 176 10/31/2016 Oct A/P Temp Receptionist 640.00 13,784.56 TRINITY EMPLOYMENT SOLUTIONS 2511 AP 176 10/31/2016 Oct A/P Temp Receptionist 544.00 14,328.56 TRINITY EMPLOYMENT SOLUTIONS 2511 AP _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 14,328.56 14,328.56 ** 519,883.00 Budgeted 505,554.44 Remaining 3 % Used Account: 135-50010-030-000 Overtime 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (174.63) (174.63) GL 10 10/07/2016 MUD Payroll 10/7/16 Overtime 174.63 .00 PR 83 10/21/2016 MUD Payroll 10/21/16 Overtime 182.80 182.80 PR _______________ Account: 135-50010-030-000 Overtime Totals: 182.80 182.80 ** 1,000.00 Budgeted 817.20 Remaining 18 % Used Account: 135-50016-030-000 Longevity .00 .00 _______________ Account: 135-50016-030-000 Longevity Totals: .00 .00 ** 3,890.00 Budgeted 3,890.00 Remaining 0 % Used Account: 135-50020-030-000 Retirement 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (1,018.94) (1,018.94) GL 10 10/07/2016 MUD Payroll 10/7/16 Retirement 1,018.94 .00 PR 85 10/21/2016 Supplemental P/R Tenure checks Retirement 25.57 25.57 PR 83 10/21/2016 MUD Payroll 10/21/16 Retirement 1,037.36 1,062.93 PR _______________ Account: 135-50020-030-000 Retirement Totals: 1,062.93 1,062.93 ** 47,768.00 Budgeted 46,705.07 Remaining 2 % Used Account: 135-50026-030-000 Medical Insurance 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (1,691.22) (1,691.22) GL 10 10/07/2016 MUD Payroll 10/7/16 Medical Insurance 1,691.22 .00 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 83 10/21/2016 MUD Payroll 10/21/16 Medical Insurance 1,691.19 1,691.19 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 1,691.19 1,691.19 ** 84,289.00 Budgeted 82,597.81 Remaining 2 % Used Account: 135-50027-030-000 Dental Insurance 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (120.39) (120.39) GL 10 10/07/2016 MUD Payroll 10/7/16 Dental Insurance 120.39 .00 PR 83 10/21/2016 MUD Payroll 10/21/16 Dental Insurance 120.38 120.38 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 120.38 120.38 ** 5,981.00 Budgeted 5,860.62 Remaining 2 % Used Account: 135-50028-030-000 Vision Insurance 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (27.01) (27.01) GL 10 10/07/2016 MUD Payroll 10/7/16 Vision Insurance 27.01 .00 PR 83 10/21/2016 MUD Payroll 10/21/16 Vision Insurance 26.97 26.97 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 26.97 26.97 ** 1,312.00 Budgeted 1,285.03 Remaining 2 % Used Account: 135-50029-030-000 Life Insurance & Other 43 10/11/2016 October A/P Oct. Dental, Vision, Life & Ot 101.04 101.04 METLIFE GROUP BENEFITS 2426 AP 81 10/18/2016 October AP CAFE 125 adm fees 27.16 128.20 BenefitMall 2447 AP 180 10/31/2016 Oct A/P Rounding adjustment (.02) 128.18 Legal Shield 2499 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 128.18 128.18 ** 5,890.00 Budgeted 5,761.82 Remaining 2 % Used Account: 135-50030-030-000 Social Security Taxes 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (683.01) (683.01) GL 10 10/07/2016 MUD Payroll 10/7/16 Social Security Taxes 689.45 6.44 PR 85 10/21/2016 Supplemental P/R Tenure checks Social Security Taxes 18.17 24.61 PR 83 10/21/2016 MUD Payroll 10/21/16 Social Security Taxes 695.57 720.18 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 720.18 720.18 ** 32,777.00 Budgeted 32,056.82 Remaining 2 % Used Account: 135-50035-030-000 Medicare Taxes . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (159.74) (159.74) GL 10 10/07/2016 MUD Payroll 10/7/16 Medicare Taxes 161.24 1.50 PR 85 10/21/2016 Supplemental P/R Tenure checks Medicare Taxes 4.25 5.75 PR 83 10/21/2016 MUD Payroll 10/21/16 Medicare Taxes 162.68 168.43 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 168.43 168.43 ** 8,084.00 Budgeted 7,915.57 Remaining 2 % Used Account: 135-50040-030-000 Unemployment Taxes 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (39.78) (39.78) GL 10 10/07/2016 MUD Payroll 10/7/16 Unemployment Taxes 39.78 .00 PR 83 10/21/2016 MUD Payroll 10/21/16 Unemployment Taxes 18.90 18.90 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 18.90 18.90 ** 1,368.00 Budgeted 1,349.10 Remaining 1 % Used Account: 135-50045-030-000 Workman's Compensation .00 .00 _______________ Account: 135-50045-030-000 Workman's Compensation Totals: .00 .00 ** 1,784.00 Budgeted 1,784.00 Remaining 0 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations .00 .00 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 .00 ** 4,960.00 Budgeted 4,960.00 Remaining 0 % Used Account: 135-55030-030-000 Software & Support 66 10/14/2016 October AP Internet 1,138.34 1,138.34 WHOLESALE CARRIER SERVICES INC 2457 AP 194 10/26/2016 Oct A/P ATT*BILL PAYMENT 159.94 1,298.28 ATT*BILL PAYMENT PC 194 10/26/2016 Oct A/P ATT*BILL PAYMENT 176.26 1,474.54 ATT*BILL PAYMENT PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 194 10/26/2016 Oct A/P WWW.ISTOCK.COM 35.72 1,510.26 WWW.ISTOCK.COM PC 194 10/26/2016 Oct A/P ADOBE *IL CREATIVE CLD 19.99 1,530.25 ADOBE *IL CREATIVE CLD PC 194 10/26/2016 Oct A/P CANVA.COM 10.00 1,540.25 CANVA.COM PC _______________ Account: 135-55030-030-000 Software & Support Totals: 1,540.25 1,540.25 ** 67,791.00 Budgeted 66,250.75 Remaining 2 % Used Account: 135-55070-030-000 Independent Labor .00 .00 _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 .00 ** 12,000.00 Budgeted 12,000.00 Remaining 0 % Used Account: 135-55080-030-000 Maintenance & Repairs .00 .00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 .00 ** 7,000.00 Budgeted 7,000.00 Remaining 0 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55100-030-000 Building Maint & Supplies 131 10/28/2016 October AP Rug Service 130.89 130.89 G & K SERVICES 2488 AP 131 10/28/2016 October AP Rug Service 130.89 261.78 G & K SERVICES 2488 AP 386 10/31/2016 Town A/R Billing(Shared Exp) AR 20161001-20161031 User: (130.89) 130.89 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 130.89 130.89 ** 7,000.00 Budgeted 6,869.11 Remaining 2 % Used Account: 135-55120-030-000 Cleaning Services 386 10/31/2016 Town A/R Billing(Shared Exp) AR 20161001-20161031 User: (259.00) (259.00) AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: (259.00) (259.00) ** 10,429.00 Budgeted 10,688.00 Remaining -2 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55160-030-000 Professional Outside Services 43 10/11/2016 October A/P Annual IT 56,475.00 56,475.00 M3 Networks 2425 AP 194 10/26/2016 Oct A/P PAYPAL *CERTIFIEDTR 250.00 56,725.00 PAYPAL *CERTIFIEDTR PC 176 10/31/2016 Oct A/P Certification by CPA (SWIFT) 607.00 57,332.00 LAFOLLETT & ABBOTT PLLC 2498 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 57,332.00 57,332.00 ** 63,325.00 Budgeted 5,993.00 Remaining 91 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 45 10/11/2016 Void A/P Ck 2389/wrong vendor (597.90) (597.90) DP2 BILLING SOLUTIONS, LLC 2389 AP 46 10/11/2016 Oct A/P Replace Voided CK 2389 597.90 .00 DATAPROSE LLC 2430 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: .00 .00 ** 8,200.00 Budgeted 8,200.00 Remaining 0 % Used Account: 135-60005-030-000 Telephone 43 10/11/2016 October A/P Answering Service-October 189.18 189.18 KEYSTONE PARK SECRETARIAL 2424 AP 194 10/26/2016 Oct A/P ATT*BUS PHONE PMT 443.39 632.57 ATT*BUS PHONE PMT PC 194 10/26/2016 Oct A/P ATT*BUS PHONE PMT 846.94 1,479.51 ATT*BUS PHONE PMT PC 194 10/26/2016 Oct A/P RINGCENTRAL, INC 10.73 1,490.24 RINGCENTRAL, INC PC 386 10/31/2016 Town A/R Billing(Shared Exp) AR 20161001-20161031 User: (454.30) 1,035.94 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,035.94 1,035.94 ** 17,532.00 Budgeted 16,496.06 Remaining 6 % Used Account: 135-60010-030-000 Communications/Mobiles 83 10/21/2016 MUD Payroll 10/21/16 Communications/Mobiles 150.00 150.00 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 150.00 150.00 ** 4,150.00 Budgeted 4,000.00 Remaining 4 % Used Account: 135-60020-030-000 Electricity/Gas . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 .00 ** 12,631.00 Budgeted 12,631.00 Remaining 0 % Used Account: 135-60025-030-000 Water 176 10/31/2016 Oct A/P MUD & PS Bldg Water 190.52 190.52 TROPHY CLUB MUD (WATER BILLS) 2512 AP 386 10/31/2016 Town A/R Billing(Shared Exp) AR 20161001-20161031 User: (95.26) 95.26 AR _______________ Account: 135-60025-030-000 Water Totals: 95.26 95.26 ** 1,500.00 Budgeted 1,404.74 Remaining 6 % Used Account: 135-60035-030-000 Postage 45 10/11/2016 Void A/P Ck 2389/wrong vendor (1,742.66) (1,742.66) DP2 BILLING SOLUTIONS, LLC 2389 AP 46 10/11/2016 Oct A/P Replace Voided CK 2389 1,742.66 .00 DATAPROSE LLC 2430 AP 53 10/13/2016 Oct A/P Water/Sewer Rate Notification 1,055.17 1,055.17 U.S. POSTAL SERVICE 2434 AP 194 10/26/2016 Oct A/P FEDEX 784307006161 38.15 1,093.32 FEDEX 784307006161 PC 131 10/28/2016 October AP Postage Machine Rental 90.00 1,183.32 FRANCOTYP-POSTALIA, INC. 2485 AP 131 10/28/2016 October AP Permit & renewal 215.00 1,398.32 U.S. POSTAL SERVICE 2514 AP 176 10/31/2016 Oct A/P Overnight letter 8.74 1,407.06 FEDERAL EXPRESS CORP 2484 AP 176 10/31/2016 Oct A/P Overnight letter 5.55 1,412.61 FEDERAL EXPRESS CORP 2484 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,412.61 1,412.61 ** 28,932.00 Budgeted 27,519.39 Remaining 5 % Used Account: 135-60040-030-000 Service Charges & Fees 238 10/04/2016 Credit card fees 129.24 129.24 GL 238 10/04/2016 Credit card fees 4,456.27 4,585.51 GL 13 10/07/2016 Child Support fee 10/7/16 P/R 1.50 4,587.01 GL 236 10/11/2016 Bk of West/Safety dep box 40.00 4,627.01 GL 66 10/14/2016 October AP Copier Lease 29.00 4,656.01 EVERBANK COMMERCIAL FINANCE 2449 AP 94 10/21/2016 Child support fee 10/21/16 P/R 1.50 4,657.51 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,657.51 4,657.51 ** 55,560.00 Budgeted 50,902.49 Remaining 8 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance .00 .00 _______________ Account: 135-60055-030-000 Insurance Totals: .00 .00 ** 55,692.00 Budgeted 55,692.00 Remaining 0 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-60075-030-000 Meetings .00 .00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60079-030-000 Public Education .00 .00 _______________ Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 8,754.00 Budgeted 8,754.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 .00 ** 7,840.00 Budgeted 7,840.00 Remaining 0 % Used Account: 135-60100-030-000 Travel & per diem 12 10/01/2016 Rev Accrued Payroll @ 9/30/16 (88.45) (88.45) GL 10 10/07/2016 MUD Payroll 10/7/16 Travel & per diem 88.45 .00 PR 83 10/21/2016 MUD Payroll 10/21/16 Travel & per diem 51.57 51.57 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 51.57 51.57 ** 5,400.00 Budgeted 5,348.43 Remaining 1 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections .00 .00 _______________ Account: 135-60115-030-000 Elections Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 194 10/26/2016 Oct A/P PAYPAL *TXMUNLEAGUE 150.00 150.00 PAYPAL *TXMUNLEAGUE PC 194 10/26/2016 Oct A/P PAYPAL *TXMUNLEAGUE 150.00 300.00 PAYPAL *TXMUNLEAGUE PC _______________ Account: 135-60125-030-000 Advertising Totals: 300.00 300.00 ** 7,500.00 Budgeted 7,200.00 Remaining 4 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 .00 ** 17,500.00 Budgeted 17,500.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniforms .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 1,855.00 Budgeted 1,855.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware .00 .00 _______________ Account: 135-65055-030-000 Hardware Totals: .00 .00 ** 9,444.00 Budgeted 9,444.00 Remaining 0 % Used Account: 135-65085-030-000 Office Supplies 194 10/26/2016 Oct A/P WAL-MART #2980 4.76 4.76 WAL-MART #2980 PC 194 10/26/2016 Oct A/P STAPLES DIRECT 26.28 31.04 STAPLES DIRECT PC 176 10/31/2016 Oct A/P Office Supplies 75.96 107.00 OFFICE DEPOT, INC 2504 AP 176 10/31/2016 Oct A/P Office Supplies 87.20 194.20 OFFICE DEPOT, INC 2504 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 194.20 194.20 ** 9,000.00 Budgeted 8,805.80 Remaining 2 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65095-030-000 Maintenance Supplies 194 10/26/2016 Oct A/P STAPLES 00116533 5.73 5.73 STAPLES 00116533 PC 194 10/26/2016 Oct A/P WAL-MART #5316 41.72 47.45 WAL-MART #5316 PC 194 10/26/2016 Oct A/P SAMS CLUB #4795 84.47 131.92 SAMS CLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 131.92 131.92 ** 5,000.00 Budgeted 4,868.08 Remaining 3 % Used Account: 135-65105-030-000 Printing .00 .00 _______________ Account: 135-65105-030-000 Printing Totals: .00 .00 ** 4,800.00 Budgeted 4,800.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays 131 10/28/2016 October AP Restroom remodel 1,127.92 1,127.92 STAR-TELEGRAM OPERATING LTD 2507 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 1,127.92 1,127.92 ** 107,001.00 Budgeted 105,873.08 Remaining 1 % Used Account: 135-69170-030-000 Copier Lease Installments 66 10/14/2016 October AP Copier Lease 165.00 165.00 EVERBANK COMMERCIAL FINANCE 2449 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 165.00 165.00 ** 4,600.00 Budgeted 4,435.00 Remaining 4 % Used Department 30 Totals: ----------------------------------- 86,514.59 ** 86,514.59 Monthly Total 1,295,172.00 Budgeted 1,208,657.41 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 176 10/31/2016 Oct A/P Resolution HB 1295 360.00 360.00 FREEMAN & CORBETT 2486 AP _______________ Account: 135-55045-039-000 Legal Totals: 360.00 360.00 ** 150,000.00 Budgeted 149,640.00 Remaining 0 % Used Account: 135-55055-039-000 Auditing .00 .00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 .00 ** 23,860.00 Budgeted 23,860.00 Remaining 0 % Used Account: 135-55060-039-000 Appraisal 176 10/31/2016 Oct A/P Annual payment Budget Allocati 2,529.84 2,529.84 TARRANT APPRAISAL DISTRICT 2508 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,529.84 2,529.84 ** 11,115.00 Budgeted 8,585.16 Remaining 23 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 3,800.00 Budgeted 3,800.00 Remaining 0 % Used Department 39 Totals: ----------------------------------- 2,889.84 ** 2,889.84 Monthly Total 188,775.00 Budgeted 185,885.16 Remaining 2 % Used Fund 135 Totals: ----------------------------------- (374,708.35) (374,708.35) Monthly Total (13,456.00) Budgeted 361,252.35 Remaining ########## TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET OCTOBER 2016 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,392,632 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,392,632 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,391,204 NET REVENUES / EXPENDITURES 1,428 TOTAL FUND BALANCE 4,392,632 TOTAL LIABILITIES AND FUND BALANCE 4,392,632 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 11:47 12/14/16 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,427.56- 1,427.56- 1,427.56 Subtotal: 1,427.56- 1,427.56- 1,427.56 Program number: 1,427.56- 1,427.56- 1,427.56 Department number: Revenues 1,427.56- 1,427.56- 1,427.56 Revenues Subtotal ----------- 1,427.56- 1,427.56- 1,427.56 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,427.56- 1,427.56- 1,427.56 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 190 10/31/2016 Texpool Oct Interest (1,427.56) (1,427.56) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,427.56) (1,427.56) ** .00 Budgeted 1,427.56 Remaining 0 % Used Department Totals: ----------------------------------- (1,427.56) ** (1,427.56) Monthly Total .00 Budgeted 1,427.56 Remaining 0 % Used Fund 517 Totals: ----------------------------------- (1,427.56) (1,427.56) Monthly Total .00 Budgeted 1,427.56 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET OCTOBER 2016 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 850,329 ACCOUNTS RECEIVABLE - TOTAL ASSETS 850,329 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 1,134,756 TOTAL LIABILITIES 1,134,756 FUND BALANCE ASSIGNED FUND BALANCE 41,831 NET REVENUES / EXPENDITURES (326,258) TOTAL FUND BALANCE (284,427) TOTAL LIABILITIES AND FUND BALANCE 850,329 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 11:47 12/14/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 347.80- 347.80- 347.80 Subtotal: 347.80- 347.80- 347.80 Program number: 347.80- 347.80- 347.80 Department number: Revenues 347.80- 347.80- 347.80 Revenues Subtotal ----------- 347.80- 347.80- 347.80 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 11:47 12/14/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 326,605.64 326,605.64 326,605.64- Subtotal: 326,605.64 326,605.64 326,605.64- Program number: 326,605.64 326,605.64 326,605.64- Department number: Wastewater 326,605.64 326,605.64 326,605.64- Expenditures Subtotal ----------- 326,605.64 326,605.64 326,605.64- Fund number: 518 2015 Revenue Bond Const Fund 326,257.84 326,257.84 326,257.84- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-49010-000-000 Interest Income 190 10/31/2016 Texpool Oct Interest (347.80) (347.80) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (347.80) (347.80) ** .00 Budgeted 347.80 Remaining 0 % Used Department Totals: ----------------------------------- (347.80) ** (347.80) Monthly Total .00 Budgeted 347.80 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-69005-020-000 Capital Outlays 179 10/31/2016 Oct A/P WW Upgrade App 13 326,605.64 326,605.64 WEBBER-CADAGUA PARTNERS 2517 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 326,605.64 326,605.64 ** .00 Budgeted (326,605.64) Remaining 0 % Used Department 20 Totals: ----------------------------------- 326,605.64 ** 326,605.64 Monthly Total .00 Budgeted (326,605.64) Remaining 0 % Used Fund 518 Totals: ----------------------------------- 326,257.84 326,257.84 Monthly Total .00 Budgeted (326,257.84) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET OCTOBER 2016 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 195,826 ACCOUNTS RECEIVABLE - TOTAL ASSETS 195,826 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 195,762 NET REVENUES / EXPENDITURES 64 TOTAL FUND BALANCE 195,826 TOTAL LIABILITIES AND FUND BALANCE 195,826 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 11:47 12/14/16 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 300.00- 300.00- 63.61- 63.61- 21.203 236.39- 528-49142-000-000 Interfund transfer in-Water 64,920.00- 64,920.00- 64,920.00- 528-49143-000-000 Interfund transfer in-WW 123,492.00- 123,492.00- 123,492.00- Subtotal: 188,712.00- 188,712.00- 63.61- 63.61- .034 188,648.39- Program number: 188,712.00- 188,712.00- 63.61- 63.61- .034 188,648.39- Department number: 188,712.00- 188,712.00- 63.61- 63.61- .034 188,648.39- Revenues Subtotal ----------- 188,712.00- 188,712.00- 63.61- 63.61- .034 188,648.39- Fund number: 528 2015 Revenue Bond Reserve Fund 188,712.00- 188,712.00- 63.61- 63.61- .034 188,648.39- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 190 10/31/2016 Texpool Oct Interest (63.61) (63.61) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (63.61) (63.61) ** (300.00) Budgeted (236.39) Remaining 21 % Used Account: 528-49142-000-000 Interfund transfer in-Water .00 .00 _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: .00 .00 ** (64,920.00) Budgeted (64,920.00) Remaining 0 % Used Account: 528-49143-000-000 Interfund transfer in-WW .00 .00 _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: .00 .00 ** (123,492.00) Budgeted (123,492.00) Remaining 0 % Used Department Totals: ----------------------------------- (63.61) ** (63.61) Monthly Total (188,712.00) Budgeted (188,648.39) Remaining 0 % Used Fund 528 Totals: ----------------------------------- (63.61) (63.61) Monthly Total (188,712.00) Budgeted (188,648.39) Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET OCTOBER 2016 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 25,287 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 676,331 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 706,464 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 676,331 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 676,331 FUND BALANCE ASSIGNED FUND BALANCE 26,031 NET REVENUES / EXPENDITURES 4,102 TOTAL FUND BALANCE 30,133 TOTAL LIABILITIES AND FUND BALANCE 706,464 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 11:47 12/14/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 673,336.00- 673,336.00- 3,420.29- 3,420.29- .508 669,915.71- 533-40002-000-000 Property Taxes/Delinquent 3,501.00- 3,501.00- 542.28- 542.28- 15.489 2,958.72- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 132.00- 132.00- 6.600 1,868.00- Subtotal: 678,837.00- 678,837.00- 4,094.57- 4,094.57- .603 674,742.43- 533-49010-000-000 Interest Income 140.00- 140.00- 7.50- 7.50- 5.357 132.50- 533-49015-000-000 Lease/Rental Income 216,754.00- 216,754.00- 216,754.00- 533-49141-000-000 Interfund Trans In-PID Surchg 120,492.00- 120,492.00- 120,492.00- Subtotal: 337,386.00- 337,386.00- 7.50- 7.50- .002 337,378.50- Program number: 1,016,223.00- 1,016,223.00- 4,102.07- 4,102.07- .404 1,012,120.93- Department number: Revenues 1,016,223.00- 1,016,223.00- 4,102.07- 4,102.07- .404 1,012,120.93- Revenues Subtotal ----------- 1,016,223.00- 1,016,223.00- 4,102.07- 4,102.07- .404 1,012,120.93- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 11:47 12/14/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 2,550.00 533-70025-051-000 Bond Interest Expense-Tax 300,583.00 300,583.00 300,583.00 533-70035-051-000 Bond Principal Payment-Tax 710,000.00 710,000.00 710,000.00 Subtotal: 1,013,133.00 1,013,133.00 1,013,133.00 Program number: 1,013,133.00 1,013,133.00 1,013,133.00 Department number: Administration 1,013,133.00 1,013,133.00 1,013,133.00 Expenditures Subtotal ----------- 1,013,133.00 1,013,133.00 1,013,133.00 Fund number: 533 MUD 1 I&S Consolidated 3,090.00- 3,090.00- 4,102.07- 4,102.07- 132.753 1,012.07 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 221 10/07/2016 Property Taxes (707.92) (707.92) GL 222 10/11/2016 Property Taxes (125.81) (833.73) GL 223 10/12/2016 Property Taxes (522.41) (1,356.14) GL 224 10/13/2016 Property Taxes (140.92) (1,497.06) GL 225 10/17/2016 Property Taxes (105.01) (1,602.07) GL 226 10/18/2016 Property Taxes (516.19) (2,118.26) GL 227 10/19/2016 Property Taxes (57.60) (2,175.86) GL 228 10/20/2016 Property Taxes (267.52) (2,443.38) GL 229 10/24/2016 Property Taxes (258.10) (2,701.48) GL 230 10/27/2016 Property Taxes (1.45) (2,702.93) GL 231 10/28/2016 Property Taxes (432.10) (3,135.03) GL 232 10/31/2016 Property Taxes (285.26) (3,420.29) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (3,420.29) (3,420.29) ** (673,336.00) Budgeted (669,915.71) Remaining 1 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 219 10/03/2016 Property Taxes (.55) (.55) GL 220 10/04/2016 Property Taxes (97.81) (98.36) GL 221 10/07/2016 Property Taxes (291.21) (389.57) GL 222 10/11/2016 Property Taxes (102.95) (492.52) GL 223 10/12/2016 Property Taxes (42.58) (535.10) GL 225 10/17/2016 Property Taxes (36.72) (571.82) GL 227 10/19/2016 Property Taxes 29.54 (542.28) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (542.28) (542.28) ** (3,501.00) Budgeted (2,958.72) Remaining 15 % Used Account: 533-40015-000-000 Property Taxes/P & I 220 10/04/2016 Property Taxes (8.36) (8.36) GL 221 10/07/2016 Property Taxes (61.21) (69.57) GL 222 10/11/2016 Property Taxes (21.62) (91.19) GL 223 10/12/2016 Property Taxes (33.09) (124.28) GL 225 10/17/2016 Property Taxes (7.72) (132.00) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (132.00) (132.00) ** (2,000.00) Budgeted (1,868.00) Remaining 7 % Used Account: 533-49010-000-000 Interest Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 190 10/31/2016 Texpool Oct Interest (7.50) (7.50) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (7.50) (7.50) ** (140.00) Budgeted (132.50) Remaining 5 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (216,754.00) Budgeted (216,754.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg .00 .00 _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 .00 ** (120,492.00) Budgeted (120,492.00) Remaining 0 % Used Department Totals: ----------------------------------- (4,102.07) ** (4,102.07) Monthly Total (1,016,223.00) Budgeted (1,012,120.93) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,550.00 Budgeted 2,550.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 300,583.00 Budgeted 300,583.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 710,000.00 Budgeted 710,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 1,013,133.00 Budgeted 1,013,133.00 Remaining 0 % Used Fund 533 Totals: ----------------------------------- (4,102.07) (4,102.07) Monthly Total (3,090.00) Budgeted 1,012.07 Remaining 133 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET OCTOBER 2016 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 15,102 ACCOUNTS RECEIVABLE - TOTAL ASSETS 15,102 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,097 NET REVENUES / EXPENDITURES 5 TOTAL FUND BALANCE 15,102 TOTAL LIABILITIES AND FUND BALANCE 15,102 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 11:47 12/14/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 200.00- 200.00- 4.96- 4.96- 2.480 195.04- 534-49142-000-000 Interfund Tran In-Water Sales 297,011.00- 297,011.00- 297,011.00- 534-49143-000-000 Interfund Transfer In-WW Sales 595,638.00- 595,638.00- 595,638.00- Subtotal: 892,849.00- 892,849.00- 4.96- 4.96- .001 892,844.04- Program number: 892,849.00- 892,849.00- 4.96- 4.96- .001 892,844.04- Department number: Revenues 892,849.00- 892,849.00- 4.96- 4.96- .001 892,844.04- Revenues Subtotal ----------- 892,849.00- 892,849.00- 4.96- 4.96- .001 892,844.04- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 11:47 12/14/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 10/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 387,649.00 387,649.00 387,649.00 534-70045-051-000 Revenue Bond Principal Expense 505,000.00 505,000.00 505,000.00 Subtotal: 892,649.00 892,649.00 892,649.00 Program number: 892,649.00 892,649.00 892,649.00 Department number: Administration 892,649.00 892,649.00 892,649.00 Expenditures Subtotal ----------- 892,649.00 892,649.00 892,649.00 Fund number: 534 2015 Revenue Bond I&S 200.00- 200.00- 4.96- 4.96- 2.480 195.04- ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 190 10/31/2016 Texpool Oct Interest (4.96) (4.96) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (4.96) (4.96) ** (200.00) Budgeted (195.04) Remaining 2 % Used Account: 534-49142-000-000 Interfund Tran In-Water Sales .00 .00 _______________ Account: 534-49142-000-000 Interfund Tran In-Water Sales Totals: .00 .00 ** (297,011.00) Budgeted (297,011.00) Remaining 0 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales .00 .00 _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 .00 ** (595,638.00) Budgeted (595,638.00) Remaining 0 % Used Department Totals: ----------------------------------- (4.96) ** (4.96) Monthly Total (892,849.00) Budgeted (892,844.04) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 11:49 12/14/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 10/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 387,649.00 Budgeted 387,649.00 Remaining 0 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 505,000.00 Budgeted 505,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 892,649.00 Budgeted 892,649.00 Remaining 0 % Used Fund 534 Totals: ----------------------------------- (4.96) (4.96) Monthly Total (200.00) Budgeted (195.04) Remaining 2 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 109,631.10 **** 109,631.10 Monthly Total (205,458.00) Budgeted (315,089.10) Remaining -53 % Used ******* End of Report *********