Loading...
HomeMy WebLinkAbout2016-07 July Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JULY 2016 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 738,187 PREPAID EXPENSES 2,346 ADVALOREM PROPERTY TAXES RECEIVABLE 20,731 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE 5,558 TOTAL ASSETS 766,822 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 20,731 ACCOUNTS AND OTHER PAYABLES 70,880 TOTAL LIABILITIES 91,611 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 533,497 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 141,714 TOTAL FUND BALANCE 675,211 TOTAL LIABILITIES AND FUND BALANCE 766,822 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 19:17 08/11/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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- 1,968.03- 872,243.58- 98.009 17,719.42- 122-40011-000-000 Property Taxes/Fire-Delinquent 7,360.42- 17,058.43- 17,058.43 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- 1,685.55- 6,695.54- 148.790 2,195.54 Subtotal: 1,299,559.00- 1,298,809.00- 11,014.00- 1,267,633.95- 97.600 31,175.05- 122-42014-000-000 Fire Plan Review>6,000 sq ft 5,000.00- 5,000.00- 4,800.00- 96.000 200.00- Subtotal: 5,000.00- 5,000.00- 4,800.00- 96.000 200.00- 122-43400-000-000 Fire Inspections 825.00- 825.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- 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- 10,200.00- 101.990 199.00 Subtotal: 50,000.00- 70,001.00- 70,200.00- 100.284 199.00 Program number: 1,365,384.00- 1,384,635.00- 11,014.00- 1,353,633.95- 97.761 31,001.05- Department number: Fire Revenues 1,365,384.00- 1,384,635.00- 11,014.00- 1,353,633.95- 97.761 31,001.05- Revenues Subtotal ----------- 1,365,384.00- 1,384,635.00- 11,014.00- 1,353,633.95- 97.761 31,001.05- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 19:17 08/11/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 68,402.28 407,537.93 80.188 100,688.07 122-50010-045-000 Overtime 48,735.00 48,735.00 9,120.36 53,785.49 110.363 5,050.49- 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 3,390.13 80.717 809.87 122-50020-045-000 Retirement 75,571.00 75,571.00 8,622.67 59,238.55 78.388 16,332.45 122-50026-045-000 Medical Insurance 65,546.00 65,546.00 4,687.83 44,597.54 68.040 20,948.46 122-50027-045-000 Dental Insurance 4,885.00 4,885.00 384.21 4,061.93 83.151 823.07 122-50028-045-000 Vision Insurance 859.00 859.00 71.52 805.81 93.808 53.19 122-50029-045-000 Life Insurance & Other 4,585.00 4,585.00 342.32 3,152.94 68.766 1,432.06 122-50030-045-000 Social Security Taxes 36,132.00 36,132.00 4,015.91 27,312.29 75.590 8,819.71 122-50035-045-000 Medicare Taxes 8,450.00 8,450.00 938.97 6,385.85 75.572 2,064.15 122-50040-045-000 Unemployment Taxes 1,724.00 2,000.00 35.89 2,120.75 106.038 120.75- 122-50045-045-000 Workman's Compensation 9,379.00 9,379.00 781.58 7,815.84 83.333 1,563.16 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 97,853.54 640,706.58 81.058 149,724.42 122-55030-045-000 Software & Support 6,661.00 6,661.00 925.00 5,098.31 76.540 1,562.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 15,016.46 35,483.73 140.708 10,265.73- 122-55090-045-000 Vehicle Maintenance 10,000.00 10,000.00 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 15,941.46 62,603.43 133.543 15,724.43- 122-60005-045-000 Telephone 50.00 50.00 .02- 38.55 77.100 11.45 122-60010-045-000 Communications/Mobiles 6,653.00 7,706.00 364.43 6,301.80 81.778 1,404.20 122-60020-045-000 Electricity/Gas 7,412.00 7,412.00 639.25 4,100.61 55.324 3,311.39 122-60025-045-000 Water 1,200.00 1,200.00 291.41 1,565.56 130.463 365.56- 122-60026-045-000 Cable 1,920.00 1,920.00 152.91 1,547.72 80.610 372.28 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.00 42.77 85.540 7.23 122-60055-045-000 Insurance 14,077.00 18,451.00 391.50 8,288.74 44.923 10,162.26 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 150.00 3,338.39 48.523 3,541.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,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 1,943.86 3,073.25 40.977 4,426.75 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 603.50 2,355.34 73.974 828.66 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 19:17 08/11/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 838.01 83.717 162.99 Subtotal: 292,019.00 298,646.00 4,553.84 273,820.01 91.687 24,825.99 122-65005-045-000 Fuel & Lube 15,122.00 15,122.00 426.73 3,698.42 24.457 11,423.58 122-65010-045-000 Uniforms 3,140.00 3,640.00 2,632.50 6,446.69 177.107 2,806.69- 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 537.00 1,191.00 198.500 591.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 327.54 65.508 172.46 122-65105-045-000 Printing 498.00 498.00 498.00 Subtotal: 31,610.00 32,110.00 3,596.23 18,287.37 56.952 13,822.63 122-69050-045-000 Radios 8,000.00 8,000.00 7,933.89 7,933.89 99.174 66.11 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 7,933.89 216,502.49 99.969 66.51 Program number: 1,365,384.00 1,384,635.00 129,878.96 1,211,919.88 87.526 172,715.12 Department number: Fire 1,365,384.00 1,384,635.00 129,878.96 1,211,919.88 87.526 172,715.12 Expenditures Subtotal ----------- 1,365,384.00 1,384,635.00 129,878.96 1,211,919.88 87.526 172,715.12 Fund number: 122 Trophy Club MUD Fire Dept. 118,864.96 141,714.07- 141,714.07 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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 2049 07/01/2016 Property Taxes (870,275.55) (407.45) (870,683.00) GL 2050 07/07/2016 Property Taxes (9.69) (870,692.69) GL 2062 07/08/2016 Property Taxes (42.32) (870,735.01) GL 2063 07/11/2016 Property Taxes (99.84) (870,834.85) GL 2064 07/14/2016 Property Taxes (54.08) (870,888.93) GL 2065 07/15/2016 Property Taxes (28.31) (870,917.24) GL 2066 07/18/2016 Property Taxes (116.18) (871,033.42) GL 2067 07/20/2016 Property Taxes (179.92) (871,213.34) GL 2068 07/21/2016 Property Taxes (115.70) (871,329.04) GL 2069 07/22/2016 Property Taxes (127.62) (871,456.66) GL 2070 07/25/2016 Property Taxes (89.97) (871,546.63) GL 2071 07/26/2016 Property Taxes (125.08) (871,671.71) GL 2072 07/27/2016 Property Taxes (447.94) (872,119.65) GL 2073 07/28/2016 Property Taxes (87.82) (872,207.47) GL 2074 07/29/2016 Property Taxes (36.11) (872,243.58) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (1,968.03) (872,243.58) ** (889,963.00) Budgeted (17,719.42) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2062 07/08/2016 Property Taxes (9,698.01) (7,360.42) (17,058.43) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (7,360.42) (17,058.43) ** .00 Budgeted 17,058.43 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2049 07/01/2016 Property Taxes (5,009.99) (65.50) (5,075.49) GL 2062 07/08/2016 Property Taxes (1,588.03) (6,663.52) GL 2063 07/11/2016 Property Taxes (7.99) (6,671.51) GL 2066 07/18/2016 Property Taxes (1.73) (6,673.24) GL 2072 07/27/2016 Property Taxes (21.69) (6,694.93) GL 2073 07/28/2016 Property Taxes (.61) (6,695.54) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (1,685.55) (6,695.54) ** (4,500.00) Budgeted 2,195.54 Remaining 149 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft (4,800.00) .00 (4,800.00) _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 (4,800.00) ** (5,000.00) Budgeted (200.00) Remaining 96 % Used Account: 122-43400-000-000 Fire Inspections (1,000.00) .00 (1,000.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .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 (10,200.00) .00 (10,200.00) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (10,200.00) ** (10,001.00) Budgeted 199.00 Remaining 102 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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: ------------------------------------------------------------------------------------------------ (1,353,633.95) ** (1,384,635.00) Budgeted (31,001.05) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 1867 07/01/2016 Fire Payroll 7/1/16 339,135.65 15,745.81 354,881.46 GL 1950 07/15/2016 FD Payroll 7/15/16 19,367.88 374,249.34 GL 2080 07/29/2016 Fire Payroll 7/29/16 23,277.67 397,527.01 GL 2117 07/31/2016 July A/P Charter,Gexa,Lasky,Verizon 4,023.80 401,550.81 TOWN OF TROPHY CLUB AP 2117 07/31/2016 July A/P Charter,Gexa,Lasky,Verizon 2,531.20 404,082.01 TOWN OF TROPHY CLUB AP 2117 07/31/2016 July A/P Charter,Gexa,Lasky,Verizon 3,455.92 407,537.93 TOWN OF TROPHY CLUB AP _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 68,402.28 407,537.93 ** 508,226.00 Budgeted 100,688.07 Remaining 80 % Used Account: 122-50010-045-000 Overtime 1867 07/01/2016 Fire Payroll 7/1/16 44,665.13 3,906.30 48,571.43 GL 2080 07/29/2016 Fire Payroll 7/29/16 5,214.06 53,785.49 GL _______________ Account: 122-50010-045-000 Overtime Totals: 9,120.36 53,785.49 ** 48,735.00 Budgeted (5,050.49) Remaining 110 % 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 1867 07/01/2016 Fire Payroll 7/1/16 2,940.13 450.00 3,390.13 GL _______________ Account: 122-50017-045-000 Certification Totals: 450.00 3,390.13 ** 4,200.00 Budgeted 809.87 Remaining 81 % Used Account: 122-50020-045-000 Retirement 1867 07/01/2016 Fire Payroll 7/1/16 50,615.88 2,543.75 53,159.63 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1950 07/15/2016 FD Payroll 7/15/16 50,615.88 2,469.32 55,628.95 GL 2080 07/29/2016 Fire Payroll 7/29/16 3,609.60 59,238.55 GL _______________ Account: 122-50020-045-000 Retirement Totals: 8,622.67 59,238.55 ** 75,571.00 Budgeted 16,332.45 Remaining 78 % Used Account: 122-50026-045-000 Medical Insurance 1867 07/01/2016 Fire Payroll 7/1/16 39,909.71 2,692.40 42,602.11 GL 1950 07/15/2016 FD Payroll 7/15/16 1,995.43 44,597.54 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,687.83 44,597.54 ** 65,546.00 Budgeted 20,948.46 Remaining 68 % Used Account: 122-50027-045-000 Dental Insurance 1867 07/01/2016 Fire Payroll 7/1/16 3,677.72 191.47 3,869.19 GL 1950 07/15/2016 FD Payroll 7/15/16 192.74 4,061.93 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 384.21 4,061.93 ** 4,885.00 Budgeted 823.07 Remaining 83 % Used Account: 122-50028-045-000 Vision Insurance 1867 07/01/2016 Fire Payroll 7/1/16 734.29 35.61 769.90 GL 1950 07/15/2016 FD Payroll 7/15/16 35.91 805.81 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 71.52 805.81 ** 859.00 Budgeted 53.19 Remaining 94 % Used Account: 122-50029-045-000 Life Insurance & Other 1867 07/01/2016 Fire Payroll 7/1/16 2,810.62 170.62 2,981.24 GL 1950 07/15/2016 FD Payroll 7/15/16 171.70 3,152.94 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 342.32 3,152.94 ** 4,585.00 Budgeted 1,432.06 Remaining 69 % Used Account: 122-50030-045-000 Social Security Taxes 1867 07/01/2016 Fire Payroll 7/1/16 23,296.38 1,143.20 24,439.58 GL 1950 07/15/2016 FD Payroll 7/15/16 1,106.35 25,545.93 GL 2080 07/29/2016 Fire Payroll 7/29/16 1,766.36 27,312.29 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-50030-045-000 Social Security Taxes Totals: 4,015.91 27,312.29 ** 36,132.00 Budgeted 8,819.71 Remaining 76 % Used Account: 122-50035-045-000 Medicare Taxes 1867 07/01/2016 Fire Payroll 7/1/16 5,446.88 267.26 5,714.14 GL 1950 07/15/2016 FD Payroll 7/15/16 258.69 5,972.83 GL 2080 07/29/2016 Fire Payroll 7/29/16 413.02 6,385.85 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 938.97 6,385.85 ** 8,450.00 Budgeted 2,064.15 Remaining 76 % Used Account: 122-50040-045-000 Unemployment Taxes 1867 07/01/2016 Fire Payroll 7/1/16 2,084.86 17.67 2,102.53 GL 1950 07/15/2016 FD Payroll 7/15/16 14.80 2,117.33 GL 2080 07/29/2016 Fire Payroll 7/29/16 3.42 2,120.75 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 35.89 2,120.75 ** 2,000.00 Budgeted (120.75) Remaining 106 % Used Account: 122-50045-045-000 Workman's Compensation 1762 07/01/2016 Breakout Fire W/C from Ins 7,034.26 781.58 7,815.84 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 781.58 7,815.84 ** 9,379.00 Budgeted 1,563.16 Remaining 83 % 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 2117 07/31/2016 July A/P Charter,Gexa,Lasky,Verizon 4,173.31 462.50 4,635.81 TOWN OF TROPHY CLUB AP 2117 07/31/2016 July A/P Charter,Gexa,Lasky,Verizon 462.50 5,098.31 TOWN OF TROPHY CLUB AP _______________ Account: 122-55030-045-000 Software & Support Totals: 925.00 5,098.31 ** 6,661.00 Budgeted 1,562.69 Remaining 77 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-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 1946 07/13/2016 July A/P Pest Control Fire station 20,467.27 140.00 20,607.27 GANN'S PEST CONTROL 2123 AP 2089 07/31/2016 July A/P Rug Service/Fire Station 37.24 20,644.51 G & K SERVICES 2173 AP 2089 07/31/2016 July A/P Rug Service/Fire Station 37.24 20,681.75 G & K SERVICES 2173 AP 2089 07/31/2016 July A/P Battery in Advance Warning fla 230.00 20,911.75 CONSOLIDATED TRAFFIC CONTROL 2163 AP 2089 07/31/2016 July A/P FD Electrical Work 1/2 draw 3,369.29 24,281.04 Service Time Electric 2205 AP 2089 07/31/2016 July A/P Leaking refrigeration lines 150.00 24,431.04 BRANDON R REED 2155 AP 2089 07/31/2016 July A/P Wrap/insulate refrigeration li 600.00 25,031.04 BRANDON R REED 2155 AP 2089 07/31/2016 July A/P grills leaking due to condensa 170.00 25,201.04 BRANDON R REED 2155 AP 2089 07/31/2016 July A/P Install return grill, complete 350.00 25,551.04 BRANDON R REED 2155 AP 2089 07/31/2016 July A/P Small supply air grills 130.00 25,681.04 BRANDON R REED 2155 AP 2089 07/31/2016 July A/P Fire station Server room A/C 3,288.00 28,969.04 BRANDON R REED 2155 AP 2089 07/31/2016 July A/P Install new A/C upstairs Fire 4,660.00 33,629.04 BRANDON R REED 2155 AP 2089 07/31/2016 July A/P Upstairs unit not working 310.00 33,939.04 BRANDON R REED 2155 AP 2096 07/31/2016 July A/P THE HOME DEPOT #6581 27.88 33,966.92 THE HOME DEPOT #6581 PC 2096 07/31/2016 July A/P THE HOME DEPOT 6581 39.00 34,005.92 THE HOME DEPOT 6581 PC 2096 07/31/2016 July A/P THE HOME DEPOT #6581 123.84 34,129.76 THE HOME DEPOT #6581 PC 2096 07/31/2016 July A/P THE HOME DEPOT 6581 40.77 34,170.53 THE HOME DEPOT 6581 PC 2096 07/31/2016 July A/P THE HOME DEPOT 6581 (149.81) 34,020.72 THE HOME DEPOT 6581 PC 2096 07/31/2016 July A/P THE HOME DEPOT 6581 63.03 34,083.75 THE HOME DEPOT 6581 PC 2096 07/31/2016 July A/P THE HOME DEPOT 6581 799.31 34,883.06 THE HOME DEPOT 6581 PC 2096 07/31/2016 July A/P GUINCO SERVICE 452.64 35,335.70 GUINCO SERVICE PC 2096 07/31/2016 July A/P THE HOME DEPOT 6581 27.62 35,363.32 THE HOME DEPOT 6581 PC 2096 07/31/2016 July A/P THE HOME DEPOT 6581 234.62 35,597.94 THE HOME DEPOT 6581 PC 2096 07/31/2016 July A/P THE HOME DEPOT 6581 (6.97) 35,590.97 THE HOME DEPOT 6581 PC 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (107.24) 35,483.73 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 15,016.46 35,483.73 ** 25,218.00 Budgeted (10,265.73) Remaining 141 % Used Account: 122-55090-045-000 Vehicle Maintenance 12,718.09 .00 12,718.09 _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: .00 12,718.09 ** 10,000.00 Budgeted (2,718.09) Remaining 127 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-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 2096 07/31/2016 July A/P ATT*BUS PHONE PMT 38.57 5.21 43.78 ATT*BUS PHONE PMT PC 2096 07/31/2016 July A/P ATT*BUS PHONE PMT 5.27 49.05 ATT*BUS PHONE PMT PC 2116 07/31/2016 Town July A/R billing (10.50) 38.55 AR _______________ Account: 122-60005-045-000 Telephone Totals: (.02) 38.55 ** 50.00 Budgeted 11.45 Remaining 77 % Used Account: 122-60010-045-000 Communications/Mobiles 1867 07/01/2016 Fire Payroll 7/1/16 5,937.37 75.00 6,012.37 GL 2117 07/31/2016 July A/P Charter,Gexa,Lasky,Verizon 132.27 6,144.64 TOWN OF TROPHY CLUB AP 2117 07/31/2016 July A/P Charter,Gexa,Lasky,Verizon 157.16 6,301.80 TOWN OF TROPHY CLUB AP _______________ Account: 122-60010-045-000 Communications/Mobiles Totals: 364.43 6,301.80 ** 7,706.00 Budgeted 1,404.20 Remaining 82 % Used Account: 122-60020-045-000 Electricity/Gas 1949 07/14/2016 July A/P Electricity 6/9-7/11/16 3,461.36 1,211.65 4,673.01 HUDSON ENERGY SERVICES, LLC 2125 AP 2089 07/31/2016 July A/P Gas/Fire station 66.84 4,739.85 ATMOS ENERGY 2150 AP 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (639.24) 4,100.61 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 639.25 4,100.61 ** 7,412.00 Budgeted 3,311.39 Remaining 55 % Used Account: 122-60025-045-000 Water 2089 07/31/2016 July A/P July Water 1,274.15 481.19 1,755.34 TROPHY CLUB MUD (WATER BILLS) 2220 AP 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (189.78) 1,565.56 AR _______________ Account: 122-60025-045-000 Water Totals: 291.41 1,565.56 ** 1,200.00 Budgeted (365.56) Remaining 130 % Used Account: 122-60026-045-000 Cable . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2058 07/19/2016 Firefighter Assoc Cable 1,394.81 (128.76) 1,266.05 GL 2096 07/31/2016 July A/P ATT*BILL PAYMENT 128.76 1,394.81 ATT*BILL PAYMENT PC 2096 07/31/2016 July A/P ATT*BILL PAYMENT 152.91 1,547.72 ATT*BILL PAYMENT PC _______________ Account: 122-60026-045-000 Cable Totals: 152.91 1,547.72 ** 1,920.00 Budgeted 372.28 Remaining 81 % 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 2096 07/31/2016 July A/P LONE STAR SAFETY & SUP 25.77 17.00 42.77 LONE STAR SAFETY & SUP PC _______________ Account: 122-60035-045-000 Postage Totals: 17.00 42.77 ** 50.00 Budgeted 7.23 Remaining 86 % Used Account: 122-60055-045-000 Insurance 141 07/01/2016 Prepaid Insurance, W/C Jul 7,897.24 1,173.08 9,070.32 GL 1762 07/01/2016 Breakout Fire W/C from Ins (781.58) 8,288.74 GL _______________ Account: 122-60055-045-000 Insurance Totals: 391.50 8,288.74 ** 18,451.00 Budgeted 10,162.26 Remaining 45 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-60080-045-000 Schools & Training 2089 07/31/2016 July A/P Training/Johnson 3,188.39 150.00 3,338.39 TARRANT COUNTY COLLEGE 2213 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 150.00 3,338.39 ** 6,880.00 Budgeted 3,541.61 Remaining 49 % 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 6,804.00 .00 6,804.00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .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 2096 07/31/2016 July A/P PROMOTIONS NOW 1,129.39 1,848.80 2,978.19 PROMOTIONS NOW PC 2096 07/31/2016 July A/P THE HOME DEPOT 6581 20.42 2,998.61 THE HOME DEPOT 6581 PC 2096 07/31/2016 July A/P PIZZA HUT 24623 69.68 3,068.29 PIZZA HUT 24623 PC 2096 07/31/2016 July A/P RANDALLS STORE00017897 4.96 3,073.25 RANDALLS STORE00017897 PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 1,943.86 3,073.25 ** 7,500.00 Budgeted 4,426.75 Remaining 41 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-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 2089 07/31/2016 July A/P Flags 1,751.84 1,207.00 2,958.84 SYMONDS FLAGS & POLES 2212 AP 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (603.50) 2,355.34 AR _______________ Account: 122-60195-045-000 Flags & Repair Totals: 603.50 2,355.34 ** 3,184.00 Budgeted 828.66 Remaining 74 % Used Account: 122-60245-045-000 Miscellaneous Expense 838.01 .00 838.01 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 838.01 ** 1,001.00 Budgeted 162.99 Remaining 84 % Used Account: 122-65005-045-000 Fuel & Lube 2089 07/31/2016 July A/P Fuel 3,271.69 426.73 3,698.42 US Bank Voyager Fleet Systems 2222 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 426.73 3,698.42 ** 15,122.00 Budgeted 11,423.58 Remaining 24 % Used Account: 122-65010-045-000 Uniforms 2089 07/31/2016 July A/P Uniforms 3,814.19 4,423.50 8,237.69 RED THE UNIFORM TAILOR 2204 AP 2089 07/31/2016 July A/P Uniforms 93.50 8,331.19 RED THE UNIFORM TAILOR 2204 AP 2089 07/31/2016 July A/P Uniforms 374.00 8,705.19 RED THE UNIFORM TAILOR 2204 AP 2089 07/31/2016 July A/P Unifoms 374.00 9,079.19 RED THE UNIFORM TAILOR 2204 AP 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (2,632.50) 6,446.69 AR _______________ Account: 122-65010-045-000 Uniforms Totals: 2,632.50 6,446.69 ** 3,640.00 Budgeted (2,806.69) Remaining 177 % Used Account: 122-65015-045-000 Protective Clothing 4,565.93 .00 4,565.93 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-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 2089 07/31/2016 July A/P Foam for E681 and B681 654.00 537.00 1,191.00 CASCO INDUSTRIES INC 2160 AP _______________ Account: 122-65030-045-000 Chemicals Totals: 537.00 1,191.00 ** 600.00 Budgeted (591.00) Remaining 199 % 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 327.54 .00 327.54 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 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 1946 07/13/2016 July A/P Fire Radios 7,933.89 7,933.89 MOTOROLA SOLUTIONS INC 2130 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-69050-045-000 Radios Totals: 7,933.89 7,933.89 ** 8,000.00 Budgeted 66.11 Remaining 99 % 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,211,919.88 ** 1,384,635.00 Budgeted 172,715.12 Remaining 88 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (141,714.07) .00 Budgeted 141,714.07 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JULY 2016 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 7/31/16 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK-CHECKING 481,175 - - 481,175 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 711,882 - - 711,882 INVESTMENTS-TEXPOOL 791,404 326,020 - 1,117,424 PREPAID EXPENSES 13,312 - - 13,312 ADVALOREM PROPERTY TAXES RECEIVABLE 2,181 - - 2,181 UTILITY AND OTHER ACCOUNTS RECEIVABLE 957,974 - - 957,974 TOTAL ASSETS 3,173,760 326,020 - 3,499,780 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,181 - - 2,181 ACCOUNTS AND OTHER PAYABLES 1,185,804 - - 1,185,804 CUSTOMER DEPOSITS 320,555 - - 320,555 - TOTAL LIABILITIES 1,508,540 - - 1,508,540 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 326,020 326,020 NON-SPENDABLE FUND BALANCE 13,311 13,311 ASSIGNED FUND BALANCE 202,390 - 202,390 UNASSIGNED FUND BALANCE 2,889,665 - 8,032 2,897,697 COMMITTED FUND BALANCE 40,000 - - 40,000 NET REVENUES / EXPENDITURES (1,480,146) - (8,032) (1,488,178) - TOTAL FUND BALANCE 1,665,220 326,020 - 1,991,240 - TOTAL LIABILITIES AND FUND BALANCE 3,173,760 326,020 - 3,499,780 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 19:17 08/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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- 128.62- 57,006.23- 97.981 1,174.77- 135-40002-000-000 Property Taxes/Delinquent 790.93- 2,065.79- 2,065.79 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 154.79- 653.62- 100.557 3.62 135-40025-000-000 PID Surcharges 146,125.00- 146,125.00- 146,125.00- Subtotal: 204,956.00- 204,956.00- 1,074.34- 59,725.64- 29.141 145,230.36- 135-47000-000-000 Water 5,080,244.00- 5,080,244.00- 551,426.06- 3,089,360.23- 60.811 1,990,883.77- 135-47005-000-000 Sewer 2,413,776.00- 2,413,776.00- 249,396.72- 1,825,266.73- 75.619 588,509.27- 135-47025-000-000 Penalties 90,985.00- 90,985.00- 8,944.15- 80,409.46- 88.377 10,575.54- 135-47030-000-000 Service Charges 9,000.00- 9,000.00- 525.00- 11,200.00- 124.444 2,200.00 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 250.00- 2,350.00- 117.500 350.00 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 750.00- 6,900.00- 125.455 1,400.00 135-47070-000-000 TCCC Effluent Charges 61,330.00- 61,330.00- 12,267.75- 24,810.20- 40.454 36,519.80- Subtotal: 7,662,835.00- 7,662,835.00- 823,559.68- 5,040,296.62- 65.776 2,622,538.38- 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,127.71- 10,555.25- 105.553 555.25 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 9,105.30- 83.336 1,820.70- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,833.30- 83.333 1,166.70- 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- 5,634.30- 49,595.72- 314.335 33,817.72 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- 41.77- 28,785.29- 45.511 34,463.71- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 28.40- 142.000 8.40 Subtotal: 110,993.00- 686,576.00- 8,297.64- 142,872.62- 20.809 543,703.38- Program number: 8,047,784.00- 8,609,567.00- 832,931.66- 5,298,094.88- 61.537 3,311,472.12- Department number: Revenues 8,047,784.00- 8,609,567.00- 832,931.66- 5,298,094.88- 61.537 3,311,472.12- Revenues Subtotal ----------- 8,047,784.00- 8,609,567.00- 832,931.66- 5,298,094.88- 61.537 3,311,472.12- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 19:17 08/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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 25,276.35 176,549.71 67.888 83,512.29 135-50010-010-000 Overtime 19,500.00 19,500.00 1,275.97 11,305.88 57.979 8,194.12 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 425.00 2,150.00 59.722 1,450.00 135-50020-010-000 Retirement 25,558.00 25,018.00 2,355.12 16,949.69 67.750 8,068.31 135-50026-010-000 Medical Insurance 51,398.00 51,398.00 3,161.10 31,104.31 60.517 20,293.69 135-50027-010-000 Dental Insurance 3,999.00 3,999.00 240.76 2,343.17 58.594 1,655.83 135-50028-010-000 Vision Insurance 910.00 910.00 53.94 527.12 57.925 382.88 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 200.95 1,959.52 69.908 843.48 135-50030-010-000 Social Security Taxes 18,565.00 18,146.00 1,668.43 11,875.33 65.443 6,270.67 135-50035-010-000 Medicare Taxes 4,341.00 4,243.00 390.20 2,777.28 65.456 1,465.72 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 9,978.98 67.636 4,775.02 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 36.82 112.04 37.347 187.96 Subtotal: 417,429.00 410,004.00 36,313.99 271,673.54 66.261 138,330.46 135-55005-010-000 Engineering 5,000.00 109,400.00 49,296.48 98,217.08 89.778 11,182.92 135-55080-010-000 Maintenance & Repairs 85,000.00 99,500.00 5,140.75 73,048.11 73.415 26,451.89 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 491.00 4,050.69 50.634 3,949.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 1,034.87 4,041.74 73.486 1,458.26 Subtotal: 107,000.00 225,900.00 55,963.10 182,250.39 80.677 43,649.61 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 694.22 4,022.74 74.495 1,377.26 135-60020-010-000 Electricity 166,823.00 166,823.00 17,580.72 106,067.35 63.581 60,755.65 135-60066-010-000 Publications/Books/Subscripts 500.00 500.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 25.00 1,545.00 26.763 4,228.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 53.90 378.54 25.236 1,121.46 135-60135-010-000 TCEQ Fees & Permits 49,275.00 49,275.00 4,613.20 17,788.20 36.100 31,486.80 135-60150-010-000 Wholesale Water 2,948,742.00 2,948,742.00 186,416.61 1,336,857.80 45.337 1,611,884.20 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 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 209,383.65 1,470,003.32 46.128 1,716,759.68 135-65005-010-000 Fuel & Lube 35,947.00 35,947.00 774.10 10,943.70 30.444 25,003.30 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 19:17 08/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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,313.96 11,223.27 86.333 1,776.73 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 845.58 97,648.92 84.912 17,351.08 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 2,933.64 199,720.66 80.507 48,359.34 135-69005-010-000 Capital Outlays 201,000.00 400,250.00 1,096,503.23 1,436,119.21 358.806 1,035,869.21- 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 1,096,503.23 1,769,954.84 241.093 1,035,817.84- Program number: 4,465,834.00 4,804,884.00 1,401,097.61 3,893,602.75 81.034 911,281.25 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 19:17 08/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 7/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 160.00 1,357.74 27.155 3,642.26 Subtotal: 5,000.00 5,000.00 160.00 1,357.74 27.155 3,642.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 160.00 1,357.74 13.577 8,642.26 Department number: Water 4,475,834.00 4,814,884.00 1,401,257.61 3,894,960.49 80.894 919,923.51 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 19:17 08/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 43,264.95 297,201.98 84.511 54,469.02 135-50010-020-000 Overtime 19,500.00 29,500.00 5,129.05 30,033.40 101.808 533.40- 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 1,350.00 6,875.00 95.486 325.00 135-50020-020-000 Retirement 33,652.00 33,652.00 4,342.65 29,878.07 88.785 3,773.93 135-50026-020-000 Medical Insurance 65,989.00 65,989.00 5,531.96 52,860.59 80.105 13,128.41 135-50027-020-000 Dental Insurance 4,184.00 4,184.00 347.88 3,249.96 77.676 934.04 135-50028-020-000 Vision Insurance 972.00 972.00 78.00 734.95 75.612 237.05 135-50029-020-000 Life Insurance & Other 3,655.00 3,655.00 354.95 3,405.79 93.182 249.21 135-50030-020-000 Social Security Taxes 24,665.00 24,665.00 2,880.60 19,261.71 78.093 5,403.29 135-50035-020-000 Medicare Taxes 5,768.00 5,768.00 673.70 4,504.73 78.099 1,263.27 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 5,449.81 58.493 3,867.19 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 78.00 497.81 76.586 152.19 Subtotal: 535,097.00 544,852.00 64,808.17 461,520.82 84.706 83,331.18 135-55070-020-000 Independent Labor 50,000.00 50,000.00 355.00 24,488.45 48.977 25,511.55 135-55080-020-000 Maintenance & Repairs 72,600.00 83,100.00 19,295.23 99,156.41 119.322 16,056.41- 135-55090-020-000 Vehicle Maintenance 5,000.00 7,500.00 763.18 6,945.18 92.602 554.82 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 5,360.68 33,985.50 61.792 21,014.50 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 5,048.00 32,759.40 93.598 2,240.60 Subtotal: 218,100.00 231,100.00 30,822.09 197,625.94 85.515 33,474.06 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 824.32 5,063.94 93.777 336.06 135-60020-020-000 Electricity 161,582.00 161,582.00 10,575.90 91,754.94 56.785 69,827.06 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 944.00 3,361.00 89.128 410.00 135-60090-020-000 Safety Program 550.00 550.00 340.67 61.940 209.33 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 168.48 913.27 57.079 686.73 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 1,350.00 5,938.50 65.983 3,061.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 99,755.00 83.333 19,951.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 444,831.00 444,831.00 43,220.32 401,617.20 90.285 43,213.80 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 30,834.00 123,336.00 100.000 Subtotal: 908,423.00 908,423.00 107,868.02 747,282.50 82.262 161,140.50 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 19:17 08/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 819.22 8,772.32 27.396 23,248.68 135-65010-020-000 Uniforms 4,241.00 4,241.00 121.17 2,854.68 67.311 1,386.32 135-65030-020-000 Chemicals 27,000.00 27,000.00 5,920.00 27,103.25 100.382 103.25- 135-65035-020-000 Small Tools 2,000.00 2,000.00 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 894.14 14,335.29 110.271 1,335.29- Subtotal: 79,012.00 79,012.00 7,754.53 54,509.54 68.989 24,502.46 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 211,252.81 1,751,859.88 81.830 389,004.12 Department number: Wastewater 1,912,109.00 2,140,864.00 211,252.81 1,751,859.88 81.830 389,004.12 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 19:17 08/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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 1,100.00 6,700.00 53.600 5,800.00 135-50030-026-000 Social Security Taxes 775.00 775.00 68.20 415.40 53.600 359.60 135-50035-026-000 Medicare Taxes 181.00 181.00 15.95 97.15 53.674 83.85 135-50040-026-000 Unemployment Taxes 230.00 12.00 34.20- 1.50 12.500 10.50 135-50045-026-000 Workman's Compensation 37.00 50.00 3.08 43.81 87.620 6.19 Subtotal: 13,723.00 13,518.00 1,153.03 7,257.86 53.690 6,260.14 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 376.28 397.95 33.163 802.05 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,875.00 46.875 2,125.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 262.30 3,313.67 66.273 1,686.33 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 40.00 259.88 12.994 1,740.12 Subtotal: 12,850.00 12,850.00 678.58 5,857.48 45.584 6,992.52 Program number: 26,573.00 26,368.00 1,831.61 13,115.34 49.740 13,252.66 Department number: Board of Directors 26,573.00 26,368.00 1,831.61 13,115.34 49.740 13,252.66 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 19:17 08/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 56,780.29 397,598.89 80.545 96,034.11 135-50010-030-000 Overtime 1,000.00 500.00 30.86 522.01 104.402 22.01- 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 4,959.61 35,304.60 80.877 8,347.40 135-50026-030-000 Medical Insurance 68,196.00 68,196.00 5,089.40 51,396.06 75.365 16,799.94 135-50027-030-000 Dental Insurance 4,807.00 4,807.00 340.84 3,523.49 73.299 1,283.51 135-50028-030-000 Vision Insurance 1,114.00 1,114.00 81.14 817.67 73.399 296.33 135-50029-030-000 Life Insurance & Other 4,431.00 5,431.00 397.50 3,915.25 72.091 1,515.75 135-50030-030-000 Social Security Taxes 30,823.00 31,141.00 3,362.11 23,276.10 74.744 7,864.90 135-50035-030-000 Medicare Taxes 7,599.00 7,678.00 786.30 5,443.59 70.899 2,234.41 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,770.90 113.958 216.90- 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 3,100.95 68.910 1,399.05 Subtotal: 662,006.00 667,726.00 71,975.94 531,689.01 79.627 136,036.99 135-55030-030-000 Software & Support 78,483.00 81,097.00 4,845.82 41,874.04 51.635 39,222.96 135-55070-030-000 Independent Labor 12,000.00 12,000.00 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 148.72 6,525.59 93.223 474.41 135-55120-030-000 Cleaning Services 10,125.00 10,125.00 584.75 5,003.75 49.420 5,121.25 135-55160-030-000 Professional Outside Services 61,075.00 72,575.00 5,002.88 63,047.88 86.873 9,527.12 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 584.10 6,711.31 81.845 1,488.69 Subtotal: 206,583.00 198,197.00 11,166.27 130,539.55 65.864 67,657.45 135-60005-030-000 Telephone 16,349.00 16,349.00 2,086.95 11,582.91 70.848 4,766.09 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 675.98 3,815.30 91.935 334.70 135-60020-030-000 Electricity/Gas 10,768.00 10,768.00 586.92- 4,862.27 45.155 5,905.73 135-60025-030-000 Water 1,500.00 1,500.00 22.38 656.33 43.755 843.67 135-60035-030-000 Postage 28,932.00 28,932.00 3,300.68 21,968.88 75.933 6,963.12 135-60040-030-000 Service Charges & Fees 44,000.00 55,560.00 3,155.43 43,704.84 78.662 11,855.16 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 3,022.62 86.361 477.38 135-60055-030-000 Insurance 52,797.00 52,797.00 2,756.00 28,061.00 53.149 24,736.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 160.00 5,466.25 91.104 533.75 135-60075-030-000 Meetings 400.00 400.00 37.61 105.11 26.278 294.89 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 157.03 3,358.31 62.191 2,041.69 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 19:17 08/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 150.00 211.74 2.823 7,288.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 25.98 5,302.48 30.298 12,198.52 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 11,941.12 143,857.17 60.332 94,584.83 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 676.42 4,803.96 53.377 4,196.04 135-65090-030-000 Printer Supplies & Maintenance 4,003.00 4,003.00 1,004.63 25.097 2,998.37 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 703.61 3,412.88 68.258 1,587.12 135-65105-030-000 Printing 4,800.00 4,800.00 308.04 3,094.26 64.464 1,705.74 Subtotal: 54,252.00 38,252.00 1,688.07 18,210.58 47.607 20,041.42 135-69005-030-000 Capital Outlays 56,000.00 56,000.00 12,198.00 22,316.40 39.851 33,683.60 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 470.39 2,913.41 63.335 1,686.59 Subtotal: 60,600.00 60,600.00 12,668.39 25,229.81 41.633 35,370.19 Program number: 1,210,323.00 1,203,217.00 109,439.79 849,526.12 70.605 353,690.88 Department number: Administration 1,210,323.00 1,203,217.00 109,439.79 849,526.12 70.605 353,690.88 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 19:17 08/11/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/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 5,474.75 234,177.56 60.647 151,952.44 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 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 5,474.75 268,779.42 63.356 155,454.58 Program number: 422,945.00 424,234.00 5,474.75 268,779.42 63.356 155,454.58 Department number: Non Departmental 422,945.00 424,234.00 5,474.75 268,779.42 63.356 155,454.58 Expenditures Subtotal ----------- 8,047,784.00 8,609,567.00 1,729,256.57 6,778,241.25 78.729 1,831,325.75 Fund number: 135 MUD 1 General Fund 896,324.91 1,480,146.37 1,480,146.37- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 19:17 08/11/16 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 7/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 19:17 08/11/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 7/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 19:17 08/11/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 7/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 14 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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 2049 07/01/2016 Property Taxes (56,877.61) (26.63) (56,904.24) GL 2050 07/07/2016 Property Taxes (.63) (56,904.87) GL 2062 07/08/2016 Property Taxes (2.77) (56,907.64) GL 2063 07/11/2016 Property Taxes (6.53) (56,914.17) GL 2064 07/14/2016 Property Taxes (3.53) (56,917.70) GL 2065 07/15/2016 Property Taxes (1.85) (56,919.55) GL 2066 07/18/2016 Property Taxes (7.59) (56,927.14) GL 2067 07/20/2016 Property Taxes (11.76) (56,938.90) GL 2068 07/21/2016 Property Taxes (7.56) (56,946.46) GL 2069 07/22/2016 Property Taxes (8.34) (56,954.80) GL 2070 07/25/2016 Property Taxes (5.88) (56,960.68) GL 2071 07/26/2016 Property Taxes (8.17) (56,968.85) GL 2072 07/27/2016 Property Taxes (29.28) (56,998.13) GL 2073 07/28/2016 Property Taxes (5.74) (57,003.87) GL 2074 07/29/2016 Property Taxes (2.36) (57,006.23) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (128.62) (57,006.23) ** (58,181.00) Budgeted (1,174.77) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 2062 07/08/2016 Property Taxes (1,274.86) (790.93) (2,065.79) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (790.93) (2,065.79) ** .00 Budgeted 2,065.79 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 2049 07/01/2016 Property Taxes (498.83) (4.28) (503.11) GL 2062 07/08/2016 Property Taxes (148.42) (651.53) GL 2063 07/11/2016 Property Taxes (.52) (652.05) GL 2066 07/18/2016 Property Taxes (.12) (652.17) GL 2072 07/27/2016 Property Taxes (1.41) (653.58) GL 2073 07/28/2016 Property Taxes (.04) (653.62) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (154.79) (653.62) ** (650.00) Budgeted 3.62 Remaining 101 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (146,125.00) Budgeted (146,125.00) Remaining 0 % Used Account: 135-47000-000-000 Water 2017 07/31/2016 UB 7/31/16 Billing UB20160731-20160731 User: (2,537,934.17) (551,426.06) (3,089,360.23) UB _______________ Account: 135-47000-000-000 Water Totals: (551,426.06) (3,089,360.23) ** (5,080,244.00) Budgeted (1,990,883.77) Remaining 61 % Used Account: 135-47005-000-000 Sewer 2017 07/31/2016 UB 7/31/16 Billing UB20160731-20160731 User: (1,575,870.01) (249,396.72) (1,825,266.73) UB _______________ Account: 135-47005-000-000 Sewer Totals: (249,396.72) (1,825,266.73) ** (2,413,776.00) Budgeted (588,509.27) Remaining 76 % Used Account: 135-47025-000-000 Penalties 1981 07/21/2016 07/21/16 UB late Penalties UB20160721-20160721 User: (71,465.31) (9,788.42) (81,253.73) UB 2034 07/21/2016 UB 7/21/16 penalty removal UB20160721-20160721 User: 3.59 (81,250.14) UB 2038 07/28/2016 UB 7/28/16 Penalty removal UB20160728-20160728 User: 87.65 (81,162.49) UB 2040 07/29/2016 UB 7/29/16 Penalty removal UB20160729-20160729 User: 753.03 (80,409.46) UB _______________ Account: 135-47025-000-000 Penalties Totals: (8,944.15) (80,409.46) ** (90,985.00) Budgeted (10,575.54) Remaining 88 % Used Account: 135-47030-000-000 Service Charges 1920 07/11/2016 UB 7/11/16 Disconnects UB20160711-20160711 User: (10,675.00) (400.00) (11,075.00) UB 2028 07/12/2016 UB 7/12/16 NSF Check fee UB20160712-20160712 User: (25.00) (11,100.00) UB 2032 07/15/2016 UB 7/15/16 NSF Check fee UB20160715-20160715 User: (50.00) (11,150.00) UB 2036 07/21/2016 UB 7/21/16 NSF Check fee UB20160721-20160721 User: (50.00) (11,200.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (525.00) (11,200.00) ** (9,000.00) Budgeted 2,200.00 Remaining 124 % Used Account: 135-47035-000-000 Plumbing Inspections 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (2,100.00) (250.00) (2,350.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (250.00) (2,350.00) ** (2,000.00) Budgeted 350.00 Remaining 118 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (6,150.00) (750.00) (6,900.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (750.00) (6,900.00) ** (5,500.00) Budgeted 1,400.00 Remaining 125 % Used Account: 135-47070-000-000 TCCC Effluent Charges 2017 07/31/2016 UB 7/31/16 Billing UB20160731-20160731 User: (12,542.45) (12,267.75) (24,810.20) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (12,267.75) (24,810.20) ** (61,330.00) Budgeted (36,519.80) Remaining 40 % 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 2078 07/31/2016 Bank Interest/Month (9,427.54) (319.65) (9,747.19) GL 2078 07/31/2016 Bank Interest/Month (218.07) (9,965.26) GL 2078 07/31/2016 Bank Interest/Month (589.99) (10,555.25) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,127.71) (10,555.25) ** (10,000.00) Budgeted 555.25 Remaining 106 % Used Account: 135-49016-000-000 Cell Tower Revenue 2057 07/12/2016 AT&T Cell Tower Revenue (8,194.77) (910.53) (9,105.30) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (9,105.30) ** (10,926.00) Budgeted (1,820.70) Remaining 83 % Used Account: 135-49018-000-000 Building Rent Income 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (5,249.97) (583.33) (5,833.30) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,833.30) ** (7,000.00) Budgeted (1,166.70) Remaining 83 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (43,961.42) (5,634.30) (49,595.72) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (5,634.30) (49,595.72) ** (15,778.00) Budgeted 33,817.72 Remaining 314 % 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 2017 07/31/2016 UB 7/31/16 Billing UB20160731-20160731 User: (28,743.52) (41.77) (28,785.29) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (41.77) (28,785.29) ** (63,249.00) Budgeted (34,463.71) Remaining 46 % 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 Department Totals: ------------------------------------------------------------------------------------------------ (5,298,094.88) ** (8,609,567.00) Budgeted (3,311,472.12) Remaining 62 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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 1819 07/01/2016 MUD P/R 7/1/16 Salaries & Wages 151,273.36 8,425.45 159,698.81 PR 1931 07/15/2016 MUD Payroll 7/15/16 Salaries & Wages 8,425.45 168,124.26 PR 1995 07/29/2016 MUD Payroll 7/29/16 Salaries & Wages 8,425.45 176,549.71 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 25,276.35 176,549.71 ** 260,062.00 Budgeted 83,512.29 Remaining 68 % Used Account: 135-50010-010-000 Overtime 1819 07/01/2016 MUD P/R 7/1/16 Overtime 10,029.91 453.77 10,483.68 PR 1931 07/15/2016 MUD Payroll 7/15/16 Overtime 523.02 11,006.70 PR 1995 07/29/2016 MUD Payroll 7/29/16 Overtime 299.18 11,305.88 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,275.97 11,305.88 ** 19,500.00 Budgeted 8,194.12 Remaining 58 % 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 1819 07/01/2016 MUD P/R 7/1/16 Certification 1,725.00 200.00 1,925.00 PR 1931 07/15/2016 MUD Payroll 7/15/16 Certification 225.00 2,150.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 425.00 2,150.00 ** 3,600.00 Budgeted 1,450.00 Remaining 60 % Used Account: 135-50020-010-000 Retirement 1819 07/01/2016 MUD P/R 7/1/16 Retirement 14,594.57 792.61 15,387.18 PR 1931 07/15/2016 MUD Payroll 7/15/16 Retirement 800.85 16,188.03 PR 1995 07/29/2016 MUD Payroll 7/29/16 Retirement 761.66 16,949.69 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,355.12 16,949.69 ** 25,018.00 Budgeted 8,068.31 Remaining 68 % Used Account: 135-50026-010-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1819 07/01/2016 MUD P/R 7/1/16 Medical Insurance 27,943.21 1,580.55 29,523.76 PR 1931 07/15/2016 MUD Payroll 7/15/16 Medical Insurance 1,580.55 31,104.31 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,161.10 31,104.31 ** 51,398.00 Budgeted 20,293.69 Remaining 61 % Used Account: 135-50027-010-000 Dental Insurance 1819 07/01/2016 MUD P/R 7/1/16 Dental Insurance 2,102.41 120.38 2,222.79 PR 1931 07/15/2016 MUD Payroll 7/15/16 Dental Insurance 120.38 2,343.17 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 240.76 2,343.17 ** 3,999.00 Budgeted 1,655.83 Remaining 59 % Used Account: 135-50028-010-000 Vision Insurance 1819 07/01/2016 MUD P/R 7/1/16 Vision Insurance 473.18 26.97 500.15 PR 1931 07/15/2016 MUD Payroll 7/15/16 Vision Insurance 26.97 527.12 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.94 527.12 ** 910.00 Budgeted 382.88 Remaining 58 % Used Account: 135-50029-010-000 Life Insurance & Other 1825 07/01/2016 July A/P Dental, Vision, Life, AD&D, ST 1,758.57 191.24 1,949.81 METLIFE GROUP BENEFITS 2083 AP 2089 07/31/2016 July A/P Café 125 Admin 9.71 1,959.52 BenefitMall 2152 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 200.95 1,959.52 ** 2,803.00 Budgeted 843.48 Remaining 70 % Used Account: 135-50030-010-000 Social Security Taxes 1819 07/01/2016 MUD P/R 7/1/16 Social Security Taxes 10,206.90 555.91 10,762.81 PR 1931 07/15/2016 MUD Payroll 7/15/16 Social Security Taxes 561.72 11,324.53 PR 1995 07/29/2016 MUD Payroll 7/29/16 Social Security Taxes 550.80 11,875.33 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,668.43 11,875.33 ** 18,146.00 Budgeted 6,270.67 Remaining 65 % Used Account: 135-50035-010-000 Medicare Taxes 1819 07/01/2016 MUD P/R 7/1/16 Medicare Taxes 2,387.08 130.00 2,517.08 PR 1931 07/15/2016 MUD Payroll 7/15/16 Medicare Taxes 131.38 2,648.46 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1995 07/29/2016 MUD Payroll 7/29/16 Medicare Taxes 2,387.08 128.82 2,777.28 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 390.20 2,777.28 ** 4,243.00 Budgeted 1,465.72 Remaining 65 % Used Account: 135-50040-010-000 Unemployment Taxes 859.06 .00 859.06 _______________ 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 141 07/01/2016 Prepaid Insurance, W/C Jul 8,749.63 1,229.35 9,978.98 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,229.35 9,978.98 ** 14,754.00 Budgeted 4,775.02 Remaining 68 % 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 2096 07/31/2016 July A/P WENDY'S 09724 75.22 36.82 112.04 WENDY'S 09724 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 36.82 112.04 ** 300.00 Budgeted 187.96 Remaining 37 % Used Account: 135-55005-010-000 Engineering 1946 07/13/2016 July A/P MUD Water Study 48,920.60 49,296.48 98,217.08 CP&Y/WALLACE GROUP, INC. 2116 AP _______________ Account: 135-55005-010-000 Engineering Totals: 49,296.48 98,217.08 ** 109,400.00 Budgeted 11,182.92 Remaining 90 % Used Account: 135-55080-010-000 Maintenance & Repairs 1946 07/13/2016 July A/P Petty Cash reimbursement 67,907.36 17.19 67,924.55 TROPHY CLUB MUD PETTY CASH 2138 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1946 07/13/2016 July A/P June mowing 67,907.36 750.00 68,674.55 WATTS ELLISON LLC 2140 AP 1946 07/13/2016 July A/P Meter boxes 2,796.27 71,470.82 HD SUPPLY WATERWORKS, LTD. 2124 AP 2096 07/31/2016 July A/P AMAZON MKTPLACE PMTS 33.66 71,504.48 AMAZON MKTPLACE PMTS PC 2096 07/31/2016 July A/P TRACTOR SUPPLY COMPANY 7.56 71,512.04 TRACTOR SUPPLY COMPANY PC 2096 07/31/2016 July A/P THE HOME DEPOT #6581 36.07 71,548.11 THE HOME DEPOT #6581 PC 2117 07/31/2016 July A/P July Mowing 1,500.00 73,048.11 WATTS ELLISON LLC AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 5,140.75 73,048.11 ** 99,500.00 Budgeted 26,451.89 Remaining 73 % Used Account: 135-55090-010-000 Vehicle Maintenance 2096 07/31/2016 July A/P DENTON CO TX MOTOR VEH 3,559.69 1.00 3,560.69 DENTON CO TX MOTOR VEH PC 2096 07/31/2016 July A/P DENTON CO TX MOTOR VEH 21.75 3,582.44 DENTON CO TX MOTOR VEH PC 2096 07/31/2016 July A/P DENTON CNTY VEHREG 15.25 3,597.69 DENTON CNTY VEHREG PC 2096 07/31/2016 July A/P AUTO RENEWAL STICK 2.00 3,599.69 AUTO RENEWAL STICK PC 2096 07/31/2016 July A/P KWIK KAR LUBE & TUNE O 7.00 3,606.69 KWIK KAR LUBE & TUNE O PC 2096 07/31/2016 July A/P KWIK KAR LUBE & TUNE O 25.50 3,632.19 KWIK KAR LUBE & TUNE O PC 2096 07/31/2016 July A/P KWIK KAR LUBE & TUNE O 25.50 3,657.69 KWIK KAR LUBE & TUNE O PC 2096 07/31/2016 July A/P DISCOUNT TIRE TXD 75 393.00 4,050.69 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 491.00 4,050.69 ** 8,000.00 Budgeted 3,949.31 Remaining 51 % 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 1946 07/13/2016 July A/P Petty Cash reimbursement 3,006.87 9.87 3,016.74 TROPHY CLUB MUD PETTY CASH 2138 AP 1946 07/13/2016 July A/P Water samples/MUD 200.00 3,216.74 TARRANT CTY PUBLIC HEALTH LAB 2133 AP 2089 07/31/2016 July A/P Copper/Lead testing 600.00 3,816.74 CITY OF FORT WORTH 2162 AP 2117 07/31/2016 July A/P Testing/MUD 225.00 4,041.74 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 1,034.87 4,041.74 ** 5,500.00 Budgeted 1,458.26 Remaining 73 % Used Account: 135-60010-010-000 Communications/Mobiles . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1946 07/13/2016 July A/P Cell phones 3,328.52 347.11 3,675.63 VERIZON WIRELESS 2139 AP 2117 07/31/2016 July A/P Cell phones/July 347.11 4,022.74 VERIZON WIRELESS AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 694.22 4,022.74 ** 5,400.00 Budgeted 1,377.26 Remaining 74 % Used Account: 135-60020-010-000 Electricity 1946 07/13/2016 July A/P Electricity 6/8-7/8/16 88,486.63 184.18 88,670.81 HUDSON ENERGY SERVICES, LLC 2125 AP 1949 07/14/2016 July A/P Electricity 6/9-7/11/16 1,456.82 90,127.63 HUDSON ENERGY SERVICES, LLC 2125 AP 2089 07/31/2016 July A/P Electricity 6/9-7/11/16 15,939.72 106,067.35 HUDSON ENERGY SERVICES, LLC 2180 AP _______________ Account: 135-60020-010-000 Electricity Totals: 17,580.72 106,067.35 ** 166,823.00 Budgeted 60,755.65 Remaining 64 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 716.00 .00 716.00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .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 1946 07/13/2016 July A/P Petty Cash reimbursement 1,520.00 25.00 1,545.00 TROPHY CLUB MUD PETTY CASH 2138 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 25.00 1,545.00 ** 5,773.00 Budgeted 4,228.00 Remaining 27 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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-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 2096 07/31/2016 July A/P THE HOME DEPOT 6581 324.64 1.00 325.64 THE HOME DEPOT 6581 PC 2096 07/31/2016 July A/P THE HOME DEPOT 6581 52.90 378.54 THE HOME DEPOT 6581 PC _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 53.90 378.54 ** 1,500.00 Budgeted 1,121.46 Remaining 25 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 2089 07/31/2016 July A/P Well water fees 13,175.00 4,613.20 17,788.20 North Texas Groundwater 2197 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 4,613.20 17,788.20 ** 49,275.00 Budgeted 31,486.80 Remaining 36 % Used Account: 135-60150-010-000 Wholesale Water 2089 07/31/2016 July A/P June Wholesale Water 1,150,441.19 186,416.61 1,336,857.80 CITY OF FORT WORTH 2161 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 186,416.61 1,336,857.80 ** 2,948,742.00 Budgeted 1,611,884.20 Remaining 45 % 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 2,280.63 .00 2,280.63 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 2,280.63 ** 3,500.00 Budgeted 1,219.37 Remaining 65 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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-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 2089 07/31/2016 July A/P Fuel 10,169.60 774.10 10,943.70 US Bank Voyager Fleet Systems 2222 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 774.10 10,943.70 ** 35,947.00 Budgeted 25,003.30 Remaining 30 % 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 2089 07/31/2016 July A/P Chemicals 9,909.31 608.45 10,517.76 HACH COMPANY 2175 AP 2089 07/31/2016 July A/P Chlorine 635.64 11,153.40 DPC INDUSTRIES, INC 2166 AP 2098 07/31/2016 July A/P Hardness Treatment Reagent 69.87 11,223.27 HACH COMPANY 2175 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,313.96 11,223.27 ** 13,000.00 Budgeted 1,776.73 Remaining 86 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 2089 07/31/2016 July A/P Water meter 96,803.34 845.58 97,648.92 ATLAS UTILITY SUPPLY CO. 2149 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 845.58 97,648.92 ** 115,000.00 Budgeted 17,351.08 Remaining 85 % Used 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 1946 07/13/2016 July A/P Waterline replace/Pin Oak, Peb 339,615.98 797.72 340,413.70 TEAGUE, NALL & PERKINS,INC 2135 AP 1946 07/13/2016 July A/P Vertical Turbine pump #2 repai 19,694.00 360,107.70 SMITH PUMP COMPANY, INC. 2131 AP 1949 07/14/2016 July A/P NS II 48" Water Main FW Contra 796,145.08 1,156,252.78 Fort Worth Water Department 2120 AP 2022 07/29/2016 July A/P NS II 30" Water Main Engineeri 257,790.00 1,414,042.78 Fort Worth Water Department 2146 AP 2089 07/31/2016 July A/P Pump repair 1,318.93 1,415,361.71 SMITH PUMP COMPANY, INC. 2208 AP 2089 07/31/2016 July A/P LAS Disinfection System 16,175.00 1,431,536.71 CP&Y/WALLACE GROUP, INC. 2164 AP 2089 07/31/2016 July A/P LAS Disinfection System 4,582.50 1,436,119.21 CP&Y/WALLACE GROUP, INC. 2164 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 1,096,503.23 1,436,119.21 ** 400,250.00 Budgeted (1,035,869.21) Remaining 359 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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-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 1946 07/13/2016 July A/P Water samples/PID 1,197.74 80.00 1,277.74 TARRANT CTY PUBLIC HEALTH LAB 2133 AP 2117 07/31/2016 July A/P Testing/PID 80.00 1,357.74 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 160.00 1,357.74 ** 5,000.00 Budgeted 3,642.26 Remaining 27 % 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: ------------------------------------------------------------------------------------------------ 3,894,960.49 ** 4,814,884.00 Budgeted 919,923.51 Remaining 81 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 1819 07/01/2016 MUD P/R 7/1/16 Salaries & Wages 253,937.03 14,421.65 268,358.68 PR 1931 07/15/2016 MUD Payroll 7/15/16 Salaries & Wages 14,421.65 282,780.33 PR 1995 07/29/2016 MUD Payroll 7/29/16 Salaries & Wages 14,421.65 297,201.98 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 43,264.95 297,201.98 ** 351,671.00 Budgeted 54,469.02 Remaining 85 % Used Account: 135-50010-020-000 Overtime 1819 07/01/2016 MUD P/R 7/1/16 Overtime 24,904.35 2,553.57 27,457.92 PR 1931 07/15/2016 MUD Payroll 7/15/16 Overtime 1,602.24 29,060.16 PR 1995 07/29/2016 MUD Payroll 7/29/16 Overtime 973.24 30,033.40 PR _______________ Account: 135-50010-020-000 Overtime Totals: 5,129.05 30,033.40 ** 29,500.00 Budgeted (533.40) Remaining 102 % 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 1819 07/01/2016 MUD P/R 7/1/16 Certification 5,525.00 675.00 6,200.00 PR 1931 07/15/2016 MUD Payroll 7/15/16 Certification 675.00 6,875.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 1,350.00 6,875.00 ** 7,200.00 Budgeted 325.00 Remaining 95 % Used Account: 135-50020-020-000 Retirement 1819 07/01/2016 MUD P/R 7/1/16 Retirement 25,535.42 1,540.86 27,076.28 PR 1931 07/15/2016 MUD Payroll 7/15/16 Retirement 1,457.81 28,534.09 PR 1995 07/29/2016 MUD Payroll 7/29/16 Retirement 1,343.98 29,878.07 PR _______________ Account: 135-50020-020-000 Retirement Totals: 4,342.65 29,878.07 ** 33,652.00 Budgeted 3,773.93 Remaining 89 % Used Account: 135-50026-020-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1819 07/01/2016 MUD P/R 7/1/16 Medical Insurance 47,328.63 2,765.98 50,094.61 PR 1931 07/15/2016 MUD Payroll 7/15/16 Medical Insurance 2,765.98 52,860.59 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,531.96 52,860.59 ** 65,989.00 Budgeted 13,128.41 Remaining 80 % Used Account: 135-50027-020-000 Dental Insurance 1819 07/01/2016 MUD P/R 7/1/16 Dental Insurance 2,902.08 173.94 3,076.02 PR 1931 07/15/2016 MUD Payroll 7/15/16 Dental Insurance 173.94 3,249.96 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 347.88 3,249.96 ** 4,184.00 Budgeted 934.04 Remaining 78 % Used Account: 135-50028-020-000 Vision Insurance 1819 07/01/2016 MUD P/R 7/1/16 Vision Insurance 656.95 39.00 695.95 PR 1931 07/15/2016 MUD Payroll 7/15/16 Vision Insurance 39.00 734.95 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 78.00 734.95 ** 972.00 Budgeted 237.05 Remaining 76 % Used Account: 135-50029-020-000 Life Insurance & Other 1825 07/01/2016 July A/P Dental, Vision, Life, AD&D, ST 3,050.84 325.82 3,376.66 METLIFE GROUP BENEFITS 2083 AP 2089 07/31/2016 July A/P Café 125 Admin 29.13 3,405.79 BenefitMall 2152 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 354.95 3,405.79 ** 3,655.00 Budgeted 249.21 Remaining 93 % Used Account: 135-50030-020-000 Social Security Taxes 1819 07/01/2016 MUD P/R 7/1/16 Social Security Taxes 16,381.11 984.54 17,365.65 PR 1931 07/15/2016 MUD Payroll 7/15/16 Social Security Taxes 926.87 18,292.52 PR 1995 07/29/2016 MUD Payroll 7/29/16 Social Security Taxes 969.19 19,261.71 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,880.60 19,261.71 ** 24,665.00 Budgeted 5,403.29 Remaining 78 % Used Account: 135-50035-020-000 Medicare Taxes 1819 07/01/2016 MUD P/R 7/1/16 Medicare Taxes 3,831.03 230.27 4,061.30 PR 1931 07/15/2016 MUD Payroll 7/15/16 Medicare Taxes 216.76 4,278.06 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1995 07/29/2016 MUD Payroll 7/29/16 Medicare Taxes 3,831.03 226.67 4,504.73 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 673.70 4,504.73 ** 5,768.00 Budgeted 1,263.27 Remaining 78 % Used Account: 135-50040-020-000 Unemployment Taxes 1,203.57 .00 1,203.57 _______________ 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 141 07/01/2016 Prepaid Insurance, W/C Jul 4,673.38 776.43 5,449.81 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 776.43 5,449.81 ** 9,317.00 Budgeted 3,867.19 Remaining 58 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 238.45 .00 238.45 _______________ 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 2096 07/31/2016 July A/P MEAT U ANYWHERE TR 419.81 78.00 497.81 MEAT U ANYWHERE TR PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 78.00 497.81 ** 650.00 Budgeted 152.19 Remaining 77 % Used Account: 135-55070-020-000 Independent Labor 2089 07/31/2016 July A/P Repair Scada /Main Lift statio 24,133.45 355.00 24,488.45 DHS AUTOMATION, INC 2165 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 355.00 24,488.45 ** 50,000.00 Budgeted 25,511.55 Remaining 49 % Used Account: 135-55080-020-000 Maintenance & Repairs 1946 07/13/2016 July A/P June mowing 79,861.18 540.00 80,401.18 WATTS ELLISON LLC 2140 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1951 07/14/2016 July A/P Generator repair 79,861.18 861.99 81,263.17 WORLDWIDE POWER PRODUCTS 2142 AP 1951 07/14/2016 July A/P Generator Repair 360.00 81,623.17 WORLDWIDE POWER PRODUCTS 2142 AP 2089 07/31/2016 July A/P Repair/Install for LS1 12 HP 5,756.39 87,379.56 NORTH TEXAS PUMP CO. 2198 AP 2089 07/31/2016 July A/P Repair LS 8 pump 4,036.31 91,415.87 NORTH TEXAS PUMP CO. 2198 AP 2089 07/31/2016 July A/P Repair of Rental pump 285.00 91,700.87 NORTH TEXAS PUMP CO. 2198 AP 2089 07/31/2016 July A/P Pump repair 715.00 92,415.87 NORTH TEXAS PUMP CO. 2198 AP 2089 07/31/2016 July A/P Repair #8 pump 715.00 93,130.87 NORTH TEXAS PUMP CO. 2198 AP 2089 07/31/2016 July A/P LS 8 variable frequency drive 2,331.03 95,461.90 NORTH TEXAS PUMP CO. 2198 AP 2089 07/31/2016 July A/P LS 8 repair 808.00 96,269.90 XYLEM WATER SOLUTIONS USA INC 2227 AP 2089 07/31/2016 July A/P Shelves/bulbs 278.10 96,548.00 UV DOCTOR LAMPS LLC 2223 AP 2089 07/31/2016 July A/P Shelves/bulbs 273.28 96,821.28 UV DOCTOR LAMPS LLC 2223 AP 2089 07/31/2016 July A/P Repair LS 1 generator. 66.00 96,887.28 CANTWELL POWER SOLUTIONS 2157 AP 2096 07/31/2016 July A/P THE HOME DEPOT 6581 112.52 96,999.80 THE HOME DEPOT 6581 PC 2096 07/31/2016 July A/P THE HOME DEPOT #6581 9.74 97,009.54 THE HOME DEPOT #6581 PC 2096 07/31/2016 July A/P LOWES #00732* 836.97 97,846.51 LOWES #00732* PC 2096 07/31/2016 July A/P PHONETECH & REPAIR 129.90 97,976.41 PHONETECH & REPAIR PC 2117 07/31/2016 July A/P July Mowing 1,180.00 99,156.41 WATTS ELLISON LLC AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 19,295.23 99,156.41 ** 83,100.00 Budgeted (16,056.41) Remaining 119 % Used Account: 135-55090-020-000 Vehicle Maintenance 2096 07/31/2016 July A/P MUSTANG ELITE CAR 6,182.00 70.99 6,252.99 MUSTANG ELITE CAR PC 2096 07/31/2016 July A/P BLAGG TIRE & SERVICE 220.15 6,473.14 BLAGG TIRE & SERVICE PC 2096 07/31/2016 July A/P BLAGG TIRE & SERVICE 207.07 6,680.21 BLAGG TIRE & SERVICE PC 2096 07/31/2016 July A/P MUSTANG ELITE CAR 258.97 6,939.18 MUSTANG ELITE CAR PC 2096 07/31/2016 July A/P MUSTANG ELITE CAR WASH 6.00 6,945.18 MUSTANG ELITE CAR WASH PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 763.18 6,945.18 ** 7,500.00 Budgeted 554.82 Remaining 93 % 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 1951 07/14/2016 July A/P Sludge Haul off 28,624.82 797.68 29,422.50 L.H. CHANEY MATERIALS, INC. 2129 AP 1951 07/14/2016 July A/P Sludge Haul off 1,014.00 30,436.50 L.H. CHANEY MATERIALS, INC. 2129 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1951 07/14/2016 July A/P Sludge Haul off 28,624.82 1,014.00 31,450.50 L.H. CHANEY MATERIALS, INC. 2129 AP 1951 07/14/2016 July A/P Sludge Haul off 845.00 32,295.50 L.H. CHANEY MATERIALS, INC. 2129 AP 2089 07/31/2016 July A/P Sludge haul off 845.00 33,140.50 L.H. CHANEY MATERIALS, INC. 2185 AP 2089 07/31/2016 July A/P Sludge haul off 845.00 33,985.50 L.H. CHANEY MATERIALS, INC. 2185 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 5,360.68 33,985.50 ** 55,000.00 Budgeted 21,014.50 Remaining 62 % Used Account: 135-55135-020-000 Lab Analysis 2089 07/31/2016 July A/P Testing 27,711.40 246.00 27,957.40 OXIDOR LABORATORIES LLC 2200 AP 2089 07/31/2016 July A/P Testing 176.00 28,133.40 OXIDOR LABORATORIES LLC 2200 AP 2089 07/31/2016 July A/P Testing 246.00 28,379.40 OXIDOR LABORATORIES LLC 2200 AP 2089 07/31/2016 July A/P Testing 176.00 28,555.40 OXIDOR LABORATORIES LLC 2200 AP 2089 07/31/2016 July A/P Testing 840.00 29,395.40 OXIDOR LABORATORIES LLC 2200 AP 2089 07/31/2016 July A/P Testing 246.00 29,641.40 OXIDOR LABORATORIES LLC 2200 AP 2089 07/31/2016 July A/P Testing 176.00 29,817.40 OXIDOR LABORATORIES LLC 2200 AP 2089 07/31/2016 July A/P Testing 840.00 30,657.40 OXIDOR LABORATORIES LLC 2200 AP 2089 07/31/2016 July A/P Testing 840.00 31,497.40 OXIDOR LABORATORIES LLC 2200 AP 2089 07/31/2016 July A/P Testing 840.00 32,337.40 OXIDOR LABORATORIES LLC 2200 AP 2089 07/31/2016 July A/P Testing 246.00 32,583.40 OXIDOR LABORATORIES LLC 2200 AP 2089 07/31/2016 July A/P Testing 176.00 32,759.40 OXIDOR LABORATORIES LLC 2200 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 5,048.00 32,759.40 ** 35,000.00 Budgeted 2,240.60 Remaining 94 % Used Account: 135-60010-020-000 Communications/Mobiles 1946 07/13/2016 July A/P Cell phones 4,239.62 412.16 4,651.78 VERIZON WIRELESS 2139 AP 2117 07/31/2016 July A/P Cell phones/July 412.16 5,063.94 VERIZON WIRELESS AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 824.32 5,063.94 ** 5,400.00 Budgeted 336.06 Remaining 94 % Used Account: 135-60020-020-000 Electricity 1946 07/13/2016 July A/P Electricity 6/8-7/8/16 81,179.04 41.25 81,220.29 HUDSON ENERGY SERVICES, LLC 2125 AP 1946 07/13/2016 July A/P Electricity 6/8-7/8/16 55.57 81,275.86 HUDSON ENERGY SERVICES, LLC 2125 AP 1949 07/14/2016 July A/P Electricity 6/9-7/11/16 215.47 81,491.33 HUDSON ENERGY SERVICES, LLC 2125 AP 2089 07/31/2016 July A/P Electricity 6/27-7/26/16 298.58 81,789.91 TRI COUNTY ELECTRIC 2219 AP 2089 07/31/2016 July A/P Electricity 6/27-7/26/16 27.62 81,817.53 TRI COUNTY ELECTRIC 2219 AP 2089 07/31/2016 July A/P Electricity 6/27-7/26/16 439.46 82,256.99 TRI COUNTY ELECTRIC 2219 AP 2089 07/31/2016 July A/P Electricity 6/9-7/11/16 519.55 82,776.54 HUDSON ENERGY SERVICES, LLC 2180 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2089 07/31/2016 July A/P Electricity 6/9-7/11/16 81,179.04 8,833.91 91,610.45 HUDSON ENERGY SERVICES, LLC 2180 AP 2089 07/31/2016 July A/P Electricity 6/9-7/11/16 349.89 91,960.34 MP2 ENERGY TEXAS LLC 2195 AP 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (205.40) 91,754.94 AR _______________ Account: 135-60020-020-000 Electricity Totals: 10,575.90 91,754.94 ** 161,582.00 Budgeted 69,827.06 Remaining 57 % 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 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 2096 07/31/2016 July A/P CDL HELP 2,417.00 399.00 2,816.00 CDL HELP PC 2096 07/31/2016 July A/P SCMA 545.00 3,361.00 SCMA PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 944.00 3,361.00 ** 3,771.00 Budgeted 410.00 Remaining 89 % Used Account: 135-60090-020-000 Safety Program 340.67 .00 340.67 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 340.67 ** 550.00 Budgeted 209.33 Remaining 62 % Used Account: 135-60100-020-000 Travel & per diem 1995 07/29/2016 MUD Payroll 7/29/16 Travel & per diem 744.79 168.48 913.27 PR _______________ Account: 135-60100-020-000 Travel & per diem Totals: 168.48 913.27 ** 1,600.00 Budgeted 686.73 Remaining 57 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-020-000 Rent/Lease Equipment 2089 07/31/2016 July A/P WWTP Headworks/Rental Flygt 4,588.50 1,350.00 5,938.50 NORTH TEXAS PUMP CO. 2198 AP _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: 1,350.00 5,938.50 ** 9,000.00 Budgeted 3,061.50 Remaining 66 % 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 _______________ 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 1936 07/12/2016 Texpool Transfers PID share of new debt 79,804.00 19,951.00 99,755.00 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 19,951.00 99,755.00 ** 119,706.00 Budgeted 19,951.00 Remaining 83 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1936 07/12/2016 Texpool Transfers Xfer to Rev Bond I&S 358,396.88 43,220.32 401,617.20 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 43,220.32 401,617.20 ** 444,831.00 Budgeted 43,213.80 Remaining 90 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1936 07/12/2016 Texpool Transfers Xfer to Rev Bond Reserves 92,502.00 30,834.00 123,336.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 30,834.00 123,336.00 ** 123,336.00 Budgeted .00 Remaining 100 % Used Account: 135-65005-020-000 Fuel & Lube 2089 07/31/2016 July A/P Fuel 7,953.10 819.22 8,772.32 US Bank Voyager Fleet Systems 2222 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 819.22 8,772.32 ** 32,021.00 Budgeted 23,248.68 Remaining 27 % Used Account: 135-65010-020-000 Uniforms 2096 07/31/2016 July A/P LEVIS OUTLET 322 2,733.51 104.97 2,838.48 LEVIS OUTLET 322 PC 2096 07/31/2016 July A/P WAL-MART #5247 16.20 2,854.68 WAL-MART #5247 PC _______________ Account: 135-65010-020-000 Uniforms Totals: 121.17 2,854.68 ** 4,241.00 Budgeted 1,386.32 Remaining 67 % Used Account: 135-65030-020-000 Chemicals 2089 07/31/2016 July A/P Calcium Hypochlorite 21,183.25 2,960.00 24,143.25 HARCROS CHEMICALS INC 2176 AP 2089 07/31/2016 July A/P Calcium Hypochlorite 2,960.00 27,103.25 HARCROS CHEMICALS INC 2176 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 5,920.00 27,103.25 ** 27,000.00 Budgeted (103.25) Remaining 100 % Used Account: 135-65035-020-000 Small Tools 867.41 .00 867.41 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2089 07/31/2016 July A/P Filter, Glass FBR, Solution ki 13,441.15 334.74 13,775.89 HACH COMPANY 2175 AP 2089 07/31/2016 July A/P Sampler bottles 179.64 13,955.53 IDEXX DISTRIBUTION, INC 2181 AP 2089 07/31/2016 July A/P Testing gloves 162.00 14,117.53 LOU'S GLOVES INCORPORATED 2190 AP 2096 07/31/2016 July A/P RANDALLS STORE00017897 2.97 14,120.50 RANDALLS STORE00017897 PC 2098 07/31/2016 July A/P Tensette 214.79 14,335.29 HACH COMPANY 2175 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 894.14 14,335.29 ** 13,000.00 Budgeted (1,335.29) Remaining 110 % 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 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,751,859.88 ** 2,140,864.00 Budgeted 389,004.12 Remaining 82 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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 1819 07/01/2016 MUD P/R 7/1/16 Salaries & Wages 5,600.00 300.00 5,900.00 PR 1931 07/15/2016 MUD Payroll 7/15/16 Salaries & Wages 300.00 6,200.00 PR 1995 07/29/2016 MUD Payroll 7/29/16 Salaries & Wages 500.00 6,700.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,100.00 6,700.00 ** 12,500.00 Budgeted 5,800.00 Remaining 54 % Used Account: 135-50030-026-000 Social Security Taxes 1819 07/01/2016 MUD P/R 7/1/16 Social Security Taxes 347.20 18.60 365.80 PR 1931 07/15/2016 MUD Payroll 7/15/16 Social Security Taxes 18.60 384.40 PR 1995 07/29/2016 MUD Payroll 7/29/16 Social Security Taxes 31.00 415.40 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 68.20 415.40 ** 775.00 Budgeted 359.60 Remaining 54 % Used Account: 135-50035-026-000 Medicare Taxes 1819 07/01/2016 MUD P/R 7/1/16 Medicare Taxes 81.20 4.35 85.55 PR 1931 07/15/2016 MUD Payroll 7/15/16 Medicare Taxes 4.35 89.90 PR 1995 07/29/2016 MUD Payroll 7/29/16 Medicare Taxes 7.25 97.15 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 15.95 97.15 ** 181.00 Budgeted 83.85 Remaining 54 % Used Account: 135-50040-026-000 Unemployment Taxes 1885 07/08/2016 TWC 2nd qtr payment 35.70 (34.20) 1.50 GL _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: (34.20) 1.50 ** 12.00 Budgeted 10.50 Remaining 13 % Used Account: 135-50045-026-000 Workman's Compensation 141 07/01/2016 Prepaid Insurance, W/C Jul 40.73 3.08 43.81 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 3.08 43.81 ** 50.00 Budgeted 6.19 Remaining 88 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 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 1946 07/13/2016 July A/P Petty Cash reimbursement 21.67 76.00 97.67 TROPHY CLUB MUD PETTY CASH 2138 AP 2096 07/31/2016 July A/P RANDALLS STORE00017897 27.73 125.40 RANDALLS STORE00017897 PC 2096 07/31/2016 July A/P OMNI HOTELS 272.55 397.95 OMNI HOTELS PC _______________ Account: 135-60075-026-000 Meetings Totals: 376.28 397.95 ** 1,200.00 Budgeted 802.05 Remaining 33 % Used Account: 135-60080-026-000 Schools & Training 1,875.00 .00 1,875.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,875.00 ** 4,000.00 Budgeted 2,125.00 Remaining 47 % Used Account: 135-60100-026-000 Travel & per diem 2089 07/31/2016 July A/P AWBD New Director Training 3,051.37 262.30 3,313.67 William Rose 2226 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 262.30 3,313.67 ** 5,000.00 Budgeted 1,686.33 Remaining 66 % Used Account: 135-60245-026-000 Miscellaneous Expenses 2096 07/31/2016 July A/P KELLER TROPHY AND AWAR 219.88 40.00 259.88 KELLER TROPHY AND AWAR PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 40.00 259.88 ** 2,000.00 Budgeted 1,740.12 Remaining 13 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 13,115.34 ** 26,368.00 Budgeted 13,252.66 Remaining 50 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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 1819 07/01/2016 MUD P/R 7/1/16 Salaries & Wages 340,818.60 18,909.73 359,728.33 PR 1928 07/15/2016 Supplemental P/R run 7/15/16 Salaries & Wages 58.58 359,786.91 PR 1931 07/15/2016 MUD Payroll 7/15/16 Salaries & Wages 18,909.73 378,696.64 PR 1995 07/29/2016 MUD Payroll 7/29/16 Salaries & Wages 18,902.25 397,598.89 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 56,780.29 397,598.89 ** 493,633.00 Budgeted 96,034.11 Remaining 81 % Used Account: 135-50010-030-000 Overtime 1819 07/01/2016 MUD P/R 7/1/16 Overtime 491.15 7.62 498.77 PR 1931 07/15/2016 MUD Payroll 7/15/16 Overtime 15.43 514.20 PR 1995 07/29/2016 MUD Payroll 7/29/16 Overtime 7.81 522.01 PR _______________ Account: 135-50010-030-000 Overtime Totals: 30.86 522.01 ** 500.00 Budgeted (22.01) Remaining 104 % 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 1819 07/01/2016 MUD P/R 7/1/16 Retirement 30,344.99 1,651.48 31,996.47 PR 1928 07/15/2016 Supplemental P/R run 7/15/16 Retirement 5.12 32,001.59 PR 1931 07/15/2016 MUD Payroll 7/15/16 Retirement 1,652.15 33,653.74 PR 1995 07/29/2016 MUD Payroll 7/29/16 Retirement 1,650.86 35,304.60 PR _______________ Account: 135-50020-030-000 Retirement Totals: 4,959.61 35,304.60 ** 43,652.00 Budgeted 8,347.40 Remaining 81 % Used Account: 135-50026-030-000 Medical Insurance 1819 07/01/2016 MUD P/R 7/1/16 Medical Insurance 46,306.66 2,544.70 48,851.36 PR 1931 07/15/2016 MUD Payroll 7/15/16 Medical Insurance 2,544.70 51,396.06 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,089.40 51,396.06 ** 68,196.00 Budgeted 16,799.94 Remaining 75 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-030-000 Dental Insurance 1819 07/01/2016 MUD P/R 7/1/16 Dental Insurance 3,182.65 170.42 3,353.07 PR 1931 07/15/2016 MUD Payroll 7/15/16 Dental Insurance 170.42 3,523.49 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 340.84 3,523.49 ** 4,807.00 Budgeted 1,283.51 Remaining 73 % Used Account: 135-50028-030-000 Vision Insurance 1819 07/01/2016 MUD P/R 7/1/16 Vision Insurance 736.53 40.57 777.10 PR 1931 07/15/2016 MUD Payroll 7/15/16 Vision Insurance 40.57 817.67 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 81.14 817.67 ** 1,114.00 Budgeted 296.33 Remaining 73 % Used Account: 135-50029-030-000 Life Insurance & Other 1825 07/01/2016 July A/P Dental, Vision, Life, AD&D, ST 3,517.75 368.04 3,885.79 METLIFE GROUP BENEFITS 2083 AP 2089 07/31/2016 July A/P Café 125 Admin 29.16 3,914.95 BenefitMall 2152 AP 2099 07/31/2016 July A/P Rounding adjustment (.02) 3,914.93 Legal Shield 2187 AP 2109 07/31/2016 Rounding adj/benefit premiums .32 3,915.25 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 397.50 3,915.25 ** 5,431.00 Budgeted 1,515.75 Remaining 72 % Used Account: 135-50030-030-000 Social Security Taxes 1819 07/01/2016 MUD P/R 7/1/16 Social Security Taxes 19,913.99 1,088.98 21,002.97 PR 1928 07/15/2016 Supplemental P/R run 7/15/16 Social Security Taxes 3.64 21,006.61 PR 1931 07/15/2016 MUD Payroll 7/15/16 Social Security Taxes 1,089.45 22,096.06 PR 1995 07/29/2016 MUD Payroll 7/29/16 Social Security Taxes 1,180.04 23,276.10 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 3,362.11 23,276.10 ** 31,141.00 Budgeted 7,864.90 Remaining 75 % Used Account: 135-50035-030-000 Medicare Taxes 1819 07/01/2016 MUD P/R 7/1/16 Medicare Taxes 4,657.29 254.69 4,911.98 PR 1928 07/15/2016 Supplemental P/R run 7/15/16 Medicare Taxes .85 4,912.83 PR 1931 07/15/2016 MUD Payroll 7/15/16 Medicare Taxes 254.79 5,167.62 PR 1995 07/29/2016 MUD Payroll 7/29/16 Medicare Taxes 275.97 5,443.59 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 786.30 5,443.59 ** 7,678.00 Budgeted 2,234.41 Remaining 71 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-030-000 Unemployment Taxes 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 141 07/01/2016 Prepaid Insurance, W/C Jul 1,623.01 147.89 1,770.90 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 147.89 1,770.90 ** 1,554.00 Budgeted (216.90) Remaining 114 % 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 3,100.95 .00 3,100.95 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 3,100.95 ** 4,500.00 Budgeted 1,399.05 Remaining 69 % Used Account: 135-55030-030-000 Software & Support 1946 07/13/2016 July A/P Cash Receipts upgrade, support 37,028.22 1,056.00 38,084.22 STW INC 2132 AP 1946 07/13/2016 July A/P Search engine for websites 2,016.25 40,100.47 FOUR MAN FURNACE, INC. 2121 AP 1949 07/14/2016 July A/P Internet 1,120.77 41,221.24 WHOLESALE CARRIER SERVICES INC 2141 AP 2096 07/31/2016 July A/P ATT*BILL PAYMENT 176.26 41,397.50 ATT*BILL PAYMENT PC 2096 07/31/2016 July A/P ATT*BILL PAYMENT 159.94 41,557.44 ATT*BILL PAYMENT PC 2096 07/31/2016 July A/P ATT*BILL PAYMENT 150.14 41,707.58 ATT*BILL PAYMENT PC 2096 07/31/2016 July A/P ATT*BILL PAYMENT 166.46 41,874.04 ATT*BILL PAYMENT PC _______________ Account: 135-55030-030-000 Software & Support Totals: 4,845.82 41,874.04 ** 81,097.00 Budgeted 39,222.96 Remaining 52 % Used Account: 135-55070-030-000 Independent Labor 1,288.63 .00 1,288.63 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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: .00 1,288.63 ** 12,000.00 Budgeted 10,711.37 Remaining 11 % Used Account: 135-55080-030-000 Maintenance & Repairs 6,088.35 .00 6,088.35 _______________ 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 2089 07/31/2016 July A/P Rug Service MUD/PS bldgs 6,376.87 130.89 6,507.76 G & K SERVICES 2173 AP 2089 07/31/2016 July A/P Rug Service/MUD & PS Buildings 130.89 6,638.65 G & K SERVICES 2173 AP 2096 07/31/2016 July A/P JABOS ACE HDWE 17.83 6,656.48 JABOS ACE HDWE PC 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (130.89) 6,525.59 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 148.72 6,525.59 ** 7,000.00 Budgeted 474.41 Remaining 93 % Used Account: 135-55120-030-000 Cleaning Services 2089 07/31/2016 July A/P Janitorial Service/June 4,419.00 843.75 5,262.75 MEMBER'S BUILDING MAINTENANCE 2193 AP 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (259.00) 5,003.75 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 584.75 5,003.75 ** 10,125.00 Budgeted 5,121.25 Remaining 49 % Used Account: 135-55160-030-000 Professional Outside Services 2089 07/31/2016 July A/P Rate Assistance 58,045.00 5,002.88 63,047.88 NEW GEN STRATEGIES & SOLUTIONS 2196 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 5,002.88 63,047.88 ** 72,575.00 Budgeted 9,527.12 Remaining 87 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-55205-030-000 Utility Billing Contract 1946 07/13/2016 July A/P June Utility Billing/Inserts, 6,127.21 584.10 6,711.31 DATAPROSE LLC 2117 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 584.10 6,711.31 ** 8,200.00 Budgeted 1,488.69 Remaining 82 % Used Account: 135-60005-030-000 Telephone 1949 07/14/2016 July A/P Answering Service 9,495.96 225.32 9,721.28 KEYSTONE PARK SECRETARIAL 2128 AP 1949 07/14/2016 July A/P Answering Service 220.07 9,941.35 KEYSTONE PARK SECRETARIAL 2128 AP 2096 07/31/2016 July A/P RINGCENTRAL, INC 10.73 9,952.08 RINGCENTRAL, INC PC 2096 07/31/2016 July A/P ATT*BUS PHONE PMT 824.30 10,776.38 ATT*BUS PHONE PMT PC 2096 07/31/2016 July A/P ATT*BUS PHONE PMT 432.84 11,209.22 ATT*BUS PHONE PMT PC 2096 07/31/2016 July A/P ATT*BUS PHONE PMT 821.42 12,030.64 ATT*BUS PHONE PMT PC 2096 07/31/2016 July A/P ATT*BUS PHONE PMT 432.84 12,463.48 ATT*BUS PHONE PMT PC 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (880.57) 11,582.91 AR _______________ Account: 135-60005-030-000 Telephone Totals: 2,086.95 11,582.91 ** 16,349.00 Budgeted 4,766.09 Remaining 71 % Used Account: 135-60010-030-000 Communications/Mobiles 1819 07/01/2016 MUD P/R 7/1/16 Communications/Mobiles 3,139.32 300.00 3,439.32 PR 1946 07/13/2016 July A/P Cell phones 37.99 3,477.31 VERIZON WIRELESS 2139 AP 1931 07/15/2016 MUD Payroll 7/15/16 Communications/Mobiles 300.00 3,777.31 PR 2117 07/31/2016 July A/P Cell phones/July 37.99 3,815.30 VERIZON WIRELESS AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 675.98 3,815.30 ** 4,150.00 Budgeted 334.70 Remaining 92 % Used Account: 135-60020-030-000 Electricity/Gas 2117 07/31/2016 July A/P Charter,Gexa,Lasky,Verizon 5,449.19 857.76 6,306.95 TOWN OF TROPHY CLUB AP 2117 07/31/2016 July A/P Charter,Gexa,Lasky,Verizon (694.70) 5,612.25 TOWN OF TROPHY CLUB AP 2117 07/31/2016 July A/P Charter,Gexa,Lasky,Verizon (749.98) 4,862.27 TOWN OF TROPHY CLUB AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: (586.92) 4,862.27 ** 10,768.00 Budgeted 5,905.73 Remaining 45 % Used Account: 135-60025-030-000 Water 2089 07/31/2016 July A/P July Water 633.95 146.38 780.33 TROPHY CLUB MUD (WATER BILLS) 2220 AP 2116 07/31/2016 Town July A/R billing AR 20160731-20160731 User: (124.00) 656.33 AR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60025-030-000 Water Totals: 22.38 656.33 ** 1,500.00 Budgeted 843.67 Remaining 44 % Used Account: 135-60035-030-000 Postage 1946 07/13/2016 July A/P June Utility Billing/Inserts, 18,668.20 1,686.21 20,354.41 DATAPROSE LLC 2117 AP 2089 07/31/2016 July A/P Overnight letter 24.47 20,378.88 FEDERAL EXPRESS CORP 2167 AP 2089 07/31/2016 July A/P Postage machine 90.00 20,468.88 FRANCOTYP-POSTALIA, INC. 2172 AP 2117 07/31/2016 July A/P Postage for meter 1,500.00 21,968.88 U.S. Postal Service (CMRS-FP) AP _______________ Account: 135-60035-030-000 Postage Totals: 3,300.68 21,968.88 ** 28,932.00 Budgeted 6,963.12 Remaining 76 % Used Account: 135-60040-030-000 Service Charges & Fees 1821 07/01/2016 Child Support Fee 7/1/16 P/R 40,549.41 1.50 40,550.91 GL 1935 07/05/2016 Credit Cards fees 69.19 40,620.10 GL 1935 07/05/2016 Credit Cards fees 3,031.74 43,651.84 GL 1932 07/15/2016 Child support fee 7/15/16 P/R 1.50 43,653.34 GL 1996 07/29/2016 Child support fee 7/29 Payroll 1.50 43,654.84 GL 2089 07/31/2016 July A/P Direct send fees 50.00 43,704.84 Fiserv Solutions, LLC 2168 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,155.43 43,704.84 ** 55,560.00 Budgeted 11,855.16 Remaining 79 % Used Account: 135-60050-030-000 Bad Debt Expense 3,022.62 .00 3,022.62 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 3,022.62 ** 3,500.00 Budgeted 477.38 Remaining 86 % Used Account: 135-60055-030-000 Insurance 141 07/01/2016 Prepaid Insurance, W/C Jul 25,305.00 2,756.00 28,061.00 GL _______________ Account: 135-60055-030-000 Insurance Totals: 2,756.00 28,061.00 ** 52,797.00 Budgeted 24,736.00 Remaining 53 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 260.00 .00 260.00 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 260.00 ** 1,600.00 Budgeted 1,340.00 Remaining 16 % Used Account: 135-60070-030-000 Dues & Memberships 2096 07/31/2016 July A/P TEXAS MUNICIPAL LEAGUE 5,306.25 80.00 5,386.25 TEXAS MUNICIPAL LEAGUE PC 2096 07/31/2016 July A/P TEXAS MUNICIPAL LEAGUE 80.00 5,466.25 TEXAS MUNICIPAL LEAGUE PC _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 160.00 5,466.25 ** 6,000.00 Budgeted 533.75 Remaining 91 % Used Account: 135-60075-030-000 Meetings 2096 07/31/2016 July A/P KINCAID S K2 67.50 37.61 105.11 KINCAID S K2 PC _______________ Account: 135-60075-030-000 Meetings Totals: 37.61 105.11 ** 400.00 Budgeted 294.89 Remaining 26 % 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 1819 07/01/2016 MUD P/R 7/1/16 Travel & per diem 3,201.28 14.53 3,215.81 PR 1931 07/15/2016 MUD Payroll 7/15/16 Travel & per diem 59.02 3,274.83 PR 1995 07/29/2016 MUD Payroll 7/29/16 Travel & per diem 83.48 3,358.31 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 157.03 3,358.31 ** 5,400.00 Budgeted 2,041.69 Remaining 62 % Used Account: 135-60110-030-000 Physicals/Testing . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 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 2089 07/31/2016 July A/P Ad/Communications Specialist 61.74 150.00 211.74 TX MUNICIPAL LEAGUE 2221 AP _______________ Account: 135-60125-030-000 Advertising Totals: 150.00 211.74 ** 7,500.00 Budgeted 7,288.26 Remaining 3 % 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 2096 07/31/2016 July A/P BIG LOTS STORES - #452 5,276.50 25.98 5,302.48 BIG LOTS STORES - #452 PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 25.98 5,302.48 ** 17,501.00 Budgeted 12,198.52 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-030-000 Uniforms Totals: .00 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 _______________ 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 2089 07/31/2016 July A/P Office supplies 4,127.54 89.24 4,216.78 OFFICE DEPOT, INC 2199 AP 2089 07/31/2016 July A/P Office supplies 80.63 4,297.41 OFFICE DEPOT, INC 2199 AP 2089 07/31/2016 July A/P Office supplies 39.90 4,337.31 OFFICE DEPOT, INC 2199 AP 2089 07/31/2016 July A/P Copier Staple cartridges 155.10 4,492.41 KYOCERA DOCUMENT SOLUTIONS 2184 AP 2096 07/31/2016 July A/P WAL-MART #5247 7.97 4,500.38 WAL-MART #5247 PC 2096 07/31/2016 July A/P FEDEXOFFICE 00003319 (65.61) 4,434.77 FEDEXOFFICE 00003319 PC 2096 07/31/2016 July A/P FEDEXOFFICE 00003319 358.39 4,793.16 FEDEXOFFICE 00003319 PC 2096 07/31/2016 July A/P FEDEXOFFICE 00003319 10.80 4,803.96 FEDEXOFFICE 00003319 PC _______________ Account: 135-65085-030-000 Office Supplies Totals: 676.42 4,803.96 ** 9,000.00 Budgeted 4,196.04 Remaining 53 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1,004.63 .00 1,004.63 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 1,004.63 ** 4,003.00 Budgeted 2,998.37 Remaining 25 % Used Account: 135-65095-030-000 Maintenance Supplies 2096 07/31/2016 July A/P AMAZON MKTPLACE PMTS 2,709.27 32.95 2,742.22 AMAZON MKTPLACE PMTS PC 2096 07/31/2016 July A/P SAMSCLUB #4795 337.72 3,079.94 SAMSCLUB #4795 PC 2096 07/31/2016 July A/P SAMS CLUB #4795 46.20 3,126.14 SAMS CLUB #4795 PC 2096 07/31/2016 July A/P AMAZON.COM (84.86) 3,041.28 AMAZON.COM PC 2096 07/31/2016 July A/P AMAZON.COM 167.21 3,208.49 AMAZON.COM PC 2096 07/31/2016 July A/P SAMSCLUB #4795 204.39 3,412.88 SAMSCLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 703.61 3,412.88 ** 5,000.00 Budgeted 1,587.12 Remaining 68 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/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-65105-030-000 Printing 1946 07/13/2016 July A/P June Utility Billing/Inserts, 2,786.22 308.04 3,094.26 DATAPROSE LLC 2117 AP _______________ Account: 135-65105-030-000 Printing Totals: 308.04 3,094.26 ** 4,800.00 Budgeted 1,705.74 Remaining 64 % Used Account: 135-69005-030-000 Capital Outlays 1946 07/13/2016 July A/P Restroom remodel 10,118.40 7,010.00 17,128.40 CP&Y/WALLACE GROUP, INC. 2116 AP 2089 07/31/2016 July A/P Advertising/Restroom renovatio 836.00 17,964.40 STAR-TELEGRAM OPERATING LTD 2210 AP 2089 07/31/2016 July A/P Asbestos Removal 4,352.00 22,316.40 HESTER ENVIRONMENTAL, LP 2178 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 12,198.00 22,316.40 ** 56,000.00 Budgeted 33,683.60 Remaining 40 % Used Account: 135-69170-030-000 Copier Lease Installments 1946 07/13/2016 July A/P Copier lease 2,443.02 165.00 2,608.02 EVERBANK COMMERCIAL FINANCE 2119 AP 2089 07/31/2016 July A/P Copy costs 305.39 2,913.41 KYOCERA DOCUMENT SOLUTIONS 2184 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 470.39 2,913.41 ** 4,600.00 Budgeted 1,686.59 Remaining 63 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 849,526.12 ** 1,203,217.00 Budgeted 353,690.88 Remaining 71 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/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 2089 07/31/2016 July A/P July legal 228,702.81 30.00 228,732.81 THE LISTON LAW FIRM, P.C. 2214 AP 2089 07/31/2016 July A/P July legal 900.00 229,632.81 THE LISTON LAW FIRM, P.C. 2214 AP 2089 07/31/2016 July A/P July legal 3,944.75 233,577.56 THE LISTON LAW FIRM, P.C. 2214 AP 2089 07/31/2016 July A/P July Legal 60.00 233,637.56 THE LISTON LAW FIRM, P.C. 2214 AP 2089 07/31/2016 July A/P July legal/PUC 480.00 234,117.56 THE LISTON LAW FIRM, P.C. 2214 AP 2089 07/31/2016 July A/P July legal 60.00 234,177.56 THE LISTON LAW FIRM, P.C. 2214 AP _______________ Account: 135-55045-039-000 Legal Totals: 5,474.75 234,177.56 ** 386,130.00 Budgeted 151,952.44 Remaining 61 % 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 8,093.66 .00 8,093.66 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 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: ------------------------------------------------------------------------------------------------ 268,779.42 ** 424,234.00 Budgeted 155,454.58 Remaining 63 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 1,480,146.37 .00 Budgeted (1,480,146.37) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 7/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 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 7/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 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 7/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 JULY 2016 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,388,441 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,388,441 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,378,563 NET REVENUES / EXPENDITURES 9,878 TOTAL FUND BALANCE 4,388,441 TOTAL LIABILITIES AND FUND BALANCE 4,388,441 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 19:17 08/11/16 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 7/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,374.78- 9,877.88- 9,877.88 Subtotal: 1,374.78- 9,877.88- 9,877.88 Program number: 1,374.78- 9,877.88- 9,877.88 Department number: Revenues 1,374.78- 9,877.88- 9,877.88 Revenues Subtotal ----------- 1,374.78- 9,877.88- 9,877.88 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,374.78- 9,877.88- 9,877.88 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 7/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 2078 07/31/2016 Bank Interest/Month (8,503.10) (1,374.78) (9,877.88) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,374.78) (9,877.88) ** .00 Budgeted 9,877.88 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (9,877.88) ** .00 Budgeted 9,877.88 Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (9,877.88) .00 Budgeted 9,877.88 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET JULY 2016 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 3,458,182 ACCOUNTS RECEIVABLE - TOTAL ASSETS 3,458,182 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 1,720,406 TOTAL LIABILITIES 1,720,406 FUND BALANCE ASSIGNED FUND BALANCE 8,334,104 NET REVENUES / EXPENDITURES (6,596,328) TOTAL FUND BALANCE 1,737,776 TOTAL LIABILITIES AND FUND BALANCE 3,458,182 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 19:17 08/11/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 7/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 1,196.06- 14,802.29- 14,802.29 Subtotal: 1,196.06- 14,802.29- 14,802.29 Program number: 1,196.06- 14,802.29- 14,802.29 Department number: Revenues 1,196.06- 14,802.29- 14,802.29 Revenues Subtotal ----------- 1,196.06- 14,802.29- 14,802.29 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 19:17 08/11/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 7/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 2,278,250.36 6,611,129.85 6,611,129.85- Subtotal: 2,278,250.36 6,611,129.85 6,611,129.85- Program number: 2,278,250.36 6,611,129.85 6,611,129.85- Department number: Wastewater 2,278,250.36 6,611,129.85 6,611,129.85- Expenditures Subtotal ----------- 2,278,250.36 6,611,129.85 6,611,129.85- Fund number: 518 2015 Revenue Bond Const Fund 2,277,054.30 6,596,327.56 6,596,327.56- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 7/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 2078 07/31/2016 Bank Interest/Month (13,606.23) (1,196.06) (14,802.29) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (1,196.06) (14,802.29) ** .00 Budgeted 14,802.29 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (14,802.29) ** .00 Budgeted 14,802.29 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 7/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 1939 07/01/2016 Webber Retainage App 9 4,332,879.49 114,047.80 4,446,927.29 GL 1940 07/13/2016 July A/P WWTP App #9 1,026,430.13 5,473,357.42 WEBBER-CADAGUA PARTNERS 2112 AP 2081 07/25/2016 Webber App 10 Retainage 108,615.76 5,581,973.18 GL 2089 07/31/2016 July A/P WWTP Improvements 51,614.76 5,633,587.94 CP&Y/WALLACE GROUP, INC. 2164 AP 2089 07/31/2016 July A/P WWTP App 10 977,541.91 6,611,129.85 WEBBER-CADAGUA PARTNERS 2225 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 2,278,250.36 6,611,129.85 ** .00 Budgeted (6,611,129.85) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 6,611,129.85 ** .00 Budgeted (6,611,129.85) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ 6,596,327.56 .00 Budgeted (6,596,327.56) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JULY 2016 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 195,639 ACCOUNTS RECEIVABLE - TOTAL ASSETS 195,639 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 71,962 NET REVENUES / EXPENDITURES 123,677 TOTAL FUND BALANCE 195,639 TOTAL LIABILITIES AND FUND BALANCE 195,639 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 19:17 08/11/16 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 7/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 57.91- 340.96- 340.96 528-49141-000-000 Interfund Transfer In-Gen Fund 123,336.00- 123,336.00- 30,834.00- 123,336.00- 100.000 Subtotal: 123,336.00- 123,336.00- 30,891.91- 123,676.96- 100.276 340.96 Program number: 123,336.00- 123,336.00- 30,891.91- 123,676.96- 100.276 340.96 Department number: 123,336.00- 123,336.00- 30,891.91- 123,676.96- 100.276 340.96 Revenues Subtotal ----------- 123,336.00- 123,336.00- 30,891.91- 123,676.96- 100.276 340.96 Fund number: 528 2015 Revenue Bond Reserve Fund 123,336.00- 123,336.00- 30,891.91- 123,676.96- 100.276 340.96 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 7/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 2078 07/31/2016 Bank Interest/Month (283.05) (57.91) (340.96) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (57.91) (340.96) ** .00 Budgeted 340.96 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund 1936 07/12/2016 Texpool Transfers Xfer to Rev Bond Reserves (92,502.00) (30,834.00) (123,336.00) GL _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: (30,834.00) (123,336.00) ** (123,336.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (123,676.96) ** (123,336.00) Budgeted 340.96 Remaining 100 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (123,676.96) (123,336.00) Budgeted 340.96 Remaining 100 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JULY 2016 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 841,326 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 13,595 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 859,767 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 13,595 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 13,595 FUND BALANCE ASSIGNED FUND BALANCE 24,173 NET REVENUES / EXPENDITURES 821,999 TOTAL FUND BALANCE 846,172 TOTAL LIABILITIES AND FUND BALANCE 859,767 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 19:17 08/11/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/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- 1,476.99- 654,605.63- 98.010 13,292.37- 533-40002-000-000 Property Taxes/Delinquent 2,300.00- 2,300.00- 3,533.10- 8,316.66- 361.594 6,016.66 533-40015-000-000 Property Taxes/P & I 1,800.00- 1,800.00- 876.46- 3,432.83- 190.713 1,632.83 Subtotal: 671,998.00- 671,998.00- 5,886.55- 666,355.12- 99.160 5,642.88- 533-49010-000-000 Interest Income 140.00- 140.00- 260.50- 1,451.97- 1,037.121 1,311.97 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- 99,755.00- 83.333 19,951.00- Subtotal: 334,225.00- 334,225.00- 20,211.50- 315,585.97- 94.423 18,639.03- Program number: 1,006,223.00- 1,006,223.00- 26,098.05- 981,941.09- 97.587 24,281.91- Department number: Revenues 1,006,223.00- 1,006,223.00- 26,098.05- 981,941.09- 97.587 24,281.91- Revenues Subtotal ----------- 1,006,223.00- 1,006,223.00- 26,098.05- 981,941.09- 97.587 24,281.91- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 19:17 08/11/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/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- 26,098.05- 821,999.84- ############### 820,309.84 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/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 2049 07/01/2016 Property Taxes (653,128.64) (305.79) (653,434.43) GL 2050 07/07/2016 Property Taxes (7.27) (653,441.70) GL 2062 07/08/2016 Property Taxes (31.76) (653,473.46) GL 2063 07/11/2016 Property Taxes (74.93) (653,548.39) GL 2064 07/14/2016 Property Taxes (40.59) (653,588.98) GL 2065 07/15/2016 Property Taxes (21.25) (653,610.23) GL 2066 07/18/2016 Property Taxes (87.19) (653,697.42) GL 2067 07/20/2016 Property Taxes (135.03) (653,832.45) GL 2068 07/21/2016 Property Taxes (86.83) (653,919.28) GL 2069 07/22/2016 Property Taxes (95.78) (654,015.06) GL 2070 07/25/2016 Property Taxes (67.53) (654,082.59) GL 2071 07/26/2016 Property Taxes (93.87) (654,176.46) GL 2072 07/27/2016 Property Taxes (336.15) (654,512.61) GL 2073 07/28/2016 Property Taxes (65.92) (654,578.53) GL 2074 07/29/2016 Property Taxes (27.10) (654,605.63) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,476.99) (654,605.63) ** (667,898.00) Budgeted (13,292.37) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 2062 07/08/2016 Property Taxes (4,783.56) (3,533.10) (8,316.66) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (3,533.10) (8,316.66) ** (2,300.00) Budgeted 6,016.66 Remaining 362 % Used Account: 533-40015-000-000 Property Taxes/P & I 2049 07/01/2016 Property Taxes (2,556.37) (32.16) (2,588.53) GL 2062 07/08/2016 Property Taxes (820.28) (3,408.81) GL 2063 07/11/2016 Property Taxes (6.00) (3,414.81) GL 2066 07/18/2016 Property Taxes (1.31) (3,416.12) GL 2072 07/27/2016 Property Taxes (16.26) (3,432.38) GL 2073 07/28/2016 Property Taxes (.45) (3,432.83) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (876.46) (3,432.83) ** (1,800.00) Budgeted 1,632.83 Remaining 191 % Used Account: 533-49010-000-000 Interest Income 2078 07/31/2016 Bank Interest/Month (1,191.47) (260.50) (1,451.97) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 57 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/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 Totals: (260.50) (1,451.97) ** (140.00) Budgeted 1,311.97 Remaining 1.037 % 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 1936 07/12/2016 Texpool Transfers PID share of new debt (79,804.00) (19,951.00) (99,755.00) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (19,951.00) (99,755.00) ** (119,706.00) Budgeted (19,951.00) Remaining 83 % Used Department Totals: ------------------------------------------------------------------------------------------------ (981,941.09) ** (1,006,223.00) Budgeted (24,281.91) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 58 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/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: ------------------------------------------------------------------------------------------------------ (821,999.84) (1,690.00) Budgeted 820,309.84 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET JULY 2016 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 299,409 ACCOUNTS RECEIVABLE - TOTAL ASSETS 299,409 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,068 NET REVENUES / EXPENDITURES 284,341 TOTAL FUND BALANCE 299,409 TOTAL LIABILITIES AND FUND BALANCE 299,409 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 19:17 08/11/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 7/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- 89.03- 342.42- 4,891.714 335.42 534-49143-000-000 Interfund Transfer In-WW Sales 444,831.00- 444,831.00- 43,220.32- 401,617.20- 90.285 43,213.80- Subtotal: 444,838.00- 444,838.00- 43,309.35- 401,959.62- 90.361 42,878.38- Program number: 444,838.00- 444,838.00- 43,309.35- 401,959.62- 90.361 42,878.38- Department number: Revenues 444,838.00- 444,838.00- 43,309.35- 401,959.62- 90.361 42,878.38- Revenues Subtotal ----------- 444,838.00- 444,838.00- 43,309.35- 401,959.62- 90.361 42,878.38- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 19:17 08/11/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 7/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,309.35- 284,340.87- 284,340.87 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 59 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 7/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 2078 07/31/2016 Bank Interest/Month (253.39) (89.03) (342.42) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (89.03) (342.42) ** (7.00) Budgeted 335.42 Remaining 4.892 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1936 07/12/2016 Texpool Transfers Xfer to Rev Bond I&S (358,396.88) (43,220.32) (401,617.20) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (43,220.32) (401,617.20) ** (444,831.00) Budgeted (43,213.80) Remaining 90 % Used Department Totals: ------------------------------------------------------------------------------------------------ (401,959.62) ** (444,838.00) Budgeted (42,878.38) Remaining 90 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 60 19:17 08/11/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 7/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: ------------------------------------------------------------------------------------------------------ (284,340.87) .00 Budgeted 284,340.87 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 6,546,475.90 **** (125,026.00) Budgeted (6,671,501.90) Remaining ########## ******* End of Report *********