The URL can be used to link to this page

Home My WebLink About2016-11 November Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET NOVEMBER 2016 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 249,521 PREPAID EXPENSES 13,761 ADVALOREM PROPERTY TAXES RECEIVABLE 1,009,915 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,273,197 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,009,915 ACCOUNTS AND OTHER PAYABLES 5,305 TOTAL LIABILITIES 1,015,220 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 521,108 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (263,132) TOTAL FUND BALANCE 257,977 TOTAL LIABILITIES AND FUND BALANCE 1,273,197 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 16:15 12/14/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/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 122-40010-000-000 Property Taxes/MUD Fire 1,035,810.00- 1,035,810.00- 38,974.66- 44,236.88- 4.271 991,573.12- 122-40011-000-000 Property Taxes/Fire-Delinquent 13.37- 797.65- 797.65 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 11.10- 240.37- 5.342 4,259.63- Subtotal: 1,040,310.00- 1,040,310.00- 38,999.13- 45,386.92- 4.363 994,923.08- 122-49900-000-000 Miscellaneous Income 149.00- 149.00- 149.00 Subtotal: 149.00- 149.00- 149.00 Program number: 1,040,310.00- 1,040,310.00- 39,148.13- 45,535.92- 4.377 994,774.08- Department number: Fire Revenues 1,040,310.00- 1,040,310.00- 39,148.13- 45,535.92- 4.377 994,774.08- Revenues Subtotal ----------- 1,040,310.00- 1,040,310.00- 39,148.13- 45,535.92- 4.377 994,774.08- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 16:15 12/14/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 5,453.91 5,453.91 5,453.91- Subtotal: 5,453.91 5,453.91 5,453.91- 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 2,752.18 2,752.18 16.667 13,760.82 122-60337-045-000 Transfer to Town/Fire Budget 581,638.00 581,638.00 48,974.00 91,893.00 15.799 489,745.00 Subtotal: 814,905.00 814,905.00 51,726.18 94,645.18 11.614 720,259.82 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 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 225,405.00 225,405.00 81,420.00 208,568.60 92.531 16,836.40 Program number: 1,040,310.00 1,040,310.00 138,600.09 308,667.69 29.671 731,642.31 Department number: Fire 1,040,310.00 1,040,310.00 138,600.09 308,667.69 29.671 731,642.31 Expenditures Subtotal ----------- 1,040,310.00 1,040,310.00 138,600.09 308,667.69 29.671 731,642.31 Fund number: 122 Trophy Club MUD Fire Dept. 99,451.96 263,131.77 263,131.77- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/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 (112.02) .00 (112.02) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (112.02) ** .00 Budgeted 112.02 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 396 11/01/2016 Property Taxes (5,262.22) (2,254.04) (7,516.26) GL 397 11/02/2016 Property Taxes (116.08) (7,632.34) GL 398 11/03/2016 Property Taxes (729.98) (8,362.32) GL 399 11/04/2016 Property Taxes (4,989.46) (13,351.78) GL 400 11/07/2016 Property Taxes (3,417.31) (16,769.09) GL 402 11/08/2016 Property Taxes (1,579.28) (18,348.37) GL 403 11/09/2016 Property Taxes (591.90) (18,940.27) GL 404 11/10/2016 Property Taxes (2,275.88) (21,216.15) GL 405 11/15/2016 Property Taxes (2.01) (21,218.16) GL 406 11/16/2016 Property Taxes (3,750.36) (24,968.52) GL 407 11/17/2016 Property Taxes (2,618.57) (27,587.09) GL 408 11/18/2016 Property Taxes (3,153.95) (30,741.04) GL 409 11/21/2016 Property Taxes (1,606.44) (32,347.48) GL 410 11/22/2016 Property Taxes (1,402.28) (33,749.76) GL 411 11/23/2016 Property Taxes (1,372.82) (35,122.58) GL 412 11/28/2016 Property Taxes (3,987.98) (39,110.56) GL 413 11/29/2016 Property Taxes (5,089.48) (44,200.04) GL 414 11/30/2016 Property Taxes (36.84) (44,236.88) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (38,974.66) (44,236.88) ** (1,035,810.00) Budgeted (991,573.12) Remaining 4 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 396 11/01/2016 Property Taxes (784.28) (7.04) (791.32) GL 403 11/09/2016 Property Taxes 18.05 (773.27) GL 405 11/15/2016 Property Taxes (24.38) (797.65) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (13.37) (797.65) ** .00 Budgeted 797.65 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 396 11/01/2016 Property Taxes (229.27) (2.10) (231.37) GL 398 11/03/2016 Property Taxes (1.17) (232.54) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 402 11/08/2016 Property Taxes (229.27) (1.72) (234.26) GL 405 11/15/2016 Property Taxes (6.00) (240.26) GL 411 11/23/2016 Property Taxes (.11) (240.37) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (11.10) (240.37) ** (4,500.00) Budgeted (4,259.63) Remaining 5 % Used Account: 122-49900-000-000 Miscellaneous Income 372 11/28/2016 Nov A/P HAIX NORTH AMERICA (149.00) (149.00) HAIX NORTH AMERICA PC _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (149.00) (149.00) ** .00 Budgeted 149.00 Remaining 0 % Used Department Totals: ----------------------------------- (45,535.92) ** (39,148.13) Monthly Total (1,040,310.00) Budgeted (994,774.08) Remaining 4 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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-55080-045-000 Maintenance & Repairs 306 11/23/2016 November AP Repairs 176.95 176.95 Service Time Electric 2621 AP 417 11/30/2016 Nov A/P Security/Locks @ Fire Sta. (GA 5,276.96 5,453.91 MICHAEL'S KEYS INC. 2640 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 5,453.91 5,453.91 ** .00 Budgeted (5,453.91) Remaining 0 % Used 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 460 11/01/2016 Insurance/Wrk Comp Exp Oct 1,376.09 1,376.09 GL 461 11/01/2016 Insurance/Wrk Comp Exp Nov 1,376.09 2,752.18 GL _______________ Account: 122-60055-045-000 Insurance Totals: 2,752.18 2,752.18 ** 16,513.00 Budgeted 13,760.82 Remaining 17 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 199 11/07/2016 Nov A/P Nov Fire Budget 42,919.00 48,974.00 91,893.00 TOWN OF TROPHY CLUB 2544 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 48,974.00 91,893.00 ** 581,638.00 Budgeted 489,745.00 Remaining 16 % 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 307 11/25/2016 GASB 34 transfers Fiscal 2017 Fire Truck Future Replacement 81,420.00 81,420.00 GL _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 308,667.69 ** 138,600.09 Monthly Total 1,040,310.00 Budgeted 731,642.31 Remaining 30 % Used Fund 122 Totals: ----------------------------------- 263,131.77 99,451.96 Monthly Total .00 Budgeted (263,131.77) Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET NOVEMBER 2016 GENERAL FUND GASB COMBINED BALANCE @ 11/30/16 ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 740,974 - 740,974 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,447 - 712,447 INVESTMENTS-TEXPOOL 1,042,917 433,170 1,476,087 PREPAID EXPENSES 71,622 - 71,622 ADVALOREM PROPERTY TAXES RECEIVABLE 60,242 - 60,242 UTILITY AND OTHER ACCOUNTS RECEIVABLE 836,885 - 836,885 TOTAL ASSETS 3,681,032 433,170 4,114,202 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 60,242 - 60,242 ACCOUNTS AND OTHER PAYABLES 700,497 - 700,497 CUSTOMER DEPOSITS 316,535 - 316,535 - TOTAL LIABILITIES 1,077,274 - 1,077,274 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 433,170 433,170 NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,276,319 1,276,319 UNASSIGNED FUND BALANCE 851,803 - 851,803 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 472,149 - 472,149 - TOTAL FUND BALANCE 2,603,757 433,170 3,036,927 TOTAL LIABILITIES AND FUND BALANCE 3,681,032 433,170 4,114,202 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 16:15 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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- 2,292.94- 2,602.52- 4.268 58,374.48- 135-40002-000-000 Property Taxes/Delinquent 1.76- 57.87- 57.87 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 20.90- 39.20- 6.031 610.80- 135-40025-000-000 PID Surcharges 148,291.00- 148,291.00- 148,291.00- Subtotal: 209,918.00- 209,918.00- 2,315.60- 2,699.59- 1.286 207,218.41- 135-47000-000-000 Water 6,436,734.00- 6,436,734.00- 467,892.04- 893,020.41- 13.874 5,543,713.59- 135-47005-000-000 Sewer 2,629,524.00- 2,629,524.00- 229,720.41- 422,055.59- 16.051 2,207,468.41- 135-47025-000-000 Penalties 119,260.00- 119,260.00- 8,727.92- 22,455.05- 18.829 96,804.95- 135-47030-000-000 Service Charges 11,400.00- 11,400.00- 825.00- 2,300.00- 20.175 9,100.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 100.00- 450.00- 22.500 1,550.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 300.00- 600.00- 10.909 4,900.00- 135-47070-000-000 TCCC Effluent Charges 61,188.00- 61,188.00- 712.50- 6,252.00- 10.218 54,936.00- Subtotal: 9,265,606.00- 9,265,606.00- 708,277.87- 1,347,133.05- 14.539 7,918,472.95- 135-49010-000-000 Interest Income 8,001.00- 8,001.00- 924.07- 1,863.03- 23.285 6,137.97- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 1,821.06- 16.667 9,104.94- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 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- 686.00- 3,469.00- 16.053 18,140.00- 135-49900-000-000 Miscellaneous Income 20,000.00- 20,000.00- 38.03- 2,057.09- 10.285 17,942.91- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 20.00- Subtotal: 69,556.00- 69,556.00- 2,558.63- 9,793.51- 14.080 59,762.49- Program number: 9,545,080.00- 9,545,080.00- 713,152.10- 1,359,626.15- 14.244 8,185,453.85- Department number: Revenues 9,545,080.00- 9,545,080.00- 713,152.10- 1,359,626.15- 14.244 8,185,453.85- Revenues Subtotal ----------- 9,545,080.00- 9,545,080.00- 713,152.10- 1,359,626.15- 14.244 8,185,453.85- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 16:15 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 18,036.15 27,248.08 10.049 243,894.92 135-50010-010-000 Overtime 19,500.00 19,500.00 1,072.23 1,790.55 9.182 17,709.45 135-50016-010-000 Longevity 3,270.00 3,270.00 3,270.00 3,270.00 100.000 135-50017-010-000 Certification 4,800.00 4,800.00 225.00 450.00 9.375 4,350.00 135-50020-010-000 Retirement 27,151.00 27,151.00 1,973.26 2,859.83 10.533 24,291.17 135-50026-010-000 Medical Insurance 55,914.00 55,914.00 3,161.15 4,758.71 8.511 51,155.29 135-50027-010-000 Dental Insurance 4,159.00 4,159.00 240.77 362.13 8.707 3,796.87 135-50028-010-000 Vision Insurance 910.00 910.00 53.98 81.19 8.922 828.81 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 225.67 426.62 15.220 2,376.38 135-50030-010-000 Social Security Taxes 19,021.00 19,021.00 1,403.86 2,030.61 10.676 16,990.39 135-50035-010-000 Medicare Taxes 4,448.00 4,448.00 328.32 474.91 10.677 3,973.09 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 2,148.32 2,148.32 16.335 11,003.68 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 32,138.71 45,900.95 10.702 382,996.05 135-55005-010-000 Engineering 5,000.00 5,000.00 12,615.00 12,615.00 252.300 7,615.00- 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 12,867.40 16,601.64 16.602 83,398.36 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 10.50 10.50 .131 7,989.50 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 250.00 665.40 12.098 4,834.60 Subtotal: 125,000.00 125,000.00 25,742.90 29,892.54 23.914 95,107.46 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 365.59 365.59 6.770 5,034.41 135-60020-010-000 Electricity 172,737.00 172,737.00 12,494.12 16,881.54 9.773 155,855.46 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 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 124.46 124.46 8.297 1,375.54 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 14,190.95 14,190.95 28.282 35,985.05 135-60150-010-000 Wholesale Water 2,998,802.00 2,998,802.00 217,924.68 217,924.68 7.267 2,780,877.32 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 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 16:15 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 245,099.80 250,502.22 6.557 3,569,865.78 135-65005-010-000 Fuel & Lube 33,011.00 33,011.00 511.78 1.550 32,499.22 135-65010-010-000 Uniforms 4,608.00 4,608.00 1,158.49 1,158.49 25.141 3,449.51 135-65030-010-000 Chemicals 20,000.00 20,000.00 635.64 2,591.93 12.960 17,408.07 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 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 1,794.13 12,328.46 4.810 243,990.54 135-69005-010-000 Capital Outlays 502,421.00 502,421.00 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 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 118,775.00 80,986.69 80,986.69 68.185 37,788.31 Subtotal: 696,196.00 696,196.00 155,986.69 227,317.29 32.651 468,878.71 135-70040-010-000 Bond Related Expenses 4,635.00- Subtotal: 4,635.00- Program number: 5,326,780.00 5,326,780.00 456,127.23 565,941.46 10.624 4,760,838.54 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 16:15 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 11/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 80.00 80.00 1.600 4,920.00 Subtotal: 5,000.00 5,000.00 80.00 80.00 1.600 4,920.00 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 80.00 80.00 .800 9,920.00 Department number: Water 5,336,780.00 5,336,780.00 456,207.23 566,021.46 10.606 4,770,758.54 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 16:15 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 29,474.69 44,309.55 11.329 346,792.45 135-50010-020-000 Overtime 29,500.00 29,500.00 2,188.94 3,315.72 11.240 26,184.28 135-50016-020-000 Longevity 6,635.00 6,635.00 6,635.00 6,635.00 100.000 135-50017-020-000 Certification 7,800.00 7,800.00 625.00 1,250.00 16.026 6,550.00 135-50020-020-000 Retirement 39,584.00 39,584.00 3,398.02 4,846.03 12.242 34,737.97 135-50026-020-000 Medical Insurance 73,022.00 73,022.00 5,531.97 8,309.80 11.380 64,712.20 135-50027-020-000 Dental Insurance 4,592.00 4,592.00 347.91 522.53 11.379 4,069.47 135-50028-020-000 Vision Insurance 1,031.00 1,031.00 78.05 117.22 11.370 913.78 135-50029-020-000 Life Insurance & Other 4,485.00 4,485.00 360.69 713.64 15.912 3,771.36 135-50030-020-000 Social Security Taxes 27,886.00 27,886.00 2,226.91 3,162.55 11.341 24,723.45 135-50035-020-000 Medicare Taxes 6,522.00 6,522.00 520.81 739.63 11.341 5,782.37 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 1,853.50 1,853.50 16.335 9,493.50 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 650.00 650.00 120.65 120.65 18.562 529.35 Subtotal: 605,653.00 605,653.00 53,362.14 75,895.82 12.531 529,757.18 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 30.910 13,818.00 135-55080-020-000 Maintenance & Repairs 83,100.00 83,100.00 5,311.83 6,185.03 7.443 76,914.97 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 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 4,551.59 8,100.59 14.728 46,899.41 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 2,748.00 4,436.00 17.744 20,564.00 Subtotal: 277,600.00 277,600.00 12,611.42 25,719.49 9.265 251,880.51 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 469.35 469.35 8.692 4,930.65 135-60020-020-000 Electricity 158,627.00 158,627.00 11,781.26 15,168.65 9.562 143,458.35 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 47.60 82.20 14.945 467.80 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 48.04 83.89 5.243 1,516.11 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60125-020-000 Advertising 4,086.37 4,086.37 4,086.37- 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 22.95 9,910.97 57.790 7,239.03 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 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 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 16:15 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60333-020-000 Interfund Transfer Out-Reserve 123,492.00 123,492.00 123,492.00 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 16,455.57 30,391.43 2.421 1,225,073.57 135-65005-020-000 Fuel & Lube 28,088.00 28,088.00 392.56 1.398 27,695.44 135-65010-020-000 Uniforms 4,459.00 4,459.00 301.98 3,378.92 75.778 1,080.08 135-65030-020-000 Chemicals 25,000.00 25,000.00 7,228.57 9,777.29 39.109 15,222.71 135-65035-020-000 Small Tools 2,000.00 2,000.00 782.54 39.127 1,217.46 135-65040-020-000 Safety Equipment 750.00 750.00 49.83 49.83 6.644 700.17 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 1,535.35 1,751.47 12.511 12,248.53 Subtotal: 74,297.00 74,297.00 9,115.73 16,132.61 21.714 58,164.39 135-69005-020-000 Capital Outlays 485,000.00 485,000.00 14,827.55 3.057 470,172.45 Subtotal: 485,000.00 485,000.00 14,827.55 3.057 470,172.45 Program number: 2,698,015.00 2,698,015.00 91,544.86 162,966.90 6.040 2,535,048.10 Department number: Wastewater 2,698,015.00 2,698,015.00 91,544.86 162,966.90 6.040 2,535,048.10 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 16:15 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/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 5.22 5.22 16.313 26.78 Subtotal: 32.00 32.00 5.22 5.22 16.313 26.78 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 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 8.755 11,725.00 Program number: 12,882.00 12,882.00 5.22 1,130.22 8.774 11,751.78 Department number: Board of Directors 12,882.00 12,882.00 5.22 1,130.22 8.774 11,751.78 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 16:15 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 24,233.92 38,562.48 7.418 481,320.52 135-50010-030-000 Overtime 1,000.00 1,000.00 117.63 300.43 30.043 699.57 135-50016-030-000 Longevity 3,890.00 3,890.00 3,417.50 3,417.50 87.853 472.50 135-50020-030-000 Retirement 47,768.00 47,768.00 2,390.72 3,453.65 7.230 44,314.35 135-50026-030-000 Medical Insurance 84,289.00 84,289.00 3,382.41 5,073.60 6.019 79,215.40 135-50027-030-000 Dental Insurance 5,981.00 5,981.00 240.77 361.15 6.038 5,619.85 135-50028-030-000 Vision Insurance 1,312.00 1,312.00 53.98 80.95 6.170 1,231.05 135-50029-030-000 Life Insurance & Other 5,890.00 5,890.00 281.10 409.28 6.949 5,480.72 135-50030-030-000 Social Security Taxes 32,777.00 32,777.00 1,622.54 2,342.72 7.147 30,434.28 135-50035-030-000 Medicare Taxes 8,084.00 8,084.00 379.47 547.90 6.778 7,536.10 135-50040-030-000 Unemployment Taxes 1,368.00 1,368.00 6.16 25.06 1.832 1,342.94 135-50045-030-000 Workman's Compensation 1,784.00 1,784.00 291.06 291.06 16.315 1,492.94 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 76.00 76.00 15.200 424.00 135-50070-030-000 Employee Relations 4,960.00 4,960.00 916.23 916.23 18.472 4,043.77 Subtotal: 719,486.00 719,486.00 37,409.49 55,858.01 7.764 663,627.99 135-55030-030-000 Software & Support 67,791.00 67,791.00 2,979.53 4,519.78 6.667 63,271.22 135-55070-030-000 Independent Labor 12,000.00 12,000.00 41.25 41.25 .344 11,958.75 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 2,911.90 3,042.79 43.468 3,957.21 135-55120-030-000 Cleaning Services 10,429.00 10,429.00 869.06 610.06 5.850 9,818.94 135-55160-030-000 Professional Outside Services 63,325.00 63,325.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 605.30 605.30 7.382 7,594.70 Subtotal: 185,945.00 185,945.00 7,407.04 66,151.18 35.576 119,793.82 135-60005-030-000 Telephone 17,532.00 17,532.00 1,054.98 2,090.92 11.926 15,441.08 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 187.99 337.99 8.144 3,812.01 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 6.351 1,404.74 135-60035-030-000 Postage 28,932.00 28,932.00 1,799.56 3,212.17 11.102 25,719.83 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,279.19 8,936.70 16.085 46,623.30 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 9,329.12 9,329.12 16.751 46,362.88 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 100.00 100.00 1.667 5,900.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 44.28 95.85 1.775 5,304.15 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 16:15 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 319.75 619.75 8.263 6,880.25 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 1,040.00 1,040.00 41.600 1,460.00 Subtotal: 246,041.00 246,041.00 18,154.87 25,857.76 10.510 220,183.24 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 698.53 892.73 9.919 8,107.27 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 441.33 573.25 11.465 4,426.75 135-65105-030-000 Printing 4,800.00 4,800.00 103.50 103.50 2.156 4,696.50 Subtotal: 32,099.00 32,099.00 1,243.36 1,569.48 4.889 30,529.52 135-69005-030-000 Capital Outlays 107,001.00 107,001.00 3,395.00 4,522.92 4.227 102,478.08 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 344.54 509.54 11.077 4,090.46 Subtotal: 111,601.00 111,601.00 3,739.54 5,032.46 4.509 106,568.54 Program number: 1,295,172.00 1,295,172.00 67,954.30 154,468.89 11.927 1,140,703.11 Department number: Administration 1,295,172.00 1,295,172.00 67,954.30 154,468.89 11.927 1,140,703.11 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 16:15 12/14/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/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 .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 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 1.531 185,885.16 Program number: 188,775.00 188,775.00 2,889.84 1.531 185,885.16 Department number: Non Departmental 188,775.00 188,775.00 2,889.84 1.531 185,885.16 Expenditures Subtotal ----------- 9,531,624.00 9,531,624.00 615,711.61 887,477.31 9.311 8,644,146.69 Fund number: 135 MUD 1 General Fund 13,456.00- 13,456.00- 97,440.49- 472,148.84- 3,508.835 458,692.84 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 16:15 12/14/16 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 11/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00- 156,420.00 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00- 156,420.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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 396 11/01/2016 Property Taxes (309.58) (132.61) (442.19) GL 397 11/02/2016 Property Taxes (6.83) (449.02) GL 398 11/03/2016 Property Taxes (42.95) (491.97) GL 399 11/04/2016 Property Taxes (293.54) (785.51) GL 400 11/07/2016 Property Taxes (201.04) (986.55) GL 402 11/08/2016 Property Taxes (92.91) (1,079.46) GL 403 11/09/2016 Property Taxes (34.82) (1,114.28) GL 404 11/10/2016 Property Taxes (133.89) (1,248.17) GL 405 11/15/2016 Property Taxes (.12) (1,248.29) GL 406 11/16/2016 Property Taxes (220.64) (1,468.93) GL 407 11/17/2016 Property Taxes (154.05) (1,622.98) GL 408 11/18/2016 Property Taxes (185.55) (1,808.53) GL 409 11/21/2016 Property Taxes (94.51) (1,903.04) GL 410 11/22/2016 Property Taxes (82.50) (1,985.54) GL 411 11/23/2016 Property Taxes (80.77) (2,066.31) GL 412 11/28/2016 Property Taxes (234.62) (2,300.93) GL 413 11/29/2016 Property Taxes (299.42) (2,600.35) GL 414 11/30/2016 Property Taxes (2.17) (2,602.52) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (2,292.94) (2,602.52) ** (60,977.00) Budgeted (58,374.48) Remaining 4 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 396 11/01/2016 Property Taxes (56.11) (1.35) (57.46) GL 403 11/09/2016 Property Taxes 1.18 (56.28) GL 405 11/15/2016 Property Taxes (1.59) (57.87) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (1.76) (57.87) ** .00 Budgeted 57.87 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 396 11/01/2016 Property Taxes (18.30) (.41) (18.71) GL 398 11/03/2016 Property Taxes (.06) (18.77) GL 402 11/08/2016 Property Taxes (.10) (18.87) GL 405 11/15/2016 Property Taxes (.39) (19.26) GL 455 11/30/2016 Bank Rec Adjustment (19.94) (39.20) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (20.90) (39.20) ** (650.00) Budgeted (610.80) Remaining 6 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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-40025-000-000 PID Surcharges .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 344 11/03/2016 ub 11/03/16 Adjustment UB20161103-20161103 User: (425,128.37) 237.62 (424,890.75) UB 347 11/11/2016 11/11/2016 UB Adjustment UB20161111-20161111 User: 217.19 (424,673.56) UB 336 11/30/2016 UB 11/30/2016 Billing UB20161130-20161130 User: (468,346.85) (893,020.41) UB _______________ Account: 135-47000-000-000 Water Totals: (467,892.04) (893,020.41) ** (6,436,734.00) Budgeted (5,543,713.59) Remaining 14 % Used Account: 135-47005-000-000 Sewer 344 11/03/2016 ub 11/03/16 Adjustment UB20161103-20161103 User: (192,335.18) 35.00 (192,300.18) UB 336 11/30/2016 UB 11/30/2016 Billing UB20161130-20161130 User: (229,755.41) (422,055.59) UB _______________ Account: 135-47005-000-000 Sewer Totals: (229,720.41) (422,055.59) ** (2,629,524.00) Budgeted (2,207,468.41) Remaining 16 % Used Account: 135-47025-000-000 Penalties 349 11/18/2016 11/18/2016 UB Adjustment UB20161118-20161118 User: (13,727.13) 302.75 (13,424.38) UB 301 11/22/2016 11/22/2016 Ub Penalties UB20161122-20161122 User: (9,168.76) (22,593.14) UB 356 11/30/2016 11/30/2016 UB Adjustments UB20161130-20161130 User: 138.09 (22,455.05) UB _______________ Account: 135-47025-000-000 Penalties Totals: (8,727.92) (22,455.05) ** (119,260.00) Budgeted (96,804.95) Remaining 19 % Used Account: 135-47030-000-000 Service Charges 214 11/09/2016 UB 11/09/2016 Disconnect Fee UB20161109-20161109 User: (1,475.00) (750.00) (2,225.00) UB 345 11/10/2016 11/10/16 UB Adjustment UB20161110-20161110 User: (25.00) (2,250.00) UB 350 11/22/2016 11/22/2016 UB Adjustments UB20161122-20161122 User: (25.00) (2,275.00) UB 354 11/25/2016 11/25/2016 UB Adjustments UB20161125-20161125 User: (25.00) (2,300.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (825.00) (2,300.00) ** (11,400.00) Budgeted (9,100.00) Remaining 20 % Used Account: 135-47035-000-000 Plumbing Inspections . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 243 11/11/2016 Permits 20160006, 20160007 410 Skyline (350.00) (50.00) (400.00) First Texas Homes CR 243 11/11/2016 Permits 20160006, 20160007 500 Crescent Court #350 (50.00) (450.00) First Texas Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (450.00) ** (2,000.00) Budgeted (1,550.00) Remaining 23 % Used Account: 135-47045-000-000 Sewer Inspections 243 11/11/2016 Permits 20160006, 20160007 410 Skyline (300.00) (150.00) (450.00) First Texas Homes CR 243 11/11/2016 Permits 20160006, 20160007 500 Crescent Court #350 (150.00) (600.00) First Texas Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (600.00) ** (5,500.00) Budgeted (4,900.00) Remaining 11 % Used Account: 135-47070-000-000 TCCC Effluent Charges 336 11/30/2016 UB 11/30/2016 Billing UB20161130-20161130 User: (5,539.50) (712.50) (6,252.00) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (712.50) (6,252.00) ** (61,188.00) Budgeted (54,936.00) Remaining 10 % Used Account: 135-49010-000-000 Interest Income 424 11/30/2016 Nov Bank Interest (938.96) (146.36) (1,085.32) GL 424 11/30/2016 Nov Bank Interest (221.07) (1,306.39) GL 424 11/30/2016 Nov Bank Interest (556.64) (1,863.03) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (924.07) (1,863.03) ** (8,001.00) Budgeted (6,137.97) Remaining 23 % Used Account: 135-49016-000-000 Cell Tower Revenue 313 11/09/2016 AT&T Cell Tower Revenue (910.53) (910.53) (1,821.06) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (1,821.06) ** (10,926.00) Budgeted (9,104.94) Remaining 17 % Used Account: 135-49018-000-000 Building Rent Income (583.33) .00 (583.33) _______________ Account: 135-49018-000-000 Building Rent Income Totals: .00 (583.33) ** (7,000.00) Budgeted (6,416.67) Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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-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 243 11/11/2016 Permits 20160006, 20160007 410 Skyline (2,783.00) (343.00) (3,126.00) First Texas Homes CR 243 11/11/2016 Permits 20160006, 20160007 500 Crescent Court #350 (343.00) (3,469.00) First Texas Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (686.00) (3,469.00) ** (21,609.00) Budgeted (18,140.00) Remaining 16 % Used Account: 135-49900-000-000 Miscellaneous Income 336 11/30/2016 UB 11/30/2016 Billing UB20161130-20161130 User: (2,019.06) (38.03) (2,057.09) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (38.03) (2,057.09) ** (20,000.00) Budgeted (17,942.91) 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: ----------------------------------- (1,359,626.15) ** (713,152.10) Monthly Total (9,545,080.00) Budgeted (8,185,453.85) Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 149 11/04/2016 MUD P/R 11/4/16 Salaries & Wages 9,211.93 9,001.94 18,213.87 PR 255 11/18/2016 MUD Payroll 11/18/16 Salaries & Wages 9,034.21 27,248.08 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 18,036.15 27,248.08 ** 271,143.00 Budgeted 243,894.92 Remaining 10 % Used Account: 135-50010-010-000 Overtime 149 11/04/2016 MUD P/R 11/4/16 Overtime 718.32 448.12 1,166.44 PR 255 11/18/2016 MUD Payroll 11/18/16 Overtime 624.11 1,790.55 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,072.23 1,790.55 ** 19,500.00 Budgeted 17,709.45 Remaining 9 % Used Account: 135-50016-010-000 Longevity 257 11/23/2016 Longevity Longevity 3,270.00 3,270.00 PR _______________ Account: 135-50016-010-000 Longevity Totals: 3,270.00 3,270.00 ** 3,270.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 255 11/18/2016 MUD Payroll 11/18/16 Certification 225.00 225.00 450.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 225.00 450.00 ** 4,800.00 Budgeted 4,350.00 Remaining 9 % Used Account: 135-50020-010-000 Retirement 149 11/04/2016 MUD P/R 11/4/16 Retirement 886.57 824.99 1,711.56 PR 255 11/18/2016 MUD Payroll 11/18/16 Retirement 862.80 2,574.36 PR 257 11/23/2016 Longevity Retirement 285.47 2,859.83 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,973.26 2,859.83 ** 27,151.00 Budgeted 24,291.17 Remaining 11 % Used Account: 135-50026-010-000 Medical Insurance 149 11/04/2016 MUD P/R 11/4/16 Medical Insurance 1,597.56 1,580.60 3,178.16 PR 255 11/18/2016 MUD Payroll 11/18/16 Medical Insurance 1,580.55 4,758.71 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-50026-010-000 Medical Insurance Totals: 3,161.15 4,758.71 ** 55,914.00 Budgeted 51,155.29 Remaining 9 % Used Account: 135-50027-010-000 Dental Insurance 149 11/04/2016 MUD P/R 11/4/16 Dental Insurance 121.36 120.39 241.75 PR 255 11/18/2016 MUD Payroll 11/18/16 Dental Insurance 120.38 362.13 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 240.77 362.13 ** 4,159.00 Budgeted 3,796.87 Remaining 9 % Used Account: 135-50028-010-000 Vision Insurance 149 11/04/2016 MUD P/R 11/4/16 Vision Insurance 27.21 27.01 54.22 PR 255 11/18/2016 MUD Payroll 11/18/16 Vision Insurance 26.97 81.19 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.98 81.19 ** 910.00 Budgeted 828.81 Remaining 9 % Used Account: 135-50029-010-000 Life Insurance & Other 143 11/01/2016 November AP November Metlife 200.95 215.96 416.91 METLIFE GROUP BENEFITS 2501 AP 306 11/23/2016 November AP Café 125 Admin Fees 9.71 426.62 BenefitMall 2560 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 225.67 426.62 ** 2,803.00 Budgeted 2,376.38 Remaining 15 % Used Account: 135-50030-010-000 Social Security Taxes 149 11/04/2016 MUD P/R 11/4/16 Social Security Taxes 626.75 595.37 1,222.12 PR 255 11/18/2016 MUD Payroll 11/18/16 Social Security Taxes 605.75 1,827.87 PR 257 11/23/2016 Longevity Social Security Taxes 202.74 2,030.61 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,403.86 2,030.61 ** 19,021.00 Budgeted 16,990.39 Remaining 11 % Used Account: 135-50035-010-000 Medicare Taxes 149 11/04/2016 MUD P/R 11/4/16 Medicare Taxes 146.59 139.24 285.83 PR 255 11/18/2016 MUD Payroll 11/18/16 Medicare Taxes 141.66 427.49 PR 257 11/23/2016 Longevity Medicare Taxes 47.42 474.91 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 Totals: 328.32 474.91 ** 4,448.00 Budgeted 3,973.09 Remaining 11 % 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 460 11/01/2016 Insurance/Wrk Comp Exp Oct 1,074.16 1,074.16 GL 461 11/01/2016 Insurance/Wrk Comp Exp Nov 1,074.16 2,148.32 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 2,148.32 2,148.32 ** 13,152.00 Budgeted 11,003.68 Remaining 16 % 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 306 11/23/2016 November AP Swift funding water line 12,615.00 12,615.00 CP&Y/WALLACE GROUP, INC. 2569 AP _______________ Account: 135-55005-010-000 Engineering Totals: 12,615.00 12,615.00 ** 5,000.00 Budgeted (7,615.00) Remaining 252 % Used Account: 135-55080-010-000 Maintenance & Repairs 306 11/23/2016 November AP Meter boxes/lids 3,734.24 2,059.92 5,794.16 HD SUPPLY WATERWORKS, LTD. 2586 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 306 11/23/2016 November AP Angle stop, valve riers 3,734.24 1,854.50 7,648.66 HD SUPPLY WATERWORKS, LTD. 2586 AP 372 11/28/2016 Nov A/P THE HOME DEPOT #6581 114.92 7,763.58 THE HOME DEPOT #6581 PC 372 11/28/2016 Nov A/P THE HOME DEPOT #6581 265.56 8,029.14 THE HOME DEPOT #6581 PC 337 11/30/2016 November A/P Water Line repair 7,209.54 15,238.68 REY-MAR CONSTRUCTION 2618 AP 337 11/30/2016 November A/P Meter boxes and lids 1,362.96 16,601.64 HD SUPPLY WATERWORKS, LTD. 2586 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 12,867.40 16,601.64 ** 100,000.00 Budgeted 83,398.36 Remaining 17 % 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 372 11/28/2016 Nov A/P TX.GOV SERVICEFEE 2.00 2.00 TX.GOV SERVICEFEE PC 372 11/28/2016 Nov A/P DENTON VEHREG 8.50 10.50 DENTON VEHREG PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 10.50 10.50 ** 8,000.00 Budgeted 7,989.50 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 306 11/23/2016 November AP Water Samples-MUD 415.40 250.00 665.40 TARRANT CTY PUBLIC HEALTH LAB 2627 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 250.00 665.40 ** 5,500.00 Budgeted 4,834.60 Remaining 12 % Used Account: 135-60010-010-000 Communications/Mobiles 306 11/23/2016 November AP October Cellphones 365.59 365.59 VERIZON WIRELESS 2635 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 365.59 365.59 ** 5,400.00 Budgeted 5,034.41 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 306 11/23/2016 November AP Electricity 10/10-11/8/16 4,387.42 12,494.12 16,881.54 HUDSON ENERGY SERVICES, LLC 2588 AP _______________ Account: 135-60020-010-000 Electricity Totals: 12,494.12 16,881.54 ** 172,737.00 Budgeted 155,855.46 Remaining 10 % 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 265.00 .00 265.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .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 149 11/04/2016 MUD P/R 11/4/16 Travel & per diem 124.46 124.46 PR _______________ Account: 135-60100-010-000 Travel & per diem Totals: 124.46 124.46 ** 1,500.00 Budgeted 1,375.54 Remaining 8 % Used Account: 135-60105-010-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 306 11/23/2016 November AP Well Water 6,505.30 6,505.30 North Texas Groundwater 2611 AP 306 11/23/2016 November AP TCEQ Water System Fee 7,685.65 14,190.95 TX COMMISSION ENVIRONMENTAL QU 2631 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 14,190.95 14,190.95 ** 50,176.00 Budgeted 35,985.05 Remaining 28 % Used Account: 135-60150-010-000 Wholesale Water 337 11/30/2016 November A/P Wholesale water-October 2016 217,924.68 217,924.68 CITY OF FORT WORTH 2566 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 217,924.68 217,924.68 ** 2,998,802.00 Budgeted 2,780,877.32 Remaining 7 % 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 750.00 .00 750.00 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-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 511.78 .00 511.78 _______________ Account: 135-65005-010-000 Fuel & Lube Totals: .00 511.78 ** 33,011.00 Budgeted 32,499.22 Remaining 2 % Used Account: 135-65010-010-000 Uniforms 372 11/28/2016 Nov A/P RED WING SHOES #652 170.99 170.99 RED WING SHOES #652 PC 372 11/28/2016 Nov A/P RED WING SHOES #652 170.99 341.98 RED WING SHOES #652 PC 372 11/28/2016 Nov A/P RED WING SHOES #652 112.49 454.47 RED WING SHOES #652 PC 372 11/28/2016 Nov A/P RED WING SHOES #652 174.24 628.71 RED WING SHOES #652 PC 372 11/28/2016 Nov A/P TRACTOR SUPPLY COMPANY 529.78 1,158.49 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-65010-010-000 Uniforms Totals: 1,158.49 1,158.49 ** 4,608.00 Budgeted 3,449.51 Remaining 25 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-65030-010-000 Chemicals 306 11/23/2016 November AP Chlorine 1,956.29 635.64 2,591.93 DPC INDUSTRIES, INC 2573 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 635.64 2,591.93 ** 20,000.00 Budgeted 17,408.07 Remaining 13 % 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 8,066.26 .00 8,066.26 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 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 71,330.60 .00 71,330.60 _______________ Account: 135-69005-010-000 Capital Outlays Totals: .00 71,330.60 ** 502,421.00 Budgeted 431,090.40 Remaining 14 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 307 11/25/2016 GASB 34 transfers Fiscal 2017 Town Elevated Tank 45,000.00 45,000.00 GL 307 11/25/2016 GASB 34 transfers Fiscal 2017 Water Replacement 30,000.00 75,000.00 GL _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 143 11/01/2016 November AP Water Plant tank inspection 45,775.00 45,775.00 UTILITY SERVICE CO, INC. 2515 AP 143 11/01/2016 November AP Water tank inspections-Elevate 35,211.69 80,986.69 UTILITY SERVICE CO, INC. 2515 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 80,986.69 80,986.69 ** 118,775.00 Budgeted 37,788.31 Remaining 68 % Used Account: 135-70040-010-000 Bond Related Expenses 439 11/16/2016 SWIFT AG Fee Reimbursed 4,635.00 (4,635.00) .00 GL _______________ Account: 135-70040-010-000 Bond Related Expenses Totals: (4,635.00) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-55135-010-001 Lab Analysis for PID 306 11/23/2016 November AP Water Samples-PID 80.00 80.00 TARRANT CTY PUBLIC HEALTH LAB 2627 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 80.00 ** 5,000.00 Budgeted 4,920.00 Remaining 2 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ----------------------------------- 566,021.46 ** 456,207.23 Monthly Total 5,336,780.00 Budgeted 4,770,758.54 Remaining 11 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 149 11/04/2016 MUD P/R 11/4/16 Salaries & Wages 14,834.86 14,710.07 29,544.93 PR 255 11/18/2016 MUD Payroll 11/18/16 Salaries & Wages 14,764.62 44,309.55 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 29,474.69 44,309.55 ** 391,102.00 Budgeted 346,792.45 Remaining 11 % Used Account: 135-50010-020-000 Overtime 149 11/04/2016 MUD P/R 11/4/16 Overtime 1,126.78 1,229.46 2,356.24 PR 255 11/18/2016 MUD Payroll 11/18/16 Overtime 959.48 3,315.72 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,188.94 3,315.72 ** 29,500.00 Budgeted 26,184.28 Remaining 11 % Used Account: 135-50016-020-000 Longevity 257 11/23/2016 Longevity Longevity 6,635.00 6,635.00 PR _______________ Account: 135-50016-020-000 Longevity Totals: 6,635.00 6,635.00 ** 6,635.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 255 11/18/2016 MUD Payroll 11/18/16 Certification 625.00 625.00 1,250.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 625.00 1,250.00 ** 7,800.00 Budgeted 6,550.00 Remaining 16 % Used Account: 135-50020-020-000 Retirement 149 11/04/2016 MUD P/R 11/4/16 Retirement 1,448.01 1,391.51 2,839.52 PR 255 11/18/2016 MUD Payroll 11/18/16 Retirement 1,427.27 4,266.79 PR 257 11/23/2016 Longevity Retirement 579.24 4,846.03 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,398.02 4,846.03 ** 39,584.00 Budgeted 34,737.97 Remaining 12 % Used Account: 135-50026-020-000 Medical Insurance 149 11/04/2016 MUD P/R 11/4/16 Medical Insurance 2,777.83 2,765.99 5,543.82 PR 255 11/18/2016 MUD Payroll 11/18/16 Medical Insurance 2,765.98 8,309.80 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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-50026-020-000 Medical Insurance Totals: 5,531.97 8,309.80 ** 73,022.00 Budgeted 64,712.20 Remaining 11 % Used Account: 135-50027-020-000 Dental Insurance 149 11/04/2016 MUD P/R 11/4/16 Dental Insurance 174.62 173.97 348.59 PR 255 11/18/2016 MUD Payroll 11/18/16 Dental Insurance 173.94 522.53 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 347.91 522.53 ** 4,592.00 Budgeted 4,069.47 Remaining 11 % Used Account: 135-50028-020-000 Vision Insurance 149 11/04/2016 MUD P/R 11/4/16 Vision Insurance 39.17 39.05 78.22 PR 255 11/18/2016 MUD Payroll 11/18/16 Vision Insurance 39.00 117.22 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 78.05 117.22 ** 1,031.00 Budgeted 913.78 Remaining 11 % Used Account: 135-50029-020-000 Life Insurance & Other 143 11/01/2016 November AP November Metlife 352.95 333.56 686.51 METLIFE GROUP BENEFITS 2501 AP 306 11/23/2016 November AP Café 125 Admin Fees 27.13 713.64 BenefitMall 2560 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 360.69 713.64 ** 4,485.00 Budgeted 3,771.36 Remaining 16 % Used Account: 135-50030-020-000 Social Security Taxes 149 11/04/2016 MUD P/R 11/4/16 Social Security Taxes 935.64 910.36 1,846.00 PR 255 11/18/2016 MUD Payroll 11/18/16 Social Security Taxes 905.19 2,751.19 PR 257 11/23/2016 Longevity Social Security Taxes 411.36 3,162.55 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,226.91 3,162.55 ** 27,886.00 Budgeted 24,723.45 Remaining 11 % Used Account: 135-50035-020-000 Medicare Taxes 149 11/04/2016 MUD P/R 11/4/16 Medicare Taxes 218.82 212.90 431.72 PR 255 11/18/2016 MUD Payroll 11/18/16 Medicare Taxes 211.70 643.42 PR 257 11/23/2016 Longevity Medicare Taxes 96.21 739.63 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 Totals: 520.81 739.63 ** 6,522.00 Budgeted 5,782.37 Remaining 11 % 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 460 11/01/2016 Insurance/Wrk Comp Exp Oct 926.75 926.75 GL 461 11/01/2016 Insurance/Wrk Comp Exp Nov 926.75 1,853.50 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,853.50 1,853.50 ** 11,347.00 Budgeted 9,493.50 Remaining 16 % 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 372 11/28/2016 Nov A/P MR JIMS PIZZA - ROANOK 70.92 70.92 MR JIMS PIZZA - ROANOK PC 372 11/28/2016 Nov A/P ON THE BORDER 49.73 120.65 ON THE BORDER PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 120.65 120.65 ** 650.00 Budgeted 529.35 Remaining 19 % 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 Account: 135-55070-020-000 Independent Labor . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 6,182.00 .00 6,182.00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 6,182.00 ** 20,000.00 Budgeted 13,818.00 Remaining 31 % Used Account: 135-55080-020-000 Maintenance & Repairs 372 11/28/2016 Nov A/P THE HOME DEPOT #6581 873.20 86.55 959.75 THE HOME DEPOT #6581 PC 372 11/28/2016 Nov A/P LESLIES POOLMART 80.34 1,040.09 LESLIES POOLMART PC 372 11/28/2016 Nov A/P THE HOME DEPOT #6581 171.00 1,211.09 THE HOME DEPOT #6581 PC 372 11/28/2016 Nov A/P WW GRAINGER 167.66 1,378.75 WW GRAINGER PC 372 11/28/2016 Nov A/P THE HOME DEPOT #6581 96.86 1,475.61 THE HOME DEPOT #6581 PC 372 11/28/2016 Nov A/P LOWES #00732* 301.92 1,777.53 LOWES #00732* PC 337 11/30/2016 November A/P Pump #1-LS #20 1,350.00 3,127.53 NORTH TEXAS PUMP CO. 2612 AP 337 11/30/2016 November A/P pump LS #8 405.00 3,532.53 XYLEM WATER SOLUTIONS USA INC 2638 AP 337 11/30/2016 November A/P Repairs-belt press control pan 1,302.50 4,835.03 WALKER ENGINEERING INC 2636 AP 337 11/30/2016 November A/P Repairs-Blower controls 1,350.00 6,185.03 WALKER ENGINEERING INC 2636 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 5,311.83 6,185.03 ** 83,100.00 Budgeted 76,914.97 Remaining 7 % 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 815.87 .00 815.87 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 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 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 337 11/30/2016 November A/P Sludge Haul Off 3,549.00 845.00 4,394.00 L.H. CHANEY MATERIALS, INC. 2594 AP 337 11/30/2016 November A/P Sludge Haul Off 1,953.22 6,347.22 L.H. CHANEY MATERIALS, INC. 2594 AP 337 11/30/2016 November A/P Sludge Haul Off 982.31 7,329.53 L.H. CHANEY MATERIALS, INC. 2594 AP 337 11/30/2016 November A/P Sludge Haul Off 771.06 8,100.59 L.H. CHANEY MATERIALS, INC. 2594 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 4,551.59 8,100.59 ** 55,000.00 Budgeted 46,899.41 Remaining 15 % Used Account: 135-55135-020-000 Lab Analysis 337 11/30/2016 November A/P Testing supplies 1,688.00 246.00 1,934.00 OXIDOR LABORATORIES LLC 2615 AP 337 11/30/2016 November A/P Testing supplies 176.00 2,110.00 OXIDOR LABORATORIES LLC 2615 AP 337 11/30/2016 November A/P Testing supplies 246.00 2,356.00 OXIDOR LABORATORIES LLC 2615 AP 337 11/30/2016 November A/P Testing supplies 176.00 2,532.00 OXIDOR LABORATORIES LLC 2615 AP 337 11/30/2016 November A/P Testing supplies 226.00 2,758.00 OXIDOR LABORATORIES LLC 2615 AP 337 11/30/2016 November A/P Testing supplies 176.00 2,934.00 OXIDOR LABORATORIES LLC 2615 AP 337 11/30/2016 November A/P Testing supplies 246.00 3,180.00 OXIDOR LABORATORIES LLC 2615 AP 337 11/30/2016 November A/P Testing supplies 176.00 3,356.00 OXIDOR LABORATORIES LLC 2615 AP 337 11/30/2016 November A/P Bio Monitoring 1,080.00 4,436.00 HUTHER AND ASSOCIATES,INC 2589 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,748.00 4,436.00 ** 25,000.00 Budgeted 20,564.00 Remaining 18 % Used Account: 135-60010-020-000 Communications/Mobiles 306 11/23/2016 November AP October Cellphones 459.59 459.59 VERIZON WIRELESS 2635 AP 372 11/28/2016 Nov A/P WAL-MART #5247 9.76 469.35 WAL-MART #5247 PC _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 469.35 469.35 ** 5,400.00 Budgeted 4,930.65 Remaining 9 % Used Account: 135-60020-020-000 Electricity 306 11/23/2016 November AP Electricity 10/10-11/8/16 3,387.39 405.62 3,793.01 ENGIE Resources LLC 2577 AP 306 11/23/2016 November AP Electricity 926-10/25/16 236.81 4,029.82 TRI COUNTY ELECTRIC 2628 AP 306 11/23/2016 November AP Electricity 9/26-10/25/16 267.45 4,297.27 TRI COUNTY ELECTRIC 2628 AP 306 11/23/2016 November AP Electricity 9/26-10/25/16 27.44 4,324.71 TRI COUNTY ELECTRIC 2628 AP 306 11/23/2016 November AP Electricity 10/10-11/8/16 516.57 4,841.28 HUDSON ENERGY SERVICES, LLC 2588 AP 306 11/23/2016 November AP Electricity 10/10-11/7/16 9,265.81 14,107.09 HUDSON ENERGY SERVICES, LLC 2588 AP 337 11/30/2016 November A/P Electricity 10/10-11/8/16 308.36 14,415.45 MP2 ENERGY TEXAS LLC 2609 AP 337 11/30/2016 November A/P Electricity 10/7-11/7-16 73.29 14,488.74 HUDSON ENERGY SERVICES, LLC 2588 AP 337 11/30/2016 November A/P Electricity 10/10-11/8/16 93.89 14,582.63 HUDSON ENERGY SERVICES, LLC 2588 AP 417 11/30/2016 Nov A/P Electricity 10/25-11/28/16 225.70 14,808.33 TRI COUNTY ELECTRIC 2642 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 417 11/30/2016 Nov A/P Electricity 10/25-11/28/16 3,387.39 29.05 14,837.38 TRI COUNTY ELECTRIC 2642 AP 417 11/30/2016 Nov A/P Electricity 10/25-11/28/16 331.27 15,168.65 TRI COUNTY ELECTRIC 2642 AP _______________ Account: 135-60020-020-000 Electricity Totals: 11,781.26 15,168.65 ** 158,627.00 Budgeted 143,458.35 Remaining 10 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 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 372 11/28/2016 Nov A/P SALAD BOWL 10 34.60 47.60 82.20 SALAD BOWL 10 PC _______________ Account: 135-60090-020-000 Safety Program Totals: 47.60 82.20 ** 550.00 Budgeted 467.80 Remaining 15 % Used Account: 135-60100-020-000 Travel & per diem 337 11/30/2016 November A/P tolls-samples to the lab 35.85 14.65 50.50 NTTA 2613 AP 337 11/30/2016 November A/P tolls-samples to the lab 33.39 83.89 NTTA 2613 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 48.04 83.89 ** 1,600.00 Budgeted 1,516.11 Remaining 5 % Used Account: 135-60105-020-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising 306 11/23/2016 November AP TCEQ Public Meeting 2,024.29 2,024.29 STAR-TELEGRAM OPERATING LTD 2622 AP 306 11/23/2016 November AP TCEQ Public Meeting 2,062.08 4,086.37 STAR-TELEGRAM OPERATING LTD 2622 AP _______________ Account: 135-60125-020-000 Advertising Totals: 4,086.37 4,086.37 ** .00 Budgeted (4,086.37) Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 372 11/28/2016 Nov A/P USPS PO 4876450662 9,888.02 22.95 9,910.97 USPS PO 4876450662 PC _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 22.95 9,910.97 ** 17,150.00 Budgeted 7,239.03 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 590.00 .00 590.00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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-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 _______________ 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 392.56 .00 392.56 _______________ Account: 135-65005-020-000 Fuel & Lube Totals: .00 392.56 ** 28,088.00 Budgeted 27,695.44 Remaining 1 % Used Account: 135-65010-020-000 Uniforms 372 11/28/2016 Nov A/P TRACTOR SUPPLY COMPANY 3,076.94 79.98 3,156.92 TRACTOR SUPPLY COMPANY PC 337 11/30/2016 November A/P Uniforms 222.00 3,378.92 PANDA EMBROIDERY 2616 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 301.98 3,378.92 ** 4,459.00 Budgeted 1,080.08 Remaining 76 % Used Account: 135-65030-020-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 372 11/28/2016 Nov A/P Pig Poly IBC- New Pig Corp 2,548.72 1,346.57 3,895.29 NPC*NEW PIG CORP PC 337 11/30/2016 November A/P gloves 162.00 4,057.29 LOU'S GLOVES INCORPORATED 2603 AP 337 11/30/2016 November A/P Clarifloc 2,760.00 6,817.29 POLYDYNE, INC 2617 AP 337 11/30/2016 November A/P Chemicals 2,960.00 9,777.29 HARCROS CHEMICALS INC 2585 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 7,228.57 9,777.29 ** 25,000.00 Budgeted 15,222.71 Remaining 39 % Used Account: 135-65035-020-000 Small Tools 782.54 .00 782.54 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 782.54 ** 2,000.00 Budgeted 1,217.46 Remaining 39 % Used Account: 135-65040-020-000 Safety Equipment 372 11/28/2016 Nov A/P Safety Glass- Home Depot 24.97 24.97 THE HOME DEPOT #6581 PC 372 11/28/2016 Nov A/P THE HOME DEPOT #6581 24.86 49.83 THE HOME DEPOT #6581 PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 49.83 49.83 ** 750.00 Budgeted 700.17 Remaining 7 % Used Account: 135-65045-020-000 Lab Supplies 372 11/28/2016 Nov A/P THE HOME DEPOT #6581 216.12 53.58 269.70 THE HOME DEPOT #6581 PC 372 11/28/2016 Nov A/P WAL-MART #5247 1.76 271.46 WAL-MART #5247 PC 372 11/28/2016 Nov A/P RANDALLS STORE00017897 35.98 307.44 RANDALLS STORE00017897 PC 337 11/30/2016 November A/P Testing supplies 552.07 859.51 HACH COMPANY 2584 AP 337 11/30/2016 November A/P Testing supplies 493.67 1,353.18 HACH COMPANY 2584 AP 337 11/30/2016 November A/P Testing supplies 125.40 1,478.58 HACH COMPANY 2584 AP 337 11/30/2016 November A/P Sensor cap replacement 272.89 1,751.47 HACH COMPANY 2584 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,535.35 1,751.47 ** 14,000.00 Budgeted 12,248.53 Remaining 13 % Used Account: 135-69005-020-000 Capital Outlays 14,827.55 .00 14,827.55 _______________ Account: 135-69005-020-000 Capital Outlays Totals: .00 14,827.55 ** 485,000.00 Budgeted 470,172.45 Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 20 Totals: ----------------------------------- 162,966.90 ** 91,544.86 Monthly Total 2,698,015.00 Budgeted 2,535,048.10 Remaining 6 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-000 Workman's Compensation 460 11/01/2016 Insurance/Wrk Comp Exp Oct 2.61 2.61 GL 461 11/01/2016 Insurance/Wrk Comp Exp Nov 2.61 5.22 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 5.22 5.22 ** 32.00 Budgeted 26.78 Remaining 16 % 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 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 1,125.00 .00 1,125.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/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-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: ----------------------------------- 1,130.22 ** 5.22 Monthly Total 12,882.00 Budgeted 11,751.78 Remaining 9 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 149 11/04/2016 MUD P/R 11/4/16 Salaries & Wages 14,328.56 11,719.25 26,047.81 PR 255 11/18/2016 MUD Payroll 11/18/16 Salaries & Wages 12,130.67 38,178.48 PR 306 11/23/2016 November AP Temp receptionist 384.00 38,562.48 TRINITY EMPLOYMENT SOLUTIONS 2629 AP _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 24,233.92 38,562.48 ** 519,883.00 Budgeted 481,320.52 Remaining 7 % Used Account: 135-50010-030-000 Overtime 149 11/04/2016 MUD P/R 11/4/16 Overtime 182.80 50.81 233.61 PR 255 11/18/2016 MUD Payroll 11/18/16 Overtime 66.82 300.43 PR _______________ Account: 135-50010-030-000 Overtime Totals: 117.63 300.43 ** 1,000.00 Budgeted 699.57 Remaining 30 % Used Account: 135-50016-030-000 Longevity 257 11/23/2016 Longevity Longevity 3,417.50 3,417.50 PR _______________ Account: 135-50016-030-000 Longevity Totals: 3,417.50 3,417.50 ** 3,890.00 Budgeted 472.50 Remaining 88 % Used Account: 135-50020-030-000 Retirement 149 11/04/2016 MUD P/R 11/4/16 Retirement 1,062.93 1,027.52 2,090.45 PR 255 11/18/2016 MUD Payroll 11/18/16 Retirement 1,064.84 3,155.29 PR 257 11/23/2016 Longevity Retirement 298.36 3,453.65 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,390.72 3,453.65 ** 47,768.00 Budgeted 44,314.35 Remaining 7 % Used Account: 135-50026-030-000 Medical Insurance 149 11/04/2016 MUD P/R 11/4/16 Medical Insurance 1,691.19 1,691.22 3,382.41 PR 255 11/18/2016 MUD Payroll 11/18/16 Medical Insurance 1,691.19 5,073.60 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,382.41 5,073.60 ** 84,289.00 Budgeted 79,215.40 Remaining 6 % Used Account: 135-50027-030-000 Dental Insurance 149 11/04/2016 MUD P/R 11/4/16 Dental Insurance 120.38 120.39 240.77 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 255 11/18/2016 MUD Payroll 11/18/16 Dental Insurance 120.38 120.38 361.15 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 240.77 361.15 ** 5,981.00 Budgeted 5,619.85 Remaining 6 % Used Account: 135-50028-030-000 Vision Insurance 149 11/04/2016 MUD P/R 11/4/16 Vision Insurance 26.97 27.01 53.98 PR 255 11/18/2016 MUD Payroll 11/18/16 Vision Insurance 26.97 80.95 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 53.98 80.95 ** 1,312.00 Budgeted 1,231.05 Remaining 6 % Used Account: 135-50029-030-000 Life Insurance & Other 143 11/01/2016 November AP November Metlife 128.18 253.96 382.14 METLIFE GROUP BENEFITS 2501 AP 306 11/23/2016 November AP Café 125 Admin Fees 27.16 409.30 BenefitMall 2560 AP 369 11/30/2016 Nov A/P Rounding adjustment (.02) 409.28 Legal Shield 2596 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 281.10 409.28 ** 5,890.00 Budgeted 5,480.72 Remaining 7 % Used Account: 135-50030-030-000 Social Security Taxes 149 11/04/2016 MUD P/R 11/4/16 Social Security Taxes 720.18 695.55 1,415.73 PR 255 11/18/2016 MUD Payroll 11/18/16 Social Security Taxes 715.11 2,130.84 PR 257 11/23/2016 Longevity Social Security Taxes 211.88 2,342.72 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,622.54 2,342.72 ** 32,777.00 Budgeted 30,434.28 Remaining 7 % Used Account: 135-50035-030-000 Medicare Taxes 149 11/04/2016 MUD P/R 11/4/16 Medicare Taxes 168.43 162.67 331.10 PR 255 11/18/2016 MUD Payroll 11/18/16 Medicare Taxes 167.25 498.35 PR 257 11/23/2016 Longevity Medicare Taxes 49.55 547.90 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 379.47 547.90 ** 8,084.00 Budgeted 7,536.10 Remaining 7 % Used Account: 135-50040-030-000 Unemployment Taxes 255 11/18/2016 MUD Payroll 11/18/16 Unemployment Taxes 18.90 6.16 25.06 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 6.16 25.06 ** 1,368.00 Budgeted 1,342.94 Remaining 2 % Used Account: 135-50045-030-000 Workman's Compensation 460 11/01/2016 Insurance/Wrk Comp Exp Oct 145.53 145.53 GL 461 11/01/2016 Insurance/Wrk Comp Exp Nov 145.53 291.06 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 291.06 291.06 ** 1,784.00 Budgeted 1,492.94 Remaining 16 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 337 11/30/2016 November A/P Pre-employment physical-Wright 35.00 35.00 CARENOW CORPORATE 2564 AP 337 11/30/2016 November A/P Pre-employment physical-Krolcz 38.00 73.00 CARENOW CORPORATE 2564 AP 339 11/30/2016 November AP Pre-employment Physical-Wright 3.00 76.00 CARENOW CORPORATE 2564 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 76.00 76.00 ** 500.00 Budgeted 424.00 Remaining 15 % Used Account: 135-50070-030-000 Employee Relations 372 11/28/2016 Nov A/P SALAD BOWL 10 90.00 90.00 SALAD BOWL 10 PC 372 11/28/2016 Nov A/P WM SUPERCENTER #5247 11.23 101.23 WM SUPERCENTER #5247 PC 372 11/28/2016 Nov A/P RANDALLS STORE00017897 6.87 108.10 RANDALLS STORE00017897 PC 372 11/28/2016 Nov A/P DONUT HAVEN 56.92 165.02 DONUT HAVEN PC 372 11/28/2016 Nov A/P DONUT HAVEN 49.37 214.39 DONUT HAVEN PC 372 11/28/2016 Nov A/P RANDALLS STORE00017897 11.85 226.24 RANDALLS STORE00017897 PC 372 11/28/2016 Nov A/P ACADEMY SPORTS #76 100.00 326.24 ACADEMY SPORTS #76 PC 372 11/28/2016 Nov A/P TOM THUMB STOR00026096 300.00 626.24 TOM THUMB STOR00026096 PC 372 11/28/2016 Nov A/P RANDALLS STORE00017897 200.00 826.24 RANDALLS STORE00017897 PC 372 11/28/2016 Nov A/P WM SUPERCENTER #5247 50.00 876.24 WM SUPERCENTER #5247 PC 372 11/28/2016 Nov A/P CANVA.COM 20.00 896.24 CANVA.COM PC 372 11/28/2016 Nov A/P ADOBE *IL CREATIVE CLD 19.99 916.23 ADOBE *IL CREATIVE CLD PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 916.23 916.23 ** 4,960.00 Budgeted 4,043.77 Remaining 18 % Used Account: 135-55030-030-000 Software & Support 306 11/23/2016 November AP Internet 1,540.25 1,120.77 2,661.02 WHOLESALE CARRIER SERVICES INC 2637 AP 306 11/23/2016 November AP Support 1,522.56 4,183.58 STW INC 2624 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 372 11/28/2016 Nov A/P ATT*BILL PAYMENT 1,540.25 159.94 4,343.52 ATT*BILL PAYMENT PC 372 11/28/2016 Nov A/P ATT*BILL PAYMENT 176.26 4,519.78 ATT*BILL PAYMENT PC _______________ Account: 135-55030-030-000 Software & Support Totals: 2,979.53 4,519.78 ** 67,791.00 Budgeted 63,271.22 Remaining 7 % Used Account: 135-55070-030-000 Independent Labor 306 11/23/2016 November AP Record MUD Meeting 41.25 41.25 MIGUEL CRUZ 2608 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 41.25 41.25 ** 12,000.00 Budgeted 11,958.75 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 306 11/23/2016 November AP Restripe Parking lot 130.89 2,828.55 2,959.44 Sweeper King, Inc 2625 AP 372 11/28/2016 Nov A/P MICHAELS KEYS 5.85 2,965.29 MICHAELS KEYS PC 372 11/28/2016 Nov A/P MICHAELS KEYS 77.50 3,042.79 MICHAELS KEYS PC _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 2,911.90 3,042.79 ** 7,000.00 Budgeted 3,957.21 Remaining 43 % Used Account: 135-55120-030-000 Cleaning Services 306 11/23/2016 November AP Janitor Service (259.00) 869.06 610.06 MEMBER'S BUILDING MAINTENANCE 2606 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 610.06 ** 10,429.00 Budgeted 9,818.94 Remaining 6 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 57,332.00 .00 57,332.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .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 306 11/23/2016 November AP October utility billing 605.30 605.30 DATAPROSE LLC 2571 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 605.30 605.30 ** 8,200.00 Budgeted 7,594.70 Remaining 7 % Used Account: 135-60005-030-000 Telephone 177 11/05/2016 Nov A/P Answering Service 1,035.94 200.00 1,235.94 KEYSTONE PARK SECRETARIAL 2496 AP 372 11/28/2016 Nov A/P ATT*BUS PHONE PMT 844.25 2,080.19 ATT*BUS PHONE PMT PC 372 11/28/2016 Nov A/P RINGCENTRAL, INC 10.73 2,090.92 RINGCENTRAL, INC PC _______________ Account: 135-60005-030-000 Telephone Totals: 1,054.98 2,090.92 ** 17,532.00 Budgeted 15,441.08 Remaining 12 % Used Account: 135-60010-030-000 Communications/Mobiles 255 11/18/2016 MUD Payroll 11/18/16 Communications/Mobiles 150.00 150.00 300.00 PR 306 11/23/2016 November AP October Cellphones 37.99 337.99 VERIZON WIRELESS 2635 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 187.99 337.99 ** 4,150.00 Budgeted 3,812.01 Remaining 8 % Used Account: 135-60020-030-000 Electricity/Gas .00 .00 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 .00 ** 12,631.00 Budgeted 12,631.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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-60025-030-000 Water 95.26 .00 95.26 _______________ Account: 135-60025-030-000 Water Totals: .00 95.26 ** 1,500.00 Budgeted 1,404.74 Remaining 6 % Used Account: 135-60035-030-000 Postage 177 11/05/2016 Nov A/P Overnight letter 1,412.61 11.72 1,424.33 FEDERAL EXPRESS CORP 2484 AP 306 11/23/2016 November AP October utility billing 1,770.26 3,194.59 DATAPROSE LLC 2571 AP 337 11/30/2016 November A/P Overnight letters 12.03 3,206.62 FEDERAL EXPRESS CORP 2579 AP 337 11/30/2016 November A/P Overnight letter 5.55 3,212.17 FEDERAL EXPRESS CORP 2579 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,799.56 3,212.17 ** 28,932.00 Budgeted 25,719.83 Remaining 11 % Used Account: 135-60040-030-000 Service Charges & Fees 395 11/02/2016 Online payment fees 4,657.51 105.44 4,762.95 GL 395 11/02/2016 Online payment fees 4,170.75 8,933.70 GL 440 11/04/2016 Child support fee 1.50 8,935.20 GL 256 11/18/2016 Child support fee 11/18 p/r 1.50 8,936.70 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,279.19 8,936.70 ** 55,560.00 Budgeted 46,623.30 Remaining 16 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 460 11/01/2016 Insurance/Wrk Comp Exp Oct 4,664.56 4,664.56 GL 461 11/01/2016 Insurance/Wrk Comp Exp Nov 4,664.56 9,329.12 GL _______________ Account: 135-60055-030-000 Insurance Totals: 9,329.12 9,329.12 ** 55,692.00 Budgeted 46,362.88 Remaining 17 % Used Account: 135-60066-030-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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-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 306 11/23/2016 November AP Annual Membership NCTCOG 10/16 100.00 100.00 N CENTRAL TX COG 2610 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 100.00 100.00 ** 6,000.00 Budgeted 5,900.00 Remaining 2 % 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 _______________ 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 149 11/04/2016 MUD P/R 11/4/16 Travel & per diem 51.57 44.28 95.85 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 44.28 95.85 ** 5,400.00 Budgeted 5,304.15 Remaining 2 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60110-030-000 Physicals/Testing 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 306 11/23/2016 November AP Employment ad 300.00 319.75 619.75 TX WATER UTILITIES ASSOC 2632 AP _______________ Account: 135-60125-030-000 Advertising Totals: 319.75 619.75 ** 7,500.00 Budgeted 6,880.25 Remaining 8 % 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 .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 372 11/28/2016 Nov A/P PEARCE OFFICE FURNITUR 1,040.00 1,040.00 PEARCE OFFICE FURNITUR PC _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 1,040.00 1,040.00 ** 2,500.00 Budgeted 1,460.00 Remaining 42 % Used Account: 135-65010-030-000 Uniforms .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-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 306 11/23/2016 November AP Office Supplies 194.20 90.41 284.61 OFFICE DEPOT, INC 2614 AP 372 11/28/2016 Nov A/P OFFICE DEPOT #406 41.54 326.15 OFFICE DEPOT #406 PC 372 11/28/2016 Nov A/P SHI GOVERNMENT SOLUTIO 121.42 447.57 SHI GOVERNMENT SOLUTIO PC 372 11/28/2016 Nov A/P STAPLES DIRECT 78.23 525.80 STAPLES DIRECT PC 337 11/30/2016 November A/P office supplies 121.79 647.59 OFFICE DEPOT, INC 2614 AP 337 11/30/2016 November A/P Office supplies 245.14 892.73 OFFICE DEPOT, INC 2614 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 698.53 892.73 ** 9,000.00 Budgeted 8,107.27 Remaining 10 % 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 Account: 135-65095-030-000 Maintenance Supplies 372 11/28/2016 Nov A/P AMAZON MKTPLACE PMTS 131.92 96.75 228.67 AMAZON MKTPLACE PMTS PC 372 11/28/2016 Nov A/P WM SUPERCENTER #2980 15.05 243.72 WM SUPERCENTER #2980 PC 372 11/28/2016 Nov A/P AMAZON MKTPLACE PMTS 77.38 321.10 AMAZON MKTPLACE PMTS PC 372 11/28/2016 Nov A/P WAL-MART #0266 11.06 332.16 WAL-MART #0266 PC 372 11/28/2016 Nov A/P SAMS CLUB #4795 203.62 535.78 SAMS CLUB #4795 PC 372 11/28/2016 Nov A/P SAMSCLUB #4795 37.47 573.25 SAMSCLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 441.33 573.25 ** 5,000.00 Budgeted 4,426.75 Remaining 11 % Used Account: 135-65105-030-000 Printing . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 306 11/23/2016 November AP October utility billing 103.50 103.50 DATAPROSE LLC 2571 AP _______________ Account: 135-65105-030-000 Printing Totals: 103.50 103.50 ** 4,800.00 Budgeted 4,696.50 Remaining 2 % Used Account: 135-69005-030-000 Capital Outlays 306 11/23/2016 November AP Restroom renovations 1,127.92 3,395.00 4,522.92 CP&Y/WALLACE GROUP, INC. 2569 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 3,395.00 4,522.92 ** 107,001.00 Budgeted 102,478.08 Remaining 4 % Used Account: 135-69170-030-000 Copier Lease Installments 306 11/23/2016 November AP Copier Lease 165.00 165.00 330.00 EVERBANK COMMERCIAL FINANCE 2578 AP 337 11/30/2016 November A/P Copier charges 179.54 509.54 KYOCERA DOCUMENT SOLUTIONS 2593 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 344.54 509.54 ** 4,600.00 Budgeted 4,090.46 Remaining 11 % Used Department 30 Totals: ----------------------------------- 154,468.89 ** 67,954.30 Monthly Total 1,295,172.00 Budgeted 1,140,703.11 Remaining 12 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/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 360.00 .00 360.00 _______________ Account: 135-55045-039-000 Legal Totals: .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 2,529.84 .00 2,529.84 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 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 ** .00 Monthly Total 188,775.00 Budgeted 185,885.16 Remaining 2 % Used Fund 135 Totals: ----------------------------------- (472,148.84) (97,440.49) Monthly Total (13,456.00) Budgeted 458,692.84 Remaining ########## . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund 307 11/25/2016 GASB 34 transfers Fiscal 2017 Town Elevated Tank (45,000.00) (45,000.00) GL 307 11/25/2016 GASB 34 transfers Fiscal 2017 Water Replacement (30,000.00) (75,000.00) GL _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: (75,000.00) (75,000.00) ** .00 Budgeted 75,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept 307 11/25/2016 GASB 34 transfers Fiscal 2017 Fire Truck Future Replacement (81,420.00) (81,420.00) GL _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: (81,420.00) (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (156,420.00) ** (156,420.00) Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (156,420.00) (156,420.00) Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET NOVEMBER 2016 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,394,071 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,394,071 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,391,204 NET REVENUES / EXPENDITURES 2,867 TOTAL FUND BALANCE 4,394,071 TOTAL LIABILITIES AND FUND BALANCE 4,394,071 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 16:15 12/14/16 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 11/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,439.36- 2,866.92- 2,866.92 Subtotal: 1,439.36- 2,866.92- 2,866.92 Program number: 1,439.36- 2,866.92- 2,866.92 Department number: Revenues 1,439.36- 2,866.92- 2,866.92 Revenues Subtotal ----------- 1,439.36- 2,866.92- 2,866.92 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,439.36- 2,866.92- 2,866.92 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 11/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 424 11/30/2016 Nov Bank Interest (1,427.56) (1,439.36) (2,866.92) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,439.36) (2,866.92) ** .00 Budgeted 2,866.92 Remaining 0 % Used Department Totals: ----------------------------------- (2,866.92) ** (1,439.36) Monthly Total .00 Budgeted 2,866.92 Remaining 0 % Used Fund 517 Totals: ----------------------------------- (2,866.92) (1,439.36) Monthly Total .00 Budgeted 2,866.92 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET NOVEMBER 2016 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 406,993 ACCOUNTS RECEIVABLE - TOTAL ASSETS 406,993 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 736,413 TOTAL LIABILITIES 736,413 FUND BALANCE ASSIGNED FUND BALANCE 41,831 NET REVENUES / EXPENDITURES (371,251) TOTAL FUND BALANCE (329,420) TOTAL LIABILITIES AND FUND BALANCE 406,993 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 16:15 12/14/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 11/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 170.84- 518.64- 518.64 Subtotal: 170.84- 518.64- 518.64 Program number: 170.84- 518.64- 518.64 Department number: Revenues 170.84- 518.64- 518.64 Revenues Subtotal ----------- 170.84- 518.64- 518.64 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 16:15 12/14/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 11/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 45,163.73 371,769.37 371,769.37- Subtotal: 45,163.73 371,769.37 371,769.37- Program number: 45,163.73 371,769.37 371,769.37- Department number: Wastewater 45,163.73 371,769.37 371,769.37- Expenditures Subtotal ----------- 45,163.73 371,769.37 371,769.37- Fund number: 518 2015 Revenue Bond Const Fund 44,992.89 371,250.73 371,250.73- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 11/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 424 11/30/2016 Nov Bank Interest (347.80) (170.84) (518.64) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (170.84) (518.64) ** .00 Budgeted 518.64 Remaining 0 % Used Department Totals: ----------------------------------- (518.64) ** (170.84) Monthly Total .00 Budgeted 518.64 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 11/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 306 11/23/2016 November AP WWTP Improvements 326,605.64 45,163.73 371,769.37 CP&Y/WALLACE GROUP, INC. 2569 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 45,163.73 371,769.37 ** .00 Budgeted (371,769.37) Remaining 0 % Used Department 20 Totals: ----------------------------------- 371,769.37 ** 45,163.73 Monthly Total .00 Budgeted (371,769.37) Remaining 0 % Used Fund 518 Totals: ----------------------------------- 371,250.73 44,992.89 Monthly Total .00 Budgeted (371,250.73) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET NOVEMBER 2016 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 195,890 ACCOUNTS RECEIVABLE - TOTAL ASSETS 195,890 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 195,762 NET REVENUES / EXPENDITURES 128 TOTAL FUND BALANCE 195,890 TOTAL LIABILITIES AND FUND BALANCE 195,890 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 16:15 12/14/16 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 11/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- 64.19- 127.80- 42.600 172.20- 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- 64.19- 127.80- .068 188,584.20- Program number: 188,712.00- 188,712.00- 64.19- 127.80- .068 188,584.20- Department number: 188,712.00- 188,712.00- 64.19- 127.80- .068 188,584.20- Revenues Subtotal ----------- 188,712.00- 188,712.00- 64.19- 127.80- .068 188,584.20- Fund number: 528 2015 Revenue Bond Reserve Fund 188,712.00- 188,712.00- 64.19- 127.80- .068 188,584.20- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 11/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 424 11/30/2016 Nov Bank Interest (63.61) (64.19) (127.80) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (64.19) (127.80) ** (300.00) Budgeted (172.20) Remaining 43 % 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: ----------------------------------- (127.80) ** (64.19) Monthly Total (188,712.00) Budgeted (188,584.20) Remaining 0 % Used Fund 528 Totals: ----------------------------------- (127.80) (64.19) Monthly Total (188,712.00) Budgeted (188,584.20) Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET NOVEMBER 2016 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 50,658 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 656,104 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 711,608 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 656,104 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 656,104 FUND BALANCE ASSIGNED FUND BALANCE 26,031 NET REVENUES / EXPENDITURES 29,474 TOTAL FUND BALANCE 55,505 TOTAL LIABILITIES AND FUND BALANCE 711,608 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 16:15 12/14/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/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- 25,332.29- 28,752.58- 4.270 644,583.42- 533-40002-000-000 Property Taxes/Delinquent 3,501.00- 3,501.00- 8.50- 550.78- 15.732 2,950.22- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 19.21- 151.21- 7.561 1,848.79- Subtotal: 678,837.00- 678,837.00- 25,360.00- 29,454.57- 4.339 649,382.43- 533-49010-000-000 Interest Income 140.00- 140.00- 11.51- 19.01- 13.579 120.99- 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- 11.51- 19.01- .006 337,366.99- Program number: 1,016,223.00- 1,016,223.00- 25,371.51- 29,473.58- 2.900 986,749.42- Department number: Revenues 1,016,223.00- 1,016,223.00- 25,371.51- 29,473.58- 2.900 986,749.42- Revenues Subtotal ----------- 1,016,223.00- 1,016,223.00- 25,371.51- 29,473.58- 2.900 986,749.42- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 16:15 12/14/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/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- 25,371.51- 29,473.58- 953.838 26,383.58 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/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 396 11/01/2016 Property Taxes (3,420.29) (1,465.06) (4,885.35) GL 397 11/02/2016 Property Taxes (75.45) (4,960.80) GL 398 11/03/2016 Property Taxes (474.49) (5,435.29) GL 399 11/04/2016 Property Taxes (3,243.01) (8,678.30) GL 400 11/07/2016 Property Taxes (2,221.14) (10,899.44) GL 402 11/08/2016 Property Taxes (1,026.47) (11,925.91) GL 403 11/09/2016 Property Taxes (384.71) (12,310.62) GL 404 11/10/2016 Property Taxes (1,479.25) (13,789.87) GL 405 11/15/2016 Property Taxes (1.30) (13,791.17) GL 406 11/16/2016 Property Taxes (2,437.61) (16,228.78) GL 407 11/17/2016 Property Taxes (1,701.98) (17,930.76) GL 408 11/18/2016 Property Taxes (2,049.97) (19,980.73) GL 409 11/21/2016 Property Taxes (1,044.13) (21,024.86) GL 410 11/22/2016 Property Taxes (911.43) (21,936.29) GL 411 11/23/2016 Property Taxes (892.29) (22,828.58) GL 412 11/28/2016 Property Taxes (2,592.08) (25,420.66) GL 413 11/29/2016 Property Taxes (3,307.97) (28,728.63) GL 414 11/30/2016 Property Taxes (23.95) (28,752.58) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (25,332.29) (28,752.58) ** (673,336.00) Budgeted (644,583.42) Remaining 4 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 396 11/01/2016 Property Taxes (542.28) (3.76) (546.04) GL 403 11/09/2016 Property Taxes 13.55 (532.49) GL 405 11/15/2016 Property Taxes (18.29) (550.78) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (8.50) (550.78) ** (3,501.00) Budgeted (2,950.22) Remaining 16 % Used Account: 533-40015-000-000 Property Taxes/P & I 396 11/01/2016 Property Taxes (132.00) (1.13) (133.13) GL 405 11/15/2016 Property Taxes (4.02) (137.15) GL 456 11/30/2016 Correct JE452 (14.06) (151.21) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (19.21) (151.21) ** (2,000.00) Budgeted (1,848.79) Remaining 8 % Used Account: 533-49010-000-000 Interest Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 424 11/30/2016 Nov Bank Interest (7.50) (11.51) (19.01) GL 452 11/30/2016 Bank Rec adjustment (14.06) (33.07) GL 456 11/30/2016 Correct JE452 14.06 (19.01) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (11.51) (19.01) ** (140.00) Budgeted (120.99) Remaining 14 % 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: ----------------------------------- (29,473.58) ** (25,371.51) Monthly Total (1,016,223.00) Budgeted (986,749.42) Remaining 3 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/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: ----------------------------------- (29,473.58) (25,371.51) Monthly Total (3,090.00) Budgeted 26,383.58 Remaining 954 % Used TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET NOVEMBER 2016 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 15,107 ACCOUNTS RECEIVABLE - TOTAL ASSETS 15,107 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,097 NET REVENUES / EXPENDITURES 10 TOTAL FUND BALANCE 15,107 TOTAL LIABILITIES AND FUND BALANCE 15,107 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 16:15 12/14/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 11/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- 9.92- 4.960 190.08- 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- 9.92- .001 892,839.08- Program number: 892,849.00- 892,849.00- 4.96- 9.92- .001 892,839.08- Department number: Revenues 892,849.00- 892,849.00- 4.96- 9.92- .001 892,839.08- Revenues Subtotal ----------- 892,849.00- 892,849.00- 4.96- 9.92- .001 892,839.08- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 16:15 12/14/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 11/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- 9.92- 4.960 190.08- ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 11/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 424 11/30/2016 Nov Bank Interest (4.96) (4.96) (9.92) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (4.96) (9.92) ** (200.00) Budgeted (190.08) Remaining 5 % 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: ----------------------------------- (9.92) ** (4.96) Monthly Total (892,849.00) Budgeted (892,839.08) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 16:15 12/14/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 11/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: ----------------------------------- (9.92) (4.96) Monthly Total (200.00) Budgeted (190.08) Remaining 5 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (26,664.56) **** (136,295.66) Monthly Total (205,458.00) Budgeted (178,793.44) Remaining 13 % Used ******* End of Report *********