Loading...
HomeMy WebLinkAboutJuly FinancialsTROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JULY 31, 2013 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 770,279 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 16,510 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 1 UTILITY AND OTHER ACCOUNTS RECEIVABLE 2,850 TOTAL ASSETS 789,640 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 16,510 ACCOUNTS AND OTHER PAYABLES 58,231 TOTAL LIABILITIES 74,742 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - UNASSIGNED FUND BALANCE 350,496 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 364,402 TOTAL FUND BALANCE 714,898 TOTAL LIABILITIES AND FUND BALANCE 789,640 . glbase_tbam tsisk Trophy Club MUD #1 Page 1 08:15 08/13/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 252,084.00- 252,084.00- 403.64- 255,003.90- 101.158 2,919.90 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700.00- 700.00- 8,522.94- 8,589.15- 1,227.021 7,889.15 122-40010-000-000 Property Taxes/MUD Fire 1,050,349.00- 1,050,349.00- 2,293.73- 1,054,801.70- 100.424 4,452.70 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 252.43- 2,985.78 -51.479 8,785.78- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 1,682.38- 2,385.44- 318.059 1,635.44 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 174.34- 4,292.71- 95.394 207.29- Subtotal: 1,318,183.00- 1,314,183.00- 13,329.46- 1,322,087.12- 100.601 7,904.12 122-42014-000-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-000 Fire Inspections 500.00- 675.00- 75.00- 1,050.00- 155.556 375.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,500.00- 10,675.00- 75.00- 11,050.00- 103.513 375.00 122-49035-000-000 Prior Year Reserves 5,413.00- 5,413.00- 122-49900-000-000 Miscellaneous Income 1,200.00- 5,200.00- 1,125.00- 8,439.26- 162.293 3,239.26 122-49903-000-000 Recovery of Prior Year Expense 4,340.96- 4,340.96 Subtotal: 1,200.00- 10,613.00- 1,125.00- 12,780.22- 120.420 2,167.22 Program number: 1,335,883.00- 1,341,471.00- 14,929.46- 1,351,117.34- 100.719 9,646.34 Department number: Fire Revenues 1,335,883.00- 1,341,471.00- 14,929.46- 1,351,117.34- 100.719 9,646.34 Revenues Subtotal ----------- 1,335,883.00- 1,341,471.00- 14,929.46- 1,351,117.34- 100.719 9,646.34 . glbase_tbam tsisk Trophy Club MUD #1 Page 2 08:15 08/13/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 444,717.00 444,717.00 35,852.64 347,036.07 78.035 97,680.93 122-50010-045-000 Overtime 31,375.00 37,076.00 1,940.65 31,603.97 85.241 5,472.03 122-50011-045-000 DPS Holiday Pay 13,083.00 12,083.00 12,080.51 99.979 2.49 122-50016-045-000 Longevity 4,266.00 4,266.00 4,266.11 100.003 .11- 122-50017-045-000 Certification 4,896.00 6,024.00 314.25 4,270.84 70.897 1,753.16 122-50020-045-000 Retirement 69,242.00 69,242.00 5,005.57 56,002.16 80.879 13,239.84 122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,458.99 34,589.02 71.573 13,737.98 122-50027-045-000 Dental Insurance 3,635.00 3,836.00 317.53 3,198.86 83.391 637.14 122-50028-045-000 Vision Insurance 824.00 824.00 66.64 661.55 80.285 162.45 122-50029-045-000 Life Insurance & Other 4,250.00 5,974.00 414.25 4,918.21 82.327 1,055.79 122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 2,180.36 23,597.95 76.376 7,299.05 122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 509.89 5,518.80 76.374 1,707.20 122-50040-045-000 Unemployment Taxes 1,481.00 1,980.00 2.50 136.89 6.914 1,843.11 122-50045-045-000 Workman's Compensation 10,000.00 10,000.00 10,274.65 102.747 274.65- 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 283.05 41.933 391.95 122-50075-045-000 Tuition Reimbursement 1,500.00 1,500.00 1,500.00 Subtotal: 676,394.00 684,647.00 50,063.27 538,438.64 78.645 146,208.36 122-55045-045-000 Legal 5,000.00 3,055.72 61.114 1,944.28 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 500.75 7,740.75 80.953 1,821.25 122-55090-045-000 Vehicle Maintenance 14,850.00 14,600.00 345.55 5,522.98 37.829 9,077.02 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 6,518.15 66.457 3,289.85 122-55100-045-000 Building Maintenance 6,500.00 5,500.00 1,020.41 3,987.42 72.499 1,512.58 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 451.30 40.916 651.70 122-55160-045-000 Professional Outside Services 2,500.00 Subtotal: 44,323.00 45,573.00 1,866.71 27,276.32 59.852 18,296.68 122-60005-045-000 Telephone 106.00 106.00 4.84 54.62 51.528 51.38 122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 3,500.00 217.60 3,298.44 94.241 201.56 122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 665.73 6,505.28 105.485 338.28- 122-60025-045-000 Water 1,400.00 1,400.00 282.24 1,192.92 85.209 207.08 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 100.000 122-60035-045-000 Postage 100.00 100.00 .46 41.66 41.660 58.34 122-60055-045-000 Insurance 10,000.00 10,000.00 10,000.00 100.000 122-60066-045-000 Publications/Books/Subscrips 410.00 410.00 410.00 122-60070-045-000 Dues & Memberships 7,500.00 8,000.00 7,955.91 99.449 44.09 122-60075-045-000 Meetings 75.00 75.00 75.00 122-60080-045-000 Schools & Training 5,000.00 5,000.00 85.00 2,782.50 55.650 2,217.50 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 4,800.00 4,800.00 2,789.19 58.108 2,010.81 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 150.00 150.00 122.35 81.567 27.65 . glbase_tbam tsisk Trophy Club MUD #1 Page 3 08:15 08/13/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60160-045-000 Programs & Special Projects 4,200.00 4,200.00 2,415.66 57.516 1,784.34 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 2,150.00 2,381.92 110.787 231.92- 122-60195-045-000 Flags & Repair 2,543.00 2,293.00 1,557.92 67.942 735.08 122-60243-045-000 Prior Year Expense 2,088.00 2,088.44 100.021 .44- 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 600.00 1,184.51 95.757 52.49 Subtotal: 359,088.00 362,676.00 1,855.87 353,371.32 97.434 9,304.68 122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 737.07 5,802.43 58.024 4,197.57 122-65010-045-000 Uniforms 4,357.00 3,357.00 288.35- 1,450.97 43.222 1,906.03 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 315.00 7,060.00 92.895 540.00 122-65030-045-000 Chemicals 1,000.00 1,000.00 21.28 843.28 84.328 156.72 122-65035-045-000 Small Tools 5,000.00 2,400.00 3,369.21 5,169.14 215.381 2,769.14- 122-65085-045-000 Office Supplies 1,200.00 1,200.00 10.71 370.09 30.841 829.91 122-65095-045-000 Maintenance Supplies 2,785.00 1,988.00 464.55 1,723.90 86.715 264.10 122-65105-045-000 Printing 106.00 Subtotal: 32,048.00 27,545.00 4,629.47 22,419.81 81.393 5,125.19 122-69006-045-000 Grant Match 3,000.00 122-69008-045-000 Short Term Debt-Principal 72,932.00 72,932.00 2,966.05 4.067 69,965.95 122-69050-045-000 Radios 2,500.00 2,500.00 353.13 14.125 2,146.87 122-69195-045-000 GASB34/Reserve for Replacement 145,598.00 145,598.00 41,890.00 28.771 103,708.00 Subtotal: 224,030.00 221,030.00 45,209.18 20.454 175,820.82 Program number: 1,335,883.00 1,341,471.00 58,415.32 986,715.27 73.555 354,755.73 Department number: Fire 1,335,883.00 1,341,471.00 58,415.32 986,715.27 73.555 354,755.73 Expenditures Subtotal ----------- 1,335,883.00 1,341,471.00 58,415.32 986,715.27 73.555 354,755.73 Fund number: 122 Trophy Club MUD Fire Dept. 43,485.86 364,402.07- 364,402.07 . glpdatb2 tsisk Trophy Club MUD #1 Page 1 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2013 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 1863 07/02/2013 Property Taxes/Assessments (254,600.26) (97.13) (254,697.39) GL 1864 07/08/2013 Property Taxes/Assessments (174.81) (254,872.20) GL 1865 07/10/2013 Property Taxes/Assessments (46.10) (254,918.30) GL 1968 07/15/2013 Property Taxes/Assessments (67.72) (254,986.02) GL 1973 07/23/2013 Property Taxes/Assessments (17.88) (255,003.90) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (403.64) (255,003.90) ** (252,084.00) Budgeted 2,919.90 Remaining 101 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 1971 07/19/2013 Property Taxes/Assessments (66.21) (8,522.94) (8,589.15) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (8,522.94) (8,589.15) ** (700.00) Budgeted 7,889.15 Remaining ########## Account: 122-40010-000-000 Property Taxes/MUD Fire 1863 07/02/2013 Property Taxes/Assessments (1,052,507.97) (2.33) (1,052,510.30) GL 1864 07/08/2013 Property Taxes/Assessments (238.72) (1,052,749.02) GL 1865 07/10/2013 Property Taxes/Assessments (242.93) (1,052,991.95) GL 1866 07/10/2013 Property Taxes/Assessments (125.96) (1,053,117.91) GL 1967 07/11/2013 Property Taxes/Assessments (57.33) (1,053,175.24) GL 2028 07/11/2013 Correct JE 1967/tax payment .02 (1,053,175.22) GL 1968 07/15/2013 Property Taxes/Assessments (322.54) (1,053,497.76) GL 1969 07/17/2013 Property Taxes/Assessments (111.90) (1,053,609.66) GL 1970 07/18/2013 Property Taxes/Assessments (120.46) (1,053,730.12) GL 1972 07/22/2013 Property Taxes/Assessments (240.44) (1,053,970.56) GL 1973 07/23/2013 Property Taxes/Assessments (76.37) (1,054,046.93) GL 1974 07/24/2013 Property Taxes/Assessments (75.39) (1,054,122.32) GL 2022 07/25/2013 Property Taxes/Assessments (205.20) (1,054,327.52) GL 2023 07/29/2013 Property Taxes/Assessments (222.67) (1,054,550.19) GL 2024 07/30/2013 Property Taxes/Assessments (171.90) (1,054,722.09) GL 2025 07/31/2013 Property Taxes/Assessments (79.61) (1,054,801.70) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (2,293.73) (1,054,801.70) ** (1,050,349.00) Budgeted 4,452.70 Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1968 07/15/2013 Property Taxes/Assessments 3,238.21 (214.66) 3,023.55 GL 1971 07/19/2013 Property Taxes/Assessments (37.77) 2,985.78 GL . glpdatb2 tsisk Trophy Club MUD #1 Page 2 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (252.43) 2,985.78 ** (5,800.00) Budgeted (8,785.78) Remaining -51 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1865 07/10/2013 Property Taxes/Assessments (703.06) (6.92) (709.98) GL 1971 07/19/2013 Property Taxes/Assessments (1,672.24) (2,382.22) GL 1973 07/23/2013 Property Taxes/Assessments (3.22) (2,385.44) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (1,682.38) (2,385.44) ** (750.00) Budgeted 1,635.44 Remaining 318 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1863 07/02/2013 Property Taxes/Assessments (4,118.37) (.35) (4,118.72) GL 1968 07/15/2013 Property Taxes/Assessments (113.56) (4,232.28) GL 1972 07/22/2013 Property Taxes/Assessments (18.61) (4,250.89) GL 1973 07/23/2013 Property Taxes/Assessments (4.90) (4,255.79) GL 2022 07/25/2013 Property Taxes/Assessments (36.92) (4,292.71) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (174.34) (4,292.71) ** (4,500.00) Budgeted (207.29) Remaining 95 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 2049 07/31/2013 Bill Town Inv 1061-1062 AR 20130731-20130731 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 2049 07/31/2013 Bill Town Inv 1061-1062 AR 20130731-20130731 User: (975.00) (75.00) (1,050.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (1,050.00) ** (675.00) Budgeted 375.00 Remaining 156 % 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 . glpdatb2 tsisk Trophy Club MUD #1 Page 3 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (5,413.00) Budgeted (5,413.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 2049 07/31/2013 Bill Town Inv 1061-1062 AR 20130731-20130731 User: (7,314.26) (1,125.00) (8,439.26) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (1,125.00) (8,439.26) ** (5,200.00) Budgeted 3,239.26 Remaining 162 % Used Account: 122-49903-000-000 Recovery of Prior Year Expense (4,340.96) .00 (4,340.96) _______________ Account: 122-49903-000-000 Recovery of Prior Year Expense Totals: .00 (4,340.96) ** .00 Budgeted 4,340.96 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,351,117.34) ** (1,341,471.00) Budgeted 9,646.34 Remaining 101 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 4 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2013 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 1892 07/05/2013 FD Payroll 7/5/13 311,183.43 18,130.55 329,313.98 GL 1893 07/19/2013 FD Payroll 7/19/13 17,722.09 347,036.07 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 35,852.64 347,036.07 ** 444,717.00 Budgeted 97,680.93 Remaining 78 % Used Account: 122-50010-045-000 Overtime 1892 07/05/2013 FD Payroll 7/5/13 29,663.32 1,940.65 31,603.97 GL _______________ Account: 122-50010-045-000 Overtime Totals: 1,940.65 31,603.97 ** 37,076.00 Budgeted 5,472.03 Remaining 85 % Used Account: 122-50011-045-000 DPS Holiday Pay 12,080.51 .00 12,080.51 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 12,080.51 ** 12,083.00 Budgeted 2.49 Remaining 100 % Used Account: 122-50016-045-000 Longevity 4,266.11 .00 4,266.11 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,266.11 ** 4,266.00 Budgeted (.11) Remaining 100 % Used Account: 122-50017-045-000 Certification 1892 07/05/2013 FD Payroll 7/5/13 3,956.59 314.25 4,270.84 GL _______________ Account: 122-50017-045-000 Certification Totals: 314.25 4,270.84 ** 6,024.00 Budgeted 1,753.16 Remaining 71 % Used Account: 122-50020-045-000 Retirement 1892 07/05/2013 FD Payroll 7/5/13 50,996.59 2,680.85 53,677.44 GL 1893 07/19/2013 FD Payroll 7/19/13 2,324.72 56,002.16 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,005.57 56,002.16 ** 69,242.00 Budgeted 13,239.84 Remaining 81 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 5 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 1892 07/05/2013 FD Payroll 7/5/13 31,130.03 1,729.51 32,859.54 GL 1893 07/19/2013 FD Payroll 7/19/13 1,729.48 34,589.02 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,458.99 34,589.02 ** 48,327.00 Budgeted 13,737.98 Remaining 72 % Used Account: 122-50027-045-000 Dental Insurance 1892 07/05/2013 FD Payroll 7/5/13 2,881.33 158.74 3,040.07 GL 1893 07/19/2013 FD Payroll 7/19/13 158.79 3,198.86 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 317.53 3,198.86 ** 3,836.00 Budgeted 637.14 Remaining 83 % Used Account: 122-50028-045-000 Vision Insurance 1892 07/05/2013 FD Payroll 7/5/13 594.91 33.33 628.24 GL 1893 07/19/2013 FD Payroll 7/19/13 33.31 661.55 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 66.64 661.55 ** 824.00 Budgeted 162.45 Remaining 80 % Used Account: 122-50029-045-000 Life Insurance & Other 1892 07/05/2013 FD Payroll 7/5/13 4,503.96 207.16 4,711.12 GL 1893 07/19/2013 FD Payroll 7/19/13 207.09 4,918.21 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 414.25 4,918.21 ** 5,974.00 Budgeted 1,055.79 Remaining 82 % Used Account: 122-50030-045-000 Social Security Taxes 1892 07/05/2013 FD Payroll 7/5/13 21,417.59 1,172.74 22,590.33 GL 1893 07/19/2013 FD Payroll 7/19/13 1,007.62 23,597.95 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,180.36 23,597.95 ** 30,897.00 Budgeted 7,299.05 Remaining 76 % Used Account: 122-50035-045-000 Medicare Taxes 1892 07/05/2013 FD Payroll 7/5/13 5,008.91 274.25 5,283.16 GL 1893 07/19/2013 FD Payroll 7/19/13 235.64 5,518.80 GL . glpdatb2 tsisk Trophy Club MUD #1 Page 6 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 509.89 5,518.80 ** 7,226.00 Budgeted 1,707.20 Remaining 76 % Used Account: 122-50040-045-000 Unemployment Taxes 1892 07/05/2013 FD Payroll 7/5/13 134.39 1.31 135.70 GL 1893 07/19/2013 FD Payroll 7/19/13 1.19 136.89 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 2.50 136.89 ** 1,980.00 Budgeted 1,843.11 Remaining 7 % Used Account: 122-50045-045-000 Workman's Compensation 10,274.65 .00 10,274.65 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 10,274.65 ** 10,000.00 Budgeted (274.65) Remaining 103 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 283.05 .00 283.05 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 283.05 ** 675.00 Budgeted 391.95 Remaining 42 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-55045-045-000 Legal 3,055.72 .00 3,055.72 _______________ Account: 122-55045-045-000 Legal Totals: .00 3,055.72 ** 5,000.00 Budgeted 1,944.28 Remaining 61 % Used Account: 122-55080-045-000 Maintenance & Repairs 1945 07/25/2013 July AP maint & repairs 7,240.00 187.75 7,427.75 AUGUST INDUSTRIES, INC 32810 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 7 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1999 07/31/2013 July A/P equipment repair-rescue truck 7,240.00 313.00 7,740.75 METRO FIRE APPARATUS 32839 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 500.75 7,740.75 ** 9,562.00 Budgeted 1,821.25 Remaining 81 % Used Account: 122-55090-045-000 Vehicle Maintenance 1885 07/17/2013 July AP Q-681 repairs 5,177.43 204.75 5,382.18 SIDDONS-MARTIN EMERGENCY GROUP 32789 AP 1996 07/26/2013 6/27-7/26 PCards MOORE INDUSTRIAL 140.80 5,522.98 MOORE INDUSTRIAL PC _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 345.55 5,522.98 ** 14,600.00 Budgeted 9,077.02 Remaining 38 % Used Account: 122-55095-045-000 Equipment Maintenance 6,518.15 .00 6,518.15 _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: .00 6,518.15 ** 9,808.00 Budgeted 3,289.85 Remaining 66 % Used Account: 122-55100-045-000 Building Maintenance 1979 07/05/2013 PCards 5/27-6/26/13 SAMS MEMBERSHIP 2,967.01 90.00 3,057.01 SAMS MEMBERSHIP PC 1979 07/05/2013 PCards 5/27-6/26/13 ATT*BILL PAYMENT 152.83 3,209.84 ATT*BILL PAYMENT PC 1979 07/05/2013 PCards 5/27-6/26/13 ATT*BILL PAYMENT 133.68 3,343.52 ATT*BILL PAYMENT PC 1979 07/05/2013 PCards 5/27-6/26/13 THE HOME DEPOT 6581 58.42 3,401.94 THE HOME DEPOT 6581 PC 1885 07/17/2013 July AP Mats 24.51 3,426.45 G & K SERVICES 32763 AP 1887 07/17/2013 July A/P Rug Service-FD 24.51 3,450.96 G & K SERVICES 32763 AP 1887 07/17/2013 July A/P Rug Service-FD 24.51 3,475.47 G & K SERVICES 32763 AP 1887 07/17/2013 July A/P Rug Service-FD 24.51 3,499.98 G & K SERVICES 32763 AP 1925 07/22/2013 Bill Town Inv 1055-1058 AR 20130701-20130722 User: (49.02) 3,450.96 AR 1996 07/26/2013 6/27-7/26 PCards ATT*BILL PAYMENT 133.68 3,584.64 ATT*BILL PAYMENT PC 1996 07/26/2013 6/27-7/26 PCards ATT*BILL PAYMENT 152.83 3,737.47 ATT*BILL PAYMENT PC 1996 07/26/2013 6/27-7/26 PCards BARBEQUES GALORE 10149 249.95 3,987.42 BARBEQUES GALORE 10149 PC _______________ Account: 122-55100-045-000 Building Maintenance Totals: 1,020.41 3,987.42 ** 5,500.00 Budgeted 1,512.58 Remaining 72 % Used Account: 122-55110-045-000 Maintenance-Radios 451.30 .00 451.30 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 451.30 ** 1,103.00 Budgeted 651.70 Remaining 41 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 8 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60005-045-000 Telephone 1887 07/17/2013 July A/P BOA PCards 5/28/13-6/27/13 49.78 4.84 54.62 TOWN OF TROPHY CLUB 32803 AP _______________ Account: 122-60005-045-000 Telephone Totals: 4.84 54.62 ** 106.00 Budgeted 51.38 Remaining 52 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1892 07/05/2013 FD Payroll 7/5/13 3,080.84 75.42 3,156.26 GL 1885 07/17/2013 July AP Verizon 142.18 3,298.44 TOWN OF TROPHY CLUB 32803 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 217.60 3,298.44 ** 3,500.00 Budgeted 201.56 Remaining 94 % Used Account: 122-60020-045-000 Electricity/Gas 1925 07/22/2013 Bill Town Inv 1055-1058 AR 20130701-20130722 User: 5,839.55 (635.07) 5,204.48 AR 1934 07/23/2013 Town Billing Inv 1059-1060 AR 20130701-20130723 User: (30.64) 5,173.84 AR 1945 07/25/2013 July AP gas-fire station July bill 61.29 5,235.13 ATMOS ENERGY 32809 AP 1945 07/25/2013 July AP Fire sta elec 6/13-7/15 1,270.15 6,505.28 HUDSON ENERGY SERVICES, LLC 32816 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 665.73 6,505.28 ** 6,167.00 Budgeted (338.28) Remaining 105 % Used Account: 122-60025-045-000 Water 1999 07/31/2013 July A/P water 910.68 103.91 1,014.59 TROPHY CLUB MUD (WATER BILLS) 32840 AP 1999 07/31/2013 July A/P water 178.33 1,192.92 TROPHY CLUB MUD (WATER BILLS) 32840 AP _______________ Account: 122-60025-045-000 Water Totals: 282.24 1,192.92 ** 1,400.00 Budgeted 207.08 Remaining 85 % Used Account: 122-60030-045-000 Rent And/Or Usage 308,000.00 .00 308,000.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 308,000.00 ** 308,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 1913 07/01/2013 June Postage meter usage 41.20 .46 41.66 GL . glpdatb2 tsisk Trophy Club MUD #1 Page 9 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60035-045-000 Postage Totals: .46 41.66 ** 100.00 Budgeted 58.34 Remaining 42 % Used Account: 122-60055-045-000 Insurance 10,000.00 .00 10,000.00 _______________ Account: 122-60055-045-000 Insurance Totals: .00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 410.00 Budgeted 410.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 7,955.91 .00 7,955.91 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 7,955.91 ** 8,000.00 Budgeted 44.09 Remaining 99 % Used Account: 122-60075-045-000 Meetings .00 .00 _______________ Account: 122-60075-045-000 Meetings Totals: .00 .00 ** 75.00 Budgeted 75.00 Remaining 0 % Used Account: 122-60080-045-000 Schools & Training 1999 07/31/2013 July A/P Basic Incident Safety Officer- 2,697.50 85.00 2,782.50 TX COMM ON FIRE PROTECTION 32841 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 85.00 2,782.50 ** 5,000.00 Budgeted 2,217.50 Remaining 56 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 . glpdatb2 tsisk Trophy Club MUD #1 Page 10 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem 2,789.19 .00 2,789.19 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 2,789.19 ** 4,800.00 Budgeted 2,010.81 Remaining 58 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ 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 122.35 .00 122.35 _______________ Account: 122-60125-045-000 Advertising Totals: .00 122.35 ** 150.00 Budgeted 27.65 Remaining 82 % Used Account: 122-60160-045-000 Programs & Special Projects 2,415.66 .00 2,415.66 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 2,415.66 ** 4,200.00 Budgeted 1,784.34 Remaining 58 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 2,381.92 .00 2,381.92 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 2,381.92 ** 2,150.00 Budgeted (231.92) Remaining 111 % Used Account: 122-60195-045-000 Flags & Repair 1,557.92 .00 1,557.92 . glpdatb2 tsisk Trophy Club MUD #1 Page 11 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 1,557.92 ** 2,293.00 Budgeted 735.08 Remaining 68 % Used Account: 122-60243-045-000 Prior Year Expense 2,088.44 .00 2,088.44 _______________ Account: 122-60243-045-000 Prior Year Expense Totals: .00 2,088.44 ** 2,088.00 Budgeted (.44) Remaining 100 % Used Account: 122-60245-045-000 Miscellaneous Expense 1887 07/17/2013 July A/P Fire Truck paying agent fee 584.51 500.00 1,084.51 ZIONS BANK 32806 AP 1996 07/26/2013 6/27-7/26 PCards ROANOKE FLORIST 100.00 1,184.51 ROANOKE FLORIST PC _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 600.00 1,184.51 ** 1,237.00 Budgeted 52.49 Remaining 96 % Used Account: 122-65005-045-000 Fuel & Lube 2050 07/31/2013 July Gas log 5,065.36 737.07 5,802.43 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 737.07 5,802.43 ** 10,000.00 Budgeted 4,197.57 Remaining 58 % Used Account: 122-65010-045-000 Uniforms 1934 07/23/2013 Town Billing Inv 1059-1060 AR 20130701-20130723 User: 1,739.32 (535.65) 1,203.67 AR 1945 07/25/2013 July AP uniforms-fire department 247.30 1,450.97 ALL STAR SCREEN PRINTING & TEE 32808 AP _______________ Account: 122-65010-045-000 Uniforms Totals: (288.35) 1,450.97 ** 3,357.00 Budgeted 1,906.03 Remaining 43 % Used Account: 122-65015-045-000 Protective Clothing 1945 07/25/2013 July AP structure boots-fire departmen 6,745.00 315.00 7,060.00 CASCO INDUSTRIES INC 32812 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 315.00 7,060.00 ** 7,600.00 Budgeted 540.00 Remaining 93 % Used Account: 122-65030-045-000 Chemicals . glpdatb2 tsisk Trophy Club MUD #1 Page 12 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1979 07/05/2013 PCards 5/27-6/26/13 TRACTOR SUPPLY COMPANY 822.00 21.28 843.28 TRACTOR SUPPLY COMPANY PC _______________ Account: 122-65030-045-000 Chemicals Totals: 21.28 843.28 ** 1,000.00 Budgeted 156.72 Remaining 84 % Used Account: 122-65035-045-000 Small Tools 1979 07/05/2013 PCards 5/27-6/26/13 OPTICS PLANET INC 1,799.93 83.78 1,883.71 OPTICS PLANET INC PC 1979 07/05/2013 PCards 5/27-6/26/13 L N CURTIS AND SONS 144.44 2,028.15 L N CURTIS AND SONS PC 1979 07/05/2013 PCards 5/27-6/26/13 TRACTOR SUPPLY COMPANY 29.99 2,058.14 TRACTOR SUPPLY COMPANY PC 1999 07/31/2013 July A/P new fire hose 3,111.00 5,169.14 METRO FIRE APPARATUS 32839 AP _______________ Account: 122-65035-045-000 Small Tools Totals: 3,369.21 5,169.14 ** 2,400.00 Budgeted (2,769.14) Remaining 215 % Used Account: 122-65085-045-000 Office Supplies 1945 07/25/2013 July AP office supplies 359.38 10.71 370.09 OFFICE DEPOT, INC 32822 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 10.71 370.09 ** 1,200.00 Budgeted 829.91 Remaining 31 % Used Account: 122-65095-045-000 Maintenance Supplies 1979 07/05/2013 PCards 5/27-6/26/13 SAMSCLUB #4795 1,259.35 178.82 1,438.17 SAMSCLUB #4795 PC 1996 07/26/2013 6/27-7/26 PCards SAMSCLUB #4795 230.40 1,668.57 SAMSCLUB #4795 PC 1996 07/26/2013 6/27-7/26 PCards SAMSCLUB #4795 55.33 1,723.90 SAMSCLUB #4795 PC _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 464.55 1,723.90 ** 1,988.00 Budgeted 264.10 Remaining 87 % Used Account: 122-69008-045-000 Short Term Debt-Principal 2,966.05 .00 2,966.05 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 2,966.05 ** 72,932.00 Budgeted 69,965.95 Remaining 4 % Used Account: 122-69050-045-000 Radios 353.13 .00 353.13 _______________ Account: 122-69050-045-000 Radios Totals: .00 353.13 ** 2,500.00 Budgeted 2,146.87 Remaining 14 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 13 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 ** 145,598.00 Budgeted 103,708.00 Remaining 29 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 986,715.27 ** 1,341,471.00 Budgeted 354,755.73 Remaining 74 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (364,402.07) .00 Budgeted 364,402.07 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M BALANCE SHEET JULY 31, 2013 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 7/31/13 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 658,877 - - 658,877 INVESTMENTS 2,208,017 313,050 330,548 2,851,616 PREPAID EXPENSES 10,572 - - 10,572 ADVALOREM PROPERTY TAXES RECEIVABLE 2,092 - - 2,092 UTILITY AND OTHER ACCOUNTS RECEIVABLE 847,009 - - 847,009 - TOTAL ASSETS 3,727,167 313,050 330,548 4,370,766 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,092 - - 2,092 ACCOUNTS AND OTHER PAYABLES 239,711 - 6,314 246,025 CUSTOMER DEPOSITS 235,232 - - 235,232 - TOTAL LIABILITIES 477,035 - 6,314 483,349 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 214,249 214,249 ASSIGNED FUND BALANCE 456,156 456,156 UNASSIGNED FUND BALANCE 2,825,965 - 38,101 2,864,066 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES (31,988) 98,801 286,133 352,946 - TOTAL FUND BALANCE 3,250,133 313,050 324,234 3,887,417 - TOTAL LIABILITIES AND FUND BALANCE 3,727,167 313,050 330,548 4,370,766 . glbase_tbam tsisk Trophy Club MUD #1 Page 4 08:15 08/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,884.00- 99,884.00- 221.70- 100,311.14- 100.428 427.14 135-40002-000-000 Property Taxes/Delinquent 500.00- 624.00- 19.43- 297.28 -47.641 921.28- 135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 18.85- 824.66- 68.722 375.34- Subtotal: 101,584.00- 101,708.00- 259.98- 100,838.52- 99.145 869.48- 135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 399,161.94- 2,496,645.64- 70.415 1,048,963.36- 135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 178,594.16- 1,460,926.03- 88.340 192,820.97- 135-47020-000-000 Standby 576.00- 576.00- 149.90- 26.024 426.10- 135-47025-000-000 Penalties 64,580.00- 64,580.00- 4,483.26- 45,997.42- 71.225 18,582.58- 135-47030-000-000 Service Charges 11,625.00- 11,625.00- 1,069.52- 10,302.88- 88.627 1,322.12- 135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 500.00- 1,450.00- 80.556 350.00- 135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 1,500.00- 4,800.00- 92.308 400.00- 135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 15,370.60- 47,262.69- 60.925 30,312.31- 135-47400-000-000 Water-Out of Dist/Port Meters 100.00 Subtotal: 5,360,712.00- 5,360,712.00- 600,579.48- 4,067,534.56- 75.877 1,293,177.44- 135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 46,000.00- 443,900.00- 68.929 200,100.00- Subtotal: 644,000.00- 644,000.00- 46,000.00- 443,900.00- 68.929 200,100.00- 135-49010-000-000 Interest Income 5,500.00- 5,500.00- 236.51- 3,849.70- 69.995 1,650.30- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 9,041.77- 88.959 1,122.23- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,833.30- 83.333 1,166.70- 135-49030-000-000 Vending Revenue 350.00- 350.00- 80.95- 398.41- 113.831 48.41 135-49035-000-000 Prior Year Reserves 305,748.00- 234,014.00- 234,014.00- 135-49075-000-000 Oversize Meter Reimbursement 73,000.00- 73,000.00- 9,510.00- 72,704.69- 99.595 295.31- 135-49141-000-000 Interfund Trans In (Cap Proj) 38,101.00- 38,101.42- 100.001 .42 135-49900-000-000 Miscellaneous Income 1,000.00- 13,213.00- 589.40- 15,562.28- 117.780 2,349.28 135-49901-000-000 Records Management Revenue 109.00- 90.50- 83.028 18.50- 135-49903-000-000 Recovery of Prior Year Expense 11,789.33- 11,789.33 135-49905-000-000 Gas Well Revenue 200.00- 286.00- 663.35- 231.941 377.35 Subtotal: 402,962.00- 381,737.00- 11,910.72- 158,034.75- 41.399 223,702.25- Program number: 6,509,258.00- 6,488,157.00- 658,750.18- 4,770,307.83- 73.523 1,717,849.17- Department number: Revenues 6,509,258.00- 6,488,157.00- 658,750.18- 4,770,307.83- 73.523 1,717,849.17- Revenues Subtotal ----------- 6,509,258.00- 6,488,157.00- 658,750.18- 4,770,307.83- 73.523 1,717,849.17- . glbase_tbam tsisk Trophy Club MUD #1 Page 5 08:15 08/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 213,321.00 213,321.00 13,326.24 133,649.42 62.652 79,671.58 135-50010-010-000 Overtime 13,250.00 19,250.00 593.12 10,636.39 55.254 8,613.61 135-50016-010-000 Longevity 3,080.00 3,080.00 3,080.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 350.00 3,700.00 72.549 1,400.00 135-50020-010-000 Retirement 32,725.00 57,748.00 1,281.39 41,754.14 72.304 15,993.86 135-50026-010-000 Medical Insurance 28,920.00 28,920.00 2,113.96 19,585.24 67.722 9,334.76 135-50027-010-000 Dental Insurance 2,091.00 2,091.00 190.78 1,446.73 69.188 644.27 135-50028-010-000 Vision Insurance 519.00 519.00 41.38 335.61 64.665 183.39 135-50029-010-000 Life Insurance & Other 1,204.00 1,532.00 580.38 1,616.81 105.536 84.81- 135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 871.74 9,434.60 64.820 5,120.40 135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 203.88 2,206.48 64.820 1,197.52 135-50040-010-000 Unemployment Taxes 945.00 945.00 2.58 48.26 5.107 896.74 135-50045-010-000 Workman's Compensation 6,109.00 6,109.00 3,760.65 61.559 2,348.35 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 72.45 239.40 119.700 39.40- 135-50070-010-000 Employee Relations 350.00 350.00 48.63 160.14 45.754 189.86 Subtotal: 325,773.00 357,124.00 19,676.53 231,653.87 64.867 125,470.13 135-55005-010-000 Engineering 3,000.00 2,000.00 2,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 1,928.22 27,240.50 54.481 22,759.50 135-55090-010-000 Vehicle Maintenance 3,700.00 4,650.00 107.20 3,788.10 81.465 861.90 135-55100-010-000 Building Maint & Supplies 55.30 55.30 55.30- 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 1,767.04 60.932 1,132.96 135-55135-010-000 Lab Analysis 4,500.00 5,384.00 240.00 4,540.21 84.328 843.79 Subtotal: 64,100.00 64,934.00 2,330.72 37,391.15 57.583 27,542.85 135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 183.09 1,376.64 68.832 623.36 135-60020-010-000 Electricity 162,410.00 162,410.00 18,813.39 99,582.47 61.315 62,827.53 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 100.000 135-60080-010-000 Schools & Training 1,672.00 1,472.00 111.00 462.00 31.386 1,010.00 135-60090-010-000 Safety Program 500.00 400.00 400.00 135-60100-010-000 Travel & per diem 700.00 800.00 551.69 68.961 248.31 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 6.00 30.00 6.000 470.00 135-60125-010-000 Advertising 300.00- 135-60135-010-000 TCEQ Fees & Permits 35,800.00 42,743.00 43,293.75 101.289 550.75- 135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 320,325.69 1,150,847.13 56.735 877,599.87 135-60243-010-000 Prior Year Expense 756.00 756.00 100.000 135-60245-010-000 Miscellaneous Expenses 500.00 200.00 200.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 403.35 1,335.78 31.804 2,864.22 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 500.00 1,090.00 1,128.99 225.798 628.99- . glbase_tbam tsisk Trophy Club MUD #1 Page 6 08:15 08/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 2,239,129.00 2,245,328.00 340,632.52 1,299,514.45 57.876 945,813.55 135-65005-010-000 Fuel & Lube 17,661.00 17,661.00 968.06 9,570.68 54.191 8,090.32 135-65010-010-000 Uniforms 2,680.00 2,680.00 304.23 1,922.05 71.718 757.95 135-65030-010-000 Chemicals 6,200.00 6,200.00 986.57 4,470.69 72.108 1,729.31 135-65035-010-000 Small Tools 1,500.00 1,500.00 358.84 626.03 41.735 873.97 135-65040-010-000 Safety Equipment 2,000.00 1,000.00 256.82 25.682 743.18 135-65050-010-000 Meter Expense 143,550.00 143,550.00 1,480.00 149,743.25 104.314 6,193.25- 135-65085-010-000 Office Supplies 109.68- Subtotal: 173,591.00 172,591.00 3,988.02 166,589.52 96.523 6,001.48 135-69005-010-000 Capital Expenses 181,800.00 8,000.00 1,094.96- -13.687 9,094.96 135-69008-010-000 Short Term Debt-Principal 387,037.00 366,000.00 35,991.00 35,991.00 9.834 330,009.00 135-69009-010-000 Short Term Debt-Interest 21,037.00 4,238.24 14,615.22 69.474 6,421.78 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000 135-69280-010-000 Capital Repairs 270,000.00 60,000.00 59,869.00 99.782 131.00 135-69281-010-000 Capital Repair-Ground Storage 150,000.00 100,900.00 100,816.54 99.917 83.46 Subtotal: 1,018,837.00 585,937.00 40,229.24 240,196.80 40.994 345,740.20 Program number: 3,821,430.00 3,425,914.00 406,857.03 1,975,345.79 57.659 1,450,568.21 Department number: Water 3,821,430.00 3,425,914.00 406,857.03 1,975,345.79 57.659 1,450,568.21 . glbase_tbam tsisk Trophy Club MUD #1 Page 7 08:15 08/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 196,781.00 196,781.00 14,732.94 143,828.70 73.091 52,952.30 135-50010-020-000 Overtime 10,166.00 17,546.00 1,244.20 10,218.05 58.236 7,327.95 135-50016-020-000 Longevity 2,858.00 2,858.00 2,857.50 99.983 .50 135-50017-020-000 Certification 4,200.00 4,200.00 350.00 3,400.00 80.952 800.00 135-50020-020-000 Retirement 29,821.00 54,844.00 1,466.18 42,700.45 77.858 12,143.55 135-50026-020-000 Medical Insurance 29,034.00 29,034.00 3,293.23 28,713.28 98.895 320.72 135-50027-020-000 Dental Insurance 2,112.00 2,112.00 226.46 2,033.99 96.306 78.01 135-50028-020-000 Vision Insurance 552.00 552.00 49.93 487.73 88.357 64.27 135-50029-020-000 Life Insurance & Other 920.00 1,377.00 663.34 1,751.09 127.167 374.09- 135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 876.71 8,774.18 66.130 4,493.82 135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 205.04 2,052.01 66.130 1,050.99 135-50040-020-000 Unemployment Taxes 756.00 756.00 45.41 6.007 710.59 135-50045-020-000 Workman's Compensation 2,939.00 2,939.00 5,960.27 202.799 3,021.27- 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 189.00 126.000 39.00- 135-50070-020-000 Employee Relations 350.00 350.00 19.66 110.89 31.683 239.11 Subtotal: 297,010.00 329,870.00 23,127.69 253,122.55 76.734 76,747.45 135-55070-020-000 Independent Labor 1,000.00 84,418.00 77,500.00 91.805 6,918.00 135-55080-020-000 Maintenance & Repairs 40,000.00 41,205.00 5,706.88 47,795.39 115.994 6,590.39- 135-55090-020-000 Vehicle Maintenance 2,000.00 3,350.00 175.43 4,693.39 140.101 1,343.39- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,080.96 72.064 419.04 135-55125-020-000 Dumpster Services 15,000.00 49,611.00 1,901.19 36,717.24 74.010 12,893.76 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,833.00 24,416.65 81.389 5,583.35 Subtotal: 89,500.00 210,084.00 9,616.50 192,203.63 91.489 17,880.37 135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 3,981.00 232.99 1,875.18 47.103 2,105.82 135-60020-020-000 Electricity 153,045.00 153,045.00 10,195.31 104,916.43 68.553 48,128.57 135-60066-020-000 Publications/Books/Subscripts 500.00 200.00 161.45 80.725 38.55 135-60080-020-000 Schools & Training 3,272.00 3,272.00 1,071.66 32.752 2,200.34 135-60090-020-000 Safety Program 250.00 71.47 71.47- 135-60100-020-000 Travel & per diem 1,400.00 1,400.00 185.86 3,442.80 245.914 2,042.80- 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 1,123.00 74.867 377.00 135-60125-020-000 Advertising 2,000.00 300.00 112.50 37.500 187.50 135-60135-020-000 TCEQ Fees & Permits 56,000.00 15,600.00 7,887.19 50.559 7,712.81 135-60136-020-000 TCEQ Environmental Proj (SEP) 40,400.00 40,400.00 100.000 135-60243-020-000 Prior Year Expense 802.00 801.59 99.949 .41 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 202.10 101.050 2.10- 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 412.23 82.446 87.77 Subtotal: 221,367.00 221,200.00 10,614.16 162,477.60 73.453 58,722.40 135-65005-020-000 Fuel & Lube 8,527.00 10,527.00 1,029.55 9,127.04 86.701 1,399.96 . glbase_tbam tsisk Trophy Club MUD #1 Page 8 08:15 08/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-020-000 Uniforms 2,574.00 1,574.00 1,323.70 84.098 250.30 135-65030-020-000 Chemicals 10,000.00 38,346.00 2,760.00 25,550.90 66.633 12,795.10 135-65035-020-000 Small Tools 1,000.00 1,000.00 469.05 46.905 530.95 135-65040-020-000 Safety Equipment 250.00 500.00 270.16 822.49 164.498 322.49- 135-65045-020-000 Lab Supplies 10,000.00 10,000.00 321.08 13,346.28 133.463 3,346.28- Subtotal: 32,351.00 61,947.00 4,380.79 50,639.46 81.746 11,307.54 135-69005-020-000 Capital Expenses 241,200.00 446,484.00 442,195.29 99.039 4,288.71 135-69280-020-000 Capital Repairs 158,000.00 Subtotal: 399,200.00 446,484.00 442,195.29 99.039 4,288.71 Program number: 1,039,428.00 1,269,585.00 47,739.14 1,100,638.53 86.693 168,946.47 Department number: Wastewater 1,039,428.00 1,269,585.00 47,739.14 1,100,638.53 86.693 168,946.47 . glbase_tbam tsisk Trophy Club MUD #1 Page 9 08:15 08/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 156,475.00 156,475.00 11,782.74 118,469.61 75.712 38,005.39 135-50010-021-000 Overtime 7,297.00 12,158.00 684.26 8,205.73 67.492 3,952.27 135-50016-021-000 Longevity 3,818.00 3,818.00 3,817.50 99.987 .50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 1,450.00 80.556 350.00 135-50020-021-000 Retirement 23,574.00 42,910.00 1,133.01 33,858.57 78.906 9,051.43 135-50026-021-000 Medical Insurance 20,198.00 25,940.00 2,321.55 21,300.09 82.113 4,639.91 135-50027-021-000 Dental Insurance 1,409.00 1,812.00 159.88 1,492.60 82.373 319.40 135-50028-021-000 Vision Insurance 357.00 383.00 32.60 317.32 82.851 65.68 135-50029-021-000 Life Insurance & Other 1,008.00 1,223.00 523.15 1,327.82 108.571 104.82- 135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 714.92 7,751.46 73.809 2,750.54 135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 167.21 1,812.82 73.812 643.18 135-50040-021-000 Unemployment Taxes 567.00 567.00 34.39 6.065 532.61 135-50045-021-000 Workman's Compensation 3,348.00 3,348.00 4,896.88 146.263 1,548.88- 135-50070-021-000 Employee Relations 250.00 250.00 19.65 127.65 51.060 122.35 Subtotal: 233,059.00 263,642.00 17,688.97 204,862.44 77.705 58,779.56 135-55005-021-000 Engineering 1,500.00 135-55080-021-000 Maintenance & Repairs 35,000.00 20,000.00 687.00 18,149.78 90.749 1,850.22 135-55090-021-000 Vehicle Maintenance 1,900.00 1,600.00 17.38 1,423.26 88.954 176.74 Subtotal: 38,400.00 21,600.00 704.38 19,573.04 90.616 2,026.96 135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 216.79 2,014.15 57.547 1,485.85 135-60020-021-000 Electricity 18,705.00 18,705.00 1,666.16 15,147.23 80.980 3,557.77 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 100.000 135-60080-021-000 Schools & Training 826.00 826.00 830.00 100.484 4.00- 135-60090-021-000 Safety Program 500.00 300.00 300.00 135-60100-021-000 Travel & per diem 450.00 450.00 2,092.93 465.096 1,642.93- 135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00 135-60243-021-000 Prior Year Expense 621.00 620.83 99.973 .17 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 34,331.00 34,752.00 1,882.95 20,955.14 60.299 13,796.86 135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 972.90 7,483.74 61.762 4,633.26 135-65010-021-000 Uniforms 2,220.00 2,220.00 934.13 42.078 1,285.87 135-65030-021-000 Chemicals 7,500.00 7,500.00 2,221.00 29.613 5,279.00 135-65035-021-000 Small Tools 1,500.00 1,250.00 70.00 5.600 1,180.00 135-65040-021-000 Safety Equipment 500.00 500.00 120.00 24.000 380.00 Subtotal: 23,837.00 23,587.00 972.90 10,828.87 45.910 12,758.13 135-69005-021-000 Capital Expenses 90,000.00 90,000.00 15,276.00 16.973 74,724.00 . glbase_tbam tsisk Trophy Club MUD #1 Page 10 08:15 08/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69008-021-000 Short Term Debt-Principal 40,260.00 40,260.00 40,260.00 Subtotal: 130,260.00 130,260.00 15,276.00 11.727 114,984.00 Program number: 459,887.00 473,841.00 21,249.20 271,495.49 57.297 202,345.51 Department number: Collection 459,887.00 473,841.00 21,249.20 271,495.49 57.297 202,345.51 . glbase_tbam tsisk Trophy Club MUD #1 Page 11 08:15 08/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 1,200.00 8,700.00 87.000 1,300.00 135-50030-026-000 Social Security Taxes 620.00 620.00 74.40 539.40 87.000 80.60 135-50035-026-000 Medicare Taxes 145.00 145.00 17.40 126.15 87.000 18.85 135-50040-026-000 Unemployment Taxes 210.00 210.00 1.20 67.50 32.143 142.50 135-50045-026-000 Workman's Compensation 150.00 150.00 7.88 5.253 142.12 Subtotal: 11,125.00 11,125.00 1,293.00 9,440.93 84.862 1,684.07 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 42.00 2.000 2,058.00 135-60075-026-000 Meetings 1,200.00 1,200.00 22.00 456.97 38.081 743.03 135-60080-026-000 Schools & Training 4,000.00 4,000.00 2,655.00 66.375 1,345.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 401.47 5,727.01 114.540 727.01- 135-60243-026-000 Prior Year Expense 107.10 107.10- 135-60245-026-000 Miscellaneous Expenses 3,000.00 3,000.00 267.88 8.929 2,732.12 Subtotal: 15,450.00 15,450.00 423.47 9,255.96 59.909 6,194.04 Program number: 26,575.00 26,575.00 1,716.47 18,696.89 70.355 7,878.11 Department number: Board of Directors 26,575.00 26,575.00 1,716.47 18,696.89 70.355 7,878.11 . glbase_tbam tsisk Trophy Club MUD #1 Page 12 08:15 08/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 444,730.00 444,730.00 33,146.76 340,235.19 76.504 104,494.81 135-50010-030-000 Overtime 1,500.00 1,500.00 24.67 264.61 17.641 1,235.39 135-50016-030-000 Longevity 2,193.00 2,318.00 2,317.50 99.978 .50 135-50020-030-000 Retirement 60,441.00 104,801.00 2,978.80 81,298.27 77.574 23,502.73 135-50026-030-000 Medical Insurance 44,066.00 49,049.00 4,388.10 40,272.60 82.107 8,776.40 135-50027-030-000 Dental Insurance 3,379.00 3,379.00 386.34 3,570.54 105.669 191.54- 135-50028-030-000 Vision Insurance 795.00 945.00 82.53 776.23 82.141 168.77 135-50029-030-000 Life Insurance & Other 2,500.00 2,582.00 1,408.15 3,477.40 134.679 895.40- 135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 1,912.00 20,232.97 72.775 7,569.03 135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 447.15 4,731.92 72.776 1,770.08 135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 439.29 28.581 1,097.71 135-50045-030-000 Workman's Compensation 831.00 831.00 938.60 112.948 107.60- 135-50060-030-000 Pre-emp Physicals/Testing 250.00 250.00 39.00 15.600 211.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 91.86 2,831.85 56.637 2,168.15 Subtotal: 601,526.00 651,226.00 44,866.36 501,425.97 76.997 149,800.03 135-55030-030-000 Software & Support 63,555.00 63,555.00 4,139.03 55,897.77 87.952 7,657.23 135-55070-030-000 Independent Labor 2,700.00 7,700.00 4,787.05 5,472.67 71.074 2,227.33 135-55075-030-000 Records Management 500.00 500.00 500.00 135-55080-030-000 Maintenance & Repairs 811.00 810.52 99.941 .48 135-55100-030-000 Building Maint & Supplies 5,000.00 6,500.00 252.45 4,491.38 69.098 2,008.62 135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,678.51 15,554.27 77.001 4,645.73 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 6,974.00 46.493 8,026.00 135-55161-030-000 Outside Services-Town Semo 85,465.00 85,465.00 85,465.00 100.000 135-55165-030-000 Collection Fees 160.00 159.77 99.856 .23 135-55205-030-000 Utility Billing Contract 11,000.00 11,000.00 632.68 5,738.74 52.170 5,261.26 Subtotal: 203,420.00 210,891.00 11,489.72 180,564.12 85.620 30,326.88 135-60005-030-000 Telephone 9,000.00 10,500.00 1,096.72 9,533.59 90.796 966.41 135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 326.73 2,949.17 82.494 625.83 135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 2,141.26 11,291.26 86.729 1,727.74 135-60025-030-000 Water 3,100.00 3,100.00 185.59 838.39 27.045 2,261.61 135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 10,985.10 83.334 2,196.90 135-60035-030-000 Postage 23,000.00 26,604.00 1,720.17 22,882.99 86.013 3,721.01 135-60040-030-000 Service Charges & Fees 18,000.00 28,330.00 2,804.98 23,674.17 83.566 4,655.83 135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 1,001.40 11.781 7,498.60 135-60055-030-000 Insurance 35,000.00 50,694.00 50.00 50,993.77 100.591 299.77- 135-60066-030-000 Publications/Books/Subscripts 750.00 834.00 833.50 99.940 .50 135-60070-030-000 Dues & Memberships 2,400.00 3,892.00 80.00 4,271.95 109.762 379.95- 135-60075-030-000 Meetings 250.00 400.00 283.85 70.963 116.15 135-60080-030-000 Schools & Training 5,500.00 5,350.00 364.58 3,759.23 70.266 1,590.77 135-60100-030-000 Travel & per diem 3,950.00 3,616.00 733.34 4,460.44 123.353 844.44- . glbase_tbam tsisk Trophy Club MUD #1 Page 13 08:15 08/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60110-030-000 Physicals/Testing 500.00 500.00 500.00 135-60125-030-000 Advertising 4,000.00 4,000.00 1,272.74 2,691.64 67.291 1,308.36 135-60235-030-000 Security 1,350.00 1,350.00 505.13 37.417 844.87 135-60243-030-000 Prior Year Expense 1,263.00 3,290.58 260.537 2,027.58- 135-60245-030-000 Miscellaneous Expenses 15,000.00 13,500.00 155.37 1,190.59 8.819 12,309.41 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 99.01 10,099.01 96.181 400.99 135-60281-030-000 Park Expenses 42,500.00 774.67 32,502.00 76.475 9,998.00 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 161,000.00 161,000.00- 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 449.00 3,986.76 159.470 1,486.76- Subtotal: 173,076.00 247,709.00 13,352.67 363,024.52 146.553 115,315.52- 135-65010-030-000 Uniforms 1,635.00 1,635.00 624.12 38.172 1,010.88 135-65055-030-000 Hardware 20,188.00 20,188.00 12,129.34 60.082 8,058.66 135-65085-030-000 Office Supplies 8,200.00 8,200.00 576.84 7,472.40 91.127 727.60 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 787.67 3,078.75 53.712 2,653.25 135-65095-030-000 Maintenance Supplies 2,000.00 1,500.00 688.46 2,904.40 193.627 1,404.40- 135-65097-030-000 Vending Machine Supplies 500.00 500.00 28.38 78.70 15.740 421.30 135-65105-030-000 Printing 5,200.00 4,200.00 2,135.66 50.849 2,064.34 Subtotal: 43,455.00 41,955.00 2,081.35 28,423.37 67.747 13,531.63 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 2,311.65 67.004 1,138.35 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 100.000 Subtotal: 30,361.00 30,361.00 29,222.65 96.251 1,138.35 Program number: 1,051,838.00 1,182,142.00 71,790.10 1,102,660.63 93.276 79,481.37 Department number: Administration 1,051,838.00 1,182,142.00 71,790.10 1,102,660.63 93.276 79,481.37 . glbase_tbam tsisk Trophy Club MUD #1 Page 14 08:15 08/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 70,000.00 70,000.00 32,995.07 189,882.41 271.261 119,882.41- 135-55055-039-000 Auditing 21,200.00 21,200.00 20,700.00 97.642 500.00 135-55060-039-000 Appraisal 15,100.00 15,100.00 8,152.22 53.988 6,947.78 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,390.56 62.909 1,409.44 Subtotal: 110,100.00 110,100.00 32,995.07 221,125.19 200.840 111,025.19- 135-60344-039-000 Intergov Trans Out (Fire CIP) 112,333.21 112,333.21- Subtotal: 112,333.21 112,333.21- Program number: 110,100.00 110,100.00 32,995.07 333,458.40 302.869 223,358.40- Department number: Non Departmental 110,100.00 110,100.00 32,995.07 333,458.40 302.869 223,358.40- Expenditures Subtotal ----------- 6,509,258.00 6,488,157.00 582,347.01 4,802,295.73 74.016 1,685,861.27 Fund number: 135 MUD 1 General Fund 76,403.17- 31,987.90 31,987.90- . glbase_tbam tsisk Trophy Club MUD #1 Page 15 08:15 08/13/13 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 56,911.00- 56,911.00 137-49146-000-000 Intergov Transfer-Fire Dept 41,890.00- 41,890.00 Subtotal: 98,801.00- 98,801.00 Program number: 98,801.00- 98,801.00 Department number: 98,801.00- 98,801.00 Revenues Subtotal ----------- 98,801.00- 98,801.00 Fund number: 137 MUD 1 Consolidated GASB 98,801.00- 98,801.00 . glbase_tbam tsisk Trophy Club MUD #1 Page 16 08:15 08/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49005-000-000 Loan Proceeds 445,000.00- 445,000.00- 100.000 507-49010-000-000 Interest Income 100.00- 17.14- 85.23- 85.230 14.77- Subtotal: 445,100.00- 17.14- 445,085.23- 99.997 14.77- Program number: 445,100.00- 17.14- 445,085.23- 99.997 14.77- Department number: 445,100.00- 17.14- 445,085.23- 99.997 14.77- Revenues Subtotal ----------- 445,100.00- 17.14- 445,085.23- 99.997 14.77- . glbase_tbam tsisk Trophy Club MUD #1 Page 17 08:15 08/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 1 Security Cameras Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-010-001 Capital Exp/Security Cameras 5,800.00 6,289.00 108.431 489.00- Subtotal: 5,800.00 6,289.00 108.431 489.00- Program number: 1 Security Cameras 5,800.00 6,289.00 108.431 489.00- . glbase_tbam tsisk Trophy Club MUD #1 Page 18 08:15 08/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-002 Capital Repairs/ROFC FW Meter 165,000.00 37,142.00 53,875.50 32.652 111,124.50 Subtotal: 165,000.00 37,142.00 53,875.50 32.652 111,124.50 Program number: 2 Rate of Flow Control-FW Meter 165,000.00 37,142.00 53,875.50 32.652 111,124.50 . glbase_tbam tsisk Trophy Club MUD #1 Page 19 08:15 08/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 3 Indian Creek Waterline Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-003 Capital Rep/Ind Crk Waterline 210,000.00 6,514.50 15,593.83 7.426 194,406.17 Subtotal: 210,000.00 6,514.50 15,593.83 7.426 194,406.17 Program number: 3 Indian Creek Waterline 210,000.00 6,514.50 15,593.83 7.426 194,406.17 Department number: Water 380,800.00 43,656.50 75,758.33 19.895 305,041.67 . glbase_tbam tsisk Trophy Club MUD #1 Page 20 08:15 08/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-60335-020-000 Interfund Transfer Out (GF) 38,101.42 38,101.42- Subtotal: 38,101.42 38,101.42- Program number: 38,101.42 38,101.42- . glbase_tbam tsisk Trophy Club MUD #1 Page 21 08:15 08/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 1 Security Cameras Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-001 Capital Exp/Security Cameras 8,200.00 8,578.00 104.610 378.00- Subtotal: 8,200.00 8,578.00 104.610 378.00- Program number: 1 Security Cameras 8,200.00 8,578.00 104.610 378.00- . glbase_tbam tsisk Trophy Club MUD #1 Page 22 08:15 08/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 4 Sludge Blanket Level Indicator Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-004 Capital Exp/Sludge Blanket Ind 18,000.00 18,000.00 Subtotal: 18,000.00 18,000.00 Program number: 4 Sludge Blanket Level Indicator 18,000.00 18,000.00 . glbase_tbam tsisk Trophy Club MUD #1 Page 23 08:15 08/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 5 Portable Submersible Pump Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69005-020-005 Capital Exp/Port Sub Pump 10,000.00 8,553.92 85.539 1,446.08 Subtotal: 10,000.00 8,553.92 85.539 1,446.08 Program number: 5 Portable Submersible Pump 10,000.00 8,553.92 85.539 1,446.08 . glbase_tbam tsisk Trophy Club MUD #1 Page 24 08:15 08/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: 6 Waste Pump Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-020-006 Capital Repairs/Waste Pump 28,000.00 27,960.70 99.860 39.30 Subtotal: 28,000.00 27,960.70 99.860 39.30 Program number: 6 Waste Pump 28,000.00 27,960.70 99.860 39.30 Department number: Wastewater 64,200.00 83,194.04 129.586 18,994.04- Expenditures Subtotal ----------- 445,000.00 43,656.50 158,952.37 35.720 286,047.63 Fund number: 507 MUD 1 Capital Projects 100.00- 43,639.36 286,132.86- ############### 286,032.86 . glbase_tbam tsisk Trophy Club MUD #1 Page 25 08:15 08/13/13 Budget Summary with Amendment Fund: 522 2010 GO/Fire Station Department: Revenues Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 522-49145-000-000 Intergov Transfer-General Fund 112,333.21- 112,333.21 Subtotal: 112,333.21- 112,333.21 Program number: 112,333.21- 112,333.21 Department number: Revenues 112,333.21- 112,333.21 Revenues Subtotal ----------- 112,333.21- 112,333.21 Fund number: 522 2010 GO/Fire Station 112,333.21- 112,333.21 . glpdatb2 tsisk Trophy Club MUD #1 Page 14 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2013 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 1863 07/02/2013 Property Taxes/Assessments (100,089.44) (.22) (100,089.66) GL 1864 07/08/2013 Property Taxes/Assessments (22.70) (100,112.36) GL 1865 07/10/2013 Property Taxes/Assessments (23.10) (100,135.46) GL 1866 07/10/2013 Property Taxes/Assessments (11.98) (100,147.44) GL 1967 07/11/2013 Property Taxes/Assessments (5.45) (100,152.89) GL 1968 07/15/2013 Property Taxes/Assessments (30.67) (100,183.56) GL 1969 07/17/2013 Property Taxes/Assessments (10.64) (100,194.20) GL 1970 07/18/2013 Property Taxes/Assessments (11.45) (100,205.65) GL 1971 07/19/2013 Property Taxes/Assessments (3.59) (100,209.24) GL 1972 07/22/2013 Property Taxes/Assessments (22.86) (100,232.10) GL 1973 07/23/2013 Property Taxes/Assessments (7.26) (100,239.36) GL 1974 07/24/2013 Property Taxes/Assessments (7.17) (100,246.53) GL 2022 07/25/2013 Property Taxes/Assessments (19.51) (100,266.04) GL 2023 07/29/2013 Property Taxes/Assessments (21.18) (100,287.22) GL 2024 07/30/2013 Property Taxes/Assessments (16.35) (100,303.57) GL 2025 07/31/2013 Property Taxes/Assessments (7.57) (100,311.14) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (221.70) (100,311.14) ** (99,884.00) Budgeted 427.14 Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1968 07/15/2013 Property Taxes/Assessments 316.71 (19.43) 297.28 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (19.43) 297.28 ** (624.00) Budgeted (921.28) Remaining -48 % Used Account: 135-40015-000-000 Property Taxes/P & I 1863 07/02/2013 Property Taxes/Assessments (805.81) (.04) (805.85) GL 1968 07/15/2013 Property Taxes/Assessments (10.51) (816.36) GL 1972 07/22/2013 Property Taxes/Assessments (1.77) (818.13) GL 1972 07/22/2013 Property Taxes/Assessments (2.54) (820.67) GL 1973 07/23/2013 Property Taxes/Assessments (.47) (821.14) GL 2022 07/25/2013 Property Taxes/Assessments (3.52) (824.66) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (18.85) (824.66) ** (1,200.00) Budgeted (375.34) Remaining 69 % Used Account: 135-47000-000-000 Water 1983 07/18/2013 UB 7/18/13 Adjustments UB20130718-20130718 User: (2,097,483.70) (100.00) (2,097,583.70) UB . glpdatb2 tsisk Trophy Club MUD #1 Page 15 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1904 07/18/2013 Recode JE1766/Out of District (2,097,483.70) (100.00) (2,097,683.70) GL 1910 07/18/2013 UB 7/18/13 Adj-Price account UB20130718-20130718 User: 90.90 (2,097,592.80) UB 1986 07/29/2013 UB 7/29/13 Adjustments UB20130729-20130729 User: (100.00) (2,097,692.80) UB 2007 07/31/2013 UB 7/31/13 July Billing UB20130731-20130731 User: (398,952.84) (2,496,645.64) UB _______________ Account: 135-47000-000-000 Water Totals: (399,161.94) (2,496,645.64) ** (3,545,609.00) Budgeted (1,048,963.36) Remaining 70 % Used Account: 135-47005-000-000 Sewer 1910 07/18/2013 UB 7/18/13 Adj-Price account UB20130718-20130718 User: (1,282,331.87) 12.50 (1,282,319.37) UB 2007 07/31/2013 UB 7/31/13 July Billing UB20130731-20130731 User: (178,606.66) (1,460,926.03) UB _______________ Account: 135-47005-000-000 Sewer Totals: (178,594.16) (1,460,926.03) ** (1,653,747.00) Budgeted (192,820.97) Remaining 88 % Used Account: 135-47020-000-000 Standby (149.90) .00 (149.90) _______________ Account: 135-47020-000-000 Standby Totals: .00 (149.90) ** (576.00) Budgeted (426.10) Remaining 26 % Used Account: 135-47025-000-000 Penalties 1932 07/23/2013 UB 7/23/13 Penalties UB20130723-20130723 User: (41,514.16) (4,185.50) (45,699.66) UB 1953 07/23/2013 UB 7/23/13 Penalties UB20130723-20130723 User: 1,597.99 (44,101.67) UB 2004 07/31/2013 UB 07/31/2013 Penalties UB20130731-20130731 User: 176.29 (43,925.38) UB 2007 07/31/2013 UB 7/31/13 July Billing UB20130731-20130731 User: (2,072.04) (45,997.42) UB _______________ Account: 135-47025-000-000 Penalties Totals: (4,483.26) (45,997.42) ** (64,580.00) Budgeted (18,582.58) Remaining 71 % Used Account: 135-47030-000-000 Service Charges 1845 07/09/2013 UB 7/9/13 Cut Off Fees UB20130709-20130709 User: (9,233.36) (850.00) (10,083.36) UB 1949 07/09/2013 UB 7/9/13 After Hours Fee UB20130709-20130709 User: (200.00) (10,283.36) UB 1954 07/15/2013 UB 7/15/13 Adjustment-NSF Fee UB20130715-20130715 User: (25.00) (10,308.36) UB 1956 07/23/2013 UB 7/23/13 Adjustment-NSF Fee UB20130723-20130723 User: (25.00) (10,333.36) UB 2007 07/31/2013 UB 7/31/13 July Billing UB20130731-20130731 User: 30.48 (10,302.88) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,069.52) (10,302.88) ** (11,625.00) Budgeted (1,322.12) Remaining 89 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 16 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47035-000-000 Plumbing Inspections 2049 07/31/2013 Bill Town Inv 1061-1062 AR 20130731-20130731 User: (950.00) (500.00) (1,450.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (500.00) (1,450.00) ** (1,800.00) Budgeted (350.00) Remaining 81 % Used Account: 135-47045-000-000 Sewer Inspections 2049 07/31/2013 Bill Town Inv 1061-1062 AR 20130731-20130731 User: (3,300.00) (1,500.00) (4,800.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (1,500.00) (4,800.00) ** (5,200.00) Budgeted (400.00) Remaining 92 % Used Account: 135-47070-000-000 TCCC Effluent Charges 2007 07/31/2013 UB 7/31/13 July Billing UB20130731-20130731 User: (31,892.09) (15,370.60) (47,262.69) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (15,370.60) (47,262.69) ** (77,575.00) Budgeted (30,312.31) Remaining 61 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 1904 07/18/2013 Recode JE1766/Out of District (100.00) 100.00 .00 GL _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: 100.00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-48005-000-000 Utility Fees 2049 07/31/2013 Bill Town Inv 1061-1062 AR 20130731-20130731 User: (397,900.00) (46,000.00) (443,900.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (46,000.00) (443,900.00) ** (644,000.00) Budgeted (200,100.00) Remaining 69 % Used Account: 135-49010-000-000 Interest Income 2029 07/31/2013 July Bank Interest (3,613.19) (88.53) (3,701.72) GL 2029 07/31/2013 July Bank Interest (147.98) (3,849.70) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (236.51) (3,849.70) ** (5,500.00) Budgeted (1,650.30) Remaining 70 % Used Account: 135-49016-000-000 Cell Tower Revenue . glpdatb2 tsisk Trophy Club MUD #1 Page 17 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1977 07/11/2013 AT&T Antenna Lease (8,131.24) (910.53) (9,041.77) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (9,041.77) ** (10,164.00) Budgeted (1,122.23) Remaining 89 % Used Account: 135-49018-000-000 Building Rent Income 1925 07/22/2013 Bill Town Inv 1055-1058 AR 20130701-20130722 User: (5,249.97) (583.33) (5,833.30) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,833.30) ** (7,000.00) Budgeted (1,166.70) Remaining 83 % Used Account: 135-49030-000-000 Vending Revenue 1976 07/11/2013 Vending/WWTP (317.46) (80.95) (398.41) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (80.95) (398.41) ** (350.00) Budgeted 48.41 Remaining 114 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (234,014.00) Budgeted (234,014.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 2049 07/31/2013 Bill Town Inv 1061-1062 AR 20130731-20130731 User: (63,194.69) (9,510.00) (72,704.69) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (9,510.00) (72,704.69) ** (73,000.00) Budgeted (295.31) Remaining 100 % Used Account: 135-49141-000-000 Interfund Trans In (Cap Proj) (38,101.42) .00 (38,101.42) _______________ Account: 135-49141-000-000 Interfund Trans In (Cap Proj) Totals: .00 (38,101.42) ** (38,101.00) Budgeted .42 Remaining 100 % Used Account: 135-49900-000-000 Miscellaneous Income 1978 07/22/2013 Lennar/Meter damage 2829 & 2831 Sheffield (14,972.88) (464.40) (15,437.28) GL . glpdatb2 tsisk Trophy Club MUD #1 Page 18 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1986 07/29/2013 UB 7/29/13 Adjustments UB20130729-20130729 User: (14,972.88) (50.00) (15,487.28) UB 2049 07/31/2013 Bill Town Inv 1061-1062 AR 20130731-20130731 User: (75.00) (15,562.28) AR _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (589.40) (15,562.28) ** (13,213.00) Budgeted 2,349.28 Remaining 118 % Used Account: 135-49901-000-000 Records Management Revenue (90.50) .00 (90.50) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (90.50) ** (109.00) Budgeted (18.50) Remaining 83 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense (11,789.33) .00 (11,789.33) _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: .00 (11,789.33) ** .00 Budgeted 11,789.33 Remaining 0 % Used Account: 135-49905-000-000 Gas Well Revenue (663.35) .00 (663.35) _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 (663.35) ** (286.00) Budgeted 377.35 Remaining 232 % Used Department Totals: ------------------------------------------------------------------------------------------------ (4,770,307.83) ** (6,488,157.00) Budgeted (1,717,849.17) Remaining 74 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 19 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2013 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 1817 07/05/2013 7/5/13 Payroll Salaries & Wages 120,323.18 6,663.12 126,986.30 PR 1878 07/19/2013 MUD Payroll 7/19/13 Salaries & Wages 6,663.12 133,649.42 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 13,326.24 133,649.42 ** 213,321.00 Budgeted 79,671.58 Remaining 63 % Used Account: 135-50010-010-000 Overtime 1817 07/05/2013 7/5/13 Payroll Overtime 10,043.27 593.12 10,636.39 PR _______________ Account: 135-50010-010-000 Overtime Totals: 593.12 10,636.39 ** 19,250.00 Budgeted 8,613.61 Remaining 55 % Used Account: 135-50016-010-000 Longevity 3,080.00 .00 3,080.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,080.00 ** 3,080.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1878 07/19/2013 MUD Payroll 7/19/13 Certification 3,350.00 350.00 3,700.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 350.00 3,700.00 ** 5,100.00 Budgeted 1,400.00 Remaining 73 % Used Account: 135-50020-010-000 Retirement 1817 07/05/2013 7/5/13 Payroll Retirement 40,472.75 651.60 41,124.35 PR 1878 07/19/2013 MUD Payroll 7/19/13 Retirement 629.79 41,754.14 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,281.39 41,754.14 ** 57,748.00 Budgeted 15,993.86 Remaining 72 % Used Account: 135-50026-010-000 Medical Insurance 1817 07/05/2013 7/5/13 Payroll Medical Insurance 17,471.28 1,057.00 18,528.28 PR 1878 07/19/2013 MUD Payroll 7/19/13 Medical Insurance 1,056.96 19,585.24 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,113.96 19,585.24 ** 28,920.00 Budgeted 9,334.76 Remaining 68 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 20 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 1817 07/05/2013 7/5/13 Payroll Dental Insurance 1,255.95 95.40 1,351.35 PR 1878 07/19/2013 MUD Payroll 7/19/13 Dental Insurance 95.38 1,446.73 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 190.78 1,446.73 ** 2,091.00 Budgeted 644.27 Remaining 69 % Used Account: 135-50028-010-000 Vision Insurance 1817 07/05/2013 7/5/13 Payroll Vision Insurance 294.23 20.70 314.93 PR 1878 07/19/2013 MUD Payroll 7/19/13 Vision Insurance 20.68 335.61 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 41.38 335.61 ** 519.00 Budgeted 183.39 Remaining 65 % Used Account: 135-50029-010-000 Life Insurance & Other 1817 07/05/2013 7/5/13 Payroll Life Insurance & Other 1,036.43 73.71 1,110.14 PR 1933 07/23/2013 Life,AD&D,LTD exp correction 506.67 1,616.81 GL _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 580.38 1,616.81 ** 1,532.00 Budgeted (84.81) Remaining 106 % Used Account: 135-50030-010-000 Social Security Taxes 1817 07/05/2013 7/5/13 Payroll Social Security Taxes 8,562.86 444.07 9,006.93 PR 1878 07/19/2013 MUD Payroll 7/19/13 Social Security Taxes 427.67 9,434.60 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 871.74 9,434.60 ** 14,555.00 Budgeted 5,120.40 Remaining 65 % Used Account: 135-50035-010-000 Medicare Taxes 1817 07/05/2013 7/5/13 Payroll Medicare Taxes 2,002.60 103.86 2,106.46 PR 1878 07/19/2013 MUD Payroll 7/19/13 Medicare Taxes 100.02 2,206.48 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 203.88 2,206.48 ** 3,404.00 Budgeted 1,197.52 Remaining 65 % Used Account: 135-50040-010-000 Unemployment Taxes 1817 07/05/2013 7/5/13 Payroll Unemployment Taxes 45.68 1.28 46.96 PR 1878 07/19/2013 MUD Payroll 7/19/13 Unemployment Taxes 1.30 48.26 PR . glpdatb2 tsisk Trophy Club MUD #1 Page 21 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 2.58 48.26 ** 945.00 Budgeted 896.74 Remaining 5 % Used Account: 135-50045-010-000 Workman's Compensation 3,760.65 .00 3,760.65 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 3,760.65 ** 6,109.00 Budgeted 2,348.35 Remaining 62 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1885 07/17/2013 July AP Employment verification-Brook 166.95 72.45 239.40 FIRST CHECK APPLICANT SCREENIN 32761 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 72.45 239.40 ** 200.00 Budgeted (39.40) Remaining 120 % Used Account: 135-50070-010-000 Employee Relations 1996 07/26/2013 6/27-7/26 PCards DONUT HAVEN 111.51 28.97 140.48 DONUT HAVEN PC 1996 07/26/2013 6/27-7/26 PCards FUZZY'S TACO SHOP 17.91 158.39 FUZZY'S TACO SHOP PC 1996 07/26/2013 6/27-7/26 PCards TOM THUMB STOR00017897 1.75 160.14 TOM THUMB STOR00017897 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 48.63 160.14 ** 350.00 Budgeted 189.86 Remaining 46 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1979 07/05/2013 PCards 5/27-6/26/13 THE HOME DEPOT 6581 25,312.28 16.53 25,328.81 THE HOME DEPOT 6581 PC 1979 07/05/2013 PCards 5/27-6/26/13 AAA KELLER APPLIANCE 63.96 25,392.77 AAA KELLER APPLIANCE PC 1979 07/05/2013 PCards 5/27-6/26/13 MACARTHUR GAUGE 79.00 25,471.77 MACARTHUR GAUGE PC 1979 07/05/2013 PCards 5/27-6/26/13 FERGUSON ENTERPRISES 1 75.78 25,547.55 FERGUSON ENTERPRISES 1 PC 1885 07/17/2013 July AP Repairs-Water Pump station 113.00 25,660.55 COVENTRY & GATTIS A/C INC 32753 AP 1885 07/17/2013 July AP A/C Water pump station 717.00 26,377.55 COVENTRY & GATTIS A/C INC 32753 AP 1885 07/17/2013 July AP maintenance 56.71 26,434.26 HD SUPPLY WATERWORKS, LTD. 32769 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 22 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1885 07/17/2013 July AP water pipe maintenance 25,312.28 42.00 26,476.26 HD SUPPLY WATERWORKS, LTD. 32769 AP 1942 07/25/2013 July A/P Bull heads 1 1/2 " 156.53 26,632.79 HD SUPPLY WATERWORKS, LTD. 32815 AP 1942 07/25/2013 July A/P 1" B angles 550.80 27,183.59 HD SUPPLY WATERWORKS, LTD. 32815 AP 1996 07/26/2013 6/27-7/26 PCards THE HOME DEPOT 6581 56.91 27,240.50 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,928.22 27,240.50 ** 50,000.00 Budgeted 22,759.50 Remaining 54 % Used Account: 135-55090-010-000 Vehicle Maintenance 1979 07/05/2013 PCards 5/27-6/26/13 KWIK KAR OF ROANOKE 3,680.90 39.75 3,720.65 KWIK KAR OF ROANOKE PC 1996 07/26/2013 6/27-7/26 PCards AUTOZONE #4206 52.95 3,773.60 AUTOZONE #4206 PC 1996 07/26/2013 6/27-7/26 PCards KWIK KAR OF ROANOKE 14.50 3,788.10 KWIK KAR OF ROANOKE PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 107.20 3,788.10 ** 4,650.00 Budgeted 861.90 Remaining 81 % Used Account: 135-55100-010-000 Building Maint & Supplies 1979 07/05/2013 PCards 5/27-6/26/13 THE HOME DEPOT 6581 55.30 55.30 THE HOME DEPOT 6581 PC _______________ Account: 135-55100-010-000 Building Maint & Supplies Totals: 55.30 55.30 ** .00 Budgeted (55.30) Remaining 0 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1,767.04 .00 1,767.04 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,767.04 ** 2,900.00 Budgeted 1,132.96 Remaining 61 % Used Account: 135-55135-010-000 Lab Analysis 1885 07/17/2013 July AP Lab analysis 4,300.21 240.00 4,540.21 TARRANT CTY PUBLIC HEALTH LAB 32794 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 240.00 4,540.21 ** 5,384.00 Budgeted 843.79 Remaining 84 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1885 07/17/2013 July AP Verizon 1,193.55 183.09 1,376.64 TOWN OF TROPHY CLUB 32803 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 183.09 1,376.64 ** 2,000.00 Budgeted 623.36 Remaining 69 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 23 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-010-000 Electricity 1945 07/25/2013 July AP elec 6/13-7/15 80,769.08 14,998.63 95,767.71 HUDSON ENERGY SERVICES, LLC 32816 AP 1945 07/25/2013 July AP elec 6/13-7/15 3,814.76 99,582.47 HUDSON ENERGY SERVICES, LLC 32816 AP _______________ Account: 135-60020-010-000 Electricity Totals: 18,813.39 99,582.47 ** 162,410.00 Budgeted 62,827.53 Remaining 61 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships 150.00 .00 150.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 150.00 ** 150.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-010-000 Schools & Training 1979 07/05/2013 PCards 5/27-6/26/13 TCEQ IND RENEWAL L 351.00 111.00 462.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 111.00 462.00 ** 1,472.00 Budgeted 1,010.00 Remaining 31 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 551.69 .00 551.69 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 551.69 ** 800.00 Budgeted 248.31 Remaining 69 % Used Account: 135-60105-010-000 Rent/Lease Equipment . glpdatb2 tsisk Trophy Club MUD #1 Page 24 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1885 07/17/2013 July AP Nitrogen 24.00 6.00 30.00 ALLIED WELDING SUPPLY, INC 32746 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 6.00 30.00 ** 500.00 Budgeted 470.00 Remaining 6 % Used Account: 135-60125-010-000 Advertising 1880 07/16/2013 Recode Adv & Ofc supplies TML Ad for Water person 300.00 (300.00) .00 GL _______________ Account: 135-60125-010-000 Advertising Totals: (300.00) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 43,293.75 .00 43,293.75 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 43,293.75 ** 42,743.00 Budgeted (550.75) Remaining 101 % Used Account: 135-60150-010-000 Wholesale Water 1885 07/17/2013 July AP Wholesale Water 830,521.44 146,044.77 976,566.21 CITY OF FORT WORTH 32751 AP 1999 07/31/2013 July A/P wholesale water 174,280.92 1,150,847.13 CITY OF FORT WORTH 32833 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 320,325.69 1,150,847.13 ** 2,028,447.00 Budgeted 877,599.87 Remaining 57 % Used Account: 135-60243-010-000 Prior Year Expense 756.00 .00 756.00 _______________ Account: 135-60243-010-000 Prior Year Expense Totals: .00 756.00 ** 756.00 Budgeted .00 Remaining 100 % 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 . glpdatb2 tsisk Trophy Club MUD #1 Page 25 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1979 07/05/2013 PCards 5/27-6/26/13 DENTON SAND & GRAVEL, 932.43 108.00 1,040.43 DENTON SAND & GRAVEL, PC 1996 07/26/2013 6/27-7/26 PCards DENTON SAND & GRAVEL, 108.00 1,148.43 DENTON SAND & GRAVEL, PC 1996 07/26/2013 6/27-7/26 PCards DENTON SAND & GRAVEL, 42.00 1,190.43 DENTON SAND & GRAVEL, PC 1996 07/26/2013 6/27-7/26 PCards DENTON SAND & GRAVEL, 108.00 1,298.43 DENTON SAND & GRAVEL, PC 1996 07/26/2013 6/27-7/26 PCards TEX-TURF 11.25 1,309.68 TEX-TURF PC 1996 07/26/2013 6/27-7/26 PCards TEX-TURF 26.10 1,335.78 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 403.35 1,335.78 ** 4,200.00 Budgeted 2,864.22 Remaining 32 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 1999 07/31/2013 July A/P security camera 38.99 1,090.00 1,128.99 3RD EYE SURVEILLANCE SYSTEMS 32830 AP _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 1,090.00 1,128.99 ** 500.00 Budgeted (628.99) Remaining 226 % Used Account: 135-65005-010-000 Fuel & Lube 2050 07/31/2013 July Gas log 8,602.62 968.06 9,570.68 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 968.06 9,570.68 ** 17,661.00 Budgeted 8,090.32 Remaining 54 % Used Account: 135-65010-010-000 Uniforms 1979 07/05/2013 PCards 5/27-6/26/13 RED WING SHOES #652 1,617.82 178.49 1,796.31 RED WING SHOES #652 PC 1979 07/05/2013 PCards 5/27-6/26/13 TRACTOR SUPPLY COMPANY 125.74 1,922.05 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-65010-010-000 Uniforms Totals: 304.23 1,922.05 ** 2,680.00 Budgeted 757.95 Remaining 72 % Used Account: 135-65030-010-000 Chemicals 1979 07/05/2013 PCards 5/27-6/26/13 TOM THUMB STOR00017897 3,484.12 5.98 3,490.10 TOM THUMB STOR00017897 PC 1885 07/17/2013 July AP testing solution 43.80 3,533.90 HACH COMPANY 32765 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 26 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1996 07/26/2013 6/27-7/26 PCards DX SERVICE 3,484.12 416.35 3,950.25 DX SERVICE PC 1996 07/26/2013 6/27-7/26 PCards DX SERVICE 520.44 4,470.69 DX SERVICE PC _______________ Account: 135-65030-010-000 Chemicals Totals: 986.57 4,470.69 ** 6,200.00 Budgeted 1,729.31 Remaining 72 % Used Account: 135-65035-010-000 Small Tools 1979 07/05/2013 PCards 5/27-6/26/13 RON'S HOME AND HARDWAR 267.19 175.86 443.05 RON'S HOME AND HARDWAR PC 1979 07/05/2013 PCards 5/27-6/26/13 THE HOME DEPOT 6581 61.31 504.36 THE HOME DEPOT 6581 PC 1885 07/17/2013 July AP small tools 22.53 526.89 HD SUPPLY WATERWORKS, LTD. 32769 AP 1996 07/26/2013 6/27-7/26 PCards THE HOME DEPOT 6581 99.14 626.03 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-010-000 Small Tools Totals: 358.84 626.03 ** 1,500.00 Budgeted 873.97 Remaining 42 % Used Account: 135-65040-010-000 Safety Equipment 256.82 .00 256.82 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 256.82 ** 1,000.00 Budgeted 743.18 Remaining 26 % Used Account: 135-65050-010-000 Meter Expense 1885 07/17/2013 July AP meters 148,263.25 1,480.00 149,743.25 ATLAS UTILITY SUPPLY CO. 32748 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 1,480.00 149,743.25 ** 143,550.00 Budgeted (6,193.25) Remaining 104 % Used Account: 135-65085-010-000 Office Supplies 1880 07/16/2013 Recode Adv & Ofc supplies Office supplies for water dept 109.68 (109.68) .00 GL _______________ Account: 135-65085-010-000 Office Supplies Totals: (109.68) .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-69005-010-000 Capital Expenses (1,094.96) .00 (1,094.96) _______________ Account: 135-69005-010-000 Capital Expenses Totals: .00 (1,094.96) ** 8,000.00 Budgeted 9,094.96 Remaining -14 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 27 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69008-010-000 Short Term Debt-Principal 1945 07/25/2013 July AP Gap Vax payment 35,991.00 35,991.00 FIRST FINANCIAL BANK 32813 AP _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: 35,991.00 35,991.00 ** 366,000.00 Budgeted 330,009.00 Remaining 10 % Used Account: 135-69009-010-000 Short Term Debt-Interest 1945 07/25/2013 July AP Gap Vax payment 10,376.98 4,238.24 14,615.22 FIRST FINANCIAL BANK 32813 AP _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: 4,238.24 14,615.22 ** 21,037.00 Budgeted 6,421.78 Remaining 69 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69280-010-000 Capital Repairs 59,869.00 .00 59,869.00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 59,869.00 ** 60,000.00 Budgeted 131.00 Remaining 100 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 ** 100,900.00 Budgeted 83.46 Remaining 100 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,975,345.79 ** 3,425,914.00 Budgeted 1,450,568.21 Remaining 58 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 28 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2013 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 1817 07/05/2013 7/5/13 Payroll Salaries & Wages 129,095.76 7,366.47 136,462.23 PR 1878 07/19/2013 MUD Payroll 7/19/13 Salaries & Wages 7,366.47 143,828.70 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,732.94 143,828.70 ** 196,781.00 Budgeted 52,952.30 Remaining 73 % Used Account: 135-50010-020-000 Overtime 1817 07/05/2013 7/5/13 Payroll Overtime 8,973.85 422.00 9,395.85 PR 1878 07/19/2013 MUD Payroll 7/19/13 Overtime 822.20 10,218.05 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,244.20 10,218.05 ** 17,546.00 Budgeted 7,327.95 Remaining 58 % Used Account: 135-50016-020-000 Longevity 2,857.50 .00 2,857.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,857.50 ** 2,858.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 1878 07/19/2013 MUD Payroll 7/19/13 Certification 3,050.00 350.00 3,400.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 350.00 3,400.00 ** 4,200.00 Budgeted 800.00 Remaining 81 % Used Account: 135-50020-020-000 Retirement 1817 07/05/2013 7/5/13 Payroll Retirement 41,234.27 699.40 41,933.67 PR 1878 07/19/2013 MUD Payroll 7/19/13 Retirement 766.78 42,700.45 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,466.18 42,700.45 ** 54,844.00 Budgeted 12,143.55 Remaining 78 % Used Account: 135-50026-020-000 Medical Insurance 1817 07/05/2013 7/5/13 Payroll Medical Insurance 25,420.05 1,646.62 27,066.67 PR 1878 07/19/2013 MUD Payroll 7/19/13 Medical Insurance 1,646.61 28,713.28 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,293.23 28,713.28 ** 29,034.00 Budgeted 320.72 Remaining 99 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 29 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 1817 07/05/2013 7/5/13 Payroll Dental Insurance 1,807.53 113.24 1,920.77 PR 1878 07/19/2013 MUD Payroll 7/19/13 Dental Insurance 113.22 2,033.99 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 226.46 2,033.99 ** 2,112.00 Budgeted 78.01 Remaining 96 % Used Account: 135-50028-020-000 Vision Insurance 1817 07/05/2013 7/5/13 Payroll Vision Insurance 437.80 24.98 462.78 PR 1878 07/19/2013 MUD Payroll 7/19/13 Vision Insurance 24.95 487.73 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 49.93 487.73 ** 552.00 Budgeted 64.27 Remaining 88 % Used Account: 135-50029-020-000 Life Insurance & Other 1817 07/05/2013 7/5/13 Payroll Life Insurance & Other 1,087.75 79.48 1,167.23 PR 1933 07/23/2013 Life,AD&D,LTD exp correction 583.86 1,751.09 GL _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 663.34 1,751.09 ** 1,377.00 Budgeted (374.09) Remaining 127 % Used Account: 135-50030-020-000 Social Security Taxes 1817 07/05/2013 7/5/13 Payroll Social Security Taxes 7,897.47 416.94 8,314.41 PR 1878 07/19/2013 MUD Payroll 7/19/13 Social Security Taxes 459.77 8,774.18 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 876.71 8,774.18 ** 13,268.00 Budgeted 4,493.82 Remaining 66 % Used Account: 135-50035-020-000 Medicare Taxes 1817 07/05/2013 7/5/13 Payroll Medicare Taxes 1,846.97 97.52 1,944.49 PR 1878 07/19/2013 MUD Payroll 7/19/13 Medicare Taxes 107.52 2,052.01 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 205.04 2,052.01 ** 3,103.00 Budgeted 1,050.99 Remaining 66 % Used Account: 135-50040-020-000 Unemployment Taxes 45.41 .00 45.41 . glpdatb2 tsisk Trophy Club MUD #1 Page 30 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 45.41 ** 756.00 Budgeted 710.59 Remaining 6 % Used Account: 135-50045-020-000 Workman's Compensation 5,960.27 .00 5,960.27 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 5,960.27 ** 2,939.00 Budgeted (3,021.27) Remaining 203 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 189.00 .00 189.00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 189.00 ** 150.00 Budgeted (39.00) Remaining 126 % Used Account: 135-50070-020-000 Employee Relations 1996 07/26/2013 6/27-7/26 PCards FUZZY'S TACO SHOP 91.23 17.91 109.14 FUZZY'S TACO SHOP PC 1996 07/26/2013 6/27-7/26 PCards TOM THUMB STOR00017897 1.75 110.89 TOM THUMB STOR00017897 PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 19.66 110.89 ** 350.00 Budgeted 239.11 Remaining 32 % Used Account: 135-55070-020-000 Independent Labor 77,500.00 .00 77,500.00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 77,500.00 ** 84,418.00 Budgeted 6,918.00 Remaining 92 % Used Account: 135-55080-020-000 Maintenance & Repairs 1979 07/05/2013 PCards 5/27-6/26/13 THE HOME DEPOT 6581 42,088.51 115.17 42,203.68 THE HOME DEPOT 6581 PC 1979 07/05/2013 PCards 5/27-6/26/13 UV DOCTOR 263.14 42,466.82 UV DOCTOR PC 1979 07/05/2013 PCards 5/27-6/26/13 THE REYNOLDS COMPANY 87.20 42,554.02 THE REYNOLDS COMPANY PC 1885 07/17/2013 July AP Backwash pump repair 381.00 42,935.02 XYLEM WATER SOLUTIONS USA INC 32804 AP 1887 07/17/2013 July A/P Relay to repair wastewater pum 27.22 42,962.24 ALLIED ELECTRONICS, INC 32745 AP 1887 07/17/2013 July A/P Bar Screen drive motor 611.53 43,573.77 SEW - EURODRIVE INC 32788 AP 1996 07/26/2013 6/27-7/26 PCards SEW EURODRIVE 611.53 44,185.30 SEW EURODRIVE PC 1996 07/26/2013 6/27-7/26 PCards THE HOME DEPOT 6581 51.94 44,237.24 THE HOME DEPOT 6581 PC . glpdatb2 tsisk Trophy Club MUD #1 Page 31 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1996 07/26/2013 6/27-7/26 PCards THE HOME DEPOT 6581 42,088.51 4.27 44,241.51 THE HOME DEPOT 6581 PC 1996 07/26/2013 6/27-7/26 PCards LESLIES POOL SPLY 574 28.99 44,270.50 LESLIES POOL SPLY 574 PC 1996 07/26/2013 6/27-7/26 PCards WW GRAINGER 768.50 45,039.00 WW GRAINGER PC 1996 07/26/2013 6/27-7/26 PCards THE HOME DEPOT 6581 65.94 45,104.94 THE HOME DEPOT 6581 PC 1996 07/26/2013 6/27-7/26 PCards THE HOME DEPOT 6581 81.59 45,186.53 THE HOME DEPOT 6581 PC 1996 07/26/2013 6/27-7/26 PCards THE HOME DEPOT 6581 15.45 45,201.98 THE HOME DEPOT 6581 PC 1999 07/31/2013 July A/P blower motor repair & alignmen 2,097.00 47,298.98 CONTINENTAL RELIABILITY LLC 32834 AP 1999 07/31/2013 July A/P filter blower 496.41 47,795.39 HD SUPPLY FACILITIES MAINT LTD 32836 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 5,706.88 47,795.39 ** 41,205.00 Budgeted (6,590.39) Remaining 116 % Used Account: 135-55090-020-000 Vehicle Maintenance 1979 07/05/2013 PCards 5/27-6/26/13 SIMONIZ CAR WASH 028 4,517.96 38.84 4,556.80 SIMONIZ CAR WASH 028 PC 1979 07/05/2013 PCards 5/27-6/26/13 SIMONIZ CAR WASH 028 35.84 4,592.64 SIMONIZ CAR WASH 028 PC 1996 07/26/2013 6/27-7/26 PCards WW GRAINGER 100.75 4,693.39 WW GRAINGER PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 175.43 4,693.39 ** 3,350.00 Budgeted (1,343.39) Remaining 140 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,080.96 .00 1,080.96 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,080.96 ** 1,500.00 Budgeted 419.04 Remaining 72 % Used Account: 135-55125-020-000 Dumpster Services 1885 07/17/2013 July AP sludge haul off 34,816.05 1,901.19 36,717.24 L.H. CHANEY MATERIALS, INC. 32774 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 1,901.19 36,717.24 ** 49,611.00 Budgeted 12,893.76 Remaining 74 % Used Account: 135-55135-020-000 Lab Analysis 1885 07/17/2013 July AP lab testing 22,583.65 243.00 22,826.65 OXIDOR LABORATORIES LLC 32780 AP 1885 07/17/2013 July AP lab testing 243.00 23,069.65 OXIDOR LABORATORIES LLC 32780 AP 1885 07/17/2013 July AP lab testing 176.00 23,245.65 OXIDOR LABORATORIES LLC 32780 AP 1885 07/17/2013 July AP lab testing 243.00 23,488.65 OXIDOR LABORATORIES LLC 32780 AP 1885 07/17/2013 July AP lab testing 176.00 23,664.65 OXIDOR LABORATORIES LLC 32780 AP 1885 07/17/2013 July AP lab testing 90.00 23,754.65 OXIDOR LABORATORIES LLC 32780 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 32 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1885 07/17/2013 July AP Lab testing 22,583.65 243.00 23,997.65 OXIDOR LABORATORIES LLC 32780 AP 1885 07/17/2013 July AP lab 176.00 24,173.65 OXIDOR LABORATORIES LLC 32780 AP 1885 07/17/2013 July AP lab testing 243.00 24,416.65 OXIDOR LABORATORIES LLC 32780 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,833.00 24,416.65 ** 30,000.00 Budgeted 5,583.35 Remaining 81 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 1885 07/17/2013 July AP Verizon 1,642.19 232.99 1,875.18 TOWN OF TROPHY CLUB 32803 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 232.99 1,875.18 ** 3,981.00 Budgeted 2,105.82 Remaining 47 % Used Account: 135-60020-020-000 Electricity 1945 07/25/2013 July AP elec 6/12-7/15 94,721.12 10,195.31 104,916.43 HUDSON ENERGY SERVICES, LLC 32816 AP _______________ Account: 135-60020-020-000 Electricity Totals: 10,195.31 104,916.43 ** 153,045.00 Budgeted 48,128.57 Remaining 69 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 161.45 .00 161.45 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 161.45 ** 200.00 Budgeted 38.55 Remaining 81 % Used Account: 135-60080-020-000 Schools & Training 1,071.66 .00 1,071.66 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 1,071.66 ** 3,272.00 Budgeted 2,200.34 Remaining 33 % Used Account: 135-60090-020-000 Safety Program 71.47 .00 71.47 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 71.47 ** .00 Budgeted (71.47) Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem . glpdatb2 tsisk Trophy Club MUD #1 Page 33 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1979 07/05/2013 PCards 5/27-6/26/13 HOLIDAY INNS 3,256.94 97.81 3,354.75 HOLIDAY INNS PC 1979 07/05/2013 PCards 5/27-6/26/13 AMERICAN AIRLINES 75.00 3,429.75 AMERICAN AIRLINES PC 1979 07/05/2013 PCards 5/27-6/26/13 DUNKIN #339277 Q35 4.24 3,433.99 DUNKIN #339277 Q35 PC 1979 07/05/2013 PCards 5/27-6/26/13 SUBWAY 00227215 8.81 3,442.80 SUBWAY 00227215 PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 185.86 3,442.80 ** 1,400.00 Budgeted (2,042.80) Remaining 246 % Used Account: 135-60105-020-000 Rent/Lease Equipment 1,123.00 .00 1,123.00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 1,123.00 ** 1,500.00 Budgeted 377.00 Remaining 75 % Used Account: 135-60125-020-000 Advertising 112.50 .00 112.50 _______________ Account: 135-60125-020-000 Advertising Totals: .00 112.50 ** 300.00 Budgeted 187.50 Remaining 38 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 7,887.19 .00 7,887.19 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 7,887.19 ** 15,600.00 Budgeted 7,712.81 Remaining 51 % Used Account: 135-60136-020-000 TCEQ Environmental Proj (SEP) 40,400.00 .00 40,400.00 _______________ Account: 135-60136-020-000 TCEQ Environmental Proj (SEP) Totals: .00 40,400.00 ** 40,400.00 Budgeted .00 Remaining 100 % Used Account: 135-60243-020-000 Prior Year Expense 801.59 .00 801.59 _______________ Account: 135-60243-020-000 Prior Year Expense Totals: .00 801.59 ** 802.00 Budgeted .41 Remaining 100 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 34 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-020-000 Miscellaneous Expenses 202.10 .00 202.10 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 202.10 ** 200.00 Budgeted (2.10) Remaining 101 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 412.23 .00 412.23 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 412.23 ** 500.00 Budgeted 87.77 Remaining 82 % Used Account: 135-65005-020-000 Fuel & Lube 2050 07/31/2013 July Gas log 8,097.49 1,029.55 9,127.04 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,029.55 9,127.04 ** 10,527.00 Budgeted 1,399.96 Remaining 87 % Used Account: 135-65010-020-000 Uniforms 1,323.70 .00 1,323.70 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,323.70 ** 1,574.00 Budgeted 250.30 Remaining 84 % Used Account: 135-65030-020-000 Chemicals 1885 07/17/2013 July AP clarifloc 22,790.90 1,080.00 23,870.90 POLYDYNE, INC 32782 AP 1885 07/17/2013 July AP chemicals 1,680.00 25,550.90 HARCROS CHEMICALS INC 32768 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 2,760.00 25,550.90 ** 38,346.00 Budgeted 12,795.10 Remaining 67 % Used Account: 135-65035-020-000 Small Tools 469.05 .00 469.05 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 469.05 ** 1,000.00 Budgeted 530.95 Remaining 47 % Used Account: 135-65040-020-000 Safety Equipment . glpdatb2 tsisk Trophy Club MUD #1 Page 35 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1979 07/05/2013 PCards 5/27-6/26/13 THE HOME DEPOT 6581 552.33 53.94 606.27 THE HOME DEPOT 6581 PC 1996 07/26/2013 6/27-7/26 PCards THE HOME DEPOT 6581 94.16 700.43 THE HOME DEPOT 6581 PC 1996 07/26/2013 6/27-7/26 PCards WW GRAINGER 59.30 759.73 WW GRAINGER PC 1999 07/31/2013 July A/P safety supplies 62.76 822.49 CINTAS FAS LOCKBOX 636525 32832 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 270.16 822.49 ** 500.00 Budgeted (322.49) Remaining 164 % Used Account: 135-65045-020-000 Lab Supplies 1885 07/17/2013 July AP water 13,025.20 50.67 13,075.87 OZARKA DIRECT 32781 AP 1999 07/31/2013 July A/P chemicals 270.41 13,346.28 HACH COMPANY 32835 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 321.08 13,346.28 ** 10,000.00 Budgeted (3,346.28) Remaining 133 % Used Account: 135-69005-020-000 Capital Expenses 442,195.29 .00 442,195.29 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .00 442,195.29 ** 446,484.00 Budgeted 4,288.71 Remaining 99 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 1,100,638.53 ** 1,269,585.00 Budgeted 168,946.47 Remaining 87 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 36 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2013 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 1817 07/05/2013 7/5/13 Payroll Salaries & Wages 106,686.87 5,891.37 112,578.24 PR 1878 07/19/2013 MUD Payroll 7/19/13 Salaries & Wages 5,891.37 118,469.61 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,782.74 118,469.61 ** 156,475.00 Budgeted 38,005.39 Remaining 76 % Used Account: 135-50010-021-000 Overtime 1817 07/05/2013 7/5/13 Payroll Overtime 7,521.47 444.13 7,965.60 PR 1878 07/19/2013 MUD Payroll 7/19/13 Overtime 240.13 8,205.73 PR _______________ Account: 135-50010-021-000 Overtime Totals: 684.26 8,205.73 ** 12,158.00 Budgeted 3,952.27 Remaining 67 % Used Account: 135-50016-021-000 Longevity 3,817.50 .00 3,817.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 3,817.50 ** 3,818.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 1878 07/19/2013 MUD Payroll 7/19/13 Certification 1,300.00 150.00 1,450.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,450.00 ** 1,800.00 Budgeted 350.00 Remaining 81 % Used Account: 135-50020-021-000 Retirement 1817 07/05/2013 7/5/13 Payroll Retirement 32,725.56 568.93 33,294.49 PR 1878 07/19/2013 MUD Payroll 7/19/13 Retirement 564.08 33,858.57 PR _______________ Account: 135-50020-021-000 Retirement Totals: 1,133.01 33,858.57 ** 42,910.00 Budgeted 9,051.43 Remaining 79 % Used Account: 135-50026-021-000 Medical Insurance 1817 07/05/2013 7/5/13 Payroll Medical Insurance 18,978.54 1,160.78 20,139.32 PR 1878 07/19/2013 MUD Payroll 7/19/13 Medical Insurance 1,160.77 21,300.09 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 2,321.55 21,300.09 ** 25,940.00 Budgeted 4,639.91 Remaining 82 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 37 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-021-000 Dental Insurance 1817 07/05/2013 7/5/13 Payroll Dental Insurance 1,332.72 79.95 1,412.67 PR 1878 07/19/2013 MUD Payroll 7/19/13 Dental Insurance 79.93 1,492.60 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 159.88 1,492.60 ** 1,812.00 Budgeted 319.40 Remaining 82 % Used Account: 135-50028-021-000 Vision Insurance 1817 07/05/2013 7/5/13 Payroll Vision Insurance 284.72 16.31 301.03 PR 1878 07/19/2013 MUD Payroll 7/19/13 Vision Insurance 16.29 317.32 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 32.60 317.32 ** 383.00 Budgeted 65.68 Remaining 83 % Used Account: 135-50029-021-000 Life Insurance & Other 1817 07/05/2013 7/5/13 Payroll Life Insurance & Other 804.67 59.53 864.20 PR 1933 07/23/2013 Life,AD&D,LTD exp correction 463.62 1,327.82 GL _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 523.15 1,327.82 ** 1,223.00 Budgeted (104.82) Remaining 109 % Used Account: 135-50030-021-000 Social Security Taxes 1817 07/05/2013 7/5/13 Payroll Social Security Taxes 7,036.54 360.19 7,396.73 PR 1878 07/19/2013 MUD Payroll 7/19/13 Social Security Taxes 354.73 7,751.46 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 714.92 7,751.46 ** 10,502.00 Budgeted 2,750.54 Remaining 74 % Used Account: 135-50035-021-000 Medicare Taxes 1817 07/05/2013 7/5/13 Payroll Medicare Taxes 1,645.61 84.25 1,729.86 PR 1878 07/19/2013 MUD Payroll 7/19/13 Medicare Taxes 82.96 1,812.82 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 167.21 1,812.82 ** 2,456.00 Budgeted 643.18 Remaining 74 % Used Account: 135-50040-021-000 Unemployment Taxes 34.39 .00 34.39 . glpdatb2 tsisk Trophy Club MUD #1 Page 38 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 34.39 ** 567.00 Budgeted 532.61 Remaining 6 % Used Account: 135-50045-021-000 Workman's Compensation 4,896.88 .00 4,896.88 _______________ Account: 135-50045-021-000 Workman's Compensation Totals: .00 4,896.88 ** 3,348.00 Budgeted (1,548.88) Remaining 146 % Used Account: 135-50070-021-000 Employee Relations 1996 07/26/2013 6/27-7/26 PCards FUZZY'S TACO SHOP 108.00 17.91 125.91 FUZZY'S TACO SHOP PC 1996 07/26/2013 6/27-7/26 PCards TOM THUMB STOR00017897 1.74 127.65 TOM THUMB STOR00017897 PC _______________ Account: 135-50070-021-000 Employee Relations Totals: 19.65 127.65 ** 250.00 Budgeted 122.35 Remaining 51 % Used Account: 135-55080-021-000 Maintenance & Repairs 1996 07/26/2013 6/27-7/26 PCards WW GRAINGER 17,462.78 687.00 18,149.78 WW GRAINGER PC _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 687.00 18,149.78 ** 20,000.00 Budgeted 1,850.22 Remaining 91 % Used Account: 135-55090-021-000 Vehicle Maintenance 1885 07/17/2013 July AP vehicle maintenance 1,405.88 17.38 1,423.26 ROANOKE AUTO SUPPLY 32786 AP _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 17.38 1,423.26 ** 1,600.00 Budgeted 176.74 Remaining 89 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 1885 07/17/2013 July AP Verizon 1,797.36 216.79 2,014.15 TOWN OF TROPHY CLUB 32803 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 216.79 2,014.15 ** 3,500.00 Budgeted 1,485.85 Remaining 58 % Used Account: 135-60020-021-000 Electricity 1945 07/25/2013 July AP elec 6/12-7/15 13,481.07 772.08 14,253.15 HUDSON ENERGY SERVICES, LLC 32816 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 39 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1945 07/25/2013 July AP elec 6/12-7/15 13,481.07 284.19 14,537.34 HUDSON ENERGY SERVICES, LLC 32816 AP 1945 07/25/2013 July AP electric-july 357.71 14,895.05 TRI COUNTY ELECTRIC 32827 AP 1945 07/25/2013 July AP electric-july 222.80 15,117.85 TRI COUNTY ELECTRIC 32827 AP 1945 07/25/2013 July AP eletric 29.38 15,147.23 TRI COUNTY ELECTRIC 32827 AP _______________ Account: 135-60020-021-000 Electricity Totals: 1,666.16 15,147.23 ** 18,705.00 Budgeted 3,557.77 Remaining 81 % Used Account: 135-60070-021-000 Dues & Memberships 250.00 .00 250.00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 250.00 ** 250.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-021-000 Schools & Training 830.00 .00 830.00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 830.00 ** 826.00 Budgeted (4.00) Remaining 100 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 2,092.93 .00 2,092.93 _______________ Account: 135-60100-021-000 Travel & per diem Totals: .00 2,092.93 ** 450.00 Budgeted (1,642.93) Remaining 465 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 40 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60243-021-000 Prior Year Expense 620.83 .00 620.83 _______________ Account: 135-60243-021-000 Prior Year Expense Totals: .00 620.83 ** 621.00 Budgeted .17 Remaining 100 % 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 2050 07/31/2013 July Gas log 6,510.84 972.90 7,483.74 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 972.90 7,483.74 ** 12,117.00 Budgeted 4,633.26 Remaining 62 % Used Account: 135-65010-021-000 Uniforms 934.13 .00 934.13 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 934.13 ** 2,220.00 Budgeted 1,285.87 Remaining 42 % Used Account: 135-65030-021-000 Chemicals 2,221.00 .00 2,221.00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 2,221.00 ** 7,500.00 Budgeted 5,279.00 Remaining 30 % Used Account: 135-65035-021-000 Small Tools 70.00 .00 70.00 _______________ Account: 135-65035-021-000 Small Tools Totals: .00 70.00 ** 1,250.00 Budgeted 1,180.00 Remaining 6 % Used Account: 135-65040-021-000 Safety Equipment . glpdatb2 tsisk Trophy Club MUD #1 Page 41 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 120.00 .00 120.00 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 120.00 ** 500.00 Budgeted 380.00 Remaining 24 % Used Account: 135-69005-021-000 Capital Expenses 15,276.00 .00 15,276.00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 15,276.00 ** 90,000.00 Budgeted 74,724.00 Remaining 17 % Used Account: 135-69008-021-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 40,260.00 Budgeted 40,260.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 271,495.49 ** 473,841.00 Budgeted 202,345.51 Remaining 57 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 42 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/2013 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 1817 07/05/2013 7/5/13 Payroll Salaries & Wages 7,500.00 1,200.00 8,700.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,200.00 8,700.00 ** 10,000.00 Budgeted 1,300.00 Remaining 87 % Used Account: 135-50030-026-000 Social Security Taxes 1817 07/05/2013 7/5/13 Payroll Social Security Taxes 465.00 74.40 539.40 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 74.40 539.40 ** 620.00 Budgeted 80.60 Remaining 87 % Used Account: 135-50035-026-000 Medicare Taxes 1817 07/05/2013 7/5/13 Payroll Medicare Taxes 108.75 17.40 126.15 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 17.40 126.15 ** 145.00 Budgeted 18.85 Remaining 87 % Used Account: 135-50040-026-000 Unemployment Taxes 1817 07/05/2013 7/5/13 Payroll Unemployment Taxes 66.30 1.20 67.50 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.20 67.50 ** 210.00 Budgeted 142.50 Remaining 32 % Used Account: 135-50045-026-000 Workman's Compensation 7.88 .00 7.88 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 7.88 ** 150.00 Budgeted 142.12 Remaining 5 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 tsisk Trophy Club MUD #1 Page 43 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 42.00 .00 42.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 42.00 ** 2,100.00 Budgeted 2,058.00 Remaining 2 % Used Account: 135-60075-026-000 Meetings 1979 07/05/2013 PCards 5/27-6/26/13 NW METROPORT CHAMBER O 434.97 22.00 456.97 NW METROPORT CHAMBER O PC _______________ Account: 135-60075-026-000 Meetings Totals: 22.00 456.97 ** 1,200.00 Budgeted 743.03 Remaining 38 % Used Account: 135-60080-026-000 Schools & Training 2,655.00 .00 2,655.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 2,655.00 ** 4,000.00 Budgeted 1,345.00 Remaining 66 % Used Account: 135-60100-026-000 Travel & per diem 1979 07/05/2013 PCards 5/27-6/26/13 HOLIDAY INNS 5,325.54 97.81 5,423.35 HOLIDAY INNS PC 1979 07/05/2013 PCards 5/27-6/26/13 AMERICAN AIRLINES 75.00 5,498.35 AMERICAN AIRLINES PC 1999 07/31/2013 July A/P mileage-TCEQ May 228.66 5,727.01 C. NICK SANDERS 32831 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 401.47 5,727.01 ** 5,000.00 Budgeted (727.01) Remaining 115 % Used Account: 135-60243-026-000 Prior Year Expense 107.10 .00 107.10 _______________ Account: 135-60243-026-000 Prior Year Expense Totals: .00 107.10 ** .00 Budgeted (107.10) Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses 267.88 .00 267.88 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 267.88 ** 3,000.00 Budgeted 2,732.12 Remaining 9 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 44 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/2013 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: ------------------------------------------------------------------------------------------------ 18,696.89 ** 26,575.00 Budgeted 7,878.11 Remaining 70 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 45 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 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 1817 07/05/2013 7/5/13 Payroll Salaries & Wages 307,088.43 16,568.63 323,657.06 PR 1878 07/19/2013 MUD Payroll 7/19/13 Salaries & Wages 16,578.13 340,235.19 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 33,146.76 340,235.19 ** 444,730.00 Budgeted 104,494.81 Remaining 77 % Used Account: 135-50010-030-000 Overtime 1817 07/05/2013 7/5/13 Payroll Overtime 239.94 7.66 247.60 PR 1878 07/19/2013 MUD Payroll 7/19/13 Overtime 17.01 264.61 PR _______________ Account: 135-50010-030-000 Overtime Totals: 24.67 264.61 ** 1,500.00 Budgeted 1,235.39 Remaining 18 % Used Account: 135-50016-030-000 Longevity 2,317.50 .00 2,317.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 2,317.50 ** 2,318.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 1817 07/05/2013 7/5/13 Payroll Retirement 78,319.47 1,488.56 79,808.03 PR 1878 07/19/2013 MUD Payroll 7/19/13 Retirement 1,490.24 81,298.27 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,978.80 81,298.27 ** 104,801.00 Budgeted 23,502.73 Remaining 78 % Used Account: 135-50026-030-000 Medical Insurance 1817 07/05/2013 7/5/13 Payroll Medical Insurance 35,884.50 2,194.07 38,078.57 PR 1878 07/19/2013 MUD Payroll 7/19/13 Medical Insurance 2,194.03 40,272.60 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,388.10 40,272.60 ** 49,049.00 Budgeted 8,776.40 Remaining 82 % Used Account: 135-50027-030-000 Dental Insurance 1817 07/05/2013 7/5/13 Payroll Dental Insurance 3,184.20 193.19 3,377.39 PR 1878 07/19/2013 MUD Payroll 7/19/13 Dental Insurance 193.15 3,570.54 PR . glpdatb2 tsisk Trophy Club MUD #1 Page 46 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 386.34 3,570.54 ** 3,379.00 Budgeted (191.54) Remaining 106 % Used Account: 135-50028-030-000 Vision Insurance 1817 07/05/2013 7/5/13 Payroll Vision Insurance 693.70 41.29 734.99 PR 1878 07/19/2013 MUD Payroll 7/19/13 Vision Insurance 41.24 776.23 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.53 776.23 ** 945.00 Budgeted 168.77 Remaining 82 % Used Account: 135-50029-030-000 Life Insurance & Other 1817 07/05/2013 7/5/13 Payroll Life Insurance & Other 2,069.25 136.33 2,205.58 PR 1933 07/23/2013 Life,AD&D,LTD exp correction 1,271.82 3,477.40 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 1,408.15 3,477.40 ** 2,582.00 Budgeted (895.40) Remaining 135 % Used Account: 135-50030-030-000 Social Security Taxes 1817 07/05/2013 7/5/13 Payroll Social Security Taxes 18,320.97 957.67 19,278.64 PR 1878 07/19/2013 MUD Payroll 7/19/13 Social Security Taxes 954.33 20,232.97 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,912.00 20,232.97 ** 27,802.00 Budgeted 7,569.03 Remaining 73 % Used Account: 135-50035-030-000 Medicare Taxes 1817 07/05/2013 7/5/13 Payroll Medicare Taxes 4,284.77 223.95 4,508.72 PR 1878 07/19/2013 MUD Payroll 7/19/13 Medicare Taxes 223.20 4,731.92 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 447.15 4,731.92 ** 6,502.00 Budgeted 1,770.08 Remaining 73 % Used Account: 135-50040-030-000 Unemployment Taxes 439.29 .00 439.29 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 439.29 ** 1,537.00 Budgeted 1,097.71 Remaining 29 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 47 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-030-000 Workman's Compensation 938.60 .00 938.60 _______________ Account: 135-50045-030-000 Workman's Compensation Totals: .00 938.60 ** 831.00 Budgeted (107.60) Remaining 113 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 39.00 .00 39.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 39.00 ** 250.00 Budgeted 211.00 Remaining 16 % Used Account: 135-50070-030-000 Employee Relations 1979 07/05/2013 PCards 5/27-6/26/13 TLF MERLINS GREENHOUSE 2,739.99 72.20 2,812.19 TLF MERLINS GREENHOUSE PC 1996 07/26/2013 6/27-7/26 PCards FUZZY'S TACO SHOP 17.91 2,830.10 FUZZY'S TACO SHOP PC 1996 07/26/2013 6/27-7/26 PCards TOM THUMB STOR00017897 1.75 2,831.85 TOM THUMB STOR00017897 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 91.86 2,831.85 ** 5,000.00 Budgeted 2,168.15 Remaining 57 % Used Account: 135-55030-030-000 Software & Support 1885 07/17/2013 July AP ISP-Charter 51,758.74 806.36 52,565.10 TOWN OF TROPHY CLUB 32803 AP 1885 07/17/2013 July AP ISP 368.75 52,933.85 TOWN OF TROPHY CLUB 32803 AP 1885 07/17/2013 July AP STW support 1,355.63 54,289.48 STW INC 32792 AP 1885 07/17/2013 July AP annual maintenance 989.04 55,278.52 BADGER METER, INC 32749 AP 1887 07/17/2013 July A/P BOA PCards 5/28/13-6/27/13 25.00 55,303.52 TOWN OF TROPHY CLUB 32803 AP 1887 07/17/2013 July A/P BOA PCards 5/28/13-6/27/13 53.38 55,356.90 TOWN OF TROPHY CLUB 32803 AP 1887 07/17/2013 July A/P BOA PCards 5/28/13-6/27/13 64.99 55,421.89 TOWN OF TROPHY CLUB 32803 AP 1945 07/25/2013 July AP STW support 475.88 55,897.77 STW INC 32823 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 4,139.03 55,897.77 ** 63,555.00 Budgeted 7,657.23 Remaining 88 % Used Account: 135-55070-030-000 Independent Labor 1885 07/17/2013 July AP front desk fill in 685.62 468.75 1,154.37 TAMARA THOMAS 32793 AP 1945 07/25/2013 July AP record mud meeting 63.75 1,218.12 MIGUEL CRUZ 32820 AP 1945 07/25/2013 July AP Rate study 4,254.55 5,472.67 NEW GEN STRATEGIES & SOLUTIONS 32821 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 4,787.05 5,472.67 ** 7,700.00 Budgeted 2,227.33 Remaining 71 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 48 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55075-030-000 Records Management .00 .00 _______________ Account: 135-55075-030-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-030-000 Maintenance & Repairs 810.52 .00 810.52 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 810.52 ** 811.00 Budgeted .48 Remaining 100 % Used Account: 135-55100-030-000 Building Maint & Supplies 1885 07/17/2013 July AP Rug service 4,238.93 84.15 4,323.08 G & K SERVICES 32763 AP 1885 07/17/2013 July AP rug service 84.15 4,407.23 G & K SERVICES 32763 AP 1885 07/17/2013 July AP rug service 84.15 4,491.38 G & K SERVICES 32763 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 252.45 4,491.38 ** 6,500.00 Budgeted 2,008.62 Remaining 69 % Used Account: 135-55120-030-000 Cleaning Services 1945 07/25/2013 July AP July cleaning service 13,875.76 1,678.51 15,554.27 ABM JANITORIAL SERVICES, INC 32807 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,678.51 15,554.27 ** 20,200.00 Budgeted 4,645.73 Remaining 77 % Used Account: 135-55160-030-000 Professional Outside Services 6,974.00 .00 6,974.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 6,974.00 ** 15,000.00 Budgeted 8,026.00 Remaining 46 % Used Account: 135-55161-030-000 Outside Services-Town Semo 85,465.00 .00 85,465.00 _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 85,465.00 ** 85,465.00 Budgeted .00 Remaining 100 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 49 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55165-030-000 Collection Fees 159.77 .00 159.77 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 159.77 ** 160.00 Budgeted .23 Remaining 100 % Used Account: 135-55205-030-000 Utility Billing Contract 1887 07/17/2013 July A/P June Utility Billing 5,106.06 632.68 5,738.74 DP2 BILLING SOLUTIONS, LLC 32758 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 632.68 5,738.74 ** 11,000.00 Budgeted 5,261.26 Remaining 52 % Used Account: 135-60005-030-000 Telephone 1887 07/17/2013 July A/P BOA PCards 5/28/13-6/27/13 8,436.87 26.97 8,463.84 TOWN OF TROPHY CLUB 32803 AP 1887 07/17/2013 July A/P BOA PCards 5/28/13-6/27/13 123.80 8,587.64 TOWN OF TROPHY CLUB 32803 AP 1887 07/17/2013 July A/P BOA PCards 5/28/13-6/27/13 392.46 8,980.10 TOWN OF TROPHY CLUB 32803 AP 1887 07/17/2013 July A/P BOA PCards 5/28/13-6/27/13 373.49 9,353.59 TOWN OF TROPHY CLUB 32803 AP 1945 07/25/2013 July AP answering svc 180.00 9,533.59 KEYSTONE PARK SECRETARIAL 32817 AP _______________ Account: 135-60005-030-000 Telephone Totals: 1,096.72 9,533.59 ** 10,500.00 Budgeted 966.41 Remaining 91 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1885 07/17/2013 July AP Verizon 2,622.44 176.73 2,799.17 TOWN OF TROPHY CLUB 32803 AP 1878 07/19/2013 MUD Payroll 7/19/13 Communications/Pagers/Mobiles 150.00 2,949.17 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 326.73 2,949.17 ** 3,575.00 Budgeted 625.83 Remaining 82 % Used Account: 135-60020-030-000 Electricity/Gas 1885 07/17/2013 July AP electricity 9,150.00 1,070.63 10,220.63 TOWN OF TROPHY CLUB 32803 AP 1945 07/25/2013 July AP Direct Energy Inv 1,070.63 11,291.26 TOWN OF TROPHY CLUB 32826 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 2,141.26 11,291.26 ** 13,019.00 Budgeted 1,727.74 Remaining 87 % Used Account: 135-60025-030-000 Water 1999 07/31/2013 July A/P water 652.80 185.59 838.39 TROPHY CLUB MUD (WATER BILLS) 32840 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 50 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60025-030-000 Water Totals: 185.59 838.39 ** 3,100.00 Budgeted 2,261.61 Remaining 27 % Used Account: 135-60030-030-000 Rent And/Or Usage 1945 07/25/2013 July AP public services building rent 9,886.59 1,098.51 10,985.10 TOWN OF TROPHY CLUB 32826 AP _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: 1,098.51 10,985.10 ** 13,182.00 Budgeted 2,196.90 Remaining 83 % Used Account: 135-60035-030-000 Postage 1913 07/01/2013 June Postage meter usage 21,162.82 85.64 21,248.46 GL 1885 07/17/2013 July AP overnight documents 15.47 21,263.93 FEDERAL EXPRESS CORP 32760 AP 1885 07/17/2013 July AP overnight to Metlife 6.17 21,270.10 FEDERAL EXPRESS CORP 32760 AP 1887 07/17/2013 July A/P June Utility Billing 1,590.88 22,860.98 DP2 BILLING SOLUTIONS, LLC 32758 AP 1996 07/26/2013 6/27-7/26 PCards USPS 48764506630613152 22.01 22,882.99 USPS 48764506630613152 PC _______________ Account: 135-60035-030-000 Postage Totals: 1,720.17 22,882.99 ** 26,604.00 Budgeted 3,721.01 Remaining 86 % Used Account: 135-60040-030-000 Service Charges & Fees 1975 07/02/2013 Online and Credit card fees 20,869.19 2,306.36 23,175.55 GL 1975 07/02/2013 Online and Credit card fees 84.00 23,259.55 GL 1975 07/02/2013 Online and Credit card fees 61.59 23,321.14 GL 2030 07/24/2013 Monthly Bank Analysis charge 250.00 23,571.14 GL 1997 07/31/2013 July A/P Late payment fee 103.03 23,674.17 JPMORGAN CHASE BANK NA 32837 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,804.98 23,674.17 ** 28,330.00 Budgeted 4,655.83 Remaining 84 % Used Account: 135-60050-030-000 Bad Debt Expense 1,001.40 .00 1,001.40 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 1,001.40 ** 8,500.00 Budgeted 7,498.60 Remaining 12 % Used Account: 135-60055-030-000 Insurance 1945 07/25/2013 July AP Bond-Schultz 50,943.77 50.00 50,993.77 VICTOR O SCHINNERER & CO, INC 32828 AP . glpdatb2 tsisk Trophy Club MUD #1 Page 51 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60055-030-000 Insurance Totals: 50.00 50,993.77 ** 50,694.00 Budgeted (299.77) Remaining 101 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 833.50 .00 833.50 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 833.50 ** 834.00 Budgeted .50 Remaining 100 % Used Account: 135-60070-030-000 Dues & Memberships 1945 07/25/2013 July AP membership 4,191.95 80.00 4,271.95 GOVT FINANCE OFFICERS ASSOC TX 32814 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 80.00 4,271.95 ** 3,892.00 Budgeted (379.95) Remaining 110 % Used Account: 135-60075-030-000 Meetings 283.85 .00 283.85 _______________ Account: 135-60075-030-000 Meetings Totals: .00 283.85 ** 400.00 Budgeted 116.15 Remaining 71 % Used Account: 135-60080-030-000 Schools & Training 1979 07/05/2013 PCards 5/27-6/26/13 TXDPS CRIME RECS 3,394.65 3.58 3,398.23 TXDPS CRIME RECS PC 1979 07/05/2013 PCards 5/27-6/26/13 TCEQ IND RENEWAL L 111.00 3,509.23 TCEQ IND RENEWAL L PC 1996 07/26/2013 6/27-7/26 PCards NCTCOG RTC TRAINING 250.00 3,759.23 NCTCOG RTC TRAINING PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 364.58 3,759.23 ** 5,350.00 Budgeted 1,590.77 Remaining 70 % Used Account: 135-60100-030-000 Travel & per diem 1817 07/05/2013 7/5/13 Payroll Travel & per diem 3,727.10 41.81 3,768.91 PR 1979 07/05/2013 PCards 5/27-6/26/13 BEST PARKING 19.49 3,788.40 BEST PARKING PC 1979 07/05/2013 PCards 5/27-6/26/13 WHATABURGER 313 Q26 6.91 3,795.31 WHATABURGER 313 Q26 PC 1979 07/05/2013 PCards 5/27-6/26/13 DOS COMALES 27.71 3,823.02 DOS COMALES PC 1979 07/05/2013 PCards 5/27-6/26/13 HOLIDAY INNS 322.00 4,145.02 HOLIDAY INNS PC 1979 07/05/2013 PCards 5/27-6/26/13 DRAGONFLY RESTAURANT & 48.88 4,193.90 DRAGONFLY RESTAURANT & PC 1979 07/05/2013 PCards 5/27-6/26/13 DICKEYS TX-548 5.95 4,199.85 DICKEYS TX-548 PC . glpdatb2 tsisk Trophy Club MUD #1 Page 52 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1979 07/05/2013 PCards 5/27-6/26/13 HOLIDAY INNS 3,727.10 97.81 4,297.66 HOLIDAY INNS PC 1979 07/05/2013 PCards 5/27-6/26/13 STARBUCKS-AMER10322212 1.93 4,299.59 STARBUCKS-AMER10322212 PC 1979 07/05/2013 PCards 5/27-6/26/13 DFW AIRPORT PARKING NP 40.00 4,339.59 DFW AIRPORT PARKING NP PC 1979 07/05/2013 PCards 5/27-6/26/13 STARBAUCKS A3520511655 4.71 4,344.30 STARBAUCKS A3520511655 PC 1979 07/05/2013 PCards 5/27-6/26/13 AA INFLIGHT MC 1 6.79 4,351.09 AA INFLIGHT MC 1 PC 1979 07/05/2013 PCards 5/27-6/26/13 AMERICAN AIRLINES 75.00 4,426.09 AMERICAN AIRLINES PC 1887 07/17/2013 July A/P Mileage reimbursement 34.35 4,460.44 LAURIE SLAGHT 32775 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 733.34 4,460.44 ** 3,616.00 Budgeted (844.44) Remaining 123 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising 1979 07/05/2013 PCards 5/27-6/26/13 4IMPRINT 1,418.90 704.02 2,122.92 4IMPRINT PC 1979 07/05/2013 PCards 5/27-6/26/13 ONLINE SIGN PURCHASE 268.72 2,391.64 ONLINE SIGN PURCHASE PC 1880 07/16/2013 Recode Adv & Ofc supplies TML Ad for Water Person 300.00 2,691.64 GL _______________ Account: 135-60125-030-000 Advertising Totals: 1,272.74 2,691.64 ** 4,000.00 Budgeted 1,308.36 Remaining 67 % Used Account: 135-60235-030-000 Security 505.13 .00 505.13 _______________ Account: 135-60235-030-000 Security Totals: .00 505.13 ** 1,350.00 Budgeted 844.87 Remaining 37 % Used Account: 135-60243-030-000 Prior Year Expense 3,290.58 .00 3,290.58 _______________ Account: 135-60243-030-000 Prior Year Expense Totals: .00 3,290.58 ** 1,263.00 Budgeted (2,027.58) Remaining 261 % Used Account: 135-60245-030-000 Miscellaneous Expenses . glpdatb2 tsisk Trophy Club MUD #1 Page 53 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1996 07/26/2013 6/27-7/26 PCards FASTSIGNS 1,035.22 155.37 1,190.59 FASTSIGNS PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 155.37 1,190.59 ** 13,500.00 Budgeted 12,309.41 Remaining 9 % Used Account: 135-60270-030-000 4th of July Celebration 1996 07/26/2013 6/27-7/26 PCards WAL-MART #5985 10,000.00 23.94 10,023.94 WAL-MART #5985 PC 1996 07/26/2013 6/27-7/26 PCards DOLRTREE 1907 00019075 51.00 10,074.94 DOLRTREE 1907 00019075 PC 1996 07/26/2013 6/27-7/26 PCards THE HOME DEPOT 6581 24.07 10,099.01 THE HOME DEPOT 6581 PC _______________ Account: 135-60270-030-000 4th of July Celebration Totals: 99.01 10,099.01 ** 10,500.00 Budgeted 400.99 Remaining 96 % Used Account: 135-60281-030-000 Park Expenses 1885 07/17/2013 July AP Harmony Park Expenses- june ex 31,727.33 2,949.02 34,676.35 TOWN OF TROPHY CLUB 32803 AP 1885 07/17/2013 July AP Harmony Park Expenses- june ex (2,174.35) 32,502.00 TOWN OF TROPHY CLUB 32803 AP _______________ Account: 135-60281-030-000 Park Expenses Totals: 774.67 32,502.00 ** 42,500.00 Budgeted 9,998.00 Remaining 76 % Used Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) 161,000.00 .00 161,000.00 _______________ Account: 135-60336-030-000 Interfund Trans Out (MUD1 I&S) Totals: .00 161,000.00 ** .00 Budgeted (161,000.00) Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 1979 07/05/2013 PCards 5/27-6/26/13 THE HOME DEPOT 6581 3,537.76 449.00 3,986.76 THE HOME DEPOT 6581 PC _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 449.00 3,986.76 ** 2,500.00 Budgeted (1,486.76) Remaining 159 % Used Account: 135-65010-030-000 Uniforms 624.12 .00 624.12 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 624.12 ** 1,635.00 Budgeted 1,010.88 Remaining 38 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 54 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65055-030-000 Hardware 12,129.34 .00 12,129.34 _______________ Account: 135-65055-030-000 Hardware Totals: .00 12,129.34 ** 20,188.00 Budgeted 8,058.66 Remaining 60 % Used Account: 135-65085-030-000 Office Supplies 1979 07/05/2013 PCards 5/27-6/26/13 ZAPCO, INC 6,895.56 65.11 6,960.67 ZAPCO, INC PC 1979 07/05/2013 PCards 5/27-6/26/13 AMAZON MKTPLACE PMTS 154.90 7,115.57 AMAZON MKTPLACE PMTS PC 1880 07/16/2013 Recode Adv & Ofc supplies Office supplies for water dept 109.68 7,225.25 GL 1945 07/25/2013 July AP Pcards-K Moore 118.83 7,344.08 TOWN OF TROPHY CLUB 32826 AP 1945 07/25/2013 July AP office supplies 105.82 7,449.90 OFFICE DEPOT, INC 32822 AP 1996 07/26/2013 6/27-7/26 PCards KELLER TROPHY AND AWAR 22.50 7,472.40 KELLER TROPHY AND AWAR PC _______________ Account: 135-65085-030-000 Office Supplies Totals: 576.84 7,472.40 ** 8,200.00 Budgeted 727.60 Remaining 91 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1885 07/17/2013 July AP Printer supplies 2,291.08 787.67 3,078.75 TOWN OF TROPHY CLUB 32803 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 787.67 3,078.75 ** 5,732.00 Budgeted 2,653.25 Remaining 54 % Used Account: 135-65095-030-000 Maintenance Supplies 1979 07/05/2013 PCards 5/27-6/26/13 GREAT COFFEES OF AMERI 2,215.94 83.04 2,298.98 GREAT COFFEES OF AMERI PC 1979 07/05/2013 PCards 5/27-6/26/13 SAMSCLUB #4795 146.56 2,445.54 SAMSCLUB #4795 PC 1979 07/05/2013 PCards 5/27-6/26/13 COSTCO.COM *ONLINE (24.75) 2,420.79 COSTCO.COM *ONLINE PC 1979 07/05/2013 PCards 5/27-6/26/13 SAMSCLUB #4795 174.21 2,595.00 SAMSCLUB #4795 PC 1945 07/25/2013 July AP Pcards-K Moore 42.79 2,637.79 TOWN OF TROPHY CLUB 32826 AP 1996 07/26/2013 6/27-7/26 PCards SAMSCLUB #4795 266.61 2,904.40 SAMSCLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 688.46 2,904.40 ** 1,500.00 Budgeted (1,404.40) Remaining 194 % Used Account: 135-65097-030-000 Vending Machine Supplies 1976 07/11/2013 Vending/WWTP 50.32 28.38 78.70 GL _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: 28.38 78.70 ** 500.00 Budgeted 421.30 Remaining 16 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 55 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65105-030-000 Printing 2,135.66 .00 2,135.66 _______________ Account: 135-65105-030-000 Printing Totals: .00 2,135.66 ** 4,200.00 Budgeted 2,064.34 Remaining 51 % Used Account: 135-69170-030-000 Copier Lease Installments 2,311.65 .00 2,311.65 _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: .00 2,311.65 ** 3,450.00 Budgeted 1,138.35 Remaining 67 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 .00 26,911.00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 26,911.00 ** 26,911.00 Budgeted .00 Remaining 100 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 1,102,660.63 ** 1,182,142.00 Budgeted 79,481.37 Remaining 93 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 56 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/2013 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 1885 07/17/2013 July AP legal 156,887.34 5,238.51 162,125.85 THE LISTON LAW FIRM, P.C. 32799 AP 1885 07/17/2013 July AP June legal 2,090.00 164,215.85 FREEMAN & CORBETT 32762 AP 1944 07/25/2013 July A/P Legal fees 15,000.00 179,215.85 THE LISTON LAW FIRM, P.C. 32825 AP 1945 07/25/2013 July AP june legal-general 2,014.96 181,230.81 WHITAKER CHALK SWINDLE 32829 AP 1945 07/25/2013 July AP June legal-CCN 502.20 181,733.01 WHITAKER CHALK SWINDLE 32829 AP 1945 07/25/2013 July AP june legal-service to Solana 168.00 181,901.01 WHITAKER CHALK SWINDLE 32829 AP 1945 07/25/2013 July AP June legal-Town contract 4,150.45 186,051.46 WHITAKER CHALK SWINDLE 32829 AP 1945 07/25/2013 July AP June legal-Bond refinancing 2,915.70 188,967.16 WHITAKER CHALK SWINDLE 32829 AP 1945 07/25/2013 July AP June legal-Custodial contract 915.25 189,882.41 WHITAKER CHALK SWINDLE 32829 AP _______________ Account: 135-55045-039-000 Legal Totals: 32,995.07 189,882.41 ** 70,000.00 Budgeted (119,882.41) Remaining 271 % Used Account: 135-55055-039-000 Auditing 20,700.00 .00 20,700.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 20,700.00 ** 21,200.00 Budgeted 500.00 Remaining 98 % Used Account: 135-55060-039-000 Appraisal 8,152.22 .00 8,152.22 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 8,152.22 ** 15,100.00 Budgeted 6,947.78 Remaining 54 % Used Account: 135-55065-039-000 Tax Admin Fees 2,390.56 .00 2,390.56 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,390.56 ** 3,800.00 Budgeted 1,409.44 Remaining 63 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 112,333.21 .00 112,333.21 _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: .00 112,333.21 ** .00 Budgeted (112,333.21) Remaining 0 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 57 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 39 Totals: ------------------------------------------------------------------------------------------------ 333,458.40 ** 110,100.00 Budgeted (223,358.40) Remaining 303 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 31,987.90 .00 Budgeted (31,987.90) Remaining 0 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 58 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (56,911.00) .00 (56,911.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (56,911.00) ** .00 Budgeted 56,911.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (41,890.00) .00 (41,890.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (41,890.00) ** .00 Budgeted 41,890.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (98,801.00) ** .00 Budgeted 98,801.00 Remaining 0 % Used Fund 137 Totals: ------------------------------------------------------------------------------------------------------ (98,801.00) .00 Budgeted 98,801.00 Remaining 0 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 59 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49005-000-000 Loan Proceeds (445,000.00) .00 (445,000.00) _______________ Account: 507-49005-000-000 Loan Proceeds Totals: .00 (445,000.00) ** (445,000.00) Budgeted .00 Remaining 100 % Used Account: 507-49010-000-000 Interest Income 2029 07/31/2013 July Bank Interest (68.09) (17.14) (85.23) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (17.14) (85.23) ** (100.00) Budgeted (14.77) Remaining 85 % Used Department Totals: ------------------------------------------------------------------------------------------------ (445,085.23) ** (445,100.00) Budgeted (14.77) Remaining 100 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 60 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 1 Security Cameras Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69005-010-001 Capital Exp/Security Cameras 6,289.00 .00 6,289.00 _______________ Account: 507-69005-010-001 Capital Exp/Security Cameras Totals: .00 6,289.00 ** 5,800.00 Budgeted (489.00) Remaining 108 % Used Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter 1886 07/17/2013 Rey-Mar App 1 Retainage ROFC 16,733.50 3,714.20 20,447.70 GL 1887 07/17/2013 July A/P Rate of Flow Control App 1 33,427.80 53,875.50 REY-MAR CONSTRUCTION 32784 AP _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: 37,142.00 53,875.50 ** 165,000.00 Budgeted 111,124.50 Remaining 33 % Used Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline 1885 07/17/2013 July AP indian creek waterline 9,079.33 3,914.50 12,993.83 TEAGUE, NALL & PERKINS,INC 32797 AP 1945 07/25/2013 July AP engineering 2,600.00 15,593.83 TEAGUE, NALL & PERKINS,INC 32824 AP _______________ Account: 507-69280-010-003 Capital Rep/Ind Crk Waterline Totals: 6,514.50 15,593.83 ** 210,000.00 Budgeted 194,406.17 Remaining 7 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 75,758.33 ** 380,800.00 Budgeted 305,041.67 Remaining 20 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 61 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 20 Wastewater Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-60335-020-000 Interfund Transfer Out (GF) 38,101.42 .00 38,101.42 _______________ Account: 507-60335-020-000 Interfund Transfer Out (GF) Totals: .00 38,101.42 ** .00 Budgeted (38,101.42) Remaining 0 % Used Account: 507-69005-020-001 Capital Exp/Security Cameras 8,578.00 .00 8,578.00 _______________ Account: 507-69005-020-001 Capital Exp/Security Cameras Totals: .00 8,578.00 ** 8,200.00 Budgeted (378.00) Remaining 105 % Used Account: 507-69005-020-004 Capital Exp/Sludge Blanket Ind .00 .00 _______________ Account: 507-69005-020-004 Capital Exp/Sludge Blanket Ind Totals: .00 .00 ** 18,000.00 Budgeted 18,000.00 Remaining 0 % Used Account: 507-69005-020-005 Capital Exp/Port Sub Pump 8,553.92 .00 8,553.92 _______________ Account: 507-69005-020-005 Capital Exp/Port Sub Pump Totals: .00 8,553.92 ** 10,000.00 Budgeted 1,446.08 Remaining 86 % Used Account: 507-69280-020-006 Capital Repairs/Waste Pump 27,960.70 .00 27,960.70 _______________ Account: 507-69280-020-006 Capital Repairs/Waste Pump Totals: .00 27,960.70 ** 28,000.00 Budgeted 39.30 Remaining 100 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 83,194.04 ** 64,200.00 Budgeted (18,994.04) Remaining 130 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ (286,132.86) (100.00) Budgeted 286,032.86 Remaining ########## . glpdatb2 tsisk Trophy Club MUD #1 Page 62 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 522 2010 GO/Fire Station Department: Revenues Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 522-49145-000-000 Intergov Transfer-General Fund (112,333.21) .00 (112,333.21) _______________ Account: 522-49145-000-000 Intergov Transfer-General Fund Totals: .00 (112,333.21) ** .00 Budgeted 112,333.21 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (112,333.21) ** .00 Budgeted 112,333.21 Remaining 0 % Used Fund 522 Totals: ------------------------------------------------------------------------------------------------------ (112,333.21) .00 Budgeted 112,333.21 Remaining 0 % Used TROPHY CLUB MUD #1 - I&S BALANCE SHEET JULY 31, 2013 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 686,508 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 12,262 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 703,616 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 12,262 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 12,262 FUND BALANCE ASSIGNED FUND BALANCE 136,417 NET REVENUES / EXPENDITURES 554,937 TOTAL FUND BALANCE 691,354 TOTAL LIABILITIES AND FUND BALANCE 703,616 . glbase_tbam tsisk Trophy Club MUD #1 Page 26 08:15 08/13/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 196,940.00- 196,940.00- 437.15- 197,782.18- 100.428 842.18 533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 109.76- 3,027.40- 77.626 872.60- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 53.47- 1,639.38- 32.676 3,377.62- Subtotal: 205,857.00- 205,857.00- 600.38- 202,448.96- 98.344 3,408.04- 533-48005-000-000 Reserve Funds/PID Utility Fees 345,000.00- 345,000.00- 161,000.00- 46.667 184,000.00- Subtotal: 345,000.00- 345,000.00- 161,000.00- 46.667 184,000.00- 533-49010-000-000 Interest Income 1,700.00- 1,700.00- 31.00- 303.90- 17.876 1,396.10- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- 100.000 Subtotal: 309,700.00- 309,700.00- 31.00- 308,303.90- 99.549 1,396.10- Program number: 860,557.00- 860,557.00- 631.38- 671,752.86- 78.060 188,804.14- Department number: Revenues 860,557.00- 860,557.00- 631.38- 671,752.86- 78.060 188,804.14- Revenues Subtotal ----------- 860,557.00- 860,557.00- 631.38- 671,752.86- 78.060 188,804.14- . glbase_tbam tsisk Trophy Club MUD #1 Page 27 08:15 08/13/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 1,300.00 2,300.00 57.500 1,700.00 533-70025-051-000 Bond Interest Expense 229,033.00 229,033.00 114,516.25 50.000 114,516.75 533-70035-051-000 Bond Principal Payment 605,000.00 605,000.00 605,000.00 Subtotal: 838,033.00 838,033.00 1,300.00 116,816.25 13.939 721,216.75 Program number: 838,033.00 838,033.00 1,300.00 116,816.25 13.939 721,216.75 Department number: Administration 838,033.00 838,033.00 1,300.00 116,816.25 13.939 721,216.75 Expenditures Subtotal ----------- 838,033.00 838,033.00 1,300.00 116,816.25 13.939 721,216.75 Fund number: 533 MUD 1 I&S Consolidated 22,524.00- 22,524.00- 668.62 554,936.61- 2,463.757 532,412.61 ******* End of Report ********* . glpdatb2 tsisk Trophy Club MUD #1 Page 63 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/2013 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 1863 07/02/2013 Property Taxes/Assessments (197,345.03) (.44) (197,345.47) GL 1864 07/08/2013 Property Taxes/Assessments (44.76) (197,390.23) GL 1865 07/10/2013 Property Taxes/Assessments (45.56) (197,435.79) GL 1866 07/10/2013 Property Taxes/Assessments (23.61) (197,459.40) GL 1967 07/11/2013 Property Taxes/Assessments (10.74) (197,470.14) GL 1968 07/15/2013 Property Taxes/Assessments (60.48) (197,530.62) GL 1969 07/17/2013 Property Taxes/Assessments (20.98) (197,551.60) GL 1970 07/18/2013 Property Taxes/Assessments (22.58) (197,574.18) GL 1971 07/19/2013 Property Taxes/Assessments (7.08) (197,581.26) GL 1972 07/22/2013 Property Taxes/Assessments (45.08) (197,626.34) GL 1973 07/23/2013 Property Taxes/Assessments (14.32) (197,640.66) GL 1974 07/24/2013 Property Taxes/Assessments (14.14) (197,654.80) GL 2022 07/25/2013 Property Taxes/Assessments (38.47) (197,693.27) GL 2023 07/29/2013 Property Taxes/Assessments (41.74) (197,735.01) GL 2024 07/30/2013 Property Taxes/Assessments (32.24) (197,767.25) GL 2025 07/31/2013 Property Taxes/Assessments (14.93) (197,782.18) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (437.15) (197,782.18) ** (196,940.00) Budgeted 842.18 Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1968 07/15/2013 Property Taxes/Assessments (2,917.64) (109.76) (3,027.40) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (109.76) (3,027.40) ** (3,900.00) Budgeted (872.60) Remaining 78 % Used Account: 533-40015-000-000 Property Taxes/P & I 1863 07/02/2013 Property Taxes/Assessments (1,585.91) (.06) (1,585.97) GL 1968 07/15/2013 Property Taxes/Assessments (42.16) (1,628.13) GL 1972 07/22/2013 Property Taxes/Assessments (3.40) (1,631.53) GL 1973 07/23/2013 Property Taxes/Assessments (.92) (1,632.45) GL 2022 07/25/2013 Property Taxes/Assessments (6.93) (1,639.38) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (53.47) (1,639.38) ** (5,017.00) Budgeted (3,377.62) Remaining 33 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees (161,000.00) .00 (161,000.00) . glpdatb2 tsisk Trophy Club MUD #1 Page 64 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 7/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 (161,000.00) ** (345,000.00) Budgeted (184,000.00) Remaining 47 % Used Account: 533-49010-000-000 Interest Income 2029 07/31/2013 July Bank Interest (272.90) (31.00) (303.90) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (31.00) (303.90) ** (1,700.00) Budgeted (1,396.10) Remaining 18 % Used Account: 533-49015-000-000 Lease/Rental Income (308,000.00) .00 (308,000.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (308,000.00) ** (308,000.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (671,752.86) ** (860,557.00) Budgeted (188,804.14) Remaining 78 % Used . glpdatb2 tsisk Trophy Club MUD #1 Page 65 08:16 08/13/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 7/2013 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 1915 07/23/2013 BONY/Bond Admin Fees TCMUD2 Ref CIB Ser 05 1,000.00 300.00 1,300.00 GL 1915 07/23/2013 BONY/Bond Admin Fees TCMUD2 Unl Tax Bonds Ser 03 1,000.00 2,300.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 1,300.00 2,300.00 ** 4,000.00 Budgeted 1,700.00 Remaining 58 % Used Account: 533-70025-051-000 Bond Interest Expense 114,516.25 .00 114,516.25 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 114,516.25 ** 229,033.00 Budgeted 114,516.75 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 605,000.00 Budgeted 605,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 116,816.25 ** 838,033.00 Budgeted 721,216.75 Remaining 14 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (554,936.61) (22,524.00) Budgeted 532,412.61 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (1,384,617.85) **** (22,624.00) Budgeted 1,361,993.85 Remaining ########## ******* End of Report *********