Loading...
HomeMy WebLinkAboutAugust Combined FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET AUGUST 2014 122 ASSETS FIRE DEPT. INVESTMENTS 674,420 PREPAID EXPENSES 1,672 ADVALOREM PROPERTY TAXES RECEIVABLE 18,060 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 8,450 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,042 TOTAL ASSETS 704,644 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 26,511 ACCOUNTS AND OTHER PAYABLES 43,368 TOTAL LIABILITIES 69,879 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 495,688 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 139,078 TOTAL FUND BALANCE 634,766 TOTAL LIABILITIES AND FUND BALANCE 704,644 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 16:40 09/09/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000- Assessment - Emerg Svcs 305,445.00- 305,445.00- 309,752.79- 101.410 4,307.79 122-40003-000- Emer Svcs Assessmen/Delinquent 1,581.21- 1,581.21 122-40010-000- Property Taxes/MUD Fire 927,555.00- 927,555.00- 695.87- 921,398.14- 99.336 6,156.86- 122-40011-000- Property Taxes/Fire-Delinquent 1.75- 1,346.42- 1,346.42 122-40015-000- Property Taxes/Assessments P&I 750.00- 750.00- 738.58- 98.477 11.42- 122-40020-000- Property Taxes/Fire P&I 4,500.00- 4,500.00- 138.87- 5,407.43- 120.165 907.43 Subtotal: 1,238,250.00- 1,238,250.00- 836.49- 1,240,224.57- 100.159 1,974.57 122-42014-000- Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 5,200.00- 86.667 800.00- Subtotal: 6,000.00- 6,000.00- 400.00- 5,200.00- 86.667 800.00- 122-43400-000- Fire Inspections 700.00- 700.00- 900.00- 128.571 200.00 122-43415-000- Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,700.00- 10,700.00- 10,900.00- 101.869 200.00 122-49900-000- Miscellaneous Income 6,000.00- 6,000.00- 880.00- 8,255.00- 137.583 2,255.00 Subtotal: 6,000.00- 6,000.00- 880.00- 8,255.00- 137.583 2,255.00 Program number: 1,260,950.00- 1,260,950.00- 2,116.49- 1,264,579.57- 100.288 3,629.57 Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 2,116.49- 1,264,579.57- 100.288 3,629.57 Revenues Subtotal ----- 1,260,950.00- 1,260,950.00- 2,116.49- 1,264,579.57- 100.288 3,629.57 . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 16:40 09/09/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045- Salaries & Wages 455,916.00 455,916.00 53,100.97 415,830.38 91.208 40,085.62 122-50010-045- Overtime 44,225.00 44,225.00 7,460.25 37,401.31 84.571 6,823.69 122-50011-045- DPS Holiday Pay 13,529.00 13,529.00 13,289.86 98.232 239.14 122-50016-045- Longevity 4,768.00 4,768.00 4,655.00 97.630 113.00 122-50017-045- Certification 4,350.00 4,350.00 425.00 4,164.39 95.733 185.61 122-50020-045- Retirement 70,991.00 70,991.00 8,855.43 67,774.03 95.468 3,216.97 122-50026-045- Medical Insurance 56,968.00 56,968.00 4,316.40 46,091.08 80.907 10,876.92 122-50027-045- Dental Insurance 4,230.00 4,230.00 352.83 3,761.73 88.930 468.27 122-50028-045- Vision Insurance 892.00 892.00 69.52 763.31 85.573 128.69 122-50029-045- Life Insurance & Other 4,250.00 4,250.00 326.55 3,502.02 82.400 747.98 122-50030-045- Social Security Taxes 32,980.00 32,980.00 3,569.04 27,251.07 82.629 5,728.93 122-50035-045- Medicare Taxes 7,713.00 7,713.00 834.47 6,371.54 82.608 1,341.46 122-50040-045- Unemployment Taxes 2,259.00 2,259.00 18.03 1,633.97 72.332 625.03 122-50045-045- Workman's Compensation 8,708.00 8,708.00 662.78 7,290.64 83.723 1,417.36 122-50060-045- Pre-employment Physicals/Test 500.00 500.00 205.72 41.144 294.28 122-50075-045- Tuition Reimbursement 600.00 600.00 600.00 Subtotal: 712,879.00 712,879.00 79,991.27 639,986.05 89.775 72,892.95 122-55030-045- Software & Support 8,682.00 6,834.00 462.50 462.50 6.768 6,371.50 122-55045-045- Legal 5,000.00 3,391.00 2,505.51- -73.887 5,896.51 122-55080-045- Maintenance & Repairs 20,472.00 20,472.00 867.63 16,485.43 80.527 3,986.57 122-55090-045- Vehicle Maintenance 14,850.00 14,850.00 4,355.39 11,708.04 78.842 3,141.96 Subtotal: 49,004.00 45,547.00 5,685.52 26,150.46 57.414 19,396.54 122-60005-045- Telephone 100.00 100.00 5.74 31.97 31.970 68.03 122-60010-045- Communications/Pagers/Mobiles 4,237.00 4,237.00 221.40 3,872.82 91.405 364.18 122-60020-045- Electricity/Gas 6,568.00 9,268.00 624.90 6,426.45 69.340 2,841.55 122-60025-045- Water 1,500.00 1,500.00 241.48 1,010.37 67.358 489.63 122-60030-045- Rent And/Or Usage 214,279.00 214,279.00 214,279.00 100.000 122-60035-045- Postage 100.00 100.00 53.51 53.510 46.49 122-60055-045- Insurance 12,110.00 12,110.00 1,009.25 11,143.75 92.021 966.25 122-60066-045- Publications/Books/Subscrips 400.00 400.00 112.75 28.188 287.25 122-60070-045- Dues & Memberships 15,180.00 15,180.00 7,675.00 16,086.64 105.973 906.64- 122-60080-045- Schools & Training 4,280.00 4,280.00 85.00 4,652.01 108.692 372.01- 122-60096-045- Emergency Management 2,000.00 2,000.00 1,608.70 80.435 391.30 122-60100-045- Travel & per diem 4,577.00 4,577.00 500.00 2,990.18 65.331 1,586.82 122-60110-045- Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045- Advertising 200.00 200.00 200.00- 122-60160-045- Programs & Special Projects 4,500.00 4,500.00 1,215.03 2,686.53 59.701 1,813.47 122-60180-045- Fire Inspection/Enforcement 1,500.00 1,500.00 383.45 632.45 42.163 867.55 122-60195-045- Flags & Repair 2,000.00 2,000.00 1,587.12 79.356 412.88 122-60243-045- Prior Year Expense 3,457.00 3,456.54 99.987 .46 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 16:40 09/09/14 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045- Miscellaneous Expense 1,000.00 1,000.00 609.93 857.90 85.790 142.10 Subtotal: 276,531.00 282,488.00 12,571.18 271,688.69 96.177 10,799.31 122-65005-045- Fuel & Lube 11,698.00 10,198.00 821.29 7,813.28 76.616 2,384.72 122-65010-045- Uniforms 3,360.00 3,360.00 123.00 3,101.74 92.314 258.26 122-65015-045- Protective Clothing 7,600.00 7,600.00 1,869.00 7,822.77 102.931 222.77- 122-65030-045- Chemicals 1,000.00 500.00 420.00 84.000 80.00 122-65035-045- Small Tools 2,500.00 2,500.00 10.90 705.21 28.208 1,794.79 122-65085-045- Office Supplies 1,000.00 500.00 233.22 46.644 266.78 122-65105-045- Printing 100.00 100.00 100.00 Subtotal: 27,258.00 24,758.00 2,824.19 20,096.22 81.171 4,661.78 122-69008-045- Short Term Debt-Principal 70,000.00 70,000.00 70,000.00 70,000.00 100.000 122-69009-045- Short Term Debt-Interest 3,031.00 3,031.00 1,515.50 3,031.00 100.000 122-69050-045- Radios 34,200.00 34,200.00 32,693.40 95.595 1,506.60 122-69195-045- GASB34/Reserve for Replacement 67,647.00 67,647.00 41,890.00 61.924 25,757.00 122-69255-045- Airpacks 20,400.00 20,400.00 19,965.59 97.871 434.41 Subtotal: 195,278.00 195,278.00 71,515.50 167,579.99 85.816 27,698.01 Program number: 1,260,950.00 1,260,950.00 172,587.66 1,125,501.41 89.258 135,448.59 Department number: Fire 1,260,950.00 1,260,950.00 172,587.66 1,125,501.41 89.258 135,448.59 Expenditures Subtotal ----- 1,260,950.00 1,260,950.00 172,587.66 1,125,501.41 89.258 135,448.59 Fund number: 122 Trophy Club MUD Fire Dept. 170,471.17 139,078.16- 139,078.16 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/2014 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 (309,752.79) .00 (309,752.79) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (309,752.79) ** (305,445.00) Budgeted 4,307.79 Remaining 101 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (1,581.21) .00 (1,581.21) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (1,581.21) ** .00 Budgeted 1,581.21 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 2024 08/01/2014 Property Taxes/Assessments (920,702.27) (119.20) (920,821.47) GL 2025 08/05/2014 Property Taxes/Assessments (178.79) (921,000.26) GL 2026 08/08/2014 Property Taxes/Assessments (5.83) (921,006.09) GL 2027 08/18/2014 Property Taxes/Assessments (12.77) (921,018.86) GL 2028 08/19/2014 Property Taxes/Assessments (295.67) (921,314.53) GL 2029 08/21/2014 Property Taxes/Assessments (52.78) (921,367.31) GL 2030 08/22/2014 Property Taxes/Assessments (30.83) (921,398.14) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (695.87) (921,398.14) ** (927,555.00) Budgeted (6,156.86) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 2027 08/18/2014 Property Taxes/Assessments (1,344.67) (1.75) (1,346.42) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (1.75) (1,346.42) ** .00 Budgeted 1,346.42 Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I (738.58) .00 (738.58) _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 (738.58) ** (750.00) Budgeted (11.42) Remaining 98 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 2025 08/05/2014 Property Taxes/Assessments (5,268.56) (55.22) (5,323.78) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2026 08/08/2014 Property Taxes/Assessments (5,268.56) (.99) (5,324.77) GL 2027 08/18/2014 Property Taxes/Assessments (14.29) (5,339.06) GL 2028 08/19/2014 Property Taxes/Assessments (56.19) (5,395.25) GL 2029 08/21/2014 Property Taxes/Assessments (10.03) (5,405.28) GL 2030 08/22/2014 Property Taxes/Assessments (2.15) (5,407.43) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (138.87) (5,407.43) ** (4,500.00) Budgeted 907.43 Remaining 120 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (4,800.00) (400.00) (5,200.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (5,200.00) ** (6,000.00) Budgeted (800.00) Remaining 87 % Used Account: 122-43400-000-000 Fire Inspections (900.00) .00 (900.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 (900.00) ** (700.00) Budgeted 200.00 Remaining 129 % 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-49900-000-000 Miscellaneous Income 2018 08/29/2014 FD Records Request (7,375.00) (5.00) (7,380.00) GL 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (875.00) (8,255.00) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (880.00) (8,255.00) ** (6,000.00) Budgeted 2,255.00 Remaining 138 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,264,579.57) ** (1,260,950.00) Budgeted 3,629.57 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2014 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 1803 08/01/2014 FD Payroll 8/1/14 362,729.41 18,034.67 380,764.08 GL 1937 08/15/2014 FD Payroll 8/15/14 17,751.08 398,515.16 GL 2041 08/29/2014 FD Payroll 8/29/14 17,315.22 415,830.38 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 53,100.97 415,830.38 ** 455,916.00 Budgeted 40,085.62 Remaining 91 % Used Account: 122-50010-045-000 Overtime 1803 08/01/2014 FD Payroll 8/1/14 29,941.06 4,182.96 34,124.02 GL 2041 08/29/2014 FD Payroll 8/29/14 3,277.29 37,401.31 GL _______________ Account: 122-50010-045-000 Overtime Totals: 7,460.25 37,401.31 ** 44,225.00 Budgeted 6,823.69 Remaining 85 % Used Account: 122-50011-045-000 DPS Holiday Pay 13,289.86 .00 13,289.86 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,289.86 ** 13,529.00 Budgeted 239.14 Remaining 98 % Used Account: 122-50016-045-000 Longevity 4,655.00 .00 4,655.00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,655.00 ** 4,768.00 Budgeted 113.00 Remaining 98 % Used Account: 122-50017-045-000 Certification 1803 08/01/2014 FD Payroll 8/1/14 3,739.39 400.00 4,139.39 GL 2041 08/29/2014 FD Payroll 8/29/14 25.00 4,164.39 GL _______________ Account: 122-50017-045-000 Certification Totals: 425.00 4,164.39 ** 4,350.00 Budgeted 185.61 Remaining 96 % Used Account: 122-50020-045-000 Retirement 1803 08/01/2014 FD Payroll 8/1/14 58,918.60 3,280.93 62,199.53 GL 1937 08/15/2014 FD Payroll 8/15/14 2,587.64 64,787.17 GL 2041 08/29/2014 FD Payroll 8/29/14 2,986.86 67,774.03 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50020-045-000 Retirement Totals: 8,855.43 67,774.03 ** 70,991.00 Budgeted 3,216.97 Remaining 95 % Used Account: 122-50026-045-000 Medical Insurance 1803 08/01/2014 FD Payroll 8/1/14 41,774.68 2,488.42 44,263.10 GL 1937 08/15/2014 FD Payroll 8/15/14 1,827.98 46,091.08 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,316.40 46,091.08 ** 56,968.00 Budgeted 10,876.92 Remaining 81 % Used Account: 122-50027-045-000 Dental Insurance 1803 08/01/2014 FD Payroll 8/1/14 3,408.90 176.40 3,585.30 GL 1937 08/15/2014 FD Payroll 8/15/14 176.43 3,761.73 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 352.83 3,761.73 ** 4,230.00 Budgeted 468.27 Remaining 89 % Used Account: 122-50028-045-000 Vision Insurance 1803 08/01/2014 FD Payroll 8/1/14 693.79 34.72 728.51 GL 1937 08/15/2014 FD Payroll 8/15/14 34.80 763.31 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 69.52 763.31 ** 892.00 Budgeted 128.69 Remaining 86 % Used Account: 122-50029-045-000 Life Insurance & Other 1803 08/01/2014 FD Payroll 8/1/14 3,175.47 163.21 3,338.68 GL 1937 08/15/2014 FD Payroll 8/15/14 163.34 3,502.02 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 326.55 3,502.02 ** 4,250.00 Budgeted 747.98 Remaining 82 % Used Account: 122-50030-045-000 Social Security Taxes 1803 08/01/2014 FD Payroll 8/1/14 23,682.03 1,296.25 24,978.28 GL 1937 08/15/2014 FD Payroll 8/15/14 994.60 25,972.88 GL 2041 08/29/2014 FD Payroll 8/29/14 1,278.19 27,251.07 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 3,569.04 27,251.07 ** 32,980.00 Budgeted 5,728.93 Remaining 83 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50035-045-000 Medicare Taxes 1803 08/01/2014 FD Payroll 8/1/14 5,537.07 303.04 5,840.11 GL 1937 08/15/2014 FD Payroll 8/15/14 232.57 6,072.68 GL 2041 08/29/2014 FD Payroll 8/29/14 298.86 6,371.54 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 834.47 6,371.54 ** 7,713.00 Budgeted 1,341.46 Remaining 83 % Used Account: 122-50040-045-000 Unemployment Taxes 1803 08/01/2014 FD Payroll 8/1/14 1,615.94 7.19 1,623.13 GL 1937 08/15/2014 FD Payroll 8/15/14 3.67 1,626.80 GL 2041 08/29/2014 FD Payroll 8/29/14 7.17 1,633.97 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 18.03 1,633.97 ** 2,259.00 Budgeted 625.03 Remaining 72 % Used Account: 122-50045-045-000 Workman's Compensation 126 08/01/2014 FD Aug W/C expense 6,627.86 662.78 7,290.64 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.78 7,290.64 ** 8,708.00 Budgeted 1,417.36 Remaining 84 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 205.72 .00 205.72 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 205.72 ** 500.00 Budgeted 294.28 Remaining 41 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Account: 122-55030-045-000 Software & Support 1972 08/27/2014 Aug A/P Shi, Charter, Verizon 462.50 462.50 TOWN OF TROPHY CLUB 34158 AP _______________ Account: 122-55030-045-000 Software & Support Totals: 462.50 462.50 ** 6,834.00 Budgeted 6,371.50 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55045-045-000 Legal (2,505.51) .00 (2,505.51) _______________ Account: 122-55045-045-000 Legal Totals: .00 (2,505.51) ** 3,391.00 Budgeted 5,896.51 Remaining -74 % Used Account: 122-55080-045-000 Maintenance & Repairs 1926 08/15/2014 Aug Firefighter Cable 15,617.80 (133.82) 15,483.98 GL 1944 08/19/2014 Aug A/P Rug Service 24.51 15,508.49 G & K SERVICES 34084 AP 1944 08/19/2014 Aug A/P Rug Service 24.51 15,533.00 G & K SERVICES 34084 AP 2037 08/26/2014 7/29-8/26/14 PCards SAMS CLUB #8268 47.26 15,580.26 SAMS CLUB #8268 PC 2037 08/26/2014 7/29-8/26/14 PCards ATT*BILL PAYMENT 158.76 15,739.02 ATT*BILL PAYMENT PC 2037 08/26/2014 7/29-8/26/14 PCards ATT*BILL PAYMENT 128.82 15,867.84 ATT*BILL PAYMENT PC 2037 08/26/2014 7/29-8/26/14 PCards IMC-BATTERY SPEC 21.07 15,888.91 IMC-BATTERY SPEC PC 2037 08/26/2014 7/29-8/26/14 PCards SAMS CLUB #4795 433.57 16,322.48 SAMS CLUB #4795 PC 1972 08/27/2014 Aug A/P Ganns, Gexa, Shi, Nevill 140.00 16,462.48 TOWN OF TROPHY CLUB 34158 AP 1972 08/27/2014 Aug A/P Reimb for Sam's/Walmart purcha 47.46 16,509.94 Kari Schultz 34096 AP 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (24.51) 16,485.43 AR _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 867.63 16,485.43 ** 20,472.00 Budgeted 3,986.57 Remaining 81 % Used Account: 122-55090-045-000 Vehicle Maintenance 2037 08/26/2014 7/29-8/26/14 PCards KWIK KAR LUBE & TUNE O 7,352.65 216.23 7,568.88 KWIK KAR LUBE & TUNE O PC 2037 08/26/2014 7/29-8/26/14 PCards AUTOZONE #4206 581.95 8,150.83 AUTOZONE #4206 PC 2037 08/26/2014 7/29-8/26/14 PCards PRO TIRE INC 197.50 8,348.33 PRO TIRE INC PC 2065 08/31/2014 Aug A/P 2007 Pier Arrow/Pumper Major P 3,359.71 11,708.04 SIDDONS-MARTIN EMERGENCY GROUP 34149 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 4,355.39 11,708.04 ** 14,850.00 Budgeted 3,141.96 Remaining 79 % Used Account: 122-60005-045-000 Telephone 1944 08/19/2014 Aug A/P BOA PCards-IT 26.23 5.74 31.97 TOWN OF TROPHY CLUB 34088 AP _______________ Account: 122-60005-045-000 Telephone Totals: 5.74 31.97 ** 100.00 Budgeted 68.03 Remaining 32 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1803 08/01/2014 FD Payroll 8/1/14 3,651.42 75.00 3,726.42 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1972 08/27/2014 Aug A/P Shi, Charter, Verizon 3,651.42 146.40 3,872.82 TOWN OF TROPHY CLUB 34158 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 221.40 3,872.82 ** 4,237.00 Budgeted 364.18 Remaining 91 % Used Account: 122-60020-045-000 Electricity/Gas 1944 08/19/2014 Aug A/P Electricity 7/15/14-8/13/14 5,801.55 1,170.83 6,972.38 HUDSON ENERGY SERVICES, LLC 34085 AP 1972 08/27/2014 Aug A/P Gas/Fire Station 7/18-8/19/14 78.96 7,051.34 ATMOS ENERGY 34107 AP 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (624.89) 6,426.45 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 624.90 6,426.45 ** 9,268.00 Budgeted 2,841.55 Remaining 69 % Used Account: 122-60025-045-000 Water 1972 08/27/2014 Aug A/P Balance due July water 768.89 77.77 846.66 TROPHY CLUB MUD (WATER BILLS) 34103 AP 1972 08/27/2014 Aug A/P Balance due July water 45.86 892.52 TROPHY CLUB MUD (WATER BILLS) 34103 AP 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (117.86) 774.66 AR 2056 08/31/2014 Aug A/P August Water 152.78 927.44 TROPHY CLUB MUD (WATER BILLS) 34160 AP 2056 08/31/2014 Aug A/P August Water 82.93 1,010.37 TROPHY CLUB MUD (WATER BILLS) 34160 AP _______________ Account: 122-60025-045-000 Water Totals: 241.48 1,010.37 ** 1,500.00 Budgeted 489.63 Remaining 67 % Used Account: 122-60030-045-000 Rent And/Or Usage 214,279.00 .00 214,279.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 214,279.00 ** 214,279.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 53.51 .00 53.51 _______________ Account: 122-60035-045-000 Postage Totals: .00 53.51 ** 100.00 Budgeted 46.49 Remaining 54 % Used Account: 122-60055-045-000 Insurance 58 08/01/2014 Aug Ins & W/C Expense 10,134.50 1,009.25 11,143.75 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2014 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 Totals: 1,009.25 11,143.75 ** 12,110.00 Budgeted 966.25 Remaining 92 % Used Account: 122-60066-045-000 Publications/Books/Subscrips 112.75 .00 112.75 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 112.75 ** 400.00 Budgeted 287.25 Remaining 28 % Used Account: 122-60070-045-000 Dues & Memberships 2037 08/26/2014 7/29-8/26/14 PCards SAMSCLUB #4795 8,411.64 90.00 8,501.64 SAMSCLUB #4795 PC 1973 08/27/2014 Aug A/P Capital Replacement Dues 13-14 7,585.00 16,086.64 NORTH EAST FIRE DEPT ASSOC 34139 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 7,675.00 16,086.64 ** 15,180.00 Budgeted (906.64) Remaining 106 % Used Account: 122-60080-045-000 Schools & Training 1972 08/27/2014 Aug A/P Intermediate Cert/Sam Johnson 4,567.01 85.00 4,652.01 TX COMM ON FIRE PROTECTION 34162 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 85.00 4,652.01 ** 4,280.00 Budgeted (372.01) Remaining 109 % Used Account: 122-60096-045-000 Emergency Management 1,608.70 .00 1,608.70 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,608.70 ** 2,000.00 Budgeted 391.30 Remaining 80 % Used Account: 122-60100-045-000 Travel & per diem 2037 08/26/2014 7/29-8/26/14 PCards PAYPAL *FDINTERNATI 2,490.18 500.00 2,990.18 PAYPAL *FDINTERNATI PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 500.00 2,990.18 ** 4,577.00 Budgeted 1,586.82 Remaining 65 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 200.00 .00 200.00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 200.00 ** .00 Budgeted (200.00) Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 2037 08/26/2014 7/29-8/26/14 PCards NFPA NATL FIRE PROTECT 1,471.50 533.93 2,005.43 NFPA NATL FIRE PROTECT PC 2037 08/26/2014 7/29-8/26/14 PCards ALERT ALL CORP 495.00 2,500.43 ALERT ALL CORP PC 2037 08/26/2014 7/29-8/26/14 PCards LETS JUMP 186.10 2,686.53 LETS JUMP PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 1,215.03 2,686.53 ** 4,500.00 Budgeted 1,813.47 Remaining 60 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 2037 08/26/2014 7/29-8/26/14 PCards TEXAS OURDOORS 249.00 383.45 632.45 TEXAS OURDOORS PC _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 383.45 632.45 ** 1,500.00 Budgeted 867.55 Remaining 42 % Used Account: 122-60195-045-000 Flags & Repair 1,587.12 .00 1,587.12 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 1,587.12 ** 2,000.00 Budgeted 412.88 Remaining 79 % Used Account: 122-60243-045-000 Prior Year Expense 3,456.54 .00 3,456.54 _______________ Account: 122-60243-045-000 Prior Year Expense Totals: .00 3,456.54 ** 3,457.00 Budgeted .46 Remaining 100 % Used Account: 122-60245-045-000 Miscellaneous Expense . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2049 08/19/2014 Zion Bank/Fire Truck adm fee 247.97 500.00 747.97 GL 2037 08/26/2014 7/29-8/26/14 PCards THE FLORIST ON HICKORY 50.00 797.97 THE FLORIST ON HICKORY PC 2056 08/31/2014 Aug A/P Black Display boxes 59.93 857.90 CW NIELSEN MANUFACTURING, INC 34116 AP _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 609.93 857.90 ** 1,000.00 Budgeted 142.10 Remaining 86 % Used Account: 122-65005-045-000 Fuel & Lube 2016 08/31/2014 MUD August Gas Log 6,991.99 821.29 7,813.28 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 821.29 7,813.28 ** 10,198.00 Budgeted 2,384.72 Remaining 77 % Used Account: 122-65010-045-000 Uniforms 2037 08/26/2014 7/29-8/26/14 PCards NORTHWEST TERRITORIA 2,978.74 123.00 3,101.74 NORTHWEST TERRITORIA PC _______________ Account: 122-65010-045-000 Uniforms Totals: 123.00 3,101.74 ** 3,360.00 Budgeted 258.26 Remaining 92 % Used Account: 122-65015-045-000 Protective Clothing 1973 08/27/2014 Aug A/P Protective Clothing 5,953.77 1,869.00 7,822.77 CASCO INDUSTRIES INC 34111 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 1,869.00 7,822.77 ** 7,600.00 Budgeted (222.77) Remaining 103 % Used Account: 122-65030-045-000 Chemicals 420.00 .00 420.00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 420.00 ** 500.00 Budgeted 80.00 Remaining 84 % Used Account: 122-65035-045-000 Small Tools 2037 08/26/2014 7/29-8/26/14 PCards KELLER OUTDOOR POWER I 694.31 10.90 705.21 KELLER OUTDOOR POWER I PC _______________ Account: 122-65035-045-000 Small Tools Totals: 10.90 705.21 ** 2,500.00 Budgeted 1,794.79 Remaining 28 % Used Account: 122-65085-045-000 Office Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 233.22 .00 233.22 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 233.22 ** 500.00 Budgeted 266.78 Remaining 47 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt-Principal 2051 08/26/2014 Fire Truck Payment 70,000.00 70,000.00 GL _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: 70,000.00 70,000.00 ** 70,000.00 Budgeted .00 Remaining 100 % Used Account: 122-69009-045-000 Short Term Debt-Interest 2051 08/26/2014 Fire Truck Payment 1,515.50 1,515.50 3,031.00 GL _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: 1,515.50 3,031.00 ** 3,031.00 Budgeted .00 Remaining 100 % Used Account: 122-69050-045-000 Radios 32,693.40 .00 32,693.40 _______________ Account: 122-69050-045-000 Radios Totals: .00 32,693.40 ** 34,200.00 Budgeted 1,506.60 Remaining 96 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 41,890.00 .00 41,890.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 41,890.00 ** 67,647.00 Budgeted 25,757.00 Remaining 62 % Used Account: 122-69255-045-000 Airpacks 19,965.59 .00 19,965.59 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69255-045-000 Airpacks Totals: .00 19,965.59 ** 20,400.00 Budgeted 434.41 Remaining 98 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 1,125,501.41 ** 1,260,950.00 Budgeted 135,448.59 Remaining 89 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (139,078.16) .00 Budgeted 139,078.16 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET AUGUST 2014 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 8/31/14 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 52,652 - - 52,652 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,504,280 - - 1,504,280 INVESTMENTS-TEXPOOL 861,172 234,940 152,085 1,248,197 PREPAID EXPENSES 17,275 - - 17,275 ADVALOREM PROPERTY TAXES RECEIVABLE 2,255 - - 2,255 UTILITY AND OTHER ACCOUNTS RECEIVABLE 865,186 - - 865,186 - TOTAL ASSETS 3,303,419 234,940 152,085 3,690,444 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,255 - - 2,255 ACCOUNTS AND OTHER PAYABLES 265,560 - 6,674 272,234 CUSTOMER DEPOSITS 263,172 - - 263,172 - TOTAL LIABILITIES 530,987 - 6,674 537,661 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 313,050 313,050 NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 276,500 245,101 521,601 UNASSIGNED FUND BALANCE 2,708,490 - - 2,708,490 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES (216,044) (78,110) (99,689) (393,843) - TOTAL FUND BALANCE 2,772,432 234,940 145,412 3,152,784 - TOTAL LIABILITIES AND FUND BALANCE 3,303,419 234,940 152,085 3,690,444 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 16:40 09/09/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000- Property Taxes 99,250.00- 99,250.00- 74.46- 98,636.42- 99.382 613.58- 135-40002-000- Property Taxes/Delinquent .17- 129.78- 129.78 135-40015-000- Property Taxes/P & I 900.00- 900.00- 15.74- 573.41- 63.712 326.59- Subtotal: 100,150.00- 100,150.00- 90.37- 99,339.61- 99.191 810.39- 135-43215-000- Insurance Settlement 82.36- 82.36 Subtotal: 82.36- 82.36 135-47000-000- Water 3,749,310.00- 3,749,310.00- 451,216.05- 2,903,612.28- 77.444 845,697.72- 135-47005-000- Sewer 1,708,321.00- 1,708,321.00- 230,890.56- 1,844,745.66- 107.986 136,424.66 135-47025-000- Penalties 64,522.00- 64,522.00- 10,281.20- 55,020.13- 85.273 9,501.87- 135-47030-000- Service Charges 9,075.00- 9,075.00- 1,078.00- 8,883.00- 97.884 192.00- 135-47035-000- Plumbing Inspections 1,200.00- 2,000.00- 150.00- 2,300.00- 115.000 300.00 135-47045-000- Sewer Inspections 4,400.00- 5,000.00- 300.00- 7,050.00- 141.000 2,050.00 135-47070-000- TCCC Effluent Charges 79,586.00- 79,586.00- 13,773.20- 64,722.38- 81.324 14,863.62- Subtotal: 5,616,414.00- 5,617,814.00- 707,689.01- 4,886,333.45- 86.979 731,480.55- 135-48005-000- Utility Fees 582,109.00- 582,109.00- 16,100.00- 322,000.00- 55.316 260,109.00- Subtotal: 582,109.00- 582,109.00- 16,100.00- 322,000.00- 55.316 260,109.00- 135-49010-000- Interest Income 4,800.00- 4,800.00- 496.31- 5,547.90- 115.581 747.90 135-49016-000- Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 10,015.83- 98.542 148.17- 135-49018-000- Building Rent Income 7,000.00- 7,000.00- 583.33- 6,416.63- 91.666 583.37- 135-49030-000- Vending Revenue 350.00- 350.00- 226.85- 64.814 123.15- 135-49035-000- Prior Year Reserves 880,000.00- 880,000.00- 135-49036-000- GASB Reserves 8,964.00- 8,964.00- 8,964.00- 135-49075-000- Oversize Meter Reimbursement 84,000.00- 84,000.00- 3,087.00- 75,321.80- 89.669 8,678.20- 135-49900-000- Miscellaneous Income 3,000.00- 3,000.00- 708.19- 76,595.24- 2,553.175 73,595.24 135-49901-000- Records Management Revenue 100.00- 100.00- 53.39- 53.390 46.61- 135-49903-000- Recovery of Prior Year Expense 4,087.00- 4,087.00- 100.000 135-49905-000- Gas Well Revenue 886.00- 886.00- 886.00- Subtotal: 119,264.00- 1,003,351.00- 5,785.36- 178,264.64- 17.767 825,086.36- Program number: 6,417,937.00- 7,303,424.00- 729,664.74- 5,486,020.06- 75.116 1,817,403.94- Department number: Revenues 6,417,937.00- 7,303,424.00- 729,664.74- 5,486,020.06- 75.116 1,817,403.94- Revenues Subtotal ----- 6,417,937.00- 7,303,424.00- 729,664.74- 5,486,020.06- 75.116 1,817,403.94- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 16:40 09/09/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010- Salaries & Wages 287,709.00 287,709.00 33,208.00 250,561.52 87.089 37,147.48 135-50010-010- Overtime 13,391.00 16,391.00 2,159.20 17,803.84 108.620 1,412.84- 135-50016-010- Longevity 4,905.00 4,905.00 4,905.00 100.000 135-50017-010- Certification 5,100.00 5,100.00 375.00 4,011.00 78.647 1,089.00 135-50020-010- Retirement 27,847.00 27,847.00 3,209.64 25,333.85 90.975 2,513.15 135-50026-010- Medical Insurance 48,334.00 48,334.00 3,559.98 36,940.47 76.428 11,393.53 135-50027-010- Dental Insurance 3,932.00 3,932.00 249.12 2,673.45 67.992 1,258.55 135-50028-010- Vision Insurance 873.00 873.00 63.03 659.11 75.499 213.89 135-50029-010- Life Insurance & Other 3,306.00 3,306.00 238.45 2,390.61 72.311 915.39 135-50030-010- Social Security Taxes 19,289.00 19,289.00 2,214.69 17,525.13 90.856 1,763.87 135-50035-010- Medicare Taxes 4,511.00 4,511.00 517.95 4,098.63 90.859 412.37 135-50040-010- Unemployment Taxes 54.00 1,244.00 1,244.44 100.035 .44- 135-50045-010- Workman's Compensation 9,829.00 9,829.00 802.45 8,826.95 89.805 1,002.05 135-50060-010- Pre-emp Physicals/Testing 200.00 350.00 359.90 102.829 9.90- 135-50070-010- Employee Relations 300.00 300.00 180.53 60.177 119.47 Subtotal: 429,580.00 433,920.00 46,597.51 377,514.43 87.001 56,405.57 135-55005-010- Engineering 3,000.00 6,000.00 6,000.00 135-55080-010- Maintenance & Repairs 50,000.00 61,000.00 3,680.68 57,645.58 94.501 3,354.42 135-55090-010- Vehicle Maintenance 5,000.00 5,000.00 967.04 4,589.37 91.787 410.63 135-55105-010- Maintenance-Backhoe/SkidLoader 3,500.00 2,500.00 248.33 9.933 2,251.67 135-55135-010- Lab Analysis 5,500.00 5,500.00 4.78 3,821.02 69.473 1,678.98 Subtotal: 67,000.00 80,000.00 4,652.50 66,304.30 82.880 13,695.70 135-60010-010- Communications/Pagers/Mobiles 4,913.00 4,913.00 380.08 4,211.41 85.720 701.59 135-60020-010- Electricity 162,160.00 155,160.00 19,092.89 126,426.47 81.481 28,733.53 135-60066-010- Publications/Books/Subscripts 500.00 2,538.00 2,715.66 107.000 177.66- 135-60070-010- Dues & Memberships 150.00 300.00 289.00 96.333 11.00 135-60080-010- Schools & Training 4,184.00 1,500.00 1,782.00 118.800 282.00- 135-60090-010- Safety Program 400.00 27.83 27.83 27.83- 135-60100-010- Travel & per diem 1,450.00 279.00 237.48 85.118 41.52 135-60105-010- Rent/Lease Equipment 500.00 500.00 36.00 96.00 19.200 404.00 135-60135-010- TCEQ Fees & Permits 47,400.00 47,400.00 37,077.89 78.223 10,322.11 135-60150-010- Wholesale Water 2,338,473.00 2,338,473.00 197,239.53 1,515,268.67 64.797 823,204.33 135-60245-010- Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010- Property Maintenance 3,500.00 3,500.00 241.30 1,680.85 48.024 1,819.15 135-60285-010- Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010- Furniture/Equipment < $5000 3,500.00 2,000.00 1,664.20 83.210 335.80 Subtotal: 2,567,580.00 2,557,013.00 217,017.63 1,691,477.46 66.151 865,535.54 135-65005-010- Fuel & Lube 23,181.00 22,181.00 2,371.00 13,040.82 58.793 9,140.18 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 16:40 09/09/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010- Uniforms 3,270.00 2,500.00 1,938.58 77.543 561.42 135-65030-010- Chemicals 5,000.00 5,000.00 624.53 7,917.02 158.340 2,917.02- 135-65035-010- Small Tools 1,200.00 1,200.00 97.08 588.00 49.000 612.00 135-65040-010- Safety Equipment 1,000.00 1,000.00 344.55 34.455 655.45 135-65050-010- Meter Expense 143,550.00 143,550.00 15,590.00 91,735.04 63.905 51,814.96 Subtotal: 177,201.00 175,431.00 18,682.61 115,564.01 65.874 59,866.99 135-69005-010- Capital Outlays 37,000.00 35,681.00 35,679.59 99.996 1.41 135-69008-010- Short Term Debt-Principal 489,980.00 489,980.00 122,980.00 25.099 367,000.00 135-69009-010- Short Term Debt-Interest 19,268.00 19,268.00 11,621.26 60.314 7,646.74 135-69195-010- Gasb34/Reserve for Replacement 30,000.00 135-69280-010- Capital Repairs 7,500.00 135-69281-010- Water Tank Inspection Contract 106,847.00 100,847.00 100,816.54 99.970 30.46 Subtotal: 690,595.00 645,776.00 271,097.39 41.980 374,678.61 Program number: 3,931,956.00 3,892,140.00 286,950.25 2,521,957.59 64.796 1,370,182.41 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 16:40 09/09/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010- Lab Analysis for PID 1,000.00 2,000.00 97.63 3,279.87 163.994 1,279.87- Subtotal: 1,000.00 2,000.00 97.63 3,279.87 163.994 1,279.87- 135-60135-010- TCEQ Fees & Permits for PID 5,000.00 2,496.19 49.924 2,503.81 Subtotal: 5,000.00 2,496.19 49.924 2,503.81 Program number: 1 Lab Analysis for PID 1,000.00 7,000.00 97.63 5,776.06 82.515 1,223.94 Department number: Water 3,932,956.00 3,899,140.00 287,047.88 2,527,733.65 64.828 1,371,406.35 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 16:40 09/09/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020- Salaries & Wages 202,894.00 202,894.00 23,356.53 179,525.26 88.482 23,368.74 135-50010-020- Overtime 11,965.00 11,965.00 974.40 12,491.76 104.403 526.76- 135-50016-020- Longevity 2,998.00 2,998.00 2,997.50 99.983 .50 135-50017-020- Certification 4,800.00 4,800.00 400.00 4,400.00 91.667 400.00 135-50020-020- Retirement 19,905.00 19,905.00 2,220.84 18,375.78 92.317 1,529.22 135-50026-020- Medical Insurance 43,471.00 43,471.00 3,426.76 37,241.60 85.670 6,229.40 135-50027-020- Dental Insurance 2,989.00 2,989.00 211.38 2,370.42 79.305 618.58 135-50028-020- Vision Insurance 658.00 658.00 51.26 559.87 85.087 98.13 135-50029-020- Life Insurance & Other 2,303.00 2,303.00 189.29 2,020.71 87.743 282.29 135-50030-020- Social Security Taxes 13,805.00 13,805.00 1,389.69 11,202.01 81.145 2,602.99 135-50035-020- Medicare Taxes 3,229.00 3,229.00 325.00 2,619.82 81.134 609.18 135-50040-020- Unemployment Taxes 36.00 828.00 828.00 100.000 135-50045-020- Workman's Compensation 6,552.00 6,552.00 535.08 5,885.88 89.833 666.12 135-50060-020- Pre-emp Physicals/Testing 150.00 150.00 63.00 42.000 87.00 135-50070-020- Employee Relations 350.00 350.00 187.77 320.34 91.526 29.66 Subtotal: 316,105.00 316,897.00 33,268.00 280,901.95 88.641 35,995.05 135-55070-020- Independent Labor 880,000.00 55,668.81 855,057.65 97.166 24,942.35 135-55080-020- Maintenance & Repairs 35,000.00 36,120.00 472.60 35,167.77 97.364 952.23 135-55090-020- Vehicle Maintenance 2,000.00 2,000.00 306.60 1,972.08 98.604 27.92 135-55105-020- Maintenance-Backhoe/SkidLoader 500.00 135-55125-020- Dumpster Services 52,000.00 47,000.00 2,780.69 45,681.04 97.194 1,318.96 135-55135-020- Lab Analysis 30,000.00 30,000.00 2,140.00 24,056.08 80.187 5,943.92 Subtotal: 119,500.00 995,120.00 61,368.70 961,934.62 96.665 33,185.38 135-60010-020- Communications/Pagers/Mobiles 3,329.00 3,329.00 323.08 3,079.43 92.503 249.57 135-60020-020- Electricity 148,227.00 138,227.00 9,709.54 98,759.24 71.447 39,467.76 135-60066-020- Publications/Books/Subscripts 400.00 400.00 351.00 87.750 49.00 135-60080-020- Schools & Training 2,636.00 1,636.00 1,347.00 82.335 289.00 135-60090-020- Safety Program 250.00 500.00 474.07 94.814 25.93 135-60100-020- Travel & per diem 1,050.00 1,050.00 4.82 1,093.55 104.148 43.55- 135-60105-020- Rent/Lease Equipment 1,500.00 1,500.00 299.53 19.969 1,200.47 135-60135-020- TCEQ Fees & Permits 17,150.00 17,150.00 8,919.00 52.006 8,231.00 135-60243-020- Prior Year Expense 3,554.00 3,554.22 100.006 .22- 135-60245-020- Miscellaneous Expenses 200.00 200.00 4.67 4.67 2.335 195.33 135-60285-020- Lawn Equipment & Maintenance 500.00 250.00 250.00 135-60360-020- Furniture/Equipment < $5000 3,000.00 1,079.00 1,079.10 100.009 .10- Subtotal: 178,242.00 168,875.00 10,042.11 118,960.81 70.443 49,914.19 135-65005-020- Fuel & Lube 14,720.00 13,600.00 1,846.42 11,192.79 82.300 2,407.21 135-65010-020- Uniforms 1,752.00 1,752.00 230.50 1,667.77 95.192 84.23 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 16:40 09/09/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65030-020- Chemicals 39,000.00 31,000.00 4,400.00 25,292.10 81.587 5,707.90 135-65035-020- Small Tools 1,000.00 300.00 346.09 115.363 46.09- 135-65040-020- Safety Equipment 250.00 500.00 277.86 55.572 222.14 135-65045-020- Lab Supplies 15,000.00 15,000.00 1,811.87 11,815.89 78.773 3,184.11 Subtotal: 71,722.00 62,152.00 8,288.79 50,592.50 81.401 11,559.50 135-69005-020- Capital Outlays 31,000.00 135-69008-020- Short Term Debt-Principal 20,020.00 20,020.00 20,020.00 100.000 135-69009-020- Short Term Debt-Interest 1,422.00 1,422.00 1,043.70 73.397 378.30 135-69280-020- Capital Repairs 30,000.00 Subtotal: 82,442.00 21,442.00 21,063.70 98.236 378.30 Program number: 768,011.00 1,564,486.00 112,967.60 1,433,453.58 91.625 131,032.42 Department number: Wastewater 768,011.00 1,564,486.00 112,967.60 1,433,453.58 91.625 131,032.42 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 16:40 09/09/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021- Salaries & Wages 90,299.00 90,299.00 10,303.92 70,956.71 78.580 19,342.29 135-50010-021- Overtime 10,028.00 10,028.00 2,225.85 7,585.69 75.645 2,442.31 135-50016-021- Longevity 17,913.00 2,108.00 2,107.50 99.976 .50 135-50017-021- Certification 1,800.00 1,800.00 150.00 1,650.00 91.667 150.00 135-50020-021- Retirement 9,025.00 9,025.00 1,138.64 7,745.53 85.823 1,279.47 135-50026-021- Medical Insurance 23,668.00 23,668.00 1,473.70 17,042.39 72.006 6,625.61 135-50027-021- Dental Insurance 1,703.00 1,703.00 102.60 1,223.19 71.826 479.81 135-50028-021- Vision Insurance 314.00 314.00 23.68 265.29 84.487 48.71 135-50029-021- Life Insurance & Other 1,066.00 1,066.00 72.75 903.24 84.732 162.76 135-50030-021- Social Security Taxes 7,442.00 7,442.00 812.54 4,974.66 66.846 2,467.34 135-50035-021- Medicare Taxes 1,741.00 1,741.00 190.02 1,163.43 66.825 577.57 135-50040-021- Unemployment Taxes 198.00 414.00 414.00 100.000 135-50045-021- Workman's Compensation 3,276.00 3,276.00 267.54 2,942.94 89.833 333.06 135-50070-021- Employee Relations 200.00 200.00 230.28 115.140 30.28- Subtotal: 168,673.00 153,084.00 16,761.24 119,204.85 77.869 33,879.15 135-55005-021- Engineering 1,500.00 135-55080-021- Maintenance & Repairs 23,801.00 14,451.00 13,336.21 92.286 1,114.79 135-55090-021- Vehicle Maintenance 2,000.00 2,000.00 814.24 1,813.42 90.671 186.58 Subtotal: 27,301.00 16,451.00 814.24 15,149.63 92.089 1,301.37 135-60010-021- Communications/Pagers/Mobiles 1,333.00 1,333.00 101.36 1,301.12 97.608 31.88 135-60020-021- Electricity 21,178.00 21,178.00 1,494.37 18,757.32 88.570 2,420.68 135-60070-021- Dues & Memberships 250.00 250.00 250.00 135-60080-021- Schools & Training 1,711.00 911.00 561.00 61.581 350.00 135-60090-021- Safety Program 300.00 300.00 35.34 11.780 264.66 135-60100-021- Travel & per diem 550.00 250.00 86.01- 621.24 248.496 371.24- 135-60105-021- Rent/Lease Equipment 10,000.00 5,000.00 5,000.00 135-60245-021- Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 35,422.00 29,322.00 1,509.72 21,276.02 72.560 8,045.98 135-65005-021- Fuel & Lube 22,397.00 21,747.00 1,953.29 11,856.45 54.520 9,890.55 135-65010-021- Uniforms 1,040.00 1,040.00 172.50 986.73 94.878 53.27 135-65030-021- Chemicals 6,000.00 2,000.00 300.89 15.045 1,699.11 135-65035-021- Small Tools 1,000.00 300.00 242.99 80.997 57.01 135-65040-021- Safety Equipment 500.00 750.00 586.73 78.231 163.27 Subtotal: 30,937.00 25,837.00 2,125.79 13,973.79 54.084 11,863.21 135-69005-021- Capital Outlays 100,000.00 114,000.00 68,300.20 59.912 45,699.80 135-69008-021- Short Term Debt-Principal 35,991.00 35,991.00 35,991.00 35,991.00 100.000 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 16:40 09/09/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69009-021- Short Term Debt-Interest 2,846.00 2,846.00 2,822.90 2,822.90 99.188 23.10 135-69280-021- Capital Repairs 71,000.00 Subtotal: 209,837.00 152,837.00 38,813.90 107,114.10 70.084 45,722.90 Program number: 472,170.00 377,531.00 60,024.89 276,718.39 73.297 100,812.61 Department number: Collection 472,170.00 377,531.00 60,024.89 276,718.39 73.297 100,812.61 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 16:40 09/09/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026- Salaries & Wages 10,000.00 10,000.00 1,500.00 8,500.00 85.000 1,500.00 135-50030-026- Social Security Taxes 620.00 620.00 93.00 527.00 85.000 93.00 135-50035-026- Medicare Taxes 145.00 145.00 21.75 123.25 85.000 21.75 135-50040-026- Unemployment Taxes 10.00 230.00 34.50 140.50 61.087 89.50 135-50045-026- Workman's Compensation 36.00 36.00 2.94 32.41 90.028 3.59 Subtotal: 10,811.00 11,031.00 1,652.19 9,323.16 84.518 1,707.84 135-60066-026- Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026- Dues & Memberships 500.00 500.00 35.00 7.000 465.00 135-60075-026- Meetings 1,200.00 1,200.00 87.92 395.79 32.983 804.21 135-60080-026- Schools & Training 4,000.00 4,000.00 200.00 957.00 23.925 3,043.00 135-60100-026- Travel & per diem 5,000.00 5,000.00 41.66 .833 4,958.34 135-60245-026- Miscellaneous Expenses 1,000.00 1,000.00 179.40 17.940 820.60 Subtotal: 11,850.00 11,850.00 287.92 1,608.85 13.577 10,241.15 Program number: 22,661.00 22,881.00 1,940.11 10,932.01 47.778 11,948.99 Department number: Board of Directors 22,661.00 22,881.00 1,940.11 10,932.01 47.778 11,948.99 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 16:40 09/09/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030- Salaries & Wages 458,721.00 458,721.00 51,737.66 408,322.07 89.013 50,398.93 135-50010-030- Overtime 500.00 750.00 82.73 884.28 117.904 134.28- 135-50016-030- Longevity 3,018.00 3,018.00 3,077.50 101.972 59.50- 135-50020-030- Retirement 41,419.00 41,419.00 4,366.11 37,536.04 90.625 3,882.96 135-50026-030- Medical Insurance 57,923.00 57,923.00 4,211.48 51,176.38 88.352 6,746.62 135-50027-030- Dental Insurance 5,100.00 5,100.00 307.67 3,755.54 73.638 1,344.46 135-50028-030- Vision Insurance 1,087.00 1,087.00 72.57 891.50 82.015 195.50 135-50029-030- Life Insurance & Other 4,483.00 5,500.00 322.59 4,276.80 77.760 1,223.20 135-50030-030- Social Security Taxes 28,659.00 28,659.00 2,930.11 24,602.12 85.844 4,056.88 135-50035-030- Medicare Taxes 6,702.00 6,702.00 685.28 5,753.74 85.851 948.26 135-50040-030- Unemployment Taxes 63.00 1,449.00 1,449.00 100.000 135-50045-030- Workman's Compensation 1,575.00 1,575.00 128.62 1,414.89 89.834 160.11 135-50060-030- Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-030- Employee Relations 5,000.00 5,000.00 2,732.68 54.654 2,267.32 Subtotal: 614,450.00 617,103.00 64,844.82 545,872.54 88.457 71,230.46 135-55030-030- Software & Support 59,698.00 59,698.00 726.48 45,801.22 76.722 13,896.78 135-55070-030- Independent Labor 7,700.00 7,000.00 8,454.78 120.783 1,454.78- 135-55080-030- Maintenance & Repairs 4,500.00 4,500.00 503.45 11.188 3,996.55 135-55100-030- Building Maint & Supplies 6,500.00 6,500.00 302.47 2,700.79 41.551 3,799.21 135-55120-030- Cleaning Services 19,140.00 19,140.00 1,594.97 15,949.70 83.332 3,190.30 135-55160-030- Professional Outside Services 15,000.00 10,000.00 500.00 5.000 9,500.00 135-55161-030- Town Personnel Contract 77,048.00 77,048.00 77,048.00 100.000 135-55165-030- Collection Fees 200.00 200.00 200.00 135-55205-030- Utility Billing Contract 6,808.00 6,808.00 6,744.24 99.063 63.76 Subtotal: 196,594.00 190,894.00 2,623.92 157,702.18 82.612 33,191.82 135-60005-030- Telephone 11,250.00 11,250.00 1,069.50 11,693.40 103.941 443.40- 135-60010-030- Communications/Pagers/Mobiles 3,589.00 4,057.00 337.99 3,340.58 82.341 716.42 135-60020-030- Electricity/Gas 15,171.00 15,171.00 916.40 12,750.50 84.045 2,420.50 135-60025-030- Water 1,500.00 1,500.00 238.75 948.89 63.259 551.11 135-60035-030- Postage 28,500.00 28,500.00 176.59 22,463.42 78.819 6,036.58 135-60040-030- Service Charges & Fees 28,330.00 28,330.00 3,946.29 30,826.66 108.813 2,496.66- 135-60050-030- Bad Debt Expense 1,500.00 6,200.00 4,351.64 70.188 1,848.36 135-60055-030- Insurance 53,561.00 53,561.00 4,269.73 47,295.28 88.302 6,265.72 135-60066-030- Publications/Books/Subscripts 1,000.00 1,000.00 401.08 40.108 598.92 135-60070-030- Dues & Memberships 4,500.00 4,500.00 260.00 4,571.95 101.599 71.95- 135-60075-030- Meetings 400.00 400.00 27.26 6.815 372.74 135-60079-030- Public Education 5,000.00 274.83 5.497 4,725.17 135-60080-030- Schools & Training 7,500.00 6,800.00 50.01- 2,614.25 38.445 4,185.75 135-60100-030- Travel & per diem 5,000.00 5,000.00 233.03 3,209.96 64.199 1,790.04 135-60110-030- Physicals/Testing 200.00 200.00 200.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 16:40 09/09/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030- Elections 2,500.00 2,500.00 3,709.19 148.368 1,209.19- 135-60125-030- Advertising 2,500.00 2,500.00 1,039.50 1,778.93 71.157 721.07 135-60235-030- Security 1,350.00 1,350.00 123.56 9.153 1,226.44 135-60245-030- Miscellaneous Expenses 22,870.00 17,870.00 2.25 2,066.40 11.564 15,803.60 135-60270-030- 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60336-030- Interfund Trans Out (MUD1 I&S) 16,525.00 16,525.00- 135-60360-030- Furniture/Equipment < $5000 2,500.00 2,500.00 2,563.55 102.542 63.55- Subtotal: 204,221.00 208,689.00 12,440.02 171,536.33 82.197 37,152.67 135-65010-030- Uniforms 1,390.00 1,390.00 998.90 71.863 391.10 135-65055-030- Hardware 13,562.00 13,562.00 420.64 7,895.10 58.215 5,666.90 135-65085-030- Office Supplies 9,100.00 9,100.00 1,564.99 5,878.91 64.603 3,221.09 135-65090-030- Printer Supplies & Maintenance 5,732.00 5,732.00 295.44 4,323.06 75.420 1,408.94 135-65095-030- Maintenance Supplies 2,500.00 2,500.00 363.66 2,849.96 113.998 349.96- 135-65097-030- Vending Machine Supplies 200.00 200.00 76.96 38.480 123.04 135-65105-030- Printing 4,000.00 4,000.00 3,424.27 85.607 575.73 Subtotal: 36,484.00 36,484.00 2,644.73 25,447.16 69.749 11,036.84 135-69170-030- Copier Lease Installments 3,450.00 3,450.00 317.14 2,371.95 68.752 1,078.05 Subtotal: 3,450.00 3,450.00 317.14 2,371.95 68.752 1,078.05 Program number: 1,055,199.00 1,056,620.00 82,870.63 902,930.16 85.455 153,689.84 Department number: Administration 1,055,199.00 1,056,620.00 82,870.63 902,930.16 85.455 153,689.84 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 16:40 09/09/14 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039- Legal 131,300.00 347,126.00 142,427.58 518,486.18 149.365 171,360.18- 135-55055-039- Auditing 21,840.00 21,840.00 21,200.00 97.070 640.00 135-55060-039- Appraisal 10,000.00 10,000.00 8,158.30 81.583 1,841.70 135-55065-039- Tax Admin Fees 3,800.00 3,800.00 2,451.40 64.511 1,348.60 Subtotal: 166,940.00 382,766.00 142,427.58 550,295.88 143.768 167,529.88- Program number: 166,940.00 382,766.00 142,427.58 550,295.88 143.768 167,529.88- Department number: Non Departmental 166,940.00 382,766.00 142,427.58 550,295.88 143.768 167,529.88- Expenditures Subtotal ----- 6,417,937.00 7,303,424.00 687,278.69 5,702,063.67 78.074 1,601,360.33 Fund number: 135 MUD 1 General Fund 42,386.05- 216,043.61 216,043.61- . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 16:40 09/09/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000- Interest Income 7.60- 82.83- 82.83 507-49036-000- GASB Reserves 120,000.00- 120,000.00 Subtotal: 7.60- 120,082.83- 120,082.83 Program number: 7.60- 120,082.83- 120,082.83 Department number: 7.60- 120,082.83- 120,082.83 Revenues Subtotal ----------- 7.60- 120,082.83- 120,082.83 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 16:40 09/09/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010- Capital Repairs/ROFC FW Meter 82,629.40 82,629.40- Subtotal: 82,629.40 82,629.40- Program number: 2 Rate of Flow Control-FW Meter 82,629.40 82,629.40- . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 16:40 09/09/14 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010- Capital Rep/Ind Crk Waterline 282,245.17 80,520.00 137,142.00 48.590 145,103.17 Subtotal: 282,245.17 80,520.00 137,142.00 48.590 145,103.17 Program number: 3 Indian Creek Waterline 282,245.17 80,520.00 137,142.00 48.590 145,103.17 Department number: Water 282,245.17 80,520.00 219,771.40 77.865 62,473.77 Expenditures Subtotal ----------- 282,245.17 80,520.00 219,771.40 77.865 62,473.77 Fund number: 507 MUD 1 Capital Projects 282,245.17 80,512.40 99,688.57 35.320 182,556.60 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2014 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 2024 08/01/2014 Property Taxes/Assessments (98,561.96) (12.75) (98,574.71) GL 2025 08/05/2014 Property Taxes/Assessments (19.13) (98,593.84) GL 2026 08/08/2014 Property Taxes/Assessments (.62) (98,594.46) GL 2027 08/18/2014 Property Taxes/Assessments (1.37) (98,595.83) GL 2028 08/19/2014 Property Taxes/Assessments (31.64) (98,627.47) GL 2029 08/21/2014 Property Taxes/Assessments (5.65) (98,633.12) GL 2030 08/22/2014 Property Taxes/Assessments (3.30) (98,636.42) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (74.46) (98,636.42) ** (99,250.00) Budgeted (613.58) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 2027 08/18/2014 Property Taxes/Assessments (129.61) (.17) (129.78) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (.17) (129.78) ** .00 Budgeted 129.78 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 2025 08/05/2014 Property Taxes/Assessments (557.67) (6.80) (564.47) GL 2026 08/08/2014 Property Taxes/Assessments (.11) (564.58) GL 2027 08/18/2014 Property Taxes/Assessments (1.52) (566.10) GL 2028 08/19/2014 Property Taxes/Assessments (6.01) (572.11) GL 2029 08/21/2014 Property Taxes/Assessments (1.07) (573.18) GL 2030 08/22/2014 Property Taxes/Assessments (.23) (573.41) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (15.74) (573.41) ** (900.00) Budgeted (326.59) Remaining 64 % Used Account: 135-43215-000-000 Insurance Settlement (82.36) .00 (82.36) _______________ Account: 135-43215-000-000 Insurance Settlement Totals: .00 (82.36) ** .00 Budgeted 82.36 Remaining 0 % Used Account: 135-47000-000-000 Water 1980 08/04/2014 UB 8/4/14 Adj-Lakeview UB20140804-20140804 User: (2,452,396.23) 25,800.33 (2,426,595.90) UB 1983 08/06/2014 UB 8/6/14 Adjustment UB20140806-20140806 User: 36.18 (2,426,559.72) UB 1999 08/31/2014 UB 8/31/14 Billing UB20140831-20140831 User: (477,052.56) (2,903,612.28) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47000-000-000 Water Totals: (451,216.05) (2,903,612.28) ** (3,749,310.00) Budgeted (845,697.72) Remaining 77 % Used Account: 135-47005-000-000 Sewer 1983 08/06/2014 UB 8/6/14 Adjustment UB20140806-20140806 User: (1,613,855.10) 23.82 (1,613,831.28) UB 1999 08/31/2014 UB 8/31/14 Billing UB20140831-20140831 User: (230,914.38) (1,844,745.66) UB _______________ Account: 135-47005-000-000 Sewer Totals: (230,890.56) (1,844,745.66) ** (1,708,321.00) Budgeted 136,424.66 Remaining 108 % Used Account: 135-47025-000-000 Penalties 1980 08/04/2014 UB 8/4/14 Adj-Lakeview UB20140804-20140804 User: (44,738.93) 54.77 (44,684.16) UB 1990 08/14/2014 UB 8/14/14 Adjustments UB20140814-20140814 User: 38.69 (44,645.47) UB 1955 08/21/2014 UB 8/21/14 Penalties UB20140821-20140821 User: (10,633.68) (55,279.15) UB 2008 08/28/2014 UB 8/28/14 Adjustments UB20140828-20140828 User: 259.02 (55,020.13) UB _______________ Account: 135-47025-000-000 Penalties Totals: (10,281.20) (55,020.13) ** (64,522.00) Budgeted (9,501.87) Remaining 85 % Used Account: 135-47030-000-000 Service Charges 1885 08/06/2014 UB 8/6/14 Disconnect Fees UB20140806-20140806 User: (7,805.00) (675.00) (8,480.00) UB 1982 08/06/2014 UB 8/6/14 After Hours Fee UB20140806-20140806 User: (300.00) (8,780.00) UB 1984 08/07/2014 UB 8/7/14 Adj-NSF Fee removal UB20140807-20140807 User: 25.00 (8,755.00) UB 1992 08/15/2014 UB 8/15/14 NSF Check fe UB20140815-20140815 User: (25.00) (8,780.00) UB 2005 08/22/2014 UB 8/22/14 NSF CHeck Fees UB20140822-20140822 User: (75.00) (8,855.00) UB 2010 08/27/2014 UB 8/27/14 NSF Check Fee UB20140827-20140827 User: (25.00) (8,880.00) UB 1999 08/31/2014 UB 8/31/14 Billing UB20140831-20140831 User: (3.00) (8,883.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,078.00) (8,883.00) ** (9,075.00) Budgeted (192.00) Remaining 98 % Used Account: 135-47035-000-000 Plumbing Inspections 2017 08/29/2014 Back Flow Test 2525 Kensington (2,150.00) (50.00) (2,200.00) GL 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (100.00) (2,300.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (2,300.00) ** (2,000.00) Budgeted 300.00 Remaining 115 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47045-000-000 Sewer Inspections 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (6,750.00) (300.00) (7,050.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (7,050.00) ** (5,000.00) Budgeted 2,050.00 Remaining 141 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1999 08/31/2014 UB 8/31/14 Billing UB20140831-20140831 User: (50,949.18) (13,773.20) (64,722.38) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (13,773.20) (64,722.38) ** (79,586.00) Budgeted (14,863.62) Remaining 81 % Used Account: 135-48005-000-000 Utility Fees 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (305,900.00) (16,100.00) (322,000.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (16,100.00) (322,000.00) ** (582,109.00) Budgeted (260,109.00) Remaining 55 % Used Account: 135-49010-000-000 Interest Income 2020 08/31/2014 Bank Interest/August (5,051.59) (60.00) (5,111.59) GL 2020 08/31/2014 Bank Interest/August (53.95) (5,165.54) GL 2020 08/31/2014 Bank Interest/August (382.36) (5,547.90) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (496.31) (5,547.90) ** (4,800.00) Budgeted 747.90 Remaining 116 % Used Account: 135-49016-000-000 Cell Tower Revenue 1927 08/15/2014 Cell Tower Lease (9,105.30) (910.53) (10,015.83) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (10,015.83) ** (10,164.00) Budgeted (148.17) Remaining 99 % Used Account: 135-49018-000-000 Building Rent Income 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (5,833.30) (583.33) (6,416.63) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (6,416.63) ** (7,000.00) Budgeted (583.37) Remaining 92 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49030-000-000 Vending Revenue (226.85) .00 (226.85) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (226.85) ** (350.00) Budgeted (123.15) Remaining 65 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (880,000.00) Budgeted (880,000.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (8,964.00) Budgeted (8,964.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (72,234.80) (3,087.00) (75,321.80) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (3,087.00) (75,321.80) ** (84,000.00) Budgeted (8,678.20) Remaining 90 % Used Account: 135-49900-000-000 Miscellaneous Income 1946 08/19/2014 Discovery Benefits/Settlement (75,887.05) (683.94) (76,570.99) GL 1999 08/31/2014 UB 8/31/14 Billing UB20140831-20140831 User: (24.25) (76,595.24) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (708.19) (76,595.24) ** (3,000.00) Budgeted 73,595.24 Remaining ########## Account: 135-49901-000-000 Records Management Revenue (53.39) .00 (53.39) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (53.39) ** (100.00) Budgeted (46.61) Remaining 53 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (4,087.00) .00 (4,087.00) _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: .00 (4,087.00) ** (4,087.00) Budgeted .00 Remaining 100 % Used Account: 135-49905-000-000 Gas Well Revenue .00 .00 _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 .00 ** (886.00) Budgeted (886.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5,486,020.06) ** (7,303,424.00) Budgeted (1,817,403.94) Remaining 75 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2014 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 1786 08/01/2014 PR 08-01-2014 Salaries & Wages 217,353.52 11,069.33 228,422.85 PR 1904 08/15/2014 MUD Payroll 8/15/14 Salaries & Wages 11,069.34 239,492.19 PR 1961 08/29/2014 MUD Payroll 8/29/14 Salaries & Wages 11,069.33 250,561.52 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 33,208.00 250,561.52 ** 287,709.00 Budgeted 37,147.48 Remaining 87 % Used Account: 135-50010-010-000 Overtime 1786 08/01/2014 PR 08-01-2014 Overtime 15,644.64 769.17 16,413.81 PR 1904 08/15/2014 MUD Payroll 8/15/14 Overtime 851.15 17,264.96 PR 1961 08/29/2014 MUD Payroll 8/29/14 Overtime 538.88 17,803.84 PR _______________ Account: 135-50010-010-000 Overtime Totals: 2,159.20 17,803.84 ** 16,391.00 Budgeted (1,412.84) Remaining 109 % Used Account: 135-50016-010-000 Longevity 4,905.00 .00 4,905.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 4,905.00 ** 4,905.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1904 08/15/2014 MUD Payroll 8/15/14 Certification 3,636.00 375.00 4,011.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 375.00 4,011.00 ** 5,100.00 Budgeted 1,089.00 Remaining 79 % Used Account: 135-50020-010-000 Retirement 1786 08/01/2014 PR 08-01-2014 Retirement 22,124.21 1,063.10 23,187.31 PR 1904 08/15/2014 MUD Payroll 8/15/14 Retirement 1,104.14 24,291.45 PR 1961 08/29/2014 MUD Payroll 8/29/14 Retirement 1,042.40 25,333.85 PR _______________ Account: 135-50020-010-000 Retirement Totals: 3,209.64 25,333.85 ** 27,847.00 Budgeted 2,513.15 Remaining 91 % Used Account: 135-50026-010-000 Medical Insurance 1786 08/01/2014 PR 08-01-2014 Medical Insurance 33,380.49 1,780.02 35,160.51 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1904 08/15/2014 MUD Payroll 8/15/14 Medical Insurance 33,380.49 1,779.96 36,940.47 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 3,559.98 36,940.47 ** 48,334.00 Budgeted 11,393.53 Remaining 76 % Used Account: 135-50027-010-000 Dental Insurance 1786 08/01/2014 PR 08-01-2014 Dental Insurance 2,424.33 124.54 2,548.87 PR 1904 08/15/2014 MUD Payroll 8/15/14 Dental Insurance 124.58 2,673.45 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 249.12 2,673.45 ** 3,932.00 Budgeted 1,258.55 Remaining 68 % Used Account: 135-50028-010-000 Vision Insurance 1786 08/01/2014 PR 08-01-2014 Vision Insurance 596.08 31.49 627.57 PR 1904 08/15/2014 MUD Payroll 8/15/14 Vision Insurance 31.54 659.11 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 63.03 659.11 ** 873.00 Budgeted 213.89 Remaining 75 % Used Account: 135-50029-010-000 Life Insurance & Other 1764 08/01/2014 Aug A/P Dental and Other Insurances 2,152.16 223.17 2,375.33 METLIFE 34004 AP 1972 08/27/2014 Aug A/P Café 125 Monthly adm fee 15.28 2,390.61 BenefitMall 34108 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 238.45 2,390.61 ** 3,306.00 Budgeted 915.39 Remaining 72 % Used Account: 135-50030-010-000 Social Security Taxes 1786 08/01/2014 PR 08-01-2014 Social Security Taxes 15,310.44 733.43 16,043.87 PR 1904 08/15/2014 MUD Payroll 8/15/14 Social Security Taxes 759.39 16,803.26 PR 1961 08/29/2014 MUD Payroll 8/29/14 Social Security Taxes 721.87 17,525.13 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 2,214.69 17,525.13 ** 19,289.00 Budgeted 1,763.87 Remaining 91 % Used Account: 135-50035-010-000 Medicare Taxes 1786 08/01/2014 PR 08-01-2014 Medicare Taxes 3,580.68 171.51 3,752.19 PR 1904 08/15/2014 MUD Payroll 8/15/14 Medicare Taxes 177.62 3,929.81 PR 1961 08/29/2014 MUD Payroll 8/29/14 Medicare Taxes 168.82 4,098.63 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 517.95 4,098.63 ** 4,511.00 Budgeted 412.37 Remaining 91 % Used Account: 135-50040-010-000 Unemployment Taxes 1,244.44 .00 1,244.44 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 1,244.44 ** 1,244.00 Budgeted (.44) Remaining 100 % Used Account: 135-50045-010-000 Workman's Compensation 58 08/01/2014 Aug Ins & W/C Expense 8,024.50 802.45 8,826.95 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 8,826.95 ** 9,829.00 Budgeted 1,002.05 Remaining 90 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 359.90 .00 359.90 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 359.90 ** 350.00 Budgeted (9.90) Remaining 103 % Used Account: 135-50070-010-000 Employee Relations 180.53 .00 180.53 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 180.53 ** 300.00 Budgeted 119.47 Remaining 60 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1914 08/13/2014 Aug A/P Valve for Indian Creek 53,964.90 1,648.50 55,613.40 HD SUPPLY WATERWORKS, LTD. 34067 AP 1914 08/13/2014 Aug A/P Water parts 817.57 56,430.97 HD SUPPLY WATERWORKS, LTD. 34067 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2037 08/26/2014 7/29-8/26/14 PCards AUTOZONE #4206 53,964.90 36.97 56,467.94 AUTOZONE #4206 PC 2037 08/26/2014 7/29-8/26/14 PCards ROANOKE WINNELSON CO 152.13 56,620.07 ROANOKE WINNELSON CO PC 2037 08/26/2014 7/29-8/26/14 PCards ATLAS UTILITY SUPPLY C 60.00 56,680.07 ATLAS UTILITY SUPPLY C PC 2037 08/26/2014 7/29-8/26/14 PCards THE HOME DEPOT 6581 13.99 56,694.06 THE HOME DEPOT 6581 PC 1972 08/27/2014 Aug A/P Angle stops and meter boxes 875.77 57,569.83 ATLAS UTILITY SUPPLY CO. 34106 AP 2065 08/31/2014 Aug A/P Prokeys for fuel system 75.75 57,645.58 SYN-TECH SYSTEMS, INC 34152 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 3,680.68 57,645.58 ** 61,000.00 Budgeted 3,354.42 Remaining 95 % Used Account: 135-55090-010-000 Vehicle Maintenance 1914 08/13/2014 Aug A/P 2 Tires Dodge Dakota 3,622.33 303.16 3,925.49 BLAGG TIRE & SERVICE 34060 AP 2037 08/26/2014 7/29-8/26/14 PCards ROANOKE AUTO SUPPLY LT 5.49 3,930.98 ROANOKE AUTO SUPPLY LT PC 2037 08/26/2014 7/29-8/26/14 PCards ROANOKE AUTO SUPPLY LT 36.98 3,967.96 ROANOKE AUTO SUPPLY LT PC 2037 08/26/2014 7/29-8/26/14 PCards KWIK KAR LUBE & TUNE O (32.48) 3,935.48 KWIK KAR LUBE & TUNE O PC 2037 08/26/2014 7/29-8/26/14 PCards KWIK KAR LUBE & TUNE O (1.48) 3,934.00 KWIK KAR LUBE & TUNE O PC 2037 08/26/2014 7/29-8/26/14 PCards KWIK KAR LUBE & TUNE O 30.68 3,964.68 KWIK KAR LUBE & TUNE O PC 2037 08/26/2014 7/29-8/26/14 PCards KWIK KAR LUBE & TUNE O 33.96 3,998.64 KWIK KAR LUBE & TUNE O PC 2037 08/26/2014 7/29-8/26/14 PCards KWIK KAR LUBE & TUNE O 39.75 4,038.39 KWIK KAR LUBE & TUNE O PC 1973 08/27/2014 Aug A/P 2007 Dodge 2500, Brakes, AC Co 550.98 4,589.37 MICHAEL G. WATSON 34099 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 967.04 4,589.37 ** 5,000.00 Budgeted 410.63 Remaining 92 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 248.33 .00 248.33 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 248.33 ** 2,500.00 Budgeted 2,251.67 Remaining 10 % Used Account: 135-55135-010-000 Lab Analysis 2037 08/26/2014 7/29-8/26/14 PCards RANDALLS STORE00017897 3,816.24 4.78 3,821.02 RANDALLS STORE00017897 PC _______________ Account: 135-55135-010-000 Lab Analysis Totals: 4.78 3,821.02 ** 5,500.00 Budgeted 1,678.98 Remaining 69 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1972 08/27/2014 Aug A/P Shi, Charter, Verizon 3,831.33 380.08 4,211.41 TOWN OF TROPHY CLUB 34158 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 380.08 4,211.41 ** 4,913.00 Budgeted 701.59 Remaining 86 % Used Account: 135-60020-010-000 Electricity 1944 08/19/2014 Aug A/P Electricity 7/14-8/12/14 107,333.58 73.18 107,406.76 HUDSON ENERGY SERVICES, LLC 34085 AP 1944 08/19/2014 Aug A/P Electricity 7/15-8/13/14 3,717.02 111,123.78 HUDSON ENERGY SERVICES, LLC 34085 AP 1972 08/27/2014 Aug A/P Electricity 7/15-8/13/14 15,302.69 126,426.47 HUDSON ENERGY SERVICES, LLC 34124 AP _______________ Account: 135-60020-010-000 Electricity Totals: 19,092.89 126,426.47 ** 155,160.00 Budgeted 28,733.53 Remaining 81 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 1907 08/12/2014 Void A/P ck 33914 AWWA AWWA Standards 2,715.66 (2,715.66) .00 AMERICAN WATER WORKS ASSOC 33914 AP 1914 08/13/2014 Aug A/P AWWA Standards 2,715.66 2,715.66 AMERICAN WATER WORKS ASSOC 34058 AP _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 2,715.66 ** 2,538.00 Budgeted (177.66) Remaining 107 % Used Account: 135-60070-010-000 Dues & Memberships 289.00 .00 289.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 289.00 ** 300.00 Budgeted 11.00 Remaining 96 % Used Account: 135-60080-010-000 Schools & Training 1,782.00 .00 1,782.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 1,782.00 ** 1,500.00 Budgeted (282.00) Remaining 119 % Used Account: 135-60090-010-000 Safety Program 2037 08/26/2014 7/29-8/26/14 PCards DONUT HAVEN 27.83 27.83 DONUT HAVEN PC _______________ Account: 135-60090-010-000 Safety Program Totals: 27.83 27.83 ** .00 Budgeted (27.83) Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 237.48 .00 237.48 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 237.48 ** 279.00 Budgeted 41.52 Remaining 85 % Used Account: 135-60105-010-000 Rent/Lease Equipment 2065 08/31/2014 Aug A/P Lease/Nitrogen bottles 60.00 36.00 96.00 ALLIED WELDING SUPPLY, INC 34105 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 36.00 96.00 ** 500.00 Budgeted 404.00 Remaining 19 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 37,077.89 .00 37,077.89 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 37,077.89 ** 47,400.00 Budgeted 10,322.11 Remaining 78 % Used Account: 135-60150-010-000 Wholesale Water 2056 08/31/2014 Aug A/P Wholesale Water 1,318,029.14 197,239.53 1,515,268.67 CITY OF FORT WORTH 34113 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 197,239.53 1,515,268.67 ** 2,338,473.00 Budgeted 823,204.33 Remaining 65 % 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 2045 08/26/2014 Recode Cap Repair to Prop Main Tex Turf, Denton Sand & Gravel 1,439.55 241.30 1,680.85 GL _______________ Account: 135-60280-010-000 Property Maintenance Totals: 241.30 1,680.85 ** 3,500.00 Budgeted 1,819.15 Remaining 48 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 1,664.20 .00 1,664.20 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 1,664.20 ** 2,000.00 Budgeted 335.80 Remaining 83 % Used Account: 135-65005-010-000 Fuel & Lube 2037 08/26/2014 7/29-8/26/14 PCards CHEVRON 0204503 10,669.82 51.36 10,721.18 CHEVRON 0204503 PC 2037 08/26/2014 7/29-8/26/14 PCards J & N SUPPLY COMPANY 237.89 10,959.07 J & N SUPPLY COMPANY PC 2016 08/31/2014 MUD August Gas Log 1,543.15 12,502.22 GL 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (118.94) 12,383.28 AR 2055 08/31/2014 Adj Fuel to Stick equivalents 718.16 13,101.44 GL 2055 08/31/2014 Adj Fuel to Stick equivalents (60.62) 13,040.82 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 2,371.00 13,040.82 ** 22,181.00 Budgeted 9,140.18 Remaining 59 % Used Account: 135-65010-010-000 Uniforms 1,938.58 .00 1,938.58 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,938.58 ** 2,500.00 Budgeted 561.42 Remaining 78 % Used Account: 135-65030-010-000 Chemicals 2056 08/31/2014 Aug A/P Chlorine 7,292.49 624.53 7,917.02 DPC INDUSTRIES, INC 34118 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 624.53 7,917.02 ** 5,000.00 Budgeted (2,917.02) Remaining 158 % Used Account: 135-65035-010-000 Small Tools 2037 08/26/2014 7/29-8/26/14 PCards ROANOKE WINNELSON CO 490.92 97.08 588.00 ROANOKE WINNELSON CO PC _______________ Account: 135-65035-010-000 Small Tools Totals: 97.08 588.00 ** 1,200.00 Budgeted 612.00 Remaining 49 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65040-010-000 Safety Equipment 344.55 .00 344.55 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 344.55 ** 1,000.00 Budgeted 655.45 Remaining 34 % Used Account: 135-65050-010-000 Meter Expense 1914 08/13/2014 Aug A/P Meter Heads 76,145.04 465.00 76,610.04 ATLAS UTILITY SUPPLY CO. 34059 AP 1914 08/13/2014 Aug A/P Meter Heads 6,200.00 82,810.04 ATLAS UTILITY SUPPLY CO. 34059 AP 1972 08/27/2014 Aug A/P Water meters 8,925.00 91,735.04 ATLAS UTILITY SUPPLY CO. 34106 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 15,590.00 91,735.04 ** 143,550.00 Budgeted 51,814.96 Remaining 64 % Used Account: 135-69005-010-000 Capital Outlays 35,679.59 .00 35,679.59 _______________ Account: 135-69005-010-000 Capital Outlays Totals: .00 35,679.59 ** 35,681.00 Budgeted 1.41 Remaining 100 % Used Account: 135-69008-010-000 Short Term Debt-Principal 122,980.00 .00 122,980.00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 122,980.00 ** 489,980.00 Budgeted 367,000.00 Remaining 25 % Used Account: 135-69009-010-000 Short Term Debt-Interest 11,621.26 .00 11,621.26 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 11,621.26 ** 19,268.00 Budgeted 7,646.74 Remaining 60 % Used Account: 135-69280-010-000 Capital Repairs 2037 08/26/2014 7/29-8/26/14 PCards DENTON SAND & GRAVEL, 108.00 108.00 DENTON SAND & GRAVEL, PC 2037 08/26/2014 7/29-8/26/14 PCards DENTON SAND & GRAVEL, 108.00 216.00 DENTON SAND & GRAVEL, PC 2037 08/26/2014 7/29-8/26/14 PCards TEX-TURF 25.30 241.30 TEX-TURF PC 2045 08/26/2014 Recode Cap Repair to Prop Main Tex Turf, Denton Sand & Gravel (241.30) .00 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 100,816.54 ** 100,847.00 Budgeted 30.46 Remaining 100 % Used Account: 135-55135-010-001 Lab Analysis for PID 2065 08/31/2014 Aug A/P DBP2 Testing 3,182.24 97.63 3,279.87 LOWER COLORADO RIVER AUTHORITY 34134 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 97.63 3,279.87 ** 2,000.00 Budgeted (1,279.87) Remaining 164 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID 2,496.19 .00 2,496.19 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 2,496.19 ** 5,000.00 Budgeted 2,503.81 Remaining 50 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,527,733.65 ** 3,899,140.00 Budgeted 1,371,406.35 Remaining 65 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2014 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 1786 08/01/2014 PR 08-01-2014 Salaries & Wages 156,168.73 7,785.51 163,954.24 PR 1904 08/15/2014 MUD Payroll 8/15/14 Salaries & Wages 7,785.51 171,739.75 PR 1961 08/29/2014 MUD Payroll 8/29/14 Salaries & Wages 7,785.51 179,525.26 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 23,356.53 179,525.26 ** 202,894.00 Budgeted 23,368.74 Remaining 88 % Used Account: 135-50010-020-000 Overtime 1786 08/01/2014 PR 08-01-2014 Overtime 11,517.36 380.07 11,897.43 PR 1904 08/15/2014 MUD Payroll 8/15/14 Overtime 62.40 11,959.83 PR 1961 08/29/2014 MUD Payroll 8/29/14 Overtime 531.93 12,491.76 PR _______________ Account: 135-50010-020-000 Overtime Totals: 974.40 12,491.76 ** 11,965.00 Budgeted (526.76) Remaining 104 % Used Account: 135-50016-020-000 Longevity 2,997.50 .00 2,997.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,997.50 ** 2,998.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 1904 08/15/2014 MUD Payroll 8/15/14 Certification 4,000.00 400.00 4,400.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 4,400.00 ** 4,800.00 Budgeted 400.00 Remaining 92 % Used Account: 135-50020-020-000 Retirement 1786 08/01/2014 PR 08-01-2014 Retirement 16,154.94 733.26 16,888.20 PR 1904 08/15/2014 MUD Payroll 8/15/14 Retirement 740.66 17,628.86 PR 1961 08/29/2014 MUD Payroll 8/29/14 Retirement 746.92 18,375.78 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,220.84 18,375.78 ** 19,905.00 Budgeted 1,529.22 Remaining 92 % Used Account: 135-50026-020-000 Medical Insurance 1786 08/01/2014 PR 08-01-2014 Medical Insurance 33,814.84 1,713.39 35,528.23 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1904 08/15/2014 MUD Payroll 8/15/14 Medical Insurance 33,814.84 1,713.37 37,241.60 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,426.76 37,241.60 ** 43,471.00 Budgeted 6,229.40 Remaining 86 % Used Account: 135-50027-020-000 Dental Insurance 1786 08/01/2014 PR 08-01-2014 Dental Insurance 2,159.04 105.68 2,264.72 PR 1904 08/15/2014 MUD Payroll 8/15/14 Dental Insurance 105.70 2,370.42 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 211.38 2,370.42 ** 2,989.00 Budgeted 618.58 Remaining 79 % Used Account: 135-50028-020-000 Vision Insurance 1786 08/01/2014 PR 08-01-2014 Vision Insurance 508.61 25.61 534.22 PR 1904 08/15/2014 MUD Payroll 8/15/14 Vision Insurance 25.65 559.87 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 51.26 559.87 ** 658.00 Budgeted 98.13 Remaining 85 % Used Account: 135-50029-020-000 Life Insurance & Other 1764 08/01/2014 Aug A/P Dental and Other Insurances 1,831.42 158.73 1,990.15 METLIFE 34004 AP 1972 08/27/2014 Aug A/P Café 125 Monthly adm fee 30.56 2,020.71 BenefitMall 34108 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 189.29 2,020.71 ** 2,303.00 Budgeted 282.29 Remaining 88 % Used Account: 135-50030-020-000 Social Security Taxes 1786 08/01/2014 PR 08-01-2014 Social Security Taxes 9,812.32 434.27 10,246.59 PR 1904 08/15/2014 MUD Payroll 8/15/14 Social Security Taxes 425.32 10,671.91 PR 1961 08/29/2014 MUD Payroll 8/29/14 Social Security Taxes 530.10 11,202.01 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,389.69 11,202.01 ** 13,805.00 Budgeted 2,602.99 Remaining 81 % Used Account: 135-50035-020-000 Medicare Taxes 1786 08/01/2014 PR 08-01-2014 Medicare Taxes 2,294.82 101.56 2,396.38 PR 1904 08/15/2014 MUD Payroll 8/15/14 Medicare Taxes 99.47 2,495.85 PR 1961 08/29/2014 MUD Payroll 8/29/14 Medicare Taxes 123.97 2,619.82 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 325.00 2,619.82 ** 3,229.00 Budgeted 609.18 Remaining 81 % Used Account: 135-50040-020-000 Unemployment Taxes 828.00 .00 828.00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 828.00 ** 828.00 Budgeted .00 Remaining 100 % Used Account: 135-50045-020-000 Workman's Compensation 58 08/01/2014 Aug Ins & W/C Expense 5,350.80 535.08 5,885.88 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 5,885.88 ** 6,552.00 Budgeted 666.12 Remaining 90 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 63.00 .00 63.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 63.00 ** 150.00 Budgeted 87.00 Remaining 42 % Used Account: 135-50070-020-000 Employee Relations 2037 08/26/2014 7/29-8/26/14 PCards TRE TRATTORIA DOWN 132.57 26.24 158.81 TRE TRATTORIA DOWN PC 2037 08/26/2014 7/29-8/26/14 PCards CHARLIE WANTS A BUR 12.97 171.78 CHARLIE WANTS A BUR PC 2037 08/26/2014 7/29-8/26/14 PCards CHIPOTLE 1758 16.67 188.45 CHIPOTLE 1758 PC 2037 08/26/2014 7/29-8/26/14 PCards WAXY OCONNORS IRISHPUB 15.78 204.23 WAXY OCONNORS IRISHPUB PC 2037 08/26/2014 7/29-8/26/14 PCards CHARLIE WANTS A BUR 11.73 215.96 CHARLIE WANTS A BUR PC 2037 08/26/2014 7/29-8/26/14 PCards HYATT REGENCY SANANT F 9.20 225.16 HYATT REGENCY SANANT F PC 2037 08/26/2014 7/29-8/26/14 PCards DENNY'S INC 10.66 235.82 DENNY'S INC PC 2037 08/26/2014 7/29-8/26/14 PCards PAPPADEAUX SEAFOOD KIT 38.86 274.68 PAPPADEAUX SEAFOOD KIT PC 2037 08/26/2014 7/29-8/26/14 PCards CASA RIO MEXICAN FOODS 36.56 311.24 CASA RIO MEXICAN FOODS PC 2037 08/26/2014 7/29-8/26/14 PCards SCHLOTZSKY'S 1149 8.10 319.34 SCHLOTZSKY'S 1149 PC 2037 08/26/2014 7/29-8/26/14 PCards TROPHY CLUB PARK 1.00 320.34 TROPHY CLUB PARK PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 187.77 320.34 ** 350.00 Budgeted 29.66 Remaining 92 % Used Account: 135-55070-020-000 Independent Labor . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1917 08/14/2014 Aug A/P Lift Station 2 Drainage 799,388.84 4,280.00 803,668.84 THE WALLACE GROUP, INC. 34081 AP 2056 08/31/2014 Aug A/P WWTP Improvement 51,388.81 855,057.65 THE WALLACE GROUP, INC. 34156 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 55,668.81 855,057.65 ** 880,000.00 Budgeted 24,942.35 Remaining 97 % Used Account: 135-55080-020-000 Maintenance & Repairs 2037 08/26/2014 7/29-8/26/14 PCards THE REYNOLDS COMPANY 34,695.17 91.60 34,786.77 THE REYNOLDS COMPANY PC 2056 08/31/2014 Aug A/P Trouble shoot Alarm on Clarifi 381.00 35,167.77 XYLEM WATER SOLUTIONS USA INC 34165 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 472.60 35,167.77 ** 36,120.00 Budgeted 952.23 Remaining 97 % Used Account: 135-55090-020-000 Vehicle Maintenance 2037 08/26/2014 7/29-8/26/14 PCards BLAGG TIRE SERVICE 1,665.48 306.60 1,972.08 BLAGG TIRE SERVICE PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 306.60 1,972.08 ** 2,000.00 Budgeted 27.92 Remaining 99 % Used Account: 135-55125-020-000 Dumpster Services 1914 08/13/2014 Aug A/P Rejected loads & storage 42,900.35 1,140.00 44,040.35 L.H. CHANEY MATERIALS, INC. 34071 AP 2056 08/31/2014 Aug A/P Sludge Haul off 878.13 44,918.48 L.H. CHANEY MATERIALS, INC. 34132 AP 2056 08/31/2014 Aug A/P Sludge Haul off 762.56 45,681.04 L.H. CHANEY MATERIALS, INC. 34132 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,780.69 45,681.04 ** 47,000.00 Budgeted 1,318.96 Remaining 97 % Used Account: 135-55135-020-000 Lab Analysis 1917 08/14/2014 Aug A/P Testing 21,916.08 276.00 22,192.08 OXIDOR LABORATORIES LLC 34075 AP 1917 08/14/2014 Aug A/P Testing 176.00 22,368.08 OXIDOR LABORATORIES LLC 34075 AP 1917 08/14/2014 Aug A/P Testing 246.00 22,614.08 OXIDOR LABORATORIES LLC 34075 AP 1917 08/14/2014 Aug A/P Testing 176.00 22,790.08 OXIDOR LABORATORIES LLC 34075 AP 2056 08/31/2014 Aug A/P Testing 246.00 23,036.08 OXIDOR LABORATORIES LLC 34143 AP 2056 08/31/2014 Aug A/P Testing 176.00 23,212.08 OXIDOR LABORATORIES LLC 34143 AP 2056 08/31/2014 Aug A/P Testing 246.00 23,458.08 OXIDOR LABORATORIES LLC 34143 AP 2056 08/31/2014 Aug A/P Testing 176.00 23,634.08 OXIDOR LABORATORIES LLC 34143 AP 2056 08/31/2014 Aug A/P Testing 246.00 23,880.08 OXIDOR LABORATORIES LLC 34143 AP 2056 08/31/2014 Aug A/P Testing 176.00 24,056.08 OXIDOR LABORATORIES LLC 34143 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,140.00 24,056.08 ** 30,000.00 Budgeted 5,943.92 Remaining 80 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 2037 08/26/2014 7/29-8/26/14 PCards AT&T D17F 7414 2,756.35 19.00 2,775.35 AT&T D17F 7414 PC 1972 08/27/2014 Aug A/P Shi, Charter, Verizon 304.08 3,079.43 TOWN OF TROPHY CLUB 34158 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 323.08 3,079.43 ** 3,329.00 Budgeted 249.57 Remaining 93 % Used Account: 135-60020-020-000 Electricity 1944 08/19/2014 Aug A/P Electricity 7/15-8/13/14 89,049.70 9,709.54 98,759.24 HUDSON ENERGY SERVICES, LLC 34085 AP _______________ Account: 135-60020-020-000 Electricity Totals: 9,709.54 98,759.24 ** 138,227.00 Budgeted 39,467.76 Remaining 71 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 351.00 .00 351.00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 351.00 ** 400.00 Budgeted 49.00 Remaining 88 % Used Account: 135-60080-020-000 Schools & Training 1,347.00 .00 1,347.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 1,347.00 ** 1,636.00 Budgeted 289.00 Remaining 82 % Used Account: 135-60090-020-000 Safety Program 474.07 .00 474.07 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 474.07 ** 500.00 Budgeted 25.93 Remaining 95 % Used Account: 135-60100-020-000 Travel & per diem 2056 08/31/2014 Aug A/P Bush Toll/trip to lab 1,088.73 4.82 1,093.55 NTTA 34140 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60100-020-000 Travel & per diem Totals: 4.82 1,093.55 ** 1,050.00 Budgeted (43.55) Remaining 104 % Used Account: 135-60105-020-000 Rent/Lease Equipment 299.53 .00 299.53 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 299.53 ** 1,500.00 Budgeted 1,200.47 Remaining 20 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 8,919.00 .00 8,919.00 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 8,919.00 ** 17,150.00 Budgeted 8,231.00 Remaining 52 % Used Account: 135-60243-020-000 Prior Year Expense 3,554.22 .00 3,554.22 _______________ Account: 135-60243-020-000 Prior Year Expense Totals: .00 3,554.22 ** 3,554.00 Budgeted (.22) Remaining 100 % Used Account: 135-60245-020-000 Miscellaneous Expenses 2037 08/26/2014 7/29-8/26/14 PCards CFW PARKING METER 4.67 4.67 CFW PARKING METER PC _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: 4.67 4.67 ** 200.00 Budgeted 195.33 Remaining 2 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 1,079.10 .00 1,079.10 . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 1,079.10 ** 1,079.00 Budgeted (.10) Remaining 100 % Used Account: 135-65005-020-000 Fuel & Lube 2037 08/26/2014 7/29-8/26/14 PCards SHELL OIL 575413071QPS 9,346.37 72.70 9,419.07 SHELL OIL 575413071QPS PC 2016 08/31/2014 MUD August Gas Log 1,116.17 10,535.24 GL 2055 08/31/2014 Adj Fuel to Stick equivalents 718.16 11,253.40 GL 2055 08/31/2014 Adj Fuel to Stick equivalents (60.61) 11,192.79 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,846.42 11,192.79 ** 13,600.00 Budgeted 2,407.21 Remaining 82 % Used Account: 135-65010-020-000 Uniforms 2056 08/31/2014 Aug A/P Tshirts, Jacket 1,437.27 230.50 1,667.77 PANDA EMBROIDERY 34144 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 230.50 1,667.77 ** 1,752.00 Budgeted 84.23 Remaining 95 % Used Account: 135-65030-020-000 Chemicals 1917 08/14/2014 Aug A/P Clarifloc C 20,892.10 2,160.00 23,052.10 POLYDYNE, INC 34076 AP 2037 08/26/2014 7/29-8/26/14 PCards HARCROS CHEMICALS INC 2,240.00 25,292.10 HARCROS CHEMICALS INC PC _______________ Account: 135-65030-020-000 Chemicals Totals: 4,400.00 25,292.10 ** 31,000.00 Budgeted 5,707.90 Remaining 82 % Used Account: 135-65035-020-000 Small Tools 346.09 .00 346.09 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 346.09 ** 300.00 Budgeted (46.09) Remaining 115 % Used Account: 135-65040-020-000 Safety Equipment 277.86 .00 277.86 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 277.86 ** 500.00 Budgeted 222.14 Remaining 56 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65045-020-000 Lab Supplies 2037 08/26/2014 7/29-8/26/14 PCards HACH COMPANY 10,004.02 393.74 10,397.76 HACH COMPANY PC 2037 08/26/2014 7/29-8/26/14 PCards HACH COMPANY 78.06 10,475.82 HACH COMPANY PC 2037 08/26/2014 7/29-8/26/14 PCards IDEXX DISTRIBUTION INC 1,179.48 11,655.30 IDEXX DISTRIBUTION INC PC 2037 08/26/2014 7/29-8/26/14 PCards IDEXX DISTRIBUTION INC 160.59 11,815.89 IDEXX DISTRIBUTION INC PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,811.87 11,815.89 ** 15,000.00 Budgeted 3,184.11 Remaining 79 % Used Account: 135-69008-020-000 Short Term Debt-Principal 20,020.00 .00 20,020.00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 20,020.00 ** 20,020.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-020-000 Short Term Debt-Interest 1,043.70 .00 1,043.70 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 1,043.70 ** 1,422.00 Budgeted 378.30 Remaining 73 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,433,453.58 ** 1,564,486.00 Budgeted 131,032.42 Remaining 92 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2014 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-021-000 Salaries & Wages 1786 08/01/2014 PR 08-01-2014 Salaries & Wages 60,652.79 3,434.64 64,087.43 PR 1904 08/15/2014 MUD Payroll 8/15/14 Salaries & Wages 3,434.64 67,522.07 PR 1961 08/29/2014 MUD Payroll 8/29/14 Salaries & Wages 3,434.64 70,956.71 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 10,303.92 70,956.71 ** 90,299.00 Budgeted 19,342.29 Remaining 79 % Used Account: 135-50010-021-000 Overtime 1786 08/01/2014 PR 08-01-2014 Overtime 5,359.84 123.94 5,483.78 PR 1904 08/15/2014 MUD Payroll 8/15/14 Overtime 984.06 6,467.84 PR 1961 08/29/2014 MUD Payroll 8/29/14 Overtime 1,117.85 7,585.69 PR _______________ Account: 135-50010-021-000 Overtime Totals: 2,225.85 7,585.69 ** 10,028.00 Budgeted 2,442.31 Remaining 76 % Used Account: 135-50016-021-000 Longevity 2,107.50 .00 2,107.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 2,107.50 ** 2,108.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 1904 08/15/2014 MUD Payroll 8/15/14 Certification 1,500.00 150.00 1,650.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,650.00 ** 1,800.00 Budgeted 150.00 Remaining 92 % Used Account: 135-50020-021-000 Retirement 1786 08/01/2014 PR 08-01-2014 Retirement 6,606.89 319.56 6,926.45 PR 1904 08/15/2014 MUD Payroll 8/15/14 Retirement 410.27 7,336.72 PR 1961 08/29/2014 MUD Payroll 8/29/14 Retirement 408.81 7,745.53 PR _______________ Account: 135-50020-021-000 Retirement Totals: 1,138.64 7,745.53 ** 9,025.00 Budgeted 1,279.47 Remaining 86 % Used Account: 135-50026-021-000 Medical Insurance 1786 08/01/2014 PR 08-01-2014 Medical Insurance 15,568.69 736.86 16,305.55 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1904 08/15/2014 MUD Payroll 8/15/14 Medical Insurance 15,568.69 736.84 17,042.39 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,473.70 17,042.39 ** 23,668.00 Budgeted 6,625.61 Remaining 72 % Used Account: 135-50027-021-000 Dental Insurance 1786 08/01/2014 PR 08-01-2014 Dental Insurance 1,120.59 51.30 1,171.89 PR 1904 08/15/2014 MUD Payroll 8/15/14 Dental Insurance 51.30 1,223.19 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 102.60 1,223.19 ** 1,703.00 Budgeted 479.81 Remaining 72 % Used Account: 135-50028-021-000 Vision Insurance 1786 08/01/2014 PR 08-01-2014 Vision Insurance 241.61 11.84 253.45 PR 1904 08/15/2014 MUD Payroll 8/15/14 Vision Insurance 11.84 265.29 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 23.68 265.29 ** 314.00 Budgeted 48.71 Remaining 84 % Used Account: 135-50029-021-000 Life Insurance & Other 1764 08/01/2014 Aug A/P Dental and Other Insurances 830.49 72.75 903.24 METLIFE 34004 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 72.75 903.24 ** 1,066.00 Budgeted 162.76 Remaining 85 % Used Account: 135-50030-021-000 Social Security Taxes 1786 08/01/2014 PR 08-01-2014 Social Security Taxes 4,162.12 202.55 4,364.67 PR 1904 08/15/2014 MUD Payroll 8/15/14 Social Security Taxes 268.71 4,633.38 PR 1961 08/29/2014 MUD Payroll 8/29/14 Social Security Taxes 341.28 4,974.66 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 812.54 4,974.66 ** 7,442.00 Budgeted 2,467.34 Remaining 67 % Used Account: 135-50035-021-000 Medicare Taxes 1786 08/01/2014 PR 08-01-2014 Medicare Taxes 973.41 47.36 1,020.77 PR 1904 08/15/2014 MUD Payroll 8/15/14 Medicare Taxes 62.85 1,083.62 PR 1961 08/29/2014 MUD Payroll 8/29/14 Medicare Taxes 79.81 1,163.43 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 190.02 1,163.43 ** 1,741.00 Budgeted 577.57 Remaining 67 % Used Account: 135-50040-021-000 Unemployment Taxes 414.00 .00 414.00 _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 414.00 ** 414.00 Budgeted .00 Remaining 100 % Used Account: 135-50045-021-000 Workman's Compensation 58 08/01/2014 Aug Ins & W/C Expense 2,675.40 267.54 2,942.94 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 2,942.94 ** 3,276.00 Budgeted 333.06 Remaining 90 % Used Account: 135-50070-021-000 Employee Relations 230.28 .00 230.28 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 230.28 ** 200.00 Budgeted (30.28) Remaining 115 % Used Account: 135-55080-021-000 Maintenance & Repairs 13,336.21 .00 13,336.21 _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: .00 13,336.21 ** 14,451.00 Budgeted 1,114.79 Remaining 92 % Used Account: 135-55090-021-000 Vehicle Maintenance 1877 08/05/2014 Aug A/P 2002 Ford F350 Unit 301, 3 tir 999.18 364.56 1,363.74 BLAGG TIRE & SERVICE 34021 AP 2037 08/26/2014 7/29-8/26/14 PCards MUSTANG ELITE CAR WASH 70.99 1,434.73 MUSTANG ELITE CAR WASH PC 2037 08/26/2014 7/29-8/26/14 PCards MUSTANG ELITE CAR WASH 70.99 1,505.72 MUSTANG ELITE CAR WASH PC 2056 08/31/2014 Aug A/P Two front tires/Unit 201 307.70 1,813.42 BLAGG TIRE & SERVICE 34109 AP _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 814.24 1,813.42 ** 2,000.00 Budgeted 186.58 Remaining 91 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1972 08/27/2014 Aug A/P Shi, Charter, Verizon 1,199.76 101.36 1,301.12 TOWN OF TROPHY CLUB 34158 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 101.36 1,301.12 ** 1,333.00 Budgeted 31.88 Remaining 98 % Used Account: 135-60020-021-000 Electricity 1944 08/19/2014 Aug A/P Electricity 6/30-7/29/14 17,262.95 404.57 17,667.52 TRI COUNTY ELECTRIC 34089 AP 1944 08/19/2014 Aug A/P Electricity 6/30-7/29/14 233.18 17,900.70 TRI COUNTY ELECTRIC 34089 AP 1944 08/19/2014 Aug A/P Electricity 6/30-7/29/14 28.21 17,928.91 TRI COUNTY ELECTRIC 34089 AP 1944 08/19/2014 Aug A/P Electricity 7/15-8/13/14 500.59 18,429.50 HUDSON ENERGY SERVICES, LLC 34085 AP 1944 08/19/2014 Aug A/P Electricity 7/15-8/13/14 248.79 18,678.29 HUDSON ENERGY SERVICES, LLC 34085 AP 1944 08/19/2014 Aug A/P Electricity 7/14-8/12/14 56.93 18,735.22 HUDSON ENERGY SERVICES, LLC 34085 AP 1944 08/19/2014 Aug A/P Electricity 7/14-8/12/14 40.44 18,775.66 HUDSON ENERGY SERVICES, LLC 34085 AP 1944 08/19/2014 Aug A/P Electricity 7/15-8/13/14 75.78 18,851.44 HUDSON ENERGY SERVICES, LLC 34085 AP 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (94.12) 18,757.32 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,494.37 18,757.32 ** 21,178.00 Budgeted 2,420.68 Remaining 89 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training 561.00 .00 561.00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 561.00 ** 911.00 Budgeted 350.00 Remaining 62 % Used Account: 135-60090-021-000 Safety Program 35.34 .00 35.34 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 35.34 ** 300.00 Budgeted 264.66 Remaining 12 % Used Account: 135-60100-021-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2037 08/26/2014 7/29-8/26/14 PCards HYATT HOTELS SAN ANTON 707.25 (86.01) 621.24 HYATT HOTELS SAN ANTON PC _______________ Account: 135-60100-021-000 Travel & per diem Totals: (86.01) 621.24 ** 250.00 Budgeted (371.24) Remaining 248 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 2016 08/31/2014 MUD August Gas Log 9,903.16 1,295.75 11,198.91 GL 2055 08/31/2014 Adj Fuel to Stick equivalents 718.15 11,917.06 GL 2055 08/31/2014 Adj Fuel to Stick equivalents (60.61) 11,856.45 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 1,953.29 11,856.45 ** 21,747.00 Budgeted 9,890.55 Remaining 55 % Used Account: 135-65010-021-000 Uniforms 2056 08/31/2014 Aug A/P Tshirts 814.23 172.50 986.73 PANDA EMBROIDERY 34144 AP _______________ Account: 135-65010-021-000 Uniforms Totals: 172.50 986.73 ** 1,040.00 Budgeted 53.27 Remaining 95 % Used Account: 135-65030-021-000 Chemicals 300.89 .00 300.89 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 300.89 ** 2,000.00 Budgeted 1,699.11 Remaining 15 % Used Account: 135-65035-021-000 Small Tools . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 242.99 .00 242.99 _______________ Account: 135-65035-021-000 Small Tools Totals: .00 242.99 ** 300.00 Budgeted 57.01 Remaining 81 % Used Account: 135-65040-021-000 Safety Equipment 586.73 .00 586.73 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 586.73 ** 750.00 Budgeted 163.27 Remaining 78 % Used Account: 135-69005-021-000 Capital Outlays 68,300.20 .00 68,300.20 _______________ Account: 135-69005-021-000 Capital Outlays Totals: .00 68,300.20 ** 114,000.00 Budgeted 45,699.80 Remaining 60 % Used Account: 135-69008-021-000 Short Term Debt-Principal 1773 08/04/2014 August A/P Gap Vax payment 35,991.00 35,991.00 FIRST FINANCIAL BANK 34013 AP _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: 35,991.00 35,991.00 ** 35,991.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-021-000 Short Term Debt-Interest 1773 08/04/2014 August A/P Gap Vax payment 2,822.90 2,822.90 FIRST FINANCIAL BANK 34013 AP _______________ Account: 135-69009-021-000 Short Term Debt-Interest Totals: 2,822.90 2,822.90 ** 2,846.00 Budgeted 23.10 Remaining 99 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 276,718.39 ** 377,531.00 Budgeted 100,812.61 Remaining 73 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/2014 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 1786 08/01/2014 PR 08-01-2014 Salaries & Wages 7,000.00 500.00 7,500.00 PR 1904 08/15/2014 MUD Payroll 8/15/14 Salaries & Wages 500.00 8,000.00 PR 1961 08/29/2014 MUD Payroll 8/29/14 Salaries & Wages 500.00 8,500.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,500.00 8,500.00 ** 10,000.00 Budgeted 1,500.00 Remaining 85 % Used Account: 135-50030-026-000 Social Security Taxes 1786 08/01/2014 PR 08-01-2014 Social Security Taxes 434.00 31.00 465.00 PR 1904 08/15/2014 MUD Payroll 8/15/14 Social Security Taxes 31.00 496.00 PR 1961 08/29/2014 MUD Payroll 8/29/14 Social Security Taxes 31.00 527.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 93.00 527.00 ** 620.00 Budgeted 93.00 Remaining 85 % Used Account: 135-50035-026-000 Medicare Taxes 1786 08/01/2014 PR 08-01-2014 Medicare Taxes 101.50 7.25 108.75 PR 1904 08/15/2014 MUD Payroll 8/15/14 Medicare Taxes 7.25 116.00 PR 1961 08/29/2014 MUD Payroll 8/29/14 Medicare Taxes 7.25 123.25 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 21.75 123.25 ** 145.00 Budgeted 21.75 Remaining 85 % Used Account: 135-50040-026-000 Unemployment Taxes 1786 08/01/2014 PR 08-01-2014 Unemployment Taxes 106.00 11.50 117.50 PR 1904 08/15/2014 MUD Payroll 8/15/14 Unemployment Taxes 11.50 129.00 PR 1961 08/29/2014 MUD Payroll 8/29/14 Unemployment Taxes 11.50 140.50 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 34.50 140.50 ** 230.00 Budgeted 89.50 Remaining 61 % Used Account: 135-50045-026-000 Workman's Compensation 58 08/01/2014 Aug Ins & W/C Expense 29.47 2.94 32.41 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.94 32.41 ** 36.00 Budgeted 3.59 Remaining 90 % Used Account: 135-60066-026-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 35.00 .00 35.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 35.00 ** 500.00 Budgeted 465.00 Remaining 7 % Used Account: 135-60075-026-000 Meetings 2037 08/26/2014 7/29-8/26/14 PCards WEINBERGERS DELI TWO 307.87 59.95 367.82 WEINBERGERS DELI TWO PC 2037 08/26/2014 7/29-8/26/14 PCards RANDALLS STORE00017897 11.00 378.82 RANDALLS STORE00017897 PC 2056 08/31/2014 Aug A/P Coffee, Refreshments for MUD m 16.97 395.79 COSTCO WHOLESALE 34115 AP _______________ Account: 135-60075-026-000 Meetings Totals: 87.92 395.79 ** 1,200.00 Budgeted 804.21 Remaining 33 % Used Account: 135-60080-026-000 Schools & Training 2037 08/26/2014 7/29-8/26/14 PCards TXST CERTIFIED PUB MGR 757.00 200.00 957.00 TXST CERTIFIED PUB MGR PC _______________ Account: 135-60080-026-000 Schools & Training Totals: 200.00 957.00 ** 4,000.00 Budgeted 3,043.00 Remaining 24 % Used Account: 135-60100-026-000 Travel & per diem 41.66 .00 41.66 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 41.66 ** 5,000.00 Budgeted 4,958.34 Remaining 1 % Used Account: 135-60245-026-000 Miscellaneous Expenses 179.40 .00 179.40 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 179.40 ** 1,000.00 Budgeted 820.60 Remaining 18 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 26 Totals: ------------------------------------------------------------------------------------------------ 10,932.01 ** 22,881.00 Budgeted 11,948.99 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 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 1786 08/01/2014 PR 08-01-2014 Salaries & Wages 356,584.41 16,179.76 372,764.17 PR 1914 08/13/2014 Aug A/P Temp Receptionist 640.00 373,404.17 TRINITY EMPLOYMENT SOLUTIONS 34083 AP 1904 08/15/2014 MUD Payroll 8/15/14 Salaries & Wages 16,179.76 389,583.93 PR 1922 08/15/2014 Aug A/P Temp Receptionist 8/4-8/8 640.00 390,223.93 TRINITY EMPLOYMENT SOLUTIONS 34083 AP 1972 08/27/2014 Aug A/P Temp Receptionist 640.00 390,863.93 TRINITY EMPLOYMENT SOLUTIONS 34159 AP 1972 08/27/2014 Aug A/P Temp Receptionist 640.00 391,503.93 TRINITY EMPLOYMENT SOLUTIONS 34159 AP 1961 08/29/2014 MUD Payroll 8/29/14 Salaries & Wages 16,178.14 407,682.07 PR 2056 08/31/2014 Aug A/P Temp Receptionist 640.00 408,322.07 TRINITY EMPLOYMENT SOLUTIONS 34159 AP _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 51,737.66 408,322.07 ** 458,721.00 Budgeted 50,398.93 Remaining 89 % Used Account: 135-50010-030-000 Overtime 1786 08/01/2014 PR 08-01-2014 Overtime 801.55 46.67 848.22 PR 1904 08/15/2014 MUD Payroll 8/15/14 Overtime 22.94 871.16 PR 1961 08/29/2014 MUD Payroll 8/29/14 Overtime 13.12 884.28 PR _______________ Account: 135-50010-030-000 Overtime Totals: 82.73 884.28 ** 750.00 Budgeted (134.28) Remaining 118 % Used Account: 135-50016-030-000 Longevity 3,077.50 .00 3,077.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,077.50 ** 3,018.00 Budgeted (59.50) Remaining 102 % Used Account: 135-50020-030-000 Retirement 1786 08/01/2014 PR 08-01-2014 Retirement 33,169.93 1,457.13 34,627.06 PR 1904 08/15/2014 MUD Payroll 8/15/14 Retirement 1,455.01 36,082.07 PR 1961 08/29/2014 MUD Payroll 8/29/14 Retirement 1,453.97 37,536.04 PR _______________ Account: 135-50020-030-000 Retirement Totals: 4,366.11 37,536.04 ** 41,419.00 Budgeted 3,882.96 Remaining 91 % Used Account: 135-50026-030-000 Medical Insurance 1786 08/01/2014 PR 08-01-2014 Medical Insurance 46,964.90 2,105.76 49,070.66 PR 1904 08/15/2014 MUD Payroll 8/15/14 Medical Insurance 2,105.72 51,176.38 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,211.48 51,176.38 ** 57,923.00 Budgeted 6,746.62 Remaining 88 % Used Account: 135-50027-030-000 Dental Insurance 1786 08/01/2014 PR 08-01-2014 Dental Insurance 3,447.87 153.82 3,601.69 PR 1904 08/15/2014 MUD Payroll 8/15/14 Dental Insurance 153.85 3,755.54 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 307.67 3,755.54 ** 5,100.00 Budgeted 1,344.46 Remaining 74 % Used Account: 135-50028-030-000 Vision Insurance 1786 08/01/2014 PR 08-01-2014 Vision Insurance 818.93 36.26 855.19 PR 1904 08/15/2014 MUD Payroll 8/15/14 Vision Insurance 36.31 891.50 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 72.57 891.50 ** 1,087.00 Budgeted 195.50 Remaining 82 % Used Account: 135-50029-030-000 Life Insurance & Other 1764 08/01/2014 Aug A/P Dental and Other Insurances 3,954.21 284.59 4,238.80 METLIFE 34004 AP 1972 08/27/2014 Aug A/P Rounding Adjustment (.06) 4,238.74 Legal Shield 34098 AP 1972 08/27/2014 Aug A/P Café 125 Monthly adm fee 38.16 4,276.90 BenefitMall 34108 AP 2052 08/31/2014 Premium Rounding Adj (.10) 4,276.80 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 322.59 4,276.80 ** 5,500.00 Budgeted 1,223.20 Remaining 78 % Used Account: 135-50030-030-000 Social Security Taxes 1786 08/01/2014 PR 08-01-2014 Social Security Taxes 21,672.01 950.70 22,622.71 PR 1904 08/15/2014 MUD Payroll 8/15/14 Social Security Taxes 938.49 23,561.20 PR 1961 08/29/2014 MUD Payroll 8/29/14 Social Security Taxes 1,040.92 24,602.12 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,930.11 24,602.12 ** 28,659.00 Budgeted 4,056.88 Remaining 86 % Used Account: 135-50035-030-000 Medicare Taxes 1786 08/01/2014 PR 08-01-2014 Medicare Taxes 5,068.46 222.34 5,290.80 PR 1904 08/15/2014 MUD Payroll 8/15/14 Medicare Taxes 219.51 5,510.31 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1961 08/29/2014 MUD Payroll 8/29/14 Medicare Taxes 5,068.46 243.43 5,753.74 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 685.28 5,753.74 ** 6,702.00 Budgeted 948.26 Remaining 86 % Used Account: 135-50040-030-000 Unemployment Taxes 1,449.00 .00 1,449.00 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 1,449.00 ** 1,449.00 Budgeted .00 Remaining 100 % Used Account: 135-50045-030-000 Workman's Compensation 58 08/01/2014 Aug Ins & W/C Expense 1,286.27 128.62 1,414.89 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.62 1,414.89 ** 1,575.00 Budgeted 160.11 Remaining 90 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 2,732.68 .00 2,732.68 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 2,732.68 ** 5,000.00 Budgeted 2,267.32 Remaining 55 % Used Account: 135-55030-030-000 Software & Support 1944 08/19/2014 Aug A/P BOA PCards-IT 45,074.74 80.98 45,155.72 TOWN OF TROPHY CLUB 34088 AP 1972 08/27/2014 Aug A/P Shi, Charter, Verizon 645.50 45,801.22 TOWN OF TROPHY CLUB 34158 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 726.48 45,801.22 ** 59,698.00 Budgeted 13,896.78 Remaining 77 % Used Account: 135-55070-030-000 Independent Labor . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 8,454.78 .00 8,454.78 _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 8,454.78 ** 7,000.00 Budgeted (1,454.78) Remaining 121 % Used Account: 135-55080-030-000 Maintenance & Repairs 503.45 .00 503.45 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 503.45 ** 4,500.00 Budgeted 3,996.55 Remaining 11 % Used Account: 135-55100-030-000 Building Maint & Supplies 1914 08/13/2014 Aug A/P AC Unit Zone Board/MUD Bldg 2,398.32 578.50 2,976.82 NORTH TX HEATING & AIR, INC 34074 AP 2037 08/26/2014 7/29-8/26/14 PCards THE HOME DEPOT 6581 18.43 2,995.25 THE HOME DEPOT 6581 PC 2037 08/26/2014 7/29-8/26/14 PCards LOCKE SUPPLY WHC DENTO (175.67) 2,819.58 LOCKE SUPPLY WHC DENTO PC 2037 08/26/2014 7/29-8/26/14 PCards LOCKE SUPPLY WHC DENTO 175.67 2,995.25 LOCKE SUPPLY WHC DENTO PC 2037 08/26/2014 7/29-8/26/14 PCards LOCKE SUPPLY WHC DENTO 175.67 3,170.92 LOCKE SUPPLY WHC DENTO PC 2037 08/26/2014 7/29-8/26/14 PCards WM SUPERCENTER #5247 9.96 3,180.88 WM SUPERCENTER #5247 PC 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (480.09) 2,700.79 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 302.47 2,700.79 ** 6,500.00 Budgeted 3,799.21 Remaining 42 % Used Account: 135-55120-030-000 Cleaning Services 1944 08/19/2014 Aug A/P July Janitorial Service 14,354.73 1,594.97 15,949.70 MEMBER'S BUILDING MAINTENANCE 34086 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,594.97 15,949.70 ** 19,140.00 Budgeted 3,190.30 Remaining 83 % Used Account: 135-55160-030-000 Professional Outside Services 500.00 .00 500.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 500.00 ** 10,000.00 Budgeted 9,500.00 Remaining 5 % Used Account: 135-55161-030-000 Town Personnel Contract 77,048.00 .00 77,048.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55161-030-000 Town Personnel Contract Totals: .00 77,048.00 ** 77,048.00 Budgeted .00 Remaining 100 % 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 6,744.24 .00 6,744.24 _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: .00 6,744.24 ** 6,808.00 Budgeted 63.76 Remaining 99 % Used Account: 135-60005-030-000 Telephone 1914 08/13/2014 Aug A/P Answering Service 10,623.90 180.00 10,803.90 KEYSTONE PARK SECRETARIAL 34070 AP 1944 08/19/2014 Aug A/P BOA PCards-IT 889.50 11,693.40 TOWN OF TROPHY CLUB 34088 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,069.50 11,693.40 ** 11,250.00 Budgeted (443.40) Remaining 104 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1904 08/15/2014 MUD Payroll 8/15/14 Communications/Pagers/Mobiles 3,002.59 300.00 3,302.59 PR 1972 08/27/2014 Aug A/P Shi, Charter, Verizon 37.99 3,340.58 TOWN OF TROPHY CLUB 34158 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 337.99 3,340.58 ** 4,057.00 Budgeted 716.42 Remaining 82 % Used Account: 135-60020-030-000 Electricity/Gas 1972 08/27/2014 Aug A/P Ganns, Gexa, Shi, Nevill 11,834.10 916.40 12,750.50 TOWN OF TROPHY CLUB 34158 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 916.40 12,750.50 ** 15,171.00 Budgeted 2,420.50 Remaining 84 % Used Account: 135-60025-030-000 Water . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1972 08/27/2014 Aug A/P Balance due July water 710.14 120.47 830.61 TROPHY CLUB MUD (WATER BILLS) 34103 AP 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (118.27) 712.34 AR 2056 08/31/2014 Aug A/P August Water 236.55 948.89 TROPHY CLUB MUD (WATER BILLS) 34160 AP _______________ Account: 135-60025-030-000 Water Totals: 238.75 948.89 ** 1,500.00 Budgeted 551.11 Remaining 63 % Used Account: 135-60035-030-000 Postage 1944 08/19/2014 Aug A/P JPChase PCards 22,286.83 39.75 22,326.58 TOWN OF TROPHY CLUB 34088 AP 2015 08/31/2014 August MUD Postage Usage 136.84 22,463.42 GL _______________ Account: 135-60035-030-000 Postage Totals: 176.59 22,463.42 ** 28,500.00 Budgeted 6,036.58 Remaining 79 % Used Account: 135-60040-030-000 Service Charges & Fees 2034 08/04/2014 Aug UB Online Credit Card fees 26,880.37 81.97 26,962.34 GL 2034 08/04/2014 Aug UB Online Credit Card fees 102.20 27,064.54 GL 2034 08/04/2014 Aug UB Online Credit Card fees 3,512.12 30,576.66 GL 2019 08/11/2014 FF Bank July Account Analysis 250.00 30,826.66 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,946.29 30,826.66 ** 28,330.00 Budgeted (2,496.66) Remaining 109 % Used Account: 135-60050-030-000 Bad Debt Expense 4,351.64 .00 4,351.64 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 4,351.64 ** 6,200.00 Budgeted 1,848.36 Remaining 70 % Used Account: 135-60055-030-000 Insurance 58 08/01/2014 Aug Ins & W/C Expense 43,025.55 4,269.73 47,295.28 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,269.73 47,295.28 ** 53,561.00 Budgeted 6,265.72 Remaining 88 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 401.08 .00 401.08 . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 401.08 ** 1,000.00 Budgeted 598.92 Remaining 40 % Used Account: 135-60070-030-000 Dues & Memberships 2037 08/26/2014 7/29-8/26/14 PCards TEXAS MUNICIPAL LEAGUE 4,311.95 80.00 4,391.95 TEXAS MUNICIPAL LEAGUE PC 2037 08/26/2014 7/29-8/26/14 PCards TEXAS MUNICIPAL LEAGUE 80.00 4,471.95 TEXAS MUNICIPAL LEAGUE PC 2056 08/31/2014 Aug A/P State of Texas CO-OP Membershi 100.00 4,571.95 STATE COMPTROLLER 34150 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 260.00 4,571.95 ** 4,500.00 Budgeted (71.95) Remaining 102 % Used Account: 135-60075-030-000 Meetings 27.26 .00 27.26 _______________ Account: 135-60075-030-000 Meetings Totals: .00 27.26 ** 400.00 Budgeted 372.74 Remaining 7 % Used Account: 135-60079-030-000 Public Education 274.83 .00 274.83 _______________ Account: 135-60079-030-000 Public Education Totals: .00 274.83 ** 5,000.00 Budgeted 4,725.17 Remaining 5 % Used Account: 135-60080-030-000 Schools & Training 1928 08/15/2014 TCDRS/Seminar refund 2,664.26 (50.01) 2,614.25 GL _______________ Account: 135-60080-030-000 Schools & Training Totals: (50.01) 2,614.25 ** 6,800.00 Budgeted 4,185.75 Remaining 38 % Used Account: 135-60100-030-000 Travel & per diem 1786 08/01/2014 PR 08-01-2014 Travel & per diem 2,976.93 35.00 3,011.93 PR 1914 08/13/2014 Aug A/P Meeting/FW Water and Westlake 34.82 3,046.75 LAURIE SLAGHT 34072 AP 1904 08/15/2014 MUD Payroll 8/15/14 Travel & per diem 45.08 3,091.83 PR 2037 08/26/2014 7/29-8/26/14 PCards FOUR SEASONS AUSTIN F& 10.00 3,101.83 FOUR SEASONS AUSTIN F& PC 2037 08/26/2014 7/29-8/26/14 PCards QUIZNOS #246 19.56 3,121.39 QUIZNOS #246 PC 2037 08/26/2014 7/29-8/26/14 PCards STARBUCKS #06511 LACY 3.84 3,125.23 STARBUCKS #06511 LACY PC 2037 08/26/2014 7/29-8/26/14 PCards PRIMA PIZZA PASTA 43.10 3,168.33 PRIMA PIZZA PASTA PC . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1972 08/27/2014 Aug A/P Mileage Reimbursement 2,976.93 41.63 3,209.96 LAURIE SLAGHT 34097 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 233.03 3,209.96 ** 5,000.00 Budgeted 1,790.04 Remaining 64 % 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 3,709.19 .00 3,709.19 _______________ Account: 135-60115-030-000 Elections Totals: .00 3,709.19 ** 2,500.00 Budgeted (1,209.19) Remaining 148 % Used Account: 135-60125-030-000 Advertising 2065 08/31/2014 Aug A/P Notice of Public Hearing/Tax r 739.43 1,039.50 1,778.93 ALLIANCE REGIONAL NEWSPAPERS 34104 AP _______________ Account: 135-60125-030-000 Advertising Totals: 1,039.50 1,778.93 ** 2,500.00 Budgeted 721.07 Remaining 71 % Used Account: 135-60235-030-000 Security 123.56 .00 123.56 _______________ Account: 135-60235-030-000 Security Totals: .00 123.56 ** 1,350.00 Budgeted 1,226.44 Remaining 9 % Used Account: 135-60245-030-000 Miscellaneous Expenses 2056 08/31/2014 Aug A/P Petty cash reimbursement 2,064.15 2.25 2,066.40 TROPHY CLUB MUD PETTY CASH 34161 AP _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 2.25 2,066.40 ** 17,870.00 Budgeted 15,803.60 Remaining 12 % Used Account: 135-60270-030-000 4th of July Celebration .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,500.00 Budgeted 10,500.00 Remaining 0 % Used Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 16,525.00 .00 16,525.00 _______________ Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) Totals: .00 16,525.00 ** .00 Budgeted (16,525.00) Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 2,563.55 .00 2,563.55 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 2,563.55 ** 2,500.00 Budgeted (63.55) Remaining 103 % Used Account: 135-65010-030-000 Uniforms 998.90 .00 998.90 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 998.90 ** 1,390.00 Budgeted 391.10 Remaining 72 % Used Account: 135-65055-030-000 Hardware 1944 08/19/2014 Aug A/P BOA PCards-IT 7,474.46 318.89 7,793.35 TOWN OF TROPHY CLUB 34088 AP 1972 08/27/2014 Aug A/P Shi, Charter, Verizon 101.75 7,895.10 TOWN OF TROPHY CLUB 34158 AP _______________ Account: 135-65055-030-000 Hardware Totals: 420.64 7,895.10 ** 13,562.00 Budgeted 5,666.90 Remaining 58 % Used Account: 135-65085-030-000 Office Supplies 1944 08/19/2014 Aug A/P JPChase PCards 4,313.92 99.48 4,413.40 TOWN OF TROPHY CLUB 34088 AP 1944 08/19/2014 Aug A/P Office supplies 105.17 4,518.57 OFFICE DEPOT, INC 34087 AP 1944 08/19/2014 Aug A/P Office supplies 9.02 4,527.59 OFFICE DEPOT, INC 34087 AP 2037 08/26/2014 7/29-8/26/14 PCards SIGMA SIGNS & PRINTING 1,125.00 5,652.59 SIGMA SIGNS & PRINTING PC 2037 08/26/2014 7/29-8/26/14 PCards PROBLEM SOLVER (68.25) 5,584.34 PROBLEM SOLVER PC 2039 08/31/2014 Town Billing Inv1196-1205 AR 20140801-20140831 User: (50.47) 5,533.87 AR 2056 08/31/2014 Aug A/P Office Supplies 63.74 5,597.61 OFFICE DEPOT, INC 34141 AP 2056 08/31/2014 Aug A/P Office supplies 281.30 5,878.91 OFFICE DEPOT, INC 34141 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 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: 1,564.99 5,878.91 ** 9,100.00 Budgeted 3,221.09 Remaining 65 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1972 08/27/2014 Aug A/P Ganns, Gexa, Shi, Nevill 4,027.62 295.44 4,323.06 TOWN OF TROPHY CLUB 34158 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 295.44 4,323.06 ** 5,732.00 Budgeted 1,408.94 Remaining 75 % Used Account: 135-65095-030-000 Maintenance Supplies 2037 08/26/2014 7/29-8/26/14 PCards AMAZON.COM 2,486.30 35.57 2,521.87 AMAZON.COM PC 2037 08/26/2014 7/29-8/26/14 PCards WM SUPERCENTER #5247 6.97 2,528.84 WM SUPERCENTER #5247 PC 2037 08/26/2014 7/29-8/26/14 PCards SAMS CLUB #4795 36.82 2,565.66 SAMS CLUB #4795 PC 1972 08/27/2014 Aug A/P Reimb for Sam's/Walmart purcha 249.31 2,814.97 Kari Schultz 34096 AP 2056 08/31/2014 Aug A/P Coffee, Refreshments for MUD m 34.99 2,849.96 COSTCO WHOLESALE 34115 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 363.66 2,849.96 ** 2,500.00 Budgeted (349.96) Remaining 114 % Used Account: 135-65097-030-000 Vending Machine Supplies 76.96 .00 76.96 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 76.96 ** 200.00 Budgeted 123.04 Remaining 38 % Used Account: 135-65105-030-000 Printing 3,424.27 .00 3,424.27 _______________ Account: 135-65105-030-000 Printing Totals: .00 3,424.27 ** 4,000.00 Budgeted 575.73 Remaining 86 % Used Account: 135-69170-030-000 Copier Lease Installments 1972 08/27/2014 Aug A/P Ganns, Gexa, Shi, Nevill 2,054.81 38.81 2,093.62 TOWN OF TROPHY CLUB 34158 AP 1972 08/27/2014 Aug A/P Ganns, Gexa, Shi, Nevill 278.33 2,371.95 TOWN OF TROPHY CLUB 34158 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 317.14 2,371.95 ** 3,450.00 Budgeted 1,078.05 Remaining 69 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 8/2014 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: ------------------------------------------------------------------------------------------------ 902,930.16 ** 1,056,620.00 Budgeted 153,689.84 Remaining 85 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/2014 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 1944 08/19/2014 Aug A/P July Legal/General 376,058.60 34.29 376,092.89 WHITAKER CHALK SWINDLE 34090 AP 1944 08/19/2014 Aug A/P July Legal/TIRZ #2 33.60 376,126.49 WHITAKER CHALK SWINDLE 34090 AP 1944 08/19/2014 Aug A/P July Legal/BDMR 1,777.90 377,904.39 WHITAKER CHALK SWINDLE 34090 AP 1972 08/27/2014 Aug A/P Bond Validation 130,902.33 508,806.72 Fulbright & Jaworski LLP 34121 AP 2056 08/31/2014 Aug A/P August Legal 7,039.46 515,846.18 THE LISTON LAW FIRM, P.C. 34155 AP 2056 08/31/2014 Aug A/P Legal 2,640.00 518,486.18 FREEMAN & CORBETT 34120 AP _______________ Account: 135-55045-039-000 Legal Totals: 142,427.58 518,486.18 ** 347,126.00 Budgeted (171,360.18) Remaining 149 % Used Account: 135-55055-039-000 Auditing 21,200.00 .00 21,200.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 21,200.00 ** 21,840.00 Budgeted 640.00 Remaining 97 % Used Account: 135-55060-039-000 Appraisal 8,158.30 .00 8,158.30 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 8,158.30 ** 10,000.00 Budgeted 1,841.70 Remaining 82 % Used Account: 135-55065-039-000 Tax Admin Fees 2,451.40 .00 2,451.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,451.40 ** 3,800.00 Budgeted 1,348.60 Remaining 65 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 550,295.88 ** 382,766.00 Budgeted (167,529.88) Remaining 144 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 216,043.61 .00 Budgeted (216,043.61) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 8/2014 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 2020 08/31/2014 Bank Interest/August (75.23) (7.60) (82.83) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (7.60) (82.83) ** .00 Budgeted 82.83 Remaining 0 % Used Account: 507-49036-000-000 GASB Reserves (120,000.00) .00 (120,000.00) _______________ Account: 507-49036-000-000 GASB Reserves Totals: .00 (120,000.00) ** .00 Budgeted 120,000.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (120,082.83) ** .00 Budgeted 120,082.83 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter 82,629.40 .00 82,629.40 _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: .00 82,629.40 ** .00 Budgeted (82,629.40) Remaining 0 % Used Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline 1970 08/01/2014 Fain Grp/Retainage App2/Ind Cr 56,622.00 4,026.00 60,648.00 GL 1973 08/27/2014 Aug A/P Indian Creek Waterline App 2 76,494.00 137,142.00 The Fain Group, Inc 34102 AP _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: 80,520.00 137,142.00 ** 282,245.17 Budgeted 145,103.17 Remaining 49 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 219,771.40 ** 282,245.17 Budgeted 62,473.77 Remaining 78 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 99,688.57 282,245.17 Budgeted 182,556.60 Remaining 35 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET AUGUST 2014 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 10,114 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 10,247 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 25,207 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 10,247 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 10,247 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES (2,919) TOTAL FUND BALANCE 14,960 TOTAL LIABILITIES AND FUND BALANCE 25,207 . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 16:40 09/09/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000- Property Taxes 389,216.00- 389,216.00- 291.94- 386,739.74- 99.364 2,476.26- 533-40002-000- Property Taxes/Delinquent 2,500.00- 2,500.00- .33- 459.76- 18.390 2,040.24- 533-40015-000- Property Taxes/P & I 1,600.00- 1,600.00- 38.47- 2,176.18- 136.011 576.18 Subtotal: 393,316.00- 393,316.00- 330.74- 389,375.68- 98.998 3,940.32- 533-48005-000- Reserve Funds/PID Utility Fees 16,525.00- 16,525.00- 16,525.00- 100.000 Subtotal: 16,525.00- 16,525.00- 16,525.00- 100.000 533-49010-000- Interest Income 375.00- 375.00- 13.00- 96.63- 25.768 278.37- 533-49015-000- Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- 100.000 Subtotal: 214,654.00- 214,654.00- 13.00- 214,375.63- 99.870 278.37- Program number: 624,495.00- 624,495.00- 343.74- 620,276.31- 99.324 4,218.69- Department number: Revenues 624,495.00- 624,495.00- 343.74- 620,276.31- 99.324 4,218.69- Revenues Subtotal ----- 624,495.00- 624,495.00- 343.74- 620,276.31- 99.324 4,218.69- . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 16:40 09/09/14 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/2014 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051- Paying Agent Fee/Bond Issuance 2,300.00 2,300.00 1,000.00 43.478 1,300.00 533-70025-051- Bond Interest Expense-Tax 197,195.00 197,195.00 94,028.75 197,195.00 100.000 533-70035-051- Bond Principal Payment-Tax 425,000.00 425,000.00 425,000.00 425,000.00 100.000 Subtotal: 624,495.00 624,495.00 519,028.75 623,195.00 99.792 1,300.00 Program number: 624,495.00 624,495.00 519,028.75 623,195.00 99.792 1,300.00 Department number: Administration 624,495.00 624,495.00 519,028.75 623,195.00 99.792 1,300.00 Expenditures Subtotal ----- 624,495.00 624,495.00 519,028.75 623,195.00 99.792 1,300.00 Fund number: 533 MUD 1 I&S Consolidated 518,685.01 2,918.69 2,918.69- ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/2014 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 2024 08/01/2014 Property Taxes/Assessments (386,447.80) (50.00) (386,497.80) GL 2025 08/05/2014 Property Taxes/Assessments (75.01) (386,572.81) GL 2026 08/08/2014 Property Taxes/Assessments (2.45) (386,575.26) GL 2027 08/18/2014 Property Taxes/Assessments (5.36) (386,580.62) GL 2028 08/19/2014 Property Taxes/Assessments (124.04) (386,704.66) GL 2029 08/21/2014 Property Taxes/Assessments (22.15) (386,726.81) GL 2030 08/22/2014 Property Taxes/Assessments (12.93) (386,739.74) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (291.94) (386,739.74) ** (389,216.00) Budgeted (2,476.26) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 2027 08/18/2014 Property Taxes/Assessments (459.43) (.33) (459.76) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (.33) (459.76) ** (2,500.00) Budgeted (2,040.24) Remaining 18 % Used Account: 533-40015-000-000 Property Taxes/P & I 2025 08/05/2014 Property Taxes/Assessments (2,137.71) (4.93) (2,142.64) GL 2026 08/08/2014 Property Taxes/Assessments (.41) (2,143.05) GL 2027 08/18/2014 Property Taxes/Assessments (4.44) (2,147.49) GL 2028 08/19/2014 Property Taxes/Assessments (23.57) (2,171.06) GL 2029 08/21/2014 Property Taxes/Assessments (4.21) (2,175.27) GL 2030 08/22/2014 Property Taxes/Assessments (.91) (2,176.18) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (38.47) (2,176.18) ** (1,600.00) Budgeted 576.18 Remaining 136 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees (16,525.00) .00 (16,525.00) _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 (16,525.00) ** (16,525.00) Budgeted .00 Remaining 100 % Used Account: 533-49010-000-000 Interest Income 2020 08/31/2014 Bank Interest/August (83.63) (13.00) (96.63) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (13.00) (96.63) ** (375.00) Budgeted (278.37) Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 8/2014 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-49015-000-000 Lease/Rental Income (214,279.00) .00 (214,279.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (214,279.00) ** (214,279.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (620,276.31) ** (624,495.00) Budgeted (4,218.69) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 16:41 09/09/14 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 8/2014 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/Bond Issuance 1,000.00 .00 1,000.00 _______________ Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: .00 1,000.00 ** 2,300.00 Budgeted 1,300.00 Remaining 43 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 2050 08/26/2014 Bond Payments TCMUD1-12 103,166.25 28,525.00 131,691.25 GL 2050 08/26/2014 Bond Payments TCMUD1-13 27,412.50 159,103.75 GL 2050 08/26/2014 Bond Payments TCMUD1-10 38,091.25 197,195.00 GL _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: 94,028.75 197,195.00 ** 197,195.00 Budgeted .00 Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax 2050 08/26/2014 Bond Payments TCMUD1-12 190,000.00 190,000.00 GL 2050 08/26/2014 Bond Payments TCMUD1-13 165,000.00 355,000.00 GL 2050 08/26/2014 Bond Payments TCMUD1-10 70,000.00 425,000.00 GL _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: 425,000.00 425,000.00 ** 425,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 623,195.00 ** 624,495.00 Budgeted 1,300.00 Remaining 100 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ 2,918.69 .00 Budgeted (2,918.69) Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 257,682.71 **** 282,245.17 Budgeted 24,562.46 Remaining 91 % Used ******* End of Report *********