Loading...
HomeMy WebLinkAbout2016-12 December Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET DECEMBER 2016 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 543,384 PREPAID EXPENSES 12,385 ADVALOREM PROPERTY TAXES RECEIVABLE 663,349 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,219,118 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 663,349 ACCOUNTS AND OTHER PAYABLES 5,300 TOTAL LIABILITIES 668,649 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 521,108 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 29,361 TOTAL FUND BALANCE 550,469 TOTAL LIABILITIES AND FUND BALANCE 1,219,118 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 16:50 01/13/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/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- 347,277.28- 391,514.16- 37.798 644,295.84- 122-40011-000-000 Property Taxes/Fire-Delinquent 703.49- 1,501.14- 1,501.14 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 162.00- 402.37- 8.942 4,097.63- Subtotal: 1,040,310.00- 1,040,310.00- 348,142.77- 393,529.69- 37.828 646,780.31- 122-49900-000-000 Miscellaneous Income 149.00- 149.00 Subtotal: 149.00- 149.00 Program number: 1,040,310.00- 1,040,310.00- 348,142.77- 393,678.69- 37.842 646,631.31- Department number: Fire Revenues 1,040,310.00- 1,040,310.00- 348,142.77- 393,678.69- 37.842 646,631.31- Revenues Subtotal ----------- 1,040,310.00- 1,040,310.00- 348,142.77- 393,678.69- 37.842 646,631.31- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 16:50 01/13/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 5,300.00 10,753.91 10,753.91- Subtotal: 5,300.00 10,753.91 10,753.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 1,376.09 4,128.27 25.000 12,384.73 122-60337-045-000 Transfer to Town/Fire Budget 581,638.00 581,638.00 48,974.00 140,867.00 24.219 440,771.00 Subtotal: 814,905.00 814,905.00 50,350.09 144,995.27 17.793 669,909.73 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 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 208,568.60 92.531 16,836.40 Program number: 1,040,310.00 1,040,310.00 55,650.09 364,317.78 35.020 675,992.22 Department number: Fire 1,040,310.00 1,040,310.00 55,650.09 364,317.78 35.020 675,992.22 Expenditures Subtotal ----------- 1,040,310.00 1,040,310.00 55,650.09 364,317.78 35.020 675,992.22 Fund number: 122 Trophy Club MUD Fire Dept. 292,492.68- 29,360.91- 29,360.91 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/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 608 12/01/2016 Property Taxes (44,236.88) (3,071.44) (47,308.32) GL 609 12/02/2016 Property Taxes (3,542.66) (50,850.98) GL 610 12/05/2016 Property Taxes (1,416.13) (52,267.11) GL 611 12/06/2016 Property Taxes (2,136.11) (54,403.22) GL 612 12/07/2016 Property Taxes (1,381.42) (55,784.64) GL 613 12/08/2016 Property Taxes (6,515.92) (62,300.56) GL 614 12/09/2016 Property Taxes (1,206.98) (63,507.54) GL 615 12/10/2016 Property Taxes (3,742.04) (67,249.58) GL 616 12/12/2016 Property Taxes (4,585.50) (71,835.08) GL 617 12/13/2016 Property Taxes (3,867.67) (75,702.75) GL 618 12/14/2016 Property Taxes (6,168.59) (81,871.34) GL 619 12/15/2016 Property Taxes (692.68) (82,564.02) GL 620 12/16/2016 Property Taxes (11,654.97) (94,218.99) GL 621 12/19/2016 Property Taxes (9,813.00) (104,031.99) GL 623 12/21/2016 Property Taxes (10,223.11) (114,255.10) GL 622 12/22/2016 Property Taxes (216,181.51) (330,436.61) GL 624 12/22/2016 Property Taxes (5,002.25) (335,438.86) GL 625 12/27/2016 Property Taxes (4,481.84) (339,920.70) GL 626 12/28/2016 Property Taxes (39,852.31) (379,773.01) GL 627 12/29/2016 Property Taxes (9,162.67) (388,935.68) GL 628 12/30/2016 Property Taxes (2,578.48) (391,514.16) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (347,277.28) (391,514.16) ** (1,035,810.00) Budgeted (644,295.84) Remaining 38 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 608 12/01/2016 Property Taxes (797.65) (6.98) (804.63) GL 610 12/05/2016 Property Taxes (56.14) (860.77) GL 619 12/15/2016 Property Taxes (5.48) (866.25) GL 623 12/21/2016 Property Taxes (455.03) (1,321.28) GL 626 12/28/2016 Property Taxes (62.78) (1,384.06) GL 627 12/29/2016 Property Taxes (117.08) (1,501.14) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (703.49) (1,501.14) ** .00 Budgeted 1,501.14 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/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-40020-000-000 Property Taxes/Fire P&I 608 12/01/2016 Property Taxes (240.37) (2.17) (242.54) GL 610 12/05/2016 Property Taxes (12.91) (255.45) GL 619 12/15/2016 Property Taxes (.39) (255.84) GL 621 12/19/2016 Property Taxes (.35) (256.19) GL 623 12/21/2016 Property Taxes (109.04) (365.23) GL 622 12/22/2016 Property Taxes (.74) (365.97) GL 626 12/28/2016 Property Taxes (9.47) (375.44) GL 627 12/29/2016 Property Taxes (26.93) (402.37) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (162.00) (402.37) ** (4,500.00) Budgeted (4,097.63) Remaining 9 % Used Account: 122-49900-000-000 Miscellaneous Income (149.00) .00 (149.00) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (149.00) ** .00 Budgeted 149.00 Remaining 0 % Used Department Totals: ----------------------------------- (393,678.69) ** (348,142.77) Monthly Total (1,040,310.00) Budgeted (646,631.31) Remaining 38 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 630 12/31/2016 December A/P Replace 28 grills 5,453.91 5,300.00 10,753.91 BRANDON R REED 2692 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 5,300.00 10,753.91 ** .00 Budgeted (10,753.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 462 12/01/2016 Insurance/Wrk Comp Exp Dec 2,752.18 1,376.09 4,128.27 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,376.09 4,128.27 ** 16,513.00 Budgeted 12,384.73 Remaining 25 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 418 12/09/2016 Dec A/P Dec Fire Admin 91,893.00 48,974.00 140,867.00 TOWN OF TROPHY CLUB 2641 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 48,974.00 140,867.00 ** 581,638.00 Budgeted 440,771.00 Remaining 24 % 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 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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: ----------------------------------- 364,317.78 ** 55,650.09 Monthly Total 1,040,310.00 Budgeted 675,992.22 Remaining 35 % Used Fund 122 Totals: ----------------------------------- (29,360.91) (292,492.68) Monthly Total .00 Budgeted 29,360.91 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET DECEMBER 2016 GENERAL FUND GASB COMBINED BALANCE @ 12/31/16 ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 720,482 - 720,482 CASH IN BANK-SAVINGS-CASH RESERVE 180,300 - 180,300 CD-BANK OF THE WEST/THB DEPOSIT 35,158 - 35,158 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 712,593 - 712,593 INVESTMENTS-TEXPOOL 778,065 433,170 1,211,235 PREPAID EXPENSES 64,809 - 64,809 ADVALOREM PROPERTY TAXES RECEIVABLE 39,822 - 39,822 UTILITY AND OTHER ACCOUNTS RECEIVABLE 602,484 - 602,484 TOTAL ASSETS 3,134,313 433,170 3,567,483 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 39,822 - 39,822 ACCOUNTS AND OTHER PAYABLES 622,938 - 622,938 CUSTOMER DEPOSITS 315,905 - 315,905 - TOTAL LIABILITIES 978,665 - 978,665 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 24,040 - 24,040 - TOTAL FUND BALANCE 2,155,648 433,170 2,588,818 TOTAL LIABILITIES AND FUND BALANCE 3,134,313 433,170 3,567,483 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 16:50 01/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/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- 20,430.82- 23,033.34- 37.774 37,943.66- 135-40002-000-000 Property Taxes/Delinquent 72.20- 130.07- 130.07 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 16.07- 55.27- 8.503 594.73- 135-40025-000-000 PID Surcharges 148,291.00- 148,291.00- 148,291.00- Subtotal: 209,918.00- 209,918.00- 20,519.09- 23,218.68- 11.061 186,699.32- 135-47000-000-000 Water 6,436,734.00- 6,436,734.00- 305,691.36- 1,198,711.77- 18.623 5,238,022.23- 135-47005-000-000 Sewer 2,629,524.00- 2,629,524.00- 173,424.79- 595,480.38- 22.646 2,034,043.62- 135-47025-000-000 Penalties 119,260.00- 119,260.00- 9,737.80- 32,192.85- 26.994 87,067.15- 135-47030-000-000 Service Charges 11,400.00- 11,400.00- 1,025.00- 3,325.00- 29.167 8,075.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 450.00- 22.500 1,550.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 600.00- 10.909 4,900.00- 135-47070-000-000 TCCC Effluent Charges 61,188.00- 61,188.00- 57.00- 6,309.00- 10.311 54,879.00- Subtotal: 9,265,606.00- 9,265,606.00- 489,935.95- 1,837,069.00- 19.827 7,428,537.00- 135-49010-000-000 Interest Income 8,001.00- 8,001.00- 1,210.24- 3,073.27- 38.411 4,927.73- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 2,731.59- 25.001 8,194.41- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,166.66- 16.667 5,833.34- 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- 4,155.00- 19.228 17,454.00- 135-49900-000-000 Miscellaneous Income 20,000.00- 20,000.00- 73.79- 2,130.88- 10.654 17,869.12- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 30.00- 30.00- 150.000 10.00 Subtotal: 69,556.00- 69,556.00- 3,493.89- 13,287.40- 19.103 56,268.60- Program number: 9,545,080.00- 9,545,080.00- 513,948.93- 1,873,575.08- 19.629 7,671,504.92- Department number: Revenues 9,545,080.00- 9,545,080.00- 513,948.93- 1,873,575.08- 19.629 7,671,504.92- Revenues Subtotal ----------- 9,545,080.00- 9,545,080.00- 513,948.93- 1,873,575.08- 19.629 7,671,504.92- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 16:50 01/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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 26,996.53 54,244.61 20.006 216,898.39 135-50010-010-000 Overtime 19,500.00 19,500.00 1,662.61 3,453.16 17.709 16,046.84 135-50016-010-000 Longevity 3,270.00 3,270.00 3,270.00 100.000 135-50017-010-000 Certification 4,800.00 4,800.00 250.00 700.00 14.583 4,100.00 135-50020-010-000 Retirement 27,151.00 27,151.00 2,523.78 5,383.61 19.828 21,767.39 135-50026-010-000 Medical Insurance 55,914.00 55,914.00 2,922.03 7,680.74 13.737 48,233.26 135-50027-010-000 Dental Insurance 4,159.00 4,159.00 240.77 602.90 14.496 3,556.10 135-50028-010-000 Vision Insurance 910.00 910.00 53.98 135.17 14.854 774.83 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 213.31 639.93 22.830 2,163.07 135-50030-010-000 Social Security Taxes 19,021.00 19,021.00 1,743.28 3,773.89 19.841 15,247.11 135-50035-010-000 Medicare Taxes 4,448.00 4,448.00 407.71 882.62 19.843 3,565.38 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 1,074.16 3,222.48 24.502 9,929.52 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 38,088.16 83,989.11 19.583 344,907.89 135-55005-010-000 Engineering 5,000.00 5,000.00 3,397.23 16,012.23 320.245 11,012.23- 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 1,454.00 18,055.64 18.056 81,944.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 16.50 27.00 .338 7,973.00 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 510.00 1,175.40 21.371 4,324.60 Subtotal: 125,000.00 125,000.00 5,377.73 35,270.27 28.216 89,729.73 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 693.26 1,058.85 19.608 4,341.15 135-60020-010-000 Electricity 172,737.00 172,737.00 13,855.87 30,737.41 17.794 141,999.59 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 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 28.282 35,985.05 135-60150-010-000 Wholesale Water 2,998,802.00 2,998,802.00 147,255.17 365,179.85 12.178 2,633,622.15 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 65,678.61 65,678.61 22.113 231,332.39 135-60333-010-000 Interfund Transfer Out-Reserve 64,920.00 64,920.00 43,083.00 43,083.00 66.363 21,837.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:50 01/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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 270,565.91 521,068.13 13.639 3,299,299.87 135-65005-010-000 Fuel & Lube 33,011.00 33,011.00 1,373.48 1,885.26 5.711 31,125.74 135-65010-010-000 Uniforms 4,608.00 4,608.00 1,158.49 25.141 3,449.51 135-65030-010-000 Chemicals 20,000.00 20,000.00 771.36 3,363.29 16.816 16,636.71 135-65035-010-000 Small Tools 1,200.00 1,200.00 221.62 221.62 18.468 978.38 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 3,642.00 11,708.26 10.181 103,291.74 135-65053-010-000 Meter Change Out Program 81,500.00 81,500.00 41,464.00 41,464.00 50.876 40,036.00 Subtotal: 256,319.00 256,319.00 47,472.46 59,800.92 23.331 196,518.08 135-69005-010-000 Capital Outlays 502,421.00 502,421.00 127,635.00 198,965.60 39.601 303,455.40 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 118,775.00 80,986.69 68.185 37,788.31 Subtotal: 696,196.00 696,196.00 127,635.00 354,952.29 50.985 341,243.71 Program number: 5,326,780.00 5,326,780.00 489,139.26 1,055,080.72 19.807 4,271,699.28 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 16:50 01/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 12/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 160.00 240.00 4.800 4,760.00 Subtotal: 5,000.00 5,000.00 160.00 240.00 4.800 4,760.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 160.00 240.00 2.400 9,760.00 Department number: Water 5,336,780.00 5,336,780.00 489,299.26 1,055,320.72 19.774 4,281,459.28 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 16:50 01/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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 44,104.76 88,414.31 22.606 302,687.69 135-50010-020-000 Overtime 29,500.00 29,500.00 5,593.08 8,908.80 30.199 20,591.20 135-50016-020-000 Longevity 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,875.00 24.038 5,925.00 135-50020-020-000 Retirement 39,584.00 39,584.00 4,393.18 9,239.21 23.341 30,344.79 135-50026-020-000 Medical Insurance 73,022.00 73,022.00 4,710.20 13,020.00 17.830 60,002.00 135-50027-020-000 Dental Insurance 4,592.00 4,592.00 347.91 870.44 18.956 3,721.56 135-50028-020-000 Vision Insurance 1,031.00 1,031.00 78.05 195.27 18.940 835.73 135-50029-020-000 Life Insurance & Other 4,485.00 4,485.00 356.82 1,070.46 23.868 3,414.54 135-50030-020-000 Social Security Taxes 27,886.00 27,886.00 2,985.24 6,147.79 22.046 21,738.21 135-50035-020-000 Medicare Taxes 6,522.00 6,522.00 698.15 1,437.78 22.045 5,084.22 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 926.75 2,780.25 24.502 8,566.75 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 18.562 529.35 Subtotal: 605,653.00 605,653.00 64,819.14 140,714.96 23.234 464,938.04 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 1,597.12 7,779.12 38.896 12,220.88 135-55080-020-000 Maintenance & Repairs 83,100.00 83,100.00 18,808.16 24,993.19 30.076 58,106.81 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 2,842.39 3,658.26 91.457 341.74 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 23.94 23.94 4.788 476.06 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 4,705.81 12,806.40 23.284 42,193.60 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 2,223.00 6,659.00 26.636 18,341.00 Subtotal: 277,600.00 277,600.00 30,200.42 55,919.91 20.144 221,680.09 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 823.04 1,292.39 23.933 4,107.61 135-60020-020-000 Electricity 158,627.00 158,627.00 12,169.88 27,338.53 17.234 131,288.47 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 1,095.00 1,095.00 26.103 3,100.00 135-60090-020-000 Safety Program 550.00 550.00 59.99 142.19 25.853 407.81 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 53.85 137.74 8.609 1,462.26 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- 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 4,000.00 13,910.97 81.114 3,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 32,861.46 32,861.46 27.273 87,630.54 135-60332-020-000 Interfund Transfer Out-Rev I&S 595,638.00 595,638.00 162,446.73 162,446.73 27.273 433,191.27 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 16:50 01/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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 33,679.60 33,679.60 27.273 89,812.40 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 247,189.55 277,580.98 22.110 977,884.02 135-65005-020-000 Fuel & Lube 28,088.00 28,088.00 1,442.21 1,834.77 6.532 26,253.23 135-65010-020-000 Uniforms 4,459.00 4,459.00 175.00 3,553.92 79.702 905.08 135-65030-020-000 Chemicals 25,000.00 25,000.00 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 6.644 700.17 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 2,283.90 4,035.37 28.824 9,964.63 Subtotal: 74,297.00 74,297.00 3,901.11 20,033.72 26.964 54,263.28 135-69005-020-000 Capital Outlays 485,000.00 485,000.00 17,994.50 32,822.05 6.767 452,177.95 Subtotal: 485,000.00 485,000.00 17,994.50 32,822.05 6.767 452,177.95 Program number: 2,698,015.00 2,698,015.00 364,104.72 527,071.62 19.536 2,170,943.38 Department number: Wastewater 2,698,015.00 2,698,015.00 364,104.72 527,071.62 19.536 2,170,943.38 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 16:50 01/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/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 2.61 7.83 24.469 24.17 Subtotal: 32.00 32.00 2.61 7.83 24.469 24.17 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 2.61 1,132.83 8.794 11,749.17 Department number: Board of Directors 12,882.00 12,882.00 2.61 1,132.83 8.794 11,749.17 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 16:50 01/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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 45,636.27 84,198.75 16.196 435,684.25 135-50010-030-000 Overtime 1,000.00 1,000.00 300.39 600.82 60.082 399.18 135-50016-030-000 Longevity 3,890.00 3,890.00 3,417.50 87.853 472.50 135-50020-030-000 Retirement 47,768.00 47,768.00 4,010.26 7,463.91 15.625 40,304.09 135-50026-030-000 Medical Insurance 84,289.00 84,289.00 3,505.95 8,579.55 10.179 75,709.45 135-50027-030-000 Dental Insurance 5,981.00 5,981.00 277.21 638.36 10.673 5,342.64 135-50028-030-000 Vision Insurance 1,312.00 1,312.00 53.98 134.93 10.284 1,177.07 135-50029-030-000 Life Insurance & Other 5,890.00 5,890.00 272.67 681.95 11.578 5,208.05 135-50030-030-000 Social Security Taxes 32,777.00 32,777.00 2,765.61 5,108.33 15.585 27,668.67 135-50035-030-000 Medicare Taxes 8,084.00 8,084.00 646.78 1,194.68 14.778 6,889.32 135-50040-030-000 Unemployment Taxes 1,368.00 1,368.00 196.67 221.73 16.208 1,146.27 135-50045-030-000 Workman's Compensation 1,784.00 1,784.00 145.53 436.59 24.473 1,347.41 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 77.90 153.90 30.780 346.10 135-50070-030-000 Employee Relations 4,960.00 4,960.00 1,209.51 2,125.74 42.858 2,834.26 Subtotal: 719,486.00 719,486.00 59,098.73 114,956.74 15.978 604,529.26 135-55030-030-000 Software & Support 67,791.00 67,791.00 10,589.26 15,109.04 22.288 52,681.96 135-55070-030-000 Independent Labor 12,000.00 12,000.00 673.75 715.00 5.958 11,285.00 135-55080-030-000 Maintenance & Repairs 7,000.00 7,000.00 275.00 275.00 3.929 6,725.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 392.67 3,435.46 49.078 3,564.54 135-55120-030-000 Cleaning Services 10,429.00 10,429.00 633.06 1,243.12 11.920 9,185.88 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 1,767.34 2,372.64 28.935 5,827.36 Subtotal: 185,945.00 185,945.00 14,331.08 80,482.26 43.283 105,462.74 135-60005-030-000 Telephone 17,532.00 17,532.00 1,684.50 3,775.42 21.534 13,756.58 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 300.98 638.97 15.397 3,511.03 135-60020-030-000 Electricity/Gas 12,631.00 12,631.00 882.09 882.09 6.984 11,748.91 135-60025-030-000 Water 1,500.00 1,500.00 343.41 438.67 29.245 1,061.33 135-60035-030-000 Postage 28,932.00 28,932.00 5,059.02 8,271.19 28.588 20,660.81 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,447.22 13,383.92 24.089 42,176.08 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 4,664.56 13,993.68 25.127 41,698.32 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 3,656.25 3,756.25 62.604 2,243.75 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 8,754.00 8,754.00 51.65 51.65 .590 8,702.35 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 83.93 179.78 3.329 5,220.22 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 16:50 01/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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 330.34 950.09 12.668 6,549.91 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 41.600 1,460.00 Subtotal: 246,041.00 246,041.00 21,503.95 47,361.71 19.250 198,679.29 135-65010-030-000 Uniforms 1,855.00 1,855.00 142.36 142.36 7.674 1,712.64 135-65055-030-000 Hardware 9,444.00 9,444.00 2,239.88 2,239.88 23.717 7,204.12 135-65085-030-000 Office Supplies 9,000.00 9,000.00 771.90 1,664.63 18.496 7,335.37 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 239.89 813.14 16.263 4,186.86 135-65105-030-000 Printing 4,800.00 4,800.00 19.50 123.00 2.563 4,677.00 Subtotal: 32,099.00 32,099.00 3,413.53 4,983.01 15.524 27,115.99 135-69005-030-000 Capital Outlays 107,001.00 107,001.00 4,172.53 8,695.45 8.127 98,305.55 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 112.69 622.23 13.527 3,977.77 Subtotal: 111,601.00 111,601.00 4,285.22 9,317.68 8.349 102,283.32 Program number: 1,295,172.00 1,295,172.00 102,632.51 257,101.40 19.851 1,038,070.60 Department number: Administration 1,295,172.00 1,295,172.00 102,632.51 257,101.40 19.851 1,038,070.60 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 16:50 01/13/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/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 1,410.93 1,770.93 1.181 148,229.07 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,045.87 4,575.71 41.167 6,539.29 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,561.76 2,561.76 67.415 1,238.24 Subtotal: 188,775.00 188,775.00 6,018.56 8,908.40 4.719 179,866.60 Program number: 188,775.00 188,775.00 6,018.56 8,908.40 4.719 179,866.60 Department number: Non Departmental 188,775.00 188,775.00 6,018.56 8,908.40 4.719 179,866.60 Expenditures Subtotal ----------- 9,531,624.00 9,531,624.00 962,057.66 1,849,534.97 19.404 7,682,089.03 Fund number: 135 MUD 1 General Fund 13,456.00- 13,456.00- 448,108.73 24,040.11- 178.657 10,584.11 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 16:50 01/13/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 12/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/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 608 12/01/2016 Property Taxes (2,602.52) (180.70) (2,783.22) GL 609 12/02/2016 Property Taxes (208.42) (2,991.64) GL 610 12/05/2016 Property Taxes (83.31) (3,074.95) GL 611 12/06/2016 Property Taxes (125.67) (3,200.62) GL 612 12/07/2016 Property Taxes (81.27) (3,281.89) GL 613 12/08/2016 Property Taxes (383.34) (3,665.23) GL 614 12/09/2016 Property Taxes (71.01) (3,736.24) GL 615 12/10/2016 Property Taxes (220.15) (3,956.39) GL 616 12/12/2016 Property Taxes (269.77) (4,226.16) GL 617 12/13/2016 Property Taxes (227.54) (4,453.70) GL 618 12/14/2016 Property Taxes (362.91) (4,816.61) GL 619 12/15/2016 Property Taxes (40.75) (4,857.36) GL 620 12/16/2016 Property Taxes (685.68) (5,543.04) GL 621 12/19/2016 Property Taxes (577.31) (6,120.35) GL 623 12/21/2016 Property Taxes (601.44) (6,721.79) GL 622 12/22/2016 Property Taxes (12,718.27) (19,440.06) GL 624 12/22/2016 Property Taxes (294.29) (19,734.35) GL 625 12/27/2016 Property Taxes (263.67) (19,998.02) GL 626 12/28/2016 Property Taxes (2,344.57) (22,342.59) GL 627 12/29/2016 Property Taxes (539.05) (22,881.64) GL 628 12/30/2016 Property Taxes (151.70) (23,033.34) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (20,430.82) (23,033.34) ** (60,977.00) Budgeted (37,943.66) Remaining 38 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 608 12/01/2016 Property Taxes (57.87) (1.34) (59.21) GL 610 12/05/2016 Property Taxes (3.67) (62.88) GL 619 12/15/2016 Property Taxes (.36) (63.24) GL 623 12/21/2016 Property Taxes (55.08) (118.32) GL 626 12/28/2016 Property Taxes (4.10) (122.42) GL 627 12/29/2016 Property Taxes (7.65) (130.07) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (72.20) (130.07) ** .00 Budgeted 130.07 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 608 12/01/2016 Property Taxes (39.20) (.42) (39.62) GL 610 12/05/2016 Property Taxes (.85) (40.47) GL 619 12/15/2016 Property Taxes (.02) (40.49) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 621 12/19/2016 Property Taxes (39.20) (.02) (40.51) GL 623 12/21/2016 Property Taxes (12.34) (52.85) GL 622 12/22/2016 Property Taxes (.04) (52.89) GL 626 12/28/2016 Property Taxes (.62) (53.51) GL 627 12/29/2016 Property Taxes (1.76) (55.27) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (16.07) (55.27) ** (650.00) Budgeted (594.73) Remaining 9 % Used 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 562 12/07/2016 UB 12/7/16 Adj 4 Riviera ct UB20161207-20161207 User: (893,020.41) 242.63 (892,777.78) UB 563 12/19/2016 UB 12/19-adj 5 Spring Creek UB20161219-20161219 User: 24.97 (892,752.81) UB 565 12/29/2016 UB 12/29/16 Solana misread UB20161229-20161229 User: 1,809.71 (890,943.10) UB 559 12/31/2016 12/31/2016 UB Billing UB20161231-20161231 User: (307,846.66) (1,198,789.76) UB 567 12/31/2016 12/31/16 adj 2224 TC Drive UB20161231-20161231 User: 77.99 (1,198,711.77) UB _______________ Account: 135-47000-000-000 Water Totals: (305,691.36) (1,198,711.77) ** (6,436,734.00) Budgeted (5,238,022.23) Remaining 19 % Used Account: 135-47005-000-000 Sewer 573 12/06/2016 UB Adjustments 12/06/2016 UB20161206-20161206 User: (422,055.59) 40.46 (422,015.13) UB 563 12/19/2016 UB 12/19-adj 5 Spring Creek UB20161219-20161219 User: 21.89 (421,993.24) UB 565 12/29/2016 UB 12/29/16 Solana misread UB20161229-20161229 User: 712.84 (421,280.40) UB 566 12/30/2016 UB 12/30-adj to 2224 TC Drive UB20161230-20161230 User: 44.50 (421,235.90) UB 559 12/31/2016 12/31/2016 UB Billing UB20161231-20161231 User: (174,244.48) (595,480.38) UB _______________ Account: 135-47005-000-000 Sewer Totals: (173,424.79) (595,480.38) ** (2,629,524.00) Budgeted (2,034,043.62) Remaining 23 % Used Account: 135-47025-000-000 Penalties 571 12/01/2016 UB Penalty removed UB20161201-20161201 User: (22,455.05) 574.83 (21,880.22) UB 562 12/07/2016 UB 12/7/16 Adj 4 Riviera ct UB20161207-20161207 User: 72.32 (21,807.90) UB 582 12/08/2016 12/08/16 UB penalty removed UB20161208-20161208 User: 179.33 (21,628.57) UB . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 518 12/21/2016 12/21/2016 UB Penalties UB20161221-20161221 User: (22,455.05) (10,906.58) (32,535.15) UB 570 12/21/2016 UB 12/21/16 pnlty&nsf fees UB20161221-20161221 User: 14.90 (32,520.25) UB 587 12/29/2016 12/29/2017 UB Penalty removed UB20161229-20161229 User: 327.40 (32,192.85) UB _______________ Account: 135-47025-000-000 Penalties Totals: (9,737.80) (32,192.85) ** (119,260.00) Budgeted (87,067.15) Remaining 27 % Used Account: 135-47030-000-000 Service Charges 393 12/08/2016 UB 12/08/2016 Disconnect Fees UB20161208-20161208 User: (2,300.00) (925.00) (3,225.00) UB 583 12/09/2016 UB 12/09/2016 NSF Fee UB20161209-20161209 User: (25.00) (3,250.00) UB 592 12/13/2016 12/13/16 NSF FEE UB20161213-20161213 User: (25.00) (3,275.00) UB 570 12/21/2016 UB 12/21/16 pnlty&nsf fees UB20161221-20161221 User: (50.00) (3,325.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,025.00) (3,325.00) ** (11,400.00) Budgeted (8,075.00) Remaining 29 % Used Account: 135-47035-000-000 Plumbing Inspections (450.00) .00 (450.00) _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: .00 (450.00) ** (2,000.00) Budgeted (1,550.00) Remaining 23 % Used Account: 135-47045-000-000 Sewer Inspections (600.00) .00 (600.00) _______________ Account: 135-47045-000-000 Sewer Inspections Totals: .00 (600.00) ** (5,500.00) Budgeted (4,900.00) Remaining 11 % Used Account: 135-47070-000-000 TCCC Effluent Charges 559 12/31/2016 12/31/2016 UB Billing UB20161231-20161231 User: (6,252.00) (57.00) (6,309.00) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (57.00) (6,309.00) ** (61,188.00) Budgeted (54,879.00) Remaining 10 % Used Account: 135-49010-000-000 Interest Income 677 12/31/2016 Bank Interest/December (1,863.03) (146.39) (2,009.42) GL 677 12/31/2016 Bank Interest/December (288.88) (2,298.30) GL 677 12/31/2016 Bank Interest/December (113.27) (2,411.57) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 677 12/31/2016 Bank Interest/December (1,863.03) (661.70) (3,073.27) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,210.24) (3,073.27) ** (8,001.00) Budgeted (4,927.73) Remaining 38 % Used Account: 135-49016-000-000 Cell Tower Revenue 499 12/15/2016 AT&T Cell Tower Revenue (1,821.06) (910.53) (2,731.59) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (2,731.59) ** (10,926.00) Budgeted (8,194.41) Remaining 25 % Used Account: 135-49018-000-000 Building Rent Income 687 12/31/2016 Bill Town Inv 1538-1543 AR 20161231-20161231 User: (583.33) (583.33) (1,166.66) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,166.66) ** (7,000.00) Budgeted (5,833.34) Remaining 17 % Used Account: 135-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 394 12/06/2016 12/06/2016 UB Deposits 2117 Veranda (3,469.00) (343.00) (3,812.00) CalAtlanticHomes CR 394 12/06/2016 12/06/2016 UB Deposits 2103 Veranda (343.00) (4,155.00) CalAtlantic Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (686.00) (4,155.00) ** (21,609.00) Budgeted (17,454.00) Remaining 19 % Used Account: 135-49900-000-000 Miscellaneous Income 501 12/19/2016 Gonzales/Flu shot (2,057.09) (15.00) (2,072.09) GL 564 12/19/2016 UB 12/19/16-5 Spring Creek Ct UB20161219-20161219 User: (.34) (2,072.43) UB 559 12/31/2016 12/31/2016 UB Billing UB20161231-20161231 User: (58.45) (2,130.88) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (73.79) (2,130.88) ** (20,000.00) Budgeted (17,869.12) Remaining 11 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/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-49901-000-000 Records Management Revenue 663 12/28/2016 ORR/Lamont (30.00) (30.00) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (30.00) (30.00) ** (20.00) Budgeted 10.00 Remaining 150 % Used Department Totals: ----------------------------------- (1,873,575.08) ** (513,948.93) Monthly Total (9,545,080.00) Budgeted (7,671,504.92) Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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 329 12/02/2016 MUD Payroll 12/2/16 Salaries & Wages 27,248.08 8,992.65 36,240.73 PR 449 12/16/2016 MUD P/R 12/16/16 Salaries & Wages 9,001.94 45,242.67 PR 544 12/30/2016 MUD P/R 12/30/16 Salaries & Wages 9,001.94 54,244.61 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 26,996.53 54,244.61 ** 271,143.00 Budgeted 216,898.39 Remaining 20 % Used Account: 135-50010-010-000 Overtime 329 12/02/2016 MUD Payroll 12/2/16 Overtime 1,790.55 650.97 2,441.52 PR 449 12/16/2016 MUD P/R 12/16/16 Overtime 168.56 2,610.08 PR 544 12/30/2016 MUD P/R 12/30/16 Overtime 843.08 3,453.16 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,662.61 3,453.16 ** 19,500.00 Budgeted 16,046.84 Remaining 18 % Used Account: 135-50016-010-000 Longevity 3,270.00 .00 3,270.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,270.00 ** 3,270.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 449 12/16/2016 MUD P/R 12/16/16 Certification 450.00 250.00 700.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 250.00 700.00 ** 4,800.00 Budgeted 4,100.00 Remaining 15 % Used Account: 135-50020-010-000 Retirement 329 12/02/2016 MUD Payroll 12/2/16 Retirement 2,859.83 841.90 3,701.73 PR 449 12/16/2016 MUD P/R 12/16/16 Retirement 822.40 4,524.13 PR 544 12/30/2016 MUD P/R 12/30/16 Retirement 859.48 5,383.61 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,523.78 5,383.61 ** 27,151.00 Budgeted 21,767.39 Remaining 20 % Used Account: 135-50026-010-000 Medical Insurance 329 12/02/2016 MUD Payroll 12/2/16 Medical Insurance 4,758.71 1,461.01 6,219.72 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 449 12/16/2016 MUD P/R 12/16/16 Medical Insurance 4,758.71 1,461.02 7,680.74 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,922.03 7,680.74 ** 55,914.00 Budgeted 48,233.26 Remaining 14 % Used Account: 135-50027-010-000 Dental Insurance 329 12/02/2016 MUD Payroll 12/2/16 Dental Insurance 362.13 120.39 482.52 PR 449 12/16/2016 MUD P/R 12/16/16 Dental Insurance 120.38 602.90 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 240.77 602.90 ** 4,159.00 Budgeted 3,556.10 Remaining 14 % Used Account: 135-50028-010-000 Vision Insurance 329 12/02/2016 MUD Payroll 12/2/16 Vision Insurance 81.19 27.01 108.20 PR 449 12/16/2016 MUD P/R 12/16/16 Vision Insurance 26.97 135.17 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.98 135.17 ** 910.00 Budgeted 774.83 Remaining 15 % Used Account: 135-50029-010-000 Life Insurance & Other 362 12/05/2016 December AP Metlife-December 426.62 203.60 630.22 METLIFE GROUP BENEFITS 2607 AP 503 12/20/2016 December A/P Café 125 Admin fee 9.71 639.93 BenefitMall 2669 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 213.31 639.93 ** 2,803.00 Budgeted 2,163.07 Remaining 23 % Used Account: 135-50030-010-000 Social Security Taxes 329 12/02/2016 MUD Payroll 12/2/16 Social Security Taxes 2,030.61 574.82 2,605.43 PR 449 12/16/2016 MUD P/R 12/16/16 Social Security Taxes 555.46 3,160.89 PR 544 12/30/2016 MUD P/R 12/30/16 Social Security Taxes 613.00 3,773.89 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,743.28 3,773.89 ** 19,021.00 Budgeted 15,247.11 Remaining 20 % Used Account: 135-50035-010-000 Medicare Taxes 329 12/02/2016 MUD Payroll 12/2/16 Medicare Taxes 474.91 134.44 609.35 PR 449 12/16/2016 MUD P/R 12/16/16 Medicare Taxes 129.90 739.25 PR 544 12/30/2016 MUD P/R 12/30/16 Medicare Taxes 143.37 882.62 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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: 407.71 882.62 ** 4,448.00 Budgeted 3,565.38 Remaining 20 % 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 462 12/01/2016 Insurance/Wrk Comp Exp Dec 2,148.32 1,074.16 3,222.48 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,074.16 3,222.48 ** 13,152.00 Budgeted 9,929.52 Remaining 25 % 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 479 12/16/2016 Dec A/P Utility Mapping 12,615.00 180.00 12,795.00 CP&Y/WALLACE GROUP, INC. 2660 AP 479 12/16/2016 Dec A/P Water Study 937.50 13,732.50 CP&Y/WALLACE GROUP, INC. 2660 AP 669 12/31/2016 December AP Utility mapping 1,278.75 15,011.25 CP&Y/WALLACE GROUP, INC. 2757 AP 669 12/31/2016 December AP Water Study 1,000.98 16,012.23 CP&Y/WALLACE GROUP, INC. 2757 AP _______________ Account: 135-55005-010-000 Engineering Totals: 3,397.23 16,012.23 ** 5,000.00 Budgeted (11,012.23) Remaining 320 % Used Account: 135-55080-010-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 368 12/06/2016 December AP Nuts & Bolts 16,601.64 369.00 16,970.64 HD SUPPLY WATERWORKS, LTD. 2586 AP 368 12/06/2016 December AP Credit for Invoice G461686 (112.00) 16,858.64 HD SUPPLY WATERWORKS, LTD. 2586 AP 503 12/20/2016 December A/P Pimp #1 troubleshoot 342.00 17,200.64 SES Group, LLC 2681 AP 672 12/31/2016 December AP Heater for pump room 855.00 18,055.64 BRANDON R REED 2756 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,454.00 18,055.64 ** 100,000.00 Budgeted 81,944.36 Remaining 18 % 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 661 12/27/2016 Dec A/P TX.GOV SERVICEFEE 10.50 2.00 12.50 TX.GOV SERVICEFEE PC 661 12/27/2016 Dec A/P DENTON VEHREG 7.50 20.00 DENTON VEHREG PC 661 12/27/2016 Dec A/P KWIK KAR LUBE TUNE 7.00 27.00 KWIK KAR LUBE TUNE PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 16.50 27.00 ** 8,000.00 Budgeted 7,973.00 Remaining 0 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 437 12/12/2016 December A/P Water samples-MUD 665.40 225.00 890.40 TARRANT CTY PUBLIC HEALTH LAB 2652 AP 669 12/31/2016 December AP Water samples-MUD 285.00 1,175.40 TARRANT CTY PUBLIC HEALTH LAB 2765 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 510.00 1,175.40 ** 5,500.00 Budgeted 4,324.60 Remaining 21 % Used Account: 135-60010-010-000 Communications/Mobiles 437 12/12/2016 December A/P November Cellphones 365.59 346.75 712.34 VERIZON WIRELESS 2656 AP 669 12/31/2016 December AP December Cell Phones 346.51 1,058.85 VERIZON WIRELESS 2767 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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-60010-010-000 Communications/Mobiles Totals: 693.26 1,058.85 ** 5,400.00 Budgeted 4,341.15 Remaining 20 % Used Account: 135-60020-010-000 Electricity 437 12/12/2016 December A/P Electricity 10/10-11/08/2016 16,881.54 1,834.21 18,715.75 HUDSON ENERGY SERVICES, LLC 2647 AP 444 12/13/2016 Dec A/P Electricity 11/8-12/9/16 1,702.92 20,418.67 HUDSON ENERGY SERVICES, LLC 2658 AP 528 12/22/2016 December A/P Electricity 11/8-12/9/16 10,318.74 30,737.41 HUDSON ENERGY SERVICES, LLC 2685 AP _______________ Account: 135-60020-010-000 Electricity Totals: 13,855.87 30,737.41 ** 172,737.00 Budgeted 141,999.59 Remaining 18 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 124.46 .00 124.46 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 124.46 ** 1,500.00 Budgeted 1,375.54 Remaining 8 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 14,190.95 .00 14,190.95 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 14,190.95 ** 50,176.00 Budgeted 35,985.05 Remaining 28 % Used Account: 135-60150-010-000 Wholesale Water 630 12/31/2016 December A/P Wholesale water-November 217,924.68 147,255.17 365,179.85 CITY OF FORT WORTH 2693 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 147,255.17 365,179.85 ** 2,998,802.00 Budgeted 2,633,622.15 Remaining 12 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60285-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 664 12/21/2016 Texpool Transfers 65,678.61 65,678.61 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 65,678.61 65,678.61 ** 297,011.00 Budgeted 231,332.39 Remaining 22 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 664 12/21/2016 Texpool Transfers 43,083.00 43,083.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 43,083.00 43,083.00 ** 64,920.00 Budgeted 21,837.00 Remaining 66 % 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 368 12/06/2016 December AP fuel 511.78 671.02 1,182.80 US Bank Voyager Fleet Systems 2634 AP 630 12/31/2016 December A/P Fuel 702.46 1,885.26 US Bank Voyager Fleet Systems 2713 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,373.48 1,885.26 ** 33,011.00 Budgeted 31,125.74 Remaining 6 % Used Account: 135-65010-010-000 Uniforms 1,158.49 .00 1,158.49 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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-010-000 Uniforms Totals: .00 1,158.49 ** 4,608.00 Budgeted 3,449.51 Remaining 25 % Used Account: 135-65030-010-000 Chemicals 503 12/20/2016 December A/P Chemicals 2,591.93 347.60 2,939.53 HACH COMPANY 2674 AP 630 12/31/2016 December A/P Chlorine 423.76 3,363.29 DPC INDUSTRIES, INC 2695 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 771.36 3,363.29 ** 20,000.00 Budgeted 16,636.71 Remaining 17 % Used Account: 135-65035-010-000 Small Tools 438 12/12/2016 Dec A/P Valve wrenches 221.62 221.62 HD SUPPLY WATERWORKS, LTD. 2646 AP _______________ Account: 135-65035-010-000 Small Tools Totals: 221.62 221.62 ** 1,200.00 Budgeted 978.38 Remaining 18 % 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 503 12/20/2016 December A/P 4" meters 8,066.26 3,497.00 11,563.26 ATLAS UTILITY SUPPLY CO. 2668 AP 630 12/31/2016 December A/P 2" meter gaskets 145.00 11,708.26 HD SUPPLY WATERWORKS, LTD. 2698 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 3,642.00 11,708.26 ** 115,000.00 Budgeted 103,291.74 Remaining 10 % Used Account: 135-65053-010-000 Meter Change Out Program 503 12/20/2016 December A/P Meters for change outs 41,464.00 41,464.00 ATLAS UTILITY SUPPLY CO. 2668 AP _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: 41,464.00 41,464.00 ** 81,500.00 Budgeted 40,036.00 Remaining 51 % Used Account: 135-69005-010-000 Capital Outlays . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 503 12/20/2016 December A/P 14# Inline Valve 71,330.60 62,421.00 133,751.60 REY-MAR CONSTRUCTION 2680 AP 520 12/21/2016 December AP LAS Building 10,863.00 144,614.60 CP&Y/WALLACE GROUP, INC. AP 522 12/21/2016 Reverse CPY/Wrong Inv(Fryer) LAS Building (10,863.00) 133,751.60 CP&Y/WALLACE GROUP, INC. AP 523 12/21/2016 Dec A/P LAS Building 10,863.00 144,614.60 FRYER CONSTRUCTION COMPANY 2673 AP 646 12/31/2016 Dec A/P LAS App 5 54,351.00 198,965.60 FRYER CONSTRUCTION COMPANY 2747 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 127,635.00 198,965.60 ** 502,421.00 Budgeted 303,455.40 Remaining 40 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 80,986.69 .00 80,986.69 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 80,986.69 ** 118,775.00 Budgeted 37,788.31 Remaining 68 % Used Account: 135-55135-010-001 Lab Analysis for PID 437 12/12/2016 December A/P Water samples-PID 80.00 80.00 160.00 TARRANT CTY PUBLIC HEALTH LAB 2652 AP 669 12/31/2016 December AP Water samples-PID 80.00 240.00 TARRANT CTY PUBLIC HEALTH LAB 2765 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 160.00 240.00 ** 5,000.00 Budgeted 4,760.00 Remaining 5 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ----------------------------------- 1,055,320.72 ** 489,299.26 Monthly Total 5,336,780.00 Budgeted 4,281,459.28 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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 329 12/02/2016 MUD Payroll 12/2/16 Salaries & Wages 44,309.55 14,713.64 59,023.19 PR 449 12/16/2016 MUD P/R 12/16/16 Salaries & Wages 14,681.04 73,704.23 PR 544 12/30/2016 MUD P/R 12/30/16 Salaries & Wages 14,710.08 88,414.31 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 44,104.76 88,414.31 ** 391,102.00 Budgeted 302,687.69 Remaining 23 % Used Account: 135-50010-020-000 Overtime 329 12/02/2016 MUD Payroll 12/2/16 Overtime 3,315.72 2,309.97 5,625.69 PR 449 12/16/2016 MUD P/R 12/16/16 Overtime 2,087.82 7,713.51 PR 544 12/30/2016 MUD P/R 12/30/16 Overtime 1,195.29 8,908.80 PR _______________ Account: 135-50010-020-000 Overtime Totals: 5,593.08 8,908.80 ** 29,500.00 Budgeted 20,591.20 Remaining 30 % Used Account: 135-50016-020-000 Longevity 6,635.00 .00 6,635.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,635.00 ** 6,635.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 449 12/16/2016 MUD P/R 12/16/16 Certification 1,250.00 625.00 1,875.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 625.00 1,875.00 ** 7,800.00 Budgeted 5,925.00 Remaining 24 % Used Account: 135-50020-020-000 Retirement 329 12/02/2016 MUD Payroll 12/2/16 Retirement 4,846.03 1,486.16 6,332.19 PR 449 12/16/2016 MUD P/R 12/16/16 Retirement 1,518.48 7,850.67 PR 544 12/30/2016 MUD P/R 12/30/16 Retirement 1,388.54 9,239.21 PR _______________ Account: 135-50020-020-000 Retirement Totals: 4,393.18 9,239.21 ** 39,584.00 Budgeted 30,344.79 Remaining 23 % Used Account: 135-50026-020-000 Medical Insurance 329 12/02/2016 MUD Payroll 12/2/16 Medical Insurance 8,309.80 2,355.10 10,664.90 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 449 12/16/2016 MUD P/R 12/16/16 Medical Insurance 8,309.80 2,355.10 13,020.00 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 13,020.00 ** 73,022.00 Budgeted 60,002.00 Remaining 18 % Used Account: 135-50027-020-000 Dental Insurance 329 12/02/2016 MUD Payroll 12/2/16 Dental Insurance 522.53 173.97 696.50 PR 449 12/16/2016 MUD P/R 12/16/16 Dental Insurance 173.94 870.44 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 347.91 870.44 ** 4,592.00 Budgeted 3,721.56 Remaining 19 % Used Account: 135-50028-020-000 Vision Insurance 329 12/02/2016 MUD Payroll 12/2/16 Vision Insurance 117.22 39.05 156.27 PR 449 12/16/2016 MUD P/R 12/16/16 Vision Insurance 39.00 195.27 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 78.05 195.27 ** 1,031.00 Budgeted 835.73 Remaining 19 % Used Account: 135-50029-020-000 Life Insurance & Other 362 12/05/2016 December AP Metlife-December 713.64 329.69 1,043.33 METLIFE GROUP BENEFITS 2607 AP 503 12/20/2016 December A/P Café 125 Admin fee 27.13 1,070.46 BenefitMall 2669 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 356.82 1,070.46 ** 4,485.00 Budgeted 3,414.54 Remaining 24 % Used Account: 135-50030-020-000 Social Security Taxes 329 12/02/2016 MUD Payroll 12/2/16 Social Security Taxes 3,162.55 995.37 4,157.92 PR 449 12/16/2016 MUD P/R 12/16/16 Social Security Taxes 1,001.11 5,159.03 PR 544 12/30/2016 MUD P/R 12/30/16 Social Security Taxes 988.76 6,147.79 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,985.24 6,147.79 ** 27,886.00 Budgeted 21,738.21 Remaining 22 % Used Account: 135-50035-020-000 Medicare Taxes 329 12/02/2016 MUD Payroll 12/2/16 Medicare Taxes 739.63 232.78 972.41 PR 449 12/16/2016 MUD P/R 12/16/16 Medicare Taxes 234.14 1,206.55 PR 544 12/30/2016 MUD P/R 12/30/16 Medicare Taxes 231.23 1,437.78 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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: 698.15 1,437.78 ** 6,522.00 Budgeted 5,084.22 Remaining 22 % 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 462 12/01/2016 Insurance/Wrk Comp Exp Dec 1,853.50 926.75 2,780.25 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 926.75 2,780.25 ** 11,347.00 Budgeted 8,566.75 Remaining 25 % 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 120.65 .00 120.65 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 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 669 12/31/2016 December AP VFD Repair #1 Influent 6,182.00 1,597.12 7,779.12 WALKER ENGINEERING INC 2768 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55070-020-000 Independent Labor Totals: 1,597.12 7,779.12 ** 20,000.00 Budgeted 12,220.88 Remaining 39 % Used Account: 135-55080-020-000 Maintenance & Repairs 520 12/21/2016 December AP Repair of Pump #2, LS #8 6,185.03 3,705.00 9,890.03 XYLEM WATER SOLUTIONS USA INC 2684 AP 661 12/27/2016 Dec A/P THE HOME DEPOT #6581 33.89 9,923.92 THE HOME DEPOT #6581 PC 661 12/27/2016 Dec A/P THE HOME DEPOT #6581 25.35 9,949.27 THE HOME DEPOT #6581 PC 661 12/27/2016 Dec A/P WM SUPERCENTER #5247 47.04 9,996.31 WM SUPERCENTER #5247 PC 661 12/27/2016 Dec A/P CES #459 97.78 10,094.09 CES #459 PC 661 12/27/2016 Dec A/P THE HOME DEPOT #6581 132.88 10,226.97 THE HOME DEPOT #6581 PC 661 12/27/2016 Dec A/P THE HOME DEPOT #6581 128.00 10,354.97 THE HOME DEPOT #6581 PC 661 12/27/2016 Dec A/P PHONETECH & REPAIR 124.47 10,479.44 PHONETECH & REPAIR PC 630 12/31/2016 December A/P Push camera repair 12,500.00 22,979.44 CLS SEWER EQUIPMENT CO., INC 2694 AP 669 12/31/2016 December AP manhole 2,013.75 24,993.19 Ace Pipe Cleaning, Inc. 2754 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 18,808.16 24,993.19 ** 83,100.00 Budgeted 58,106.81 Remaining 30 % 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 661 12/27/2016 Dec A/P SOUTHWEST INTERNATIONA 815.87 937.59 1,753.46 SOUTHWEST INTERNATIONA PC 646 12/31/2016 Dec A/P GapVax repair 1,904.80 3,658.26 CLS SEWER EQUIPMENT CO., INC 2744 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 2,842.39 3,658.26 ** 4,000.00 Budgeted 341.74 Remaining 91 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 661 12/27/2016 Dec A/P THE HOME DEPOT #6581 23.94 23.94 THE HOME DEPOT #6581 PC _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 23.94 23.94 ** 500.00 Budgeted 476.06 Remaining 5 % Used Account: 135-55125-020-000 Dumpster Services . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 442 12/13/2016 Dec A/P Sludge haul off 8,100.59 845.00 8,945.59 L.H. CHANEY MATERIALS, INC. 2648 AP 442 12/13/2016 Dec A/P Sludge Haul off 2,798.64 11,744.23 L.H. CHANEY MATERIALS, INC. 2648 AP 630 12/31/2016 December A/P Sludge Haul Off 1,062.17 12,806.40 L.H. CHANEY MATERIALS, INC. 2701 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 4,705.81 12,806.40 ** 55,000.00 Budgeted 42,193.60 Remaining 23 % Used Account: 135-55135-020-000 Lab Analysis 442 12/13/2016 Dec A/P Testing 4,436.00 246.00 4,682.00 OXIDOR LABORATORIES LLC 2650 AP 442 12/13/2016 Dec A/P Testing 176.00 4,858.00 OXIDOR LABORATORIES LLC 2650 AP 442 12/13/2016 Dec A/P Testing 176.00 5,034.00 OXIDOR LABORATORIES LLC 2650 AP 442 12/13/2016 Dec A/P Testing 246.00 5,280.00 OXIDOR LABORATORIES LLC 2650 AP 520 12/21/2016 December AP Testing supplies 246.00 5,526.00 OXIDOR LABORATORIES LLC 2679 AP 520 12/21/2016 December AP Testing 176.00 5,702.00 OXIDOR LABORATORIES LLC 2679 AP 520 12/21/2016 December AP Testing supplies 246.00 5,948.00 OXIDOR LABORATORIES LLC 2679 AP 520 12/21/2016 December AP Testing 176.00 6,124.00 OXIDOR LABORATORIES LLC 2679 AP 630 12/31/2016 December A/P Testing 113.00 6,237.00 OXIDOR LABORATORIES LLC 2707 AP 630 12/31/2016 December A/P Testing 246.00 6,483.00 OXIDOR LABORATORIES LLC 2707 AP 630 12/31/2016 December A/P Testing 176.00 6,659.00 OXIDOR LABORATORIES LLC 2707 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,223.00 6,659.00 ** 25,000.00 Budgeted 18,341.00 Remaining 27 % Used Account: 135-60010-020-000 Communications/Mobiles 437 12/12/2016 December A/P November Cellphones 469.35 411.68 881.03 VERIZON WIRELESS 2656 AP 669 12/31/2016 December AP December Cell Phones 411.36 1,292.39 VERIZON WIRELESS 2767 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 823.04 1,292.39 ** 5,400.00 Budgeted 4,107.61 Remaining 24 % Used Account: 135-60020-020-000 Electricity 437 12/12/2016 December A/P Electricity 11/7-12/8/16 15,168.65 44.82 15,213.47 HUDSON ENERGY SERVICES, LLC 2647 AP 503 12/20/2016 December A/P Electricity 11/8-12/9 842.62 16,056.09 ENGIE Resources LLC 2672 AP 528 12/22/2016 December A/P Electricity 11/8-12/9/16 654.00 16,710.09 HUDSON ENERGY SERVICES, LLC 2685 AP 528 12/22/2016 December A/P Electricity 11/8-12-9/16 9,640.91 26,351.00 HUDSON ENERGY SERVICES, LLC 2685 AP 630 12/31/2016 December A/P Electricity 11/8-12/9/16 443.94 26,794.94 MP2 ENERGY TEXAS LLC 2704 AP 672 12/31/2016 December AP Electricity 11/28-12/27/16 153.56 26,948.50 TRI COUNTY ELECTRIC 2766 AP 672 12/31/2016 December AP Electricity 11/28-12/27/16 284.92 27,233.42 TRI COUNTY ELECTRIC 2766 AP 672 12/31/2016 December AP Electricity 11/28-12/27/16 27.56 27,260.98 TRI COUNTY ELECTRIC 2766 AP 674 12/31/2016 December AP Electricity 12/8-1/9/17 37.24 27,298.22 HUDSON ENERGY SERVICES, LLC 2759 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 674 12/31/2016 December AP Electricity 12/8-1/9/17 15,168.65 243.59 27,541.81 HUDSON ENERGY SERVICES, LLC 2759 AP 687 12/31/2016 Bill Town Inv 1538-1543 AR 20161231-20161231 User: (203.28) 27,338.53 AR _______________ Account: 135-60020-020-000 Electricity Totals: 12,169.88 27,338.53 ** 158,627.00 Budgeted 131,288.47 Remaining 17 % 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 661 12/27/2016 Dec A/P TRAINING 1,095.00 1,095.00 TRAINING PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 1,095.00 1,095.00 ** 4,195.00 Budgeted 3,100.00 Remaining 26 % Used Account: 135-60090-020-000 Safety Program 661 12/27/2016 Dec A/P SALAD BOWL 10 82.20 54.00 136.20 SALAD BOWL 10 PC 661 12/27/2016 Dec A/P RANDALLS STORE00017897 5.99 142.19 RANDALLS STORE00017897 PC _______________ Account: 135-60090-020-000 Safety Program Totals: 59.99 142.19 ** 550.00 Budgeted 407.81 Remaining 26 % Used Account: 135-60100-020-000 Travel & per diem 503 12/20/2016 December A/P Tolls to lab 83.89 43.85 127.74 NTTA 2677 AP 529 12/22/2016 December AP Tolls to lab 10.00 137.74 NTTA 2686 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 53.85 137.74 ** 1,600.00 Budgeted 1,462.26 Remaining 9 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising 4,086.37 .00 4,086.37 _______________ Account: 135-60125-020-000 Advertising Totals: .00 4,086.37 ** .00 Budgeted (4,086.37) Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 630 12/31/2016 December A/P Stormwater permit 9,910.97 200.00 10,110.97 TX COMMISSION ENVIRONMENTAL QU 2712 AP 669 12/31/2016 December AP WWTP Permit Renewal 3,800.00 13,910.97 CP&Y/WALLACE GROUP, INC. 2757 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 4,000.00 13,910.97 ** 17,150.00 Budgeted 3,239.03 Remaining 81 % 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 26 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 664 12/21/2016 Texpool Transfers 32,861.46 32,861.46 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 32,861.46 32,861.46 ** 120,492.00 Budgeted 87,630.54 Remaining 27 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 664 12/21/2016 Texpool Transfers 162,446.73 162,446.73 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 162,446.73 162,446.73 ** 595,638.00 Budgeted 433,191.27 Remaining 27 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 664 12/21/2016 Texpool Transfers 33,679.60 33,679.60 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 33,679.60 33,679.60 ** 123,492.00 Budgeted 89,812.40 Remaining 27 % 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 368 12/06/2016 December AP fuel 392.56 721.88 1,114.44 US Bank Voyager Fleet Systems 2634 AP 630 12/31/2016 December A/P Fuel 720.33 1,834.77 US Bank Voyager Fleet Systems 2713 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,442.21 1,834.77 ** 28,088.00 Budgeted 26,253.23 Remaining 7 % Used Account: 135-65010-020-000 Uniforms 661 12/27/2016 Dec A/P CAVENDERS BOOT #7 3,378.92 175.00 3,553.92 CAVENDERS BOOT #7 PC _______________ Account: 135-65010-020-000 Uniforms Totals: 175.00 3,553.92 ** 4,459.00 Budgeted 905.08 Remaining 80 % Used Account: 135-65030-020-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 9,777.29 .00 9,777.29 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 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 49.83 .00 49.83 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 49.83 ** 750.00 Budgeted 700.17 Remaining 7 % Used Account: 135-65045-020-000 Lab Supplies 520 12/21/2016 December AP Lab supplies 1,751.47 297.89 2,049.36 HACH COMPANY 2674 AP 520 12/21/2016 December AP Lab supplies 228.74 2,278.10 HACH COMPANY 2674 AP 661 12/27/2016 Dec A/P TRACTOR SUPPLY COMPANY 89.97 2,368.07 TRACTOR SUPPLY COMPANY PC 669 12/31/2016 December AP Lab supplies 1,667.30 4,035.37 IDEXX DISTRIBUTION, INC 2760 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,283.90 4,035.37 ** 14,000.00 Budgeted 9,964.63 Remaining 29 % Used Account: 135-69005-020-000 Capital Outlays 503 12/20/2016 December A/P Digester Blower 14,827.55 17,994.50 32,822.05 AIR MAC 2667 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 17,994.50 32,822.05 ** 485,000.00 Budgeted 452,177.95 Remaining 7 % Used Department 20 Totals: ----------------------------------- 527,071.62 ** 364,104.72 Monthly Total 2,698,015.00 Budgeted 2,170,943.38 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/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 462 12/01/2016 Insurance/Wrk Comp Exp Dec 5.22 2.61 7.83 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.61 7.83 ** 32.00 Budgeted 24.17 Remaining 24 % 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:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/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,132.83 ** 2.61 Monthly Total 12,882.00 Budgeted 11,749.17 Remaining 9 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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 329 12/02/2016 MUD Payroll 12/2/16 Salaries & Wages 38,562.48 14,797.26 53,359.74 PR 449 12/16/2016 MUD P/R 12/16/16 Salaries & Wages 15,464.42 68,824.16 PR 544 12/30/2016 MUD P/R 12/30/16 Salaries & Wages 15,374.59 84,198.75 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 45,636.27 84,198.75 ** 519,883.00 Budgeted 435,684.25 Remaining 16 % Used Account: 135-50010-030-000 Overtime 329 12/02/2016 MUD Payroll 12/2/16 Overtime 300.43 73.86 374.29 PR 449 12/16/2016 MUD P/R 12/16/16 Overtime 117.20 491.49 PR 544 12/30/2016 MUD P/R 12/30/16 Overtime 109.33 600.82 PR _______________ Account: 135-50010-030-000 Overtime Totals: 300.39 600.82 ** 1,000.00 Budgeted 399.18 Remaining 60 % Used Account: 135-50016-030-000 Longevity 3,417.50 .00 3,417.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,417.50 ** 3,890.00 Budgeted 472.50 Remaining 88 % Used Account: 135-50020-030-000 Retirement 329 12/02/2016 MUD Payroll 12/2/16 Retirement 3,453.65 1,298.24 4,751.89 PR 449 12/16/2016 MUD P/R 12/16/16 Retirement 1,360.26 6,112.15 PR 544 12/30/2016 MUD P/R 12/30/16 Retirement 1,351.76 7,463.91 PR _______________ Account: 135-50020-030-000 Retirement Totals: 4,010.26 7,463.91 ** 47,768.00 Budgeted 40,304.09 Remaining 16 % Used Account: 135-50026-030-000 Medical Insurance 329 12/02/2016 MUD Payroll 12/2/16 Medical Insurance 5,073.60 1,911.02 6,984.62 PR 449 12/16/2016 MUD P/R 12/16/16 Medical Insurance 1,911.03 8,895.65 PR 644 12/31/2016 Corr Med prem 8/26/16 P/R (316.10) 8,579.55 GL _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,505.95 8,579.55 ** 84,289.00 Budgeted 75,709.45 Remaining 10 % Used Account: 135-50027-030-000 Dental Insurance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 329 12/02/2016 MUD Payroll 12/2/16 Dental Insurance 361.15 138.61 499.76 PR 449 12/16/2016 MUD P/R 12/16/16 Dental Insurance 138.60 638.36 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 277.21 638.36 ** 5,981.00 Budgeted 5,342.64 Remaining 11 % Used Account: 135-50028-030-000 Vision Insurance 329 12/02/2016 MUD Payroll 12/2/16 Vision Insurance 80.95 27.01 107.96 PR 449 12/16/2016 MUD P/R 12/16/16 Vision Insurance 26.97 134.93 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 53.98 134.93 ** 1,312.00 Budgeted 1,177.07 Remaining 10 % Used Account: 135-50029-030-000 Life Insurance & Other 362 12/05/2016 December AP Metlife-December 409.28 245.53 654.81 METLIFE GROUP BENEFITS 2607 AP 503 12/20/2016 December A/P Café 125 Admin fee 27.16 681.97 BenefitMall 2669 AP 576 12/25/2016 Dec A/P Rounding adjustment (.02) 681.95 Legal Shield 2702 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 272.67 681.95 ** 5,890.00 Budgeted 5,208.05 Remaining 12 % Used Account: 135-50030-030-000 Social Security Taxes 329 12/02/2016 MUD Payroll 12/2/16 Social Security Taxes 2,342.72 884.62 3,227.34 PR 449 12/16/2016 MUD P/R 12/16/16 Social Security Taxes 921.00 4,148.34 PR 544 12/30/2016 MUD P/R 12/30/16 Social Security Taxes 959.99 5,108.33 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,765.61 5,108.33 ** 32,777.00 Budgeted 27,668.67 Remaining 16 % Used Account: 135-50035-030-000 Medicare Taxes 329 12/02/2016 MUD Payroll 12/2/16 Medicare Taxes 547.90 206.88 754.78 PR 449 12/16/2016 MUD P/R 12/16/16 Medicare Taxes 215.40 970.18 PR 544 12/30/2016 MUD P/R 12/30/16 Medicare Taxes 224.50 1,194.68 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 646.78 1,194.68 ** 8,084.00 Budgeted 6,889.32 Remaining 15 % Used Account: 135-50040-030-000 Unemployment Taxes . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 329 12/02/2016 MUD Payroll 12/2/16 Unemployment Taxes 25.06 57.00 82.06 PR 449 12/16/2016 MUD P/R 12/16/16 Unemployment Taxes 70.69 152.75 PR 544 12/30/2016 MUD P/R 12/30/16 Unemployment Taxes 68.98 221.73 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 196.67 221.73 ** 1,368.00 Budgeted 1,146.27 Remaining 16 % Used Account: 135-50045-030-000 Workman's Compensation 462 12/01/2016 Insurance/Wrk Comp Exp Dec 291.06 145.53 436.59 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 145.53 436.59 ** 1,784.00 Budgeted 1,347.41 Remaining 24 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 368 12/06/2016 December AP Pre employment testing- Wright 76.00 77.90 153.90 FIRST CHECK APPLICANT SCREENIN 2580 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 77.90 153.90 ** 500.00 Budgeted 346.10 Remaining 31 % Used Account: 135-50070-030-000 Employee Relations 418 12/09/2016 Dec A/P Christmas party @ VFW 916.23 100.00 1,016.23 TROPHY CLUB MUD PETTY CASH 2643 AP 500 12/15/2016 VFW Cleaning Deposit returned (50.00) 966.23 GL 661 12/27/2016 Dec A/P BUC-EE'S #37 108.24 1,074.47 BUC-EE'S #37 PC 661 12/27/2016 Dec A/P BUC-EE'S #37 184.00 1,258.47 BUC-EE'S #37 PC 661 12/27/2016 Dec A/P BABE'S- ROANOKE LLC 301.33 1,559.80 BABE'S- ROANOKE LLC PC 661 12/27/2016 Dec A/P TOM THUMB STOR00026096 100.00 1,659.80 TOM THUMB STOR00026096 PC 661 12/27/2016 Dec A/P RANDALLS STORE00017897 200.00 1,859.80 RANDALLS STORE00017897 PC 661 12/27/2016 Dec A/P WAL-MART #3274 100.00 1,959.80 WAL-MART #3274 PC 661 12/27/2016 Dec A/P KELLER TROPHY AND AWAR 10.00 1,969.80 KELLER TROPHY AND AWAR PC 661 12/27/2016 Dec A/P RANDALLS STORE00017897 31.30 2,001.10 RANDALLS STORE00017897 PC 661 12/27/2016 Dec A/P AMAZON MKTPLACE PMTS 51.03 2,052.13 AMAZON MKTPLACE PMTS PC 661 12/27/2016 Dec A/P WM SUPERCENTER #5247 17.97 2,070.10 WM SUPERCENTER #5247 PC 661 12/27/2016 Dec A/P RANDALLS STORE00017897 22.64 2,092.74 RANDALLS STORE00017897 PC 661 12/27/2016 Dec A/P TOGOORDER.COM 33.00 2,125.74 TOGOORDER.COM PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 1,209.51 2,125.74 ** 4,960.00 Budgeted 2,834.26 Remaining 43 % Used Account: 135-55030-030-000 Software & Support . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 374 12/06/2016 November AP Laserfish 4,519.78 4,494.94 9,014.72 MCCI 2605 AP 374 12/06/2016 November AP Emergency Notification System 3,670.00 12,684.72 Emergency Comm Network, LLC 2575 AP 479 12/16/2016 Dec A/P Internet Service/Dec 1,138.34 13,823.06 WHOLESALE CARRIER SERVICES INC 2665 AP 661 12/27/2016 Dec A/P ATT*BILL PAYMENT 159.94 13,983.00 ATT*BILL PAYMENT PC 661 12/27/2016 Dec A/P ATT*BILL PAYMENT 176.26 14,159.26 ATT*BILL PAYMENT PC 661 12/27/2016 Dec A/P ADOBE *PHOTOGPHY PLAN 119.88 14,279.14 ADOBE *PHOTOGPHY PLAN PC 661 12/27/2016 Dec A/P ADOBE *IL CREATIVE CLD 19.99 14,299.13 ADOBE *IL CREATIVE CLD PC 661 12/27/2016 Dec A/P WWW.ISTOCK.COM 53.91 14,353.04 WWW.ISTOCK.COM PC 630 12/31/2016 December A/P Software support 756.00 15,109.04 STW INC 2709 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 10,589.26 15,109.04 ** 67,791.00 Budgeted 52,681.96 Remaining 22 % Used Account: 135-55070-030-000 Independent Labor 362 12/05/2016 December AP Backflow company 41.25 595.00 636.25 SC TRACKING SOLUTIONS LLC 2619 AP 630 12/31/2016 December A/P Record MUD Meeting-December 20 78.75 715.00 MIGUEL CRUZ 2703 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 673.75 715.00 ** 12,000.00 Budgeted 11,285.00 Remaining 6 % Used Account: 135-55080-030-000 Maintenance & Repairs 503 12/20/2016 December A/P Server Room AC 275.00 275.00 BRANDON R REED 2670 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 275.00 275.00 ** 7,000.00 Budgeted 6,725.00 Remaining 4 % 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 368 12/06/2016 December AP Rug service 3,042.79 130.89 3,173.68 G & K SERVICES 2582 AP 368 12/06/2016 December AP Rug service 130.89 3,304.57 G & K SERVICES 2582 AP 630 12/31/2016 December A/P Rug service 130.89 3,435.46 G & K SERVICES 2697 AP 630 12/31/2016 December A/P Rug service 130.89 3,566.35 G & K SERVICES 2697 AP 687 12/31/2016 Bill Town Inv 1538-1543 AR 20161231-20161231 User: (130.89) 3,435.46 AR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-55100-030-000 Building Maint & Supplies Totals: 392.67 3,435.46 ** 7,000.00 Budgeted 3,564.54 Remaining 49 % Used Account: 135-55120-030-000 Cleaning Services 503 12/20/2016 December A/P Janitor Services 610.06 869.06 1,479.12 MEMBER'S BUILDING MAINTENANCE 2675 AP 687 12/31/2016 Bill Town Inv 1538-1543 AR 20161231-20161231 User: (236.00) 1,243.12 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 633.06 1,243.12 ** 10,429.00 Budgeted 9,185.88 Remaining 12 % Used 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 368 12/06/2016 December AP November Utility Billing 605.30 596.90 1,202.20 DATAPROSE LLC 2571 AP 646 12/31/2016 Dec A/P Nov/Dec billing 1,170.44 2,372.64 DATAPROSE LLC 2746 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,767.34 2,372.64 ** 8,200.00 Budgeted 5,827.36 Remaining 29 % Used Account: 135-60005-030-000 Telephone 368 12/06/2016 December AP Answering service 2,090.92 200.00 2,290.92 KEYSTONE PARK SECRETARIAL 2592 AP 661 12/27/2016 Dec A/P ATT*BUS PHONE PMT 440.74 2,731.66 ATT*BUS PHONE PMT PC 661 12/27/2016 Dec A/P ATT*BUS PHONE PMT 844.25 3,575.91 ATT*BUS PHONE PMT PC 661 12/27/2016 Dec A/P ATT*BUS PHONE PMT 441.04 4,016.95 ATT*BUS PHONE PMT PC 661 12/27/2016 Dec A/P RINGCENTRAL, INC 10.73 4,027.68 RINGCENTRAL, INC PC 630 12/31/2016 December A/P Answering service 200.00 4,227.68 KEYSTONE PARK SECRETARIAL 2699 AP 687 12/31/2016 Bill Town Inv 1538-1543 AR 20161231-20161231 User: (452.26) 3,775.42 AR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-60005-030-000 Telephone Totals: 1,684.50 3,775.42 ** 17,532.00 Budgeted 13,756.58 Remaining 22 % Used Account: 135-60010-030-000 Communications/Mobiles 437 12/12/2016 December A/P November Cellphones 337.99 37.99 375.98 VERIZON WIRELESS 2656 AP 449 12/16/2016 MUD P/R 12/16/16 Communications/Mobiles 225.00 600.98 PR 669 12/31/2016 December AP December Cell Phones 37.99 638.97 VERIZON WIRELESS 2767 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 300.98 638.97 ** 4,150.00 Budgeted 3,511.03 Remaining 15 % Used Account: 135-60020-030-000 Electricity/Gas 437 12/12/2016 December A/P Electricity 882.09 882.09 TOWN OF TROPHY CLUB 2654 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 882.09 882.09 ** 12,631.00 Budgeted 11,748.91 Remaining 7 % Used Account: 135-60025-030-000 Water 368 12/06/2016 December AP Water 10/25-11/28/16 95.26 244.40 339.66 TROPHY CLUB MUD (WATER BILLS) 2630 AP 630 12/31/2016 December A/P Water-December 198.01 537.67 TROPHY CLUB MUD (WATER BILLS) 2711 AP 687 12/31/2016 Bill Town Inv 1538-1543 AR 20161231-20161231 User: (99.00) 438.67 AR _______________ Account: 135-60025-030-000 Water Totals: 343.41 438.67 ** 1,500.00 Budgeted 1,061.33 Remaining 29 % Used Account: 135-60035-030-000 Postage 368 12/06/2016 December AP November Utility Billing 3,212.17 1,742.90 4,955.07 DATAPROSE LLC 2571 AP 630 12/31/2016 December A/P Overnight letter 8.74 4,963.81 FEDERAL EXPRESS CORP 2696 AP 646 12/31/2016 Dec A/P Nov/Dec billing 3,307.38 8,271.19 DATAPROSE LLC 2746 AP _______________ Account: 135-60035-030-000 Postage Totals: 5,059.02 8,271.19 ** 28,932.00 Budgeted 20,660.81 Remaining 29 % Used Account: 135-60040-030-000 Service Charges & Fees 693 12/01/2016 TWC Sept 2016 Quarterly 8,936.70 34.64 8,971.34 GL 331 12/02/2016 Child Support fee 1.50 8,972.84 GL 666 12/03/2016 Credit Card fees 132.40 9,105.24 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 666 12/03/2016 Credit Card fees 8,936.70 4,275.68 13,380.92 GL 450 12/16/2016 Child support fee 1.50 13,382.42 GL 545 12/30/2016 Child Support Fee 1.50 13,383.92 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,447.22 13,383.92 ** 55,560.00 Budgeted 42,176.08 Remaining 24 % 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 462 12/01/2016 Insurance/Wrk Comp Exp Dec 9,329.12 4,664.56 13,993.68 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,664.56 13,993.68 ** 55,692.00 Budgeted 41,698.32 Remaining 25 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 437 12/12/2016 December A/P annual admin fee 100.00 35.00 135.00 TX SOCIAL SECURITY PROGRAM 2655 AP 438 12/12/2016 Dec A/P Membership renewal 55.00 190.00 Costco Membership 2644 AP 438 12/12/2016 Dec A/P 2017 Dues 3,566.25 3,756.25 Texas Rural Water Assoc 2653 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 3,656.25 3,756.25 ** 6,000.00 Budgeted 2,243.75 Remaining 63 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-60079-030-000 Public Education 661 12/27/2016 Dec A/P AMAZON MKTPLACE PMTS 51.65 51.65 AMAZON MKTPLACE PMTS PC _______________ Account: 135-60079-030-000 Public Education Totals: 51.65 51.65 ** 8,754.00 Budgeted 8,702.35 Remaining 1 % 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 329 12/02/2016 MUD Payroll 12/2/16 Travel & per diem 95.85 21.73 117.58 PR 449 12/16/2016 MUD P/R 12/16/16 Travel & per diem 6.96 124.54 PR 544 12/30/2016 MUD P/R 12/30/16 Travel & per diem 55.24 179.78 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 83.93 179.78 ** 5,400.00 Budgeted 5,220.22 Remaining 3 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections .00 .00 _______________ Account: 135-60115-030-000 Elections Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 362 12/05/2016 December AP Ad for GM position 619.75 330.34 950.09 KEVIN R. CARR 2591 AP _______________ Account: 135-60125-030-000 Advertising Totals: 330.34 950.09 ** 7,500.00 Budgeted 6,549.91 Remaining 13 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-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 1,040.00 .00 1,040.00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 1,040.00 ** 2,500.00 Budgeted 1,460.00 Remaining 42 % Used Account: 135-65010-030-000 Uniforms 661 12/27/2016 Dec A/P AMAZON.COM 142.36 142.36 AMAZON.COM PC _______________ Account: 135-65010-030-000 Uniforms Totals: 142.36 142.36 ** 1,855.00 Budgeted 1,712.64 Remaining 8 % Used Account: 135-65055-030-000 Hardware 646 12/31/2016 Dec A/P S Krolczyk computer/Monitors 2,239.88 2,239.88 M3 Networks 2749 AP _______________ Account: 135-65055-030-000 Hardware Totals: 2,239.88 2,239.88 ** 9,444.00 Budgeted 7,204.12 Remaining 24 % Used Account: 135-65085-030-000 Office Supplies 437 12/12/2016 December A/P BS cards- Karl & Steven K 892.73 116.00 1,008.73 SIGMA SIGNS & PRINTING 2651 AP 437 12/12/2016 December A/P Creidt for office supplies (55.78) 952.95 OFFICE DEPOT, INC 2649 AP 437 12/12/2016 December A/P Office supplies 176.46 1,129.41 OFFICE DEPOT, INC 2649 AP 437 12/12/2016 December A/P Office supplies 202.76 1,332.17 OFFICE DEPOT, INC 2649 AP 503 12/20/2016 December A/P Office supplies 76.23 1,408.40 OFFICE DEPOT, INC 2678 AP 661 12/27/2016 Dec A/P WAL-MART #2980 20.81 1,429.21 WAL-MART #2980 PC 630 12/31/2016 December A/P Office supplies 164.39 1,593.60 OFFICE DEPOT, INC 2705 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 630 12/31/2016 December A/P Office supplies 892.73 15.11 1,608.71 OFFICE DEPOT, INC 2705 AP 630 12/31/2016 December A/P Office supplies 55.92 1,664.63 OFFICE DEPOT, INC 2705 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 771.90 1,664.63 ** 9,000.00 Budgeted 7,335.37 Remaining 18 % 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 368 12/06/2016 December AP office supplies 573.25 54.31 627.56 COSTCO WHOLESALE 2567 AP 661 12/27/2016 Dec A/P STAPLES DIRECT 15.13 642.69 STAPLES DIRECT PC 661 12/27/2016 Dec A/P SAMS INTERNET 100.54 743.23 SAMS INTERNET PC 661 12/27/2016 Dec A/P SAMSCLUB #4795 13.77 757.00 SAMSCLUB #4795 PC 661 12/27/2016 Dec A/P RANDALLS STORE00017897 3.24 760.24 RANDALLS STORE00017897 PC 661 12/27/2016 Dec A/P AMAZON MKTPLACE PMTS 52.90 813.14 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 239.89 813.14 ** 5,000.00 Budgeted 4,186.86 Remaining 16 % Used Account: 135-65105-030-000 Printing 368 12/06/2016 December AP November Utility Billing 103.50 19.50 123.00 DATAPROSE LLC 2571 AP _______________ Account: 135-65105-030-000 Printing Totals: 19.50 123.00 ** 4,800.00 Budgeted 4,677.00 Remaining 3 % Used Account: 135-69005-030-000 Capital Outlays 438 12/12/2016 Dec A/P Restroom Remodel 4,522.92 2,327.50 6,850.42 CP&Y/WALLACE GROUP, INC. 2645 AP 630 12/31/2016 December A/P Restroom remodel 1,180.03 8,030.45 STAR-TELEGRAM OPERATING LTD 2708 AP 669 12/31/2016 December AP 665.00 8,695.45 CP&Y/WALLACE GROUP, INC. 2757 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 4,172.53 8,695.45 ** 107,001.00 Budgeted 98,305.55 Remaining 8 % Used Account: 135-69170-030-000 Copier Lease Installments . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 630 12/31/2016 December A/P Copies 509.54 112.69 622.23 KYOCERA DOCUMENT SOLUTIONS 2700 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 112.69 622.23 ** 4,600.00 Budgeted 3,977.77 Remaining 14 % Used Department 30 Totals: ----------------------------------- 257,101.40 ** 102,632.51 Monthly Total 1,295,172.00 Budgeted 1,038,070.60 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/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 379 12/07/2016 Void Ck #2547, Lost in mail 360.00 (13,064.25) (12,704.25) THE LISTON LAW FIRM, P.C. 2547 AP 379 12/07/2016 Void Ck #2547, Lost in mail (8,790.00) (21,494.25) THE LISTON LAW FIRM, P.C. 2547 AP 379 12/07/2016 Void Ck #2547, Lost in mail (270.00) (21,764.25) THE LISTON LAW FIRM, P.C. 2547 AP 381 12/07/2016 Dec A/P September Legal/General 8,790.00 (12,974.25) THE LISTON LAW FIRM, P.C. 2639 AP 381 12/07/2016 Dec A/P Legal/PUC 270.00 (12,704.25) THE LISTON LAW FIRM, P.C. 2639 AP 381 12/07/2016 Dec A/P September Legal 13,064.25 360.00 THE LISTON LAW FIRM, P.C. 2639 AP 437 12/12/2016 December A/P Legal-Audit Response 840.93 1,200.93 WHITAKER CHALK SWINDLE 2657 AP 669 12/31/2016 December AP Legal 570.00 1,770.93 FREEMAN & CORBETT 2758 AP _______________ Account: 135-55045-039-000 Legal Totals: 1,410.93 1,770.93 ** 150,000.00 Budgeted 148,229.07 Remaining 1 % 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 368 12/06/2016 December AP 1st qtr DCAD Budget 2,529.84 2,045.87 4,575.71 DENTON CENTRAL APPRAISAL DISTR 2572 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,045.87 4,575.71 ** 11,115.00 Budgeted 6,539.29 Remaining 41 % Used Account: 135-55065-039-000 Tax Admin Fees 678 12/20/2016 Tax Collection fees/Denton Cty 2,561.76 2,561.76 GL _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: 2,561.76 2,561.76 ** 3,800.00 Budgeted 1,238.24 Remaining 67 % Used Department 39 Totals: ----------------------------------- 8,908.40 ** 6,018.56 Monthly Total 188,775.00 Budgeted 179,866.60 Remaining 5 % Used Fund 135 Totals: ----------------------------------- (24,040.11) 448,108.73 Monthly Total (13,456.00) Budgeted 10,584.11 Remaining 179 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (75,000.00) .00 (75,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (75,000.00) ** .00 Budgeted 75,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (156,420.00) ** .00 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (156,420.00) .00 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET DECEMBER 2016 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,282,292 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,282,292 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 927,160 TOTAL LIABILITIES 927,160 FUND BALANCE ASSIGNED FUND BALANCE 4,391,204 NET REVENUES / EXPENDITURES (1,036,072) TOTAL FUND BALANCE 3,355,132 TOTAL LIABILITIES AND FUND BALANCE 4,282,292 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 16:50 01/13/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 12/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,688.79- 4,555.71- 4,555.71 Subtotal: 1,688.79- 4,555.71- 4,555.71 Program number: 1,688.79- 4,555.71- 4,555.71 Department number: Revenues 1,688.79- 4,555.71- 4,555.71 Revenues Subtotal ----------- 1,688.79- 4,555.71- 4,555.71 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 16:50 01/13/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 12/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 1,040,627.82 1,040,627.82 1,040,627.82- Subtotal: 1,040,627.82 1,040,627.82 1,040,627.82- Program number: 1,040,627.82 1,040,627.82 1,040,627.82- Department number: Wastewater 1,040,627.82 1,040,627.82 1,040,627.82- Expenditures Subtotal ----------- 1,040,627.82 1,040,627.82 1,040,627.82- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,038,939.03 1,036,072.11 1,036,072.11- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 12/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 677 12/31/2016 Bank Interest/December (2,866.92) (1,688.79) (4,555.71) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,688.79) (4,555.71) ** .00 Budgeted 4,555.71 Remaining 0 % Used Department Totals: ----------------------------------- (4,555.71) ** (1,688.79) Monthly Total .00 Budgeted 4,555.71 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 12/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-69005-020-000 Capital Outlays 479 12/16/2016 Dec A/P WWTP Improvements APP 14 22,065.51 22,065.51 WEBBER-CADAGUA PARTNERS 2664 AP 503 12/20/2016 December A/P WWTP Improvements 46,238.26 68,303.77 CP&Y/WALLACE GROUP, INC. 2671 AP 521 12/21/2016 Recode Fund 518 CPY to 517 45,163.73 113,467.50 GL 669 12/31/2016 December AP WWTP Expansion 38,398.97 151,866.47 CP&Y/WALLACE GROUP, INC. 2757 AP 683 12/31/2016 Dec A/P WWTP Improvements App 15 888,761.35 1,040,627.82 WEBBER-CADAGUA PARTNERS 2769 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 1,040,627.82 1,040,627.82 ** .00 Budgeted (1,040,627.82) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,040,627.82 ** 1,040,627.82 Monthly Total .00 Budgeted (1,040,627.82) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,036,072.11 1,038,939.03 Monthly Total .00 Budgeted (1,036,072.11) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET DECEMBER 2016 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 691,249 TOTAL LIABILITIES 691,249 FUND BALANCE ASSIGNED FUND BALANCE 41,831 NET REVENUES / EXPENDITURES (733,080) TOTAL FUND BALANCE (691,249) TOTAL LIABILITIES AND FUND BALANCE - . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 16:50 01/13/17 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 12/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 72.08- 590.72- 590.72 Subtotal: 72.08- 590.72- 590.72 Program number: 72.08- 590.72- 590.72 Department number: Revenues 72.08- 590.72- 590.72 Revenues Subtotal ----------- 72.08- 590.72- 590.72 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 16:50 01/13/17 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 12/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 361,901.01 733,670.38 733,670.38- Subtotal: 361,901.01 733,670.38 733,670.38- Program number: 361,901.01 733,670.38 733,670.38- Department number: Wastewater 361,901.01 733,670.38 733,670.38- Expenditures Subtotal ----------- 361,901.01 733,670.38 733,670.38- Fund number: 518 2015 Revenue Bond Const Fund 361,828.93 733,079.66 733,079.66- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 12/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 486 12/16/2016 Texpool Interest/Bond Const WW (518.64) (72.08) (590.72) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (72.08) (590.72) ** .00 Budgeted 590.72 Remaining 0 % Used Department Totals: ----------------------------------- (590.72) ** (72.08) Monthly Total .00 Budgeted 590.72 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 12/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 479 12/16/2016 Dec A/P WWTP Improvements APP 14 371,769.37 406,992.66 778,762.03 WEBBER-CADAGUA PARTNERS 2664 AP 503 12/20/2016 December A/P WWTP Improvements 72.08 778,834.11 CP&Y/WALLACE GROUP, INC. 2671 AP 521 12/21/2016 Recode Fund 518 CPY to 517 (45,163.73) 733,670.38 GL _______________ Account: 518-69005-020-000 Capital Outlays Totals: 361,901.01 733,670.38 ** .00 Budgeted (733,670.38) Remaining 0 % Used Department 20 Totals: ----------------------------------- 733,670.38 ** 361,901.01 Monthly Total .00 Budgeted (733,670.38) Remaining 0 % Used Fund 518 Totals: ----------------------------------- 733,079.66 361,828.93 Monthly Total .00 Budgeted (733,079.66) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET DECEMBER 2016 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 229,650 ACCOUNTS RECEIVABLE - TOTAL ASSETS 229,650 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 195,762 NET REVENUES / EXPENDITURES 33,888 TOTAL FUND BALANCE 195,890 TOTAL LIABILITIES AND FUND BALANCE 195,890 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 16:50 01/13/17 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 12/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- 80.95- 208.75- 69.583 91.25- 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- 33,679.60- 33,679.60- 27.273 89,812.40- Subtotal: 188,712.00- 188,712.00- 33,760.55- 33,888.35- 17.958 154,823.65- Program number: 188,712.00- 188,712.00- 33,760.55- 33,888.35- 17.958 154,823.65- Department number: 188,712.00- 188,712.00- 33,760.55- 33,888.35- 17.958 154,823.65- Revenues Subtotal ----------- 188,712.00- 188,712.00- 33,760.55- 33,888.35- 17.958 154,823.65- Fund number: 528 2015 Revenue Bond Reserve Fund 188,712.00- 188,712.00- 33,760.55- 33,888.35- 17.958 154,823.65- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 12/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 677 12/31/2016 Bank Interest/December (127.80) (80.95) (208.75) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (80.95) (208.75) ** (300.00) Budgeted (91.25) Remaining 70 % 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 664 12/21/2016 Texpool Transfers (33,679.60) (33,679.60) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (33,679.60) (33,679.60) ** (123,492.00) Budgeted (89,812.40) Remaining 27 % Used Department Totals: ----------------------------------- (33,888.35) ** (33,760.55) Monthly Total (188,712.00) Budgeted (154,823.65) Remaining 18 % Used Fund 528 Totals: ----------------------------------- (33,888.35) (33,760.55) Monthly Total (188,712.00) Budgeted (154,823.65) Remaining 18 % Used TROPHY CLUB MUD #1 - SWIFT REVENUE BOND RESERVE BALANCE SHEET DECEMBER 2016 529 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 43,089 ACCOUNTS RECEIVABLE - TOTAL ASSETS 43,089 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 43,089 TOTAL FUND BALANCE 43,089 TOTAL LIABILITIES AND FUND BALANCE 43,089 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 16:50 01/13/17 Budget Summary with Amendment Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 12/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 529-49010-000-000 Interest Income 6.29- 6.29- 6.29 529-49142-000-000 Interfund transfer in-Water 43,083.00- 43,083.00- 43,083.00 Subtotal: 43,089.29- 43,089.29- 43,089.29 Program number: 43,089.29- 43,089.29- 43,089.29 Department number: 43,089.29- 43,089.29- 43,089.29 Revenues Subtotal ----------- 43,089.29- 43,089.29- 43,089.29 Fund number: 529 2016 Rev Bond Reserve-SWIFT 43,089.29- 43,089.29- 43,089.29 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 529-49010-000-000 Interest Income 677 12/31/2016 Bank Interest/December (6.29) (6.29) GL _______________ Account: 529-49010-000-000 Interest Income Totals: (6.29) (6.29) ** .00 Budgeted 6.29 Remaining 0 % Used Account: 529-49142-000-000 Interfund transfer in-Water 664 12/21/2016 Texpool Transfers (43,083.00) (43,083.00) GL _______________ Account: 529-49142-000-000 Interfund transfer in-Water Totals: (43,083.00) (43,083.00) ** .00 Budgeted 43,083.00 Remaining 0 % Used Department Totals: ----------------------------------- (43,089.29) ** (43,089.29) Monthly Total .00 Budgeted 43,089.29 Remaining 0 % Used Fund 529 Totals: ----------------------------------- (43,089.29) (43,089.29) Monthly Total .00 Budgeted 43,089.29 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET DECEMBER 2016 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 309,715 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 430,954 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 745,515 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 430,954 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 430,954 FUND BALANCE ASSIGNED FUND BALANCE 26,031 NET REVENUES / EXPENDITURES 288,530 TOTAL FUND BALANCE 314,561 TOTAL LIABILITIES AND FUND BALANCE 745,515 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 16:50 01/13/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/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- 225,718.42- 254,471.00- 37.793 418,865.00- 533-40002-000-000 Property Taxes/Delinquent 3,501.00- 3,501.00- 351.80- 902.58- 25.781 2,598.42- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 74.96- 226.17- 11.309 1,773.83- Subtotal: 678,837.00- 678,837.00- 226,145.18- 255,599.75- 37.653 423,237.25- 533-49010-000-000 Interest Income 140.00- 140.00- 49.97- 68.98- 49.271 71.02- 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- 32,861.46- 32,861.46- 27.273 87,630.54- Subtotal: 337,386.00- 337,386.00- 32,911.43- 32,930.44- 9.760 304,455.56- Program number: 1,016,223.00- 1,016,223.00- 259,056.61- 288,530.19- 28.392 727,692.81- Department number: Revenues 1,016,223.00- 1,016,223.00- 259,056.61- 288,530.19- 28.392 727,692.81- Revenues Subtotal ----------- 1,016,223.00- 1,016,223.00- 259,056.61- 288,530.19- 28.392 727,692.81- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 16:50 01/13/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/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- 259,056.61- 288,530.19- 9,337.547 285,440.19 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/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 608 12/01/2016 Property Taxes (28,752.58) (1,996.33) (30,748.91) GL 609 12/02/2016 Property Taxes (2,302.61) (33,051.52) GL 610 12/05/2016 Property Taxes (920.45) (33,971.97) GL 611 12/06/2016 Property Taxes (1,388.40) (35,360.37) GL 612 12/07/2016 Property Taxes (897.88) (36,258.25) GL 613 12/08/2016 Property Taxes (4,235.09) (40,493.34) GL 614 12/09/2016 Property Taxes (784.50) (41,277.84) GL 615 12/10/2016 Property Taxes (2,432.21) (43,710.05) GL 616 12/12/2016 Property Taxes (2,980.43) (46,690.48) GL 617 12/13/2016 Property Taxes (2,513.83) (49,204.31) GL 618 12/14/2016 Property Taxes (4,009.41) (53,213.72) GL 619 12/15/2016 Property Taxes (450.23) (53,663.95) GL 620 12/16/2016 Property Taxes (7,575.36) (61,239.31) GL 621 12/19/2016 Property Taxes (6,378.16) (67,617.47) GL 623 12/21/2016 Property Taxes (6,644.68) (74,262.15) GL 622 12/22/2016 Property Taxes (140,510.56) (214,772.71) GL 624 12/22/2016 Property Taxes (3,251.30) (218,024.01) GL 625 12/27/2016 Property Taxes (2,913.05) (220,937.06) GL 626 12/28/2016 Property Taxes (25,902.59) (246,839.65) GL 627 12/29/2016 Property Taxes (5,955.41) (252,795.06) GL 628 12/30/2016 Property Taxes (1,675.94) (254,471.00) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (225,718.42) (254,471.00) ** (673,336.00) Budgeted (418,865.00) Remaining 38 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 608 12/01/2016 Property Taxes (550.78) (3.73) (554.51) GL 610 12/05/2016 Property Taxes (42.13) (596.64) GL 619 12/15/2016 Property Taxes (4.11) (600.75) GL 623 12/21/2016 Property Taxes (166.86) (767.61) GL 626 12/28/2016 Property Taxes (47.11) (814.72) GL 627 12/29/2016 Property Taxes (87.86) (902.58) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (351.80) (902.58) ** (3,501.00) Budgeted (2,598.42) Remaining 26 % Used Account: 533-40015-000-000 Property Taxes/P & I 608 12/01/2016 Property Taxes (151.21) (1.15) (152.36) GL 610 12/05/2016 Property Taxes (9.68) (162.04) GL 619 12/15/2016 Property Taxes (.29) (162.33) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 623 12/21/2016 Property Taxes (151.21) (36.53) (198.86) GL 626 12/28/2016 Property Taxes (7.11) (205.97) GL 627 12/29/2016 Property Taxes (20.20) (226.17) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (74.96) (226.17) ** (2,000.00) Budgeted (1,773.83) Remaining 11 % Used Account: 533-49010-000-000 Interest Income 677 12/31/2016 Bank Interest/December (19.01) (49.97) (68.98) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (49.97) (68.98) ** (140.00) Budgeted (71.02) Remaining 49 % 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 664 12/21/2016 Texpool Transfers (32,861.46) (32,861.46) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (32,861.46) (32,861.46) ** (120,492.00) Budgeted (87,630.54) Remaining 27 % Used Department Totals: ----------------------------------- (288,530.19) ** (259,056.61) Monthly Total (1,016,223.00) Budgeted (727,692.81) Remaining 28 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/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: ----------------------------------- (288,530.19) (259,056.61) Monthly Total (3,090.00) Budgeted 285,440.19 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET DECEMBER 2016 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 177,583 ACCOUNTS RECEIVABLE - TOTAL ASSETS 177,583 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,097 NET REVENUES / EXPENDITURES 162,486 TOTAL FUND BALANCE 177,583 TOTAL LIABILITIES AND FUND BALANCE 177,583 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 16:50 01/13/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 12/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- 29.63- 39.55- 19.775 160.45- 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- 162,446.73- 162,446.73- 27.273 433,191.27- Subtotal: 892,849.00- 892,849.00- 162,476.36- 162,486.28- 18.199 730,362.72- Program number: 892,849.00- 892,849.00- 162,476.36- 162,486.28- 18.199 730,362.72- Department number: Revenues 892,849.00- 892,849.00- 162,476.36- 162,486.28- 18.199 730,362.72- Revenues Subtotal ----------- 892,849.00- 892,849.00- 162,476.36- 162,486.28- 18.199 730,362.72- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 16:50 01/13/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 12/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- 162,476.36- 162,486.28- ############### 162,286.28 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 12/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 677 12/31/2016 Bank Interest/December (9.92) (29.63) (39.55) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (29.63) (39.55) ** (200.00) Budgeted (160.45) Remaining 20 % 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 664 12/21/2016 Texpool Transfers (162,446.73) (162,446.73) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (162,446.73) (162,446.73) ** (595,638.00) Budgeted (433,191.27) Remaining 27 % Used Department Totals: ----------------------------------- (162,486.28) ** (162,476.36) Monthly Total (892,849.00) Budgeted (730,362.72) Remaining 18 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 12/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: ----------------------------------- (162,486.28) (162,476.36) Monthly Total (200.00) Budgeted 162,286.28 Remaining ########## TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET DECEMBER 2016 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 65,688 ACCOUNTS RECEIVABLE - TOTAL ASSETS 65,688 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 65,688 TOTAL FUND BALANCE 65,688 TOTAL LIABILITIES AND FUND BALANCE 65,688 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 16:50 01/13/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 12/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 9.58- 9.58- 9.58 535-49142-000-000 Interfund Tran In-Water Sales 65,678.61- 65,678.61- 65,678.61 Subtotal: 65,688.19- 65,688.19- 65,688.19 Program number: 65,688.19- 65,688.19- 65,688.19 Department number: Revenues 65,688.19- 65,688.19- 65,688.19 Revenues Subtotal ----------- 65,688.19- 65,688.19- 65,688.19 Fund number: 535 2016 Rev Bond I&S-SWIFT 65,688.19- 65,688.19- 65,688.19 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 16:50 01/13/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 12/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-49010-000-000 Interest Income 677 12/31/2016 Bank Interest/December (9.58) (9.58) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (9.58) (9.58) ** .00 Budgeted 9.58 Remaining 0 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 664 12/21/2016 Texpool Transfers (65,678.61) (65,678.61) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (65,678.61) (65,678.61) ** .00 Budgeted 65,678.61 Remaining 0 % Used Department Totals: ----------------------------------- (65,688.19) ** (65,688.19) Monthly Total .00 Budgeted 65,688.19 Remaining 0 % Used Fund 535 Totals: ----------------------------------- (65,688.19) (65,688.19) Monthly Total .00 Budgeted 65,688.19 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 965,648.45 **** 992,313.01 Monthly Total (205,458.00) Budgeted (1,171,106.45) Remaining ########## ******* End of Report *********