Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Aug 2011 Financial Summary
Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 8/31/2011 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 845,821 INVESTMENTS 2,206,749 RESTRICTED ASSETS: INVESTMENTS 403,901 PREPAID EXPENSES (987) ADVALOREM PROPERTY TAXES RECEIVABLE 2,815 UTILITY AND OTHER ACCOUNTS RECEIVABLE 600,564 TOTAL ASSETS 4,059,262$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,815$ ACCOUNTS PAYABLE 587,755 CUSTOMER DEPOSITS 184,487 TOTAL LIABILITIES 775,057 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT 219,414 UNDESIGNATED FUND BALANCE 3,064,792 TOTAL FUND BALANCE 3,284,205 TOTAL LIABILITIES AND FUND BALANCE 4,059,262$ August 31, 2011 11/12 Months (92% of Fiscal Year) Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 08/31/2011 From Account: 180 To Account: Run Date: 09/16/2011 User: rgonzales Segments/Accounts Total Budget MTD Rev. YTD Rev. Total Variance Total % [FUND] 180 : MUD 1 General Fund 180-000-000-30100 : Property Taxes 86,314.00 111.62 86,666.98 -352.98 -0.41% 180-000-000-30125 : Property Taxes/Delinquent 0.00 77.90 845.14 -845.14 0.00% 180-000-000-30150 : Property Taxes/Penalty & Interest 0.00 75.92 1,483.03 -1,483.03 0.00% 180-000-000-35050 : Interest Income 2,000.00 342.41 5,099.62 -3,099.62 -154.98% 180-000-000-35150 : Cell Tower Lease Revenue 10,164.00 847.00 9,317.00 847.00 8.33% 180-000-000-35170 : Building Rent 7,000.00 583.33 6,416.63 583.37 8.33% 180-000-000-36100 : Gas Well Revenues 2,000.00 89.06 854.41 1,145.59 57.28% 180-000-000-36400 : Auction Sales 0.00 0.00 202.12 -202.12 0.00% 180-000-000-36500 : Vending Revenue 850.00 0.00 830.81 19.19 2.26% 180-000-000-36700 : Miscellaneous Revenue 14,500.00 50.00 9,361.10 5,138.90 35.44% 180-000-000-36900 : Recovery of Prior Year Expense 0.00 0.00 2,119.00 -2,119.00 0.00% 180-000-000-38100 : Water - Residential 1,709,811.00 344,995.87 1,768,086.46 -58,275.46 -3.41% 180-000-000-38120 : Water - Commercial 777,075.00 161,229.13 742,797.82 34,277.18 4.41% 180-000-000-38130 : Water - PID 195,249.00 57,605.03 292,865.12 -97,616.12 -50.00% 180-000-000-38140 : Portable Meters - Out of District 16,000.00 6,317.00 45,810.67 -29,810.67 -186.32% 180-000-000-38200 : Sewer - Residential 1,098,146.00 116,890.16 1,030,002.96 68,143.04 6.20% 180-000-000-38220 : Sewer - Commercial 300,403.00 28,922.36 262,290.12 38,112.88 12.69% 180-000-000-38230 : Sewer - PID 74,364.00 19,404.62 148,221.23 -73,857.23 -99.32% 180-000-000-38240 : Sewer - Out of District 10,000.00 2,191.83 15,882.25 -5,882.25 -58.82% 180-000-000-38250 : TCCC Effluent Charges 47,500.00 15,424.76 59,523.29 -12,023.29 -25.31% 180-000-000-38300 : Standby 0.00 60.00 667.60 -667.60 0.00% 180-000-000-38320 : Penalties 50,000.00 4,510.69 41,186.44 8,813.56 17.63% 180-000-000-38340 : Service Charges 17,500.00 753.00 13,689.42 3,810.58 21.78% 180-000-000-38360 : Penalities - Out of District 500.00 0.00 270.19 229.81 45.96% 180-000-000-38400 : Plumbing Inspections 0.00 100.00 1,900.00 -1,900.00 0.00% 180-000-000-38420 : Sewer Inspections 3,000.00 300.00 5,700.00 -2,700.00 -90.00% 180-000-000-38500 : PID Utility Fees 167,900.00 27,600.00 108,100.00 59,800.00 35.62% 180-000-000-38540 : Sewer/Septic Dump Fees 48,000.00 0.00 0.00 48,000.00 100.00% PAGE 1 Segments/Accounts Total Budget MTD Rev. YTD Rev. Total Variance Total % 180-000-000-38560 : Fire Line Fees 5,000.00 0.00 525.00 4,475.00 89.50% 180-000-000-38600 : Oversize Meter Reimbursements 50,000.00 8,554.60 63,002.29 -13,002.29 -26.00% 180-000-000-39290 : Transfer In - Future Replacement Reserve 54,314.00 0.00 0.00 54,314.00 100.00% [FUND] SubTotal : 180 : MUD 1 General Fund 4,747,590.00 797,036.29 4,723,716.70 23,873.30 0.50% Grand Total : 4,747,590.00 797,036.29 4,723,716.70 23,873.30 0.50% PAGE 2 180-010-000-40100 Salaries - Regular 165,718.00 165,718.00 12,295.22 122,488.33 43,229.67 73.9 180-010-000-40130 Salaries - Overtime 8,814.00 8,814.00 2,960.63 15,272.89 (6,458.89) 173.3 180-010-000-40140 Salaries - Longevity 2,150.00 2,150.00 0.00 2,150.00 0.00 100.0 180-010-000-40160 Salaries - Certification 1,500.00 1,500.00 150.00 1,580.00 (80.00) 105.3 180-010-000-41200 Retirement 24,945.00 24,945.00 2,181.48 20,068.53 4,876.47 80.5 180-010-000-41210 Medical Insurance 27,748.00 27,748.00 2,592.25 21,745.64 6,002.36 78.4 180-010-000-41215 Dental Insurance 1,446.00 1,446.00 130.92 1,192.38 253.62 82.5 180-010-000-41216 Vision Insurance 269.00 269.00 22.95 213.38 55.62 79.3 180-010-000-41218 Life Insurance & Other 1,177.00 1,177.00 0.00 313.00 864.00 26.6 180-010-000-42220 Social Security Taxes 10,994.00 10,994.00 875.46 8,334.41 2,659.59 75.8 180-010-000-42225 Medicare Taxes 2,571.00 2,571.00 204.75 1,949.18 621.82 75.8 180-010-000-42250 Unemployment Taxes 720.00 720.00 0.00 329.40 390.60 45.7 180-010-000-42260 Workman's Compensation 7,764.00 7,764.00 0.00 7,368.69 395.31 94.9 180-010-000-42290 Pre-employment Physicals/Testing 200.00 200.00 0.00 0.00 200.00 # 180-010-000-42960 Employee Relations 350.00 350.00 0.00 226.04 123.96 64.6 180-010-000-50500 Engineering 1,500.00 1,500.00 0.00 80.15 1,419.85 5.3 180-010-000-52400 Lab Analysis 3,850.00 3,850.00 1,571.00 3,644.00 206.00 94.6 180-010-000-57000 Independent Labor 500.00 500.00 0.00 0.00 500.00 # 180-010-000-58000 Bulk Water 1,410,000.00 1,410,000.00 230,157.11 1,161,158.17 248,841.83 82.4 180-010-000-60300 Postage 250.00 250.00 0.00 13.35 236.65 5.3 180-010-000-60400 Publications/Books/Subscriptions 50.00 50.00 0.00 0.00 50.00 # 180-010-000-61000 Fuel 15,216.00 15,216.00 3,099.63 11,093.74 4,122.26 72.9 180-010-000-62100 Uniforms 3,690.00 3,690.00 0.00 1,882.87 1,807.13 51.0 180-010-000-62300 Chemicals 6,200.00 6,200.00 312.26 3,526.90 2,673.10 56.9 180-010-000-72100 Electricity 175,000.00 175,000.00 26,849.71 141,926.13 33,073.87 81.1 180-010-000-73200 Communications /Pagers/Mobiles 1,599.00 1,599.00 0.00 1,515.13 83.87 94.8 180-010-000-73350 Copies 50.00 50.00 0.00 0.00 50.00 # 180-010-000-73400 Printing 150.00 150.00 0.00 0.00 150.00 # 180-010-000-74100 Dues & Membership 150.00 150.00 0.00 61.00 89.00 40.7 180-010-000-74200 Travel & per diem 3,200.00 3,200.00 358.84 1,225.78 1,974.22 38.3 180-010-000-74300 Schools & Training 2,800.00 2,800.00 425.00 1,933.00 867.00 69.0 180-010-000-74700 Safety Program 500.00 500.00 0.00 7.17 492.83 1.4 180-010-000-75200 Annual Permit Fee 6,600.00 6,600.00 0.00 6,133.95 466.05 92.9 180-010-000-78100 Meter Expense 85,000.00 85,000.00 3,381.65 86,563.89 (1,563.89) 101.8 180-010-000-78200 Small Tools 2,500.00 2,500.00 3,684.61 3,969.48 (1,469.48) 158.8 180-010-000-78300 Safety Equipment 2,500.00 2,500.00 229.92 229.92 2,270.08 9.2 180-010-000-78500 Furniture/Equipment<$5,000 1,500.00 1,500.00 0.00 0.00 1,500.00 # 180-010-000-78600 Hardware 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-010-000-79150 Equipment Rental/Lease 500.00 500.00 0.00 770.00 (270.00) 154.0 page 1 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-010-000-79400 Bad Debt Expense 4,200.00 4,200.00 0.00 2,172.73 2,027.27 51.7 180-010-000-79999 Miscellaneous Expense 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-010-000-80250 Maintenance and Repairs 29,500.00 29,500.00 3,956.52 11,286.13 18,213.87 38.3 180-010-000-80300 Non-routine Maintenance 250.00 250.00 0.00 0.00 250.00 # 180-010-000-81100 Property Maintenance 4,200.00 4,200.00 594.00 1,296.85 2,903.15 30.9 180-010-000-81200 Building Maintenance 750.00 750.00 0.00 0.00 750.00 # 180-010-000-81300 Vehicle Maintenance 3,380.00 3,380.00 818.36 3,000.86 379.14 88.8 180-010-000-81360 Maintenance - Backhoe/Skid Loader 2,900.00 2,900.00 0.00 0.00 2,900.00 # 180-010-000-81500 Lawn Maintenance 2,000.00 2,000.00 0.00 0.00 2,000.00 # 180-010-000-81900 Maintenance Supplies 32,000.00 32,000.00 4,294.02 12,422.53 19,577.47 38.8 180-010-000-91000 Capital Lease 11,490.00 11,490.00 10,627.13 10,627.13 862.87 92.5 180-010-000-93700 Capital Expenses 130,932.00 130,932.00 113,767.31 329,620.76 (198,688.76) 251.7 180-010-000-97000 Capital Repairs 9,000.00 9,000.00 0.00 0.00 9,000.00 # 180-010-000-97100 Capital Repairs - Ground Storage 124,771.00 124,771.00 0.00 97,741.64 27,029.36 78.3 180-010-000-99500 Transfer to Future Replacement Reserve 30,000.00 30,000.00 30,000.00 30,000.00 0.00 100.0 Total Water 2,367,044.00 2,367,044.00 455,540.73 2,127,135.13 239,908.87 page 2 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-020-000-40100 Salaries - Regular 176,791.00 176,791.00 13,600.90 153,114.95 23,676.05 86.6 180-020-000-40130 Salaries - Overtime 10,166.00 10,166.00 1,260.73 12,703.20 (2,537.20) 125.0 180-020-000-40140 Salaries - Longevity 3,483.00 3,483.00 0.00 3,482.50 0.50 100.0 180-020-000-40160 Salaries - Certification 2,550.00 2,550.00 200.00 2,175.00 375.00 85.3 180-020-000-41200 Retirement 27,019.00 27,019.00 2,132.73 24,236.29 2,782.71 89.7 180-020-000-41210 Medical Insurance 37,298.00 37,298.00 2,785.32 33,424.09 3,873.91 89.6 180-020-000-41215 Dental Insurance 1,983.00 1,983.00 154.98 1,689.33 293.67 85.2 180-020-000-41216 Vision Insurance 341.00 341.00 29.76 327.36 13.64 96.0 180-020-000-41218 Life Insurance & Other 1,237.00 1,237.00 0.00 444.77 792.23 36.0 180-020-000-42220 Social Security Taxes 10,504.00 10,504.00 790.79 9,229.87 1,274.13 87.9 180-020-000-42225 Medicare Taxes 2,457.00 2,457.00 184.94 2,158.60 298.40 87.9 180-020-000-42250 Unemployment Taxes 720.00 720.00 0.00 434.45 285.55 60.3 180-020-000-42260 Workman's Compensation 8,410.00 8,410.00 0.00 7,981.82 428.18 94.9 180-020-000-42960 Employee Relations 250.00 250.00 0.00 151.88 98.12 60.8 180-020-000-50500 Engineering 4,000.00 4,000.00 0.00 2,800.00 1,200.00 70.0 180-020-000-52400 Lab Analysis 18,750.00 18,750.00 2,149.50 12,128.25 6,621.75 64.7 180-020-000-57000 Independent Labor 750.00 750.00 0.00 0.00 750.00 # 180-020-000-60100 Office Supplies 400.00 400.00 58.26 65.50 334.50 16.4 180-020-000-60300 Postage 120.00 120.00 0.00 0.00 120.00 # 180-020-000-60400 Publications/Books/Subscriptions 500.00 500.00 0.00 0.00 500.00 # 180-020-000-61000 Fuel 6,875.00 6,875.00 857.41 3,148.56 3,726.44 45.8 180-020-000-62100 Uniforms 2,205.00 2,205.00 0.00 1,449.17 755.83 65.7 180-020-000-62300 Chemicals 13,000.00 13,000.00 149.11 4,177.39 8,822.61 32.1 180-020-000-62800 Lab Supplies 6,085.00 6,085.00 561.49 4,120.55 1,964.45 67.7 180-020-000-62900 Other Consumables 110.00 110.00 0.00 50.14 59.86 45.6 180-020-000-72100 Electricity 205,000.00 205,000.00 16,832.55 182,581.50 22,418.50 89.1 180-020-000-72200 Water 1,900.00 1,900.00 0.00 1,288.84 611.16 67.8 180-020-000-72400 Dumpster Services 35,000.00 35,000.00 2,750.75 14,070.00 20,930.00 40.2 180-020-000-73100 Telephone 0.00 10.00 6.84 10.20 (0.20) 102.0 180-020-000-73200 Communications /Pagers/Mobiles 3,000.00 3,000.00 0.00 2,848.56 151.44 95.0 180-020-000-74200 Travel & per diem 1,750.00 1,750.00 180.20 2,090.60 (340.60) 119.5 180-020-000-74300 Schools & Training 1,320.00 1,320.00 0.00 900.00 420.00 68.2 180-020-000-74700 Safety Program 200.00 200.00 0.00 7.18 192.82 3.6 180-020-000-75200 Annual Permit Fee 7,500.00 7,500.00 0.00 10,704.14 (3,204.14) 142.7 180-020-000-78200 Small Tools 1,260.00 1,260.00 164.44 646.15 613.85 51.3 180-020-000-78300 Safety Equipment 540.00 540.00 46.13 704.36 (164.36) 130.4 180-020-000-78600 Hardware 525.00 525.00 0.00 35.81 489.19 6.8 180-020-000-79150 Equipment Rental/Lease 200.00 200.00 0.00 0.00 200.00 # 180-020-000-79999 Miscellaneous Expense 525.00 515.00 0.00 0.00 515.00 # 180-020-000-80250 Maintenance and Repairs 17,750.00 17,750.00 395.72 11,834.73 5,915.27 66.7 page 3 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-020-000-81200 Building Maintenance 1,400.00 1,400.00 0.00 0.00 1,400.00 # 180-020-000-81300 Vehicle Maintenance 4,998.00 4,998.00 366.36 1,416.10 3,581.90 28.3 180-020-000-81360 Maintenance - Backhoe/Skid Loader 2,950.00 2,950.00 0.00 1,126.76 1,823.24 38.2 180-020-000-81500 Lawn Maintenance 525.00 525.00 0.00 95.90 429.10 18.3 180-020-000-81900 Maintenance Supplies 5,860.00 5,860.00 175.01 936.83 4,923.17 16.0 180-020-000-93700 Capital Expenses 136,189.00 136,189.00 0.00 124,550.39 11,638.61 91.5 180-020-000-97000 Capital Repairs 35,000.00 35,000.00 0.00 1,500.00 33,500.00 4.3 Total Wastewater 799,396.00 799,396.00 45,833.92 636,841.72 162,554.28 page 4 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-021-000-40100 Salaries - Regular 136,341.00 136,341.00 10,518.72 118,255.68 18,085.32 86.7 180-021-000-40130 Salaries - Overtime 14,145.00 14,145.00 2,761.47 16,577.91 (2,432.91) 117.2 180-021-000-40140 Salaries - Longevity 3,128.00 3,128.00 0.00 3,160.00 (32.00) 101.0 180-021-000-40160 Salaries - Certification 1,200.00 1,200.00 125.00 1,375.00 (175.00) 114.6 180-021-000-41200 Retirement 21,674.00 21,674.00 1,898.18 19,676.58 1,997.42 90.8 180-021-000-41210 Medical Insurance 28,228.00 28,228.00 1,978.38 23,174.22 5,053.78 82.1 180-021-000-41215 Dental Insurance 1,426.00 1,426.00 118.88 1,248.57 177.43 87.6 180-021-000-41216 Vision Insurance 253.00 253.00 19.86 210.42 42.58 83.2 180-021-000-41218 Life Insurance & Other 942.00 942.00 0.00 339.73 602.27 36.1 180-021-000-42220 Social Security Taxes 8,769.00 8,769.00 747.99 7,958.70 810.30 90.8 180-021-000-42225 Medicare Taxes 2,051.00 2,051.00 174.93 1,863.82 187.18 90.9 180-021-000-42250 Unemployment Taxes 540.00 540.00 0.00 333.23 206.77 61.7 180-021-000-42260 Workman's Compensation 4,412.00 4,412.00 0.00 4,187.36 224.64 94.9 180-021-000-42960 Employee Relations 250.00 250.00 0.00 191.59 58.41 76.6 180-021-000-50500 Engineering 1,500.00 1,500.00 0.00 80.14 1,419.86 5.3 180-021-000-57000 Independent Labor 200.00 200.00 0.00 0.00 200.00 # 180-021-000-60300 Postage 150.00 150.00 0.00 0.00 150.00 # 180-021-000-61000 Fuel 11,700.00 11,700.00 2,319.06 10,384.50 1,315.50 88.8 180-021-000-62100 Uniforms 2,505.00 2,505.00 0.00 860.75 1,644.25 34.4 180-021-000-62300 Chemicals 12,500.00 12,500.00 2,846.00 2,846.00 9,654.00 22.8 180-021-000-72100 Electricity 23,625.00 23,625.00 2,960.28 16,921.64 6,703.36 71.6 180-021-000-72200 Water 750.00 750.00 0.00 0.00 750.00 # 180-021-000-73100 Telephone 0.00 0.00 0.63 22.26 (22.26) # 180-021-000-73200 Communications /Pagers/Mobiles 2,796.00 2,796.00 0.00 2,332.91 463.09 83.4 180-021-000-74100 Dues & Membership 255.00 255.00 111.00 172.00 83.00 67.5 180-021-000-74200 Travel & per diem 1,500.00 1,500.00 81.44 665.34 834.66 44.4 180-021-000-74300 Schools & Training 2,818.00 2,818.00 0.00 55.00 2,763.00 2.0 180-021-000-74700 Safety Program 750.00 750.00 0.00 7.18 742.82 1.0 180-021-000-78200 Small Tools 1,500.00 1,500.00 0.00 220.58 1,279.42 14.7 180-021-000-78300 Safety Equipment 1,150.00 1,150.00 0.00 62.84 1,087.16 5.5 180-021-000-78600 Hardware 750.00 750.00 0.00 0.00 750.00 # 180-021-000-79150 Equipment Rental/Lease 44,107.00 44,107.00 0.00 0.00 44,107.00 # 180-021-000-79999 Miscellaneous Expense 100.00 100.00 0.00 0.00 100.00 # 180-021-000-80250 Maintenance and Repairs 23,700.00 23,700.00 0.00 4,175.22 19,524.78 17.6 180-021-000-81100 Property Maintenance 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-021-000-81200 Building Maintenance 750.00 750.00 0.00 0.00 750.00 # 180-021-000-81300 Vehicle Maintenance 8,143.00 8,143.00 0.00 5,841.37 2,301.63 71.7 180-021-000-81900 Maintenance Supplies 16,050.00 16,050.00 78.91 2,129.54 13,920.46 13.3 180-021-000-93700 Capital Expenses 15,000.00 15,000.00 10,979.25 10,979.25 4,020.75 73.2 180-021-000-97000 Capital Repairs 20,000.00 20,000.00 0.00 0.00 20,000.00 # page 5 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Total Collection 416,658.00 416,658.00 37,719.98 256,309.33 160,348.67 page 6 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-130-000-40100 Salaries - Regular 10,000.00 10,000.00 1,000.00 6,400.00 3,600.00 64.0 180-130-000-42220 Social Security Taxes 620.00 620.00 62.00 396.80 223.20 64.0 180-130-000-42225 Medicare Taxes 145.00 145.00 14.50 92.80 52.20 64.0 180-130-000-42250 Unemployment Taxes 210.00 210.00 8.00 74.60 135.40 35.5 180-130-000-42260 Workman's Compensation 120.00 120.00 0.00 113.88 6.12 94.9 180-130-000-60100 Office Supplies 50.00 50.00 0.00 0.00 50.00 # 180-130-000-60300 Postage 0.00 0.00 0.00 (1.86) 1.86 # 180-130-000-60400 Publications/Books/Subscriptions 50.00 50.00 0.00 0.00 50.00 # 180-130-000-74100 Dues & Membership 2,100.00 2,100.00 0.00 79.00 2,021.00 3.8 180-130-000-74200 Travel & per diem 5,805.00 5,805.00 0.00 968.26 4,836.74 16.7 180-130-000-74300 Schools & Training 4,000.00 4,000.00 0.00 2,140.00 1,860.00 53.5 180-130-000-74600 Meetings 1,278.00 1,278.00 37.00 326.00 952.00 25.5 180-130-000-79999 Miscellaneous Expense 150.00 150.00 0.00 0.00 150.00 # 180-130-000-87110 Water Conservation Program/Public Information 0.00 0.00 0.00 2,334.72 (2,334.72) # Total Board of Directors 24,528.00 24,528.00 1,121.50 12,924.20 11,603.80 page 7 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-140-000-40100 Salaries - Regular 214,374.00 214,374.00 13,240.34 183,599.40 30,774.60 85.6 180-140-000-40130 Salaries - Overtime 500.00 500.00 30.83 292.89 207.11 58.6 180-140-000-40140 Salaries - Longevity 2,580.00 2,580.00 0.00 2,755.00 (175.00) 106.8 180-140-000-41200 Retirement 30,360.00 30,360.00 1,834.03 25,705.57 4,654.43 84.7 180-140-000-41210 Medical Insurance 17,925.00 17,925.00 1,395.92 17,061.78 863.22 95.2 180-140-000-41215 Dental Insurance 930.00 930.00 77.42 873.71 56.29 93.9 180-140-000-41216 Vision Insurance 179.00 179.00 14.87 162.83 16.17 91.0 180-140-000-41218 Life Insurance & Other 1,205.00 1,205.00 0.00 390.74 814.26 32.4 180-140-000-42220 Social Security Taxes 13,474.00 13,474.00 772.14 11,494.04 1,979.96 85.3 180-140-000-42225 Medicare Taxes 3,151.00 3,151.00 180.59 2,711.82 439.18 86.1 180-140-000-42250 Unemployment Taxes 630.00 630.00 19.67 467.54 162.46 74.2 180-140-000-42260 Workman's Compensation 783.00 783.00 0.00 743.12 39.88 94.9 180-140-000-42290 Pre-employment Physicals/Testing 0.00 0.00 7.25 82.17 (82.17) # 180-140-000-42960 Employee Relations 1,000.00 1,000.00 2.50 908.67 91.33 90.9 180-140-000-50100 Professional Outside Services 229,076.00 229,076.00 0.00 228,075.63 1,000.37 99.6 180-140-000-52100 Elections 2,500.00 2,500.00 0.00 1,952.65 547.35 78.1 180-140-000-54200 Records Management 500.00 500.00 0.00 120.00 380.00 24.0 180-140-000-57000 Independent Labor 840.00 840.00 0.00 406.87 433.13 48.4 180-140-000-60100 Office Supplies 2,450.00 2,450.00 159.81 1,506.00 944.00 61.5 180-140-000-60300 Postage 1,571.00 1,571.00 217.22 2,171.31 (600.31) 138.2 180-140-000-60400 Publications/Books/Subscriptions 450.00 450.00 0.00 215.40 234.60 47.9 180-140-000-73100 Telephone 200.00 200.00 18.42 215.15 (15.15) 107.6 180-140-000-73200 Communications /Pagers/Mobiles 1,798.00 1,798.00 56.22 2,382.95 (584.95) 132.5 180-140-000-73300 Advertising 1,500.00 1,500.00 0.00 0.00 1,500.00 # 180-140-000-73400 Printing 515.00 515.00 0.00 3,170.00 (2,655.00) 615.5 180-140-000-73600 Service Charges & Fees 0.00 0.00 0.00 32.50 (32.50) # 180-140-000-74100 Dues & Membership 1,612.00 1,612.00 455.00 2,169.50 (557.50) 134.6 180-140-000-74200 Travel & per diem 3,088.00 3,088.00 0.00 1,201.01 1,886.99 38.9 180-140-000-74300 Schools & Training 2,555.00 2,555.00 619.91 2,260.84 294.16 88.5 180-140-000-74600 Meetings 312.00 312.00 67.83 183.83 128.17 58.9 180-140-000-76700 July 4 Celebration 10,000.00 10,000.00 10,000.00 10,000.00 0.00 100.0 180-140-000-78500 Furniture/Equipment<$5,000 1,750.00 1,750.00 0.00 4,081.30 (2,331.30) 233.2 180-140-000-79999 Miscellaneous Expense 100.00 100.00 10.06 10.06 89.94 10.1 Total Managers Office 547,908.00 547,908.00 29,180.03 507,404.28 40,503.72 page 8 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-611-000-40100 Salaries - Regular 70,839.00 70,839.00 5,449.60 60,371.56 10,467.44 85.2 180-611-000-40130 Salaries - Overtime 3,500.00 3,500.00 670.81 12,713.60 (9,213.60) 363.2 180-611-000-40140 Salaries - Longevity 1,710.00 1,710.00 0.00 1,710.00 0.00 100.0 180-611-000-41200 Retirement 10,647.00 10,647.00 866.65 10,672.39 (25.39) 100.2 180-611-000-41210 Medical Insurance 8,583.00 8,583.00 715.24 8,332.23 250.77 97.1 180-611-000-41215 Dental Insurance 393.00 393.00 43.06 452.78 (59.78) 115.2 180-611-000-41216 Vision Insurance 75.00 75.00 4.98 54.78 20.22 73.0 180-611-000-41218 Life Insurance & Other 424.00 424.00 0.00 146.23 277.77 34.5 180-611-000-42220 Social Security Taxes 4,697.00 4,697.00 319.00 4,125.37 571.63 87.8 180-611-000-42225 Medicare Taxes 1,099.00 1,099.00 74.61 964.81 134.19 87.8 180-611-000-42250 Unemployment Taxes 180.00 180.00 0.00 129.59 50.41 72.0 180-611-000-42260 Workman's Compensation 274.00 274.00 0.00 260.04 13.96 94.9 180-611-000-50100 Professional Outside Services 5,000.00 5,000.00 0.00 2,437.50 2,562.50 48.7 180-611-000-60100 Office Supplies 600.00 600.00 0.00 495.65 104.35 82.6 180-611-000-60300 Postage 500.00 500.00 56.72 363.47 136.53 72.7 180-611-000-60400 Publications/Books/Subscriptions 250.00 250.00 0.00 0.00 250.00 # 180-611-000-73100 Telephone 100.00 100.00 3.01 16.19 83.81 16.2 180-611-000-73200 Communications /Pagers/Mobiles 670.00 670.00 0.00 560.98 109.02 83.7 180-611-000-73300 Advertising 500.00 500.00 0.00 207.40 292.60 41.5 180-611-000-73400 Printing 500.00 500.00 0.00 0.00 500.00 # 180-611-000-73600 Service Charges & Fees 77.00 77.00 0.00 0.00 77.00 # 180-611-000-74100 Dues & Membership 413.00 413.00 95.00 117.00 296.00 28.3 180-611-000-74200 Travel & per diem 1,547.00 1,547.00 7.05 152.18 1,394.82 9.8 180-611-000-74300 Schools & Training 1,040.00 1,040.00 0.00 309.00 731.00 29.7 180-611-000-74600 Meetings 88.00 88.00 25.00 25.00 63.00 28.4 Total Finance 113,706.00 113,706.00 8,330.73 104,617.75 9,088.25 page 9 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-620-000-40100 Salaries - Regular 112,537.00 112,537.00 7,392.09 80,068.82 32,468.18 71.1 180-620-000-40130 Salaries - Overtime 1,500.00 1,500.00 322.91 1,029.34 470.66 68.6 180-620-000-40140 Salaries - Longevity 245.00 245.00 0.00 405.00 (160.00) 165.3 180-620-000-41200 Retirement 15,999.00 15,999.00 1,092.44 11,035.32 4,963.68 69.0 180-620-000-41210 Medical Insurance 21,773.00 21,773.00 1,612.79 16,388.23 5,384.77 75.3 180-620-000-41215 Dental Insurance 1,136.00 1,136.00 104.81 1,007.58 128.42 88.7 180-620-000-41216 Vision Insurance 209.00 209.00 18.48 177.91 31.09 85.1 180-620-000-41218 Life Insurance & Other 800.00 800.00 0.00 260.31 539.69 32.5 180-620-000-42220 Social Security Taxes 7,029.00 7,029.00 413.62 4,782.06 2,246.94 68.0 180-620-000-42225 Medicare Taxes 1,644.00 1,644.00 96.74 1,118.39 525.61 68.0 180-620-000-42250 Unemployment Taxes 540.00 540.00 16.87 410.47 129.53 76.0 180-620-000-42260 Workman's Compensation 411.00 411.00 0.00 390.08 20.92 94.9 180-620-000-42290 Pre-employment Physicals/Testing 0.00 0.00 7.75 30.23 (30.23) # 180-620-000-56200 Utility Billing Contract 11,000.00 11,000.00 0.00 8,840.88 2,159.12 80.4 180-620-000-57000 Independent Labor 800.00 800.00 0.00 0.00 800.00 # 180-620-000-60100 Office Supplies 700.00 700.00 98.44 504.43 195.57 72.1 180-620-000-60300 Postage 18,000.00 18,000.00 0.00 13,158.75 4,841.25 73.1 180-620-000-73100 Telephone 100.00 100.00 7.50 105.78 (5.78) 105.8 180-620-000-73200 Communications /Pagers/Mobiles 472.00 472.00 0.00 410.36 61.64 86.9 180-620-000-73400 Printing 3,000.00 3,000.00 0.00 2,152.00 848.00 71.7 180-620-000-73600 Service Charges & Fees 18,000.00 18,000.00 2,355.60 20,511.35 (2,511.35) 114.0 180-620-000-74100 Dues & Membership 71.00 71.00 0.00 0.00 71.00 # 180-620-000-74200 Travel & per diem 605.00 605.00 24.98 55.07 549.93 9.1 180-620-000-74300 Schools & Training 800.00 800.00 0.00 46.44 753.56 5.8 180-620-000-75600 TCEQ Annual Assessment Fee 20,000.00 20,000.00 0.00 19,248.17 751.83 96.2 180-620-000-79999 Miscellaneous Expense 200.00 200.00 0.00 1.84 198.16 0.9 Total Utility Billing 237,571.00 237,571.00 13,565.02 182,138.81 55,432.19 page 10 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-630-000-42290 Pre-employment Physicals/Testing 1,260.00 1,260.00 0.00 152.41 1,107.59 12.1 180-630-000-42960 Employee Relations 1,788.00 1,788.00 107.87 626.72 1,161.28 35.1 180-630-000-43240 Tuition Reimbursement 1,530.00 1,530.00 0.00 74.65 1,455.35 4.9 180-630-000-60100 Office Supplies 424.00 424.00 0.00 0.00 424.00 # 180-630-000-60300 Postage 104.00 104.00 0.00 0.00 104.00 # 180-630-000-60400 Publications/Books/Subscriptions 462.00 462.00 0.00 0.00 462.00 # 180-630-000-73100 Telephone 27.00 27.00 0.00 0.00 27.00 # 180-630-000-73400 Printing 113.00 113.00 0.00 0.00 113.00 # 180-630-000-74100 Dues & Membership 529.00 529.00 0.00 0.00 529.00 # 180-630-000-74200 Travel & per diem 8.00 8.00 0.00 0.00 8.00 # 180-630-000-74300 Schools & Training 566.00 566.00 0.00 0.00 566.00 # 180-630-000-74600 Meetings 134.00 134.00 0.00 0.00 134.00 # Total Human Resources 6,945.00 6,945.00 107.87 853.78 6,091.22 page 11 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-640-000-50700 Security 1,350.00 1,350.00 145.24 187.75 1,162.25 13.9 180-640-000-55000 Software & Support 50,453.00 50,453.00 6,788.49 50,224.94 228.06 99.5 180-640-000-57000 Independent Labor 1,464.00 1,464.00 0.00 2,348.75 (884.75) 160.4 180-640-000-60100 Office Supplies 371.00 371.00 25.42 270.03 100.97 72.8 180-640-000-60200 Printer Supplies 5,732.00 5,732.00 1,516.50 6,752.96 (1,020.96) 117.8 180-640-000-73100 Telephone 8,040.00 8,040.00 816.20 9,595.33 (1,555.33) 119.3 180-640-000-74200 Travel & per diem 0.00 0.00 0.00 16.18 (16.18) # 180-640-000-75900 Prompt Payment Interest 0.00 0.00 0.00 14.53 (14.53) # 180-640-000-78600 Hardware 60,152.00 60,152.00 1,690.46 38,745.09 21,406.91 64.4 180-640-000-79100 Copier Rental/Lease 3,450.00 3,450.00 273.29 2,732.90 717.10 79.2 180-640-000-99500 Transfer to Future Replacement Reserve 26,911.00 26,911.00 26,911.00 26,911.00 0.00 100.0 Total Information Services 157,923.00 157,923.00 38,166.60 137,799.46 20,123.54 page 12 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-710-000-52400 Lab Analysis 0.00 0.00 0.00 1,168.75 (1,168.75) # 180-710-000-62520 Vending Machine Supplies 1,000.00 1,000.00 0.00 429.28 570.72 42.9 180-710-000-72100 Electricity 20,895.00 20,895.00 1,426.32 12,391.29 8,503.71 59.3 180-710-000-72200 Water 1,061.00 1,061.00 0.00 560.41 500.59 52.8 180-710-000-75000 Insurance 31,081.00 31,081.00 100.00 23,575.81 7,505.19 75.9 180-710-000-79200 Building Rental/Lease 13,182.00 13,182.00 1,098.51 12,083.61 1,098.39 91.7 180-710-000-81200 Building Maintenance 11,970.00 11,970.00 47.50 13,446.44 (1,476.44) 112.3 180-710-000-81600 Cleaning Services 9,450.00 9,450.00 678.18 7,541.63 1,908.37 79.8 180-710-000-81900 Maintenance Supplies 2,100.00 2,100.00 150.28 1,680.74 419.26 80.0 Total Facilities Maintenance 90,739.00 90,739.00 3,500.79 72,877.96 17,861.04 page 13 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-810-000-50200 Auditing 27,500.00 27,500.00 0.00 27,500.00 0.00 100.0 180-810-000-50300 Legal 35,000.00 35,000.00 11,894.30 39,827.61 (4,827.61) 113.8 180-810-000-51100 Appraisal 20,211.00 20,211.00 0.00 12,269.68 7,941.32 60.7 180-810-000-51150 Tax Administration 3,603.00 3,603.00 0.00 2,696.56 906.44 74.8 180-810-000-99510 Transfer to Fire Construction Fund 0.00 0.00 272,718.65 272,718.65 (272,718.65) # Total Non Departmental 86,314.00 86,314.00 284,612.95 355,012.50 (268,698.50) Total Expenses 4,848,732.00 4,848,732.00 917,680.12 4,393,914.92 454,817.08 page 14 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance180-000-000-30100Property TaxesBalance Forward-86,555.36CR08/01/2011MUD 1 AV Taxes1868833.3708/02/2011MUD 1 AV Taxes198078.2508/03/2011MUD 1 AV Taxes186908.1808/04/2011MUD 1 AV Taxes186924.8208/05/2011MUD 1 AV Taxes1869539.3908/30/2011MUD 1 AV Taxes1995317.61Total0.00111.62 -86,666.98 CR180-000-000-30125Property Taxes/DelinquentBalance Forward-767.24CR08/10/2011MUD 1 AV Taxes197995.6608/30/2011Advalorem Taxes1995172.24Total0.0077.90-845.14 CR180-000-000-30150Property Taxes/Penalty & InterestBalance Forward-1,407.11CR08/02/2011Advalorem Taxes198070.4808/04/2011Advalorem Taxes186921.4908/05/2011Advalorem Taxes186957.4808/10/2011Advalorem Taxes197996.0608/30/2011Advalorem Taxes1995157.0608/30/2011Advalorem Taxes199533.35Total0.0075.92 -1,483.03 CR180-000-000-35050Interest IncomeBalance Forward-4,757.21CR08/31/2011August Bank Interest20256129.2008/31/2011August Bank Interest20256213.21Total0.00342.41 -5,099.62 CR180-000-000-35150Cell Tower Lease RevenueBalance Forward-8,470.00CR08/23/2011AT&T August Cell Tower Lease19002847.00Total0.00 847.00 -9,317.00 CR180-000-000-35160Lease/Rental RevenueBalance Forward0.00Total0.00 0.00 0.00180-000-000-35170Building RentBalance Forward-5,833.30CR08/23/2011Town/August Maint Barn Rent19004583.33Total0.00 583.33 -6,416.63 CR180-000-000-35420Loan ProceedsBalance Forward0.00Total0.00 0.00 0.00180-000-000-35430Capital Lease ProceedsBalance Forward0.00Total0.00 0.00 0.00180-000-000-36100Gas Well RevenuesBalance Forward-765.35CR08/26/2011Encana/gas well revenue1939589.06Total0.0089.06-854.41 CR180-000-000-36400Auction SalesBalance Forward-202.12CRTotal0.00 0.00 -202.12 CR180-000-000-36500Vending RevenueBalance Forward-830.81CRTotal0.00 0.00 -830.81 CR180-000-000-36700Miscellaneous RevenueBalance Forward-9,311.10CR08/31/2011Backflow testing/My Cherryo2003350.00Trophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011Total0.00 50.00 -9,361.10 CR180-000-000-36900Recovery of Prior Year ExpenseBalance Forward-2,119.00CRTotal0.00 0.00 -2,119.00 CR180-000-000-37100Prior Year ReservesBalance Forward0.00Total0.00 0.00 0.00180-000-000-38100Water - ResidentialBalance Forward-1,423,090.59CR08/09/2011UB Adjustments186724.7308/11/2011UB Adjustments186860.1008/31/2011August Credit Adjustments200352,411.8108/31/2011UB August Billing20037342,579.23Total0.00 344,995.87 -1,768,086.46 CR180-000-000-38120Water - CommercialBalance Forward-581,568.69CR08/31/2011August Credit Adjustments20035203.8508/31/2011UB August Billing20037161,432.98Total203.85 161,432.98 -742,797.82 CR180-000-000-38130Water - PIDBalance Forward-235,260.09CR08/23/2011PID July billed1900857,605.03Total0.00 57,605.03 -292,865.12 CR180-000-000-38140Portable Meters - Out of DistrictBalance Forward-39,493.67CR08/05/2011UB Adjustments182625,001.7608/15/2011UB Adjustments18892200.0008/23/2011UB Late Fees Applied19377429.6308/31/2011UB August Billing2003710,689.13Total5,001.76 11,318.76 -45,810.67 CR180-000-000-38200Sewer - ResidentialBalance Forward-913,112.80CR08/09/2011UB Adjustments186724.9608/11/2011UB Adjustments186860.0908/31/2011August Credit Adjustments200351,741.9408/31/2011UB August Billing20037118,637.15Total1,746.99 118,637.15 -1,030,002.96 CR180-000-000-38220Sewer - CommercialBalance Forward-233,367.76CR08/31/2011August Credit Adjustments2003581.1208/31/2011UB August Billing2003729,003.48Total81.12 29,003.48 -262,290.12 CR180-000-000-38230Sewer - PIDBalance Forward-128,816.61CR08/23/2011PID July billed1900819,404.62Total0.00 19,404.62 -148,221.23 CR180-000-000-38240Sewer - Out of DistrictBalance Forward-13,690.42CR08/31/2011UB August Billing200372,191.83Total0.00 2,191.83 -15,882.25 CR180-000-000-38250TCCC Effluent ChargesBalance Forward-44,098.53CR08/23/2011TCCC July Effluent1900615,424.76Total0.00 15,424.76 -59,523.29 CR180-000-000-38300StandbyBalance Forward-607.60CR08/31/2011August Credit Adjustments2003518.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/31/2011UB August Billing2003778.00Total18.0078.00-667.60 CR180-000-000-38320PenaltiesBalance Forward-36,675.75CR08/23/2011UB Late Fees Applied193774,576.9308/31/2011August Credit Adjustments20035178.4508/31/2011Reverse & Correct JE 20040/UB20366244.69Total244.69 4,755.38 -41,186.44 CR180-000-000-38340Service ChargesBalance Forward-12,936.42CR08/01/2011UB NSF Service Charge2029625.0008/10/2011 UB Adjustments 18676675.0008/10/2011 UB Adjustments 1868050.0008/12/2011 UB Adjustments Made 1935925.0008/15/2011 UB Adjustments Taken 1936325.0008/22/2011 UB Adjustments 1936725.0008/22/2011 UB Adjustments Taken 1977725.0008/31/2011 UB August Billing 200373.00Total50.00 803.00 -13,689.42 CR180-000-000-38360Penalities - Out of DistrictBalance Forward-270.19CRTotal0.00 0.00 -270.19 CR180-000-000-38400Plumbing InspectionsBalance Forward-1,800.00CR08/18/2011Permits 8/18/111899050.0008/29/2011Permits 8/29/111982550.00Total0.00100.00 -1,900.00 CR180-000-000-38420Sewer InspectionsBalance Forward-5,400.00CR08/18/2011Permits 8/18/1118990150.0008/29/2011 Permits 8/29/11 19825150.00Total0.00 300.00 -5,700.00 CR180-000-000-38500PID Utility FeesBalance Forward-80,500.00CR08/03/2011Permits 8/3/111898411,500.0008/04/2011Permits 8/4/11189864,600.0008/10/2011Permits 8/10/11189882,300.0008/24/2011Permits 8/24/11193892,300.0008/25/2011Permits 8/25/11193934,600.0008/29/2011Permits 8/29/11198252,300.00Total0.00 27,600.00 -108,100.00 CR180-000-000-38520Tap FeesBalance Forward0.00Total0.00 0.00 0.00180-000-000-38540Sewer/Septic Dump FeesBalance Forward0.00Total0.00 0.00 0.00180-000-000-38560Fire Line FeesBalance Forward-525.00CRTotal0.00 0.00 -525.00 CR180-000-000-38600Oversize Meter ReimbursementsBalance Forward-54,447.69CR08/03/2011Permits 8/3/11189841,460.0008/04/2011Permits 8/4/1118986584.0008/10/2011Permits 8/10/1118988292.0008/18/2011Permits 8/18/1118990292.0008/23/2011Permits 8/23/11193874,758.6008/24/2011Permits 8/24/1119389292.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/25/2011Permits 8/25/1119393584.0008/29/2011 Permits 8/29/11 19825292.00Total0.00 8,554.60 -63,002.29 CR180-000-000-39200Transfer In - General FundBalance Forward0.00Total0.00 0.00 0.00180-000-000-39290Transfer In - Future Replacement ReserveBalance Forward0.00Total0.00 0.00 0.00180-010-000-40100Salaries - RegularBalance Forward110,193.1108/05/2011 Payroll 08/05/11 186386,143.8608/19/2011 Payroll 08/19/11 190466,151.36Total12,295.22 0.00 122,488.33180-010-000-40130Salaries - OvertimeBalance Forward12,312.2608/05/2011 Payroll 08/05/11 186382,000.8408/19/2011 Payroll 08/19/11 19046959.79Total2,960.63 0.00 15,272.89180-010-000-40140Salaries - LongevityBalance Forward2,150.00Total0.00 0.00 2,150.00180-010-000-40160Salaries - CertificationBalance Forward1,430.0008/19/2011 Payroll 08/19/11 19046150.00Total150.00 0.00 1,580.00180-010-000-41200RetirementBalance Forward17,887.0508/05/2011 Payroll 08/05/11 186381,153.3008/19/2011 Payroll 08/19/11 190461,028.18Total2,181.48 0.00 20,068.53180-010-000-41210Medical InsuranceBalance Forward19,153.3908/05/2011 Payroll 08/05/11 186381,062.9808/19/2011 Payroll 08/19/11 190461,529.27Total2,592.25 0.00 21,745.64180-010-000-41215Dental InsuranceBalance Forward1,061.4608/05/2011 Payroll 08/05/11 1863863.7208/19/2011 Payroll 08/19/11 1904667.20Total130.92 0.00 1,192.38180-010-000-41216Vision InsuranceBalance Forward190.4308/05/2011 Payroll 08/05/11 1863811.1408/19/2011 Payroll 08/19/11 1904611.81Total22.95 0.00 213.38180-010-000-41218Life Insurance & OtherBalance Forward313.00Total0.00 0.00 313.00180-010-000-42220Social Security TaxesBalance Forward7,458.9508/05/2011 Payroll 08/05/11 18638479.5608/19/2011 Payroll 08/19/11 19046395.90Total875.46 0.00 8,334.41180-010-000-42225Medicare TaxesBalance Forward1,744.4308/05/2011 Payroll 08/05/11 18638112.15 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/19/2011Payroll 08/19/111904692.60Total204.750.00 1,949.18180-010-000-42250Unemployment TaxesBalance Forward329.40Total0.00 0.00 329.40180-010-000-42260Workman's CompensationBalance Forward7,368.69Total0.00 0.00 7,368.69180-010-000-42290Pre-employment Physicals/TestingBalance Forward0.00Total0.00 0.00 0.00180-010-000-42960Employee RelationsBalance Forward226.0408/31/2011 Breakfast for safety meeting 19834 Laurie Slaght 042611 25.0008/31/2011 Replacement check for 4/28/11 20122 Laurie Slaght 083111 25.00Total25.00 25.00 226.04180-010-000-50500EngineeringBalance Forward80.15Total0.00 0.00 80.15180-010-000-52400Lab AnalysisBalance Forward2,073.0008/11/2011 Lab Analysis 18530 Lower Colorado River Authority LB85885 1,391.0008/11/2011 Lab Cultures 18562 Tarrant County Public Health Lab 21053 180.00Total1,571.00 0.00 3,644.00180-010-000-57000Independent LaborBalance Forward0.00Total0.00 0.00 0.00180-010-000-58000Bulk WaterBalance Forward931,001.0608/31/2011 July Water 20136 City of Fort Worth 082911 230,157.11Total230,157.11 0.00 1,161,158.17180-010-000-60300PostageBalance Forward13.35Total0.00 0.00 13.35180-010-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00180-010-000-61000FuelBalance Forward7,994.1108/01/2011 Gas Log/July 190121,523.2608/04/2011 Adrian Womack 18522 JP Morgan Chase Bank NA 07202011 40.0808/31/2011 August Gas log 202761,536.29Total3,099.63 0.00 11,093.74180-010-000-62100UniformsBalance Forward1,882.87Total0.00 0.00 1,882.87180-010-000-62300ChemicalsBalance Forward3,214.6408/04/2011 Adrian Womack 18522 JP Morgan Chase Bank NA 07202011 312.26Total312.26 0.00 3,526.90180-010-000-72100ElectricityBalance Forward115,076.4208/02/2011 Electricity 7/5-8/2 19201 Tri County Electric 2309888001 0811 27.6908/17/2011 Electricity 7/15-8/15 19163 Hudson Energy 2219284 625.0608/23/2011 Electricity 7/15-8/15 19437 Hudson Energy 16740 26,196.96Total26,849.71 0.00 141,926.13 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-010-000-73200Communications /Pagers/MobilesBalanceForward1,515.13Total0.00 0.00 1,515.13180-010-000-73350CopiesBalance Forward0.00Total0.00 0.00 0.00180-010-000-73400PrintingBalance Forward0.00Total0.00 0.00 0.00180-010-000-74100Dues & MembershipBalance Forward61.00Total0.00 0.00 61.00180-010-000-74200Travel & per diemBalance Forward866.9408/05/2011 Payroll 08/05/11 18638102.5108/19/2011 Payroll 08/19/11 19046167.0608/31/2011 Mike McMahon 20610 JP Morgan Chase Bank NA 08312011 89.27Total358.84 0.00 1,225.78180-010-000-74300Schools & TrainingBalance Forward1,508.0008/04/2011 Adrian Womack 18522 JP Morgan Chase Bank NA 07202011 175.0008/11/2011 Lance Holt-Ground Water Production Train 18540 TEEX 08222011 250.00Total425.00 0.00 1,933.00180-010-000-74700Safety ProgramBalance Forward7.17Total0.00 0.00 7.17180-010-000-75200Annual Permit FeeBalance Forward6,133.95Total0.00 0.00 6,133.95180-010-000-78100Meter ExpenseBalance Forward83,182.2408/16/2011 Mary Moore 18704 JP Morgan Chase Bank NA 08162011 3,381.65Total3,381.65 0.00 86,563.89180-010-000-78200Small ToolsBalance Forward284.8708/16/2011 Adrian Womack 18704 JP Morgan Chase Bank NA 08162011 3,684.61Total3,684.61 0.00 3,969.48180-010-000-78300Safety EquipmentBalance Forward0.0008/04/2011 Mike McMahon 18522 JP Morgan Chase Bank NA 07202011 229.92Total229.92 0.00 229.92180-010-000-78500Furniture/Equipment<$5,000Balance Forward0.00Total0.00 0.00 0.00180-010-000-78600HardwareBalance Forward0.00Total0.00 0.00 0.00180-010-000-79150Equipment Rental/LeaseBalance Forward770.00Total0.00 0.00 770.00180-010-000-79400Bad Debt ExpenseBalance Forward2,172.73Total0.00 0.00 2,172.73180-010-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.00 0.00 0.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-010-000-80250Maintenance and RepairsBalanceForward7,329.6108/04/2011 Adrian Womack 18522 JP Morgan Chase Bank NA 07202011 56.0708/04/2011 Adrian Womack 18522 JP Morgan Chase Bank NA 07202011 984.1708/04/2011 Adrian Womack 18522 JP Morgan Chase Bank NA 07202011 361.8508/11/2011 Maintenance and repairs on Well 18558 Circle R Electric Co 3967 1,057.5008/16/2011 Adrian Womack 18704 JP Morgan Chase Bank NA 08162011 423.1708/31/2011 Water Plant Effluent Flow Meter Re-Scale 20124 DHS Automation,Inc 06-878 440.0008/31/2011 Concrete - Lee Ct. 20130 Lattimore Materials Co 413705 331.2508/31/2011 Adrian Womack 20610 JP Morgan Chase Bank NA 08312011 302.51Total3,956.52 0.00 11,286.13180-010-000-80300Non-routine MaintenanceBalance Forward0.00Total0.00 0.00 0.00180-010-000-81100Property MaintenanceBalance Forward702.8508/16/2011 Adrian Womack 18704 JP Morgan Chase Bank NA 08162011 594.00Total594.00 0.00 1,296.85180-010-000-81200Building MaintenanceBalance Forward0.00Total0.00 0.00 0.00180-010-000-81300Vehicle MaintenanceBalance Forward2,182.5008/04/2011 Adrian Womack 18522 JP Morgan Chase Bank NA 07202011 34.9608/16/2011 Mike McMahon 18704 JP Morgan Chase Bank NA 08162011 383.4008/31/2011 Mike McMahon 20610 JP Morgan Chase Bank NA 08312011 400.00Total818.36 0.00 3,000.86180-010-000-81360Maintenance - Backhoe/Skid LoaderBalance Forward0.00Total0.00 0.00 0.00180-010-000-81500Lawn MaintenanceBalance Forward0.00Total0.00 0.00 0.00180-010-000-81900Maintenance SuppliesBalance Forward8,128.5108/02/2011 July purchases 17906 Costco Wholesale 072611 124.8008/16/2011 Adrian Womack 18704 JP Morgan Chase Bank NA 08162011 3,813.4908/16/2011 Mike McMahon 18704 JP Morgan Chase Bank NA 08162011 355.73Total4,294.02 0.00 12,422.53180-010-000-91000Capital LeaseBalance Forward0.0008/01/2011 Multi Loan 17876 First Financial Bank 91500005342Multiloan 10,627.13Total10,627.13 0.00 10,627.13180-010-000-93700Capital ExpensesBalance Forward215,853.4508/31/2011 WTP Ground Storage Tanks 20140 Deltatek Engineering 82611 1,605.0008/31/2011 Recode Water Capital Project to Gen Fund 2027038,100.0008/31/2011 Recode Water Capital Project to Gen Fund 2027058,800.0008/31/2011 Recode Water Capital Project to Gen Fund 20270500.0008/31/2011 Recode Water Capital Project to Gen Fund 2027014,762.31Total113,767.31 0.00 329,620.76180-010-000-97000Capital RepairsBalance Forward0.00Total0.00 0.00 0.00180-010-000-97100Capital Repairs - Ground StorageBalance Forward97,741.64Total0.00 0.00 97,741.64 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-010-000-99100Transfer to General FundBalanceForward0.00Total0.00 0.00 0.00180-010-000-99500Transfer to Future Replacement ReserveBalance Forward0.0008/31/2011 GASB Transfers 2027430,000.00Total30,000.00 0.00 30,000.00180-020-000-40100Salaries - RegularBalance Forward139,514.0508/05/2011 Payroll 08/05/11 186386,799.3008/19/2011 Payroll 08/19/11 190466,801.60Total13,600.90 0.00 153,114.95180-020-000-40130Salaries - OvertimeBalance Forward11,442.4708/05/2011 Payroll 08/05/11 18638422.8308/19/2011 Payroll 08/19/11 19046837.90Total1,260.73 0.00 12,703.20180-020-000-40140Salaries - LongevityBalance Forward3,482.50Total0.00 0.00 3,482.50180-020-000-40160Salaries - CertificationBalance Forward1,975.0008/19/2011 Payroll 08/19/11 19046200.00Total200.00 0.00 2,175.00180-020-000-41200RetirementBalance Forward22,103.5608/05/2011 Payroll 08/05/11 186381,022.6508/19/2011 Payroll 08/19/11 190461,110.08Total2,132.73 0.00 24,236.29180-020-000-41210Medical InsuranceBalance Forward30,638.7708/05/2011 Payroll 08/05/11 186381,392.6608/19/2011 Payroll 08/19/11 190461,392.66Total2,785.32 0.00 33,424.09180-020-000-41215Dental InsuranceBalance Forward1,534.3508/05/2011 Payroll 08/05/11 1863877.4908/19/2011 Payroll 08/19/11 1904677.49Total154.98 0.00 1,689.33180-020-000-41216Vision InsuranceBalance Forward297.6008/05/2011 Payroll 08/05/11 1863814.8808/19/2011 Payroll 08/19/11 1904614.88Total29.76 0.00 327.36180-020-000-41218Life Insurance & OtherBalance Forward444.77Total0.00 0.00 444.77180-020-000-42220Social Security TaxesBalance Forward8,439.0808/05/2011 Payroll 08/05/11 18638376.2608/19/2011 Payroll 08/19/11 19046414.53Total790.79 0.00 9,229.87180-020-000-42225Medicare TaxesBalance Forward1,973.6608/05/2011 Payroll 08/05/11 1863887.9908/19/2011 Payroll 08/19/11 1904696.95Total184.94 0.00 2,158.60 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-020-000-42250Unemployment TaxesBalanceForward434.45Total0.00 0.00 434.45180-020-000-42260Workman's CompensationBalance Forward7,981.82Total0.00 0.00 7,981.82180-020-000-42960Employee RelationsBalance Forward151.8808/31/2011 Breakfast for safety meeting 19834 Laurie Slaght 042611 25.0008/31/2011 Replacement check for 4/28/11 20122 Laurie Slaght 083111 25.00Total25.00 25.00 151.88180-020-000-50500EngineeringBalance Forward2,800.00Total0.00 0.00 2,800.00180-020-000-52400Lab AnalysisBalance Forward9,978.7508/04/2011 Mary Moore 18522 JP Morgan Chase Bank NA 07202011 1,069.5008/31/2011 Rodney Greenwood 20610 JP Morgan Chase Bank NA 08312011 1,080.00Total2,149.50 0.00 12,128.25180-020-000-57000Independent LaborBalance Forward0.00Total0.00 0.00 0.00180-020-000-60100Office SuppliesBalance Forward7.2408/15/2011 Office Supplies 19439 Office Depot 574982922001 46.2908/16/2011 Rodney Greenwood 18704 JP Morgan Chase Bank NA 08162011 11.97Total58.26 0.00 65.50180-020-000-60300PostageBalance Forward0.00Total0.00 0.00 0.00180-020-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00180-020-000-61000FuelBalance Forward2,291.1508/01/2011 Gas Log/July 19012468.9708/31/2011 August Gas log 20276388.44Total857.41 0.00 3,148.56180-020-000-62100UniformsBalance Forward1,449.17Total0.00 0.00 1,449.17180-020-000-62300ChemicalsBalance Forward4,028.2808/16/2011 Jeff Richey 18704 JP Morgan Chase Bank NA 08162011 149.11Total149.11 0.00 4,177.39180-020-000-62800Lab SuppliesBalance Forward3,559.0608/04/2011 Rodney Greenwood 18522 JP Morgan Chase Bank NA 07202011 85.8608/16/2011 Rodney Greenwood 18704 JP Morgan Chase Bank NA 08162011 475.63Total561.49 0.00 4,120.55180-020-000-62900Other ConsumablesBalance Forward50.14Total0.00 0.00 50.14180-020-000-72100ElectricityBalance Forward165,748.9508/17/2011 Electricity 7/15-8/14 19165 Hudson Energy 16672 16,832.55Total16,832.55 0.00 182,581.50 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-020-000-72200WaterBalanceForward1,288.84Total0.00 0.00 1,288.84180-020-000-72400Dumpster ServicesBalance Forward11,319.2508/04/2011 Mary Moore 18522 JP Morgan Chase Bank NA 07202011 63.2508/16/2011 Mary Moore 18704 JP Morgan Chase Bank NA 08162011 1,075.0008/31/2011 Sludge Haul Off 20100 L.H. Chaney Materials, Inc 0000036680 537.5008/31/2011 Sludge Hauling and Disposal Fee Per Yard 20104 L.H. Chaney Materials, Inc 0000035060 537.5008/31/2011 Sludge hauling and disposal fee per yard 20106 L.H. Chaney Materials, Inc 0000036054 537.50Total2,750.75 0.00 14,070.00180-020-000-73100TelephoneBalance Forward3.3608/31/2011 Steve Z. 20280 Bank of America 082711 6.84Total6.84 0.00 10.20180-020-000-73200Communications /Pagers/MobilesBalance Forward2,848.56Total0.00 0.00 2,848.56180-020-000-74200Travel & per diemBalance Forward1,910.4008/05/2011 Payroll 08/05/11 1863858.6508/19/2011 Payroll 08/19/11 19046121.55Total180.20 0.00 2,090.60180-020-000-74300Schools & TrainingBalance Forward900.00Total0.00 0.00 900.00180-020-000-74700Safety ProgramBalance Forward7.18Total0.00 0.00 7.18180-020-000-75200Annual Permit FeeBalance Forward10,704.14Total0.00 0.00 10,704.14180-020-000-78200Small ToolsBalance Forward481.7108/04/2011 Rodney Greenwood 18522 JP Morgan Chase Bank NA 07202011 147.8308/16/2011 Jeff Richey 18704 JP Morgan Chase Bank NA 08162011 16.61Total164.44 0.00 646.15180-020-000-78300Safety EquipmentBalance Forward658.2308/16/2011 Rodney Greenwood 18704 JP Morgan Chase Bank NA 08162011 46.13Total46.13 0.00 704.36180-020-000-78600HardwareBalance Forward35.81Total0.00 0.00 35.81180-020-000-79150Equipment Rental/LeaseBalance Forward0.00Total0.00 0.00 0.00180-020-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.00 0.00 0.00180-020-000-80250Maintenance and RepairsBalance Forward11,439.0108/04/2011 Rodney Greenwood 18522 JP Morgan Chase Bank NA 07202011 365.9108/16/2011 Rodney Greenwood 18704 JP Morgan Chase Bank NA 08162011 29.81Total395.72 0.00 11,834.73180-020-000-81100Property MaintenanceBalance Forward0.00Total0.00 0.00 0.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-020-000-81200Building MaintenanceBalanceForward0.00Total0.00 0.00 0.00180-020-000-81300Vehicle MaintenanceBalance Forward1,049.7408/04/2011 Jeff Richey 18522 JP Morgan Chase Bank NA 07202011 125.9208/31/2011 Rodney Greenwood 20610 JP Morgan Chase Bank NA 08312011 240.44Total366.36 0.00 1,416.10180-020-000-81360Maintenance - Backhoe/Skid LoaderBalance Forward1,126.76Total0.00 0.00 1,126.76180-020-000-81500Lawn MaintenanceBalance Forward95.90Total0.00 0.00 95.90180-020-000-81900Maintenance SuppliesBalance Forward761.8208/16/2011 Rodney Greenwood 18704 JP Morgan Chase Bank NA 08162011 93.8008/31/2011 Rodney Greenwood 20610 JP Morgan Chase Bank NA 08312011 81.21Total175.01 0.00 936.83180-020-000-93700Capital ExpensesBalance Forward124,550.39Total0.00 0.00 124,550.39180-020-000-97000Capital RepairsBalance Forward1,500.00Total0.00 0.00 1,500.00180-021-000-40100Salaries - RegularBalance Forward107,736.9608/05/2011 Payroll 08/05/11 186385,259.3608/19/2011 Payroll 08/19/11 190465,259.36Total10,518.72 0.00 118,255.68180-021-000-40130Salaries - OvertimeBalance Forward13,816.4408/05/2011 Payroll 08/05/11 186382,009.9508/19/2011 Payroll 08/19/11 19046751.52Total2,761.47 0.00 16,577.91180-021-000-40140Salaries - LongevityBalance Forward3,160.00Total0.00 0.00 3,160.00180-021-000-40160Salaries - CertificationBalance Forward1,250.0008/19/2011 Payroll 08/19/11 19046125.00Total125.00 0.00 1,375.00180-021-000-41200RetirementBalance Forward17,778.4008/05/2011 Payroll 08/05/11 186381,029.3308/19/2011 Payroll 08/19/11 19046868.85Total1,898.18 0.00 19,676.58180-021-000-41210Medical InsuranceBalance Forward21,195.8408/05/2011 Payroll 08/05/11 18638989.1908/19/2011 Payroll 08/19/11 19046989.19Total1,978.38 0.00 23,174.22180-021-000-41215Dental InsuranceBalance Forward1,129.6908/05/2011 Payroll 08/05/11 1863859.4408/19/2011 Payroll 08/19/11 1904659.44Total118.88 0.00 1,248.57 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-021-000-41216Vision InsuranceBalanceForward190.5608/05/2011 Payroll 08/05/11 186389.9308/19/2011 Payroll 08/19/11 190469.93Total19.86 0.00 210.42180-021-000-41218Life Insurance & OtherBalance Forward339.73Total0.00 0.00 339.73180-021-000-42220Social Security TaxesBalance Forward7,210.7108/05/2011 Payroll 08/05/11 18638409.1208/19/2011 Payroll 08/19/11 19046338.87Total747.99 0.00 7,958.70180-021-000-42225Medicare TaxesBalance Forward1,688.8908/05/2011 Payroll 08/05/11 1863895.6808/19/2011 Payroll 08/19/11 1904679.25Total174.93 0.00 1,863.82180-021-000-42250Unemployment TaxesBalance Forward333.23Total0.00 0.00 333.23180-021-000-42260Workman's CompensationBalance Forward4,187.36Total0.00 0.00 4,187.36180-021-000-42960Employee RelationsBalance Forward191.5908/31/2011 Breakfast for safety meeting 19834 Laurie Slaght 042611 25.0008/31/2011 Replacement check for 4/28/11 20122 Laurie Slaght 083111 25.00Total25.00 25.00 191.59180-021-000-50500EngineeringBalance Forward80.14Total0.00 0.00 80.14180-021-000-57000Independent LaborBalance Forward0.00Total0.00 0.00 0.00180-021-000-60300PostageBalance Forward0.00Total0.00 0.00 0.00180-021-000-61000FuelBalance Forward8,065.4408/01/2011 Gas Log/July 190121,203.0208/31/2011 August Gas log 202761,116.04Total2,319.06 0.00 10,384.50180-021-000-62100UniformsBalance Forward860.75Total0.00 0.00 860.75180-021-000-62300ChemicalsBalance Forward0.0008/11/2011 Chemicals - Degreaser and Solvent 18560 Nusco 0719111 2,846.00Total2,846.00 0.00 2,846.00180-021-000-72100ElectricityBalance Forward13,961.3608/02/2011 Electricity 7/5-8/2 19197 Tri County Electric 2009888001 0811 325.0108/02/2011 Electricity 7/5-8/2 19199 Tri County Electric 2209888001 0811 183.8308/11/2011 Electricity Collections 18556 Hudson Energy 16399 847.5708/16/2011 Mary Moore 18704 JP Morgan Chase Bank NA 08162011 609.2508/17/2011 Electricity 7/15-8/14 19165 Hudson Energy 16672 287.96 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/17/2011Electricity 7/15-8/1519167Hudson Energy16671706.66Total2,960.280.00 16,921.64180-021-000-72200WaterBalance Forward0.00Total0.00 0.00 0.00180-021-000-73100TelephoneBalance Forward21.6308/31/2011 Steve Z. 20280 Bank of America 082711 0.63Total0.63 0.00 22.26180-021-000-73200Communications /Pagers/MobilesBalance Forward2,332.91Total0.00 0.00 2,332.91180-021-000-74100Dues & MembershipBalance Forward61.0008/16/2011 Mary Moore 18704 JP Morgan Chase Bank NA 08162011 111.00Total111.00 0.00 172.00180-021-000-74200Travel & per diemBalance Forward583.9008/05/2011 Payroll 08/05/11 1863833.1508/19/2011 Payroll 08/19/11 1904648.29Total81.44 0.00 665.34180-021-000-74300Schools & TrainingBalance Forward55.00Total0.00 0.00 55.00180-021-000-74700Safety ProgramBalance Forward7.18Total0.00 0.00 7.18180-021-000-78200Small ToolsBalance Forward220.58Total0.00 0.00 220.58180-021-000-78300Safety EquipmentBalance Forward62.84Total0.00 0.00 62.84180-021-000-78600HardwareBalance Forward0.00Total0.00 0.00 0.00180-021-000-79150Equipment Rental/LeaseBalance Forward0.00Total0.00 0.00 0.00180-021-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.00 0.00 0.00180-021-000-80250Maintenance and RepairsBalance Forward4,175.22Total0.00 0.00 4,175.22180-021-000-81100Property MaintenanceBalance Forward0.00Total0.00 0.00 0.00180-021-000-81200Building MaintenanceBalance Forward0.00Total0.00 0.00 0.00180-021-000-81300Vehicle MaintenanceBalance Forward5,841.37Total0.00 0.00 5,841.37180-021-000-81900Maintenance SuppliesBalance Forward2,050.63 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/02/2011July purchases17906Costco Wholesale07261178.91Total78.910.00 2,129.54180-021-000-93700Capital ExpensesBalance Forward0.0008/04/2011 GapVax payment 17338 First Financial Bank 91500007041 071911 10,979.25Total10,979.25 0.00 10,979.25180-021-000-97000Capital RepairsBalance Forward0.00Total0.00 0.00 0.00180-130-000-40100Salaries - RegularBalance Forward5,400.0008/05/2011 Payroll 08/05/11 186381,000.00Total1,000.00 0.00 6,400.00180-130-000-42220Social Security TaxesBalance Forward334.8008/05/2011 Payroll 08/05/11 1863862.00Total62.00 0.00 396.80180-130-000-42225Medicare TaxesBalance Forward78.3008/05/2011 Payroll 08/05/11 1863814.50Total14.50 0.00 92.80180-130-000-42250Unemployment TaxesBalance Forward66.6008/05/2011 Payroll 08/05/11 186388.00Total8.00 0.00 74.60180-130-000-42260Workman's CompensationBalance Forward113.88Total0.00 0.00 113.88180-130-000-50100Professional Outside ServicesBalance Forward0.00Total0.00 0.00 0.00180-130-000-60100Office SuppliesBalance Forward0.00Total0.00 0.00 0.00180-130-000-60300PostageBalance Forward-1.86CRTotal0.00 0.00 -1.86 CR180-130-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00180-130-000-73300AdvertisingBalance Forward0.00Total0.00 0.00 0.00180-130-000-73400PrintingBalance Forward0.00Total0.00 0.00 0.00180-130-000-74100Dues & MembershipBalance Forward79.00Total0.00 0.00 79.00180-130-000-74200Travel & per diemBalance Forward968.26Total0.00 0.00 968.26180-130-000-74300Schools & TrainingBalance Forward2,140.00Total0.00 0.00 2,140.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-130-000-74600MeetingsBalanceForward289.0008/11/2011 Council members chamber seat signs. Jim 18554 Mulhollands 153594 15.0008/16/2011 Shannon Deprater 18704 JP Morgan Chase Bank NA 08162011 22.00Total37.00 0.00 326.00180-130-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.00 0.00 0.00180-130-000-87110Water Conservation Program/Public InformationBalance Forward2,334.72Total0.00 0.00 2,334.72180-140-000-40100Salaries - RegularBalance Forward170,359.0608/05/2011 Payroll 08/05/11 186386,454.2008/19/2011 Payroll 08/19/11 190466,786.14Total13,240.34 0.00 183,599.40180-140-000-40130Salaries - OvertimeBalance Forward262.0608/05/2011 Payroll 08/05/11 1863821.8308/19/2011 Payroll 08/19/11 190469.00Total30.83 0.00 292.89180-140-000-40140Salaries - LongevityBalance Forward2,755.00Total0.00 0.00 2,755.00180-140-000-41200RetirementBalance Forward23,871.5408/05/2011 Payroll 08/05/11 18638896.8608/19/2011 Payroll 08/19/11 19046937.17Total1,834.03 0.00 25,705.57180-140-000-41210Medical InsuranceBalance Forward15,665.8608/05/2011 Payroll 08/05/11 18638702.1608/19/2011 Payroll 08/19/11 19046693.76Total1,395.92 0.00 17,061.78180-140-000-41215Dental InsuranceBalance Forward796.2908/05/2011 Payroll 08/05/11 1863838.9308/19/2011 Payroll 08/19/11 1904638.49Total77.42 0.00 873.71180-140-000-41216Vision InsuranceBalance Forward147.9608/05/2011 Payroll 08/05/11 186387.4708/19/2011 Payroll 08/19/11 190467.40Total14.87 0.00 162.83180-140-000-41218Life Insurance & OtherBalance Forward390.74Total0.00 0.00 390.74180-140-000-42220Social Security TaxesBalance Forward10,721.9008/05/2011 Payroll 08/05/11 18638376.0008/19/2011 Payroll 08/19/11 19046396.14Total772.14 0.00 11,494.04180-140-000-42225Medicare TaxesBalance Forward2,531.2308/05/2011 Payroll 08/05/11 1863887.9408/19/2011 Payroll 08/19/11 1904692.65Total180.59 0.00 2,711.82 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-140-000-42250Unemployment TaxesBalanceForward447.8708/05/2011 Payroll 08/05/11 186388.5608/19/2011 Payroll 08/19/11 1904611.11Total19.67 0.00 467.54180-140-000-42260Workman's CompensationBalance Forward743.12Total0.00 0.00 743.12180-140-000-42290Pre-employment Physicals/TestingBalance Forward74.9208/01/2011 Pre-Employment testing/Schultz 19157 First Check Applicant Screening 2146 3.7508/11/2011 Kari Schultz, pre-employment testing 18552 First Check Applicant Screening 20035 3.50Total7.25 0.00 82.17180-140-000-42960Employee RelationsBalance Forward906.1708/19/2011 Reimburse MMoore petty cash 19203 Trophy Club MUD Petty Cash 081911MM 2.50Total2.50 0.00 908.67180-140-000-50100Professional Outside ServicesBalance Forward228,075.63Total0.00 0.00 228,075.63180-140-000-52100ElectionsBalance Forward1,952.65Total0.00 0.00 1,952.65180-140-000-54200Records ManagementBalance Forward120.00Total0.00 0.00 120.00180-140-000-57000Independent LaborBalance Forward406.87Total0.00 0.00 406.87180-140-000-60100Office SuppliesBalance Forward1,346.1908/04/2011 Mary Moore 18522 JP Morgan Chase Bank NA 07202011 106.9808/15/2011 Office Supplies 19439 Office Depot 574982922001 52.83Total159.81 0.00 1,506.00180-140-000-60300PostageBalance Forward1,954.0908/01/2011 July Postage meter usage 2028242.3208/04/2011 Mary Moore 18522 JP Morgan Chase Bank NA 07202011 83.2308/04/2011 Shannon Deprater 18522 JP Morgan Chase Bank NA 07202011 29.4008/04/2011 Tammy Ard 18522 JP Morgan Chase Bank NA 07202011 18.4008/31/2011 Gaslog Shipping Charges 20144 Federal Express Corp 7-607-42438 29.0408/31/2011 August Postage Meter usage 2028414.83Total217.22 0.00 2,171.31180-140-000-60400Publications/Books/SubscriptionsBalance Forward215.40Total0.00 0.00 215.40180-140-000-73100TelephoneBalance Forward196.7308/31/2011 Steve Z. 20280 Bank of America 082711 18.42Total18.42 0.00 215.15180-140-000-73200Communications /Pagers/MobilesBalance Forward2,326.7308/31/2011 Robert Scott 20610 JP Morgan Chase Bank NA 08312011 56.22Total56.22 0.00 2,382.95180-140-000-73300AdvertisingBalance Forward0.00Total0.00 0.00 0.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-140-000-73400PrintingBalanceForward3,170.00Total0.00 0.00 3,170.00180-140-000-73600Service Charges & FeesBalance Forward32.50Total0.00 0.00 32.50180-140-000-74100Dues & MembershipBalance Forward1,714.5008/02/2011 Security bond/Slaght 17912 American Surety Bond 080211Slaght 105.0008/02/2011 Notary Recording books 17922 State Notary Commission 080211 30.0008/02/2011 Security Bond/Schultz 17934 American Surety Bond 080211Schultz 105.0008/24/2011 Membership renewal 19151 Costco Membership 000111803072338 150.0008/31/2011 Laurie Slaght 20610 JP Morgan Chase Bank NA 08312011 65.00Total455.00 0.00 2,169.50180-140-000-74200Travel & per diemBalance Forward1,201.01Total0.00 0.00 1,201.01180-140-000-74300Schools & TrainingBalance Forward1,640.9308/02/2011 Notary Law & Procedure/Slaght 17888 North Central Texas COG 08102011/Slaght 130.0008/02/2011 Notary Law & Procedure/Schultz 17890 North Central Texas COG 08022011/Schultz 130.0008/02/2011 Municipal Clerks certification study/Sla 17904 Texas Municipal Clerks Certification Program080211300.0008/16/2011 Mary Moore 18704 JP Morgan Chase Bank NA 08162011 55.0008/19/2011 Reimburse MMoore petty cash 19203 Trophy Club MUD Petty Cash 081911MM 4.91Total619.91 0.00 2,260.84180-140-000-74600MeetingsBalance Forward116.0008/16/2011 Robert Scott 18704 JP Morgan Chase Bank NA 08162011 17.8308/25/2011 Legislative breakfast, Scott, Gonzales, 19425 Northwest Metroport Chamber 8104 50.00Total67.83 0.00 183.83180-140-000-76700July 4 CelebrationBalance Forward0.0008/31/2011 July 4th Celebration 20146 Town of Trophy Club 07042011 10,000.00Total10,000.00 0.00 10,000.00180-140-000-78500Furniture/Equipment<$5,000Balance Forward4,081.30Total0.00 0.00 4,081.30180-140-000-79999Miscellaneous ExpenseBalance Forward0.0008/19/2011 Reduce MM Petty Cash 1899610.06Total10.06 0.00 10.06180-611-000-40100Salaries - RegularBalance Forward54,921.9608/05/2011 Payroll 08/05/11 186382,724.8008/19/2011 Payroll 08/19/11 190462,724.80Total5,449.60 0.00 60,371.56180-611-000-40130Salaries - OvertimeBalance Forward12,042.7908/19/2011 Payroll 08/19/11 19046670.81Total670.81 0.00 12,713.60180-611-000-40140Salaries - LongevityBalance Forward1,710.00Total0.00 0.00 1,710.00180-611-000-41200RetirementBalance Forward9,805.7408/05/2011 Payroll 08/05/11 18638385.8308/19/2011 Payroll 08/19/11 19046480.82Total866.65 0.00 10,672.39 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-611-000-41210Medical InsuranceBalanceForward7,616.9908/05/2011 Payroll 08/05/11 18638357.6208/19/2011 Payroll 08/19/11 19046357.62Total715.24 0.00 8,332.23180-611-000-41215Dental InsuranceBalance Forward409.7208/05/2011 Payroll 08/05/11 1863821.5308/19/2011 Payroll 08/19/11 1904621.53Total43.06 0.00 452.78180-611-000-41216Vision InsuranceBalance Forward49.8008/05/2011 Payroll 08/05/11 186382.4908/19/2011 Payroll 08/19/11 190462.49Total4.98 0.00 54.78180-611-000-41218Life Insurance & OtherBalance Forward146.23Total0.00 0.00 146.23180-611-000-42220Social Security TaxesBalance Forward3,806.3708/05/2011 Payroll 08/05/11 18638138.7008/19/2011 Payroll 08/19/11 19046180.30Total319.00 0.00 4,125.37180-611-000-42225Medicare TaxesBalance Forward890.2008/05/2011 Payroll 08/05/11 1863832.4408/19/2011 Payroll 08/19/11 1904642.17Total74.61 0.00 964.81180-611-000-42250Unemployment TaxesBalance Forward129.59Total0.00 0.00 129.59180-611-000-42260Workman's CompensationBalance Forward260.04Total0.00 0.00 260.04180-611-000-42290Pre-employment Physicals/TestingBalance Forward0.00Total0.00 0.00 0.00180-611-000-50100Professional Outside ServicesBalance Forward2,437.50Total0.00 0.00 2,437.50180-611-000-60100Office SuppliesBalance Forward495.65Total0.00 0.00 495.65180-611-000-60300PostageBalance Forward306.7508/01/2011 July Postage meter usage 2028216.2808/31/2011 August Postage Meter usage 2028440.44Total56.72 0.00 363.47180-611-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00180-611-000-73100TelephoneBalance Forward13.1808/31/2011 Steve Z. 20280 Bank of America 082711 3.01Total3.01 0.00 16.19180-611-000-73200Communications /Pagers/MobilesBalance Forward560.98 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011Total0.00 0.00 560.98180-611-000-73300AdvertisingBalance Forward207.40Total0.00 0.00 207.40180-611-000-73400PrintingBalance Forward0.00Total0.00 0.00 0.00180-611-000-73600Service Charges & FeesBalance Forward0.00Total0.00 0.00 0.00180-611-000-74100Dues & MembershipBalance Forward22.0008/24/2011 Membership renewal/Gonzales 19161 Govt Finance Officers Assoc Texas 082411Gonzales 95.00Total95.00 0.00 117.00180-611-000-74200Travel & per diemBalance Forward145.1308/19/2011 Payroll 08/19/11 190467.05Total7.05 0.00 152.18180-611-000-74300Schools & TrainingBalance Forward309.00Total0.00 0.00 309.00180-611-000-74600MeetingsBalance Forward0.0008/25/2011 Legislative breakfast, Scott, Gonzales, 19425 Northwest Metroport Chamber 8104 25.00Total25.00 0.00 25.00180-611-000-78500Furniture/Equipment<$5,000Balance Forward0.00Total0.00 0.00 0.00180-611-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.00 0.00 0.00180-620-000-40100Salaries - RegularBalance Forward72,676.7308/05/2011 Payroll 08/05/11 186383,541.3708/19/2011 Payroll 08/19/11 190463,850.72Total7,392.09 0.00 80,068.82180-620-000-40130Salaries - OvertimeBalance Forward706.4308/05/2011 Payroll 08/05/11 18638187.4608/19/2011 Payroll 08/19/11 19046135.45Total322.91 0.00 1,029.34180-620-000-40140Salaries - LongevityBalance Forward405.00Total0.00 0.00 405.00180-620-000-41200RetirementBalance Forward9,942.8808/05/2011 Payroll 08/05/11 18638528.0108/19/2011 Payroll 08/19/11 19046564.43Total1,092.44 0.00 11,035.32180-620-000-41210Medical InsuranceBalance Forward14,775.4408/05/2011 Payroll 08/05/11 18638805.7408/19/2011 Payroll 08/19/11 19046807.05Total1,612.79 0.00 16,388.23180-620-000-41215Dental InsuranceBalance Forward902.7708/05/2011 Payroll 08/05/11 1863852.37 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/19/2011Payroll 08/19/111904652.44Total104.810.00 1,007.58180-620-000-41216Vision InsuranceBalance Forward159.4308/05/2011 Payroll 08/05/11 186389.2408/19/2011 Payroll 08/19/11 190469.24Total18.48 0.00 177.91180-620-000-41218Life Insurance & OtherBalance Forward260.31Total0.00 0.00 260.31180-620-000-42220Social Security TaxesBalance Forward4,368.4408/05/2011 Payroll 08/05/11 18638198.8808/19/2011 Payroll 08/19/11 19046214.74Total413.62 0.00 4,782.06180-620-000-42225Medicare TaxesBalance Forward1,021.6508/05/2011 Payroll 08/05/11 1863846.5208/19/2011 Payroll 08/19/11 1904650.22Total96.74 0.00 1,118.39180-620-000-42250Unemployment TaxesBalance Forward393.6008/05/2011 Payroll 08/05/11 186387.2508/19/2011 Payroll 08/19/11 190469.62Total16.87 0.00 410.47180-620-000-42260Workman's CompensationBalance Forward390.08Total0.00 0.00 390.08180-620-000-42290Pre-employment Physicals/TestingBalance Forward22.4808/01/2011 Pre-Employment testing/Schultz 19157 First Check Applicant Screening 2146 3.7508/11/2011 Kari Schultz, pre-employment testing 18552 First Check Applicant Screening 20035 4.00Total7.75 0.00 30.23180-620-000-56200Utility Billing ContractBalance Forward8,840.88Total0.00 0.00 8,840.88180-620-000-57000Independent LaborBalance Forward0.00Total0.00 0.00 0.00180-620-000-60100Office SuppliesBalance Forward405.9908/15/2011 Office Supplies 19439 Office Depot 574982922001 70.4208/25/2011 Office Supplies 20096 Office Depot 576602711001 3.7208/25/2011 Office Supplies 20098 Office Depot 576586689001 24.30Total98.44 0.00 504.43180-620-000-60300PostageBalance Forward13,158.75Total0.00 0.00 13,158.75180-620-000-73100TelephoneBalance Forward98.2808/31/2011 Steve Z. 20280 Bank of America 082711 7.50Total7.50 0.00 105.78180-620-000-73200Communications /Pagers/MobilesBalance Forward410.36Total0.00 0.00 410.36180-620-000-73400PrintingBalance Forward2,152.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011Total0.00 0.00 2,152.00180-620-000-73600Service Charges & FeesBalance Forward18,155.7508/04/2011 Credit Card fees/July 203009.9908/04/2011 Credit Card fees/July 20300363.6908/04/2011 Credit Card fees/July 203001,981.92Total2,355.60 0.00 20,511.35180-620-000-74100Dues & MembershipBalance Forward0.00Total0.00 0.00 0.00180-620-000-74200Travel & per diemBalance Forward30.0908/19/2011 Payroll 08/19/11 1904624.98Total24.98 0.00 55.07180-620-000-74300Schools & TrainingBalance Forward46.44Total0.00 0.00 46.44180-620-000-75600TCEQ Annual Assessment FeeBalance Forward19,248.17Total0.00 0.00 19,248.17180-620-000-79999Miscellaneous ExpenseBalance Forward1.84Total0.00 0.00 1.84180-620-000-99100Transfer to General FundBalance Forward0.00Total0.00 0.00 0.00180-630-000-42290Pre-employment Physicals/TestingBalance Forward152.41Total0.00 0.00 152.41180-630-000-42960Employee RelationsBalance Forward518.8508/04/2011 Tammy Ard 18522 JP Morgan Chase Bank NA 07202011 99.2208/11/2011 Frame for Employee of the Qtr. 18550 April Reiling 08012011 8.65Total107.87 0.00 626.72180-630-000-43240Tuition ReimbursementBalance Forward74.65Total0.00 0.00 74.65180-630-000-60100Office SuppliesBalance Forward0.00Total0.00 0.00 0.00180-630-000-60300PostageBalance Forward0.00Total0.00 0.00 0.00180-630-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00180-630-000-73100TelephoneBalance Forward0.00Total0.00 0.00 0.00180-630-000-73200Communications /Pagers/MobilesBalance Forward0.00Total0.00 0.00 0.00180-630-000-73400PrintingBalance Forward0.00Total0.00 0.00 0.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-630-000-74100Dues & MembershipBalanceForward0.00Total0.00 0.00 0.00180-630-000-74200Travel & per diemBalance Forward0.00Total0.00 0.00 0.00180-630-000-74300Schools & TrainingBalance Forward0.00Total0.00 0.00 0.00180-630-000-74600MeetingsBalance Forward0.00Total0.00 0.00 0.00180-630-000-99100Transfer to General FundBalance Forward0.00Total0.00 0.00 0.00180-640-000-50700SecurityBalance Forward42.5108/31/2011 Mike Pastor 20280 Bank of America 082711 145.24Total145.24 0.00 187.75180-640-000-55000Software & SupportBalance Forward43,436.4508/02/2011 Software support 18574 STW Inc 043011 389.6908/11/2011 JULY 2011 MONTHLY BANDWIDTH 18542 Bandwidth.com, Inc. IN08152011-2007145 326.6908/16/2011 Annual support 19183 Pipelogix, Inc. 1908 1,900.0008/28/2011 Support/June 20088 Prime Construction Co 082811 192.9708/28/2011 Support/June 20250 Prime Construction Co 082811 192.9708/31/2011 Steve Z. 20280 Bank of America 082711 54.9908/31/2011 Steve Z. 20280 Bank of America 082711 53.3808/31/2011 Mike Pastor 20280 Bank of America 082711 25.0008/31/2011 Mike Pastor 20280 Bank of America 082711 298.5008/31/2011 Steve Z. 20280 Bank of America 082711 293.9108/31/2011 Axiar Set up 20128 STW Inc 082211 17.3308/31/2011 CTY Connect Service 20142 Blackboard Connect Inc. 1076566 3,429.00Total6,981.46 192.97 50,224.94180-640-000-57000Independent LaborBalance Forward2,348.75Total0.00 0.00 2,348.75180-640-000-60100Office SuppliesBalance Forward244.6108/31/2011 Mike Pastor 20280 Bank of America 082711 25.42Total25.42 0.00 270.03180-640-000-60200Printer SuppliesBalance Forward5,236.4608/11/2011 Printer Cartridges 18532 SHI Governmental Solutions GS00037239 565.0008/11/2011 Printer Cartridges 18534 SHI Governmental Solutions GS00037190 666.5008/11/2011 HP Toner Cartridges 18536 SHI Governmental Solutions GS00036372 140.5008/31/2011 Steve Z. 20280 Bank of America 082711 144.50Total1,516.50 0.00 6,752.96180-640-000-73100TelephoneBalance Forward8,779.1308/31/2011 Hardware Headset Cord 20112 SHI Governmental Solutions GB00041332 12.7508/31/2011 Steve Z. 20280 Bank of America 082711 453.3008/31/2011 Steve Z. 20280 Bank of America 082711 350.15Total816.20 0.00 9,595.33180-640-000-73200Communications /Pagers/MobilesBalance Forward0.00Total0.00 0.00 0.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-640-000-74200Travel & per diemBalanceForward16.18Total0.00 0.00 16.18180-640-000-75900Prompt Payment InterestBalance Forward14.53Total0.00 0.00 14.53180-640-000-78600HardwareBalance Forward37,054.6308/01/2011 Repair Marquee 18566 ENTECH Assc/ENTECH SIGNS 2223 622.5008/31/2011 Hardware Headset Cord 20112 SHI Governmental Solutions GB00041332 599.0008/31/2011 Steve Z. 20280 Bank of America 082711 114.9908/31/2011 Steve Z. 20280 Bank of America 082711 353.97Total1,690.46 0.00 38,745.09180-640-000-79100Copier Rental/LeaseBalance Forward2,459.6108/01/2011 Adm Copier Lease/August 19171 Kyocera Mita America, Inc 110783868 146.7608/01/2011 PW Copier lease/August 19173 Kyocera Mita America, Inc 110783877 115.6208/01/2011 PW Fax lease/August 19175 Kyocera Mita America, Inc 110783878 10.91Total273.29 0.00 2,732.90180-640-000-99100Transfer to General FundBalance Forward0.00Total0.00 0.00 0.00180-640-000-99500Transfer to Future Replacement ReserveBalance Forward0.0008/31/2011 GASB Transfers 2027426,911.00Total26,911.00 0.00 26,911.00180-710-000-52400Lab AnalysisBalance Forward1,168.75Total0.00 0.00 1,168.75180-710-000-62520Vending Machine SuppliesBalance Forward429.28Total0.00 0.00 429.28180-710-000-72100ElectricityBalance Forward10,964.9708/31/2011 Electricity 20134 Direct Energy Business Svcs 1163697 1,426.32Total1,426.32 0.00 12,391.29180-710-000-72200WaterBalance Forward560.41Total0.00 0.00 560.41180-710-000-75000InsuranceBalance Forward23,475.8108/10/2011 Bond/Schultz 19205 Victor O Schinnerer & Co, Inc R110057802 50.0008/19/2011 Bond/Schaefer 19429 Victor O Schinnerer & Co, Inc R110058564 50.00Total100.00 0.00 23,575.81180-710-000-79200Building Rental/LeaseBalance Forward10,985.1008/01/2011 Public Services Bldg Rent/August 17926 Town of Trophy Club 080111 PS Bldg rent 1,098.51Total1,098.51 0.00 12,083.61180-710-000-81200Building MaintenanceBalance Forward13,398.9408/19/2011 Airconditioning service call 19153 Dennis Electric Co., Inc. 10605 47.50Total47.50 0.00 13,446.44180-710-000-81600Cleaning ServicesBalance Forward6,863.4508/01/2011 August janitorial service 18568 ABM Janitorial Services, Inc 2791855 559.5008/04/2011 Mary Moore 18522 JP Morgan Chase Bank NA 07202011 118.68Total678.18 0.00 7,541.63 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-710-000-81900Maintenance SuppliesBalanceForward1,530.4608/02/2011 July purchases 17906 Costco Wholesale 072611 36.3508/04/2011 Adrian Womack 18522 JP Morgan Chase Bank NA 07202011 39.0608/16/2011 Carolyn Huggins 18704 JP Morgan Chase Bank NA 08162011 41.3108/16/2011 Tammy Ard 18704 JP Morgan Chase Bank NA 08162011 16.5608/31/2011 Laurie Slaght 20610 JP Morgan Chase Bank NA 08312011 17.00Total150.28 0.00 1,680.74180-710-000-93300EquipmentBalance Forward0.00Total0.00 0.00 0.00180-810-000-50200AuditingBalance Forward27,500.00Total0.00 0.00 27,500.00180-810-000-50300LegalBalance Forward27,933.3108/01/2011 July 2011 Legal Fees 18524 The Liston Law Firm, P.C. 072011 5,734.6008/01/2011 June legal 19207 Whitaker, Chalk, Swindle LLP 154258 1,721.5008/01/2011 July legal 19209 Whitaker, Chalk, Swindle LLP 055049 320.0008/31/2011 August Legal 20090 The Liston Law Firm, P.C. 083111 4,118.20Total11,894.30 0.00 39,827.61180-810-000-51100AppraisalBalance Forward12,269.68Total0.00 0.00 12,269.68180-810-000-51150Tax AdministrationBalance Forward2,696.56Total0.00 0.00 2,696.56180-810-000-99510Transfer to Fire Construction FundBalance Forward0.0008/31/2011 Transfer to Fire Construction/Aug exp 20304272,718.65Total272,718.65 0.00 272,718.65GRAND TOTAL925,294.50 804,650.67 -329,801.78 380-010-000-93700 Capital Expenses 0.00 0.00 (112,162.31) 0.00 0.00 # 380-020-000-93700 Capital Expenses 0.00 0.00 0.00 210,220.60 (210,220.60) # Total Capital Projects 0.00 0.00 (112,162.31)210,220.60 (210,220.60) page 1 Budget to Actual - Capital Pro Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective DateDescriptionJournal #Vendor NameVendor Invoice #DebitCreditBalance380-000-000-35050Interest IncomeBalanceForward0.00Total0.000.000.00380-010-000-93700Capital ExpensesBalanceForward112,162.3108/31/2011Recode Water Capital Project to Gen Fund2027038,100.0008/31/2011Recode Water Capital Project to Gen Fund2027058,800.0008/31/2011Recode Water Capital Project to Gen Fund20270500.0008/31/2011Recode Water Capital Project to Gen Fund2027014,762.31Total0.00112,162.310.00380-020-000-93700Capital ExpensesBalanceForward210,220.60Total0.000.00 210,220.60GRAND TOTAL0.00 112,162.31 210,220.60Trophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011 Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 8/31/2011 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 346,388 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 23,938 ACCOUNTS RECEIVABLE - PID EMERGENCY SERVICES ASSESSMENTS 4,864 OTHER RECEIVABLES 12,602 TOTAL ASSETS 387,793$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 28,803$ ACCOUNTS PAYABLE 30,185 TOTAL LIABILITIES 58,988$ FUND BALANCE UNDESIGNATED FUND BALANCE 328,805 TOTAL LIABILITIES AND FUND BALANCE 387,793$ August 31, 2011 11/12 Months (92% of Fiscal Year) Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 08/31/2011 From Account: 190 To Account: Run Date: 09/16/2011 User: rgonzales Segments/Accounts Total Budget MTD Rev. YTD Rev. Total Variance Total % [FUND] 190 : Fire Department Operations 190-000-000-30050 : Emergency Service Assessment 111,648.00 0.00 120,126.77 -8,478.77 -7.59% 190-000-000-30060 : Emergency Services Assessment - Penalty & Interest 0.00 0.00 1,729.10 -1,729.10 0.00% 190-000-000-30100 : Property Taxes 1,072,786.00 1,387.31 1,072,733.87 52.13 0.00% 190-000-000-30125 : Property Taxes/Delinquent 0.00 217.27 8,967.76 -8,967.76 0.00% 190-000-000-30150 : Property Taxes/Penalty & Interest 7,500.00 338.82 5,256.30 2,243.70 29.92% 190-000-000-32014 : Fire Permits/Sprinkler 0.00 800.00 2,400.00 -2,400.00 0.00% 190-000-000-33050 : Fire Inspections 0.00 150.00 375.00 -375.00 0.00% 190-000-000-33420 : Denton/Tarrant County - Fire 13,750.00 0.00 10,000.00 3,750.00 27.27% 190-000-000-35050 : Interest Income 0.00 0.00 75.00 -75.00 0.00% 190-000-000-36700 : Miscellaneous Revenue 2,500.00 1,050.00 2,825.00 -325.00 -13.00% [FUND] SubTotal : 190 : Fire Department Operations 1,208,184.00 3,943.40 1,224,488.80 -16,304.80 -1.35% Grand Total : 1,208,184.00 3,943.40 1,224,488.80 -16,304.80 -1.35% PAGE 1 190-045-000-40100 Salaries - Regular 390,466.00 390,466.00 31,128.23 343,289.34 47,176.66 87.9 190-045-000-40130 Salaries - Overtime 40,298.00 40,298.00 5,638.48 47,794.33 (7,496.33) 118.6 190-045-000-40140 Salaries - Longevity 2,946.00 2,946.00 0.00 2,986.99 (40.99) 101.4 190-045-000-40160 Salaries - Certification 5,401.00 5,401.00 0.00 6,582.94 (1,181.94) 121.9 190-045-000-40180 Salaries - Holiday Pay 11,604.00 11,604.00 0.00 12,154.86 (550.86) 104.7 190-045-000-41200 Retirement 63,016.00 63,016.00 4,754.50 56,017.47 6,998.53 88.9 190-045-000-41210 Medical Insurance 54,809.00 54,809.00 3,919.68 48,278.23 6,530.77 88.1 190-045-000-41215 Dental Insurance 2,819.00 2,819.00 244.28 2,690.91 128.09 95.5 190-045-000-41216 Vision Insurance 505.00 505.00 37.78 431.39 73.61 85.4 190-045-000-41218 Life Insurance & Other 2,491.00 2,491.00 0.00 886.38 1,604.62 35.6 190-045-000-42220 Social Security Taxes 26,252.00 26,252.00 2,081.14 23,815.50 2,436.50 90.7 190-045-000-42225 Medicare Taxes 6,140.00 6,140.00 486.72 5,572.81 567.19 90.8 190-045-000-42250 Unemployment Taxes 1,387.00 1,387.00 20.29 954.78 432.22 68.8 190-045-000-42260 Workman's Compensation 13,134.00 13,134.00 0.00 12,465.28 668.72 94.9 190-045-000-42290 Pre-employment Physicals/Testing 675.00 675.00 0.00 195.50 479.50 29.0 190-045-000-50100 Professional Outside Services 40,000.00 40,000.00 0.00 0.00 40,000.00 # 190-045-000-54100 Physicals/Testing 1,880.00 1,880.00 0.00 0.00 1,880.00 # 190-045-000-60100 Office Supplies 319.00 319.00 0.00 215.63 103.37 67.6 190-045-000-60300 Postage 95.00 95.00 136.82 229.08 (134.08) 241.1 190-045-000-60400 Publications/Books/Subscriptions 382.00 382.00 0.00 0.00 382.00 # 190-045-000-61000 Fuel 16,585.00 16,585.00 2,240.48 10,836.10 5,748.90 65.3 190-045-000-62100 Uniforms 4,357.00 4,357.00 746.45 4,276.77 80.23 98.2 190-045-000-62150 Protective Clothing 7,600.00 7,600.00 5,422.00 6,178.18 1,421.82 81.3 190-045-000-62300 Chemicals 1,545.00 1,545.00 0.00 305.00 1,240.00 19.7 190-045-000-72100 Electricity 17,400.00 17,400.00 1,249.30 10,425.77 6,974.23 59.9 190-045-000-72200 Water 3,193.00 3,193.00 0.00 444.61 2,748.39 13.9 190-045-000-73100 Telephone 103.00 103.00 5.78 129.98 (26.98) 126.2 190-045-000-73200 Communications /Pagers/Mobiles 1,874.00 1,874.00 29.52 2,241.45 (367.45) 119.6 190-045-000-73300 Advertising 153.00 153.00 0.00 0.00 153.00 # 190-045-000-73400 Printing 103.00 103.00 0.00 0.00 103.00 # 190-045-000-74100 Dues & Membership 8,358.00 8,358.00 0.00 6,466.60 1,891.40 77.4 190-045-000-74200 Travel & per diem 7,107.00 7,107.00 0.00 3,531.41 3,575.59 49.7 190-045-000-74300 Schools & Training 6,615.00 6,615.00 349.98 3,666.93 2,948.07 55.4 190-045-000-74400 Emergency Management 1,000.00 1,000.00 0.00 1,000.00 0.00 100.0 190-045-000-74600 Meetings 0.00 0.00 0.00 22.00 (22.00) # 190-045-000-75000 Insurance 19,975.00 19,975.00 0.00 8,714.00 11,261.00 43.6 190-045-000-77300 Fire Inspections/Enforcement 1,000.00 1,000.00 0.00 205.12 794.88 20.5 page 1 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 190-045-000-78200 Small Tools 8,127.00 8,127.00 615.42 5,179.95 2,947.05 63.7 190-045-000-79200 Building Rental/Lease 308,000.00 308,000.00 0.00 308,000.00 0.00 100.0 190-045-000-79999 Miscellaneous Expense 1,213.00 1,213.00 34.71 240.47 972.53 19.8 190-045-000-80250 Maintenance and Repairs 5,562.00 5,562.00 264.06 3,557.84 2,004.16 64.0 190-045-000-81200 Building Maintenance 11,000.00 11,000.00 1,100.99 8,066.62 2,933.38 73.3 190-045-000-81300 Vehicle Maintenance 13,500.00 13,500.00 4,405.36 12,864.04 635.96 95.3 190-045-000-81350 Equipment Maintenance 3,675.00 3,675.00 100.39 622.10 3,052.90 16.9 190-045-000-81400 Radio Maintenance 1,050.00 1,050.00 0.00 465.00 585.00 44.3 190-045-000-81800 Flags & Repairs 2,422.00 2,422.00 0.00 1,972.50 449.50 81.4 190-045-000-81900 Maintenance Supplies 2,652.00 2,652.00 494.78 1,420.38 1,231.62 53.6 190-045-000-85000 Grant Match 3,000.00 3,000.00 0.00 1,308.60 1,691.40 43.6 190-045-000-87100 Programs & Special Projects 4,080.00 4,080.00 804.99 2,877.84 1,202.16 70.5 190-045-000-90100 Radios 2,500.00 2,500.00 199.87 1,007.37 1,492.63 40.3 190-045-000-90200 Fire Engine 681 Payment 73,388.00 73,388.00 68,193.95 73,887.90 (499.90) 100.7 190-045-000-93200 Vehicles 4,183.00 4,183.00 0.00 4,164.55 18.45 99.6 190-045-000-93600 Airpacks 2,245.00 2,245.00 2,245.00 2,245.00 0.00 100.0 Total Fire Department 1,208,184.00 1,208,184.00 136,950.95 1,050,885.50 157,298.50 page 2 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance190-000-000-30100Property TaxesBalance Forward-1,071,346.56CR08/01/2011MUD 1 AV Taxes18688414.8108/02/2011MUD 1 AV Taxes19807102.5208/03/2011MUD 1 AV Taxes18690101.6908/04/2011MUD 1 AV Taxes1869259.9008/05/2011MUD 1 AV Taxes18695489.5208/30/2011MUD 1 AV Taxes19953218.87Total0.00 1,387.31 -1,072,733.87 CR190-000-000-30125Property Taxes/DelinquentBalance Forward-8,750.49CR08/10/2011Advalorem Taxes1979926.2108/30/2011Advalorem Taxes19951191.06Total0.00217.27 -8,967.76 CR190-000-000-30150Property Taxes/Penalty & InterestBalance Forward-4,917.48CR08/02/2011Advalorem Taxes198072.2708/04/2011Advalorem Taxes1869218.5308/05/2011Advalorem Taxes1869592.9908/05/2011AV Taxes 8/5/11 correction203880.0208/10/2011Advalorem Taxes1979927.2208/30/2011Advalorem Taxes19951150.9408/30/2011Advalorem Taxes1995341.5908/31/2011August Bank Rec adjustment203685.2608/31/2011August Bank Rec adjustment203845.2608/31/2011August Bank Rec Adjustment203865.26Total5.26344.08 -5,256.30 CR190-000-000-32014Fire Permits/SprinklerBalance Forward-1,600.00CR08/18/2011Permits 8/18/1118990400.0008/29/2011 Permits 8/29/11 19825400.00Total0.00 800.00 -2,400.00 CR190-000-000-33050Fire InspectionsBalance Forward-225.00CR08/18/2011Permits 8/18/111899075.0008/29/2011Permits 8/29/111982575.00Total0.00150.00-375.00 CR190-000-000-33420Denton/Tarrant County - FireBalance Forward-10,000.00CRTotal0.00 0.00 -10,000.00 CR190-000-000-35050Interest IncomeBalance Forward-75.00CRTotal0.00 0.00 -75.00 CR190-000-000-35370DonationsBalance Forward0.00Total0.00 0.00 0.00190-000-000-36700Miscellaneous RevenueBalance Forward-1,775.00CR08/18/2011Permits 8/18/1118990525.0008/29/2011 Permits 8/29/11 19825525.00Total0.00 1,050.00 -2,825.00 CR190-000-000-39200Transfer In - General FundBalance Forward0.00Total0.00 0.00 0.00190-045-000-40100Salaries - RegularBalance Forward312,161.1108/05/2011 Payroll 08/05/11 1863815,766.1808/19/2011 Payroll 08/19/11 1904615,362.05Total31,128.23 0.00 343,289.34Trophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011190-045-000-40130Salaries - OvertimeBalanceForward42,155.8508/05/2011 Payroll 08/05/11 186385,143.7808/19/2011 Payroll 08/19/11 19046494.70Total5,638.48 0.00 47,794.33190-045-000-40140Salaries - LongevityBalance Forward2,986.99Total0.00 0.00 2,986.99190-045-000-40160Salaries - CertificationBalance Forward6,582.94Total0.00 0.00 6,582.94190-045-000-40180Salaries - Holiday PayBalance Forward12,154.86Total0.00 0.00 12,154.86190-045-000-41200RetirementBalance Forward51,262.9708/05/2011 Payroll 08/05/11 186382,693.4108/19/2011 Payroll 08/19/11 190462,061.09Total4,754.50 0.00 56,017.47190-045-000-41210Medical InsuranceBalance Forward44,358.5508/05/2011 Payroll 08/05/11 186381,949.7008/19/2011 Payroll 08/19/11 190461,969.98Total3,919.68 0.00 48,278.23190-045-000-41215Dental InsuranceBalance Forward2,446.6308/05/2011 Payroll 08/05/11 18638121.3808/19/2011 Payroll 08/19/11 19046122.90Total244.28 0.00 2,690.91190-045-000-41216Vision InsuranceBalance Forward393.6108/05/2011 Payroll 08/05/11 1863818.7808/19/2011 Payroll 08/19/11 1904619.00Total37.78 0.00 431.39190-045-000-41218Life Insurance & OtherBalance Forward886.38Total0.00 0.00 886.38190-045-000-42220Social Security TaxesBalance Forward21,734.3608/05/2011 Payroll 08/05/11 186381,197.7108/19/2011 Payroll 08/19/11 19046883.43Total2,081.14 0.00 23,815.50190-045-000-42225Medicare TaxesBalance Forward5,086.0908/05/2011 Payroll 08/05/11 18638280.0708/19/2011 Payroll 08/19/11 19046206.65Total486.72 0.00 5,572.81190-045-000-42250Unemployment TaxesBalance Forward934.4908/05/2011 Payroll 08/05/11 1863813.8008/19/2011 Payroll 08/19/11 190466.49Total20.29 0.00 954.78190-045-000-42260Workman's CompensationBalance Forward12,465.28Total0.00 0.00 12,465.28190-045-000-42290Pre-employment Physicals/TestingBalance Forward195.50 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011Total0.00 0.00 195.50190-045-000-50100Professional Outside ServicesBalance Forward0.00Total0.00 0.00 0.00190-045-000-54100Physicals/TestingBalance Forward0.00Total0.00 0.00 0.00190-045-000-60100Office SuppliesBalance Forward215.63Total0.00 0.00 215.63190-045-000-60300PostageBalance Forward92.2608/01/2011 July Postage meter usage 2028259.8408/04/2011 Janet Grunt 18522 JP Morgan Chase Bank NA 07202011 21.3308/31/2011 August Postage Meter usage 2028424.6408/31/2011 Janet Grunt 20610 JP Morgan Chase Bank NA 08312011 31.01Total136.82 0.00 229.08190-045-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00190-045-000-61000FuelBalance Forward8,595.6208/01/2011 Gas Log/July 190121,110.5408/04/2011 Donnie Hurd 18522 JP Morgan Chase Bank NA 07202011 41.0008/31/2011 August Gas log 202761,088.94Total2,240.48 0.00 10,836.10190-045-000-62100UniformsBalance Forward3,530.3208/04/2011 Danny Thomas 18522 JP Morgan Chase Bank NA 07202011 466.2008/04/2011 Donnie Hurd 18522 JP Morgan Chase Bank NA 07202011 241.5008/16/2011 Gary Sipes 18704 JP Morgan Chase Bank NA 08162011 38.75Total746.45 0.00 4,276.77190-045-000-62150Protective ClothingBalance Forward756.1808/01/2011 Coats/pants 19149 Casco Industries, Inc 99899A 5,422.00Total5,422.00 0.00 6,178.18190-045-000-62300ChemicalsBalance Forward305.00Total0.00 0.00 305.00190-045-000-72100ElectricityBalance Forward9,176.4708/17/2011 Electricity 7/14-8/12 19169 Hudson Energy 2222189 1,249.30Total1,249.30 0.00 10,425.77190-045-000-72200WaterBalance Forward444.61Total0.00 0.00 444.61190-045-000-73100TelephoneBalance Forward124.2008/31/2011 Steve Z. 20280 Bank of America 082711 5.78Total5.78 0.00 129.98190-045-000-73200Communications /Pagers/MobilesBalance Forward2,211.9308/31/2011 Mike Pastor 20280 Bank of America 082711 29.52Total29.52 0.00 2,241.45190-045-000-73300AdvertisingBalance Forward0.00Total0.00 0.00 0.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011190-045-000-73400PrintingBalanceForward0.00Total0.00 0.00 0.00190-045-000-74100Dues & MembershipBalance Forward6,466.60Total0.00 0.00 6,466.60190-045-000-74200Travel & per diemBalance Forward3,531.41Total0.00 0.00 3,531.41190-045-000-74300Schools & TrainingBalance Forward3,316.9508/04/2011 Danny Thomas 18522 JP Morgan Chase Bank NA 07202011 149.9808/23/2011 Crash Recovery System 19435 North East Fire Dept Assoc 11-027 200.00Total349.98 0.00 3,666.93190-045-000-74400Emergency ManagementBalance Forward1,000.00Total0.00 0.00 1,000.00190-045-000-74600MeetingsBalance Forward22.00Total0.00 0.00 22.00190-045-000-75000InsuranceBalance Forward8,714.00Total0.00 0.00 8,714.00190-045-000-77300Fire Inspections/EnforcementBalance Forward205.12Total0.00 0.00 205.12190-045-000-78200Small ToolsBalance Forward4,564.5308/31/2011 2 Piece flag & 2 Piece pole 20110 Symonds Flags & Poles, Inc 3408 330.0008/31/2011 Donnie Hurd 20610 JP Morgan Chase Bank NA 08312011 241.9508/31/2011 Danny Thomas 20610 JP Morgan Chase Bank NA 08312011 43.47Total615.42 0.00 5,179.95190-045-000-79200Building Rental/LeaseBalance Forward308,000.00Total0.00 0.00 308,000.00190-045-000-79999Miscellaneous ExpenseBalance Forward205.7608/31/2011 Danny Thomas 20610 JP Morgan Chase Bank NA 08312011 34.71Total34.71 0.00 240.47190-045-000-80250Maintenance and RepairsBalance Forward3,293.7808/16/2011 Donnie Hurd 18704 JP Morgan Chase Bank NA 08162011 264.06Total264.06 0.00 3,557.84190-045-000-81200Building MaintenanceBalance Forward6,965.6308/02/2011 Gas/Fire Station 17916 Atmos Energy 005534734 0711 67.9708/04/2011 Donnie Hurd 18522 JP Morgan Chase Bank NA 07202011 91.6008/04/2011 Gary Sipes 18522 JP Morgan Chase Bank NA 07202011 40.8508/04/2011 Shane Beck 18522 JP Morgan Chase Bank NA 07202011 175.0008/15/2011 Pest control/Fire Station 19159 Gann's Pest Control 17536 140.0008/16/2011 Cable/Fire Station 19155 DIRECTV 15820450726 98.9908/31/2011 Fire Station Cable 20108 DIRECTV 15890378426 19.8008/31/2011 Donnie Hurd 20610 JP Morgan Chase Bank NA 08312011 430.6108/31/2011 Danny Thomas 20610 JP Morgan Chase Bank NA 08312011 36.17Total1,100.99 0.00 8,066.62190-045-000-81300Vehicle MaintenanceBalance Forward8,458.68 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/12/2011Vehicle Maint/1995 HME 3-D19177Martin Apparatus, Inc30054534,263.2908/16/2011Gary Sipes18704JP Morgan Chase Bank NA081620114.1608/16/2011Donnie Hurd18704JP Morgan Chase Bank NA0816201192.9308/31/2011Danny Thomas20610JP Morgan Chase Bank NA0831201144.98Total4,405.360.00 12,864.04190-045-000-81350Equipment MaintenanceBalance Forward521.7108/12/2011 Switch 19179 Martin Apparatus, Inc 3005454 48.5908/16/2011 Danny Thomas 18704 JP Morgan Chase Bank NA 08162011 51.80Total100.39 0.00 622.10190-045-000-81400Radio MaintenanceBalance Forward465.00Total0.00 0.00 465.00190-045-000-81800Flags & RepairsBalance Forward1,972.50Total0.00 0.00 1,972.50190-045-000-81900Maintenance SuppliesBalance Forward925.6008/26/2011 July purchases 19427 Costco Wholesale 073111 (Town) 202.1208/31/2011 Costco Order 20138 Costco Wholesale 08242011 292.66Total494.78 0.00 1,420.38190-045-000-85000Grant MatchBalance Forward1,308.60Total0.00 0.00 1,308.60190-045-000-87100Programs & Special ProjectsBalance Forward2,072.8508/04/2011 April Reiling 18522 JP Morgan Chase Bank NA 07202011 400.0008/04/2011 Danny Thomas 18522 JP Morgan Chase Bank NA 07202011 268.0008/16/2011 Shane Beck 18704 JP Morgan Chase Bank NA 08162011 86.9908/31/2011 Music for Fire Department Grand Opening. 20132 Scott A. Smith 168-42-6177 50.00Total804.99 0.00 2,877.84190-045-000-90100RadiosBalance Forward807.5008/04/2011 Donnie Hurd 18522 JP Morgan Chase Bank NA 07202011 240.0708/16/2011 Donnie Hurd 18704 JP Morgan Chase Bank NA 08162011 40.20Total240.07 40.20 1,007.37190-045-000-90200Fire Engine 681 PaymentBalance Forward5,693.9508/19/2011 Bond paying agent fees/Fire truck 19691500.0008/25/2011 CO 2007/Fire Truck 1969767,693.95Total68,193.95 0.00 73,887.90190-045-000-93200VehiclesBalance Forward4,164.55Total0.00 0.00 4,164.55190-045-000-93600AirpacksBalance Forward0.0008/11/2011 Loan Payment - Airpacks 18564 Texas Forest Service 99-0125 2,245.00Total2,245.00 0.00 2,245.00GRAND TOTAL136,996.41 3,988.86 -51,747.43 Municipal Utility District No 1 Fire Station Construction 2010 General Obligation $2M Bond Fund Interim Balance Sheet 11/12 Months (92% of Fiscal Year) Balance @ 8/31/2011 ASSETS ASSETS INVESTMENTS -$ OTHER RECEIVABLES - TOTAL ASSETS -$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE 121,450$ TOTAL LIABILITIES 121,450 FUND BALANCE DESIGNATED FOR FIRE STATION CONSTRUCTION (121,450) TOTAL LIABILITIES AND FUND BALANCE -$ * General Fund will transfer to cover expenditures over bond money received. August 31, 2011 Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 08/31/2011 From Account: 491 To Account: Run Date: 09/16/2011 User: rgonzales Segments/Accounts Total Budget MTD Rev. YTD Rev. Total Variance Total % [FUND] 491 : Bond Fund 2010 GO 2M Fire 491-000-000-35050 : Interest Income 1,295.00 0.00 1,053.58 241.42 18.64% 491-000-000-39200 : Transfer In - General Fund 0.00 272,718.65 272,718.65 -272,718.65 0.00% [FUND] SubTotal : 491 : Bond Fund 2010 GO 2M Fire 1,295.00 272,718.65 273,772.23 -272,477.23 -21,040.71% Grand Total : 1,295.00 272,718.65 273,772.23 -272,477.23 -21,040.71% PAGE 1 491-045-000-94000 Temporary Housing and Storage 0.00 10,500.00 1,227.30 11,712.82 (1,212.82) 111.6 491-045-000-95000 Construction 0.00 1,405,652.00 43,888.11 1,798,923.20 (393,271.20) 128.0 491-045-000-96300 Engineering 0.00 41,000.00 834.10 40,443.85 556.15 98.6 Total Fire Department 0.00 1,457,152.00 45,949.51 1,851,079.87 (393,927.87) page 1 Budget to Actual - Fire Const Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance491-000-000-35050Interest IncomeBalance Forward-1,053.58CRTotal0.00 0.00 -1,053.58 CR491-000-000-39200Transfer In - General FundBalance Forward0.0008/31/2011 Transfer to Fire Construction/Aug exp 20304272,718.65Total0.00 272,718.65 -272,718.65 CR491-045-000-94000Temporary Housing and StorageBalance Forward10,485.5208/11/2011 Temporary Storage 18538 Williams Scotsman, Inc 95813574 91.0608/11/2011 Temporary Housing 18546 Modular Space Corporation 105891297 845.1008/31/2011 20X8 Container WWTP 20120 Williams Scotsman, Inc 95871438 91.0608/31/2011 Steve Z. 20280 Bank of America 082711 200.08Total1,227.30 0.00 11,712.82491-045-000-95000ConstructionBalance Forward1,755,035.0908/01/2011 Security system/fire station 19193 3rd Eye Surveillance Systems 242 4,500.0008/01/2011 Balance due custom beds for fire station 18570 Tom L. Gierling, Jr. 2127 2,400.0008/04/2011 Change orders for fire station 19211 Cingl Telecom., LLC 13356 674.9008/05/2011 Furniture for fire station 18572 National Business Furniture, LLC CV754465-NAT 3,047.4808/05/2011 Cables to go/fire station 19187 SHI Governmental Solutions GB00040100 195.8208/09/2011 Custom ADA signs, Installation of EMS si 19431 The Router Room 1351 107.7608/10/2011 Punch down cabling at fire station 19181 Mercury Communication Services, Inc 263379 624.6008/11/2011 New Fire Station fiber cable 18548 Ram Comm, Inc. 07132011 8,299.3808/17/2011 Electricity 7/15-8/15 19189 Star-Tex Power 6004748 1,476.8808/19/2011 Vacuum for new Fire Station 19191 Tamara Thomas 082511 369.9908/22/2011 Tempered glass/fire station 19195 Roanoke Glass and Mirror 356035 507.0008/22/2011 Literature rack 19433 National Business Furniture, LLC CV756843-DUR 253.9008/31/2011 Steve Z. 20280 Bank of America 082711 861.9308/31/2011 Steve Z. 20280 Bank of America 082711 235.9808/31/2011 Construction Equipment for FD 20102 Comm-Fit LP 16438 10,326.3908/31/2011 2 Door 48x36 Metal Corkboard Acrylic Doo 20114 National Business Furniture, LLC CV756843-GHE 398.0008/31/2011 Furniture Install 20116 National Business Furniture, LLC CV755349-ZAM 15.0008/31/2011 Supply and install antennas, brackets an 20118 American Communications 57521 3,500.0008/31/2011 Mike Pastor 20280 Bank of America 082711 3,046.5508/31/2011 Mike Pastor 20280 Bank of America 082711 3,046.55Total43,888.11 0.00 1,798,923.20491-045-000-96100LegalBalance Forward0.00Total0.00 0.00 0.00491-045-000-96300EngineeringBalance Forward39,609.7508/11/2011 ENGINEERING 18544 Reed Engineering Group 16940 397.5008/31/2011 BRW Project No: 27069.00 20126 BRW Architects, Inc 211-07113 436.60Total834.10 0.00 40,443.85491-045-000-96500Bond Issuance CostBalance Forward0.00Total0.00 0.00 0.00GRAND TOTAL45,949.51 272,718.65 1,577,307.64Trophy Club Municipal Utility Dist #1Fire Construction8/31/2011 Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 8/31/2011 ASSETS ASSETS CASH AND CASH IN BANK -$ INVESTMENTS 97,739 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 21,910 TOTAL ASSETS 119,649$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 21,910$ TOTAL LIABILITIES 21,910 FUND BALANCE DESIGNATED FOR DEBT SERVICE 97,739 TOTAL LIABILITIES AND FUND BALANCE 119,649$ August 31, 2011 11/12 Months 92% of Fiscal Year) Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 08/31/2011 From Account: 680 To Account: Run Date: 09/16/2011 User: rgonzales Segments/Accounts Total Budget MTD Rev. YTD Rev. Total Variance Total % [FUND] 680 : Debt Service 680-000-000-30100 : Property Taxes 755,712.00 977.26 758,491.57 -2,779.57 -0.37% 680-000-000-30125 : Property Taxes/Delinquent 0.00 424.53 4,820.04 -4,820.04 0.00% 680-000-000-30150 : Property Taxes/Penalty & Interest 9,500.00 442.72 4,235.81 5,264.19 55.41% 680-000-000-35050 : Interest Income 500.00 82.12 977.91 -477.91 -95.58% 680-000-000-35170 : Building Rent 308,000.00 0.00 308,000.00 0.00 0.00% 680-000-000-38500 : PID Utility Fees 246,100.00 0.00 246,100.00 0.00 0.00% [FUND] SubTotal : 680 : Debt Service 1,319,812.00 1,926.63 1,322,625.33 -2,813.33 -0.21% Grand Total : 1,319,812.00 1,926.63 1,322,625.33 -2,813.33 -0.21% PAGE 1 680-680-000-89000 Bond Principal 1,115,000.00 1,115,000.00 1,115,000.00 1,115,000.00 0.00 100.0 680-680-000-89100 Bond Interest 379,559.00 379,559.00 172,960.00 379,558.55 0.45 100.0 680-680-000-89200 Paying Agent Fees 3,500.00 3,500.00 1,550.00 2,460.00 1,040.00 70.3 Total Debt Service 1,498,059.00 1,498,059.00 1,289,510.00 1,497,018.55 1,040.45 page 1 Budget to Actual -Debt Service Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance680-000-000-30100Property TaxesBalance Forward-757,514.31CR08/01/2011MUD 1 AV Taxes18688292.2208/02/2011MUD 1 AV Taxes1980772.2208/03/2011MUD 1 AV Taxes1869071.6208/04/2011MUD 1 AV Taxes1869242.1908/05/2011MUD 1 AV Taxes18695344.8308/30/2011MUD 1 AV Taxes19953154.18Total0.00977.26 -758,491.57 CR680-000-000-30125Property Taxes/DelinquentBalance Forward-4,395.51CR08/10/2011Advalorem Taxes1979938.7508/30/2011Advalorem Taxes19951385.78Total0.00424.53 -4,820.04 CR680-000-000-30150Property Taxes/Penalty & InterestBalance Forward-3,793.09CR08/02/2011Advalorem Taxes198070.0108/04/2011Advalorem Taxes1869213.0508/05/2011Advalorem Taxes1869565.5208/10/2011Advalorem Taxes1979930.0908/30/2011Advalorem Taxes19951304.7608/30/2011Advalorem Taxes1995329.29Total0.00442.72 -4,235.81 CR680-000-000-35050Interest IncomeBalance Forward-895.79CR08/31/2011August Bank Interest2025682.12Total0.0082.12-977.91 CR680-000-000-35170Building RentBalance Forward-308,000.00CRTotal0.00 0.00 -308,000.00 CR680-000-000-36900Recovery of Prior Year ExpenseBalance Forward0.00Total0.00 0.00 0.00680-000-000-37100Prior Year ReservesBalance Forward0.00Total0.00 0.00 0.00680-000-000-38500PID Utility FeesBalance Forward-246,100.00CRTotal0.00 0.00 -246,100.00 CR680-000-000-39200Transfer In - General FundBalance Forward0.00Total0.00 0.00 0.00680-680-000-89000Bond PrincipalBalance Forward0.0008/25/2011 Bond payments/MUD1 97W 19697380,000.0008/25/2011 Bond payments/MUD2 Series 05 19697285,000.0008/25/2011 Bond payments/MUD1 Series 03 19697245,000.0008/25/2011 Bond payments/MUD2 2002 19697150,000.0008/25/2011 Bond payments/MUD2 2003 1969755,000.00Total1,115,000.00 0.00 1,115,000.00680-680-000-89100Bond InterestBalance Forward206,598.5508/25/2011 Bond payments/MUD1 97W 196979,310.0008/25/2011 Bond payments/Fire Station 1969740,366.2508/25/2011 Bond payments/MUD2 Series 05 1969739,330.0008/25/2011 Bond payments/MUD1 Series 03 196973,981.2508/25/2011 Bond payments/MUD2 2002 1969762,333.7508/25/2011 Bond payments/MUD2 2003 1969717,638.75Total172,960.00 0.00 379,558.55Trophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011680-680-000-89200Paying Agent FeesBalance Forward910.0008/19/2011 Bond paying agent fees/Series 2003 196911,000.0008/19/2011 Bond paying agent fees/Series 2002 19691550.00Total1,550.00 0.00 2,460.00GRAND TOTAL1,289,510.00 1,926.63 174,393.22