Loading...
HomeMy WebLinkAbout2016-05 May Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MAY 2016 122 ASSETS FIRE DEPT. CASH IN BANK 29,381 INVESTMENTS 833,956 PREPAID EXPENSES 4,692 ADVALOREM PROPERTY TAXES RECEIVABLE 37,864 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,736 TOTAL ASSETS 908,629 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 37,864 ACCOUNTS AND OTHER PAYABLES 8,984 TOTAL LIABILITIES 46,848 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 533,497 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 328,284 TOTAL FUND BALANCE 861,781 TOTAL LIABILITIES AND FUND BALANCE 908,629 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 14:56 06/16/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 404,346.00- 404,346.00- 371,290.86- 91.825 33,055.14- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 345.54- 345.54 122-40010-000-000 Property Taxes/MUD Fire 889,963.00- 889,963.00- 3,662.55- 867,126.44- 97.434 22,836.56- 122-40011-000-000 Property Taxes/Fire-Delinquent 7,097.18- 9,690.76- 9,690.76 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,464.08- 4,900.80- 108.907 400.80 Subtotal: 1,299,559.00- 1,298,809.00- 12,223.81- 1,253,354.40- 96.500 45,454.60- 122-42014-000-000 Fire Plan Review>6,000 sq ft 5,000.00- 5,000.00- 400.00- 4,400.00- 88.000 600.00- Subtotal: 5,000.00- 5,000.00- 400.00- 4,400.00- 88.000 600.00- 122-43400-000-000 Fire Inspections 825.00- 825.00- 75.00- 925.00- 112.121 100.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,825.00- 10,825.00- 75.00- 10,925.00- 100.924 100.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- 900.00- 9,400.00- 93.991 601.00- Subtotal: 50,000.00- 70,001.00- 900.00- 69,400.00- 99.141 601.00- Program number: 1,365,384.00- 1,384,635.00- 13,598.81- 1,338,079.40- 96.638 46,555.60- Department number: Fire Revenues 1,365,384.00- 1,384,635.00- 13,598.81- 1,338,079.40- 96.638 46,555.60- Revenues Subtotal ----------- 1,365,384.00- 1,384,635.00- 13,598.81- 1,338,079.40- 96.638 46,555.60- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 14:56 06/16/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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 16,371.89 281,109.92 55.312 227,116.08 122-50010-045-000 Overtime 48,735.00 48,735.00 2,282.28 40,586.81 83.281 8,148.19 122-50011-045-000 DPS Holiday Pay 15,852.00 15,852.00 14,717.53 92.843 1,134.47 122-50016-045-000 Longevity 5,761.00 5,761.00 5,730.00 99.462 31.00 122-50017-045-000 Certification 4,200.00 4,200.00 450.00 2,490.13 59.289 1,709.87 122-50020-045-000 Retirement 75,571.00 75,571.00 2,412.74 43,201.17 57.166 32,369.83 122-50026-045-000 Medical Insurance 65,546.00 65,546.00 2,578.59 33,211.72 50.669 32,334.28 122-50027-045-000 Dental Insurance 4,885.00 4,885.00 183.61 3,103.16 63.524 1,781.84 122-50028-045-000 Vision Insurance 859.00 859.00 34.16 628.38 73.153 230.62 122-50029-045-000 Life Insurance & Other 4,585.00 4,585.00 160.50 2,306.84 50.313 2,278.16 122-50030-045-000 Social Security Taxes 36,132.00 36,132.00 1,094.44 19,978.51 55.293 16,153.49 122-50035-045-000 Medicare Taxes 8,450.00 8,450.00 255.88 4,671.17 55.280 3,778.83 122-50040-045-000 Unemployment Taxes 1,724.00 2,000.00 20.37 2,010.58 100.529 10.58- 122-50045-045-000 Workman's Compensation 9,379.00 9,379.00 6,252.68 6,252.68 66.667 3,126.32 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 32,097.14 460,052.60 58.203 330,378.40 122-55030-045-000 Software & Support 6,661.00 6,661.00 925.00 3,710.81 55.710 2,950.19 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 2,065.72 18,986.57 75.290 6,231.43 122-55090-045-000 Vehicle Maintenance 10,000.00 10,000.00 4,229.44 11,679.00 116.790 1,679.00- 122-55160-045-000 Professional Outside Services 2,743.80 2,743.80- Subtotal: 35,031.00 46,879.00 7,220.16 43,679.68 93.175 3,199.32 122-60005-045-000 Telephone 50.00 50.00 33.04 66.080 16.96 122-60010-045-000 Communications/Mobiles 6,653.00 7,706.00 219.65 5,625.72 73.004 2,080.28 122-60020-045-000 Electricity/Gas 7,412.00 7,412.00 411.83 2,981.53 40.226 4,430.47 122-60025-045-000 Water 1,200.00 1,200.00 132.50 1,059.43 88.286 140.57 122-60026-045-000 Cable 1,920.00 1,920.00 104.61- 1,241.90 64.682 678.10 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 7.97 15.940 42.03 122-60055-045-000 Insurance 14,077.00 18,451.00 5,079.60- 7,505.74 40.679 10,945.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 85.00 2,518.39 36.605 4,361.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 54.00 54.00 1.149 4,646.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 688.39 9.179 6,811.61 122-60180-045-000 Fire Inspection/Enforcement 500.00 500.00 359.29 71.858 140.71 122-60195-045-000 Flags & Repair 3,184.00 3,184.00 1,574.50 49.450 1,609.50 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 14:56 06/16/16 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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 580.01 57.943 420.99 Subtotal: 292,019.00 298,646.00 4,281.23- 259,395.89 86.857 39,250.11 122-65005-045-000 Fuel & Lube 15,122.00 15,122.00 244.08 2,781.40 18.393 12,340.60 122-65010-045-000 Uniforms 3,140.00 3,640.00 744.88 3,756.20 103.192 116.20- 122-65015-045-000 Protective Clothing 9,000.00 9,000.00 1,680.17 4,565.93 50.733 4,434.07 122-65030-045-000 Chemicals 600.00 600.00 600.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 164.78 225.04 45.008 274.96 122-65105-045-000 Printing 498.00 498.00 498.00 Subtotal: 31,610.00 32,110.00 2,833.91 13,386.36 41.689 18,723.64 122-69050-045-000 Radios 8,000.00 8,000.00 8,000.00 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 216,569.00 216,569.00 208,568.60 96.306 8,000.40 Program number: 1,365,384.00 1,384,635.00 37,869.98 985,083.13 71.144 399,551.87 Department number: Fire 1,365,384.00 1,384,635.00 37,869.98 985,083.13 71.144 399,551.87 Expenditures Subtotal ----------- 1,365,384.00 1,384,635.00 37,869.98 985,083.13 71.144 399,551.87 Fund number: 122 Trophy Club MUD Fire Dept. 24,271.17 352,996.27- 352,996.27 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/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 1661 05/02/2016 Property Taxes/Assessments (863,463.89) (842.85) (864,306.74) GL 1664 05/04/2016 Property Taxes/Assessments (108.25) (864,414.99) GL 1665 05/09/2016 Property Taxes/Assessments (66.62) (864,481.61) GL 1668 05/11/2016 Property Taxes/Assessments (498.47) (864,980.08) GL 1669 05/13/2016 Property Taxes/Assessments (153.04) (865,133.12) GL 1671 05/16/2016 Property Taxes/Assessments (58.25) (865,191.37) GL 1673 05/17/2016 Property Taxes/Assessments (142.54) (865,333.91) GL 1674 05/18/2016 Property Taxes/Assessments (255.77) (865,589.68) GL 1675 05/19/2016 Property Taxes/Assessments (208.97) (865,798.65) GL 1676 05/20/2016 Property Taxes/Assessments (292.27) (866,090.92) GL 1677 05/23/2016 Property Taxes/Assessments (92.56) (866,183.48) GL 1678 05/24/2016 Property Taxes/Assessments (155.37) (866,338.85) GL 1679 05/25/2016 Property Taxes/Assessments (371.57) (866,710.42) GL 1680 05/26/2016 Property Taxes/Assessments (101.63) (866,812.05) GL 1681 05/27/2016 Property Taxes/Assessments (175.42) (866,987.47) GL 1682 05/31/2016 Property Taxes/Assessments (138.97) (867,126.44) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,662.55) (867,126.44) ** (889,963.00) Budgeted (22,836.56) Remaining 97 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1663 05/03/2016 Property Taxes/Assessments (2,593.58) (6,444.85) (9,038.43) GL 1665 05/09/2016 Property Taxes/Assessments (165.86) (9,204.29) GL 1679 05/25/2016 Property Taxes/Assessments (478.10) (9,682.39) GL 1681 05/27/2016 Property Taxes/Assessments (1.06) (9,683.45) GL 1682 05/31/2016 Property Taxes/Assessments (7.31) (9,690.76) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/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-40011-000-000 Property Taxes/Fire-Delinquent Totals: (7,097.18) (9,690.76) ** .00 Budgeted 9,690.76 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1661 05/02/2016 Property Taxes/Assessments (3,436.72) (58.83) (3,495.55) GL 1663 05/03/2016 Property Taxes/Assessments (1,213.66) (4,709.21) GL 1664 05/04/2016 Property Taxes/Assessments (6.87) (4,716.08) GL 1665 05/09/2016 Property Taxes/Assessments (37.71) (4,753.79) GL 1668 05/11/2016 Property Taxes/Assessments (29.59) (4,783.38) GL 1674 05/18/2016 Property Taxes/Assessments (20.57) (4,803.95) GL 1675 05/19/2016 Property Taxes/Assessments (7.55) (4,811.50) GL 1679 05/25/2016 Property Taxes/Assessments (69.88) (4,881.38) GL 1680 05/26/2016 Property Taxes/Assessments (1.68) (4,883.06) GL 1681 05/27/2016 Property Taxes/Assessments (6.62) (4,889.68) GL 1682 05/31/2016 Property Taxes/Assessments (11.12) (4,900.80) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (1,464.08) (4,900.80) ** (4,500.00) Budgeted 400.80 Remaining 109 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (4,000.00) (400.00) (4,400.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (4,400.00) ** (5,000.00) Budgeted (600.00) Remaining 88 % Used Account: 122-43400-000-000 Fire Inspections 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (850.00) (75.00) (925.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (925.00) ** (825.00) Budgeted 100.00 Remaining 112 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (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 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (8,500.00) (900.00) (9,400.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (900.00) (9,400.00) ** (10,001.00) Budgeted (601.00) Remaining 94 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,338,079.40) ** (1,384,635.00) Budgeted (46,555.60) Remaining 97 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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 1517 05/06/2016 Fire Dept Payroll 5/6/16 264,738.03 16,371.89 281,109.92 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 16,371.89 281,109.92 ** 508,226.00 Budgeted 227,116.08 Remaining 55 % Used Account: 122-50010-045-000 Overtime 1517 05/06/2016 Fire Dept Payroll 5/6/16 38,304.53 2,282.28 40,586.81 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,282.28 40,586.81 ** 48,735.00 Budgeted 8,148.19 Remaining 83 % 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 1517 05/06/2016 Fire Dept Payroll 5/6/16 2,040.13 450.00 2,490.13 GL _______________ Account: 122-50017-045-000 Certification Totals: 450.00 2,490.13 ** 4,200.00 Budgeted 1,709.87 Remaining 59 % Used Account: 122-50020-045-000 Retirement 1517 05/06/2016 Fire Dept Payroll 5/6/16 40,788.43 2,412.74 43,201.17 GL _______________ Account: 122-50020-045-000 Retirement Totals: 2,412.74 43,201.17 ** 75,571.00 Budgeted 32,369.83 Remaining 57 % Used Account: 122-50026-045-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1517 05/06/2016 Fire Dept Payroll 5/6/16 30,633.13 2,578.59 33,211.72 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 2,578.59 33,211.72 ** 65,546.00 Budgeted 32,334.28 Remaining 51 % Used Account: 122-50027-045-000 Dental Insurance 1517 05/06/2016 Fire Dept Payroll 5/6/16 2,919.55 183.61 3,103.16 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 183.61 3,103.16 ** 4,885.00 Budgeted 1,781.84 Remaining 64 % Used Account: 122-50028-045-000 Vision Insurance 1517 05/06/2016 Fire Dept Payroll 5/6/16 594.22 34.16 628.38 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 34.16 628.38 ** 859.00 Budgeted 230.62 Remaining 73 % Used Account: 122-50029-045-000 Life Insurance & Other 1517 05/06/2016 Fire Dept Payroll 5/6/16 2,146.34 160.50 2,306.84 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 160.50 2,306.84 ** 4,585.00 Budgeted 2,278.16 Remaining 50 % Used Account: 122-50030-045-000 Social Security Taxes 1517 05/06/2016 Fire Dept Payroll 5/6/16 18,884.07 1,094.44 19,978.51 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 1,094.44 19,978.51 ** 36,132.00 Budgeted 16,153.49 Remaining 55 % Used Account: 122-50035-045-000 Medicare Taxes 1517 05/06/2016 Fire Dept Payroll 5/6/16 4,415.29 255.88 4,671.17 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 255.88 4,671.17 ** 8,450.00 Budgeted 3,778.83 Remaining 55 % Used Account: 122-50040-045-000 Unemployment Taxes 1517 05/06/2016 Fire Dept Payroll 5/6/16 1,990.21 20.37 2,010.58 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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-50040-045-000 Unemployment Taxes Totals: 20.37 2,010.58 ** 2,000.00 Budgeted (10.58) Remaining 101 % Used Account: 122-50045-045-000 Workman's Compensation 1760 05/31/2016 Breakout From W/C from Ins 6,252.68 6,252.68 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 6,252.68 6,252.68 ** 9,379.00 Budgeted 3,126.32 Remaining 67 % 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 1670 05/31/2016 May A/P Charter, CareNow, Gexa, Verizo 2,785.81 462.50 3,248.31 TOWN OF TROPHY CLUB 2000 AP 1670 05/31/2016 May A/P Charter, CareNow, Gexa, Verizo 462.50 3,710.81 TOWN OF TROPHY CLUB 2000 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 925.00 3,710.81 ** 6,661.00 Budgeted 2,950.19 Remaining 56 % Used Account: 122-55045-045-000 Legal 6,559.50 .00 6,559.50 _______________ Account: 122-55045-045-000 Legal Totals: .00 6,559.50 ** 5,000.00 Budgeted (1,559.50) Remaining 131 % Used Account: 122-55080-045-000 Maintenance & Repairs 1575 05/18/2016 May A/P Annual Fire Alarm/Sprinkler in 16,920.85 450.00 17,370.85 KIMBROUGH FIRE EXTINQUISHER CO 1895 AP 1595 05/20/2016 Void Ck 1447/Lost in mail Reissue for lost check # 1282 (178.00) 17,192.85 VALLELUNGA ENTERPRISES LLC 1447 AP 1596 05/20/2016 May A/P Replace lost A/P Check 1447 178.00 17,370.85 VALLELUNGA ENTERPRISES LLC 1918 AP 1719 05/26/2016 4/27/16-5/26/16 PCards THE HOME DEPOT 6581 11.45 17,382.30 THE HOME DEPOT 6581 PC 1719 05/26/2016 4/27/16-5/26/16 PCards GUINCO SERVICE 324.08 17,706.38 GUINCO SERVICE PC 1719 05/26/2016 4/27/16-5/26/16 PCards WM SUPERCENTER #5247 13.96 17,720.34 WM SUPERCENTER #5247 PC 1719 05/26/2016 4/27/16-5/26/16 PCards THE HOME DEPOT 6581 41.88 17,762.22 THE HOME DEPOT 6581 PC 1719 05/26/2016 4/27/16-5/26/16 PCards THE HOME DEPOT 6581 132.98 17,895.20 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1719 05/26/2016 4/27/16-5/26/16 PCards THE HOME DEPOT 6581 16,920.85 406.10 18,301.30 THE HOME DEPOT 6581 PC 1719 05/26/2016 4/27/16-5/26/16 PCards AMAZON.COM 32.00 18,333.30 AMAZON.COM PC 1719 05/26/2016 4/27/16-5/26/16 PCards SAMS CLUB #4795 381.03 18,714.33 SAMS CLUB #4795 PC 1670 05/31/2016 May A/P Pest Control/Fire Dept 140.00 18,854.33 GANN'S PEST CONTROL 1947 AP 1670 05/31/2016 May A/P Fire Sta Temp Roof repair 165.00 19,019.33 TK CONTRACTORS LLC 1999 AP 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (107.24) 18,912.09 AR 1722 05/31/2016 May A/P Rug Service/Fire Station 37.24 18,949.33 G & K SERVICES 1946 AP 1722 05/31/2016 May A/P Rug Service/Fire Station 37.24 18,986.57 G & K SERVICES 1946 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 2,065.72 18,986.57 ** 25,218.00 Budgeted 6,231.43 Remaining 75 % Used Account: 122-55090-045-000 Vehicle Maintenance 1575 05/18/2016 May A/P E-681 Repairs 7,449.56 1,197.84 8,647.40 SIDDONS-MARTIN EMERGENCY GROUP 1904 AP 1575 05/18/2016 May A/P E-681 Repairs 1,552.13 10,199.53 SIDDONS-MARTIN EMERGENCY GROUP 1905 AP 1719 05/26/2016 4/27/16-5/26/16 PCards ROANOKE AUTO SUPPLY LT 4.14 10,203.67 ROANOKE AUTO SUPPLY LT PC 1719 05/26/2016 4/27/16-5/26/16 PCards ROANOKE AUTO SUPPLY LT (18.00) 10,185.67 ROANOKE AUTO SUPPLY LT PC 1719 05/26/2016 4/27/16-5/26/16 PCards ROANOKE AUTO SUPPLY LT 165.00 10,350.67 ROANOKE AUTO SUPPLY LT PC 1670 05/31/2016 May A/P E681 repairs 1,328.33 11,679.00 INDUSTRIAL POWER TRUCK & EQUIP 1960 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 4,229.44 11,679.00 ** 10,000.00 Budgeted (1,679.00) Remaining 117 % Used Account: 122-55160-045-000 Professional Outside Services 2,743.80 .00 2,743.80 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 2,743.80 ** .00 Budgeted (2,743.80) Remaining 0 % Used Account: 122-60005-045-000 Telephone 33.04 .00 33.04 _______________ Account: 122-60005-045-000 Telephone Totals: .00 33.04 ** 50.00 Budgeted 16.96 Remaining 66 % Used Account: 122-60010-045-000 Communications/Mobiles 1517 05/06/2016 Fire Dept Payroll 5/6/16 5,406.07 75.00 5,481.07 GL 1670 05/31/2016 May A/P Charter, CareNow, Gexa, Verizo 144.65 5,625.72 TOWN OF TROPHY CLUB 2000 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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-60010-045-000 Communications/Mobiles Totals: 219.65 5,625.72 ** 7,706.00 Budgeted 2,080.28 Remaining 73 % Used Account: 122-60020-045-000 Electricity/Gas 1670 05/31/2016 May A/P Gas Fire Station 4/16-5/18/16 2,569.70 60.44 2,630.14 ATMOS ENERGY 1928 AP 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (411.82) 2,218.32 AR 1722 05/31/2016 May A/P Fire Station Electric 4/11-5/1 763.21 2,981.53 HUDSON ENERGY SERVICES, LLC 1957 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 411.83 2,981.53 ** 7,412.00 Budgeted 4,430.47 Remaining 40 % Used Account: 122-60025-045-000 Water 1670 05/31/2016 May A/P May Water 926.93 265.00 1,191.93 TROPHY CLUB MUD (WATER BILLS) 2002 AP 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (132.50) 1,059.43 AR _______________ Account: 122-60025-045-000 Water Totals: 132.50 1,059.43 ** 1,200.00 Budgeted 140.57 Remaining 88 % Used Account: 122-60026-045-000 Cable 1719 05/26/2016 4/27/16-5/26/16 PCards ATT*BILL PAYMENT 1,346.51 128.76 1,475.27 ATT*BILL PAYMENT PC 1719 05/26/2016 4/27/16-5/26/16 PCards ATT*BILL PAYMENT 158.69 1,633.96 ATT*BILL PAYMENT PC 1714 05/31/2016 Fire Assoc/Mar-May cable (392.06) 1,241.90 GL _______________ Account: 122-60026-045-000 Cable Totals: (104.61) 1,241.90 ** 1,920.00 Budgeted 678.10 Remaining 65 % 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 7.97 .00 7.97 _______________ Account: 122-60035-045-000 Postage Totals: .00 7.97 ** 50.00 Budgeted 42.03 Remaining 16 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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-60055-045-000 Insurance 139 05/01/2016 Prepaid Insurance, W/C May 12,585.34 1,173.08 13,758.42 GL 1760 05/31/2016 Breakout From W/C from Ins (6,252.68) 7,505.74 GL _______________ Account: 122-60055-045-000 Insurance Totals: (5,079.60) 7,505.74 ** 18,451.00 Budgeted 10,945.26 Remaining 41 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 172.05 .00 172.05 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 172.05 ** 350.00 Budgeted 177.95 Remaining 49 % Used Account: 122-60070-045-000 Dues & Memberships 15,456.59 .00 15,456.59 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 15,456.59 ** 15,582.00 Budgeted 125.41 Remaining 99 % Used Account: 122-60080-045-000 Schools & Training 1670 05/31/2016 May A/P MMISC State Testing/H Hawkins 2,433.39 85.00 2,518.39 TARRANT COUNTY COLLEGE 1996 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 85.00 2,518.39 ** 6,880.00 Budgeted 4,361.61 Remaining 37 % Used Account: 122-60096-045-000 Emergency Management .00 .00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-60100-045-000 Travel & per diem 958.34 .00 958.34 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 958.34 ** 2,081.00 Budgeted 1,122.66 Remaining 46 % Used Account: 122-60110-045-000 Physicals/Testing . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1670 05/31/2016 May A/P Charter, CareNow, Gexa, Verizo 54.00 54.00 TOWN OF TROPHY CLUB 2000 AP _______________ Account: 122-60110-045-000 Physicals/Testing Totals: 54.00 54.00 ** 4,700.00 Budgeted 4,646.00 Remaining 1 % 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 688.39 .00 688.39 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 688.39 ** 7,500.00 Budgeted 6,811.61 Remaining 9 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 359.29 .00 359.29 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 359.29 ** 500.00 Budgeted 140.71 Remaining 72 % Used Account: 122-60195-045-000 Flags & Repair 1,574.50 .00 1,574.50 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 1,574.50 ** 3,184.00 Budgeted 1,609.50 Remaining 49 % Used Account: 122-60245-045-000 Miscellaneous Expense 580.01 .00 580.01 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 580.01 ** 1,001.00 Budgeted 420.99 Remaining 58 % Used Account: 122-65005-045-000 Fuel & Lube 1670 05/31/2016 May A/P Fuel 4/25-5/24/16 2,537.32 393.64 2,930.96 US Bank Voyager Fleet Systems 2004 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1720 05/31/2016 May A/P Fuel Rebate Adjustment 2,537.32 (149.56) 2,781.40 US Bank Voyager Fleet Systems 2004 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 244.08 2,781.40 ** 15,122.00 Budgeted 12,340.60 Remaining 18 % Used Account: 122-65010-045-000 Uniforms 1575 05/18/2016 May A/P Uniforms 3,011.32 345.60 3,356.92 RED THE UNIFORM TAILOR 1902 AP 1719 05/26/2016 4/27/16-5/26/16 PCards TROPHY CLUB CLEANERS 36.00 3,392.92 TROPHY CLUB CLEANERS PC 1670 05/31/2016 May A/P Uniforms 589.25 3,982.17 RED THE UNIFORM TAILOR 1987 AP 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (708.87) 3,273.30 AR 1722 05/31/2016 May A/P Uniforms 482.90 3,756.20 RED THE UNIFORM TAILOR 1987 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 744.88 3,756.20 ** 3,640.00 Budgeted (116.20) Remaining 103 % Used Account: 122-65015-045-000 Protective Clothing 1670 05/31/2016 May A/P Structural boots/Jason Horne 2,885.76 325.00 3,210.76 CASCO INDUSTRIES INC 1932 AP 1670 05/31/2016 May A/P SCBA Masks 800.64 4,011.40 MUNICIPAL EMERGENCY SERVICES 1978 AP 1670 05/31/2016 May A/P NFPA 1851 Cleaning/Test (Garre 554.53 4,565.93 Gear Cleaning Solutions, LLC 1948 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 1,680.17 4,565.93 ** 9,000.00 Budgeted 4,434.07 Remaining 51 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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-65055-045-000 Hardware Totals: .00 195.42 ** 750.00 Budgeted 554.58 Remaining 26 % Used Account: 122-65085-045-000 Office Supplies 1719 05/26/2016 4/27/16-5/26/16 PCards STAPLES 00112821 60.26 24.99 85.25 STAPLES 00112821 PC 1722 05/31/2016 May A/P Office Supplies 40.69 125.94 OFFICE DEPOT, INC 1980 AP 1722 05/31/2016 May A/P Office Supplies 99.10 225.04 OFFICE DEPOT, INC 1980 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 164.78 225.04 ** 500.00 Budgeted 274.96 Remaining 45 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 498.00 Budgeted 498.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 8,000.00 Budgeted 8,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 985,083.13 ** 1,384,635.00 Budgeted 399,551.87 Remaining 71 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (352,996.27) .00 Budgeted 352,996.27 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET MAY 2016 GENERAL FUND GASB CAPITAL PROJECTS- GENERAL FUND COMBINED BALANCE @ 5/31/16 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK-CHECKING 380,028 - - 380,028 CASH IN BANK-SAVINGS-CASH RESERVE 180,000 - - 180,000 CD-BANK OF THE WEST/THB DEPOSIT 35,000 - - 35,000 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,511,354 - - 1,511,354 INVESTMENTS-TEXPOOL 936,054 326,020 - 1,262,073 PREPAID EXPENSES 23,137 - - 23,137 ADVALOREM PROPERTY TAXES RECEIVABLE 236 - - 236 UTILITY AND OTHER ACCOUNTS RECEIVABLE 567,440 - - 567,440 TOTAL ASSETS 3,633,848 326,020 - 3,959,868 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 236 - - 236 ACCOUNTS AND OTHER PAYABLES 852,832 - - 852,832 CUSTOMER DEPOSITS 314,000 - - 314,000 - TOTAL LIABILITIES 1,167,068 - - 1,167,068 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 326,020 326,020 NON-SPENDABLE FUND BALANCE 30,686 30,686 ASSIGNED FUND BALANCE 195,000 - 195,000 UNASSIGNED FUND BALANCE 2,070,826 - 8,032 2,078,858 COMMITTED FUND BALANCE 892,901 - - 892,901 NET REVENUES / EXPENDITURES (722,633) - (8,032) (730,665) - TOTAL FUND BALANCE 2,466,780 326,020 - 2,792,800 - TOTAL LIABILITIES AND FUND BALANCE 3,633,848 326,020 - 3,959,868 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 14:56 06/16/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/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- 239.38- 56,671.78- 97.406 1,509.22- 135-40002-000-000 Property Taxes/Delinquent 934.05- 1,273.46- 1,273.46 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 208.20- 491.49- 75.614 158.51- 135-40025-000-000 PID Surcharges 146,125.00- 146,125.00- 146,125.00- Subtotal: 204,956.00- 204,956.00- 1,381.63- 58,436.73- 28.512 146,519.27- 135-47000-000-000 Water 5,080,244.00- 5,080,244.00- 272,515.78- 2,207,004.83- 43.443 2,873,239.17- 135-47005-000-000 Sewer 2,413,776.00- 2,413,776.00- 177,534.65- 1,372,648.47- 56.867 1,041,127.53- 135-47025-000-000 Penalties 90,985.00- 90,985.00- 4,597.62- 66,085.66- 72.634 24,899.34- 135-47030-000-000 Service Charges 9,000.00- 9,000.00- 875.00- 9,825.00- 109.167 825.00 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 150.00- 1,950.00- 97.500 50.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 450.00- 5,700.00- 103.636 200.00 135-47070-000-000 TCCC Effluent Charges 61,330.00- 61,330.00- 11,746.00- 19.152 49,584.00- Subtotal: 7,662,835.00- 7,662,835.00- 456,123.05- 3,674,959.96- 47.958 3,987,875.04- 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,106.35- 8,241.87- 82.419 1,758.13- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 7,284.24- 66.669 3,641.76- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 4,666.64- 66.666 2,333.36- 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- 3,087.00- 42,246.42- 267.755 26,468.42 135-49141-000-000 Interfund Transfer In 8,034.36- 8,034.36 135-49900-000-000 Miscellaneous Income 63,249.00- 63,249.00- 3,248.45- 4,484.83- 7.091 58,764.17- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 8.00- 28.40- 142.000 8.40 Subtotal: 110,993.00- 686,576.00- 8,943.66- 105,921.76- 15.428 580,654.24- Program number: 8,047,784.00- 8,609,567.00- 466,448.34- 3,894,518.45- 45.235 4,715,048.55- Department number: Revenues 8,047,784.00- 8,609,567.00- 466,448.34- 3,894,518.45- 45.235 4,715,048.55- Revenues Subtotal ----------- 8,047,784.00- 8,609,567.00- 466,448.34- 3,894,518.45- 45.235 4,715,048.55- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 14:56 06/16/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 265,614.00 260,062.00 16,770.90 134,350.55 51.661 125,711.45 135-50010-010-000 Overtime 19,500.00 19,500.00 1,672.10 9,089.38 46.612 10,410.62 135-50016-010-000 Longevity 2,945.00 2,945.00 2,945.00 100.000 135-50017-010-000 Certification 4,200.00 3,600.00 200.00 1,525.00 42.361 2,075.00 135-50020-010-000 Retirement 25,558.00 25,018.00 1,627.53 13,017.64 52.033 12,000.36 135-50026-010-000 Medical Insurance 51,398.00 51,398.00 3,161.15 24,782.06 48.216 26,615.94 135-50027-010-000 Dental Insurance 3,999.00 3,999.00 240.77 1,861.64 46.553 2,137.36 135-50028-010-000 Vision Insurance 910.00 910.00 53.98 419.20 46.066 490.80 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 203.46 1,557.62 55.570 1,245.38 135-50030-010-000 Social Security Taxes 18,565.00 18,146.00 1,145.78 9,097.02 50.132 9,048.98 135-50035-010-000 Medicare Taxes 4,341.00 4,243.00 267.97 2,127.51 50.142 2,115.49 135-50040-010-000 Unemployment Taxes 1,242.00 1,026.00 11.77 859.06 83.729 166.94 135-50045-010-000 Workman's Compensation 14,754.00 14,754.00 1,229.35 7,520.28 50.971 7,233.72 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 236.45 18.188 1,063.55 135-50070-010-000 Employee Relations 300.00 300.00 75.22 25.073 224.78 Subtotal: 417,429.00 410,004.00 26,584.76 209,463.63 51.088 200,540.37 135-55005-010-000 Engineering 5,000.00 109,400.00 11,435.00 41,420.60 37.862 67,979.40 135-55080-010-000 Maintenance & Repairs 85,000.00 99,500.00 5,297.05 67,997.76 68.339 31,502.24 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 156.76 3,140.69 39.259 4,859.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 477.70 2,736.87 49.761 2,763.13 Subtotal: 107,000.00 225,900.00 17,366.51 118,188.69 52.319 107,711.31 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 346.99 2,878.03 53.297 2,521.97 135-60020-010-000 Electricity 166,823.00 166,823.00 9,808.21 78,572.99 47.100 88,250.01 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.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 30.00 1,268.00 21.964 4,505.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 8.91 87.09 6.221 1,312.91 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 324.64 324.64 21.643 1,175.36 135-60135-010-000 TCEQ Fees & Permits 49,275.00 49,275.00 2,673.60 13,175.00 26.738 36,100.00 135-60150-010-000 Wholesale Water 2,948,742.00 2,948,742.00 161,225.28 1,013,176.42 34.360 1,935,565.58 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 44.00 2,243.64 64.104 1,256.36 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 174,461.63 1,111,985.78 34.894 2,074,777.22 135-65005-010-000 Fuel & Lube 35,947.00 35,947.00 794.25 8,989.75 25.008 26,957.25 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 14:56 06/16/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 529.71 8,368.48 64.373 4,631.52 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 5,130.00 92,435.34 80.379 22,564.66 135-65053-010-000 Meter Change Out Program 50,000.00 77,325.00 77,325.00 100.000 Subtotal: 219,755.00 248,080.00 6,453.96 189,698.34 76.467 58,381.66 135-69005-010-000 Capital Outlays 201,000.00 400,250.00 19,744.60 339,615.98 84.851 60,634.02 135-69008-010-000 Short Term Debt-Principal 130,720.00 130,720.00 130,700.34 99.985 19.66 135-69009-010-000 Short Term Debt-Interest 1,209.00 1,209.00 1,177.54 97.398 31.46 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 126,958.00 126,958.00 126,957.75 100.000 .25 Subtotal: 534,887.00 734,137.00 19,744.60 673,451.61 91.734 60,685.39 Program number: 4,465,834.00 4,804,884.00 244,611.46 2,302,788.05 47.926 2,502,095.95 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 14:56 06/16/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/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 296.19 1,117.74 22.355 3,882.26 Subtotal: 5,000.00 5,000.00 296.19 1,117.74 22.355 3,882.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 296.19 1,117.74 11.177 8,882.26 Department number: Water 4,475,834.00 4,814,884.00 244,907.65 2,303,905.79 47.850 2,510,978.21 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 14:56 06/16/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 351,671.00 351,671.00 28,843.30 225,093.73 64.007 126,577.27 135-50010-020-000 Overtime 19,500.00 29,500.00 2,993.78 22,748.03 77.112 6,751.97 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 625.00 4,850.00 67.361 2,350.00 135-50020-020-000 Retirement 33,652.00 33,652.00 2,833.95 22,770.22 67.664 10,881.78 135-50026-020-000 Medical Insurance 65,989.00 65,989.00 5,531.97 41,796.66 63.339 24,192.34 135-50027-020-000 Dental Insurance 4,184.00 4,184.00 347.91 2,554.17 61.046 1,629.83 135-50028-020-000 Vision Insurance 972.00 972.00 78.05 578.90 59.558 393.10 135-50029-020-000 Life Insurance & Other 3,655.00 3,655.00 357.87 2,695.89 73.759 959.11 135-50030-020-000 Social Security Taxes 24,665.00 24,665.00 1,812.85 14,615.75 59.257 10,049.25 135-50035-020-000 Medicare Taxes 5,768.00 5,768.00 423.96 3,418.17 59.261 2,349.83 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 3,896.95 41.826 5,420.05 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 45.50 367.78 56.582 282.22 Subtotal: 535,097.00 544,852.00 44,670.57 352,953.27 64.780 191,898.73 135-55070-020-000 Independent Labor 50,000.00 50,000.00 20,711.50 20,711.50 41.423 29,288.50 135-55080-020-000 Maintenance & Repairs 72,600.00 83,100.00 6,126.17 72,146.15 86.818 10,953.85 135-55090-020-000 Vehicle Maintenance 5,000.00 7,500.00 599.50 4,801.83 64.024 2,698.17 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 291.00 58.200 209.00 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 3,622.94 25,582.82 46.514 29,417.18 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 2,110.00 26,234.40 74.955 8,765.60 Subtotal: 218,100.00 231,100.00 33,170.11 149,767.70 64.806 81,332.30 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 547.57 3,827.62 70.882 1,572.38 135-60020-020-000 Electricity 161,582.00 161,582.00 11,756.91 70,745.49 43.783 90,836.51 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 2,353.00 62.397 1,418.00 135-60090-020-000 Safety Program 550.00 550.00 296.67 53.940 253.33 135-60100-020-000 Travel & per diem 1,600.00 1,600.00 86.09 744.79 46.549 855.21 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 1,350.00 4,588.50 50.983 4,411.50 135-60135-020-000 TCEQ Fees & Permits 37,150.00 37,150.00 19,990.00- 14,578.74 39.243 22,571.26 135-60245-020-000 Miscellaneous Expenses 297.00 297.00 250.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 59,853.00 50.000 59,853.00 135-60332-020-000 Interfund Transfer Out-Rev I&S 444,831.00 444,831.00 43,220.32 315,176.56 70.853 129,654.44 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 92,502.00 75.000 30,834.00 Subtotal: 908,423.00 908,423.00 57,171.89 565,289.61 62.228 343,133.39 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 14:56 06/16/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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 628.83 7,159.33 22.358 24,861.67 135-65010-020-000 Uniforms 4,241.00 4,241.00 119.99 2,623.52 61.861 1,617.48 135-65030-020-000 Chemicals 27,000.00 27,000.00 3,485.00 21,183.25 78.456 5,816.75 135-65035-020-000 Small Tools 2,000.00 2,000.00 371.89 18.595 1,628.11 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 1,805.66 13,004.09 100.031 4.09- Subtotal: 79,012.00 79,012.00 6,039.48 44,918.67 56.850 34,093.33 135-69005-020-000 Capital Outlays 150,000.00 356,000.00 99,345.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 99,345.00 290,921.08 77.070 86,555.92 Program number: 1,912,109.00 2,140,864.00 240,397.05 1,403,850.33 65.574 737,013.67 Department number: Wastewater 1,912,109.00 2,140,864.00 240,397.05 1,403,850.33 65.574 737,013.67 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 14:56 06/16/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/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 500.00 5,200.00 41.600 7,300.00 135-50030-026-000 Social Security Taxes 775.00 775.00 31.00 322.40 41.600 452.60 135-50035-026-000 Medicare Taxes 181.00 181.00 7.25 75.40 41.657 105.60 135-50040-026-000 Unemployment Taxes 230.00 12.00 35.70 297.500 23.70- 135-50045-026-000 Workman's Compensation 37.00 50.00 3.08 37.65 75.300 12.35 Subtotal: 13,723.00 13,518.00 541.33 5,671.15 41.953 7,846.85 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 10.98 2.196 489.02 135-60075-026-000 Meetings 1,200.00 1,200.00 21.67 1.806 1,178.33 135-60080-026-000 Schools & Training 4,000.00 4,000.00 905.00 22.625 3,095.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,602.43 32.049 3,397.57 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 169.40 219.88 10.994 1,780.12 Subtotal: 12,850.00 12,850.00 169.40 2,759.96 21.478 10,090.04 Program number: 26,573.00 26,368.00 710.73 8,431.11 31.975 17,936.89 Department number: Board of Directors 26,573.00 26,368.00 710.73 8,431.11 31.975 17,936.89 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 14:56 06/16/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 488,508.00 493,633.00 37,781.11 302,954.87 61.372 190,678.13 135-50010-030-000 Overtime 1,000.00 500.00 111.19 482.99 96.598 17.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 3,308.01 27,038.78 61.942 16,613.22 135-50026-030-000 Medical Insurance 68,196.00 68,196.00 5,310.72 41,217.23 60.439 26,978.77 135-50027-030-000 Dental Insurance 4,807.00 4,807.00 378.79 2,841.78 59.118 1,965.22 135-50028-030-000 Vision Insurance 1,114.00 1,114.00 87.14 655.33 58.827 458.67 135-50029-030-000 Life Insurance & Other 4,431.00 5,431.00 401.81 3,120.59 57.459 2,310.41 135-50030-030-000 Social Security Taxes 30,823.00 31,141.00 2,163.26 17,721.45 56.907 13,419.55 135-50035-030-000 Medicare Taxes 7,599.00 7,678.00 505.93 4,144.52 53.979 3,533.48 135-50040-030-000 Unemployment Taxes 1,449.00 1,197.00 1.23 1,197.00 100.000 135-50045-030-000 Workman's Compensation 1,554.00 1,554.00 147.89 1,475.12 94.924 78.88 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 42.94 3,029.86 67.330 1,470.14 Subtotal: 662,006.00 667,726.00 50,240.02 409,702.02 61.358 258,023.98 135-55030-030-000 Software & Support 78,483.00 81,097.00 1,761.52 35,907.45 44.277 45,189.55 135-55070-030-000 Independent Labor 12,000.00 12,000.00 120.00 1,139.38 9.495 10,860.62 135-55080-030-000 Maintenance & Repairs 29,500.00 7,000.00 120.00 6,088.35 86.976 911.65 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 490.89 4,948.70 70.696 2,051.30 135-55120-030-000 Cleaning Services 10,125.00 10,125.00 584.75 3,834.25 37.869 6,290.75 135-55160-030-000 Professional Outside Services 61,075.00 72,575.00 53,072.50 73.128 19,502.50 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 1,186.04 4,962.21 60.515 3,237.79 Subtotal: 206,583.00 198,197.00 4,263.20 109,952.84 55.477 88,244.16 135-60005-030-000 Telephone 16,349.00 16,349.00 638.44 9,091.77 55.611 7,257.23 135-60010-030-000 Communications/Mobiles 4,150.00 4,150.00 337.99 2,801.33 67.502 1,348.67 135-60020-030-000 Electricity/Gas 10,768.00 10,768.00 949.82 4,661.10 43.287 6,106.90 135-60025-030-000 Water 1,500.00 1,500.00 60.49 576.56 38.437 923.44 135-60035-030-000 Postage 28,932.00 28,932.00 1,811.85 15,801.95 54.618 13,130.05 135-60040-030-000 Service Charges & Fees 44,000.00 55,560.00 3,135.92 37,382.53 67.283 18,177.47 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 2,015.35 57.581 1,484.65 135-60055-030-000 Insurance 52,797.00 52,797.00 2,756.00 22,349.00 42.330 30,448.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 300.00 5,306.25 88.438 693.75 135-60075-030-000 Meetings 400.00 400.00 29.00 7.250 371.00 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 90.00 3,382.00 34.041 6,553.00 135-60100-030-000 Travel & per diem 5,400.00 5,400.00 109.81 2,808.27 52.005 2,591.73 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 7,500.00 7,500.00 2,150.39 3,210.41 42.805 4,289.59 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 14:56 06/16/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 7,500.00 7,500.00 61.74 .823 7,438.26 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,501.00 17,501.00 159.45 5,276.50 30.150 12,224.50 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 656.38 26.255 1,843.62 Subtotal: 226,882.00 238,442.00 12,500.16 119,900.48 50.285 118,541.52 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 254.47 3,753.01 41.700 5,246.99 135-65090-030-000 Printer Supplies & Maintenance 4,003.00 4,003.00 406.44 10.153 3,596.56 135-65095-030-000 Maintenance Supplies 5,000.00 5,000.00 222.95 2,376.92 47.538 2,623.08 135-65105-030-000 Printing 4,800.00 4,800.00 1,348.88 28.102 3,451.12 Subtotal: 54,252.00 38,252.00 477.42 13,780.10 36.025 24,471.90 135-69005-030-000 Capital Outlays 56,000.00 56,000.00 1,255.40 8,260.90 14.752 47,739.10 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 263.25 2,197.38 47.769 2,402.62 Subtotal: 60,600.00 60,600.00 1,518.65 10,458.28 17.258 50,141.72 Program number: 1,210,323.00 1,203,217.00 68,999.45 663,793.72 55.168 539,423.28 Department number: Administration 1,210,323.00 1,203,217.00 68,999.45 663,793.72 55.168 539,423.28 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 14:56 06/16/16 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/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 6,128.00 204,437.89 52.945 181,692.11 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 6,224.41 60.637 4,040.59 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 6,128.00 237,170.50 55.906 187,063.50 Program number: 422,945.00 424,234.00 6,128.00 237,170.50 55.906 187,063.50 Department number: Non Departmental 422,945.00 424,234.00 6,128.00 237,170.50 55.906 187,063.50 Expenditures Subtotal ----------- 8,047,784.00 8,609,567.00 561,142.88 4,617,151.45 53.628 3,992,415.55 Fund number: 135 MUD 1 General Fund 94,694.54 722,633.00 722,633.00- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 14:56 06/16/16 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 5/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 14:56 06/16/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 5/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 14:56 06/16/16 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 5/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 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/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 1661 05/02/2016 Property Taxes/Assessments (56,432.40) (55.09) (56,487.49) GL 1664 05/04/2016 Property Taxes/Assessments (7.08) (56,494.57) GL 1665 05/09/2016 Property Taxes/Assessments (4.35) (56,498.92) GL 1668 05/11/2016 Property Taxes/Assessments (32.58) (56,531.50) GL 1669 05/13/2016 Property Taxes/Assessments (10.00) (56,541.50) GL 1671 05/16/2016 Property Taxes/Assessments (3.81) (56,545.31) GL 1673 05/17/2016 Property Taxes/Assessments (9.32) (56,554.63) GL 1674 05/18/2016 Property Taxes/Assessments (16.72) (56,571.35) GL 1675 05/19/2016 Property Taxes/Assessments (13.66) (56,585.01) GL 1676 05/20/2016 Property Taxes/Assessments (19.10) (56,604.11) GL 1677 05/23/2016 Property Taxes/Assessments (6.05) (56,610.16) GL 1678 05/24/2016 Property Taxes/Assessments (10.15) (56,620.31) GL 1679 05/25/2016 Property Taxes/Assessments (24.28) (56,644.59) GL 1680 05/26/2016 Property Taxes/Assessments (6.64) (56,651.23) GL 1681 05/27/2016 Property Taxes/Assessments (11.47) (56,662.70) GL 1682 05/31/2016 Property Taxes/Assessments (9.08) (56,671.78) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (239.38) (56,671.78) ** (58,181.00) Budgeted (1,509.22) Remaining 97 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1663 05/03/2016 Property Taxes/Assessments (339.41) (831.30) (1,170.71) GL 1665 05/09/2016 Property Taxes/Assessments (27.35) (1,198.06) GL 1679 05/25/2016 Property Taxes/Assessments (73.78) (1,271.84) GL 1681 05/27/2016 Property Taxes/Assessments (.21) (1,272.05) GL 1682 05/31/2016 Property Taxes/Assessments (1.41) (1,273.46) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (934.05) (1,273.46) ** .00 Budgeted 1,273.46 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1661 05/02/2016 Property Taxes/Assessments (283.29) (3.84) (287.13) GL 1663 05/03/2016 Property Taxes/Assessments (182.50) (469.63) GL 1664 05/04/2016 Property Taxes/Assessments (.44) (470.07) GL 1665 05/09/2016 Property Taxes/Assessments (6.32) (476.39) GL 1668 05/11/2016 Property Taxes/Assessments (1.93) (478.32) GL 1674 05/18/2016 Property Taxes/Assessments (1.34) (479.66) GL 1675 05/19/2016 Property Taxes/Assessments (.49) (480.15) GL 1679 05/25/2016 Property Taxes/Assessments (9.46) (489.61) GL 1680 05/26/2016 Property Taxes/Assessments (.11) (489.72) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1681 05/27/2016 Property Taxes/Assessments (283.29) (.81) (490.53) GL 1682 05/31/2016 Property Taxes/Assessments (.96) (491.49) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (208.20) (491.49) ** (650.00) Budgeted (158.51) Remaining 76 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (146,125.00) Budgeted (146,125.00) Remaining 0 % Used Account: 135-47000-000-000 Water 1654 05/27/2016 UB 5/27/16 Peanlties UB20160527-20160527 User: (1,934,489.05) 12.71 (1,934,476.34) UB 1632 05/31/2016 UB 5/31/16 May Billing UB20160531-20160531 User: (272,528.49) (2,207,004.83) UB _______________ Account: 135-47000-000-000 Water Totals: (272,515.78) (2,207,004.83) ** (5,080,244.00) Budgeted (2,873,239.17) Remaining 43 % Used Account: 135-47005-000-000 Sewer 1654 05/27/2016 UB 5/27/16 Peanlties UB20160527-20160527 User: (1,195,113.82) 12.71 (1,195,101.11) UB 1632 05/31/2016 UB 5/31/16 May Billing UB20160531-20160531 User: (177,547.36) (1,372,648.47) UB _______________ Account: 135-47005-000-000 Sewer Totals: (177,534.65) (1,372,648.47) ** (2,413,776.00) Budgeted (1,041,127.53) Remaining 57 % Used Account: 135-47025-000-000 Penalties 1608 05/23/2016 UB 5/23/16 Penalties UB20160523-20160523 User: (61,488.04) (4,893.44) (66,381.48) UB 1654 05/27/2016 UB 5/27/16 Peanlties UB20160527-20160527 User: 103.43 (66,278.05) UB 1655 05/31/2016 UB 5/31/16 Penalty removals UB20160531-20160531 User: 192.39 (66,085.66) UB _______________ Account: 135-47025-000-000 Penalties Totals: (4,597.62) (66,085.66) ** (90,985.00) Budgeted (24,899.34) Remaining 73 % Used Account: 135-47030-000-000 Service Charges 1639 05/04/2016 UB 5/4/16 NSF Check fee UB20160504-20160504 User: (8,950.00) (25.00) (8,975.00) UB 1541 05/10/2016 Ub 5/10/16 Cut Off List UB20160510-20160510 User: (750.00) (9,725.00) UB 1644 05/12/2016 UB 5/12/16 NSF Check fee UB20160512-20160512 User: (25.00) (9,750.00) UB . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1646 05/13/2016 UB 5/13/16 NSF Check fee UB20160513-20160513 User: (8,950.00) (50.00) (9,800.00) UB 1650 05/23/2016 UB 5/23/16 NSCF Check fee UB20160523-20160523 User: (25.00) (9,825.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (875.00) (9,825.00) ** (9,000.00) Budgeted 825.00 Remaining 109 % Used Account: 135-47035-000-000 Plumbing Inspections 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (1,800.00) (150.00) (1,950.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (1,950.00) ** (2,000.00) Budgeted (50.00) Remaining 98 % Used Account: 135-47045-000-000 Sewer Inspections 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (5,250.00) (450.00) (5,700.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (5,700.00) ** (5,500.00) Budgeted 200.00 Remaining 104 % Used Account: 135-47070-000-000 TCCC Effluent Charges (11,746.00) .00 (11,746.00) _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (11,746.00) ** (61,330.00) Budgeted (49,584.00) Remaining 19 % 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 1696 05/31/2016 Bank Interest/May (7,135.52) (162.94) (7,298.46) GL 1696 05/31/2016 Bank Interest/May (331.18) (7,629.64) GL 1696 05/31/2016 Bank Interest/May (612.23) (8,241.87) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,106.35) (8,241.87) ** (10,000.00) Budgeted (1,758.13) Remaining 82 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/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-49016-000-000 Cell Tower Revenue 1710 05/10/2016 AT&T Cell Tower Revenue (6,373.71) (910.53) (7,284.24) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (7,284.24) ** (10,926.00) Budgeted (3,641.76) Remaining 67 % Used Account: 135-49018-000-000 Building Rent Income 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (4,083.31) (583.33) (4,666.64) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (4,666.64) ** (7,000.00) Budgeted (2,333.36) Remaining 67 % Used 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 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (39,159.42) (3,087.00) (42,246.42) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (3,087.00) (42,246.42) ** (15,778.00) Budgeted 26,468.42 Remaining 268 % 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 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1711 05/10/2016 Chitty/Camera Light Citation (1,236.38) (75.00) (1,311.38) GL 1712 05/12/2016 Lone Star Metals/Scrap Metal (3,172.24) (4,483.62) GL 1575 05/18/2016 May A/P Red Light Camera fee 75.00 (4,408.62) Haltom City Red Light 1892 AP 1632 05/31/2016 UB 5/31/16 May Billing UB20160531-20160531 User: (76.21) (4,484.83) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (3,248.45) (4,484.83) ** (63,249.00) Budgeted (58,764.17) Remaining 7 % Used Account: 135-49901-000-000 Records Management Revenue 1713 05/18/2016 Mayer/Open Records (20.40) (8.00) (28.40) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (8.00) (28.40) ** (20.00) Budgeted 8.40 Remaining 142 % Used Department Totals: ------------------------------------------------------------------------------------------------ (3,894,518.45) ** (8,609,567.00) Budgeted (4,715,048.55) Remaining 45 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 1503 05/06/2016 MUD Payroll 5/6/16 Salaries & Wages 117,579.65 8,385.45 125,965.10 PR 1565 05/20/2016 MUD Payroll 5/20/16 Salaries & Wages 8,385.45 134,350.55 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 16,770.90 134,350.55 ** 260,062.00 Budgeted 125,711.45 Remaining 52 % Used Account: 135-50010-010-000 Overtime 1503 05/06/2016 MUD Payroll 5/6/16 Overtime 7,417.28 1,175.54 8,592.82 PR 1565 05/20/2016 MUD Payroll 5/20/16 Overtime 496.56 9,089.38 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,672.10 9,089.38 ** 19,500.00 Budgeted 10,410.62 Remaining 47 % 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 1565 05/20/2016 MUD Payroll 5/20/16 Certification 1,325.00 200.00 1,525.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 1,525.00 ** 3,600.00 Budgeted 2,075.00 Remaining 42 % Used Account: 135-50020-010-000 Retirement 1503 05/06/2016 MUD Payroll 5/6/16 Retirement 11,390.11 834.66 12,224.77 PR 1565 05/20/2016 MUD Payroll 5/20/16 Retirement 792.87 13,017.64 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,627.53 13,017.64 ** 25,018.00 Budgeted 12,000.36 Remaining 52 % Used Account: 135-50026-010-000 Medical Insurance 1503 05/06/2016 MUD Payroll 5/6/16 Medical Insurance 21,620.91 1,580.60 23,201.51 PR 1565 05/20/2016 MUD Payroll 5/20/16 Medical Insurance 1,580.55 24,782.06 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,161.15 24,782.06 ** 51,398.00 Budgeted 26,615.94 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 1503 05/06/2016 MUD Payroll 5/6/16 Dental Insurance 1,620.87 120.39 1,741.26 PR 1565 05/20/2016 MUD Payroll 5/20/16 Dental Insurance 120.38 1,861.64 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 240.77 1,861.64 ** 3,999.00 Budgeted 2,137.36 Remaining 47 % Used Account: 135-50028-010-000 Vision Insurance 1503 05/06/2016 MUD Payroll 5/6/16 Vision Insurance 365.22 27.01 392.23 PR 1565 05/20/2016 MUD Payroll 5/20/16 Vision Insurance 26.97 419.20 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.98 419.20 ** 910.00 Budgeted 490.80 Remaining 46 % Used Account: 135-50029-010-000 Life Insurance & Other 1440 05/01/2016 May A/P May Dental, Vision & other ins 1,354.16 193.75 1,547.91 METLIFE GROUP BENEFITS 1852 AP 1670 05/31/2016 May A/P Café 125 Admin fee 9.71 1,557.62 BenefitMall 1930 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 203.46 1,557.62 ** 2,803.00 Budgeted 1,245.38 Remaining 56 % Used Account: 135-50030-010-000 Social Security Taxes 1503 05/06/2016 MUD Payroll 5/6/16 Social Security Taxes 7,951.24 589.71 8,540.95 PR 1565 05/20/2016 MUD Payroll 5/20/16 Social Security Taxes 556.07 9,097.02 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,145.78 9,097.02 ** 18,146.00 Budgeted 9,048.98 Remaining 50 % Used Account: 135-50035-010-000 Medicare Taxes 1503 05/06/2016 MUD Payroll 5/6/16 Medicare Taxes 1,859.54 137.92 1,997.46 PR 1565 05/20/2016 MUD Payroll 5/20/16 Medicare Taxes 130.05 2,127.51 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 267.97 2,127.51 ** 4,243.00 Budgeted 2,115.49 Remaining 50 % Used Account: 135-50040-010-000 Unemployment Taxes 1503 05/06/2016 MUD Payroll 5/6/16 Unemployment Taxes 847.29 11.77 859.06 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 11.77 859.06 ** 1,026.00 Budgeted 166.94 Remaining 84 % Used Account: 135-50045-010-000 Workman's Compensation 139 05/01/2016 Prepaid Insurance, W/C May 6,290.93 1,229.35 7,520.28 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,229.35 7,520.28 ** 14,754.00 Budgeted 7,233.72 Remaining 51 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 236.45 .00 236.45 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 236.45 ** 1,300.00 Budgeted 1,063.55 Remaining 18 % Used Account: 135-50070-010-000 Employee Relations 75.22 .00 75.22 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 75.22 ** 300.00 Budgeted 224.78 Remaining 25 % Used Account: 135-55005-010-000 Engineering 1725 05/31/2016 May A/P Town Hall Plan Review 29,985.60 1,462.50 31,448.10 CP&Y/WALLACE GROUP, INC. 1934 AP 1725 05/31/2016 May A/P Utility Mapping Trophy Club 9,972.50 41,420.60 CP&Y/WALLACE GROUP, INC. 1934 AP _______________ Account: 135-55005-010-000 Engineering Totals: 11,435.00 41,420.60 ** 109,400.00 Budgeted 67,979.40 Remaining 38 % Used Account: 135-55080-010-000 Maintenance & Repairs 1510 05/04/2016 May A/P A/C at Pump room 62,700.71 270.00 62,970.71 BRANDON R REED 1822 AP 1524 05/06/2016 May A/P Saddles 452.36 63,423.07 HD SUPPLY WATERWORKS, LTD. 1841 AP 1524 05/06/2016 May A/P hydrant parts 1,207.08 64,630.15 HD SUPPLY WATERWORKS, LTD. 1841 AP 1575 05/18/2016 May A/P Bolts, nuts, lugs,sleeve, glan 268.06 64,898.21 HD SUPPLY WATERWORKS, LTD. 1893 AP 1575 05/18/2016 May A/P T Bolts 181.05 65,079.26 HD SUPPLY WATERWORKS, LTD. 1893 AP 1575 05/18/2016 May A/P April mowing 750.00 65,829.26 WATTS ELLISON LLC 1910 AP 1719 05/26/2016 4/27/16-5/26/16 PCards THE HOME DEPOT 6581 38.14 65,867.40 THE HOME DEPOT 6581 PC 1670 05/31/2016 May A/P Well meter testing 600.00 66,467.40 GREAT SOUTHWEST METERS INC 1951 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1670 05/31/2016 May A/P May mowing 62,700.71 1,500.00 67,967.40 WATTS ELLISON LLC 2006 AP 1686 05/31/2016 May A/P Water Plant Generator repair 861.99 68,829.39 WORLDWIDE POWER PRODUCTS AP 1686 05/31/2016 May A/P Water Plant Generator repair 360.00 69,189.39 WORLDWIDE POWER PRODUCTS AP 1687 05/31/2016 Void Generator Inv.Wrong Dept Water Plant Generator repair (861.99) 68,327.40 WORLDWIDE POWER PRODUCTS AP 1688 05/31/2016 Void Generator Inv Wrong Dept Water Plant Generator repair (360.00) 67,967.40 WORLDWIDE POWER PRODUCTS AP 1725 05/31/2016 May A/P Meter Box keys 30.36 67,997.76 HD SUPPLY WATERWORKS, LTD. 1955 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 5,297.05 67,997.76 ** 99,500.00 Budgeted 31,502.24 Remaining 68 % Used Account: 135-55090-010-000 Vehicle Maintenance 1719 05/26/2016 4/27/16-5/26/16 PCards ROANOKE AUTO SUPPLY LT 2,983.93 46.26 3,030.19 ROANOKE AUTO SUPPLY LT PC 1719 05/26/2016 4/27/16-5/26/16 PCards DISCOUNT TIRE TXD 75 110.50 3,140.69 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 156.76 3,140.69 ** 8,000.00 Budgeted 4,859.31 Remaining 39 % 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 1575 05/18/2016 May A/P Water Samples/MUD 2,259.17 270.00 2,529.17 TARRANT CTY PUBLIC HEALTH LAB 1906 AP 1725 05/31/2016 May A/P TCEQ Samples/MUD 207.70 2,736.87 LOWER COLORADO RIVER AUTHORITY 1973 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 477.70 2,736.87 ** 5,500.00 Budgeted 2,763.13 Remaining 50 % Used Account: 135-60010-010-000 Communications/Mobiles 1575 05/18/2016 May A/P Cells/April 2,531.04 346.99 2,878.03 VERIZON WIRELESS 1909 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 346.99 2,878.03 ** 5,400.00 Budgeted 2,521.97 Remaining 53 % Used Account: 135-60020-010-000 Electricity 1670 05/31/2016 May A/P Electricity 4/8-5/9/16 68,764.78 189.54 68,954.32 HUDSON ENERGY SERVICES, LLC 1919 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1670 05/31/2016 May A/P Electricity 4/11-5/10/16 68,764.78 174.26 69,128.58 HUDSON ENERGY SERVICES, LLC 1919 AP 1670 05/31/2016 May A/P Electricity 4/11-5/10/16 9,444.41 78,572.99 HUDSON ENERGY SERVICES, LLC 1919 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,808.21 78,572.99 ** 166,823.00 Budgeted 88,250.01 Remaining 47 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % 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 1719 05/26/2016 4/27/16-5/26/16 PCards 360 WATER INC 1,238.00 30.00 1,268.00 360 WATER INC PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 30.00 1,268.00 ** 5,773.00 Budgeted 4,505.00 Remaining 22 % Used Account: 135-60090-010-000 Safety Program 248.97 .00 248.97 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 248.97 ** 400.00 Budgeted 151.03 Remaining 62 % Used Account: 135-60100-010-000 Travel & per diem 1565 05/20/2016 MUD Payroll 5/20/16 Travel & per diem 78.18 8.91 87.09 PR _______________ Account: 135-60100-010-000 Travel & per diem Totals: 8.91 87.09 ** 1,400.00 Budgeted 1,312.91 Remaining 6 % Used Account: 135-60105-010-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1670 05/31/2016 May A/P CDL Truck Rental 161.18 161.18 Ryder Transportation Services 1991 AP 1670 05/31/2016 May A/P CDL Truck Rental 163.46 324.64 Ryder Transportation Services 1991 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 324.64 324.64 ** 1,500.00 Budgeted 1,175.36 Remaining 22 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 1575 05/18/2016 May A/P Well Water 10,501.40 2,673.60 13,175.00 North Texas Groundwater 1899 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 2,673.60 13,175.00 ** 49,275.00 Budgeted 36,100.00 Remaining 27 % Used Account: 135-60150-010-000 Wholesale Water 1670 05/31/2016 May A/P Wholesale water 851,951.14 161,225.28 1,013,176.42 CITY OF FORT WORTH 1933 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 161,225.28 1,013,176.42 ** 2,948,742.00 Budgeted 1,935,565.58 Remaining 34 % 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 1719 05/26/2016 4/27/16-5/26/16 PCards TEX-TURF 2,199.64 44.00 2,243.64 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 44.00 2,243.64 ** 3,500.00 Budgeted 1,256.36 Remaining 64 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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-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 1719 05/26/2016 4/27/16-5/26/16 PCards FINISH LINE LUBE CENTE 8,195.50 39.45 8,234.95 FINISH LINE LUBE CENTE PC 1670 05/31/2016 May A/P Fuel 4/25-5/24/16 719.32 8,954.27 US Bank Voyager Fleet Systems 2004 AP 1720 05/31/2016 May A/P Fuel Rebate Adjustment 35.48 8,989.75 US Bank Voyager Fleet Systems 2004 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 794.25 8,989.75 ** 35,947.00 Budgeted 26,957.25 Remaining 25 % 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 1670 05/31/2016 May A/P Chlorine 7,838.77 529.71 8,368.48 DPC INDUSTRIES, INC 1940 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 529.71 8,368.48 ** 13,000.00 Budgeted 4,631.52 Remaining 64 % Used Account: 135-65035-010-000 Small Tools 129.55 .00 129.55 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 129.55 ** 1,200.00 Budgeted 1,070.45 Remaining 11 % Used Account: 135-65040-010-000 Safety Equipment 443.49 .00 443.49 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 443.49 ** 1,000.00 Budgeted 556.51 Remaining 44 % Used Account: 135-65050-010-000 Meter Expense . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1575 05/18/2016 May A/P 2 3" compound meters, Orion en 87,305.34 4,500.00 91,805.34 ATLAS UTILITY SUPPLY CO. 1885 AP 1575 05/18/2016 May A/P Badger 1 1/2" meter and endpoi 630.00 92,435.34 ATLAS UTILITY SUPPLY CO. 1885 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 5,130.00 92,435.34 ** 115,000.00 Budgeted 22,564.66 Remaining 80 % 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 1670 05/31/2016 May A/P Sealed bids/Ammonia System 319,871.38 657.24 320,528.62 STAR-TELEGRAM OPERATING LTD 1994 AP 1670 05/31/2016 May A/P Valve Replacements 13,639.10 334,167.72 REY-MAR CONSTRUCTION 1988 AP 1725 05/31/2016 May A/P Pin Oak/Pebble Beach/Timberlin 420.76 334,588.48 TEAGUE, NALL & PERKINS,INC 1997 AP 1725 05/31/2016 May A/P Ammonia System 5,027.50 339,615.98 CP&Y/WALLACE GROUP, INC. 1934 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 19,744.60 339,615.98 ** 400,250.00 Budgeted 60,634.02 Remaining 85 % Used Account: 135-69008-010-000 Short Term Debt-Principal 130,700.34 .00 130,700.34 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 130,700.34 ** 130,720.00 Budgeted 19.66 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt-Interest 1,177.54 .00 1,177.54 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 1,177.54 ** 1,209.00 Budgeted 31.46 Remaining 97 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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-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 1575 05/18/2016 May A/P Water samples/PID 821.55 80.00 901.55 TARRANT CTY PUBLIC HEALTH LAB 1906 AP 1725 05/31/2016 May A/P TCEQ Samples-PID 216.19 1,117.74 LOWER COLORADO RIVER AUTHORITY 1973 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 296.19 1,117.74 ** 5,000.00 Budgeted 3,882.26 Remaining 22 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,303,905.79 ** 4,814,884.00 Budgeted 2,510,978.21 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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 1503 05/06/2016 MUD Payroll 5/6/16 Salaries & Wages 196,250.43 14,421.65 210,672.08 PR 1565 05/20/2016 MUD Payroll 5/20/16 Salaries & Wages 14,421.65 225,093.73 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 28,843.30 225,093.73 ** 351,671.00 Budgeted 126,577.27 Remaining 64 % Used Account: 135-50010-020-000 Overtime 1503 05/06/2016 MUD Payroll 5/6/16 Overtime 19,754.25 1,891.23 21,645.48 PR 1565 05/20/2016 MUD Payroll 5/20/16 Overtime 1,102.55 22,748.03 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,993.78 22,748.03 ** 29,500.00 Budgeted 6,751.97 Remaining 77 % 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 1565 05/20/2016 MUD Payroll 5/20/16 Certification 4,225.00 625.00 4,850.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 625.00 4,850.00 ** 7,200.00 Budgeted 2,350.00 Remaining 67 % Used Account: 135-50020-020-000 Retirement 1503 05/06/2016 MUD Payroll 5/6/16 Retirement 19,936.27 1,424.14 21,360.41 PR 1565 05/20/2016 MUD Payroll 5/20/16 Retirement 1,409.81 22,770.22 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,833.95 22,770.22 ** 33,652.00 Budgeted 10,881.78 Remaining 68 % Used Account: 135-50026-020-000 Medical Insurance 1503 05/06/2016 MUD Payroll 5/6/16 Medical Insurance 36,264.69 2,765.99 39,030.68 PR 1565 05/20/2016 MUD Payroll 5/20/16 Medical Insurance 2,765.98 41,796.66 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,531.97 41,796.66 ** 65,989.00 Budgeted 24,192.34 Remaining 63 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 1503 05/06/2016 MUD Payroll 5/6/16 Dental Insurance 2,206.26 173.97 2,380.23 PR 1565 05/20/2016 MUD Payroll 5/20/16 Dental Insurance 173.94 2,554.17 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 347.91 2,554.17 ** 4,184.00 Budgeted 1,629.83 Remaining 61 % Used Account: 135-50028-020-000 Vision Insurance 1503 05/06/2016 MUD Payroll 5/6/16 Vision Insurance 500.85 39.05 539.90 PR 1565 05/20/2016 MUD Payroll 5/20/16 Vision Insurance 39.00 578.90 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 78.05 578.90 ** 972.00 Budgeted 393.10 Remaining 60 % Used Account: 135-50029-020-000 Life Insurance & Other 1440 05/01/2016 May A/P May Dental, Vision & other ins 2,338.02 328.74 2,666.76 METLIFE GROUP BENEFITS 1852 AP 1670 05/31/2016 May A/P Café 125 Admin fee 29.13 2,695.89 BenefitMall 1930 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 357.87 2,695.89 ** 3,655.00 Budgeted 959.11 Remaining 74 % Used Account: 135-50030-020-000 Social Security Taxes 1503 05/06/2016 MUD Payroll 5/6/16 Social Security Taxes 12,802.90 921.38 13,724.28 PR 1565 05/20/2016 MUD Payroll 5/20/16 Social Security Taxes 891.47 14,615.75 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,812.85 14,615.75 ** 24,665.00 Budgeted 10,049.25 Remaining 59 % Used Account: 135-50035-020-000 Medicare Taxes 1503 05/06/2016 MUD Payroll 5/6/16 Medicare Taxes 2,994.21 215.48 3,209.69 PR 1565 05/20/2016 MUD Payroll 5/20/16 Medicare Taxes 208.48 3,418.17 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 423.96 3,418.17 ** 5,768.00 Budgeted 2,349.83 Remaining 59 % Used Account: 135-50040-020-000 Unemployment Taxes 1,203.57 .00 1,203.57 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 1,203.57 ** 1,204.00 Budgeted .43 Remaining 100 % Used Account: 135-50045-020-000 Workman's Compensation 139 05/01/2016 Prepaid Insurance, W/C May 3,120.52 776.43 3,896.95 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 776.43 3,896.95 ** 9,317.00 Budgeted 5,420.05 Remaining 42 % 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 1719 05/26/2016 4/27/16-5/26/16 PCards SALAD BOWL 10 322.28 45.50 367.78 SALAD BOWL 10 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 45.50 367.78 ** 650.00 Budgeted 282.22 Remaining 57 % Used Account: 135-55070-020-000 Independent Labor 1685 05/31/2016 Recode Engineer Permit Renewal Recode Engineer Permit Renewal 3,905.00 3,905.00 GL 1685 05/31/2016 Recode Engineer Permit Renewal Recode Engineer Permit Renewal 16,085.00 19,990.00 GL 1725 05/31/2016 May A/P Flow meter modified settings 721.50 20,711.50 Prime Controls, LP 1985 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 20,711.50 20,711.50 ** 50,000.00 Budgeted 29,288.50 Remaining 41 % Used Account: 135-55080-020-000 Maintenance & Repairs 1575 05/18/2016 May A/P Lift Sta #1 pump pulled 66,019.98 720.00 66,739.98 NORTH TEXAS PUMP CO. 1900 AP 1575 05/18/2016 May A/P Repair plant LS not operating 525.00 67,264.98 DHS AUTOMATION, INC 1889 AP 1575 05/18/2016 May A/P April mowing 540.00 67,804.98 WATTS ELLISON LLC 1910 AP 1719 05/26/2016 4/27/16-5/26/16 PCards FERGUSON ENT #61 98.18 67,903.16 FERGUSON ENT #61 PC 1719 05/26/2016 4/27/16-5/26/16 PCards FEDEXOFFICE 00003319 72.18 67,975.34 FEDEXOFFICE 00003319 PC 1719 05/26/2016 4/27/16-5/26/16 PCards AIR MAC INC 1,620.00 69,595.34 AIR MAC INC PC 1719 05/26/2016 4/27/16-5/26/16 PCards THE HOME DEPOT 6581 53.06 69,648.40 THE HOME DEPOT 6581 PC . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1670 05/31/2016 May A/P May mowing 66,019.98 1,080.00 70,728.40 WATTS ELLISON LLC 2006 AP 1725 05/31/2016 May A/P L/S #3 pump repair 380.00 71,108.40 NORTH TEXAS PUMP CO. 1979 AP 1725 05/31/2016 May A/P L/S #8, Pump #2 taken to shop 562.75 71,671.15 NORTH TEXAS PUMP CO. 1979 AP 1725 05/31/2016 May A/P W.P. L/S pump repair 475.00 72,146.15 NORTH TEXAS PUMP CO. 1979 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 6,126.17 72,146.15 ** 83,100.00 Budgeted 10,953.85 Remaining 87 % Used Account: 135-55090-020-000 Vehicle Maintenance 1719 05/26/2016 4/27/16-5/26/16 PCards DISCOUNT TIRE TXD 75 4,202.33 385.00 4,587.33 DISCOUNT TIRE TXD 75 PC 1719 05/26/2016 4/27/16-5/26/16 PCards AUTOZONE #4206 25.00 4,612.33 AUTOZONE #4206 PC 1719 05/26/2016 4/27/16-5/26/16 PCards DISCOUNT TIRE TXD 75 189.50 4,801.83 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 599.50 4,801.83 ** 7,500.00 Budgeted 2,698.17 Remaining 64 % 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 1575 05/18/2016 May A/P Sludge haul off 21,959.88 327.86 22,287.74 L.H. CHANEY MATERIALS, INC. 1896 AP 1575 05/18/2016 May A/P Sludge Haul off 1,631.70 23,919.44 L.H. CHANEY MATERIALS, INC. 1896 AP 1725 05/31/2016 May A/P Sludge Haul off 1,009.35 24,928.79 L.H. CHANEY MATERIALS, INC. 1965 AP 1725 05/31/2016 May A/P Sludge Haul off 654.03 25,582.82 L.H. CHANEY MATERIALS, INC. 1965 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,622.94 25,582.82 ** 55,000.00 Budgeted 29,417.18 Remaining 47 % Used Account: 135-55135-020-000 Lab Analysis 1510 05/04/2016 May A/P Testing 24,124.40 246.00 24,370.40 OXIDOR LABORATORIES LLC 1858 AP 1510 05/04/2016 May A/P Testing 176.00 24,546.40 OXIDOR LABORATORIES LLC 1858 AP 1725 05/31/2016 May A/P Testing 246.00 24,792.40 OXIDOR LABORATORIES LLC 1982 AP 1725 05/31/2016 May A/P Testing 176.00 24,968.40 OXIDOR LABORATORIES LLC 1982 AP 1725 05/31/2016 May A/P Testing 246.00 25,214.40 OXIDOR LABORATORIES LLC 1982 AP 1725 05/31/2016 May A/P Testing 176.00 25,390.40 OXIDOR LABORATORIES LLC 1982 AP 1725 05/31/2016 May A/P Testing 246.00 25,636.40 OXIDOR LABORATORIES LLC 1982 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1725 05/31/2016 May A/P Testing 24,124.40 176.00 25,812.40 OXIDOR LABORATORIES LLC 1982 AP 1725 05/31/2016 May A/P Testing 246.00 26,058.40 OXIDOR LABORATORIES LLC 1982 AP 1725 05/31/2016 May A/P Testing 176.00 26,234.40 OXIDOR LABORATORIES LLC 1982 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,110.00 26,234.40 ** 35,000.00 Budgeted 8,765.60 Remaining 75 % Used Account: 135-60010-020-000 Communications/Mobiles 1575 05/18/2016 May A/P Cells/April 3,280.05 406.84 3,686.89 VERIZON WIRELESS 1909 AP 1719 05/26/2016 4/27/16-5/26/16 PCards PHONETECH & REPAIR 140.73 3,827.62 PHONETECH & REPAIR PC _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 547.57 3,827.62 ** 5,400.00 Budgeted 1,572.38 Remaining 71 % Used Account: 135-60020-020-000 Electricity 1575 05/18/2016 May A/P Electricity 3/29-4/27/16 58,988.58 195.75 59,184.33 TRI COUNTY ELECTRIC 1908 AP 1575 05/18/2016 May A/P Electricity 3/29-4/27/16 27.81 59,212.14 TRI COUNTY ELECTRIC 1908 AP 1575 05/18/2016 May A/P Electricity 3/29-4/27/16 342.06 59,554.20 TRI COUNTY ELECTRIC 1908 AP 1670 05/31/2016 May A/P Electricity 4/8-5/9/16 133.94 59,688.14 HUDSON ENERGY SERVICES, LLC 1919 AP 1670 05/31/2016 May A/P Electricity 4/8-5/9/16 111.78 59,799.92 HUDSON ENERGY SERVICES, LLC 1919 AP 1670 05/31/2016 May A/P Electricity 4/11-5/10/16 198.92 59,998.84 HUDSON ENERGY SERVICES, LLC 1919 AP 1670 05/31/2016 May A/P Electricity 4/11-5/10/16 9,574.56 69,573.40 HUDSON ENERGY SERVICES, LLC 1919 AP 1670 05/31/2016 May A/P Electricity 4/11-5/10/16 545.66 70,119.06 HUDSON ENERGY SERVICES, LLC 1919 AP 1670 05/31/2016 May A/P Electricity 4/11-5/10/16 270.26 70,389.32 MP2 ENERGY TEXAS LLC 1977 AP 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (179.41) 70,209.91 AR 1725 05/31/2016 May A/P Electricity 4/27-5/25/16 186.96 70,396.87 TRI COUNTY ELECTRIC 2001 AP 1725 05/31/2016 May A/P Electricity 4/27-5/25/16 27.75 70,424.62 TRI COUNTY ELECTRIC 2001 AP 1725 05/31/2016 May A/P Electricity 4/27-5/25/16 320.87 70,745.49 TRI COUNTY ELECTRIC 2001 AP _______________ Account: 135-60020-020-000 Electricity Totals: 11,756.91 70,745.49 ** 161,582.00 Budgeted 90,836.51 Remaining 44 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 200.00 .00 200.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 200.00 ** 300.00 Budgeted 100.00 Remaining 67 % Used Account: 135-60080-020-000 Schools & Training 2,353.00 .00 2,353.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 2,353.00 ** 3,771.00 Budgeted 1,418.00 Remaining 62 % Used Account: 135-60090-020-000 Safety Program 296.67 .00 296.67 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 296.67 ** 550.00 Budgeted 253.33 Remaining 54 % Used Account: 135-60100-020-000 Travel & per diem 1719 05/26/2016 4/27/16-5/26/16 PCards BABE'S-ARLINGTON LLC 658.70 41.92 700.62 BABE'S-ARLINGTON LLC PC 1719 05/26/2016 4/27/16-5/26/16 PCards PAPPADEAUX SEAFOOD KIT 44.17 744.79 PAPPADEAUX SEAFOOD KIT PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 86.09 744.79 ** 1,600.00 Budgeted 855.21 Remaining 47 % Used Account: 135-60105-020-000 Rent/Lease Equipment 1725 05/31/2016 May A/P Rental 4/22-5/22 RAW #1 3,238.50 1,350.00 4,588.50 NORTH TEXAS PUMP CO. 1979 AP _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: 1,350.00 4,588.50 ** 9,000.00 Budgeted 4,411.50 Remaining 51 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 1685 05/31/2016 Recode Engineer Permit Renewal Recode Engineer Permit Renewal 34,568.74 (3,905.00) 30,663.74 GL 1685 05/31/2016 Recode Engineer Permit Renewal Recode Engineer Permit Renewal (16,085.00) 14,578.74 GL _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: (19,990.00) 14,578.74 ** 37,150.00 Budgeted 22,571.26 Remaining 39 % Used Account: 135-60245-020-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1568 05/18/2016 May A/P Processing fee/Encroachment 14 173.24 250.00 423.24 Oncor Electric Delivery 1883 AP 1570 05/18/2016 Void A/P Check 1883 Processing fee/Encroachment 14 (250.00) 173.24 Oncor Electric Delivery 1883 AP 1571 05/18/2016 May A/P Processing fee/Encroachment 14 250.00 423.24 Oncor Electric Delivery 1884 AP _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: 250.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 1593 05/02/2016 Texpool Transfers O&M xfer to Tax I&S 39,902.00 19,951.00 59,853.00 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 19,951.00 59,853.00 ** 119,706.00 Budgeted 59,853.00 Remaining 50 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1593 05/02/2016 Texpool Transfers Transfer to Rev Bond I&S 271,956.24 43,220.32 315,176.56 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 43,220.32 315,176.56 ** 444,831.00 Budgeted 129,654.44 Remaining 71 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 92,502.00 .00 92,502.00 _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: .00 92,502.00 ** 123,336.00 Budgeted 30,834.00 Remaining 75 % Used Account: 135-65005-020-000 Fuel & Lube 1670 05/31/2016 May A/P Fuel 4/25-5/24/16 6,530.50 599.25 7,129.75 US Bank Voyager Fleet Systems 2004 AP 1720 05/31/2016 May A/P Fuel Rebate Adjustment 29.58 7,159.33 US Bank Voyager Fleet Systems 2004 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 628.83 7,159.33 ** 32,021.00 Budgeted 24,861.67 Remaining 22 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65010-020-000 Uniforms 1719 05/26/2016 4/27/16-5/26/16 PCards ACADEMY SPORTS #76 2,503.53 119.99 2,623.52 ACADEMY SPORTS #76 PC _______________ Account: 135-65010-020-000 Uniforms Totals: 119.99 2,623.52 ** 4,241.00 Budgeted 1,617.48 Remaining 62 % Used Account: 135-65030-020-000 Chemicals 1725 05/31/2016 May A/P 2 Drums/Clarifloc 17,698.25 1,080.00 18,778.25 POLYDYNE, INC 1984 AP 1725 05/31/2016 May A/P Freestyle Calc Hypochlorite 2,405.00 21,183.25 HARCROS CHEMICALS INC 1952 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 3,485.00 21,183.25 ** 27,000.00 Budgeted 5,816.75 Remaining 78 % Used Account: 135-65035-020-000 Small Tools 371.89 .00 371.89 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 371.89 ** 2,000.00 Budgeted 1,628.11 Remaining 19 % 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 1719 05/26/2016 4/27/16-5/26/16 PCards BED BATH & BEYOND #341 11,198.43 39.98 11,238.41 BED BATH & BEYOND #341 PC 1719 05/26/2016 4/27/16-5/26/16 PCards HACH COMPANY 153.44 11,391.85 HACH COMPANY PC 1719 05/26/2016 4/27/16-5/26/16 PCards HACH COMPANY 816.77 12,208.62 HACH COMPANY PC 1725 05/31/2016 May A/P E Coli Quanti Trays 633.47 12,842.09 IDEXX DISTRIBUTION, INC 1959 AP 1725 05/31/2016 May A/P Nitrile Exam Grade Gloves 162.00 13,004.09 LOU'S GLOVES INCORPORATED 1972 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,805.66 13,004.09 ** 13,000.00 Budgeted (4.09) Remaining 100 % Used Account: 135-69005-020-000 Capital Outlays 1575 05/18/2016 May A/P Final pmt/LS 3 & 5 Scada upgra 170,102.28 9,000.00 179,102.28 DHS AUTOMATION, INC 1889 AP 1575 05/18/2016 May A/P 24" Aerial Crossing 90,345.00 269,447.28 REY-MAR CONSTRUCTION 1903 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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-69005-020-000 Capital Outlays Totals: 99,345.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,403,850.33 ** 2,140,864.00 Budgeted 737,013.67 Remaining 66 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/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 1565 05/20/2016 MUD Payroll 5/20/16 Salaries & Wages 4,700.00 500.00 5,200.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 500.00 5,200.00 ** 12,500.00 Budgeted 7,300.00 Remaining 42 % Used Account: 135-50030-026-000 Social Security Taxes 1565 05/20/2016 MUD Payroll 5/20/16 Social Security Taxes 291.40 31.00 322.40 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 31.00 322.40 ** 775.00 Budgeted 452.60 Remaining 42 % Used Account: 135-50035-026-000 Medicare Taxes 1565 05/20/2016 MUD Payroll 5/20/16 Medicare Taxes 68.15 7.25 75.40 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 7.25 75.40 ** 181.00 Budgeted 105.60 Remaining 42 % Used Account: 135-50040-026-000 Unemployment Taxes 35.70 .00 35.70 _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .00 35.70 ** 12.00 Budgeted (23.70) Remaining 298 % Used Account: 135-50045-026-000 Workman's Compensation 139 05/01/2016 Prepaid Insurance, W/C May 34.57 3.08 37.65 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 3.08 37.65 ** 50.00 Budgeted 12.35 Remaining 75 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 10.98 .00 10.98 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 10.98 ** 500.00 Budgeted 489.02 Remaining 2 % Used Account: 135-60075-026-000 Meetings 21.67 .00 21.67 _______________ Account: 135-60075-026-000 Meetings Totals: .00 21.67 ** 1,200.00 Budgeted 1,178.33 Remaining 2 % Used Account: 135-60080-026-000 Schools & Training 905.00 .00 905.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 905.00 ** 4,000.00 Budgeted 3,095.00 Remaining 23 % Used Account: 135-60100-026-000 Travel & per diem 1,602.43 .00 1,602.43 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 1,602.43 ** 5,000.00 Budgeted 3,397.57 Remaining 32 % Used Account: 135-60245-026-000 Miscellaneous Expenses 1719 05/26/2016 4/27/16-5/26/16 PCards KELLER TROPHY AND AWAR 50.48 169.40 219.88 KELLER TROPHY AND AWAR PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 169.40 219.88 ** 2,000.00 Budgeted 1,780.12 Remaining 11 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 8,431.11 ** 26,368.00 Budgeted 17,936.89 Remaining 32 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 1503 05/06/2016 MUD Payroll 5/6/16 Salaries & Wages 265,173.76 18,903.75 284,077.51 PR 1565 05/20/2016 MUD Payroll 5/20/16 Salaries & Wages 18,877.36 302,954.87 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 37,781.11 302,954.87 ** 493,633.00 Budgeted 190,678.13 Remaining 61 % Used Account: 135-50010-030-000 Overtime 1503 05/06/2016 MUD Payroll 5/6/16 Overtime 371.80 14.77 386.57 PR 1565 05/20/2016 MUD Payroll 5/20/16 Overtime 96.42 482.99 PR _______________ Account: 135-50010-030-000 Overtime Totals: 111.19 482.99 ** 500.00 Budgeted 17.01 Remaining 97 % 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 1503 05/06/2016 MUD Payroll 5/6/16 Retirement 23,730.77 1,651.58 25,382.35 PR 1565 05/20/2016 MUD Payroll 5/20/16 Retirement 1,656.43 27,038.78 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,308.01 27,038.78 ** 43,652.00 Budgeted 16,613.22 Remaining 62 % Used Account: 135-50026-030-000 Medical Insurance 1503 05/06/2016 MUD Payroll 5/6/16 Medical Insurance 35,906.51 2,655.37 38,561.88 PR 1565 05/20/2016 MUD Payroll 5/20/16 Medical Insurance 2,655.35 41,217.23 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 5,310.72 41,217.23 ** 68,196.00 Budgeted 26,978.77 Remaining 60 % Used Account: 135-50027-030-000 Dental Insurance 1503 05/06/2016 MUD Payroll 5/6/16 Dental Insurance 2,462.99 189.41 2,652.40 PR 1565 05/20/2016 MUD Payroll 5/20/16 Dental Insurance 189.38 2,841.78 PR . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 Totals: 378.79 2,841.78 ** 4,807.00 Budgeted 1,965.22 Remaining 59 % Used Account: 135-50028-030-000 Vision Insurance 1503 05/06/2016 MUD Payroll 5/6/16 Vision Insurance 568.19 43.60 611.79 PR 1565 05/20/2016 MUD Payroll 5/20/16 Vision Insurance 43.54 655.33 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 87.14 655.33 ** 1,114.00 Budgeted 458.67 Remaining 59 % Used Account: 135-50029-030-000 Life Insurance & Other 1440 05/01/2016 May A/P May Dental, Vision & other ins 2,718.78 372.69 3,091.47 METLIFE GROUP BENEFITS 1852 AP 1670 05/31/2016 May A/P Rounding adjustment (.02) 3,091.45 Legal Shield 1966 AP 1670 05/31/2016 May A/P Café 125 Admin fee 29.16 3,120.61 BenefitMall 1930 AP 1755 05/31/2016 Rounding Adj (.02) 3,120.59 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 401.81 3,120.59 ** 5,431.00 Budgeted 2,310.41 Remaining 57 % Used Account: 135-50030-030-000 Social Security Taxes 1503 05/06/2016 MUD Payroll 5/6/16 Social Security Taxes 15,558.19 1,086.05 16,644.24 PR 1565 05/20/2016 MUD Payroll 5/20/16 Social Security Taxes 1,077.21 17,721.45 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,163.26 17,721.45 ** 31,141.00 Budgeted 13,419.55 Remaining 57 % Used Account: 135-50035-030-000 Medicare Taxes 1503 05/06/2016 MUD Payroll 5/6/16 Medicare Taxes 3,638.59 254.02 3,892.61 PR 1565 05/20/2016 MUD Payroll 5/20/16 Medicare Taxes 251.91 4,144.52 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 505.93 4,144.52 ** 7,678.00 Budgeted 3,533.48 Remaining 54 % Used Account: 135-50040-030-000 Unemployment Taxes 1503 05/06/2016 MUD Payroll 5/6/16 Unemployment Taxes 1,195.77 1.23 1,197.00 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 1.23 1,197.00 ** 1,197.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 139 05/01/2016 Prepaid Insurance, W/C May 1,327.23 147.89 1,475.12 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 147.89 1,475.12 ** 1,554.00 Budgeted 78.88 Remaining 95 % 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 1719 05/26/2016 4/27/16-5/26/16 PCards RANDALLS STORE00017897 2,986.92 42.94 3,029.86 RANDALLS STORE00017897 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 42.94 3,029.86 ** 4,500.00 Budgeted 1,470.14 Remaining 67 % Used Account: 135-55030-030-000 Software & Support 1575 05/18/2016 May A/P Internet 34,145.93 1,101.17 35,247.10 WHOLESALE CARRIER SERVICES INC 1911 AP 1719 05/26/2016 4/27/16-5/26/16 PCards ATT*BILL PAYMENT 150.14 35,397.24 ATT*BILL PAYMENT PC 1719 05/26/2016 4/27/16-5/26/16 PCards ATT*BILL PAYMENT 166.46 35,563.70 ATT*BILL PAYMENT PC 1725 05/31/2016 May A/P Maint Agreement Time/Developme 343.75 35,907.45 FOUR MAN FURNACE, INC. 1944 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 1,761.52 35,907.45 ** 81,097.00 Budgeted 45,189.55 Remaining 44 % Used Account: 135-55070-030-000 Independent Labor 1575 05/18/2016 May A/P Record MUD meeting 1,019.38 90.00 1,109.38 KATHRYN BAUSWELL 1894 AP 1670 05/31/2016 May A/P Record MUD meeting 30.00 1,139.38 MIGUEL CRUZ 1976 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 120.00 1,139.38 ** 12,000.00 Budgeted 10,860.62 Remaining 9 % Used Account: 135-55080-030-000 Maintenance & Repairs 1575 05/18/2016 May A/P Thermostats off in office 5,968.35 120.00 6,088.35 BRANDON R REED 1886 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 120.00 6,088.35 ** 7,000.00 Budgeted 911.65 Remaining 87 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55100-030-000 Building Maint & Supplies 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: 4,457.81 (130.89) 4,326.92 AR 1725 05/31/2016 May A/P Rug Service/MUD & PS Bldgs 130.89 4,457.81 G & K SERVICES 1946 AP 1725 05/31/2016 May A/P Rug Service/MUD & PS Bldgs 130.89 4,588.70 G & K SERVICES 1946 AP 1725 05/31/2016 May A/P Check charge on generator 360.00 4,948.70 WORLDWIDE POWER PRODUCTS 2007 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 490.89 4,948.70 ** 7,000.00 Budgeted 2,051.30 Remaining 71 % Used Account: 135-55120-030-000 Cleaning Services 1575 05/18/2016 May A/P April Janitorial Service 3,249.50 843.75 4,093.25 MEMBER'S BUILDING MAINTENANCE 1897 AP 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (259.00) 3,834.25 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 584.75 3,834.25 ** 10,125.00 Budgeted 6,290.75 Remaining 38 % Used Account: 135-55160-030-000 Professional Outside Services 53,072.50 .00 53,072.50 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 53,072.50 ** 72,575.00 Budgeted 19,502.50 Remaining 73 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 1575 05/18/2016 May A/P April billing with inserts 3,776.17 1,186.04 4,962.21 DATAPROSE LLC 1888 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,186.04 4,962.21 ** 8,200.00 Budgeted 3,237.79 Remaining 61 % Used Account: 135-60005-030-000 Telephone 1719 05/26/2016 4/27/16-5/26/16 PCards RINGCENTRAL, INC 8,453.33 10.73 8,464.06 RINGCENTRAL, INC PC 1719 05/26/2016 4/27/16-5/26/16 PCards ATT*BUS PHONE PMT 432.64 8,896.70 ATT*BUS PHONE PMT PC 1670 05/31/2016 May A/P Answering service 195.07 9,091.77 KEYSTONE PARK SECRETARIAL 1963 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60005-030-000 Telephone Totals: 638.44 9,091.77 ** 16,349.00 Budgeted 7,257.23 Remaining 56 % Used Account: 135-60010-030-000 Communications/Mobiles 1575 05/18/2016 May A/P Cells/April 2,463.34 37.99 2,501.33 VERIZON WIRELESS 1909 AP 1565 05/20/2016 MUD Payroll 5/20/16 Communications/Mobiles 300.00 2,801.33 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 337.99 2,801.33 ** 4,150.00 Budgeted 1,348.67 Remaining 68 % Used Account: 135-60020-030-000 Electricity/Gas 1670 05/31/2016 May A/P Charter, CareNow, Gexa, Verizo 3,711.28 949.82 4,661.10 TOWN OF TROPHY CLUB 2000 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 949.82 4,661.10 ** 10,768.00 Budgeted 6,106.90 Remaining 43 % Used Account: 135-60025-030-000 Water 1670 05/31/2016 May A/P May Water 516.07 120.98 637.05 TROPHY CLUB MUD (WATER BILLS) 2002 AP 1721 05/31/2016 Town A/R Billing Inv 1460-1470 AR 20160531-20160531 User: (60.49) 576.56 AR _______________ Account: 135-60025-030-000 Water Totals: 60.49 576.56 ** 1,500.00 Budgeted 923.44 Remaining 38 % Used Account: 135-60035-030-000 Postage 1575 05/18/2016 May A/P Overnight letters 13,990.10 11.10 14,001.20 FEDERAL EXPRESS CORP 1891 AP 1575 05/18/2016 May A/P Overnight letter 7.33 14,008.53 FEDERAL EXPRESS CORP 1891 AP 1575 05/18/2016 May A/P April billing with inserts 1,780.12 15,788.65 DATAPROSE LLC 1888 AP 1670 05/31/2016 May A/P Overnight letter 7.75 15,796.40 FEDERAL EXPRESS CORP 1942 AP 1720 05/31/2016 May A/P Overnight letter 5.55 15,801.95 FEDERAL EXPRESS CORP 1942 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,811.85 15,801.95 ** 28,932.00 Budgeted 13,130.05 Remaining 55 % Used Account: 135-60040-030-000 Service Charges & Fees 1526 05/03/2016 Credit card fees March 34,246.61 2,989.30 37,235.91 GL 1526 05/03/2016 Credit card fees March 43.62 37,279.53 GL 1508 05/06/2016 Child support fee 5/6/16 P/R 1.50 37,281.03 GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1524 05/06/2016 May A/P Direct send fees/March 34,246.61 50.00 37,331.03 Fiserv Solutions, LLC 1835 AP 1566 05/20/2016 Child Support fee 5/20/16 P/R 1.50 37,332.53 GL 1670 05/31/2016 May A/P April Direct send fees 50.00 37,382.53 Fiserv Solutions, LLC 1943 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,135.92 37,382.53 ** 55,560.00 Budgeted 18,177.47 Remaining 67 % Used Account: 135-60050-030-000 Bad Debt Expense 2,015.35 .00 2,015.35 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 2,015.35 ** 3,500.00 Budgeted 1,484.65 Remaining 58 % Used Account: 135-60055-030-000 Insurance 139 05/01/2016 Prepaid Insurance, W/C May 19,593.00 2,756.00 22,349.00 GL _______________ Account: 135-60055-030-000 Insurance Totals: 2,756.00 22,349.00 ** 52,797.00 Budgeted 30,448.00 Remaining 42 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 260.00 .00 260.00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 260.00 ** 1,600.00 Budgeted 1,340.00 Remaining 16 % Used Account: 135-60070-030-000 Dues & Memberships 1670 05/31/2016 May A/P Assoc Membership Renew/McKnigh 5,006.25 300.00 5,306.25 TX MUNICIPAL LEAGUE 2003 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 300.00 5,306.25 ** 6,000.00 Budgeted 693.75 Remaining 88 % Used Account: 135-60075-030-000 Meetings 29.00 .00 29.00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 29.00 ** 400.00 Budgeted 371.00 Remaining 7 % Used Account: 135-60079-030-000 Public Education . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 1719 05/26/2016 4/27/16-5/26/16 PCards 360 WATER INC 3,292.00 90.00 3,382.00 360 WATER INC PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 90.00 3,382.00 ** 9,935.00 Budgeted 6,553.00 Remaining 34 % Used Account: 135-60100-030-000 Travel & per diem 1503 05/06/2016 MUD Payroll 5/6/16 Travel & per diem 2,698.46 77.93 2,776.39 PR 1719 05/26/2016 4/27/16-5/26/16 PCards ZEDS RESTAURANT 27.82 2,804.21 ZEDS RESTAURANT PC 1719 05/26/2016 4/27/16-5/26/16 PCards STARBUCKS #02832 HILLS 1.89 2,806.10 STARBUCKS #02832 HILLS PC 1719 05/26/2016 4/27/16-5/26/16 PCards STARBUCKS #14860 GEORG 2.17 2,808.27 STARBUCKS #14860 GEORG PC _______________ Account: 135-60100-030-000 Travel & per diem Totals: 109.81 2,808.27 ** 5,400.00 Budgeted 2,591.73 Remaining 52 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 1670 05/31/2016 May A/P Election Advertisement 1,060.02 131.90 1,191.92 DENTON PUBLISHING CO 1938 AP 1670 05/31/2016 May A/P May Election 2,018.49 3,210.41 DENTON COUNTY ELECTIONS 1937 AP _______________ Account: 135-60115-030-000 Elections Totals: 2,150.39 3,210.41 ** 7,500.00 Budgeted 4,289.59 Remaining 43 % Used Account: 135-60125-030-000 Advertising 61.74 .00 61.74 _______________ Account: 135-60125-030-000 Advertising Totals: .00 61.74 ** 7,500.00 Budgeted 7,438.26 Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 1575 05/18/2016 May A/P net.Watering Hotline Phone lin 5,117.05 86.25 5,203.30 MERCURY COMMUNICATION SERVICES 1898 AP 1719 05/26/2016 4/27/16-5/26/16 PCards TCEQ EPAYMENT 36.60 5,239.90 TCEQ EPAYMENT PC 1719 05/26/2016 4/27/16-5/26/16 PCards TCEQ EPAYMENT 36.60 5,276.50 TCEQ EPAYMENT PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 159.45 5,276.50 ** 17,501.00 Budgeted 12,224.50 Remaining 30 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 656.38 .00 656.38 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 656.38 ** 2,500.00 Budgeted 1,843.62 Remaining 26 % Used Account: 135-65010-030-000 Uniforms 23.00 .00 23.00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 23.00 ** 1,855.00 Budgeted 1,832.00 Remaining 1 % Used Account: 135-65055-030-000 Hardware 5,871.85 .00 5,871.85 _______________ 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 1575 05/18/2016 May A/P Office supplies 3,498.54 61.96 3,560.50 OFFICE DEPOT, INC 1901 AP 1575 05/18/2016 May A/P Ink Cartridge 36.80 3,597.30 OFFICE DEPOT, INC 1901 AP 1719 05/26/2016 4/27/16-5/26/16 PCards OFFICE DEPOT #406 49.94 3,647.24 OFFICE DEPOT #406 PC 1719 05/26/2016 4/27/16-5/26/16 PCards AMER ASSOC NOTARIESWE 33.90 3,681.14 AMER ASSOC NOTARIESWE PC 1725 05/31/2016 May A/P Office supplies 71.87 3,753.01 OFFICE DEPOT, INC 1980 AP . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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-65085-030-000 Office Supplies Totals: 254.47 3,753.01 ** 9,000.00 Budgeted 5,246.99 Remaining 42 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 406.44 .00 406.44 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 406.44 ** 4,003.00 Budgeted 3,596.56 Remaining 10 % Used Account: 135-65095-030-000 Maintenance Supplies 1719 05/26/2016 4/27/16-5/26/16 PCards AMAZON.COM 2,153.97 29.30 2,183.27 AMAZON.COM PC 1719 05/26/2016 4/27/16-5/26/16 PCards SAMS CLUB #4795 193.65 2,376.92 SAMS CLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 222.95 2,376.92 ** 5,000.00 Budgeted 2,623.08 Remaining 48 % Used Account: 135-65105-030-000 Printing 1,348.88 .00 1,348.88 _______________ Account: 135-65105-030-000 Printing Totals: .00 1,348.88 ** 4,800.00 Budgeted 3,451.12 Remaining 28 % Used Account: 135-69005-030-000 Capital Outlays 1575 05/18/2016 May A/P Restroom Renovations 7,005.50 685.00 7,690.50 CP&Y/WALLACE GROUP, INC. 1887 AP 1670 05/31/2016 May A/P RFP Electronic Mgmt System 570.40 8,260.90 STAR-TELEGRAM OPERATING LTD 1994 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 1,255.40 8,260.90 ** 56,000.00 Budgeted 47,739.10 Remaining 15 % Used Account: 135-69170-030-000 Copier Lease Installments 1575 05/18/2016 May A/P Copier payment 1,934.13 165.00 2,099.13 EVERBANK COMMERCIAL FINANCE 1890 AP 1670 05/31/2016 May A/P Adm Kyocera copies 98.25 2,197.38 KYOCERA DOCUMENT SOLUTIONS 1964 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 263.25 2,197.38 ** 4,600.00 Budgeted 2,402.62 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 30 Totals: ------------------------------------------------------------------------------------------------ 663,793.72 ** 1,203,217.00 Budgeted 539,423.28 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/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 1683 05/31/2016 May A/P April Legal/General 198,309.89 4,155.50 202,465.39 THE LISTON LAW FIRM, P.C. 1998 AP 1683 05/31/2016 May A/P April Legal/PUC Rate Challenge 766.50 203,231.89 THE LISTON LAW FIRM, P.C. 1998 AP 1683 05/31/2016 May A/P April Legal/TCEQ Notice of Enf 726.00 203,957.89 THE LISTON LAW FIRM, P.C. 1998 AP 1683 05/31/2016 May A/P April Legal/WWTP-WCP Contract 90.00 204,047.89 THE LISTON LAW FIRM, P.C. 1998 AP 1683 05/31/2016 May A/P April Legal/FW Waterline 60.00 204,107.89 THE LISTON LAW FIRM, P.C. 1998 AP 1686 05/31/2016 May A/P May Legal/TCEQ Enforcement 330.00 204,437.89 FREEMAN & CORBETT 1945 AP _______________ Account: 135-55045-039-000 Legal Totals: 6,128.00 204,437.89 ** 386,130.00 Budgeted 181,692.11 Remaining 53 % 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 6,224.41 .00 6,224.41 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 6,224.41 ** 10,265.00 Budgeted 4,040.59 Remaining 61 % 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: ------------------------------------------------------------------------------------------------ 237,170.50 ** 424,234.00 Budgeted 187,063.50 Remaining 56 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 722,633.00 .00 Budgeted (722,633.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 5/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 51 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 5/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 52 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 5/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 MAY 2016 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 4,385,757 ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,385,757 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,378,563 NET REVENUES / EXPENDITURES 7,194 TOTAL FUND BALANCE 4,385,757 TOTAL LIABILITIES AND FUND BALANCE 4,385,757 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 14:56 06/16/16 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,265.58- 7,193.63- 7,193.63 Subtotal: 1,265.58- 7,193.63- 7,193.63 Program number: 1,265.58- 7,193.63- 7,193.63 Department number: Revenues 1,265.58- 7,193.63- 7,193.63 Revenues Subtotal ----------- 1,265.58- 7,193.63- 7,193.63 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,265.58- 7,193.63- 7,193.63 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/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 1696 05/31/2016 Bank Interest/May (5,928.05) (1,265.58) (7,193.63) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,265.58) (7,193.63) ** .00 Budgeted 7,193.63 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (7,193.63) ** .00 Budgeted 7,193.63 Remaining 0 % Used Fund 517 Totals: ------------------------------------------------------------------------------------------------------ (7,193.63) .00 Budgeted 7,193.63 Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET MAY 2016 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS 5,693,656 ACCOUNTS RECEIVABLE - TOTAL ASSETS 5,693,656 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 1,680,330 TOTAL LIABILITIES 1,680,330 FUND BALANCE ASSIGNED FUND BALANCE 8,334,104 NET REVENUES / EXPENDITURES (4,320,778) TOTAL FUND BALANCE 4,013,326 TOTAL LIABILITIES AND FUND BALANCE 5,693,656 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 14:56 06/16/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 5/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 1,685.01- 12,101.50- 12,101.50 Subtotal: 1,685.01- 12,101.50- 12,101.50 Program number: 1,685.01- 12,101.50- 12,101.50 Department number: Revenues 1,685.01- 12,101.50- 12,101.50 Revenues Subtotal ----------- 1,685.01- 12,101.50- 12,101.50 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 14:56 06/16/16 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 5/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 1,903,561.45 4,332,879.49 4,332,879.49- Subtotal: 1,903,561.45 4,332,879.49 4,332,879.49- Program number: 1,903,561.45 4,332,879.49 4,332,879.49- Department number: Wastewater 1,903,561.45 4,332,879.49 4,332,879.49- Expenditures Subtotal ----------- 1,903,561.45 4,332,879.49 4,332,879.49- Fund number: 518 2015 Revenue Bond Const Fund 1,901,876.44 4,320,777.99 4,320,777.99- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 5/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 1696 05/31/2016 Bank Interest/May (10,416.49) (1,685.01) (12,101.50) GL _______________ Account: 518-49010-000-000 Interest Income Totals: (1,685.01) (12,101.50) ** .00 Budgeted 12,101.50 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (12,101.50) ** .00 Budgeted 12,101.50 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 55 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 5/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 1534 05/09/2016 May A/P WWTP Upgrade APP 7 2,429,318.04 506,167.71 2,935,485.75 WEBBER-CADAGUA PARTNERS 1882 AP 1536 05/09/2016 Webber Cadauga App 7 Retainage 56,240.85 2,991,726.60 GL 1748 05/25/2016 WWTP Webber Retainage App 8 129,408.84 3,121,135.44 GL 1725 05/31/2016 May A/P WWTP Improvements 47,064.50 3,168,199.94 CP&Y/WALLACE GROUP, INC. 1934 AP 1746 05/31/2016 May A/P WWTP App #8 1,164,679.55 4,332,879.49 WEBBER-CADAGUA PARTNERS 2008 AP _______________ Account: 518-69005-020-000 Capital Outlays Totals: 1,903,561.45 4,332,879.49 ** .00 Budgeted (4,332,879.49) Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 4,332,879.49 ** .00 Budgeted (4,332,879.49) Remaining 0 % Used Fund 518 Totals: ------------------------------------------------------------------------------------------------------ 4,320,777.99 .00 Budgeted (4,320,777.99) Remaining 0 % Used TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET MAY 2016 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 164,698 ACCOUNTS RECEIVABLE - TOTAL ASSETS 164,698 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 71,962 NET REVENUES / EXPENDITURES 92,736 TOTAL FUND BALANCE 164,698 TOTAL LIABILITIES AND FUND BALANCE 164,698 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 14:56 06/16/16 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 47.54- 233.88- 233.88 528-49141-000-000 Interfund Transfer In-Gen Fund 123,336.00- 123,336.00- 92,502.00- 75.000 30,834.00- Subtotal: 123,336.00- 123,336.00- 47.54- 92,735.88- 75.190 30,600.12- Program number: 123,336.00- 123,336.00- 47.54- 92,735.88- 75.190 30,600.12- Department number: 123,336.00- 123,336.00- 47.54- 92,735.88- 75.190 30,600.12- Revenues Subtotal ----------- 123,336.00- 123,336.00- 47.54- 92,735.88- 75.190 30,600.12- Fund number: 528 2015 Revenue Bond Reserve Fund 123,336.00- 123,336.00- 47.54- 92,735.88- 75.190 30,600.12- . glpdatb2 rgonzale Trophy Club MUD No.1 Page 56 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/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 1696 05/31/2016 Bank Interest/May (186.34) (47.54) (233.88) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (47.54) (233.88) ** .00 Budgeted 233.88 Remaining 0 % Used Account: 528-49141-000-000 Interfund Transfer In-Gen Fund (92,502.00) .00 (92,502.00) _______________ Account: 528-49141-000-000 Interfund Transfer In-Gen Fund Totals: .00 (92,502.00) ** (123,336.00) Budgeted (30,834.00) Remaining 75 % Used Department Totals: ------------------------------------------------------------------------------------------------ (92,735.88) ** (123,336.00) Budgeted (30,600.12) Remaining 75 % Used Fund 528 Totals: ------------------------------------------------------------------------------------------------------ (92,735.88) (123,336.00) Budgeted (30,600.12) Remaining 75 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET MAY 2016 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 792,588 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 21,974 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 819,408 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 21,974 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 21,974 FUND BALANCE ASSIGNED FUND BALANCE 24,173 NET REVENUES / EXPENDITURES 773,261 TOTAL FUND BALANCE 797,434 TOTAL LIABILITIES AND FUND BALANCE 819,408 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 14:56 06/16/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2016 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 667,898.00- 667,898.00- 2,748.66- 650,765.28- 97.435 17,132.72- 533-40002-000-000 Property Taxes/Delinquent 2,300.00- 2,300.00- 3,624.34- 4,779.68- 207.812 2,479.68 533-40015-000-000 Property Taxes/P & I 1,800.00- 1,800.00- 862.40- 2,474.90- 137.494 674.90 Subtotal: 671,998.00- 671,998.00- 7,235.40- 658,019.86- 97.920 13,978.14- 533-49010-000-000 Interest Income 140.00- 140.00- 227.42- 950.88- 679.200 810.88 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- 59,853.00- 50.000 59,853.00- Subtotal: 334,225.00- 334,225.00- 20,178.42- 275,182.88- 82.335 59,042.12- Program number: 1,006,223.00- 1,006,223.00- 27,413.82- 933,202.74- 92.743 73,020.26- Department number: Revenues 1,006,223.00- 1,006,223.00- 27,413.82- 933,202.74- 92.743 73,020.26- Revenues Subtotal ----------- 1,006,223.00- 1,006,223.00- 27,413.82- 933,202.74- 92.743 73,020.26- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 14:56 06/16/16 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/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- 27,413.82- 773,261.49- ############### 771,571.49 . glpdatb2 rgonzale Trophy Club MUD No.1 Page 57 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/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 1661 05/02/2016 Property Taxes/Assessments (648,016.62) (632.56) (648,649.18) GL 1664 05/04/2016 Property Taxes/Assessments (81.24) (648,730.42) GL 1665 05/09/2016 Property Taxes/Assessments (49.99) (648,780.41) GL 1668 05/11/2016 Property Taxes/Assessments (374.07) (649,154.48) GL 1669 05/13/2016 Property Taxes/Assessments (114.86) (649,269.34) GL 1671 05/16/2016 Property Taxes/Assessments (43.73) (649,313.07) GL 1673 05/17/2016 Property Taxes/Assessments (106.98) (649,420.05) GL 1674 05/18/2016 Property Taxes/Assessments (191.94) (649,611.99) GL 1675 05/19/2016 Property Taxes/Assessments (156.83) (649,768.82) GL 1676 05/20/2016 Property Taxes/Assessments (219.33) (649,988.15) GL 1677 05/23/2016 Property Taxes/Assessments (69.45) (650,057.60) GL 1678 05/24/2016 Property Taxes/Assessments (116.61) (650,174.21) GL 1679 05/25/2016 Property Taxes/Assessments (278.86) (650,453.07) GL 1680 05/26/2016 Property Taxes/Assessments (76.27) (650,529.34) GL 1681 05/27/2016 Property Taxes/Assessments (131.65) (650,660.99) GL 1682 05/31/2016 Property Taxes/Assessments (104.29) (650,765.28) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (2,748.66) (650,765.28) ** (667,898.00) Budgeted (17,132.72) Remaining 97 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1663 05/03/2016 Property Taxes/Assessments (1,155.34) (3,301.97) (4,457.31) GL 1665 05/09/2016 Property Taxes/Assessments (82.47) (4,539.78) GL 1679 05/25/2016 Property Taxes/Assessments (230.93) (4,770.71) GL 1681 05/27/2016 Property Taxes/Assessments (5.06) (4,775.77) GL 1682 05/31/2016 Property Taxes/Assessments (3.91) (4,779.68) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (3,624.34) (4,779.68) ** (2,300.00) Budgeted 2,479.68 Remaining 208 % Used Account: 533-40015-000-000 Property Taxes/P & I 1661 05/02/2016 Property Taxes/Assessments (1,612.50) (44.16) (1,656.66) GL 1663 05/03/2016 Property Taxes/Assessments (699.70) (2,356.36) GL 1664 05/04/2016 Property Taxes/Assessments (5.16) (2,361.52) GL 1665 05/09/2016 Property Taxes/Assessments (21.72) (2,383.24) GL 1668 05/11/2016 Property Taxes/Assessments (9.53) (2,392.77) GL 1674 05/18/2016 Property Taxes/Assessments (15.42) (2,408.19) GL 1675 05/19/2016 Property Taxes/Assessments (5.66) (2,413.85) GL 1679 05/25/2016 Property Taxes/Assessments (35.40) (2,449.25) GL 1680 05/26/2016 Property Taxes/Assessments (1.26) (2,450.51) GL . glpdatb2 rgonzale Trophy Club MUD No.1 Page 58 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2016 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1681 05/27/2016 Property Taxes/Assessments (1,612.50) (16.44) (2,466.95) GL 1682 05/31/2016 Property Taxes/Assessments (7.95) (2,474.90) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (862.40) (2,474.90) ** (1,800.00) Budgeted 674.90 Remaining 137 % Used Account: 533-49010-000-000 Interest Income 1696 05/31/2016 Bank Interest/May (723.46) (227.42) (950.88) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (227.42) (950.88) ** (140.00) Budgeted 810.88 Remaining 679 % 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 1593 05/02/2016 Texpool Transfers O&M xfer to Tax I&S (39,902.00) (19,951.00) (59,853.00) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (19,951.00) (59,853.00) ** (119,706.00) Budgeted (59,853.00) Remaining 50 % Used Department Totals: ------------------------------------------------------------------------------------------------ (933,202.74) ** (1,006,223.00) Budgeted (73,020.26) Remaining 93 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 59 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/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: ------------------------------------------------------------------------------------------------------ (773,261.49) (1,690.00) Budgeted 771,571.49 Remaining ########## TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET MAY 2016 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 212,809 ACCOUNTS RECEIVABLE - TOTAL ASSETS 212,809 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,068 NET REVENUES / EXPENDITURES 197,741 TOTAL FUND BALANCE 212,809 TOTAL LIABILITIES AND FUND BALANCE 212,809 . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 14:56 06/16/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/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- 60.67- 182.48- 2,606.857 175.48 534-49143-000-000 Interfund Transfer In-WW Sales 444,831.00- 444,831.00- 43,220.32- 315,176.56- 70.853 129,654.44- Subtotal: 444,838.00- 444,838.00- 43,280.99- 315,359.04- 70.893 129,478.96- Program number: 444,838.00- 444,838.00- 43,280.99- 315,359.04- 70.893 129,478.96- Department number: Revenues 444,838.00- 444,838.00- 43,280.99- 315,359.04- 70.893 129,478.96- Revenues Subtotal ----------- 444,838.00- 444,838.00- 43,280.99- 315,359.04- 70.893 129,478.96- . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 14:56 06/16/16 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/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,280.99- 197,740.29- 197,740.29 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD No.1 Page 60 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/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 1696 05/31/2016 Bank Interest/May (121.81) (60.67) (182.48) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (60.67) (182.48) ** (7.00) Budgeted 175.48 Remaining 2.607 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1593 05/02/2016 Texpool Transfers Transfer to Rev Bond I&S (271,956.24) (43,220.32) (315,176.56) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (43,220.32) (315,176.56) ** (444,831.00) Budgeted (129,654.44) Remaining 71 % Used Department Totals: ------------------------------------------------------------------------------------------------ (315,359.04) ** (444,838.00) Budgeted (129,478.96) Remaining 71 % Used . glpdatb2 rgonzale Trophy Club MUD No.1 Page 61 14:57 06/16/16 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/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: ------------------------------------------------------------------------------------------------------ (197,740.29) .00 Budgeted 197,740.29 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 3,471,095.02 **** (125,026.00) Budgeted (3,596,121.02) Remaining ########## ******* End of Report *********