Loading...
HomeMy WebLinkAbout2016-06 June Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JUNE 2016 122 ASSETS FIRE DEPT. CASH IN BANK 91,693 INVESTMENTS 737,222 PREPAID EXPENSES 3,519 ADVALOREM PROPERTY TAXES RECEIVABLE 29,956 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE 4,978 TOTAL ASSETS 867,368 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 29,956 ACCOUNTS AND OTHER PAYABLES 43,336 TOTAL LIABILITIES 73,292 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 533,497 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 260,579 TOTAL FUND BALANCE 794,076 TOTAL LIABILITIES AND FUND BALANCE 867,368 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 10:45 07/11/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 404,346.00- 404,346.00- 371,290.86- 91.825 33,055.14- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 345.54- 345.54 122-40010-000-000 Property Taxes/MUD Fire 889,963.00- 889,963.00- 3,149.11- 870,275.55- 97.788 19,687.45- 122-40011-000-000 Property Taxes/Fire-Delinquent 7.25- 9,698.01- 9,698.01 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 109.19- 5,009.99- 111.333 509.99 Subtotal: 1,299,559.00- 1,298,809.00- 3,265.55- 1,256,619.95- 96.752 42,189.05- 122-42014-000-000 Fire Plan Review>6,000 sq ft 5,000.00- 5,000.00- 400.00- 4,800.00- 96.000 200.00- Subtotal: 5,000.00- 5,000.00- 400.00- 4,800.00- 96.000 200.00- 122-43400-000-000 Fire Inspections 825.00- 825.00- 75.00- 1,000.00- 121.212 175.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,825.00- 10,825.00- 75.00- 11,000.00- 101.617 175.00 122-49026-000-000 Proceeds from Sale of Assets 60,000.00- 60,000.00- 100.000 122-49900-000-000 Miscellaneous Income 50,000.00- 10,001.00- 800.00- 10,200.00- 101.990 199.00 Subtotal: 50,000.00- 70,001.00- 800.00- 70,200.00- 100.284 199.00 Program number: 1,365,384.00- 1,384,635.00- 4,540.55- 1,342,619.95- 96.966 42,015.05- Department number: Fire Revenues 1,365,384.00- 1,384,635.00- 4,540.55- 1,342,619.95- 96.966 42,015.05- Revenues Subtotal ----------- 1,365,384.00- 1,384,635.00- 4,540.55- 1,342,619.95- 96.966 42,015.05- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 10:45 07/11/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 508,226.00 508,226.00 39,309.24 339,135.65 66.729 169,090.35 122-50010-045-000 Overtime 48,735.00 48,735.00 4,078.32 44,665.13 91.649 4,069.87 122-50011-045-000 DPS Holiday Pay 15,852.00 15,852.00 14,717.53 92.843 1,134.47 122-50016-045-000 Longevity 5,761.00 5,761.00 5,730.00 99.462 31.00 122-50017-045-000 Certification 4,200.00 4,200.00 450.00 2,940.13 70.003 1,259.87 122-50020-045-000 Retirement 75,571.00 75,571.00 5,028.43 50,615.88 66.978 24,955.12 122-50026-045-000 Medical Insurance 65,546.00 65,546.00 4,825.62 39,909.71 60.888 25,636.29 122-50027-045-000 Dental Insurance 4,885.00 4,885.00 390.87 3,677.72 75.286 1,207.28 122-50028-045-000 Vision Insurance 859.00 859.00 71.69 734.29 85.482 124.71 122-50029-045-000 Life Insurance & Other 4,585.00 4,585.00 343.22 2,810.62 61.300 1,774.38 122-50030-045-000 Social Security Taxes 36,132.00 36,132.00 2,247.46 23,296.38 64.476 12,835.62 122-50035-045-000 Medicare Taxes 8,450.00 8,450.00 525.42 5,446.88 64.460 3,003.12 122-50040-045-000 Unemployment Taxes 1,724.00 2,000.00 36.46 2,084.86 104.243 84.86- 122-50045-045-000 Workman's Compensation 9,379.00 9,379.00 781.58 7,034.26 75.000 2,344.74 122-50060-045-000 Pre-employment Physicals/Test 250.00 250.00 54.00 21.600 196.00 Subtotal: 790,155.00 790,431.00 58,088.31 542,853.04 68.678 247,577.96 122-55030-045-000 Software & Support 6,661.00 6,661.00 462.50 4,173.31 62.653 2,487.69 122-55045-045-000 Legal 2,000.00 5,000.00 6,559.50 131.190 1,559.50- 122-55080-045-000 Maintenance & Repairs 16,370.00 25,218.00 1,480.70 20,467.27 81.161 4,750.73 122-55090-045-000 Vehicle Maintenance 10,000.00 10,000.00 1,039.09 12,718.09 127.181 2,718.09- 122-55160-045-000 Professional Outside Services 2,743.80 2,743.80- Subtotal: 35,031.00 46,879.00 2,982.29 46,661.97 99.537 217.03 122-60005-045-000 Telephone 50.00 50.00 5.53 38.57 77.140 11.43 122-60010-045-000 Communications/Mobiles 6,653.00 7,706.00 311.65 5,937.37 77.049 1,768.63 122-60020-045-000 Electricity/Gas 7,412.00 7,412.00 479.83 3,461.36 46.699 3,950.64 122-60025-045-000 Water 1,200.00 1,200.00 214.72 1,274.15 106.179 74.15- 122-60026-045-000 Cable 1,920.00 1,920.00 152.91 1,394.81 72.646 525.19 122-60030-045-000 Rent And/Or Usage 214,379.00 214,379.00 214,379.00 100.000 122-60035-045-000 Postage 50.00 50.00 17.80 25.77 51.540 24.23 122-60055-045-000 Insurance 14,077.00 18,451.00 391.50 7,897.24 42.801 10,553.76 122-60066-045-000 Publications/Books/Subscrips 350.00 350.00 172.05 49.157 177.95 122-60070-045-000 Dues & Memberships 15,582.00 15,582.00 15,456.59 99.195 125.41 122-60080-045-000 Schools & Training 7,880.00 6,880.00 670.00 3,188.39 46.343 3,691.61 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 122-60100-045-000 Travel & per diem 4,081.00 2,081.00 958.34 46.052 1,122.66 122-60110-045-000 Physicals/Testing 4,700.00 4,700.00 6,750.00 6,804.00 144.766 2,104.00- 122-60125-045-000 Advertising 500.00 4,700.00 4,200.00 89.362 500.00 122-60160-045-000 Programs & Special Projects 7,500.00 7,500.00 441.00 1,129.39 15.059 6,370.61 122-60180-045-000 Fire Inspection/Enforcement 500.00 500.00 359.29 71.858 140.71 122-60195-045-000 Flags & Repair 3,184.00 3,184.00 177.34 1,751.84 55.020 1,432.16 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 10:45 07/11/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,001.00 1,001.00 258.00 838.01 83.717 162.99 Subtotal: 292,019.00 298,646.00 9,870.28 269,266.17 90.162 29,379.83 122-65005-045-000 Fuel & Lube 15,122.00 15,122.00 490.29 3,271.69 21.635 11,850.31 122-65010-045-000 Uniforms 3,140.00 3,640.00 57.99 3,814.19 104.785 174.19- 122-65015-045-000 Protective Clothing 9,000.00 9,000.00 4,565.93 50.733 4,434.07 122-65030-045-000 Chemicals 600.00 600.00 654.00 654.00 109.000 54.00- 122-65035-045-000 Small Tools 2,000.00 2,000.00 1,862.37 93.119 137.63 122-65055-045-000 Hardware 750.00 750.00 195.42 26.056 554.58 122-65085-045-000 Office Supplies 500.00 500.00 102.50 327.54 65.508 172.46 122-65105-045-000 Printing 498.00 498.00 498.00 Subtotal: 31,610.00 32,110.00 1,304.78 14,691.14 45.753 17,418.86 122-69050-045-000 Radios 8,000.00 8,000.00 8,000.00 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 216,569.00 216,569.00 208,568.60 96.306 8,000.40 Program number: 1,365,384.00 1,384,635.00 72,245.66 1,082,040.92 78.146 302,594.08 Department number: Fire 1,365,384.00 1,384,635.00 72,245.66 1,082,040.92 78.146 302,594.08 Expenditures Subtotal ----------- 1,365,384.00 1,384,635.00 72,245.66 1,082,040.92 78.146 302,594.08 Fund number: 122 Trophy Club MUD Fire Dept. 67,705.11 260,579.03- 260,579.03 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/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 (371,290.86) .00 (371,290.86) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (371,290.86) ** (404,346.00) Budgeted (33,055.14) Remaining 92 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (345.54) .00 (345.54) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (345.54) ** .00 Budgeted 345.54 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1887 06/01/2016 Property Taxes (867,126.44) (1,419.89) (868,546.33) GL 1889 06/02/2016 Property Taxes (455.01) (869,001.34) GL 1890 06/03/2016 Property Taxes (203.98) (869,205.32) GL 1891 06/06/2016 Property Taxes (348.05) (869,553.37) GL 1893 06/07/2016 Property Taxes (105.83) (869,659.20) GL 1894 06/08/2016 Property Taxes (14.35) (869,673.55) GL 1895 06/10/2016 Property Taxes (142.22) (869,815.77) GL 1896 06/16/2016 Property Taxes (4.10) (869,819.87) GL 1897 06/17/2016 Property Taxes (15.96) (869,835.83) GL 1898 06/21/2016 Property Taxes (152.53) (869,988.36) GL 1899 06/22/2016 Property Taxes (66.22) (870,054.58) GL 1900 06/23/2016 Property Taxes (132.39) (870,186.97) GL 1901 06/29/2016 Property Taxes (88.58) (870,275.55) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,149.11) (870,275.55) ** (889,963.00) Budgeted (19,687.45) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1901 06/29/2016 Property Taxes (9,690.76) (7.25) (9,698.01) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (7.25) (9,698.01) ** .00 Budgeted 9,698.01 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1887 06/01/2016 Property Taxes (4,900.80) (.09) (4,900.89) GL 1889 06/02/2016 Property Taxes (5.86) (4,906.75) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1890 06/03/2016 Property Taxes (4,900.80) (3.42) (4,910.17) GL 1891 06/06/2016 Property Taxes (32.36) (4,942.53) GL 1893 06/07/2016 Property Taxes (2.72) (4,945.25) GL 1894 06/08/2016 Property Taxes (2.15) (4,947.40) GL 1895 06/10/2016 Property Taxes (16.10) (4,963.50) GL 1896 06/16/2016 Property Taxes (.36) (4,963.86) GL 1897 06/17/2016 Property Taxes (2.39) (4,966.25) GL 1898 06/21/2016 Property Taxes (22.89) (4,989.14) GL 1900 06/23/2016 Property Taxes (16.87) (5,006.01) GL 1901 06/29/2016 Property Taxes (3.98) (5,009.99) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (109.19) (5,009.99) ** (4,500.00) Budgeted 509.99 Remaining 111 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (4,400.00) (400.00) (4,800.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (4,800.00) ** (5,000.00) Budgeted (200.00) Remaining 96 % Used Account: 122-43400-000-000 Fire Inspections 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (925.00) (75.00) (1,000.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (1,000.00) ** (825.00) Budgeted 175.00 Remaining 121 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49026-000-000 Proceeds from Sale of Assets (60,000.00) .00 (60,000.00) _______________ Account: 122-49026-000-000 Proceeds from Sale of Assets Totals: .00 (60,000.00) ** (60,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49900-000-000 Miscellaneous Income . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (9,400.00) (800.00) (10,200.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (800.00) (10,200.00) ** (10,001.00) Budgeted 199.00 Remaining 102 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,342,619.95) ** (1,384,635.00) Budgeted (42,015.05) Remaining 97 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 1667 06/03/2016 Fire Payroll 6/3/16 299,826.41 16,062.11 315,888.52 GL 1866 06/17/2016 Fire Payroll 6/17/16 18,850.16 334,738.68 GL 1824 06/28/2016 June A/P Lasky/May, Charter 4,396.97 339,135.65 TOWN OF TROPHY CLUB 2101 AP _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 39,309.24 339,135.65 ** 508,226.00 Budgeted 169,090.35 Remaining 67 % Used Account: 122-50010-045-000 Overtime 1667 06/03/2016 Fire Payroll 6/3/16 40,586.81 4,078.32 44,665.13 GL _______________ Account: 122-50010-045-000 Overtime Totals: 4,078.32 44,665.13 ** 48,735.00 Budgeted 4,069.87 Remaining 92 % Used Account: 122-50011-045-000 DPS Holiday Pay 14,717.53 .00 14,717.53 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 14,717.53 ** 15,852.00 Budgeted 1,134.47 Remaining 93 % Used Account: 122-50016-045-000 Longevity 5,730.00 .00 5,730.00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 5,730.00 ** 5,761.00 Budgeted 31.00 Remaining 99 % Used Account: 122-50017-045-000 Certification 1667 06/03/2016 Fire Payroll 6/3/16 2,490.13 450.00 2,940.13 GL _______________ Account: 122-50017-045-000 Certification Totals: 450.00 2,940.13 ** 4,200.00 Budgeted 1,259.87 Remaining 70 % Used Account: 122-50020-045-000 Retirement 1667 06/03/2016 Fire Payroll 6/3/16 45,587.45 2,625.16 48,212.61 GL 1866 06/17/2016 Fire Payroll 6/17/16 2,403.27 50,615.88 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,028.43 50,615.88 ** 75,571.00 Budgeted 24,955.12 Remaining 67 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 1667 06/03/2016 Fire Payroll 6/3/16 35,084.09 2,771.25 37,855.34 GL 1866 06/17/2016 Fire Payroll 6/17/16 2,054.37 39,909.71 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,825.62 39,909.71 ** 65,546.00 Budgeted 25,636.29 Remaining 61 % Used Account: 122-50027-045-000 Dental Insurance 1667 06/03/2016 Fire Payroll 6/3/16 3,286.85 195.42 3,482.27 GL 1866 06/17/2016 Fire Payroll 6/17/16 195.45 3,677.72 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 390.87 3,677.72 ** 4,885.00 Budgeted 1,207.28 Remaining 75 % Used Account: 122-50028-045-000 Vision Insurance 1667 06/03/2016 Fire Payroll 6/3/16 662.60 35.82 698.42 GL 1866 06/17/2016 Fire Payroll 6/17/16 35.87 734.29 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 71.69 734.29 ** 859.00 Budgeted 124.71 Remaining 85 % Used Account: 122-50029-045-000 Life Insurance & Other 1667 06/03/2016 Fire Payroll 6/3/16 2,467.40 171.60 2,639.00 GL 1866 06/17/2016 Fire Payroll 6/17/16 171.62 2,810.62 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 343.22 2,810.62 ** 4,585.00 Budgeted 1,774.38 Remaining 61 % Used Account: 122-50030-045-000 Social Security Taxes 1667 06/03/2016 Fire Payroll 6/3/16 21,048.92 1,177.66 22,226.58 GL 1866 06/17/2016 Fire Payroll 6/17/16 1,069.80 23,296.38 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,247.46 23,296.38 ** 36,132.00 Budgeted 12,835.62 Remaining 64 % Used Account: 122-50035-045-000 Medicare Taxes 1667 06/03/2016 Fire Payroll 6/3/16 4,921.46 275.29 5,196.75 GL 1866 06/17/2016 Fire Payroll 6/17/16 250.13 5,446.88 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-50035-045-000 Medicare Taxes Totals: 525.42 5,446.88 ** 8,450.00 Budgeted 3,003.12 Remaining 64 % Used Account: 122-50040-045-000 Unemployment Taxes 1667 06/03/2016 Fire Payroll 6/3/16 2,048.40 21.03 2,069.43 GL 1866 06/17/2016 Fire Payroll 6/17/16 15.43 2,084.86 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 36.46 2,084.86 ** 2,000.00 Budgeted (84.86) Remaining 104 % Used Account: 122-50045-045-000 Workman's Compensation 1761 06/01/2016 Breakout Fire W/C from Ins 6,252.68 781.58 7,034.26 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 781.58 7,034.26 ** 9,379.00 Budgeted 2,344.74 Remaining 75 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 54.00 .00 54.00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 54.00 ** 250.00 Budgeted 196.00 Remaining 22 % Used Account: 122-55030-045-000 Software & Support 1824 06/28/2016 June A/P Lasky/May, Charter 3,710.81 462.50 4,173.31 TOWN OF TROPHY CLUB 2101 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 4,173.31 ** 6,661.00 Budgeted 2,487.69 Remaining 63 % Used Account: 122-55045-045-000 Legal 6,559.50 .00 6,559.50 _______________ Account: 122-55045-045-000 Legal Totals: .00 6,559.50 ** 5,000.00 Budgeted (1,559.50) Remaining 131 % Used Account: 122-55080-045-000 Maintenance & Repairs 1871 06/27/2016 June A/P LONE STAR SAFETY & SUP 18,986.57 93.00 19,079.57 LONE STAR SAFETY & SUP PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1871 06/27/2016 June A/P SAMS CLUB #4795 18,986.57 343.87 19,423.44 SAMS CLUB #4795 PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 92.67 19,516.11 THE HOME DEPOT 6581 PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 640.48 20,156.59 THE HOME DEPOT 6581 PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 60.84 20,217.43 THE HOME DEPOT 6581 PC 1871 06/27/2016 June A/P WAL-MART #5247 42.60 20,260.03 WAL-MART #5247 PC 1824 06/28/2016 June A/P Door repair/Fire Station 170.00 20,430.03 OVERHEAD DOOR FORT WORTH 2087 AP 1868 06/30/2016 June A/P Rug Service FD 37.24 20,467.27 G & K SERVICES 2061 AP 1868 06/30/2016 June A/P Rug Service FD 37.24 20,504.51 G & K SERVICES 2061 AP 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (37.24) 20,467.27 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,480.70 20,467.27 ** 25,218.00 Budgeted 4,750.73 Remaining 81 % Used Account: 122-55090-045-000 Vehicle Maintenance 1871 06/27/2016 June A/P WM SUPERCENTER #5247 11,679.00 50.63 11,729.63 WM SUPERCENTER #5247 PC 1827 06/29/2016 June A/P E681 Repairs to steering 988.46 12,718.09 SIDDONS-MARTIN EMERGENCY GROUP 2094 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 1,039.09 12,718.09 ** 10,000.00 Budgeted (2,718.09) Remaining 127 % Used Account: 122-55160-045-000 Professional Outside Services 2,743.80 .00 2,743.80 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 2,743.80 ** .00 Budgeted (2,743.80) Remaining 0 % Used Account: 122-60005-045-000 Telephone 1871 06/27/2016 June A/P ATT*BUS PHONE PMT 33.04 5.53 38.57 ATT*BUS PHONE PMT PC _______________ Account: 122-60005-045-000 Telephone Totals: 5.53 38.57 ** 50.00 Budgeted 11.43 Remaining 77 % Used Account: 122-60010-045-000 Communications/Mobiles 1667 06/03/2016 Fire Payroll 6/3/16 5,625.72 75.00 5,700.72 GL 1857 06/30/2016 June A/P Shi,Mercury,Verizon 82.50 5,783.22 TOWN OF TROPHY CLUB 2101 AP 1857 06/30/2016 June A/P Shi,Mercury,Verizon 154.15 5,937.37 TOWN OF TROPHY CLUB 2101 AP _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 311.65 5,937.37 ** 7,706.00 Budgeted 1,768.63 Remaining 77 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-60020-045-000 Electricity/Gas 1779 06/20/2016 June A/P Electricity 5/10-6/9/16 2,981.53 894.22 3,875.75 HUDSON ENERGY SERVICES, LLC 2023 AP 1781 06/20/2016 Void A/P Ck2023/Hudson Electricity 5/10-6/9/16 (894.22) 2,981.53 HUDSON ENERGY SERVICES, LLC 2023 AP 1782 06/20/2016 June A/P Electricity 5/10-6/9/16 894.22 3,875.75 HUDSON ENERGY SERVICES, LLC 2030 AP 1910 06/30/2016 June A/P Gas FD 5/19-6/15/16 65.44 3,941.19 ATMOS ENERGY AP 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (479.83) 3,461.36 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 479.83 3,461.36 ** 7,412.00 Budgeted 3,950.64 Remaining 47 % Used Account: 122-60025-045-000 Water 1864 06/30/2016 June A/P June Water 1,059.43 429.43 1,488.86 TROPHY CLUB MUD (WATER BILLS) 2102 AP 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (214.71) 1,274.15 AR _______________ Account: 122-60025-045-000 Water Totals: 214.72 1,274.15 ** 1,200.00 Budgeted (74.15) Remaining 106 % Used Account: 122-60026-045-000 Cable 1829 06/17/2016 Firefighters Assoc/Cable 1,241.90 (128.76) 1,113.14 GL 1871 06/27/2016 June A/P ATT*BILL PAYMENT 152.91 1,266.05 ATT*BILL PAYMENT PC 1871 06/27/2016 June A/P ATT*BILL PAYMENT 128.76 1,394.81 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 152.91 1,394.81 ** 1,920.00 Budgeted 525.19 Remaining 73 % Used Account: 122-60030-045-000 Rent And/Or Usage 214,379.00 .00 214,379.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 214,379.00 ** 214,379.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 1871 06/27/2016 June A/P UPS*1ZE54N7T0395007616 7.97 8.90 16.87 UPS*1ZE54N7T0395007616 PC 1871 06/27/2016 June A/P UPS*1ZE4D42T0395028011 8.90 25.77 UPS*1ZE4D42T0395028011 PC _______________ Account: 122-60035-045-000 Postage Totals: 17.80 25.77 ** 50.00 Budgeted 24.23 Remaining 52 % Used Account: 122-60055-045-000 Insurance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 140 06/01/2016 Prepaid Insurance, W/C Jun 7,505.74 1,173.08 8,678.82 GL 1761 06/01/2016 Breakout Fire W/C from Ins (781.58) 7,897.24 GL _______________ Account: 122-60055-045-000 Insurance Totals: 391.50 7,897.24 ** 18,451.00 Budgeted 10,553.76 Remaining 43 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 172.05 .00 172.05 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 172.05 ** 350.00 Budgeted 177.95 Remaining 49 % Used Account: 122-60070-045-000 Dues & Memberships 15,456.59 .00 15,456.59 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 15,456.59 ** 15,582.00 Budgeted 125.41 Remaining 99 % Used Account: 122-60080-045-000 Schools & Training 1824 06/28/2016 June A/P Vehicle & Machinery Rescue/Har 2,518.39 335.00 2,853.39 TARRANT COUNTY COLLEGE 2097 AP 1824 06/28/2016 June A/P Vehicle & Machinery Rescue tra 335.00 3,188.39 TARRANT COUNTY COLLEGE 2097 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 670.00 3,188.39 ** 6,880.00 Budgeted 3,691.61 Remaining 46 % Used Account: 122-60096-045-000 Emergency Management .00 .00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-60100-045-000 Travel & per diem 958.34 .00 958.34 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 958.34 ** 2,081.00 Budgeted 1,122.66 Remaining 46 % Used Account: 122-60110-045-000 Physicals/Testing . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1824 06/28/2016 June A/P Physicals/Testing 54.00 6,750.00 6,804.00 TEXAS HEALTH HUGULEY INC 2098 AP _______________ Account: 122-60110-045-000 Physicals/Testing Totals: 6,750.00 6,804.00 ** 4,700.00 Budgeted (2,104.00) Remaining 145 % Used Account: 122-60125-045-000 Advertising 4,200.00 .00 4,200.00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 4,200.00 ** 4,700.00 Budgeted 500.00 Remaining 89 % Used Account: 122-60160-045-000 Programs & Special Projects 1871 06/27/2016 June A/P ECHO TRANSPORTATION 688.39 441.00 1,129.39 ECHO TRANSPORTATION PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 441.00 1,129.39 ** 7,500.00 Budgeted 6,370.61 Remaining 15 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 359.29 .00 359.29 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 359.29 ** 500.00 Budgeted 140.71 Remaining 72 % Used Account: 122-60195-045-000 Flags & Repair 1824 06/28/2016 June A/P 3x5' flag 1,574.50 28.00 1,602.50 SYMONDS FLAGS & POLES 2096 AP 1824 06/28/2016 June A/P Flag Repair 170.00 1,772.50 SYMONDS FLAGS & POLES 2096 AP 1907 06/30/2016 June A/P Flag pole repair 156.67 1,929.17 DENNIS SERVICES LLC AP 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (177.33) 1,751.84 AR _______________ Account: 122-60195-045-000 Flags & Repair Totals: 177.34 1,751.84 ** 3,184.00 Budgeted 1,432.16 Remaining 55 % Used Account: 122-60245-045-000 Miscellaneous Expense 1871 06/27/2016 June A/P VINNYS ITALIAN RESTAUR 580.01 23.00 603.01 VINNYS ITALIAN RESTAUR PC 1871 06/27/2016 June A/P ACTIVE911 INC 235.00 838.01 ACTIVE911 INC PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 258.00 838.01 ** 1,001.00 Budgeted 162.99 Remaining 84 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/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-65005-045-000 Fuel & Lube 1824 06/28/2016 June A/P Fuel 5/25-6/24/16 2,781.40 490.29 3,271.69 US Bank Voyager Fleet Systems 2103 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 490.29 3,271.69 ** 15,122.00 Budgeted 11,850.31 Remaining 22 % Used Account: 122-65010-045-000 Uniforms 1824 06/28/2016 June A/P Uniforms 3,756.20 115.98 3,872.18 RED THE UNIFORM TAILOR 2092 AP 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (57.99) 3,814.19 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 57.99 3,814.19 ** 3,640.00 Budgeted (174.19) Remaining 105 % Used Account: 122-65015-045-000 Protective Clothing 4,565.93 .00 4,565.93 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 4,565.93 ** 9,000.00 Budgeted 4,434.07 Remaining 51 % Used Account: 122-65030-045-000 Chemicals 1824 06/28/2016 June A/P Foam for E681 654.00 654.00 CASCO INDUSTRIES INC 2056 AP _______________ Account: 122-65030-045-000 Chemicals Totals: 654.00 654.00 ** 600.00 Budgeted (54.00) Remaining 109 % Used Account: 122-65035-045-000 Small Tools 1,862.37 .00 1,862.37 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 1,862.37 ** 2,000.00 Budgeted 137.63 Remaining 93 % Used Account: 122-65055-045-000 Hardware 195.42 .00 195.42 _______________ Account: 122-65055-045-000 Hardware Totals: .00 195.42 ** 750.00 Budgeted 554.58 Remaining 26 % Used Account: 122-65085-045-000 Office Supplies . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1857 06/30/2016 June A/P Shi,Mercury,Verizon 225.04 102.50 327.54 TOWN OF TROPHY CLUB 2101 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 102.50 327.54 ** 500.00 Budgeted 172.46 Remaining 66 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 498.00 Budgeted 498.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 8,000.00 Budgeted 8,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 1,082,040.92 ** 1,384,635.00 Budgeted 302,594.08 Remaining 78 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (260,579.03) .00 Budgeted 260,579.03 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JUNE 2016 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 6/30/16 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK-CHECKING 359,310 - - 359,310 CASH IN BANK-SAVINGS-CASH RESERVE 180,074 - - 180,074 CD-BANK OF THE WEST/THB DEPOSIT 35,158 - - 35,158 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,511,664 - - 1,511,664 INVESTMENTS-TEXPOOL 873,696 326,020 - 1,199,716 PREPAID EXPENSES 18,224 - - 18,224 ADVALOREM PROPERTY TAXES RECEIVABLE 3,094 - - 3,094 UTILITY AND OTHER ACCOUNTS RECEIVABLE 659,554 - - 659,554 TOTAL ASSETS 3,641,374 326,020 - 3,967,394 LIABILITIES AND FUND BALANCELIABILITIESDEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,094 - - 3,094 ACCOUNTS AND OTHER PAYABLES 760,225 - - 760,225 CUSTOMER DEPOSITS 316,510 - - 316,510 - TOTAL LIABILITIES 1,079,829 - - 1,079,829 FUND BALANCEDESIGNATED FOR FUTURE ASSET REPLACEMENT - 326,020 326,020 NON-SPENDABLE FUND BALANCE 30,686 30,686 ASSIGNED FUND BALANCE 195,000 - 195,000 UNASSIGNED FUND BALANCE 2,026,779 - 8,032 2,034,811 COMMITTED FUND BALANCE 892,901 - - 892,901 NET REVENUES / EXPENDITURES (583,821) - (8,032) (591,853) - TOTAL FUND BALANCE 2,561,545 326,020 - 2,887,565 - TOTAL LIABILITIES AND FUND BALANCE 3,641,374 326,020 - 3,967,394 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 10:45 07/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 58,181.00- 58,181.00- 205.83- 56,877.61- 97.760 1,303.39- 135-40002-000-000 Property Taxes/Delinquent 1.40- 1,274.86- 1,274.86 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 7.34- 498.83- 76.743 151.17- 135-40025-000-000 PID Surcharges 146,125.00- 146,125.00- 146,125.00- Subtotal: 204,956.00- 204,956.00- 214.57- 58,651.30- 28.617 146,304.70- 135-47000-000-000 Water 5,080,244.00- 5,080,244.00- 330,929.34- 2,537,934.17- 49.957 2,542,309.83- 135-47005-000-000 Sewer 2,413,776.00- 2,413,776.00- 203,221.54- 1,575,870.01- 65.287 837,905.99- 135-47025-000-000 Penalties 90,985.00- 90,985.00- 5,379.65- 71,465.31- 78.546 19,519.69- 135-47030-000-000 Service Charges 9,000.00- 9,000.00- 850.00- 10,675.00- 118.611 1,675.00 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 150.00- 2,100.00- 105.000 100.00 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 450.00- 6,150.00- 111.818 650.00 135-47070-000-000 TCCC Effluent Charges 61,330.00- 61,330.00- 796.45- 12,542.45- 20.451 48,787.55- Subtotal: 7,662,835.00- 7,662,835.00- 541,776.98- 4,216,736.94- 55.028 3,446,098.06- 135-48005-000-000 Utility Fees 69,000.00- 55,200.00- 55,200.00- 100.000 Subtotal: 69,000.00- 55,200.00- 55,200.00- 100.000 135-49010-000-000 Interest Income 6,000.00- 10,000.00- 1,185.67- 9,427.54- 94.275 572.46- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 8,194.77- 75.002 2,731.23- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,249.97- 75.000 1,750.03- 135-49026-000-000 Proceeds from Sale of Assets 30,935.00- 30,935.00- 100.000 135-49035-000-000 Prior Year Reserves 8,020.00- 548,668.00- 548,668.00- 135-49075-000-000 Oversize Meter Reimbursement 15,778.00- 15,778.00- 1,715.00- 43,961.42- 278.625 28,183.42 135-49141-000-000 Interfund Transfer In 8,034.36- 8,034.36 135-49900-000-000 Miscellaneous Income 63,249.00- 63,249.00- 24,258.69- 28,743.52- 45.445 34,505.48- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 28.40- 142.000 8.40 Subtotal: 110,993.00- 686,576.00- 28,653.22- 134,574.98- 19.601 552,001.02- Program number: 8,047,784.00- 8,609,567.00- 570,644.77- 4,465,163.22- 51.863 4,144,403.78- Department number: Revenues 8,047,784.00- 8,609,567.00- 570,644.77- 4,465,163.22- 51.863 4,144,403.78- Revenues Subtotal ----------- 8,047,784.00- 8,609,567.00- 570,644.77- 4,465,163.22- 51.863 4,144,403.78- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 10:45 07/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 265,614.00 260,062.00 16,922.81 151,273.36 58.168 108,788.64 135-50010-010-000 Overtime 19,500.00 19,500.00 940.53 10,029.91 51.435 9,470.09 135-50016-010-000 Longevity 2,945.00 2,945.00 2,945.00 100.000 135-50017-010-000 Certification 4,200.00 3,600.00 200.00 1,725.00 47.917 1,875.00 135-50020-010-000 Retirement 25,558.00 25,018.00 1,576.93 14,594.57 58.336 10,423.43 135-50026-010-000 Medical Insurance 51,398.00 51,398.00 3,161.15 27,943.21 54.366 23,454.79 135-50027-010-000 Dental Insurance 3,999.00 3,999.00 240.77 2,102.41 52.573 1,896.59 135-50028-010-000 Vision Insurance 910.00 910.00 53.98 473.18 51.998 436.82 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 200.95 1,758.57 62.739 1,044.43 135-50030-010-000 Social Security Taxes 18,565.00 18,146.00 1,109.88 10,206.90 56.249 7,939.10 135-50035-010-000 Medicare Taxes 4,341.00 4,243.00 259.57 2,387.08 56.259 1,855.92 135-50040-010-000 Unemployment Taxes 1,242.00 1,026.00 859.06 83.729 166.94 135-50045-010-000 Workman's Compensation 14,754.00 14,754.00 1,229.35 8,749.63 59.303 6,004.37 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 236.45 18.188 1,063.55 135-50070-010-000 Employee Relations 300.00 300.00 75.22 25.073 224.78 Subtotal: 417,429.00 410,004.00 25,895.92 235,359.55 57.404 174,644.45 135-55005-010-000 Engineering 5,000.00 109,400.00 7,500.00 48,920.60 44.717 60,479.40 135-55080-010-000 Maintenance & Repairs 85,000.00 99,500.00 90.40- 67,907.36 68.249 31,592.64 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 419.00 3,559.69 44.496 4,440.31 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 2,892.77 82.651 607.23 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 270.00 3,006.87 54.670 2,493.13 Subtotal: 107,000.00 225,900.00 8,098.60 126,287.29 55.904 99,612.71 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 450.49 3,328.52 61.639 2,071.48 135-60020-010-000 Electricity 166,823.00 166,823.00 9,913.64 88,486.63 53.042 78,336.37 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 716.00 716.00 143.200 216.00- 135-60070-010-000 Dues & Memberships 500.00 500.00 11.00 2.200 489.00 135-60080-010-000 Schools & Training 5,773.00 5,773.00 252.00 1,520.00 26.329 4,253.00 135-60090-010-000 Safety Program 400.00 400.00 248.97 62.243 151.03 135-60100-010-000 Travel & per diem 1,400.00 1,400.00 87.09 6.221 1,312.91 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 324.64 21.643 1,175.36 135-60135-010-000 TCEQ Fees & Permits 49,275.00 49,275.00 13,175.00 26.738 36,100.00 135-60150-010-000 Wholesale Water 2,948,742.00 2,948,742.00 137,264.77 1,150,441.19 39.015 1,798,300.81 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 36.99 2,280.63 65.161 1,219.37 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 3,186,763.00 3,186,763.00 148,633.89 1,260,619.67 39.558 1,926,143.33 135-65005-010-000 Fuel & Lube 35,947.00 35,947.00 1,179.85 10,169.60 28.291 25,777.40 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 10:45 07/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 4,608.00 4,608.00 2,006.73 43.549 2,601.27 135-65030-010-000 Chemicals 12,000.00 13,000.00 1,540.83 9,909.31 76.225 3,090.69 135-65035-010-000 Small Tools 1,200.00 1,200.00 129.55 10.796 1,070.45 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 443.49 44.349 556.51 135-65050-010-000 Meter Expense 115,000.00 115,000.00 4,368.00 96,803.34 84.177 18,196.66 135-65053-010-000 Meter Change Out Program 50,000.00 77,325.00 77,325.00 100.000 Subtotal: 219,755.00 248,080.00 7,088.68 196,787.02 79.324 51,292.98 135-69005-010-000 Capital Outlays 201,000.00 400,250.00 339,615.98 84.851 60,634.02 135-69008-010-000 Short Term Debt-Principal 130,720.00 130,720.00 130,700.34 99.985 19.66 135-69009-010-000 Short Term Debt-Interest 1,209.00 1,209.00 1,177.54 97.398 31.46 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 126,958.00 126,958.00 126,957.75 100.000 .25 Subtotal: 534,887.00 734,137.00 673,451.61 91.734 60,685.39 Program number: 4,465,834.00 4,804,884.00 189,717.09 2,492,505.14 51.874 2,312,378.86 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 10:45 07/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 80.00 1,197.74 23.955 3,802.26 Subtotal: 5,000.00 5,000.00 80.00 1,197.74 23.955 3,802.26 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 80.00 1,197.74 11.977 8,802.26 Department number: Water 4,475,834.00 4,814,884.00 189,797.09 2,493,702.88 51.792 2,321,181.12 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 10:45 07/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 351,671.00 351,671.00 28,843.30 253,937.03 72.209 97,733.97 135-50010-020-000 Overtime 19,500.00 29,500.00 2,156.32 24,904.35 84.422 4,595.65 135-50016-020-000 Longevity 6,125.00 6,125.00 6,125.00 100.000 135-50017-020-000 Certification 7,200.00 7,200.00 675.00 5,525.00 76.736 1,675.00 135-50020-020-000 Retirement 33,652.00 33,652.00 2,765.20 25,535.42 75.881 8,116.58 135-50026-020-000 Medical Insurance 65,989.00 65,989.00 5,531.97 47,328.63 71.722 18,660.37 135-50027-020-000 Dental Insurance 4,184.00 4,184.00 347.91 2,902.08 69.361 1,281.92 135-50028-020-000 Vision Insurance 972.00 972.00 78.05 656.95 67.587 315.05 135-50029-020-000 Life Insurance & Other 3,655.00 3,655.00 354.95 3,050.84 83.470 604.16 135-50030-020-000 Social Security Taxes 24,665.00 24,665.00 1,765.36 16,381.11 66.414 8,283.89 135-50035-020-000 Medicare Taxes 5,768.00 5,768.00 412.86 3,831.03 66.419 1,936.97 135-50040-020-000 Unemployment Taxes 1,449.00 1,204.00 1,203.57 99.964 .43 135-50045-020-000 Workman's Compensation 9,317.00 9,317.00 776.43 4,673.38 50.160 4,643.62 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 238.45 79.483 61.55 135-50070-020-000 Employee Relations 650.00 650.00 52.03 419.81 64.586 230.19 Subtotal: 535,097.00 544,852.00 43,759.38 396,712.65 72.811 148,139.35 135-55070-020-000 Independent Labor 50,000.00 50,000.00 3,421.95 24,133.45 48.267 25,866.55 135-55080-020-000 Maintenance & Repairs 72,600.00 83,100.00 7,715.03 79,861.18 96.103 3,238.82 135-55090-020-000 Vehicle Maintenance 5,000.00 7,500.00 1,380.17 6,182.00 82.427 1,318.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 291.00 58.200 209.00 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 3,042.00 28,624.82 52.045 26,375.18 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 1,477.00 27,711.40 79.175 7,288.60 Subtotal: 218,100.00 231,100.00 17,036.15 166,803.85 72.178 64,296.15 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 412.00 4,239.62 78.511 1,160.38 135-60020-020-000 Electricity 161,582.00 161,582.00 10,433.55 81,179.04 50.240 80,402.96 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 400.00 135-60070-020-000 Dues & Memberships 300.00 300.00 200.00 66.667 100.00 135-60080-020-000 Schools & Training 3,771.00 3,771.00 64.00 2,417.00 64.094 1,354.00 135-60090-020-000 Safety Program 550.00 550.00 44.00 340.67 61.940 209.33 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 744.79 46.549 855.21 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 4,588.50 50.983 4,411.50 135-60135-020-000 TCEQ Fees & Permits 37,150.00 37,150.00 14,578.74 39.243 22,571.26 135-60245-020-000 Miscellaneous Expenses 297.00 297.00 423.24 142.505 126.24- 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 119,706.00 119,706.00 19,951.00 79,804.00 66.667 39,902.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 444,831.00 444,831.00 43,220.32 358,396.88 80.569 86,434.12 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 92,502.00 75.000 30,834.00 Subtotal: 908,423.00 908,423.00 74,124.87 639,414.48 70.387 269,008.52 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 10:45 07/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 32,021.00 32,021.00 793.77 7,953.10 24.837 24,067.90 135-65010-020-000 Uniforms 4,241.00 4,241.00 109.99 2,733.51 64.454 1,507.49 135-65030-020-000 Chemicals 27,000.00 27,000.00 21,183.25 78.456 5,816.75 135-65035-020-000 Small Tools 2,000.00 2,000.00 495.52 867.41 43.371 1,132.59 135-65040-020-000 Safety Equipment 750.00 750.00 576.59 76.879 173.41 135-65045-020-000 Lab Supplies 13,000.00 13,000.00 437.06 13,441.15 103.393 441.15- Subtotal: 79,012.00 79,012.00 1,836.34 46,755.01 59.175 32,256.99 135-69005-020-000 Capital Outlays 150,000.00 356,000.00 269,447.28 75.687 86,552.72 135-69008-020-000 Short Term Debt-Principal 21,280.00 21,280.00 21,276.80 99.985 3.20 135-69009-020-000 Short Term Debt-Interest 197.00 197.00 197.00 100.000 Subtotal: 171,477.00 377,477.00 290,921.08 77.070 86,555.92 Program number: 1,912,109.00 2,140,864.00 136,756.74 1,540,607.07 71.962 600,256.93 Department number: Wastewater 1,912,109.00 2,140,864.00 136,756.74 1,540,607.07 71.962 600,256.93 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 10:45 07/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 12,500.00 12,500.00 400.00 5,600.00 44.800 6,900.00 135-50030-026-000 Social Security Taxes 775.00 775.00 24.80 347.20 44.800 427.80 135-50035-026-000 Medicare Taxes 181.00 181.00 5.80 81.20 44.862 99.80 135-50040-026-000 Unemployment Taxes 230.00 12.00 35.70 297.500 23.70- 135-50045-026-000 Workman's Compensation 37.00 50.00 3.08 40.73 81.460 9.27 Subtotal: 13,723.00 13,518.00 433.68 6,104.83 45.161 7,413.17 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 10.98 2.196 489.02 135-60075-026-000 Meetings 1,200.00 1,200.00 21.67 1.806 1,178.33 135-60080-026-000 Schools & Training 4,000.00 4,000.00 970.00 1,875.00 46.875 2,125.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,448.94 3,051.37 61.027 1,948.63 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 219.88 10.994 1,780.12 Subtotal: 12,850.00 12,850.00 2,418.94 5,178.90 40.303 7,671.10 Program number: 26,573.00 26,368.00 2,852.62 11,283.73 42.793 15,084.27 Department number: Board of Directors 26,573.00 26,368.00 2,852.62 11,283.73 42.793 15,084.27 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 10:45 07/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 488,508.00 493,633.00 37,863.73 340,818.60 69.043 152,814.40 135-50010-030-000 Overtime 1,000.00 500.00 8.16 491.15 98.230 8.85 135-50016-030-000 Longevity 3,823.00 3,823.00 3,822.50 99.987 .50 135-50020-030-000 Retirement 43,202.00 43,652.00 3,306.21 30,344.99 69.516 13,307.01 135-50026-030-000 Medical Insurance 68,196.00 68,196.00 5,089.43 46,306.66 67.902 21,889.34 135-50027-030-000 Dental Insurance 4,807.00 4,807.00 340.87 3,182.65 66.209 1,624.35 135-50028-030-000 Vision Insurance 1,114.00 1,114.00 81.20 736.53 66.116 377.47 135-50029-030-000 Life Insurance & Other 4,431.00 5,431.00 397.16 3,517.75 64.772 1,913.25 135-50030-030-000 Social Security Taxes 30,823.00 31,141.00 2,192.54 19,913.99 63.948 11,227.01 135-50035-030-000 Medicare Taxes 7,599.00 7,678.00 512.77 4,657.29 60.658 3,020.71 135-50040-030-000 Unemployment Taxes 1,449.00 1,197.00 1,197.00 100.000 135-50045-030-000 Workman's Compensation 1,554.00 1,554.00 147.89 1,623.01 104.441 69.01- 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 5,000.00 4,500.00 71.09 3,100.95 68.910 1,399.05 Subtotal: 662,006.00 667,726.00 50,011.05 459,713.07 68.848 208,012.93 135-55030-030-000 Software & Support 78,483.00 81,097.00 1,120.77 37,028.22 45.659 44,068.78 135-55070-030-000 Independent Labor 12,000.00 12,000.00 149.25 1,288.63 10.739 10,711.37 135-55080-030-000 Maintenance & Repairs 29,500.00 7,000.00 6,088.35 86.976 911.65 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 1,428.17 6,376.87 91.098 623.13 135-55120-030-000 Cleaning Services 10,125.00 10,125.00 584.75 4,419.00 43.644 5,706.00 135-55160-030-000 Professional Outside Services 61,075.00 72,575.00 4,972.50 58,045.00 79.979 14,530.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,165.00 6,127.21 74.722 2,072.79 Subtotal: 206,583.00 198,197.00 9,420.44 119,373.28 60.230 78,823.72 135-60005-030-000 Telephone 16,349.00 16,349.00 404.19 9,495.96 58.083 6,853.04 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 337.99 3,139.32 75.646 1,010.68 135-60020-030-000 Electricity/Gas 10,768.00 10,768.00 788.09 5,449.19 50.605 5,318.81 135-60025-030-000 Water 1,500.00 1,500.00 57.39 633.95 42.263 866.05 135-60035-030-000 Postage 28,932.00 28,932.00 2,866.25 18,668.20 64.524 10,263.80 135-60040-030-000 Service Charges & Fees 44,000.00 55,560.00 3,166.88 40,549.41 72.983 15,010.59 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 1,007.27 3,022.62 86.361 477.38 135-60055-030-000 Insurance 52,797.00 52,797.00 2,956.00 25,305.00 47.929 27,492.00 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 260.00 16.250 1,340.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 5,306.25 88.438 693.75 135-60075-030-000 Meetings 400.00 400.00 38.50 67.50 16.875 332.50 135-60079-030-000 Public Education 5,000.00 5,000.00 4,230.34 84.607 769.66 135-60080-030-000 Schools & Training 9,935.00 9,935.00 3,382.00 34.041 6,553.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 393.01 3,201.28 59.283 2,198.72 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 7,500.00 7,500.00 3,210.41 42.805 4,289.59 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 10:45 07/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 7,500.00 7,500.00 61.74 .823 7,438.26 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,501.00 17,501.00 5,276.50 30.150 12,224.50 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 656.38 26.255 1,843.62 Subtotal: 226,882.00 238,442.00 12,015.57 131,916.05 55.324 106,525.95 135-65010-030-000 Uniforms 1,855.00 1,855.00 23.00 1.240 1,832.00 135-65055-030-000 Hardware 29,594.00 13,594.00 5,871.85 43.194 7,722.15 135-65085-030-000 Office Supplies 9,000.00 9,000.00 374.53 4,127.54 45.862 4,872.46 135-65090-030-000 Printer Supplies & Maintenance 4,003.00 4,003.00 598.19 1,004.63 25.097 2,998.37 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 332.35 2,709.27 54.185 2,290.73 135-65105-030-000 Printing 4,800.00 4,800.00 1,437.34 2,786.22 58.046 2,013.78 Subtotal: 54,252.00 38,252.00 2,742.41 16,522.51 43.194 21,729.49 135-69005-030-000 Capital Outlays 56,000.00 56,000.00 1,857.50 10,118.40 18.069 45,881.60 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 245.64 2,443.02 53.109 2,156.98 Subtotal: 60,600.00 60,600.00 2,103.14 12,561.42 20.728 48,038.58 Program number: 1,210,323.00 1,203,217.00 76,292.61 740,086.33 61.509 463,130.67 Department number: Administration 1,210,323.00 1,203,217.00 76,292.61 740,086.33 61.509 463,130.67 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 10:45 07/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 386,130.00 386,130.00 24,264.92 228,702.81 59.229 157,427.19 135-55055-039-000 Auditing 22,750.00 24,039.00 24,039.38 100.002 .38- 135-55060-039-000 Appraisal 10,265.00 10,265.00 1,869.25 8,093.66 78.847 2,171.34 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,468.82 64.969 1,331.18 Subtotal: 422,945.00 424,234.00 26,134.17 263,304.67 62.066 160,929.33 Program number: 422,945.00 424,234.00 26,134.17 263,304.67 62.066 160,929.33 Department number: Non Departmental 422,945.00 424,234.00 26,134.17 263,304.67 62.066 160,929.33 Expenditures Subtotal ----------- 8,047,784.00 8,609,567.00 431,833.23 5,048,984.68 58.644 3,560,582.32 Fund number: 135 MUD 1 General Fund 138,811.54- 583,821.46 583,821.46- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 10:45 07/11/16 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 10:45 07/11/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 2.77- 2.77 Subtotal: 2.77- 2.77 Program number: 2.77- 2.77 Department number: 2.77- 2.77 Revenues Subtotal ----------- 2.77- 2.77 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 10:45 07/11/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 8,034.36- Subtotal: 8,034.36 8,034.36- Program number: 8,034.36 8,034.36- Department number: Wastewater 8,034.36 8,034.36- Expenditures Subtotal ----------- 8,034.36 8,034.36- Fund number: 507 MUD 1 Capital Projects 8,031.59 8,031.59- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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 1887 06/01/2016 Property Taxes (56,671.78) (92.80) (56,764.58) GL 1889 06/02/2016 Property Taxes (29.74) (56,794.32) GL 1890 06/03/2016 Property Taxes (13.33) (56,807.65) GL 1891 06/06/2016 Property Taxes (22.75) (56,830.40) GL 1893 06/07/2016 Property Taxes (6.92) (56,837.32) GL 1894 06/08/2016 Property Taxes (.94) (56,838.26) GL 1895 06/10/2016 Property Taxes (9.30) (56,847.56) GL 1896 06/16/2016 Property Taxes (.27) (56,847.83) GL 1897 06/17/2016 Property Taxes (1.04) (56,848.87) GL 1898 06/21/2016 Property Taxes (9.97) (56,858.84) GL 1899 06/22/2016 Property Taxes (4.33) (56,863.17) GL 1900 06/23/2016 Property Taxes (8.65) (56,871.82) GL 1901 06/29/2016 Property Taxes (5.79) (56,877.61) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (205.83) (56,877.61) ** (58,181.00) Budgeted (1,303.39) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1901 06/29/2016 Property Taxes (1,273.46) (1.40) (1,274.86) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (1.40) (1,274.86) ** .00 Budgeted 1,274.86 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1889 06/02/2016 Property Taxes (491.49) (.38) (491.87) GL 1890 06/03/2016 Property Taxes (.22) (492.09) GL 1891 06/06/2016 Property Taxes (2.11) (494.20) GL 1893 06/07/2016 Property Taxes (.17) (494.37) GL 1894 06/08/2016 Property Taxes (.14) (494.51) GL 1895 06/10/2016 Property Taxes (1.05) (495.56) GL 1896 06/16/2016 Property Taxes (.02) (495.58) GL 1897 06/17/2016 Property Taxes (.16) (495.74) GL 1898 06/21/2016 Property Taxes (1.49) (497.23) GL 1900 06/23/2016 Property Taxes (1.11) (498.34) GL 1901 06/29/2016 Property Taxes (.49) (498.83) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (7.34) (498.83) ** (650.00) Budgeted (151.17) Remaining 77 % Used Account: 135-40025-000-000 PID Surcharges . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (146,125.00) Budgeted (146,125.00) Remaining 0 % Used Account: 135-47000-000-000 Water 1849 06/30/2016 UB 6/30/16 Billing UB20160630-20160630 User: (2,207,004.83) (330,929.34) (2,537,934.17) UB _______________ Account: 135-47000-000-000 Water Totals: (330,929.34) (2,537,934.17) ** (5,080,244.00) Budgeted (2,542,309.83) Remaining 50 % Used Account: 135-47005-000-000 Sewer 1849 06/30/2016 UB 6/30/16 Billing UB20160630-20160630 User: (1,372,648.47) (203,221.54) (1,575,870.01) UB _______________ Account: 135-47005-000-000 Sewer Totals: (203,221.54) (1,575,870.01) ** (2,413,776.00) Budgeted (837,905.99) Remaining 65 % Used Account: 135-47025-000-000 Penalties 1790 06/21/2016 UB 6/21/16 Penalties UB20160621-20160621 User: (66,085.66) (5,551.68) (71,637.34) UB 1852 06/27/2016 UB 6/27/16 Penalties UB20160627-20160627 User: 106.46 (71,530.88) UB 1854 06/30/2016 UB 6/30/16 Panalties UB20160630-20160630 User: 65.57 (71,465.31) UB _______________ Account: 135-47025-000-000 Penalties Totals: (5,379.65) (71,465.31) ** (90,985.00) Budgeted (19,519.69) Remaining 79 % Used Account: 135-47030-000-000 Service Charges 1708 06/08/2016 UB 6/8/2016 Cut off list UB20160608-20160608 User: (9,825.00) (750.00) (10,575.00) UB 1841 06/14/2016 UB 6/14/16 NSF Check fee UB20160614-20160614 User: (25.00) (10,600.00) UB 1844 06/16/2016 UB 6/16/16 NSF Cehcek fee UB20160616-20160616 User: (25.00) (10,625.00) UB 1846 06/22/2016 UB 6/22/16 NSF Check fee UB20160622-20160622 User: (50.00) (10,675.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (850.00) (10,675.00) ** (9,000.00) Budgeted 1,675.00 Remaining 119 % Used Account: 135-47035-000-000 Plumbing Inspections 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (1,950.00) (150.00) (2,100.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (2,100.00) ** (2,000.00) Budgeted 100.00 Remaining 105 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/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-47045-000-000 Sewer Inspections 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (5,700.00) (450.00) (6,150.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (6,150.00) ** (5,500.00) Budgeted 650.00 Remaining 112 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1840 06/01/2016 UB 6/1/16 Adj for CC effleunt UB20160601-20160601 User: (11,746.00) 4,346.30 (7,399.70) UB 1849 06/30/2016 UB 6/30/16 Billing UB20160630-20160630 User: (5,142.75) (12,542.45) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (796.45) (12,542.45) ** (61,330.00) Budgeted (48,787.55) Remaining 20 % Used Account: 135-48005-000-000 Utility Fees (55,200.00) .00 (55,200.00) _______________ Account: 135-48005-000-000 Utility Fees Totals: .00 (55,200.00) ** (55,200.00) Budgeted .00 Remaining 100 % Used Account: 135-49010-000-000 Interest Income 1876 06/30/2016 Bank Interest/Month (8,241.87) (202.67) (8,444.54) GL 1876 06/30/2016 Bank Interest/Month (73.79) (8,518.33) GL 1876 06/30/2016 Bank Interest/Month (310.55) (8,828.88) GL 1876 06/30/2016 Bank Interest/Month (598.66) (9,427.54) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,185.67) (9,427.54) ** (10,000.00) Budgeted (572.46) Remaining 94 % Used Account: 135-49016-000-000 Cell Tower Revenue 1793 06/01/2016 AT&T Cell Tower Revenue (7,284.24) (910.53) (8,194.77) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (8,194.77) ** (10,926.00) Budgeted (2,731.23) Remaining 75 % Used Account: 135-49018-000-000 Building Rent Income 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (4,666.64) (583.33) (5,249.97) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,249.97) ** (7,000.00) Budgeted (1,750.03) Remaining 75 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49026-000-000 Proceeds from Sale of Assets (30,935.00) .00 (30,935.00) _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (30,935.00) ** (30,935.00) Budgeted .00 Remaining 100 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (548,668.00) Budgeted (548,668.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (42,246.42) (1,715.00) (43,961.42) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,715.00) (43,961.42) ** (15,778.00) Budgeted 28,183.42 Remaining 279 % Used Account: 135-49141-000-000 Interfund Transfer In (8,034.36) .00 (8,034.36) _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (8,034.36) ** .00 Budgeted 8,034.36 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1754 06/14/2016 Bill Town Inv 1471 AR 20160614-20160614 User: (4,484.83) (20,140.00) (24,624.83) AR 1832 06/29/2016 Compupay/Cafe125 Forfieture (4,064.60) (28,689.43) GL 1849 06/30/2016 UB 6/30/16 Billing UB20160630-20160630 User: (54.09) (28,743.52) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (24,258.69) (28,743.52) ** (63,249.00) Budgeted (34,505.48) Remaining 45 % Used Account: 135-49901-000-000 Records Management Revenue (28.40) .00 (28.40) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (28.40) ** (20.00) Budgeted 8.40 Remaining 142 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department Totals: ------------------------------------------------------------------------------------------------ (4,465,163.22) ** (8,609,567.00) Budgeted (4,144,403.78) Remaining 52 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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 1627 06/03/2016 MUD Payroll 6/3/16 Salaries & Wages 134,350.55 8,425.45 142,776.00 PR 1739 06/17/2016 MUD Payroll 6/17/16 Salaries & Wages 8,497.36 151,273.36 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 16,922.81 151,273.36 ** 260,062.00 Budgeted 108,788.64 Remaining 58 % Used Account: 135-50010-010-000 Overtime 1627 06/03/2016 MUD Payroll 6/3/16 Overtime 9,089.38 345.28 9,434.66 PR 1739 06/17/2016 MUD Payroll 6/17/16 Overtime 595.25 10,029.91 PR _______________ Account: 135-50010-010-000 Overtime Totals: 940.53 10,029.91 ** 19,500.00 Budgeted 9,470.09 Remaining 51 % Used Account: 135-50016-010-000 Longevity 2,945.00 .00 2,945.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,945.00 ** 2,945.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1739 06/17/2016 MUD Payroll 6/17/16 Certification 1,525.00 200.00 1,725.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 1,725.00 ** 3,600.00 Budgeted 1,875.00 Remaining 48 % Used Account: 135-50020-010-000 Retirement 1627 06/03/2016 MUD Payroll 6/3/16 Retirement 13,017.64 765.68 13,783.32 PR 1739 06/17/2016 MUD Payroll 6/17/16 Retirement 811.25 14,594.57 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,576.93 14,594.57 ** 25,018.00 Budgeted 10,423.43 Remaining 58 % Used Account: 135-50026-010-000 Medical Insurance 1627 06/03/2016 MUD Payroll 6/3/16 Medical Insurance 24,782.06 1,580.60 26,362.66 PR 1739 06/17/2016 MUD Payroll 6/17/16 Medical Insurance 1,580.55 27,943.21 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,161.15 27,943.21 ** 51,398.00 Budgeted 23,454.79 Remaining 54 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 1627 06/03/2016 MUD Payroll 6/3/16 Dental Insurance 1,861.64 120.39 1,982.03 PR 1739 06/17/2016 MUD Payroll 6/17/16 Dental Insurance 120.38 2,102.41 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 240.77 2,102.41 ** 3,999.00 Budgeted 1,896.59 Remaining 53 % Used Account: 135-50028-010-000 Vision Insurance 1627 06/03/2016 MUD Payroll 6/3/16 Vision Insurance 419.20 27.01 446.21 PR 1739 06/17/2016 MUD Payroll 6/17/16 Vision Insurance 26.97 473.18 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.98 473.18 ** 910.00 Budgeted 436.82 Remaining 52 % Used Account: 135-50029-010-000 Life Insurance & Other 1672 06/03/2016 June A/P June Dental, Vision, LTD, STD, 1,557.62 191.24 1,748.86 METLIFE GROUP BENEFITS 1975 AP 1824 06/28/2016 June A/P Café 125 Adm fees 9.71 1,758.57 BenefitMall 2045 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 200.95 1,758.57 ** 2,803.00 Budgeted 1,044.43 Remaining 63 % Used Account: 135-50030-010-000 Social Security Taxes 1627 06/03/2016 MUD Payroll 6/3/16 Social Security Taxes 9,097.02 540.76 9,637.78 PR 1739 06/17/2016 MUD Payroll 6/17/16 Social Security Taxes 569.12 10,206.90 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,109.88 10,206.90 ** 18,146.00 Budgeted 7,939.10 Remaining 56 % Used Account: 135-50035-010-000 Medicare Taxes 1627 06/03/2016 MUD Payroll 6/3/16 Medicare Taxes 2,127.51 126.47 2,253.98 PR 1739 06/17/2016 MUD Payroll 6/17/16 Medicare Taxes 133.10 2,387.08 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 259.57 2,387.08 ** 4,243.00 Budgeted 1,855.92 Remaining 56 % Used Account: 135-50040-010-000 Unemployment Taxes 859.06 .00 859.06 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 859.06 ** 1,026.00 Budgeted 166.94 Remaining 84 % Used Account: 135-50045-010-000 Workman's Compensation 140 06/01/2016 Prepaid Insurance, W/C Jun 7,520.28 1,229.35 8,749.63 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,229.35 8,749.63 ** 14,754.00 Budgeted 6,004.37 Remaining 59 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 236.45 .00 236.45 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 236.45 ** 1,300.00 Budgeted 1,063.55 Remaining 18 % Used Account: 135-50070-010-000 Employee Relations 75.22 .00 75.22 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 75.22 ** 300.00 Budgeted 224.78 Remaining 25 % Used Account: 135-55005-010-000 Engineering 1864 06/30/2016 June A/P 41,420.60 7,500.00 48,920.60 TOWN OF TROPHY CLUB 2101 AP _______________ Account: 135-55005-010-000 Engineering Totals: 7,500.00 48,920.60 ** 109,400.00 Budgeted 60,479.40 Remaining 45 % Used Account: 135-55080-010-000 Maintenance & Repairs 1779 06/20/2016 June A/P Gaskets, pumps, suction hose 67,997.76 189.15 68,186.91 HD SUPPLY WATERWORKS, LTD. 2022 AP 1831 06/27/2016 TML/Lightning Strike Claim (1,475.28) 66,711.63 GL 1871 06/27/2016 June A/P AMAZON MKTPLACE PMTS 51.63 66,763.26 AMAZON MKTPLACE PMTS PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 41.26 66,804.52 THE HOME DEPOT 6581 PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 15.54 66,820.06 THE HOME DEPOT 6581 PC 1824 06/28/2016 June A/P Coupling 190.00 67,010.06 HD SUPPLY WATERWORKS, LTD. 2065 AP 1857 06/30/2016 June A/P Repair ice machine in shop 215.00 67,225.06 BRANDON R REED 2047 AP 1857 06/30/2016 June A/P Oxygen for Torch 91.32 67,316.38 ALLIED WELDING SUPPLY, INC 2038 AP 1868 06/30/2016 June A/P 10" Spool Piece 302.00 67,618.38 HD SUPPLY WATERWORKS, LTD. 2065 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1868 06/30/2016 June A/P Bolts 67,997.76 78.96 67,697.34 HD SUPPLY WATERWORKS, LTD. 2065 AP 1868 06/30/2016 June A/P Coupling 210.02 67,907.36 HD SUPPLY WATERWORKS, LTD. 2065 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: (90.40) 67,907.36 ** 99,500.00 Budgeted 31,592.64 Remaining 68 % Used Account: 135-55090-010-000 Vehicle Maintenance 1871 06/27/2016 June A/P DISCOUNT TIRE TXD 75 3,140.69 419.00 3,559.69 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 419.00 3,559.69 ** 8,000.00 Budgeted 4,440.31 Remaining 44 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,892.77 .00 2,892.77 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 2,892.77 ** 3,500.00 Budgeted 607.23 Remaining 83 % Used Account: 135-55135-010-000 Lab Analysis 1779 06/20/2016 June A/P Water samples/MUD Water Sampl 2,736.87 270.00 3,006.87 TARRANT CTY PUBLIC HEALTH LAB 2025 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 270.00 3,006.87 ** 5,500.00 Budgeted 2,493.13 Remaining 55 % Used Account: 135-60010-010-000 Communications/Mobiles 1779 06/20/2016 June A/P 5/2-6/1 Cell phones 2,878.03 363.98 3,242.01 VERIZON WIRELESS 2027 AP 1871 06/27/2016 June A/P WAL-MART #5247 86.51 3,328.52 WAL-MART #5247 PC _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 450.49 3,328.52 ** 5,400.00 Budgeted 2,071.48 Remaining 62 % Used Account: 135-60020-010-000 Electricity 1824 06/28/2016 June A/P Electricity 5/10-6/09/16 78,572.99 9,913.64 88,486.63 HUDSON ENERGY SERVICES, LLC 2068 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,913.64 88,486.63 ** 166,823.00 Budgeted 78,336.37 Remaining 53 % Used Account: 135-60066-010-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1779 06/20/2016 June A/P AWWA Standards 716.00 716.00 AMERICAN WATER WORKS ASSOC 2017 AP _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 716.00 716.00 ** 500.00 Budgeted (216.00) Remaining 143 % Used Account: 135-60070-010-000 Dues & Memberships 11.00 .00 11.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 11.00 ** 500.00 Budgeted 489.00 Remaining 2 % Used Account: 135-60080-010-000 Schools & Training 1871 06/27/2016 June A/P TCEQ IND RENEWAL L 1,268.00 111.00 1,379.00 TCEQ IND RENEWAL L PC 1871 06/27/2016 June A/P TCEQ IND RENEWAL L 111.00 1,490.00 TCEQ IND RENEWAL L PC 1871 06/27/2016 June A/P 360 WATER INC 30.00 1,520.00 360 WATER INC PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 252.00 1,520.00 ** 5,773.00 Budgeted 4,253.00 Remaining 26 % Used Account: 135-60090-010-000 Safety Program 248.97 .00 248.97 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 248.97 ** 400.00 Budgeted 151.03 Remaining 62 % Used Account: 135-60100-010-000 Travel & per diem 87.09 .00 87.09 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 87.09 ** 1,400.00 Budgeted 1,312.91 Remaining 6 % Used Account: 135-60105-010-000 Rent/Lease Equipment 324.64 .00 324.64 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 324.64 ** 1,500.00 Budgeted 1,175.36 Remaining 22 % Used Account: 135-60135-010-000 TCEQ Fees & Permits . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 13,175.00 .00 13,175.00 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 13,175.00 ** 49,275.00 Budgeted 36,100.00 Remaining 27 % Used Account: 135-60150-010-000 Wholesale Water 1824 06/28/2016 June A/P Wholesale Water/May 1,013,176.42 137,264.77 1,150,441.19 CITY OF FORT WORTH 2058 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 137,264.77 1,150,441.19 ** 2,948,742.00 Budgeted 1,798,300.81 Remaining 39 % 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 1871 06/27/2016 June A/P THE HOME DEPOT 6581 2,243.64 36.99 2,280.63 THE HOME DEPOT 6581 PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 36.99 2,280.63 ** 3,500.00 Budgeted 1,219.37 Remaining 65 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .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 1824 06/28/2016 June A/P Fuel 5/25-6/24/16 8,989.75 1,179.85 10,169.60 US Bank Voyager Fleet Systems 2103 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-65005-010-000 Fuel & Lube Totals: 1,179.85 10,169.60 ** 35,947.00 Budgeted 25,777.40 Remaining 28 % Used Account: 135-65010-010-000 Uniforms 2,006.73 .00 2,006.73 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 2,006.73 ** 4,608.00 Budgeted 2,601.27 Remaining 44 % Used Account: 135-65030-010-000 Chemicals 1779 06/20/2016 June A/P Chemicals 8,368.48 424.96 8,793.44 HACH COMPANY 2021 AP 1779 06/20/2016 June A/P Chemicals 139.95 8,933.39 HACH COMPANY 2021 AP 1779 06/20/2016 June A/P Chemicals 23.29 8,956.68 HACH COMPANY 2021 AP 1824 06/28/2016 June A/P Chlorine 741.59 9,698.27 DPC INDUSTRIES, INC 2059 AP 1857 06/30/2016 June A/P Chemicals 211.04 9,909.31 HACH COMPANY 2063 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,540.83 9,909.31 ** 13,000.00 Budgeted 3,090.69 Remaining 76 % Used Account: 135-65035-010-000 Small Tools 129.55 .00 129.55 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 129.55 ** 1,200.00 Budgeted 1,070.45 Remaining 11 % Used Account: 135-65040-010-000 Safety Equipment 443.49 .00 443.49 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 443.49 ** 1,000.00 Budgeted 556.51 Remaining 44 % Used Account: 135-65050-010-000 Meter Expense 1857 06/30/2016 June A/P Meter Heads & Endpoints 92,435.34 4,350.00 96,785.34 ATLAS UTILITY SUPPLY CO. 2044 AP 1857 06/30/2016 June A/P Meter gaskets 18.00 96,803.34 ATLAS UTILITY SUPPLY CO. 2044 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 4,368.00 96,803.34 ** 115,000.00 Budgeted 18,196.66 Remaining 84 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 6/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-65053-010-000 Meter Change Out Program 77,325.00 .00 77,325.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 77,325.00 ** 77,325.00 Budgeted .00 Remaining 100 % Used Account: 135-69005-010-000 Capital Outlays 339,615.98 .00 339,615.98 _______________ Account: 135-69005-010-000 Capital Outlays Totals: .00 339,615.98 ** 400,250.00 Budgeted 60,634.02 Remaining 85 % Used Account: 135-69008-010-000 Short Term Debt-Principal 130,700.34 .00 130,700.34 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 130,700.34 ** 130,720.00 Budgeted 19.66 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt-Interest 1,177.54 .00 1,177.54 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 1,177.54 ** 1,209.00 Budgeted 31.46 Remaining 97 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 126,957.75 .00 126,957.75 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 126,957.75 ** 126,958.00 Budgeted .25 Remaining 100 % Used Account: 135-55135-010-001 Lab Analysis for PID . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1779 06/20/2016 June A/P Water Samples/PID 1,117.74 80.00 1,197.74 TARRANT CTY PUBLIC HEALTH LAB 2025 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 1,197.74 ** 5,000.00 Budgeted 3,802.26 Remaining 24 % 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: ------------------------------------------------------------------------------------------------ 2,493,702.88 ** 4,814,884.00 Budgeted 2,321,181.12 Remaining 52 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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 1627 06/03/2016 MUD Payroll 6/3/16 Salaries & Wages 225,093.73 14,421.65 239,515.38 PR 1739 06/17/2016 MUD Payroll 6/17/16 Salaries & Wages 14,421.65 253,937.03 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 28,843.30 253,937.03 ** 351,671.00 Budgeted 97,733.97 Remaining 72 % Used Account: 135-50010-020-000 Overtime 1627 06/03/2016 MUD Payroll 6/3/16 Overtime 22,748.03 1,010.64 23,758.67 PR 1739 06/17/2016 MUD Payroll 6/17/16 Overtime 1,145.68 24,904.35 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,156.32 24,904.35 ** 29,500.00 Budgeted 4,595.65 Remaining 84 % Used Account: 135-50016-020-000 Longevity 6,125.00 .00 6,125.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,125.00 ** 6,125.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1739 06/17/2016 MUD Payroll 6/17/16 Certification 4,850.00 675.00 5,525.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 675.00 5,525.00 ** 7,200.00 Budgeted 1,675.00 Remaining 77 % Used Account: 135-50020-020-000 Retirement 1627 06/03/2016 MUD Payroll 6/3/16 Retirement 22,770.22 1,347.24 24,117.46 PR 1739 06/17/2016 MUD Payroll 6/17/16 Retirement 1,417.96 25,535.42 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,765.20 25,535.42 ** 33,652.00 Budgeted 8,116.58 Remaining 76 % Used Account: 135-50026-020-000 Medical Insurance 1627 06/03/2016 MUD Payroll 6/3/16 Medical Insurance 41,796.66 2,765.99 44,562.65 PR 1739 06/17/2016 MUD Payroll 6/17/16 Medical Insurance 2,765.98 47,328.63 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,531.97 47,328.63 ** 65,989.00 Budgeted 18,660.37 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 1627 06/03/2016 MUD Payroll 6/3/16 Dental Insurance 2,554.17 173.97 2,728.14 PR 1739 06/17/2016 MUD Payroll 6/17/16 Dental Insurance 173.94 2,902.08 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 347.91 2,902.08 ** 4,184.00 Budgeted 1,281.92 Remaining 69 % Used Account: 135-50028-020-000 Vision Insurance 1627 06/03/2016 MUD Payroll 6/3/16 Vision Insurance 578.90 39.05 617.95 PR 1739 06/17/2016 MUD Payroll 6/17/16 Vision Insurance 39.00 656.95 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 78.05 656.95 ** 972.00 Budgeted 315.05 Remaining 68 % Used Account: 135-50029-020-000 Life Insurance & Other 1672 06/03/2016 June A/P June Dental, Vision, LTD, STD, 2,695.89 325.82 3,021.71 METLIFE GROUP BENEFITS 1975 AP 1824 06/28/2016 June A/P Café 125 Adm fees 29.13 3,050.84 BenefitMall 2045 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 354.95 3,050.84 ** 3,655.00 Budgeted 604.16 Remaining 83 % Used Account: 135-50030-020-000 Social Security Taxes 1627 06/03/2016 MUD Payroll 6/3/16 Social Security Taxes 14,615.75 866.79 15,482.54 PR 1739 06/17/2016 MUD Payroll 6/17/16 Social Security Taxes 898.57 16,381.11 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,765.36 16,381.11 ** 24,665.00 Budgeted 8,283.89 Remaining 66 % Used Account: 135-50035-020-000 Medicare Taxes 1627 06/03/2016 MUD Payroll 6/3/16 Medicare Taxes 3,418.17 202.73 3,620.90 PR 1739 06/17/2016 MUD Payroll 6/17/16 Medicare Taxes 210.13 3,831.03 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 412.86 3,831.03 ** 5,768.00 Budgeted 1,936.97 Remaining 66 % Used Account: 135-50040-020-000 Unemployment Taxes 1,203.57 .00 1,203.57 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 1,203.57 ** 1,204.00 Budgeted .43 Remaining 100 % Used Account: 135-50045-020-000 Workman's Compensation 140 06/01/2016 Prepaid Insurance, W/C Jun 3,896.95 776.43 4,673.38 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 776.43 4,673.38 ** 9,317.00 Budgeted 4,643.62 Remaining 50 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 1871 06/27/2016 June A/P TX DPS DL OFFICE 238.45 53.00 291.45 TX DPS DL OFFICE PC 1871 06/27/2016 June A/P TX DPS DL OFFICE 11.00 302.45 TX DPS DL OFFICE PC 1921 06/30/2016 Recode F Wolf CDL (64.00) 238.45 GL _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 238.45 ** 300.00 Budgeted 61.55 Remaining 79 % Used Account: 135-50070-020-000 Employee Relations 1871 06/27/2016 June A/P MI PUEBLO #1 NRH TX 367.78 52.03 419.81 MI PUEBLO #1 NRH TX PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 52.03 419.81 ** 650.00 Budgeted 230.19 Remaining 65 % Used Account: 135-55070-020-000 Independent Labor 1779 06/20/2016 June A/P Troubleshoot & repair Blower 1 20,711.50 3,421.95 24,133.45 WALKER ENGINEERING INC 2028 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 3,421.95 24,133.45 ** 50,000.00 Budgeted 25,866.55 Remaining 48 % Used Account: 135-55080-020-000 Maintenance & Repairs 1871 06/27/2016 June A/P AUTOZONE #4206 72,146.15 17.98 72,164.13 AUTOZONE #4206 PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 725.76 72,889.89 THE HOME DEPOT 6581 PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 409.14 73,299.03 THE HOME DEPOT 6581 PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 291.56 73,590.59 THE HOME DEPOT 6581 PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 130.64 73,721.23 THE HOME DEPOT 6581 PC 1871 06/27/2016 June A/P HUBER TECHNOLOGY INC 1,780.00 75,501.23 HUBER TECHNOLOGY INC PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 416.87 75,918.10 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1871 06/27/2016 June A/P THE HOME DEPOT 6581 72,146.15 138.32 76,056.42 THE HOME DEPOT 6581 PC 1871 06/27/2016 June A/P AIR MAC INC 206.10 76,262.52 AIR MAC INC PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 88.02 76,350.54 THE HOME DEPOT 6581 PC 1871 06/27/2016 June A/P WW GRAINGER 757.69 77,108.23 WW GRAINGER PC 1871 06/27/2016 June A/P WW GRAINGER 48.16 77,156.39 WW GRAINGER PC 1872 06/27/2016 PCards 6/27/16 ROYAL BRASS AND HOSE 39.58 77,195.97 ROYAL BRASS AND HOSE PC 1872 06/27/2016 PCards 6/27/16 THE HOME DEPOT 6581 301.25 77,497.22 THE HOME DEPOT 6581 PC 1827 06/29/2016 June A/P Repair WWTP Generator 2,363.96 79,861.18 WORLDWIDE POWER PRODUCTS 2111 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 7,715.03 79,861.18 ** 83,100.00 Budgeted 3,238.82 Remaining 96 % Used Account: 135-55090-020-000 Vehicle Maintenance 1871 06/27/2016 June A/P SOUTHWEST INTERNATIONA 4,801.83 671.18 5,473.01 SOUTHWEST INTERNATIONA PC 1871 06/27/2016 June A/P DISCOUNT TIRE TXD 75 365.00 5,838.01 DISCOUNT TIRE TXD 75 PC 1871 06/27/2016 June A/P DISCOUNT TIRE TXD 75 327.00 6,165.01 DISCOUNT TIRE TXD 75 PC 1871 06/27/2016 June A/P MUSTANG ELITE CAR WASH 16.99 6,182.00 MUSTANG ELITE CAR WASH PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 1,380.17 6,182.00 ** 7,500.00 Budgeted 1,318.00 Remaining 82 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 291.00 .00 291.00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 291.00 ** 500.00 Budgeted 209.00 Remaining 58 % Used Account: 135-55125-020-000 Dumpster Services 1827 06/29/2016 June A/P Sludge haul off 25,582.82 2,028.00 27,610.82 L.H. CHANEY MATERIALS, INC. 2076 AP 1827 06/29/2016 June A/P Sludge haul off 1,014.00 28,624.82 L.H. CHANEY MATERIALS, INC. 2076 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,042.00 28,624.82 ** 55,000.00 Budgeted 26,375.18 Remaining 52 % Used Account: 135-55135-020-000 Lab Analysis 1827 06/29/2016 June A/P Biochemical Oxygen Demand 26,234.40 35.00 26,269.40 OXIDOR LABORATORIES LLC 2088 AP 1827 06/29/2016 June A/P Testing 246.00 26,515.40 OXIDOR LABORATORIES LLC 2088 AP 1827 06/29/2016 June A/P Testing 176.00 26,691.40 OXIDOR LABORATORIES LLC 2088 AP 1827 06/29/2016 June A/P Testing 176.00 26,867.40 OXIDOR LABORATORIES LLC 2088 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1827 06/29/2016 June A/P Testing 26,234.40 246.00 27,113.40 OXIDOR LABORATORIES LLC 2088 AP 1827 06/29/2016 June A/P Testing 176.00 27,289.40 OXIDOR LABORATORIES LLC 2088 AP 1827 06/29/2016 June A/P Testing 246.00 27,535.40 OXIDOR LABORATORIES LLC 2088 AP 1827 06/29/2016 June A/P Testing 176.00 27,711.40 OXIDOR LABORATORIES LLC 2088 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,477.00 27,711.40 ** 35,000.00 Budgeted 7,288.60 Remaining 79 % Used Account: 135-60010-020-000 Communications/Mobiles 1779 06/20/2016 June A/P 5/2-6/1 Cell phones 3,827.62 412.00 4,239.62 VERIZON WIRELESS 2027 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 412.00 4,239.62 ** 5,400.00 Budgeted 1,160.38 Remaining 79 % Used Account: 135-60020-020-000 Electricity 1779 06/20/2016 June A/P Electricity 5/9-6/8/16 70,745.49 63.09 70,808.58 HUDSON ENERGY SERVICES, LLC 2023 AP 1779 06/20/2016 June A/P Electricity 5/9-6/8/16 64.36 70,872.94 HUDSON ENERGY SERVICES, LLC 2023 AP 1781 06/20/2016 Void A/P Ck2023/Hudson Electricity 5/9-6/8/16 (63.09) 70,809.85 HUDSON ENERGY SERVICES, LLC 2023 AP 1781 06/20/2016 Void A/P Ck2023/Hudson Electricity 5/9-6/8/16 (64.36) 70,745.49 HUDSON ENERGY SERVICES, LLC 2023 AP 1782 06/20/2016 June A/P Electricity 5/9-6/8/16 63.09 70,808.58 HUDSON ENERGY SERVICES, LLC 2030 AP 1782 06/20/2016 June A/P Electricity 5/9-6/8/16 64.36 70,872.94 HUDSON ENERGY SERVICES, LLC 2030 AP 1824 06/28/2016 June A/P Electricity 5/10-6/9/16 478.73 71,351.67 HUDSON ENERGY SERVICES, LLC 2068 AP 1824 06/28/2016 June A/P Electricity 5/10-6/9/16 9,002.57 80,354.24 HUDSON ENERGY SERVICES, LLC 2068 AP 1824 06/28/2016 June A/P Electricity 5/10-6/9/16 223.74 80,577.98 MP2 ENERGY TEXAS LLC 2084 AP 1912 06/30/2016 June A/P Electricity 5/25-6/27/16 292.50 80,870.48 TRI COUNTY ELECTRIC AP 1912 06/30/2016 June A/P Electricity 5/25-6/27/16 27.99 80,898.47 TRI COUNTY ELECTRIC AP 1912 06/30/2016 June A/P Electricity 5/25-6/27/16 457.46 81,355.93 TRI COUNTY ELECTRIC AP 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (176.89) 81,179.04 AR _______________ Account: 135-60020-020-000 Electricity Totals: 10,433.55 81,179.04 ** 161,582.00 Budgeted 80,402.96 Remaining 50 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 200.00 .00 200.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 200.00 ** 300.00 Budgeted 100.00 Remaining 67 % Used Account: 135-60080-020-000 Schools & Training 1921 06/30/2016 Recode F Wolf CDL 2,353.00 64.00 2,417.00 GL _______________ Account: 135-60080-020-000 Schools & Training Totals: 64.00 2,417.00 ** 3,771.00 Budgeted 1,354.00 Remaining 64 % Used Account: 135-60090-020-000 Safety Program 1871 06/27/2016 June A/P MEAT U ANYWHERE TR 296.67 44.00 340.67 MEAT U ANYWHERE TR PC _______________ Account: 135-60090-020-000 Safety Program Totals: 44.00 340.67 ** 550.00 Budgeted 209.33 Remaining 62 % Used Account: 135-60100-020-000 Travel & per diem 744.79 .00 744.79 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 744.79 ** 1,600.00 Budgeted 855.21 Remaining 47 % Used Account: 135-60105-020-000 Rent/Lease Equipment 4,588.50 .00 4,588.50 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 4,588.50 ** 9,000.00 Budgeted 4,411.50 Remaining 51 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 14,578.74 .00 14,578.74 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 14,578.74 ** 37,150.00 Budgeted 22,571.26 Remaining 39 % Used Account: 135-60245-020-000 Miscellaneous Expenses 423.24 .00 423.24 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-60245-020-000 Miscellaneous Expenses Totals: .00 423.24 ** 297.00 Budgeted (126.24) Remaining 143 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1769 06/14/2016 Texpool Transfers To MUD I&S/PID share new debt 59,853.00 19,951.00 79,804.00 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 19,951.00 79,804.00 ** 119,706.00 Budgeted 39,902.00 Remaining 67 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1769 06/14/2016 Texpool Transfers Xfer to Rev Bond I&S 315,176.56 43,220.32 358,396.88 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 43,220.32 358,396.88 ** 444,831.00 Budgeted 86,434.12 Remaining 81 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 92,502.00 .00 92,502.00 _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: .00 92,502.00 ** 123,336.00 Budgeted 30,834.00 Remaining 75 % Used Account: 135-65005-020-000 Fuel & Lube 1824 06/28/2016 June A/P Fuel 5/25-6/24/16 7,159.33 793.77 7,953.10 US Bank Voyager Fleet Systems 2103 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 793.77 7,953.10 ** 32,021.00 Budgeted 24,067.90 Remaining 25 % Used Account: 135-65010-020-000 Uniforms 1871 06/27/2016 June A/P CAVENDERS BOOT #7 2,623.52 5.00 2,628.52 CAVENDERS BOOT #7 PC 1871 06/27/2016 June A/P CAVENDERS BOOT #7 104.99 2,733.51 CAVENDERS BOOT #7 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/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-020-000 Uniforms Totals: 109.99 2,733.51 ** 4,241.00 Budgeted 1,507.49 Remaining 64 % Used Account: 135-65030-020-000 Chemicals 21,183.25 .00 21,183.25 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 21,183.25 ** 27,000.00 Budgeted 5,816.75 Remaining 78 % Used Account: 135-65035-020-000 Small Tools 1871 06/27/2016 June A/P THE HOME DEPOT 6581 371.89 29.45 401.34 THE HOME DEPOT 6581 PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 150.15 551.49 THE HOME DEPOT 6581 PC 1871 06/27/2016 June A/P HARBOR FREIGHT TOOLS 2 227.10 778.59 HARBOR FREIGHT TOOLS 2 PC 1871 06/27/2016 June A/P THE HOME DEPOT 6581 88.82 867.41 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 495.52 867.41 ** 2,000.00 Budgeted 1,132.59 Remaining 43 % Used Account: 135-65040-020-000 Safety Equipment 576.59 .00 576.59 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 576.59 ** 750.00 Budgeted 173.41 Remaining 77 % Used Account: 135-65045-020-000 Lab Supplies 1827 06/29/2016 June A/P E Coli bottles 13,004.09 437.06 13,441.15 IDEXX DISTRIBUTION, INC 2070 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 437.06 13,441.15 ** 13,000.00 Budgeted (441.15) Remaining 103 % Used Account: 135-69005-020-000 Capital Outlays 269,447.28 .00 269,447.28 _______________ Account: 135-69005-020-000 Capital Outlays Totals: .00 269,447.28 ** 356,000.00 Budgeted 86,552.72 Remaining 76 % Used Account: 135-69008-020-000 Short Term Debt-Principal . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 21,276.80 .00 21,276.80 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 21,276.80 ** 21,280.00 Budgeted 3.20 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest 197.00 .00 197.00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 197.00 ** 197.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,540,607.07 ** 2,140,864.00 Budgeted 600,256.93 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 1627 06/03/2016 MUD Payroll 6/3/16 Salaries & Wages 5,200.00 400.00 5,600.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 400.00 5,600.00 ** 12,500.00 Budgeted 6,900.00 Remaining 45 % Used Account: 135-50030-026-000 Social Security Taxes 1627 06/03/2016 MUD Payroll 6/3/16 Social Security Taxes 322.40 24.80 347.20 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 24.80 347.20 ** 775.00 Budgeted 427.80 Remaining 45 % Used Account: 135-50035-026-000 Medicare Taxes 1627 06/03/2016 MUD Payroll 6/3/16 Medicare Taxes 75.40 5.80 81.20 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 5.80 81.20 ** 181.00 Budgeted 99.80 Remaining 45 % Used Account: 135-50040-026-000 Unemployment Taxes 35.70 .00 35.70 _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .00 35.70 ** 12.00 Budgeted (23.70) Remaining 298 % Used Account: 135-50045-026-000 Workman's Compensation 140 06/01/2016 Prepaid Insurance, W/C Jun 37.65 3.08 40.73 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 3.08 40.73 ** 50.00 Budgeted 9.27 Remaining 81 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 10.98 .00 10.98 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 10.98 ** 500.00 Budgeted 489.02 Remaining 2 % Used Account: 135-60075-026-000 Meetings 21.67 .00 21.67 _______________ Account: 135-60075-026-000 Meetings Totals: .00 21.67 ** 1,200.00 Budgeted 1,178.33 Remaining 2 % Used Account: 135-60080-026-000 Schools & Training 1672 06/03/2016 June A/P PFIA Training/Wilson 905.00 160.00 1,065.00 AWBD 1929 AP 1672 06/03/2016 June A/P AWBD Conference/Rose 405.00 1,470.00 AWBD 1929 AP 1672 06/03/2016 June A/P AWBD Conference/Wilson 405.00 1,875.00 AWBD 1929 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 970.00 1,875.00 ** 4,000.00 Budgeted 2,125.00 Remaining 47 % Used Account: 135-60100-026-000 Travel & per diem 1857 06/30/2016 June A/P Reimburse AWBD Expenses 1,602.43 324.08 1,926.51 KEVIN R. CARR 2074 AP 1857 06/30/2016 June A/P Reimburse AWBD Expenses 529.76 2,456.27 William Rose 2108 AP 1857 06/30/2016 June A/P Reimburse AWBD Expenses 595.10 3,051.37 Gregory Wilson 2062 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 1,448.94 3,051.37 ** 5,000.00 Budgeted 1,948.63 Remaining 61 % Used Account: 135-60245-026-000 Miscellaneous Expenses 219.88 .00 219.88 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 219.88 ** 2,000.00 Budgeted 1,780.12 Remaining 11 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 11,283.73 ** 26,368.00 Budgeted 15,084.27 Remaining 43 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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 1627 06/03/2016 MUD Payroll 6/3/16 Salaries & Wages 302,954.87 18,896.74 321,851.61 PR 1633 06/03/2016 Supplemental P/R 6/3/16 Salaries & Wages 58.58 321,910.19 PR 1739 06/17/2016 MUD Payroll 6/17/16 Salaries & Wages 18,908.41 340,818.60 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 37,863.73 340,818.60 ** 493,633.00 Budgeted 152,814.40 Remaining 69 % Used Account: 135-50010-030-000 Overtime 1627 06/03/2016 MUD Payroll 6/3/16 Overtime 482.99 3.94 486.93 PR 1739 06/17/2016 MUD Payroll 6/17/16 Overtime 4.22 491.15 PR _______________ Account: 135-50010-030-000 Overtime Totals: 8.16 491.15 ** 500.00 Budgeted 8.85 Remaining 98 % Used Account: 135-50016-030-000 Longevity 3,822.50 .00 3,822.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,822.50 ** 3,823.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1627 06/03/2016 MUD Payroll 6/3/16 Retirement 27,038.78 1,650.03 28,688.81 PR 1633 06/03/2016 Supplemental P/R 6/3/16 Retirement 5.11 28,693.92 PR 1739 06/17/2016 MUD Payroll 6/17/16 Retirement 1,651.07 30,344.99 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,306.21 30,344.99 ** 43,652.00 Budgeted 13,307.01 Remaining 70 % Used Account: 135-50026-030-000 Medical Insurance 1627 06/03/2016 MUD Payroll 6/3/16 Medical Insurance 41,217.23 2,544.73 43,761.96 PR 1739 06/17/2016 MUD Payroll 6/17/16 Medical Insurance 2,544.70 46,306.66 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,089.43 46,306.66 ** 68,196.00 Budgeted 21,889.34 Remaining 68 % Used Account: 135-50027-030-000 Dental Insurance 1627 06/03/2016 MUD Payroll 6/3/16 Dental Insurance 2,841.78 170.45 3,012.23 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1739 06/17/2016 MUD Payroll 6/17/16 Dental Insurance 2,841.78 170.42 3,182.65 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 340.87 3,182.65 ** 4,807.00 Budgeted 1,624.35 Remaining 66 % Used Account: 135-50028-030-000 Vision Insurance 1627 06/03/2016 MUD Payroll 6/3/16 Vision Insurance 655.33 40.63 695.96 PR 1739 06/17/2016 MUD Payroll 6/17/16 Vision Insurance 40.57 736.53 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 81.20 736.53 ** 1,114.00 Budgeted 377.47 Remaining 66 % Used Account: 135-50029-030-000 Life Insurance & Other 1672 06/03/2016 June A/P June Dental, Vision, LTD, STD, 3,120.59 368.04 3,488.63 METLIFE GROUP BENEFITS 1975 AP 1824 06/28/2016 June A/P Rounding adjustment (.02) 3,488.61 Legal Shield 2078 AP 1824 06/28/2016 June A/P Café 125 Adm fees 29.16 3,517.77 BenefitMall 2045 AP 1913 06/30/2016 Vol Life Rounding Adj (.02) 3,517.75 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 397.16 3,517.75 ** 5,431.00 Budgeted 1,913.25 Remaining 65 % Used Account: 135-50030-030-000 Social Security Taxes 1627 06/03/2016 MUD Payroll 6/3/16 Social Security Taxes 17,721.45 1,100.23 18,821.68 PR 1633 06/03/2016 Supplemental P/R 6/3/16 Social Security Taxes 3.63 18,825.31 PR 1739 06/17/2016 MUD Payroll 6/17/16 Social Security Taxes 1,088.68 19,913.99 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,192.54 19,913.99 ** 31,141.00 Budgeted 11,227.01 Remaining 64 % Used Account: 135-50035-030-000 Medicare Taxes 1627 06/03/2016 MUD Payroll 6/3/16 Medicare Taxes 4,144.52 257.32 4,401.84 PR 1633 06/03/2016 Supplemental P/R 6/3/16 Medicare Taxes .85 4,402.69 PR 1739 06/17/2016 MUD Payroll 6/17/16 Medicare Taxes 254.60 4,657.29 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 512.77 4,657.29 ** 7,678.00 Budgeted 3,020.71 Remaining 61 % Used Account: 135-50040-030-000 Unemployment Taxes . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,197.00 .00 1,197.00 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 1,197.00 ** 1,197.00 Budgeted .00 Remaining 100 % Used Account: 135-50045-030-000 Workman's Compensation 140 06/01/2016 Prepaid Insurance, W/C Jun 1,475.12 147.89 1,623.01 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 147.89 1,623.01 ** 1,554.00 Budgeted (69.01) Remaining 104 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 1871 06/27/2016 June A/P BUC-EE'S #37 3,029.86 71.09 3,100.95 BUC-EE'S #37 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 71.09 3,100.95 ** 4,500.00 Budgeted 1,399.05 Remaining 69 % Used Account: 135-55030-030-000 Software & Support 1779 06/20/2016 June A/P Internet 35,907.45 1,120.77 37,028.22 WHOLESALE CARRIER SERVICES INC 2029 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 1,120.77 37,028.22 ** 81,097.00 Budgeted 44,068.78 Remaining 46 % Used Account: 135-55070-030-000 Independent Labor 1767 06/17/2016 June A/P Record MUD meeting 1,139.38 67.50 1,206.88 MIGUEL CRUZ 2012 AP 1767 06/17/2016 June A/P Record MUD meeting 97.50 1,304.38 MIGUEL CRUZ 2012 AP 1767 06/17/2016 June A/P Record MUD meeting 81.75 1,386.13 MIGUEL CRUZ 2012 AP 1795 06/21/2016 Void A/P Check 2012 Record MUD meeting (67.50) 1,318.63 MIGUEL CRUZ 2012 AP 1795 06/21/2016 Void A/P Check 2012 Record MUD meeting (97.50) 1,221.13 MIGUEL CRUZ 2012 AP 1795 06/21/2016 Void A/P Check 2012 Record MUD meeting (81.75) 1,139.38 MIGUEL CRUZ 2012 AP 1827 06/29/2016 June A/P Record MUD Meeting 2/16/16 67.50 1,206.88 MIGUEL CRUZ 2032 AP 1827 06/29/2016 June A/P Record MUD Meeting 4/19/16 81.75 1,288.63 MIGUEL CRUZ 2032 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-030-000 Independent Labor Totals: 149.25 1,288.63 ** 12,000.00 Budgeted 10,711.37 Remaining 11 % Used Account: 135-55080-030-000 Maintenance & Repairs 1833 06/23/2016 Recode Generator repair/15796 Worldwide Pwr Inv 15796 6,088.35 (1,903.50) 4,184.85 GL 1824 06/28/2016 June A/P Battery charger for Ofc Genera 1,903.50 6,088.35 WORLDWIDE POWER PRODUCTS 2111 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 6,088.35 ** 7,000.00 Budgeted 911.65 Remaining 87 % Used Account: 135-55100-030-000 Building Maint & Supplies 1833 06/23/2016 Recode Generator repair/15796 Worldwide Pwr Inv 15796 4,948.70 1,903.50 6,852.20 GL 1857 06/30/2016 June A/P Coolant Leak on Generator 415.00 7,267.20 WORLDWIDE POWER PRODUCTS 2111 AP 1868 06/30/2016 June A/P Rug Service MUD & PS Bldgs 130.89 7,398.09 G & K SERVICES 2061 AP 1868 06/30/2016 June A/P Rug Service MUD & PS Bldgs 130.89 7,528.98 G & K SERVICES 2061 AP 1907 06/30/2016 June A/P Generator repair/MUD bldg 636.06 8,165.04 WORLDWIDE POWER PRODUCTS AP 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (1,788.17) 6,376.87 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 1,428.17 6,376.87 ** 7,000.00 Budgeted 623.13 Remaining 91 % Used Account: 135-55120-030-000 Cleaning Services 1779 06/20/2016 June A/P Janitorial Service/May 3,834.25 843.75 4,678.00 HUDSON ENERGY SERVICES, LLC 2023 AP 1781 06/20/2016 Void A/P Ck2023/Hudson Janitorial Service/May (843.75) 3,834.25 HUDSON ENERGY SERVICES, LLC 2023 AP 1782 06/20/2016 June A/P May Janitorial service 843.75 4,678.00 MEMBER'S BUILDING MAINTENANCE 2031 AP 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (259.00) 4,419.00 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 584.75 4,419.00 ** 10,125.00 Budgeted 5,706.00 Remaining 44 % Used Account: 135-55160-030-000 Professional Outside Services 1824 06/28/2016 June A/P Rate assistance 53,072.50 4,972.50 58,045.00 NEW GEN STRATEGIES & SOLUTIONS 2085 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 4,972.50 58,045.00 ** 72,575.00 Budgeted 14,530.00 Remaining 80 % Used Account: 135-55165-030-000 Collection Fees . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 1779 06/20/2016 June A/P Printing/Inserts Water bills 4,962.21 1,165.00 6,127.21 DATAPROSE LLC 2019 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,165.00 6,127.21 ** 8,200.00 Budgeted 2,072.79 Remaining 75 % Used Account: 135-60005-030-000 Telephone 1871 06/27/2016 June A/P RINGCENTRAL, INC 9,091.77 10.73 9,102.50 RINGCENTRAL, INC PC 1871 06/27/2016 June A/P ATT*BUS PHONE PMT 953.90 10,056.40 ATT*BUS PHONE PMT PC 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (560.44) 9,495.96 AR _______________ Account: 135-60005-030-000 Telephone Totals: 404.19 9,495.96 ** 16,349.00 Budgeted 6,853.04 Remaining 58 % Used Account: 135-60010-030-000 Communications/Mobiles 1739 06/17/2016 MUD Payroll 6/17/16 Communications/Mobiles 2,801.33 300.00 3,101.33 PR 1779 06/20/2016 June A/P 5/2-6/1 Cell phones 37.99 3,139.32 VERIZON WIRELESS 2027 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 337.99 3,139.32 ** 4,150.00 Budgeted 1,010.68 Remaining 76 % Used Account: 135-60020-030-000 Electricity/Gas 1864 06/30/2016 June A/P 4,661.10 788.09 5,449.19 TOWN OF TROPHY CLUB 2101 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 788.09 5,449.19 ** 10,768.00 Budgeted 5,318.81 Remaining 51 % Used Account: 135-60025-030-000 Water 1864 06/30/2016 June A/P June Water 576.56 114.79 691.35 TROPHY CLUB MUD (WATER BILLS) 2102 AP 1915 06/30/2016 Town Billed/June AR 20160630-20160630 User: (57.40) 633.95 AR _______________ Account: 135-60025-030-000 Water Totals: 57.39 633.95 ** 1,500.00 Budgeted 866.05 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-60035-030-000 Postage 1767 06/17/2016 June A/P Postage/MUD CCR 15,801.95 742.93 16,544.88 U.S. POSTAL SERVICE 2015 AP 1767 06/17/2016 June A/P Postage/PID CCR 339.41 16,884.29 U.S. POSTAL SERVICE 2016 AP 1779 06/20/2016 June A/P Printing/Inserts Water bills 1,663.48 18,547.77 DATAPROSE LLC 2019 AP 1871 06/27/2016 June A/P USPS 48764506630613152 6.47 18,554.24 USPS 48764506630613152 PC 1871 06/27/2016 June A/P UPS*000000159E19216 108.72 18,662.96 UPS*000000159E19216 PC 1824 06/28/2016 June A/P Overnight letter 5.24 18,668.20 FEDERAL EXPRESS CORP 2060 AP _______________ Account: 135-60035-030-000 Postage Totals: 2,866.25 18,668.20 ** 28,932.00 Budgeted 10,263.80 Remaining 65 % Used Account: 135-60040-030-000 Service Charges & Fees 1865 06/02/2016 Credit Card fees 37,382.53 3,111.02 40,493.55 GL 1865 06/02/2016 Credit Card fees 52.86 40,546.41 GL 1628 06/03/2016 Child support fee 6/3/16 P/R 1.50 40,547.91 GL 1740 06/17/2016 Child support fee 6/17/16 P/R 1.50 40,549.41 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,166.88 40,549.41 ** 55,560.00 Budgeted 15,010.59 Remaining 73 % Used Account: 135-60050-030-000 Bad Debt Expense 1858 06/30/2016 UB 6/30/16 Write Offs UB20160630-20160630 User: 2,015.35 1,007.27 3,022.62 UB _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 1,007.27 3,022.62 ** 3,500.00 Budgeted 477.38 Remaining 86 % Used Account: 135-60055-030-000 Insurance 140 06/01/2016 Prepaid Insurance, W/C Jun 22,349.00 2,756.00 25,105.00 GL 1824 06/28/2016 June A/P Directors Bond 200.00 25,305.00 VICTOR O SCHINNERER & CO, INC 2105 AP _______________ Account: 135-60055-030-000 Insurance Totals: 2,956.00 25,305.00 ** 52,797.00 Budgeted 27,492.00 Remaining 48 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 260.00 .00 260.00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 260.00 ** 1,600.00 Budgeted 1,340.00 Remaining 16 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-030-000 Dues & Memberships 5,306.25 .00 5,306.25 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 5,306.25 ** 6,000.00 Budgeted 693.75 Remaining 88 % Used Account: 135-60075-030-000 Meetings 1871 06/27/2016 June A/P ITALIAN BISTRO 29.00 38.50 67.50 ITALIAN BISTRO PC _______________ Account: 135-60075-030-000 Meetings Totals: 38.50 67.50 ** 400.00 Budgeted 332.50 Remaining 17 % Used Account: 135-60079-030-000 Public Education 4,230.34 .00 4,230.34 _______________ Account: 135-60079-030-000 Public Education Totals: .00 4,230.34 ** 5,000.00 Budgeted 769.66 Remaining 85 % Used Account: 135-60080-030-000 Schools & Training 3,382.00 .00 3,382.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 3,382.00 ** 9,935.00 Budgeted 6,553.00 Remaining 34 % Used Account: 135-60100-030-000 Travel & per diem 1627 06/03/2016 MUD Payroll 6/3/16 Travel & per diem 2,808.27 393.01 3,201.28 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 393.01 3,201.28 ** 5,400.00 Budgeted 2,198.72 Remaining 59 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 3,210.41 .00 3,210.41 _______________ Account: 135-60115-030-000 Elections Totals: .00 3,210.41 ** 7,500.00 Budgeted 4,289.59 Remaining 43 % Used Account: 135-60125-030-000 Advertising 61.74 .00 61.74 _______________ Account: 135-60125-030-000 Advertising Totals: .00 61.74 ** 7,500.00 Budgeted 7,438.26 Remaining 1 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 5,276.50 .00 5,276.50 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 5,276.50 ** 17,501.00 Budgeted 12,224.50 Remaining 30 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 656.38 .00 656.38 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 656.38 ** 2,500.00 Budgeted 1,843.62 Remaining 26 % Used Account: 135-65010-030-000 Uniforms 23.00 .00 23.00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 23.00 ** 1,855.00 Budgeted 1,832.00 Remaining 1 % Used Account: 135-65055-030-000 Hardware 5,871.85 .00 5,871.85 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/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-65055-030-000 Hardware Totals: .00 5,871.85 ** 13,594.00 Budgeted 7,722.15 Remaining 43 % Used Account: 135-65085-030-000 Office Supplies 1779 06/20/2016 June A/P Office Supplies 3,753.01 78.70 3,831.71 OFFICE DEPOT, INC 2024 AP 1871 06/27/2016 June A/P STAPLES 00116533 10.80 3,842.51 STAPLES 00116533 PC 1871 06/27/2016 June A/P AMAZON.COM 47.98 3,890.49 AMAZON.COM PC 1824 06/28/2016 June A/P Ink Cartridge for postage mete 107.95 3,998.44 ASI BUSINESS SOLUTIONS LTD 2043 AP 1824 06/28/2016 June A/P Office Supplies 64.91 4,063.35 OFFICE DEPOT, INC 2086 AP 1857 06/30/2016 June A/P Office Supplies 64.19 4,127.54 OFFICE DEPOT, INC 2086 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 374.53 4,127.54 ** 9,000.00 Budgeted 4,872.46 Remaining 46 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1871 06/27/2016 June A/P SHI GOVERNMENT SOLUTIO 406.44 448.74 855.18 SHI GOVERNMENT SOLUTIO PC 1871 06/27/2016 June A/P SHI GOVERNMENT SOLUTIO 149.45 1,004.63 SHI GOVERNMENT SOLUTIO PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 598.19 1,004.63 ** 4,003.00 Budgeted 2,998.37 Remaining 25 % Used Account: 135-65095-030-000 Maintenance Supplies 1871 06/27/2016 June A/P AMAZON.COM 2,376.92 84.86 2,461.78 AMAZON.COM PC 1871 06/27/2016 June A/P AMAZON MKTPLACE PMTS 59.94 2,521.72 AMAZON MKTPLACE PMTS PC 1871 06/27/2016 June A/P AMAZON MKTPLACE PMTS 32.95 2,554.67 AMAZON MKTPLACE PMTS PC 1871 06/27/2016 June A/P AMAZON.COM 33.73 2,588.40 AMAZON.COM PC 1871 06/27/2016 June A/P SAMSCLUB #4795 120.87 2,709.27 SAMSCLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 332.35 2,709.27 ** 5,000.00 Budgeted 2,290.73 Remaining 54 % Used Account: 135-65105-030-000 Printing 1824 06/28/2016 June A/P Printing of CCR Reports 1,348.88 1,437.34 2,786.22 LOGAN GRAPHICS, INC 2081 AP _______________ Account: 135-65105-030-000 Printing Totals: 1,437.34 2,786.22 ** 4,800.00 Budgeted 2,013.78 Remaining 58 % Used Account: 135-69005-030-000 Capital Outlays . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1779 06/20/2016 June A/P Restroom renovation 8,260.90 1,857.50 10,118.40 CP&Y/WALLACE GROUP, INC. 2018 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 1,857.50 10,118.40 ** 56,000.00 Budgeted 45,881.60 Remaining 18 % Used Account: 135-69170-030-000 Copier Lease Installments 1779 06/20/2016 June A/P Copier Lease 2,197.38 165.00 2,362.38 EVERBANK COMMERCIAL FINANCE 2020 AP 1824 06/28/2016 June A/P Copier Copy charge 80.64 2,443.02 KYOCERA DOCUMENT SOLUTIONS 2075 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 245.64 2,443.02 ** 4,600.00 Budgeted 2,156.98 Remaining 53 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 740,086.33 ** 1,203,217.00 Budgeted 463,130.67 Remaining 62 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 6/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 1824 06/28/2016 June A/P General Legal/May 204,437.89 6,976.24 211,414.13 THE LISTON LAW FIRM, P.C. 2099 AP 1824 06/28/2016 June A/P PUC/May 810.00 212,224.13 THE LISTON LAW FIRM, P.C. 2099 AP 1824 06/28/2016 June A/P FW Waterline/May 60.00 212,284.13 THE LISTON LAW FIRM, P.C. 2099 AP 1824 06/28/2016 June A/P WWTP-WCP Contract/May 639.75 212,923.88 THE LISTON LAW FIRM, P.C. 2099 AP 1824 06/28/2016 June A/P PUC 6/1-6/19/16 1,502.24 214,426.12 THE LISTON LAW FIRM, P.C. 2099 AP 1868 06/30/2016 June A/P Legal/Ethics Complaint 216.50 214,642.62 THE LISTON LAW FIRM, P.C. 2099 AP 1868 06/30/2016 June A/P Legal/Fort Worth Waterline 128.95 214,771.57 THE LISTON LAW FIRM, P.C. 2099 AP 1868 06/30/2016 June A/P Legal/General 10,448.75 225,220.32 THE LISTON LAW FIRM, P.C. 2099 AP 1868 06/30/2016 June A/P Legal/PUC Rate Challenge 6/20- 1,347.99 226,568.31 THE LISTON LAW FIRM, P.C. 2099 AP 1868 06/30/2016 June A/P Legal/Town Hall 1,204.50 227,772.81 THE LISTON LAW FIRM, P.C. 2099 AP 1907 06/30/2016 June A/P June Legal 930.00 228,702.81 FREEMAN & CORBETT AP _______________ Account: 135-55045-039-000 Legal Totals: 24,264.92 228,702.81 ** 386,130.00 Budgeted 157,427.19 Remaining 59 % Used Account: 135-55055-039-000 Auditing 24,039.38 .00 24,039.38 _______________ Account: 135-55055-039-000 Auditing Totals: .00 24,039.38 ** 24,039.00 Budgeted (.38) Remaining 100 % Used Account: 135-55060-039-000 Appraisal 1672 06/03/2016 June A/P Third Qtr. DCAD 2016 Budget 6,224.41 1,994.51 8,218.92 DENTON CENTRAL APPRAISAL DISTR 1936 AP 1830 06/27/2016 TAD/FY2015 Budget Refund (125.26) 8,093.66 GL _______________ Account: 135-55060-039-000 Appraisal Totals: 1,869.25 8,093.66 ** 10,265.00 Budgeted 2,171.34 Remaining 79 % Used Account: 135-55065-039-000 Tax Admin Fees 2,468.82 .00 2,468.82 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,468.82 ** 3,800.00 Budgeted 1,331.18 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 263,304.67 ** 424,234.00 Budgeted 160,929.33 Remaining 62 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 583,821.46 .00 Budgeted (583,821.46) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (75,000.00) .00 (75,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (75,000.00) ** .00 Budgeted 75,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (156,420.00) ** .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ (156,420.00) .00 Budgeted 156,420.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income (2.77) .00 (2.77) _______________ Account: 507-49010-000-000 Interest Income Totals: .00 (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2.77) ** .00 Budgeted 2.77 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 6/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-60335-020-000 Interfund Transfer Out (GF) 8,034.36 .00 8,034.36 _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: .00 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 8,034.36 ** .00 Budgeted (8,034.36) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 8,031.59 .00 Budgeted (8,031.59) Remaining 0 % Used TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET JUNE 2016 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,387,066 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,387,066 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,378,563 NET REVENUES / EXPENDITURES 8,503 TOTAL FUND BALANCE 4,387,066 TOTAL LIABILITIES AND FUND BALANCE 4,387,066 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 10:45 07/11/16 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,309.47- 8,503.10- 8,503.10 Subtotal: 1,309.47- 8,503.10- 8,503.10 Program number: 1,309.47- 8,503.10- 8,503.10 Department number: Revenues 1,309.47- 8,503.10- 8,503.10 Revenues Subtotal ----------- 1,309.47- 8,503.10- 8,503.10 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,309.47- 8,503.10- 8,503.10 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 6/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 1876 06/30/2016 Bank Interest/Month (7,193.63) (1,309.47) (8,503.10) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,309.47) (8,503.10) ** .00 Budgeted 8,503.10 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (8,503.10) ** .00 Budgeted 8,503.10 Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (8,503.10) .00 Budgeted 8,503.10 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET JUNE 2016 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 4,483,416 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,483,416 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 468,585 TOTAL LIABILITIES 468,585 FUND BALANCE ASSIGNED FUND BALANCE 8,334,104 NET REVENUES / EXPENDITURES (4,319,273) TOTAL FUND BALANCE 4,014,831 TOTAL LIABILITIES AND FUND BALANCE 4,483,416 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 10:45 07/11/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 1,504.73- 13,606.23- 13,606.23 Subtotal: 1,504.73- 13,606.23- 13,606.23 Program number: 1,504.73- 13,606.23- 13,606.23 Department number: Revenues 1,504.73- 13,606.23- 13,606.23 Revenues Subtotal ----------- 1,504.73- 13,606.23- 13,606.23 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 10:45 07/11/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 4,332,879.49 4,332,879.49- Subtotal: 4,332,879.49 4,332,879.49- Program number: 4,332,879.49 4,332,879.49- Department number: Wastewater 4,332,879.49 4,332,879.49- Expenditures Subtotal ----------- 4,332,879.49 4,332,879.49- Fund number: 518 2015 Revenue Bond Const Fund 1,504.73- 4,319,273.26 4,319,273.26- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 6/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 1876 06/30/2016 Bank Interest/Month (12,101.50) (1,504.73) (13,606.23) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (1,504.73) (13,606.23) ** .00 Budgeted 13,606.23 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (13,606.23) ** .00 Budgeted 13,606.23 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 6/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 4,332,879.49 .00 4,332,879.49 _______________ Account: 518-69005-020-000 Capital Outlays Totals: .00 4,332,879.49 ** .00 Budgeted (4,332,879.49) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 4,332,879.49 ** .00 Budgeted (4,332,879.49) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ 4,319,273.26 .00 Budgeted (4,319,273.26) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JUNE 2016 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 164,747 ACCOUNTS RECEIVABLE - TOTAL ASSETS 164,747 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 71,962 NET REVENUES / EXPENDITURES 92,785 TOTAL FUND BALANCE 164,747 TOTAL LIABILITIES AND FUND BALANCE 164,747 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 10:45 07/11/16 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 49.17- 283.05- 283.05 528-49141-000-000 Interfund Transfer In-Gen Fund 123,336.00- 123,336.00- 92,502.00- 75.000 30,834.00- Subtotal: 123,336.00- 123,336.00- 49.17- 92,785.05- 75.229 30,550.95- Program number: 123,336.00- 123,336.00- 49.17- 92,785.05- 75.229 30,550.95- Department number: 123,336.00- 123,336.00- 49.17- 92,785.05- 75.229 30,550.95- Revenues Subtotal ----------- 123,336.00- 123,336.00- 49.17- 92,785.05- 75.229 30,550.95- Fund number: 528 2015 Revenue Bond Reserve Fund 123,336.00- 123,336.00- 49.17- 92,785.05- 75.229 30,550.95- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 6/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 1876 06/30/2016 Bank Interest/Month (233.88) (49.17) (283.05) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (49.17) (283.05) ** .00 Budgeted 283.05 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund (92,502.00) .00 (92,502.00) _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: .00 (92,502.00) ** (123,336.00) Budgeted (30,834.00) Remaining 75 % Used Department Totals: ------------------------------------------------------------------------------------------------ (92,785.05) ** (123,336.00) Budgeted (30,550.95) Remaining 75 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (92,785.05) (123,336.00) Budgeted (30,550.95) Remaining 75 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JUNE 2016 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 815,228 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 18,528 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 838,602 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 18,528 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 18,528 FUND BALANCE ASSIGNED FUND BALANCE 24,173 NET REVENUES / EXPENDITURES 795,901 TOTAL FUND BALANCE 820,074 TOTAL LIABILITIES AND FUND BALANCE 838,602 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 10:45 07/11/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 667,898.00- 667,898.00- 2,363.36- 653,128.64- 97.789 14,769.36- 533-40002-000-000 Property Taxes/Delinquent 2,300.00- 2,300.00- 3.88- 4,783.56- 207.981 2,483.56 533-40015-000-000 Property Taxes/P & I 1,800.00- 1,800.00- 81.47- 2,556.37- 142.021 756.37 Subtotal: 671,998.00- 671,998.00- 2,448.71- 660,468.57- 98.284 11,529.43- 533-49010-000-000 Interest Income 140.00- 140.00- 240.59- 1,191.47- 851.050 1,051.47 533-49015-000-000 Lease/Rental Income 214,379.00- 214,379.00- 214,379.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 119,706.00- 119,706.00- 19,951.00- 79,804.00- 66.667 39,902.00- Subtotal: 334,225.00- 334,225.00- 20,191.59- 295,374.47- 88.376 38,850.53- Program number: 1,006,223.00- 1,006,223.00- 22,640.30- 955,843.04- 94.993 50,379.96- Department number: Revenues 1,006,223.00- 1,006,223.00- 22,640.30- 955,843.04- 94.993 50,379.96- Revenues Subtotal ----------- 1,006,223.00- 1,006,223.00- 22,640.30- 955,843.04- 94.993 50,379.96- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 10:45 07/11/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/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 1,250.00 49.020 1,300.00 533-70025-051-000 Bond Interest Expense-Tax 316,983.00 316,983.00 158,691.25 50.063 158,291.75 533-70035-051-000 Bond Principal Payment-Tax 685,000.00 685,000.00 685,000.00 Subtotal: 1,004,533.00 1,004,533.00 159,941.25 15.922 844,591.75 Program number: 1,004,533.00 1,004,533.00 159,941.25 15.922 844,591.75 Department number: Administration 1,004,533.00 1,004,533.00 159,941.25 15.922 844,591.75 Expenditures Subtotal ----------- 1,004,533.00 1,004,533.00 159,941.25 15.922 844,591.75 Fund number: 533 MUD 1 I&S Consolidated 1,690.00- 1,690.00- 22,640.30- 795,901.79- ############### 794,211.79 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/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 1887 06/01/2016 Property Taxes (650,765.28) (1,065.62) (651,830.90) GL 1889 06/02/2016 Property Taxes (341.45) (652,172.35) GL 1890 06/03/2016 Property Taxes (153.07) (652,325.42) GL 1891 06/06/2016 Property Taxes (261.23) (652,586.65) GL 1893 06/07/2016 Property Taxes (79.42) (652,666.07) GL 1894 06/08/2016 Property Taxes (10.77) (652,676.84) GL 1895 06/10/2016 Property Taxes (106.75) (652,783.59) GL 1896 06/16/2016 Property Taxes (3.08) (652,786.67) GL 1897 06/17/2016 Property Taxes (11.98) (652,798.65) GL 1898 06/21/2016 Property Taxes (114.47) (652,913.12) GL 1899 06/22/2016 Property Taxes (49.70) (652,962.82) GL 1900 06/23/2016 Property Taxes (99.35) (653,062.17) GL 1901 06/29/2016 Property Taxes (66.47) (653,128.64) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (2,363.36) (653,128.64) ** (667,898.00) Budgeted (14,769.36) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1901 06/29/2016 Property Taxes (4,779.68) (3.88) (4,783.56) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (3.88) (4,783.56) ** (2,300.00) Budgeted 2,483.56 Remaining 208 % Used Account: 533-40015-000-000 Property Taxes/P & I 1887 06/01/2016 Property Taxes (2,474.90) (.07) (2,474.97) GL 1889 06/02/2016 Property Taxes (4.40) (2,479.37) GL 1890 06/03/2016 Property Taxes (2.56) (2,481.93) GL 1891 06/06/2016 Property Taxes (24.28) (2,506.21) GL 1893 06/07/2016 Property Taxes (2.03) (2,508.24) GL 1894 06/08/2016 Property Taxes (1.61) (2,509.85) GL 1895 06/10/2016 Property Taxes (12.08) (2,521.93) GL 1896 06/16/2016 Property Taxes (.24) (2,522.17) GL 1897 06/17/2016 Property Taxes (1.80) (2,523.97) GL 1898 06/21/2016 Property Taxes (17.17) (2,541.14) GL 1900 06/23/2016 Property Taxes (12.67) (2,553.81) GL 1901 06/29/2016 Property Taxes (2.56) (2,556.37) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (81.47) (2,556.37) ** (1,800.00) Budgeted 756.37 Remaining 142 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 57 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 6/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-49010-000-000 Interest Income 1876 06/30/2016 Bank Interest/Month (950.88) (240.59) (1,191.47) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (240.59) (1,191.47) ** (140.00) Budgeted 1,051.47 Remaining 851 % Used Account: 533-49015-000-000 Lease/Rental Income (214,379.00) .00 (214,379.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (214,379.00) ** (214,379.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 1769 06/14/2016 Texpool Transfers To MUD I&S/PID share new debt (59,853.00) (19,951.00) (79,804.00) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (19,951.00) (79,804.00) ** (119,706.00) Budgeted (39,902.00) Remaining 67 % Used Department Totals: ------------------------------------------------------------------------------------------------ (955,843.04) ** (1,006,223.00) Budgeted (50,379.96) Remaining 95 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 58 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 6/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 1,250.00 .00 1,250.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,250.00 ** 2,550.00 Budgeted 1,300.00 Remaining 49 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 158,691.25 .00 158,691.25 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 158,691.25 ** 316,983.00 Budgeted 158,291.75 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 685,000.00 Budgeted 685,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 159,941.25 ** 1,004,533.00 Budgeted 844,591.75 Remaining 16 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (795,901.79) (1,690.00) Budgeted 794,211.79 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET JUNE 2016 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 256,100 ACCOUNTS RECEIVABLE - TOTAL ASSETS 256,100 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,068 NET REVENUES / EXPENDITURES 241,032 TOTAL FUND BALANCE 256,100 TOTAL LIABILITIES AND FUND BALANCE 256,100 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 10:45 07/11/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 7.00- 7.00- 70.91- 253.39- 3,619.857 246.39 534-49143-000-000 Interfund Transfer In-WW Sales 444,831.00- 444,831.00- 43,220.32- 358,396.88- 80.569 86,434.12- Subtotal: 444,838.00- 444,838.00- 43,291.23- 358,650.27- 80.625 86,187.73- Program number: 444,838.00- 444,838.00- 43,291.23- 358,650.27- 80.625 86,187.73- Department number: Revenues 444,838.00- 444,838.00- 43,291.23- 358,650.27- 80.625 86,187.73- Revenues Subtotal ----------- 444,838.00- 444,838.00- 43,291.23- 358,650.27- 80.625 86,187.73- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 10:45 07/11/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 6/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 234,838.00 234,838.00 117,618.75 50.085 117,219.25 534-70045-051-000 Revenue Bond Principal Expense 210,000.00 210,000.00 210,000.00 Subtotal: 444,838.00 444,838.00 117,618.75 26.441 327,219.25 Program number: 444,838.00 444,838.00 117,618.75 26.441 327,219.25 Department number: Administration 444,838.00 444,838.00 117,618.75 26.441 327,219.25 Expenditures Subtotal ----------- 444,838.00 444,838.00 117,618.75 26.441 327,219.25 Fund number: 534 2015 Revenue Bond I&S 43,291.23- 241,031.52- 241,031.52 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 59 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 6/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 1876 06/30/2016 Bank Interest/Month (182.48) (70.91) (253.39) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (70.91) (253.39) ** (7.00) Budgeted 246.39 Remaining 3.620 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1769 06/14/2016 Texpool Transfers Xfer to Rev Bond I&S (315,176.56) (43,220.32) (358,396.88) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (43,220.32) (358,396.88) ** (444,831.00) Budgeted (86,434.12) Remaining 81 % Used Department Totals: ------------------------------------------------------------------------------------------------ (358,650.27) ** (444,838.00) Budgeted (86,187.73) Remaining 81 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 60 10:45 07/11/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 6/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 117,618.75 .00 117,618.75 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 117,618.75 ** 234,838.00 Budgeted 117,219.25 Remaining 50 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 210,000.00 Budgeted 210,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 117,618.75 ** 444,838.00 Budgeted 327,219.25 Remaining 26 % Used Fund 534 Totals: ------------------------------------------------------------------------------------------------------ (241,031.52) .00 Budgeted 241,031.52 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 3,355,905.82 **** (125,026.00) Budgeted (3,480,931.82) Remaining ########## ******* End of Report *********