Loading...
HomeMy WebLinkAboutSept 2011 Financial Summary Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 9/30/2011 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 569,580 INVESTMENTS 1,988,719 RESTRICTED ASSETS: INVESTMENTS 406,501 PREPAID EXPENSES 7,755 ADVALOREM PROPERTY TAXES RECEIVABLE 1,856 UTILITY AND OTHER ACCOUNTS RECEIVABLE 739,347 TOTAL ASSETS 3,714,158$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,856$ ACCOUNTS PAYABLE 669,628 CUSTOMER DEPOSITS 187,087 TOTAL LIABILITIES 858,571 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT 219,414 UNDESIGNATED FUND BALANCE 2,636,174 TOTAL FUND BALANCE 2,855,587 TOTAL LIABILITIES AND FUND BALANCE 3,714,158$ September 30, 2011 12/12 Months (100% of Fiscal Year) Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 09/30/2011 From Account: 180-000-000-30100 To Account: 180-000-000-39290 Run Date: 10/13/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 915.89 87,582.87 -1,268.87 -1.47% 180-000-000-30125 : Property Taxes/Delinquent 0.00 42.86 888.00 -888.00 0.00% 180-000-000-30150 : Property Taxes/Penalty & Interest 0.00 211.43 1,694.46 -1,694.46 0.00% 180-000-000-35050 : Interest Income 2,000.00 359.72 5,459.34 -3,459.34 -172.97% 180-000-000-35150 : Cell Tower Lease Revenue 10,164.00 847.00 10,164.00 0.00 0.00% 180-000-000-35170 : Building Rent 7,000.00 583.33 6,999.96 0.04 0.00% 180-000-000-36100 : Gas Well Revenues 2,000.00 57.08 911.49 1,088.51 54.43% 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 254.45 9,615.55 4,884.45 33.69% 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 253,774.28 2,021,860.74 -312,049.74 -18.25% 180-000-000-38120 : Water - Commercial 777,075.00 117,353.66 860,151.48 -83,076.48 -10.69% 180-000-000-38130 : Water - PID 195,249.00 134,473.31 427,338.43 -232,089.43 -118.87% 180-000-000-38140 : Portable Meters - Out of District 16,000.00 12,038.32 57,848.99 -41,848.99 -261.56% 180-000-000-38200 : Sewer - Residential 1,098,146.00 114,662.34 1,144,665.30 -46,519.30 -4.24% 180-000-000-38220 : Sewer - Commercial 300,403.00 31,833.93 294,124.05 6,278.95 2.09% 180-000-000-38230 : Sewer - PID 74,364.00 41,441.91 189,663.14 -115,299.14 -155.05% 180-000-000-38240 : Sewer - Out of District 10,000.00 2,088.63 17,970.88 -7,970.88 -79.71% 180-000-000-38250 : TCCC Effluent Charges 47,500.00 14,907.69 74,430.98 -26,930.98 -56.70% 180-000-000-38300 : Standby 0.00 66.00 733.60 -733.60 0.00% 180-000-000-38320 : Penalties 50,000.00 6,212.70 47,399.14 2,600.86 5.20% 180-000-000-38340 : Service Charges 17,500.00 1,653.00 15,342.42 2,157.58 12.33% 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 50.00 1,950.00 -1,950.00 0.00% 180-000-000-38420 : Sewer Inspections 3,000.00 150.00 5,850.00 -2,850.00 -95.00% 180-000-000-38500 : PID Utility Fees 167,900.00 57,500.00 165,600.00 2,300.00 1.37% 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 7,592.00 70,594.29 -20,594.29 -41.19% 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 799,069.53 5,522,786.23 -775,196.23 -16.33% Grand Total : 4,747,590.00 799,069.53 5,522,786.23 -775,196.23 -16.33% PAGE 2 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-010-000-40100 Salaries - Regular 165,718.00 165,718.00 18,439.53 140,927.86 24,790.14 85.0 180-010-000-40130 Salaries - Overtime 8,814.00 8,814.00 3,192.40 18,465.29 (9,651.29) 209.5 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,730.00 (230.00) 115.3 180-010-000-41200 Retirement 24,945.00 24,945.00 3,084.31 23,152.84 1,792.16 92.8 180-010-000-41210 Medical Insurance 27,748.00 27,748.00 2,144.12 23,889.76 3,858.24 86.1 180-010-000-41215 Dental Insurance 1,446.00 1,446.00 127.46 1,319.84 126.16 91.3 180-010-000-41216 Vision Insurance 269.00 269.00 22.38 235.76 33.24 87.6 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 1,295.45 9,629.86 1,364.14 87.6 180-010-000-42225 Medicare Taxes 2,571.00 2,571.00 302.96 2,252.14 318.86 87.6 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 77.68 303.72 46.28 86.8 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 360.00 4,004.00 (154.00) 104.0 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 252,534.95 1,413,693.12 (3,693.12) 100.3 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 1,197.72 12,291.46 2,924.54 80.8 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 1,789.83 5,316.73 883.27 85.8 180-010-000-72100 Electricity/Gas 175,000.00 175,000.00 23,883.86 165,809.99 9,190.01 94.7 180-010-000-73200 Communications /Pagers/Mobiles 1,599.00 1,599.00 322.67 1,837.80 (238.80) 114.9 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 172.00 233.00 (83.00) 155.3 180-010-000-74200 Travel & per diem 3,200.00 3,200.00 554.46 1,780.24 1,419.76 55.6 180-010-000-74300 Schools & Training 2,800.00 2,800.00 154.50 2,087.50 712.50 74.6 180-010-000-74700 Safety Program 500.00 500.00 77.76 84.93 415.07 17.0 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 0.00 86,563.89 (1,563.89) 101.8 180-010-000-78200 Small Tools 2,500.00 2,500.00 0.00 3,969.48 (1,469.48) 158.8 180-010-000-78300 Safety Equipment 2,500.00 2,500.00 0.00 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 180-010-000-79400 Bad Debt Expense 4,200.00 4,200.00 0.00 2,172.73 2,027.27 51.7 page 1 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 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 19,688.01 30,974.14 (1,474.14) 105.0 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 504.00 1,800.85 2,399.15 42.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 1,571.79 4,572.65 (1,192.65) 135.3 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 1,568.84 13,991.37 18,008.63 43.7 180-010-000-91000 Capital Lease 11,490.00 11,490.00 0.00 10,627.13 862.87 92.5 180-010-000-93700 Capital Expenses 130,932.00 286,911.00 0.00 329,620.76 (42,709.76) 114.9 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-99100 Transfer to General Fund 0.00 0.00 0.00 0.00 0.00 # 180-010-000-99500 Transfer to Future Replacement Reserve 30,000.00 30,000.00 0.00 30,000.00 0.00 100.0 Total Water 2,367,044.00 2,523,023.00 333,216.68 2,460,351.81 62,671.19 page 2 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/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 20,404.80 173,519.75 3,271.25 98.1 180-020-000-40130 Salaries - Overtime 10,166.00 10,166.00 1,963.15 14,666.35 (4,500.35) 144.3 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,375.00 175.00 93.1 180-020-000-41200 Retirement 27,019.00 27,019.00 3,195.62 27,431.91 (412.91) 101.5 180-020-000-41210 Medical Insurance 37,298.00 37,298.00 2,785.32 36,209.41 1,088.59 97.1 180-020-000-41215 Dental Insurance 1,983.00 1,983.00 154.98 1,844.31 138.69 93.0 180-020-000-41216 Vision Insurance 341.00 341.00 29.76 357.12 (16.12) 104.7 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 1,256.18 10,486.05 17.95 99.8 180-020-000-42225 Medicare Taxes 2,457.00 2,457.00 293.78 2,452.38 4.62 99.8 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 3,841.00 15,969.25 2,780.75 85.2 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 0.00 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 488.70 3,637.26 3,237.74 52.9 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 900.00 5,077.39 7,922.61 39.1 180-020-000-62800 Lab Supplies 6,085.00 6,085.00 96.50 4,217.05 1,867.95 69.3 180-020-000-62900 Other Consumables 110.00 110.00 0.00 50.14 59.86 45.6 180-020-000-72100 Electricity/Gas 205,000.00 205,000.00 16,543.56 199,125.06 5,874.94 97.1 180-020-000-72200 Water 1,900.00 1,900.00 61.74 1,350.58 549.42 71.1 180-020-000-72400 Dumpster Services 35,000.00 35,000.00 2,607.43 16,677.43 18,322.57 47.6 180-020-000-73100 Telephone 0.00 10.00 0.00 10.20 (0.20) 102.0 180-020-000-73200 Communications /Pagers/Mobiles 3,000.00 3,000.00 475.16 3,323.72 (323.72) 110.8 180-020-000-74200 Travel & per diem 1,750.00 1,750.00 325.23 2,415.83 (665.83) 138.0 180-020-000-74300 Schools & Training 1,320.00 1,320.00 210.00 1,110.00 210.00 84.1 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 0.00 646.15 613.85 51.3 180-020-000-78300 Safety Equipment 540.00 540.00 0.00 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 275.00 275.00 240.00 53.4 180-020-000-80250 Maintenance and Repairs 17,750.00 17,750.00 2,745.14 14,579.87 3,170.13 82.1 180-020-000-81100 Property Maintenance 0.00 0.00 0.00 0.00 0.00 # page 3 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 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 24.99 1,441.09 3,556.91 28.8 180-020-000-81360 Maintenance - Backhoe/Skid Loader 2,950.00 2,950.00 1,837.43 2,964.19 (14.19) 100.5 180-020-000-81500 Lawn Maintenance 525.00 525.00 60.98 156.88 368.12 29.9 180-020-000-81900 Maintenance Supplies 5,860.00 5,860.00 488.15 1,424.98 4,435.02 24.3 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 61,264.60 698,106.32 101,289.68 page 4 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/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 15,778.08 134,033.76 2,307.24 98.3 180-021-000-40130 Salaries - Overtime 14,145.00 14,145.00 2,601.36 19,179.27 (5,034.27) 135.6 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,500.00 (300.00) 125.0 180-021-000-41200 Retirement 21,674.00 21,674.00 2,620.22 22,296.80 (622.80) 102.9 180-021-000-41210 Medical Insurance 28,228.00 28,228.00 1,978.38 25,152.60 3,075.40 89.1 180-021-000-41215 Dental Insurance 1,426.00 1,426.00 118.88 1,367.45 58.55 95.9 180-021-000-41216 Vision Insurance 253.00 253.00 19.86 230.28 22.72 91.0 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 1,064.14 9,022.84 (253.84) 102.9 180-021-000-42225 Medicare Taxes 2,051.00 2,051.00 248.87 2,112.69 (61.69) 103.0 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 813.78 11,198.28 501.72 95.7 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 0.00 2,846.00 9,654.00 22.8 180-021-000-72100 Electricity/Gas 23,625.00 23,625.00 1,657.94 18,579.58 5,045.42 78.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.00 22.26 (22.26) # 180-021-000-73200 Communications /Pagers/Mobiles 2,796.00 2,796.00 386.38 2,719.29 76.71 97.3 180-021-000-74100 Dues & Membership 255.00 255.00 0.00 172.00 83.00 67.5 180-021-000-74200 Travel & per diem 1,500.00 1,500.00 77.70 743.04 756.96 49.5 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 945.06 6,786.43 1,356.57 83.3 180-021-000-81900 Maintenance Supplies 16,050.00 16,050.00 149.42 2,278.96 13,771.04 14.2 180-021-000-93700 Capital Expenses 15,000.00 15,000.00 0.00 10,979.25 4,020.75 73.2 180-021-000-97000 Capital Repairs 20,000.00 20,000.00 11,461.00 11,461.00 8,539.00 57.3 page 5 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 Total Collection 416,658.00 416,658.00 40,046.07 296,355.40 120,302.60 page 6 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/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,300.00 7,700.00 2,300.00 77.0 180-130-000-42220 Social Security Taxes 620.00 620.00 80.60 477.40 142.60 77.0 180-130-000-42225 Medicare Taxes 145.00 145.00 18.85 111.65 33.35 77.0 180-130-000-42250 Unemployment Taxes 210.00 210.00 10.40 85.00 125.00 40.5 180-130-000-42260 Workman's Compensation 120.00 120.00 0.00 113.88 6.12 94.9 180-130-000-50100 Professional Outside Services 0.00 0.00 0.00 0.00 0.00 # 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-73300 Advertising 0.00 0.00 0.00 0.00 0.00 # 180-130-000-73400 Printing 0.00 0.00 0.00 0.00 0.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 22.00 348.00 930.00 27.2 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,431.85 14,356.05 10,171.95 page 7 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/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 19,762.40 203,361.80 11,012.20 94.9 180-140-000-40130 Salaries - Overtime 500.00 500.00 14.63 307.52 192.48 61.5 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 2,785.80 28,491.37 1,868.63 93.8 180-140-000-41210 Medical Insurance 17,925.00 17,925.00 1,389.86 18,451.64 (526.64) 102.9 180-140-000-41215 Dental Insurance 930.00 930.00 77.11 950.82 (20.82) 102.2 180-140-000-41216 Vision Insurance 179.00 179.00 14.77 177.60 1.40 99.2 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 1,175.78 12,669.82 804.18 94.0 180-140-000-42225 Medicare Taxes 3,151.00 3,151.00 274.99 2,986.81 164.19 94.8 180-140-000-42250 Unemployment Taxes 630.00 630.00 15.68 483.22 146.78 76.7 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 0.00 82.17 (82.17) # 180-140-000-42960 Employee Relations 1,000.00 1,000.00 29.99 938.66 61.34 93.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 980.48 2,933.13 (433.13) 117.3 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 37.50 444.37 395.63 52.9 180-140-000-60100 Office Supplies 2,450.00 2,450.00 30.11 1,536.11 913.89 62.7 180-140-000-60300 Postage 1,571.00 1,571.00 98.44 2,269.75 (698.75) 144.5 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 0.00 215.15 (15.15) 107.6 180-140-000-73200 Communications /Pagers/Mobiles 1,798.00 1,798.00 233.30 2,616.25 (818.25) 145.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 348.90 2,518.40 (906.40) 156.2 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 0.00 2,260.84 294.16 88.5 180-140-000-74600 Meetings 312.00 312.00 53.74 237.57 74.43 76.1 180-140-000-76700 July 4 Celebration 10,000.00 10,000.00 0.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 0.00 10.06 89.94 10.1 Total Managers Office 547,908.00 547,908.00 27,323.48 534,727.76 13,180.24 page 8 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/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 8,174.40 68,545.96 2,293.04 96.8 180-611-000-40130 Salaries - Overtime 3,500.00 3,500.00 1,633.86 14,347.46 (10,847.46) 409.9 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 1,388.85 12,061.24 (1,414.24) 113.3 180-611-000-41210 Medical Insurance 8,583.00 8,583.00 715.24 9,047.47 (464.47) 105.4 180-611-000-41215 Dental Insurance 393.00 393.00 43.06 495.84 (102.84) 126.2 180-611-000-41216 Vision Insurance 75.00 75.00 4.98 59.76 15.24 79.7 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 547.65 4,673.02 23.98 99.5 180-611-000-42225 Medicare Taxes 1,099.00 1,099.00 128.08 1,092.89 6.11 99.4 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-42290 Pre-employment Physicals/Testing 0.00 0.00 0.00 0.00 0.00 # 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 36.42 532.07 67.93 88.7 180-611-000-60300 Postage 500.00 500.00 31.24 394.71 105.29 78.9 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 0.00 16.19 83.81 16.2 180-611-000-73200 Communications /Pagers/Mobiles 670.00 670.00 103.02 664.00 6.00 99.1 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 0.00 117.00 296.00 28.3 180-611-000-74200 Travel & per diem 1,547.00 1,547.00 5.77 157.95 1,389.05 10.2 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 22.00 47.00 41.00 53.4 180-611-000-78500 Furniture/Equipment<$5,000 0.00 0.00 0.00 0.00 0.00 # 180-611-000-79999 Miscellaneous Expense 0.00 0.00 0.00 0.00 0.00 # Total Finance 113,706.00 113,706.00 12,834.57 117,452.32 (3,746.32) page 9 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/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 11,477.45 91,546.27 20,990.73 81.3 180-620-000-40130 Salaries - Overtime 1,500.00 1,500.00 312.18 1,341.52 158.48 89.4 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,669.45 12,704.77 3,294.23 79.4 180-620-000-41210 Medical Insurance 21,773.00 21,773.00 1,614.45 18,002.68 3,770.32 82.7 180-620-000-41215 Dental Insurance 1,136.00 1,136.00 104.89 1,112.47 23.53 97.9 180-620-000-41216 Vision Insurance 209.00 209.00 18.52 196.43 12.57 94.0 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 666.15 5,448.21 1,580.79 77.5 180-620-000-42225 Medicare Taxes 1,644.00 1,644.00 155.78 1,274.17 369.83 77.5 180-620-000-42250 Unemployment Taxes 540.00 540.00 14.88 425.35 114.65 78.8 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 0.00 30.23 (30.23) # 180-620-000-56200 Utility Billing Contract 11,000.00 11,000.00 1,964.17 10,805.05 194.95 98.2 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 112.74 617.17 82.83 88.2 180-620-000-60300 Postage 18,000.00 18,000.00 2,765.39 15,924.14 2,075.86 88.5 180-620-000-73100 Telephone 100.00 100.00 0.00 105.78 (5.78) 105.8 180-620-000-73200 Communications /Pagers/Mobiles 472.00 472.00 70.73 481.09 (9.09) 101.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,513.25 23,024.60 (5,024.60) 127.9 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 61.61 116.68 488.32 19.3 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 180-620-000-99100 Transfer to General Fund 0.00 0.00 0.00 0.00 0.00 # Total Utility Billing 237,571.00 237,571.00 23,521.64 205,660.45 31,910.55 page 10 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/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 13.90 640.62 1,147.38 35.8 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-73200 Communications /Pagers/Mobiles 0.00 0.00 0.00 0.00 0.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 # 180-630-000-99100 Transfer to General Fund 0.00 0.00 0.00 0.00 0.00 # Total Human Resources 6,945.00 6,945.00 13.90 867.68 6,077.32 page 11 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/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 89.00 276.75 1,073.25 20.5 180-640-000-55000 Software & Support 50,453.00 50,453.00 3,481.49 53,706.43 (3,253.43) 106.4 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 31.52 301.55 69.45 81.3 180-640-000-60200 Printer Supplies 5,732.00 5,732.00 51.99 6,804.95 (1,072.95) 118.7 180-640-000-73100 Telephone 8,040.00 8,040.00 1,674.71 11,270.04 (3,230.04) 140.2 180-640-000-73200 Communications /Pagers/Mobiles 0.00 0.00 0.00 0.00 0.00 # 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,366.45 40,111.54 20,040.46 66.7 180-640-000-79100 Copier Rental/Lease 3,450.00 3,450.00 273.29 3,006.19 443.81 87.1 180-640-000-99100 Transfer to General Fund 0.00 0.00 0.00 0.00 0.00 # 180-640-000-99500 Transfer to Future Replacement Reserve 26,911.00 26,911.00 0.00 26,911.00 0.00 100.0 Total Information Services 157,923.00 157,923.00 6,968.45 144,767.91 13,155.09 page 12 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/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 223.82 653.10 346.90 65.3 180-710-000-72100 Electricity/Gas 20,895.00 20,895.00 1,288.18 13,679.47 7,215.53 65.5 180-710-000-72200 Water 1,061.00 1,061.00 358.95 919.36 141.64 86.7 180-710-000-75000 Insurance 31,081.00 31,081.00 0.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 13,182.12 (0.12) 100.0 180-710-000-81200 Building Maintenance 11,970.00 11,970.00 49.94 13,496.38 (1,526.38) 112.8 180-710-000-81600 Cleaning Services 9,450.00 9,450.00 826.53 8,368.16 1,081.84 88.6 180-710-000-81900 Maintenance Supplies 2,100.00 2,100.00 210.55 1,891.29 208.71 90.1 180-710-000-93300 Equipment 0.00 0.00 0.00 0.00 0.00 # Total Facilities Maintenance 90,739.00 90,739.00 4,056.48 76,934.44 13,804.56 page 13 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/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 1,543.00 41,370.61 (6,370.61) 118.2 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 309,158.99 581,877.64 (581,877.64) # Total Non Departmental 86,314.00 86,314.00 310,701.99 665,714.49 (579,400.49) Total Expenses 4,848,732.00 5,004,711.00 821,379.71 5,215,294.63 (210,583.63) page 14 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance 180-010-000-40100 Salaries - Regular Balance Forward 122,488.33 09/02/2011 Payroll 09/2/11 20782 6,143.86 09/16/2011 Payroll 09/16/11 22279 6,136.81 09/30/2011 Payroll 09/30/11 22281 6,158.86 Total 18,439.53 0.00 140,927.86 180-010-000-40130 Salaries - Overtime Balance Forward 15,272.89 09/02/2011 Payroll 09/2/11 20782 550.40 09/16/2011 Payroll 09/16/11 22279 636.46 09/30/2011 Payroll 09/30/11 22281 2,005.54 Total 3,192.40 0.00 18,465.29 180-010-000-40140 Salaries - Longevity Balance Forward 2,150.00 Total 0.00 0.00 2,150.00 180-010-000-40160 Salaries - Certification Balance Forward 1,580.00 09/16/2011 Payroll 09/16/11 22279 150.00 Total 150.00 0.00 1,730.00 180-010-000-41200 Retirement Balance Forward 20,068.53 09/02/2011 Payroll 09/2/11 20782 947.91 09/16/2011 Payroll 09/16/11 22279 980.33 09/30/2011 Payroll 09/30/11 22281 1,156.07 Total 3,084.31 0.00 23,152.84 180-010-000-41210 Medical Insurance Balance Forward 21,745.64 09/02/2011 Payroll 09/2/11 20782 1,072.06 09/16/2011 Payroll 09/16/11 22279 1,072.06 Total 2,144.12 0.00 23,889.76 180-010-000-41215 Dental Insurance Balance Forward 1,192.38 09/02/2011 Payroll 09/2/11 20782 63.73 09/16/2011 Payroll 09/16/11 22279 63.73 Total 127.46 0.00 1,319.84 180-010-000-41216 Vision Insurance Balance Forward 213.38 09/02/2011 Payroll 09/2/11 20782 11.19 09/16/2011 Payroll 09/16/11 22279 11.19 Total 22.38 0.00 235.76 180-010-000-41218 Life Insurance & Other Balance Forward 313.00 Total 0.00 0.00 313.00 180-010-000-42220 Social Security Taxes Balance Forward 8,334.41 09/02/2011 Payroll 09/2/11 20782 387.53 09/16/2011 Payroll 09/16/11 22279 401.74 09/30/2011 Payroll 09/30/11 22281 506.18 Total 1,295.45 0.00 9,629.86 Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-010-000-42225 Medicare Taxes Balance Forward 1,949.18 09/02/2011 Payroll 09/2/11 20782 90.62 09/16/2011 Payroll 09/16/11 22279 93.96 09/30/2011 Payroll 09/30/11 22281 118.38 Total 302.96 0.00 2,252.14 180-010-000-42250 Unemployment Taxes Balance Forward 329.40 Total 0.00 0.00 329.40 180-010-000-42260 Workman's Compensation Balance Forward 7,368.69 Total 0.00 0.00 7,368.69 180-010-000-42290 Pre-employment Physicals/Testing Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-42960 Employee Relations Balance Forward 226.04 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 10.26 09/01/2011 Robert Scott 20148 JP Morgan Chase Bank NA 08062011 67.42 Total 77.68 0.00 303.72 180-010-000-50500 Engineering Balance Forward 80.15 Total 0.00 0.00 80.15 180-010-000-52400 Lab Analysis Balance Forward 3,644.00 09/01/2011 Lab analysis/August 20890 Tarrant County Public Health Lab 21146 180.00 09/30/2011 Water analysis 21869 Tarrant County Public Health Lab 21240 180.00 Total 360.00 0.00 4,004.00 180-010-000-57000 Independent Labor Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-58000 Bulk Water Balance Forward 1,161,158.17 09/01/2011 August Bulk Water 21278 City of Fort Worth 083111 252,534.95 Total 252,534.95 0.00 1,413,693.12 180-010-000-60300 Postage Balance Forward 13.35 Total 0.00 0.00 13.35 180-010-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-61000 Fuel Balance Forward 11,093.74 09/30/2011 September gas log 22145 1,197.72 Total 1,197.72 0.00 12,291.46 180-010-000-62100 Uniforms Balance Forward 1,882.87 Total 0.00 0.00 1,882.87 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-010-000-62300 Chemicals Balance Forward 3,526.90 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 436.69 09/30/2011 Womack 22259 JP Morgan Chase Bank NA 100511 1,040.88 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 312.26 Total 1,789.83 0.00 5,316.73 180-010-000-72100 Electricity/Gas Balance Forward 141,926.13 09/09/2011 Electricity 8/2-9/1 20854 Tri County Electric 2309888001 0911 27.73 09/14/2011 Electricity 8/15-9/14 21851 Hudson Energy 2319809 625.19 09/16/2011 Electricity 8/15-9/14 21853 Hudson Energy 17005 23,230.94 Total 23,883.86 0.00 165,809.99 180-010-000-73200 Communications /Pagers/Mobiles Balance Forward 1,515.13 09/21/2011 Cells 20864 Verizon Wireless 090611 161.29 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 161.38 Total 322.67 0.00 1,837.80 180-010-000-73350 Copies Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-73400 Printing Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-74100 Dues & Membership Balance Forward 61.00 09/14/2011 CDL License/Holt 20514 Lance Holt 090911 61.00 09/30/2011 Slaght 22259 JP Morgan Chase Bank NA 100511 111.00 Total 172.00 0.00 233.00 180-010-000-74200 Travel & per diem Balance Forward 1,225.78 09/02/2011 Payroll 09/2/11 20782 380.73 09/16/2011 Payroll 09/16/11 22279 48.85 09/30/2011 Payroll 09/30/11 22281 124.88 Total 554.46 0.00 1,780.24 180-010-000-74300 Schools & Training Balance Forward 1,933.00 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 404.50 09/21/2011 TEEX/L Holt Refund 22111 250.00 Total 404.50 250.00 2,087.50 180-010-000-74700 Safety Program Balance Forward 7.17 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 77.76 Total 77.76 0.00 84.93 180-010-000-75200 Annual Permit Fee Balance Forward 6,133.95 Total 0.00 0.00 6,133.95 180-010-000-78100 Meter Expense Balance Forward 86,563.89 Total 0.00 0.00 86,563.89 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-010-000-78200 Small Tools Balance Forward 3,969.48 Total 0.00 0.00 3,969.48 180-010-000-78300 Safety Equipment Balance Forward 229.92 Total 0.00 0.00 229.92 180-010-000-78500 Furniture/Equipment<$5,000 Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-78600 Hardware Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-79150 Equipment Rental/Lease Balance Forward 770.00 Total 0.00 0.00 770.00 180-010-000-79400 Bad Debt Expense Balance Forward 2,172.73 Total 0.00 0.00 2,172.73 180-010-000-79999 Miscellaneous Expense Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-80250 Maintenance and Repairs Balance Forward 11,286.13 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 144.94 09/21/2011 VFD Purchase and installation 21843 DHS Automation,Inc 06-890 19,500.00 09/30/2011 McMahon 22259 JP Morgan Chase Bank NA 100511 4.97 09/30/2011 McMahon 22255 JP Morgan Chase Bank NA 092611 38.10 Total 19,688.01 0.00 30,974.14 180-010-000-80300 Non-routine Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-81100 Property Maintenance Balance Forward 1,296.85 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 216.00 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 36.00 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 108.00 09/30/2011 Womack 22259 JP Morgan Chase Bank NA 100511 108.00 09/30/2011 Womack 22259 JP Morgan Chase Bank NA 100511 36.00 Total 504.00 0.00 1,800.85 180-010-000-81200 Building Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-81300 Vehicle Maintenance Balance Forward 3,000.86 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 968.34 09/16/2011 Petty cash reimbursement 20840 Trophy Club MUD Petty Cash 091611 53.64 09/30/2011 LAMP BULB 21877 Roanoke Auto Supply, LTD 685267 4.08 09/30/2011 Womack 22259 JP Morgan Chase Bank NA 100511 39.75 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 137.00 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 368.98 Total 1,571.79 0.00 4,572.65 180-010-000-81360 Maintenance - Backhoe/Skid Loader Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-81500 Lawn Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-81900 Maintenance Supplies Balance Forward 12,422.53 09/01/2011 August Charges 20856 Costco Wholesale 082611 42.72 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 767.88 09/06/2011 Superior Water Signs 21387 Dallas Lite & Barricade 211700 62.32 09/26/2011 September purchases 21841 Costco Wholesale 092611 45.87 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 456.80 09/30/2011 McMahon 22259 JP Morgan Chase Bank NA 100511 193.25 Total 1,568.84 0.00 13,991.37 180-010-000-91000 Capital Lease Balance Forward 10,627.13 Total 0.00 0.00 10,627.13 180-010-000-93700 Capital Expenses Balance Forward 329,620.76 Total 0.00 0.00 329,620.76 180-010-000-97000 Capital Repairs Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-97100 Capital Repairs - Ground Storage Balance Forward 97,741.64 Total 0.00 0.00 97,741.64 180-010-000-99100 Transfer to General Fund Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-99500 Transfer to Future Replacement Reserve Balance Forward 30,000.00 Total 0.00 0.00 30,000.00 180-020-000-40100 Salaries - Regular Balance Forward 153,114.95 09/02/2011 Payroll 09/2/11 20782 6,801.60 09/16/2011 Payroll 09/16/11 22279 6,801.60 09/30/2011 Payroll 09/30/11 22281 6,801.60 Total 20,404.80 0.00 173,519.75 180-020-000-40130 Salaries - Overtime Balance Forward 12,703.20 09/02/2011 Payroll 09/2/11 20782 731.32 09/16/2011 Payroll 09/16/11 22279 470.03 09/30/2011 Payroll 09/30/11 22281 761.80 Total 1,963.15 0.00 14,666.35 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-020-000-40140 Salaries - Longevity Balance Forward 3,482.50 Total 0.00 0.00 3,482.50 180-020-000-40160 Salaries - Certification Balance Forward 2,175.00 09/16/2011 Payroll 09/16/11 22279 200.00 Total 200.00 0.00 2,375.00 180-020-000-41200 Retirement Balance Forward 24,236.29 09/02/2011 Payroll 09/2/11 20782 1,066.66 09/16/2011 Payroll 09/16/11 22279 1,057.98 09/30/2011 Payroll 09/30/11 22281 1,070.98 Total 3,195.62 0.00 27,431.91 180-020-000-41210 Medical Insurance Balance Forward 33,424.09 09/02/2011 Payroll 09/2/11 20782 1,392.66 09/16/2011 Payroll 09/16/11 22279 1,392.66 Total 2,785.32 0.00 36,209.41 180-020-000-41215 Dental Insurance Balance Forward 1,689.33 09/02/2011 Payroll 09/2/11 20782 77.49 09/16/2011 Payroll 09/16/11 22279 77.49 Total 154.98 0.00 1,844.31 180-020-000-41216 Vision Insurance Balance Forward 327.36 09/02/2011 Payroll 09/2/11 20782 14.88 09/16/2011 Payroll 09/16/11 22279 14.88 Total 29.76 0.00 357.12 180-020-000-41218 Life Insurance & Other Balance Forward 444.77 Total 0.00 0.00 444.77 180-020-000-42220 Social Security Taxes Balance Forward 9,229.87 09/02/2011 Payroll 09/2/11 20782 395.52 09/16/2011 Payroll 09/16/11 22279 391.73 09/30/2011 Payroll 09/30/11 22281 468.93 Total 1,256.18 0.00 10,486.05 180-020-000-42225 Medicare Taxes Balance Forward 2,158.60 09/02/2011 Payroll 09/2/11 20782 92.49 09/16/2011 Payroll 09/16/11 22279 91.62 09/30/2011 Payroll 09/30/11 22281 109.67 Total 293.78 0.00 2,452.38 180-020-000-42250 Unemployment Taxes Balance Forward 434.45 Total 0.00 0.00 434.45 180-020-000-42260 Workman's Compensation Balance Forward 7,981.82 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Total 0.00 0.00 7,981.82 180-020-000-42960 Employee Relations Balance Forward 151.88 Total 0.00 0.00 151.88 180-020-000-50500 Engineering Balance Forward 2,800.00 Total 0.00 0.00 2,800.00 180-020-000-52400 Lab Analysis Balance Forward 12,128.25 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 2,046.50 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 1,794.50 Total 3,841.00 0.00 15,969.25 180-020-000-57000 Independent Labor Balance Forward 0.00 Total 0.00 0.00 0.00 180-020-000-60100 Office Supplies Balance Forward 65.50 Total 0.00 0.00 65.50 180-020-000-60300 Postage Balance Forward 0.00 Total 0.00 0.00 0.00 180-020-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 Total 0.00 0.00 0.00 180-020-000-61000 Fuel Balance Forward 3,148.56 09/30/2011 September gas log 22145 488.70 Total 488.70 0.00 3,637.26 180-020-000-62100 Uniforms Balance Forward 1,449.17 Total 0.00 0.00 1,449.17 180-020-000-62300 Chemicals Balance Forward 4,177.39 09/01/2011 Rodney Greenwood 20148 JP Morgan Chase Bank NA 08062011 900.00 Total 900.00 0.00 5,077.39 180-020-000-62800 Lab Supplies Balance Forward 4,120.55 09/30/2011 Greenwood 22255 JP Morgan Chase Bank NA 092611 42.62 09/30/2011 Greenwood 22259 JP Morgan Chase Bank NA 100511 53.88 Total 96.50 0.00 4,217.05 180-020-000-62900 Other Consumables Balance Forward 50.14 Total 0.00 0.00 50.14 180-020-000-72100 Electricity/Gas Balance Forward 182,581.50 09/19/2011 Electricity 8/15-9/14 21855 Hudson Energy 17017 16,543.56 Total 16,543.56 0.00 199,125.06 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-020-000-72200 Water Balance Forward 1,288.84 09/21/2011 August water 20904 Trophy Club MUD - Water Bills 083111 61.74 Total 61.74 0.00 1,350.58 180-020-000-72400 Dumpster Services Balance Forward 14,070.00 09/01/2011 Renae Gonzales 20148 JP Morgan Chase Bank NA 08062011 63.25 09/01/2011 Dumpster service for new barscreen 20838 Star Waste Equipment Sales, LLC 5689 1,305.00 09/10/2011 WW Dumpster service 21280 L.H. Chaney Materials, Inc 37267 537.50 09/24/2011 Bludge haul off 21879 L.H. Chaney Materials, Inc 38349 537.50 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 164.18 Total 2,607.43 0.00 16,677.43 180-020-000-73100 Telephone Balance Forward 10.20 Total 0.00 0.00 10.20 180-020-000-73200 Communications /Pagers/Mobiles Balance Forward 2,848.56 09/21/2011 Cells 20864 Verizon Wireless 090611 236.83 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 238.33 Total 475.16 0.00 3,323.72 180-020-000-74200 Travel & per diem Balance Forward 2,090.60 09/02/2011 Payroll 09/2/11 20782 104.34 09/16/2011 Payroll 09/16/11 22279 93.24 09/30/2011 Payroll 09/30/11 22281 127.65 Total 325.23 0.00 2,415.83 180-020-000-74300 Schools & Training Balance Forward 900.00 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 210.00 Total 210.00 0.00 1,110.00 180-020-000-74700 Safety Program Balance Forward 7.18 Total 0.00 0.00 7.18 180-020-000-75200 Annual Permit Fee Balance Forward 10,704.14 Total 0.00 0.00 10,704.14 180-020-000-78200 Small Tools Balance Forward 646.15 Total 0.00 0.00 646.15 180-020-000-78300 Safety Equipment Balance Forward 704.36 Total 0.00 0.00 704.36 180-020-000-78600 Hardware Balance Forward 35.81 Total 0.00 0.00 35.81 180-020-000-79150 Equipment Rental/Lease Balance Forward 0.00 Total 0.00 0.00 0.00 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-020-000-79999 Miscellaneous Expense Balance Forward 0.00 09/06/2011 Annual Lab equipment inspection 20836 Instrumentation Engineers 8741 275.00 Total 275.00 0.00 275.00 180-020-000-80250 Maintenance and Repairs Balance Forward 11,834.73 09/01/2011 Jeff Richey 20148 JP Morgan Chase Bank NA 08062011 6.65 09/01/2011 Rodney Greenwood 20148 JP Morgan Chase Bank NA 08062011 783.91 09/01/2011 Repaired #2 New RAS Pump 20866 C & P Pump Services, Inc 22743 1,793.00 09/30/2011 Greenwood 22259 JP Morgan Chase Bank NA 100511 174.88 Total 2,751.79 6.65 14,579.87 180-020-000-81100 Property Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-020-000-81200 Building Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-020-000-81300 Vehicle Maintenance Balance Forward 1,416.10 09/30/2011 Greenwood 22255 JP Morgan Chase Bank NA 092611 24.99 Total 24.99 0.00 1,441.09 180-020-000-81360 Maintenance - Backhoe/Skid Loader Balance Forward 1,126.76 09/30/2011 Backhoe repair 21857 Landmark Equipment - Ft Worth WF10838-01 1,837.43 Total 1,837.43 0.00 2,964.19 180-020-000-81500 Lawn Maintenance Balance Forward 95.90 09/01/2011 Rodney Greenwood 20148 JP Morgan Chase Bank NA 08062011 60.98 Total 60.98 0.00 156.88 180-020-000-81900 Maintenance Supplies Balance Forward 936.83 09/26/2011 September purchases 21841 Costco Wholesale 092611 165.59 09/30/2011 Greenwood 22259 JP Morgan Chase Bank NA 100511 39.97 09/30/2011 Greenwood 22259 JP Morgan Chase Bank NA 100511 282.59 Total 488.15 0.00 1,424.98 180-020-000-93700 Capital Expenses Balance Forward 124,550.39 Total 0.00 0.00 124,550.39 180-020-000-97000 Capital Repairs Balance Forward 1,500.00 Total 0.00 0.00 1,500.00 180-021-000-40100 Salaries - Regular Balance Forward 118,255.68 09/02/2011 Payroll 09/2/11 20782 5,259.36 09/16/2011 Payroll 09/16/11 22279 5,259.36 09/30/2011 Payroll 09/30/11 22281 5,259.36 Total 15,778.08 0.00 134,033.76 180-021-000-40130 Salaries - Overtime Balance Forward 16,577.91 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/02/2011 Payroll 09/2/11 20782 487.23 09/16/2011 Payroll 09/16/11 22279 677.62 09/30/2011 Payroll 09/30/11 22281 1,436.51 Total 2,601.36 0.00 19,179.27 180-021-000-40140 Salaries - Longevity Balance Forward 3,160.00 Total 0.00 0.00 3,160.00 180-021-000-40160 Salaries - Certification Balance Forward 1,375.00 09/16/2011 Payroll 09/16/11 22279 125.00 Total 125.00 0.00 1,500.00 180-021-000-41200 Retirement Balance Forward 19,676.58 09/02/2011 Payroll 09/2/11 20782 813.71 09/16/2011 Payroll 09/16/11 22279 858.38 09/30/2011 Payroll 09/30/11 22281 948.13 Total 2,620.22 0.00 22,296.80 180-021-000-41210 Medical Insurance Balance Forward 23,174.22 09/02/2011 Payroll 09/2/11 20782 989.19 09/16/2011 Payroll 09/16/11 22279 989.19 Total 1,978.38 0.00 25,152.60 180-021-000-41215 Dental Insurance Balance Forward 1,248.57 09/02/2011 Payroll 09/2/11 20782 59.44 09/16/2011 Payroll 09/16/11 22279 59.44 Total 118.88 0.00 1,367.45 180-021-000-41216 Vision Insurance Balance Forward 210.42 09/02/2011 Payroll 09/2/11 20782 9.93 09/16/2011 Payroll 09/16/11 22279 9.93 Total 19.86 0.00 230.28 180-021-000-41218 Life Insurance & Other Balance Forward 339.73 Total 0.00 0.00 339.73 180-021-000-42220 Social Security Taxes Balance Forward 7,958.70 09/02/2011 Payroll 09/2/11 20782 314.71 09/16/2011 Payroll 09/16/11 22279 334.28 09/30/2011 Payroll 09/30/11 22281 415.15 Total 1,064.14 0.00 9,022.84 180-021-000-42225 Medicare Taxes Balance Forward 1,863.82 09/02/2011 Payroll 09/2/11 20782 73.60 09/16/2011 Payroll 09/16/11 22279 78.19 09/30/2011 Payroll 09/30/11 22281 97.08 Total 248.87 0.00 2,112.69 180-021-000-42250 Unemployment Taxes Balance Forward 333.23 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Total 0.00 0.00 333.23 180-021-000-42260 Workman's Compensation Balance Forward 4,187.36 Total 0.00 0.00 4,187.36 180-021-000-42960 Employee Relations Balance Forward 191.59 Total 0.00 0.00 191.59 180-021-000-50500 Engineering Balance Forward 80.14 Total 0.00 0.00 80.14 180-021-000-57000 Independent Labor Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-60300 Postage Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-61000 Fuel Balance Forward 10,384.50 09/30/2011 September gas log 22145 813.78 Total 813.78 0.00 11,198.28 180-021-000-62100 Uniforms Balance Forward 860.75 Total 0.00 0.00 860.75 180-021-000-62300 Chemicals Balance Forward 2,846.00 Total 0.00 0.00 2,846.00 180-021-000-72100 Electricity/Gas Balance Forward 16,921.64 09/02/2011 Electricity 8/2-9/2 20850 Tri County Electric 2009888001 323.22 09/09/2011 Electricity 8/2-9/1 20852 Tri County Electric 2209888001 0911 172.50 09/15/2011 Electricity 8/13-9/14 21288 Hudson Energy 16986 710.54 09/19/2011 Electricity 8/15-9/14 21855 Hudson Energy 17017 451.68 Total 1,657.94 0.00 18,579.58 180-021-000-72200 Water Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-73100 Telephone Balance Forward 22.26 Total 0.00 0.00 22.26 180-021-000-73200 Communications /Pagers/Mobiles Balance Forward 2,332.91 09/21/2011 Cells 20864 Verizon Wireless 090611 181.65 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 204.73 Total 386.38 0.00 2,719.29 180-021-000-74100 Dues & Membership Balance Forward 172.00 Total 0.00 0.00 172.00 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-021-000-74200 Travel & per diem Balance Forward 665.34 09/02/2011 Payroll 09/2/11 20782 6.66 09/16/2011 Payroll 09/16/11 22279 67.71 09/30/2011 Payroll 09/30/11 22281 3.33 Total 77.70 0.00 743.04 180-021-000-74300 Schools & Training Balance Forward 55.00 Total 0.00 0.00 55.00 180-021-000-74700 Safety Program Balance Forward 7.18 Total 0.00 0.00 7.18 180-021-000-78200 Small Tools Balance Forward 220.58 Total 0.00 0.00 220.58 180-021-000-78300 Safety Equipment Balance Forward 62.84 Total 0.00 0.00 62.84 180-021-000-78600 Hardware Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-79150 Equipment Rental/Lease Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-79999 Miscellaneous Expense Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-80250 Maintenance and Repairs Balance Forward 4,175.22 Total 0.00 0.00 4,175.22 180-021-000-81100 Property Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-81200 Building Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-81300 Vehicle Maintenance Balance Forward 5,841.37 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 945.06 Total 945.06 0.00 6,786.43 180-021-000-81900 Maintenance Supplies Balance Forward 2,129.54 09/01/2011 August Charges 20856 Costco Wholesale 082611 85.74 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 63.68 Total 149.42 0.00 2,278.96 180-021-000-93700 Capital Expenses Balance Forward 10,979.25 Total 0.00 0.00 10,979.25 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-021-000-97000 Capital Repairs Balance Forward 0.00 09/13/2011 pump repair 21292 ITT Water & Wastewater USA 07653040 11,461.00 Total 11,461.00 0.00 11,461.00 180-130-000-40100 Salaries - Regular Balance Forward 6,400.00 09/02/2011 Payroll 09/2/11 20782 500.00 09/16/2011 Payroll 09/16/11 22279 200.00 09/30/2011 Payroll 09/30/11 22281 600.00 Total 1,300.00 0.00 7,700.00 180-130-000-42220 Social Security Taxes Balance Forward 396.80 09/02/2011 Payroll 09/2/11 20782 31.00 09/16/2011 Payroll 09/16/11 22279 12.40 09/30/2011 Payroll 09/30/11 22281 37.20 Total 80.60 0.00 477.40 180-130-000-42225 Medicare Taxes Balance Forward 92.80 09/02/2011 Payroll 09/2/11 20782 7.25 09/16/2011 Payroll 09/16/11 22279 2.90 09/30/2011 Payroll 09/30/11 22281 8.70 Total 18.85 0.00 111.65 180-130-000-42250 Unemployment Taxes Balance Forward 74.60 09/02/2011 Payroll 09/2/11 20782 4.00 09/16/2011 Payroll 09/16/11 22279 1.60 09/30/2011 Payroll 09/30/11 22281 4.80 Total 10.40 0.00 85.00 180-130-000-42260 Workman's Compensation Balance Forward 113.88 Total 0.00 0.00 113.88 180-130-000-50100 Professional Outside Services Balance Forward 0.00 Total 0.00 0.00 0.00 180-130-000-60100 Office Supplies Balance Forward 0.00 Total 0.00 0.00 0.00 180-130-000-60300 Postage Balance Forward -1.86 CR Total 0.00 0.00 -1.86 CR 180-130-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 Total 0.00 0.00 0.00 180-130-000-73300 Advertising Balance Forward 0.00 Total 0.00 0.00 0.00 180-130-000-73400 Printing Balance Forward 0.00 Total 0.00 0.00 0.00 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-130-000-74100 Dues & Membership Balance Forward 79.00 Total 0.00 0.00 79.00 180-130-000-74200 Travel & per diem Balance Forward 968.26 Total 0.00 0.00 968.26 180-130-000-74300 Schools & Training Balance Forward 2,140.00 Total 0.00 0.00 2,140.00 180-130-000-74600 Meetings Balance Forward 326.00 09/01/2011 Chamber luncheon 20870 Northwest Metroport Chamber 8111 22.00 Total 22.00 0.00 348.00 180-130-000-79999 Miscellaneous Expense Balance Forward 0.00 Total 0.00 0.00 0.00 180-130-000-87110 Water Conservation Program/Public Information Balance Forward 2,334.72 Total 0.00 0.00 2,334.72 180-140-000-40100 Salaries - Regular Balance Forward 183,599.40 09/02/2011 Payroll 09/2/11 20782 6,618.71 09/16/2011 Payroll 09/16/11 22279 6,674.61 09/30/2011 Payroll 09/30/11 22281 6,469.08 Total 19,762.40 0.00 203,361.80 180-140-000-40130 Salaries - Overtime Balance Forward 292.89 09/02/2011 Payroll 09/2/11 20782 1.58 09/16/2011 Payroll 09/16/11 22279 13.05 Total 14.63 0.00 307.52 180-140-000-40140 Salaries - Longevity Balance Forward 2,755.00 Total 0.00 0.00 2,755.00 180-140-000-41200 Retirement Balance Forward 25,705.57 09/02/2011 Payroll 09/2/11 20782 931.71 09/16/2011 Payroll 09/16/11 22279 938.07 09/30/2011 Payroll 09/30/11 22281 916.02 Total 2,785.80 0.00 28,491.37 180-140-000-41210 Medical Insurance Balance Forward 17,061.78 09/02/2011 Payroll 09/2/11 20782 700.48 09/16/2011 Payroll 09/16/11 22279 689.38 Total 1,389.86 0.00 18,451.64 180-140-000-41215 Dental Insurance Balance Forward 873.71 09/02/2011 Payroll 09/2/11 20782 38.85 09/16/2011 Payroll 09/16/11 22279 38.26 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Total 77.11 0.00 950.82 180-140-000-41216 Vision Insurance Balance Forward 162.83 09/02/2011 Payroll 09/2/11 20782 7.44 09/16/2011 Payroll 09/16/11 22279 7.33 Total 14.77 0.00 177.60 180-140-000-41218 Life Insurance & Other Balance Forward 390.74 Total 0.00 0.00 390.74 180-140-000-42220 Social Security Taxes Balance Forward 11,494.04 09/02/2011 Payroll 09/2/11 20782 385.06 09/16/2011 Payroll 09/16/11 22279 389.65 09/30/2011 Payroll 09/30/11 22281 401.07 Total 1,175.78 0.00 12,669.82 180-140-000-42225 Medicare Taxes Balance Forward 2,711.82 09/02/2011 Payroll 09/2/11 20782 90.06 09/16/2011 Payroll 09/16/11 22279 91.13 09/30/2011 Payroll 09/30/11 22281 93.80 Total 274.99 0.00 2,986.81 180-140-000-42250 Unemployment Taxes Balance Forward 467.54 09/02/2011 Payroll 09/2/11 20782 5.60 09/16/2011 Payroll 09/16/11 22279 5.35 09/30/2011 Payroll 09/30/11 22281 4.73 Total 15.68 0.00 483.22 180-140-000-42260 Workman's Compensation Balance Forward 743.12 Total 0.00 0.00 743.12 180-140-000-42290 Pre-employment Physicals/Testing Balance Forward 82.17 Total 0.00 0.00 82.17 180-140-000-42960 Employee Relations Balance Forward 908.67 09/30/2011 Slaght 22259 JP Morgan Chase Bank NA 100511 29.99 Total 29.99 0.00 938.66 180-140-000-50100 Professional Outside Services Balance Forward 228,075.63 Total 0.00 0.00 228,075.63 180-140-000-52100 Elections Balance Forward 1,952.65 09/22/2011 Joint election 5/14/11 21867 Tarrant County Elections Admin 425-2011 980.48 Total 980.48 0.00 2,933.13 180-140-000-54200 Records Management Balance Forward 120.00 Total 0.00 0.00 120.00 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-140-000-57000 Independent Labor Balance Forward 406.87 09/20/2011 Record MUD meeting 21294 Miguel Cruz 092011 37.50 Total 37.50 0.00 444.37 180-140-000-60100 Office Supplies Balance Forward 1,506.00 09/14/2011 Office Supplies 21296 Office Depot 578996141001 30.11 Total 30.11 0.00 1,536.11 180-140-000-60300 Postage Balance Forward 2,171.31 09/16/2011 Petty cash reimbursement 20840 Trophy Club MUD Petty Cash 091611 1.76 09/27/2011 TCEQ 22249 Federal Express Corp 7-652-61103 29.16 09/29/2011 TCEQ 21849 Federal Express Corp 7-645-23013 29.16 09/30/2011 September Postage Meter usage 22130 41.88 Total 100.20 1.76 2,269.75 180-140-000-60400 Publications/Books/Subscriptions Balance Forward 215.40 Total 0.00 0.00 215.40 180-140-000-73100 Telephone Balance Forward 215.15 Total 0.00 0.00 215.15 180-140-000-73200 Communications /Pagers/Mobiles Balance Forward 2,382.95 09/21/2011 Cells 20864 Verizon Wireless 090611 91.30 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 142.00 Total 233.30 0.00 2,616.25 180-140-000-73300 Advertising Balance Forward 0.00 Total 0.00 0.00 0.00 180-140-000-73400 Printing Balance Forward 3,170.00 Total 0.00 0.00 3,170.00 180-140-000-73600 Service Charges & Fees Balance Forward 32.50 Total 0.00 0.00 32.50 180-140-000-74100 Dues & Membership Balance Forward 2,169.50 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 325.00 09/30/2011 Slaght 22259 JP Morgan Chase Bank NA 100511 23.90 Total 348.90 0.00 2,518.40 180-140-000-74200 Travel & per diem Balance Forward 1,201.01 Total 0.00 0.00 1,201.01 180-140-000-74300 Schools & Training Balance Forward 2,260.84 Total 0.00 0.00 2,260.84 180-140-000-74600 Meetings Balance Forward 183.83 09/26/2011 September purchases 21841 Costco Wholesale 092611 15.48 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 38.26 Total 53.74 0.00 237.57 180-140-000-76700 July 4 Celebration Balance Forward 10,000.00 Total 0.00 0.00 10,000.00 180-140-000-78500 Furniture/Equipment<$5,000 Balance Forward 4,081.30 Total 0.00 0.00 4,081.30 180-140-000-79999 Miscellaneous Expense Balance Forward 10.06 Total 0.00 0.00 10.06 180-611-000-40100 Salaries - Regular Balance Forward 60,371.56 09/02/2011 Payroll 09/2/11 20782 2,724.80 09/16/2011 Payroll 09/16/11 22279 2,724.80 09/30/2011 Payroll 09/30/11 22281 2,724.80 Total 8,174.40 0.00 68,545.96 180-611-000-40130 Salaries - Overtime Balance Forward 12,713.60 09/02/2011 Payroll 09/2/11 20782 356.10 09/16/2011 Payroll 09/16/11 22279 486.89 09/30/2011 Payroll 09/30/11 22281 790.87 Total 1,633.86 0.00 14,347.46 180-611-000-40140 Salaries - Longevity Balance Forward 1,710.00 Total 0.00 0.00 1,710.00 180-611-000-41200 Retirement Balance Forward 10,672.39 09/02/2011 Payroll 09/2/11 20782 436.25 09/16/2011 Payroll 09/16/11 22279 454.78 09/30/2011 Payroll 09/30/11 22281 497.82 Total 1,388.85 0.00 12,061.24 180-611-000-41210 Medical Insurance Balance Forward 8,332.23 09/02/2011 Payroll 09/2/11 20782 357.62 09/16/2011 Payroll 09/16/11 22279 357.62 Total 715.24 0.00 9,047.47 180-611-000-41215 Dental Insurance Balance Forward 452.78 09/02/2011 Payroll 09/2/11 20782 21.53 09/16/2011 Payroll 09/16/11 22279 21.53 Total 43.06 0.00 495.84 180-611-000-41216 Vision Insurance Balance Forward 54.78 09/02/2011 Payroll 09/2/11 20782 2.49 09/16/2011 Payroll 09/16/11 22279 2.49 Total 4.98 0.00 59.76 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-611-000-41218 Life Insurance & Other Balance Forward 146.23 Total 0.00 0.00 146.23 180-611-000-42220 Social Security Taxes Balance Forward 4,125.37 09/02/2011 Payroll 09/2/11 20782 160.79 09/16/2011 Payroll 09/16/11 22279 168.89 09/30/2011 Payroll 09/30/11 22281 217.97 Total 547.65 0.00 4,673.02 180-611-000-42225 Medicare Taxes Balance Forward 964.81 09/02/2011 Payroll 09/2/11 20782 37.60 09/16/2011 Payroll 09/16/11 22279 39.50 09/30/2011 Payroll 09/30/11 22281 50.98 Total 128.08 0.00 1,092.89 180-611-000-42250 Unemployment Taxes Balance Forward 129.59 Total 0.00 0.00 129.59 180-611-000-42260 Workman's Compensation Balance Forward 260.04 Total 0.00 0.00 260.04 180-611-000-42290 Pre-employment Physicals/Testing Balance Forward 0.00 Total 0.00 0.00 0.00 180-611-000-50100 Professional Outside Services Balance Forward 2,437.50 Total 0.00 0.00 2,437.50 180-611-000-60100 Office Supplies Balance Forward 495.65 09/14/2011 Office Supplies 21298 Office Depot 579087534001 13.49 09/16/2011 Office Supplies 21300 Office Depot 579446128001 16.96 09/16/2011 Petty cash reimbursement 20840 Trophy Club MUD Petty Cash 091611 5.97 Total 36.42 0.00 532.07 180-611-000-60300 Postage Balance Forward 363.47 09/30/2011 September Postage Meter usage 22130 31.24 Total 31.24 0.00 394.71 180-611-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 Total 0.00 0.00 0.00 180-611-000-73100 Telephone Balance Forward 16.19 Total 0.00 0.00 16.19 180-611-000-73200 Communications /Pagers/Mobiles Balance Forward 560.98 09/21/2011 Cells 20864 Verizon Wireless 090611 51.51 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 51.51 Total 103.02 0.00 664.00 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-611-000-73300 Advertising Balance Forward 207.40 Total 0.00 0.00 207.40 180-611-000-73400 Printing Balance Forward 0.00 Total 0.00 0.00 0.00 180-611-000-73600 Service Charges & Fees Balance Forward 0.00 Total 0.00 0.00 0.00 180-611-000-74100 Dues & Membership Balance Forward 117.00 Total 0.00 0.00 117.00 180-611-000-74200 Travel & per diem Balance Forward 152.18 09/02/2011 Payroll 09/2/11 20782 5.77 Total 5.77 0.00 157.95 180-611-000-74300 Schools & Training Balance Forward 309.00 Total 0.00 0.00 309.00 180-611-000-74600 Meetings Balance Forward 25.00 09/01/2011 Chamber luncheon 20870 Northwest Metroport Chamber 8111 22.00 Total 22.00 0.00 47.00 180-611-000-78500 Furniture/Equipment<$5,000 Balance Forward 0.00 Total 0.00 0.00 0.00 180-611-000-79999 Miscellaneous Expense Balance Forward 0.00 Total 0.00 0.00 0.00 180-620-000-40100 Salaries - Regular Balance Forward 80,068.82 09/02/2011 Payroll 09/2/11 20782 3,828.55 09/16/2011 Payroll 09/16/11 22279 3,840.66 09/30/2011 Payroll 09/30/11 22281 3,808.24 Total 11,477.45 0.00 91,546.27 180-620-000-40130 Salaries - Overtime Balance Forward 1,029.34 09/02/2011 Payroll 09/2/11 20782 30.03 09/16/2011 Payroll 09/16/11 22279 27.48 09/30/2011 Payroll 09/30/11 22281 254.67 Total 312.18 0.00 1,341.52 180-620-000-40140 Salaries - Longevity Balance Forward 405.00 Total 0.00 0.00 405.00 180-620-000-41200 Retirement Balance Forward 11,035.32 09/02/2011 Payroll 09/2/11 20782 546.38 09/16/2011 Payroll 09/16/11 22279 547.74 09/30/2011 Payroll 09/30/11 22281 575.33 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Total 1,669.45 0.00 12,704.77 180-620-000-41210 Medical Insurance Balance Forward 16,388.23 09/02/2011 Payroll 09/2/11 20782 807.82 09/16/2011 Payroll 09/16/11 22279 806.63 Total 1,614.45 0.00 18,002.68 180-620-000-41215 Dental Insurance Balance Forward 1,007.58 09/02/2011 Payroll 09/2/11 20782 52.47 09/16/2011 Payroll 09/16/11 22279 52.42 Total 104.89 0.00 1,112.47 180-620-000-41216 Vision Insurance Balance Forward 177.91 09/02/2011 Payroll 09/2/11 20782 9.27 09/16/2011 Payroll 09/16/11 22279 9.25 Total 18.52 0.00 196.43 180-620-000-41218 Life Insurance & Other Balance Forward 260.31 Total 0.00 0.00 260.31 180-620-000-42220 Social Security Taxes Balance Forward 4,782.06 09/02/2011 Payroll 09/2/11 20782 206.79 09/16/2011 Payroll 09/16/11 22279 207.47 09/30/2011 Payroll 09/30/11 22281 251.89 Total 666.15 0.00 5,448.21 180-620-000-42225 Medicare Taxes Balance Forward 1,118.39 09/02/2011 Payroll 09/2/11 20782 48.34 09/16/2011 Payroll 09/16/11 22279 48.52 09/30/2011 Payroll 09/30/11 22281 58.92 Total 155.78 0.00 1,274.17 180-620-000-42250 Unemployment Taxes Balance Forward 410.47 09/02/2011 Payroll 09/2/11 20782 5.30 09/16/2011 Payroll 09/16/11 22279 4.83 09/30/2011 Payroll 09/30/11 22281 4.75 Total 14.88 0.00 425.35 180-620-000-42260 Workman's Compensation Balance Forward 390.08 Total 0.00 0.00 390.08 180-620-000-42290 Pre-employment Physicals/Testing Balance Forward 30.23 Total 0.00 0.00 30.23 180-620-000-56200 Utility Billing Contract Balance Forward 8,840.88 09/01/2011 July Utility Billing 20834 CSG Systems, Inc.74560 1,068.15 09/30/2011 September water billing 22251 CSG Systems, Inc.75082 896.02 Total 1,964.17 0.00 10,805.05 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-620-000-57000 Independent Labor Balance Forward 0.00 Total 0.00 0.00 0.00 180-620-000-60100 Office Supplies Balance Forward 504.43 09/14/2011 Office Supplies 21296 Office Depot 578996141001 98.11 09/15/2011 Credit card machine paper/share cost wit 21306 Town of Trophy Club 091511worldpaysu 11.28 09/27/2011 Office Supplies 21861 Office Depot 580740356001 3.35 Total 112.74 0.00 617.17 180-620-000-60300 Postage Balance Forward 13,158.75 09/01/2011 July Utility Billing 20834 CSG Systems, Inc.74560 1,400.25 09/30/2011 September water billing 22251 CSG Systems, Inc.75082 1,365.14 Total 2,765.39 0.00 15,924.14 180-620-000-73100 Telephone Balance Forward 105.78 Total 0.00 0.00 105.78 180-620-000-73200 Communications /Pagers/Mobiles Balance Forward 410.36 09/21/2011 Cells 20864 Verizon Wireless 090611 34.19 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 36.54 Total 70.73 0.00 481.09 180-620-000-73400 Printing Balance Forward 2,152.00 Total 0.00 0.00 2,152.00 180-620-000-73600 Service Charges & Fees Balance Forward 20,511.35 09/07/2011 Credit Card fees/August 20302 9.99 09/07/2011 Credit Card fees/August 20302 1,989.72 09/07/2011 Credit Card fees/August 20302 513.54 Total 2,513.25 0.00 23,024.60 180-620-000-74100 Dues & Membership Balance Forward 0.00 Total 0.00 0.00 0.00 180-620-000-74200 Travel & per diem Balance Forward 55.07 09/02/2011 Payroll 09/2/11 20782 61.61 Total 61.61 0.00 116.68 180-620-000-74300 Schools & Training Balance Forward 46.44 Total 0.00 0.00 46.44 180-620-000-75600 TCEQ Annual Assessment Fee Balance Forward 19,248.17 Total 0.00 0.00 19,248.17 180-620-000-79999 Miscellaneous Expense Balance Forward 1.84 Total 0.00 0.00 1.84 180-620-000-99100 Transfer to General Fund Balance Forward 0.00 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Total 0.00 0.00 0.00 180-630-000-42290 Pre-employment Physicals/Testing Balance Forward 152.41 Total 0.00 0.00 152.41 180-630-000-42960 Employee Relations Balance Forward 626.72 09/30/2011 Huggins 22255 JP Morgan Chase Bank NA 092611 13.90 Total 13.90 0.00 640.62 180-630-000-43240 Tuition Reimbursement Balance Forward 74.65 Total 0.00 0.00 74.65 180-630-000-60100 Office Supplies Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-60300 Postage Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-73100 Telephone Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-73400 Printing Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-74100 Dues & Membership Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-74200 Travel & per diem Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-74300 Schools & Training Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-74600 Meetings Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-99100 Transfer to General Fund Balance Forward 0.00 Total 0.00 0.00 0.00 180-640-000-50700 Security Balance Forward 187.75 09/27/2011 Mike P.22197 Bank of America 092711 89.00 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Total 89.00 0.00 276.75 180-640-000-55000 Software & Support Balance Forward 50,224.94 09/01/2011 Conversion 21328 STW Inc 092211 1,291.20 09/01/2011 Fixed assets/Utility billing 20878 STW Inc 082811 192.97 09/01/2011 Internet access 20842 Bandwidth.com, Inc.IN09152011-20071 326.70 09/12/2011 Kensington Wireless Presenter Pro 20888 SHI Governmental Solutions GB00042723 143.58 09/13/2011 STW support 20880 STW Inc 091311 142.97 09/16/2011 Spam Filtering 21276 The Fulcrum Group, Inc.16087 192.00 09/16/2011 June-Sept Listhosting 20848 Northwest ISD 10063 150.00 09/27/2011 Mike P.22197 Bank of America 092711 25.00 09/27/2011 Steve Z.22197 Bank of America 092711 373.70 09/27/2011 Steve Z.22197 Bank of America 092711 54.99 09/27/2011 Steve Z.22197 Bank of America 092711 53.38 09/27/2011 Mike P.22197 Bank of America 092711 12.50 09/27/2011 Mike P.22197 Bank of America 092711 25.00 09/30/2011 Channel 27 subscription 22221 Videotex Systems, Inc.77924 497.50 Total 3,481.49 0.00 53,706.43 180-640-000-57000 Independent Labor Balance Forward 2,348.75 Total 0.00 0.00 2,348.75 180-640-000-60100 Office Supplies Balance Forward 270.03 09/27/2011 Mike P.22197 Bank of America 092711 31.52 Total 31.52 0.00 301.55 180-640-000-60200 Printer Supplies Balance Forward 6,752.96 09/15/2011 HP printer roller kit 21863 SHI Governmental Solutions GB00042987 35.00 09/27/2011 Steve Z.22197 Bank of America 092711 13.49 09/27/2011 Mike P.22197 Bank of America 092711 3.50 Total 51.99 0.00 6,804.95 180-640-000-73100 Telephone Balance Forward 9,595.33 09/01/2011 analog/phones 20874 Mercury Communication Services, Inc 263563 481.56 09/08/2011 Multi line loud ringer paging amplifier 20876 Mercury Communication Services, Inc 263608 254.93 09/27/2011 Steve Z.22197 Bank of America 092711 451.33 09/27/2011 Steve Z.22197 Bank of America 092711 349.39 09/30/2011 Balance due (Tax exempt)22247 Mercury Communication Services, Inc 263419 137.50 Total 1,674.71 0.00 11,270.04 180-640-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 Total 0.00 0.00 0.00 180-640-000-74200 Travel & per diem Balance Forward 16.18 Total 0.00 0.00 16.18 180-640-000-75900 Prompt Payment Interest Balance Forward 14.53 Total 0.00 0.00 14.53 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-640-000-78600 Hardware Balance Forward 38,745.09 09/01/2011 Lee Delk 20148 JP Morgan Chase Bank NA 08062011 68.98 09/27/2011 Steve Z.22197 Bank of America 092711 114.99 09/27/2011 Steve Z.22197 Bank of America 092711 104.80 09/27/2011 Mike P.22197 Bank of America 092711 45.81 09/27/2011 Mike P.22197 Bank of America 092711 196.22 09/27/2011 Mike P.22197 Bank of America 092711 835.65 Total 1,366.45 0.00 40,111.54 180-640-000-79100 Copier Rental/Lease Balance Forward 2,732.90 09/21/2011 PW Copier lease/Feb 20898 Kyocera Mita America, Inc 110288230 115.62 09/21/2011 PW Fax Lease/Feb 20900 Kyocera Mita America, Inc 110288231 10.91 09/21/2011 Adm Copier Lease/Feb 20902 Kyocera Mita America, Inc 110288220 146.76 Total 273.29 0.00 3,006.19 180-640-000-99100 Transfer to General Fund Balance Forward 0.00 Total 0.00 0.00 0.00 180-640-000-99500 Transfer to Future Replacement Reserve Balance Forward 26,911.00 Total 0.00 0.00 26,911.00 180-710-000-52400 Lab Analysis Balance Forward 1,168.75 Total 0.00 0.00 1,168.75 180-710-000-62520 Vending Machine Supplies Balance Forward 429.28 09/01/2011 August Charges 20856 Costco Wholesale 082611 73.13 09/26/2011 September purchases 21841 Costco Wholesale 092611 47.18 09/26/2011 September purchases 21841 Costco Wholesale 092611 21.48 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 82.03 Total 223.82 0.00 653.10 180-710-000-72100 Electricity/Gas Balance Forward 12,391.29 09/14/2011 Electricity 8/16-9/14 21845 Direct Energy Business Svcs 1167948 1,288.18 Total 1,288.18 0.00 13,679.47 180-710-000-72200 Water Balance Forward 560.41 09/21/2011 August water 20904 Trophy Club MUD - Water Bills 083111 117.64 09/30/2011 September water 21873 Trophy Club MUD - Water Bills 093011 241.31 Total 358.95 0.00 919.36 180-710-000-75000 Insurance Balance Forward 23,575.81 Total 0.00 0.00 23,575.81 180-710-000-79200 Building Rental/Lease Balance Forward 12,083.61 09/01/2011 Public Service bldg rent/September 20884 Town of Trophy Club 090111 1,098.51 Total 1,098.51 0.00 13,182.12 180-710-000-81200 Building Maintenance Balance Forward 13,446.44 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 49.94 Total 49.94 0.00 13,496.38 180-710-000-81600 Cleaning Services Balance Forward 7,541.63 09/01/2011 September janitorial service 20868 ABM Janitorial Services, Inc 2926848 559.50 09/01/2011 Renae Gonzales 20148 JP Morgan Chase Bank NA 08062011 118.68 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 148.35 Total 826.53 0.00 8,368.16 180-710-000-81900 Maintenance Supplies Balance Forward 1,680.74 09/01/2011 Carolyn Huggins 20148 JP Morgan Chase Bank NA 08062011 77.28 09/01/2011 August Charges 20856 Costco Wholesale 082611 23.89 09/26/2011 September purchases 21841 Costco Wholesale 092611 38.48 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 24.12 09/30/2011 Huggins 22255 JP Morgan Chase Bank NA 092611 46.78 Total 210.55 0.00 1,891.29 180-710-000-93300 Equipment Balance Forward 0.00 Total 0.00 0.00 0.00 180-810-000-50200 Auditing Balance Forward 27,500.00 Total 0.00 0.00 27,500.00 180-810-000-50300 Legal Balance Forward 39,827.61 09/01/2011 August Legal 20882 Whitaker, Chalk, Swindle LLP 155855 1,408.00 09/30/2011 September legal 22223 The Liston Law Firm, P.C.093011 135.00 Total 1,543.00 0.00 41,370.61 180-810-000-51100 Appraisal Balance Forward 12,269.68 Total 0.00 0.00 12,269.68 180-810-000-51150 Tax Administration Balance Forward 2,696.56 Total 0.00 0.00 2,696.56 180-810-000-99510 Transfer to Fire Construction Fund Balance Forward 272,718.65 09/30/2011 Transfer to Fire Construction/Sept exp 22121 309,158.99 Total 309,158.99 0.00 581,877.64 GRAND TOTAL 821,638.12 258.41 5,215,294.63 380-020-000-93700 Capital Expenses 0.00 0.00 1,677.98 211,898.58 (211,898.58) # Total Capital Projects 0.00 0.00 1,677.98 211,898.58 (211,898.58) page 1 Budget to Actual - Capital Pro Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance 380-020-000-93700 Capital Expenses Balance Forward 210,220.60 09/14/2011 Longofil bagging system/Bar Screen 21839 Comarco Industrial, Inc.0311052 1,677.98 Total 1,677.98 0.00 211,898.58 GRAND TOTAL 1,677.98 0.00 211,898.58 Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 9/30/2011 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 360,436 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 12,314 ACCOUNTS RECEIVABLE - PID EMERGENCY SERVICES ASSESSMENTS 4,857 OTHER RECEIVABLES 71,143 TOTAL ASSETS 448,750$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 17,171$ ACCOUNTS PAYABLE 125,645 TOTAL LIABILITIES 142,815$ FUND BALANCE UNDESIGNATED FUND BALANCE 305,935 TOTAL LIABILITIES AND FUND BALANCE 448,750$ September 30, 2011 12/12 Months (100% of Fiscal Year) Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 09/30/2011 From Account: 190-000-000-30050 To Account: 190-000-000-39200 Run Date: 10/13/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 7.75 120,134.52 -8,486.52 -7.60% 190-000-000-30060 : Emergency Services Assessment - Penalty & Interest 0.00 1.51 1,730.61 -1,730.61 0.00% 190-000-000-30100 : Property Taxes 1,072,786.00 11,383.40 1,084,117.27 -11,331.27 -1.06% 190-000-000-30125 : Property Taxes/Delinquent 0.00 240.98 9,208.75 -9,208.75 0.00% 190-000-000-30150 : Property Taxes/Penalty & Interest 7,500.00 2,414.14 7,670.44 -170.44 -2.27% 190-000-000-32014 : Fire Permits/Sprinkler 0.00 0.00 2,400.00 -2,400.00 0.00% 190-000-000-33050 : Fire Inspections 0.00 0.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 58,542.55 61,367.55 -58,867.55 -2,354.70% [FUND] SubTotal : 190 : Fire Department Operations 1,208,184.00 72,590.33 1,297,079.14 -88,895.14 -7.36% Grand Total : 1,208,184.00 72,590.33 1,297,079.14 -88,895.14 -7.36% PAGE 1 190-045-000-40100 Salaries - Regular 390,466.00 390,466.00 47,057.00 390,346.34 119.66 100.0 190-045-000-40130 Salaries - Overtime 40,298.00 40,298.00 15,873.83 63,668.16 (23,370.16) 158.0 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 494.70 7,077.64 (1,676.64) 131.0 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 8,532.09 64,549.56 (1,533.56) 102.4 190-045-000-41210 Medical Insurance 54,809.00 54,809.00 3,919.74 52,197.97 2,611.03 95.2 190-045-000-41215 Dental Insurance 2,819.00 2,819.00 244.35 2,935.26 (116.26) 104.1 190-045-000-41216 Vision Insurance 505.00 505.00 37.76 469.15 35.85 92.9 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 3,733.98 27,549.48 (1,297.48) 104.9 190-045-000-42225 Medicare Taxes 6,140.00 6,140.00 873.31 6,446.12 (306.12) 105.0 190-045-000-42250 Unemployment Taxes 1,387.00 1,387.00 27.78 982.56 404.44 70.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 169.94 365.44 309.56 54.1 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 2.36 231.44 (136.44) 243.6 190-045-000-60400 Publications/Books/Subscriptions 382.00 382.00 29.95 29.95 352.05 7.8 190-045-000-61000 Fuel 16,585.00 16,585.00 1,535.79 12,371.89 4,213.11 74.6 190-045-000-62100 Uniforms 4,357.00 4,357.00 65.97 4,342.74 14.26 99.7 190-045-000-62150 Protective Clothing 7,600.00 7,600.00 0.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/Gas 17,400.00 17,400.00 1,408.74 11,834.51 5,565.49 68.0 190-045-000-72200 Water 3,193.00 3,193.00 55.80 500.41 2,692.59 15.7 190-045-000-73100 Telephone 103.00 103.00 0.00 129.98 (26.98) 126.2 190-045-000-73200 Communications /Pagers/Mobiles 1,874.00 1,874.00 431.94 2,673.39 (799.39) 142.7 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 1,595.00 8,061.60 296.40 96.5 190-045-000-74200 Travel & per diem 7,107.00 7,107.00 153.90 3,685.31 3,421.69 51.9 190-045-000-74300 Schools & Training 6,615.00 6,615.00 1,129.00 4,795.93 1,819.07 72.5 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 09/30/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 1,825.54 7,005.49 1,121.51 86.2 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 544.15 784.62 428.38 64.7 190-045-000-80250 Maintenance and Repairs 5,562.00 5,562.00 438.00 3,995.84 1,566.16 71.8 190-045-000-81200 Building Maintenance 11,000.00 11,000.00 2,261.87 10,328.49 671.51 93.9 190-045-000-81300 Vehicle Maintenance 13,500.00 13,500.00 1,102.59 13,966.63 (466.63) 103.5 190-045-000-81350 Equipment Maintenance 3,675.00 3,675.00 634.60 1,256.70 2,418.30 34.2 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 75.00 2,047.50 374.50 84.5 190-045-000-81900 Maintenance Supplies 2,652.00 2,652.00 13.80 1,434.18 1,217.82 54.1 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 1,192.35 4,070.19 9.81 99.8 190-045-000-90100 Radios 2,500.00 2,500.00 0.00 1,007.37 1,492.63 40.3 190-045-000-90200 Fire Engine 681 Payment 73,388.00 73,388.00 0.00 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 0.00 2,245.00 0.00 100.0 Total Fire Department 1,208,184.00 1,208,184.00 95,460.83 1,146,346.33 61,837.67 page 2 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance 190-045-000-40100 Salaries - Regular Balance Forward 343,289.34 09/02/2011 Payroll 09/2/11 20782 15,150.63 09/16/2011 Payroll 09/16/11 22279 15,881.00 09/30/2011 Payroll 09/30/11 22281 16,025.37 Total 47,057.00 0.00 390,346.34 190-045-000-40130 Salaries - Overtime Balance Forward 47,794.33 09/02/2011 Payroll 09/2/11 20782 5,887.94 09/30/2011 Payroll 09/30/11 22281 9,985.89 Total 15,873.83 0.00 63,668.16 190-045-000-40140 Salaries - Longevity Balance Forward 2,986.99 Total 0.00 0.00 2,986.99 190-045-000-40160 Salaries - Certification Balance Forward 6,582.94 09/16/2011 Payroll 09/16/11 22279 494.70 Total 494.70 0.00 7,077.64 190-045-000-40180 Salaries - Holiday Pay Balance Forward 12,154.86 Total 0.00 0.00 12,154.86 190-045-000-41200 Retirement Balance Forward 56,017.47 09/02/2011 Payroll 09/2/11 20782 2,824.78 09/16/2011 Payroll 09/16/11 22279 2,181.69 09/30/2011 Payroll 09/30/11 22281 3,525.62 Total 8,532.09 0.00 64,549.56 190-045-000-41210 Medical Insurance Balance Forward 48,278.23 09/02/2011 Payroll 09/2/11 20782 1,949.76 09/16/2011 Payroll 09/16/11 22279 1,969.98 Total 3,919.74 0.00 52,197.97 190-045-000-41215 Dental Insurance Balance Forward 2,690.91 09/02/2011 Payroll 09/2/11 20782 121.42 09/16/2011 Payroll 09/16/11 22279 122.93 Total 244.35 0.00 2,935.26 190-045-000-41216 Vision Insurance Balance Forward 431.39 09/02/2011 Payroll 09/2/11 20782 18.77 09/16/2011 Payroll 09/16/11 22279 18.99 Total 37.76 0.00 469.15 190-045-000-41218 Life Insurance & Other Balance Forward 886.38 Total 0.00 0.00 886.38 190-045-000-42220 Social Security Taxes Balance Forward 23,815.50 09/02/2011 Payroll 09/2/11 20782 1,205.68 09/16/2011 Payroll 09/16/11 22279 915.63 09/30/2011 Payroll 09/30/11 22281 1,612.67 Total 3,733.98 0.00 27,549.48 Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 190-045-000-42225 Medicare Taxes Balance Forward 5,572.81 09/02/2011 Payroll 09/2/11 20782 281.99 09/16/2011 Payroll 09/16/11 22279 214.16 09/30/2011 Payroll 09/30/11 22281 377.16 Total 873.31 0.00 6,446.12 190-045-000-42250 Unemployment Taxes Balance Forward 954.78 09/02/2011 Payroll 09/2/11 20782 2.93 09/16/2011 Payroll 09/16/11 22279 11.95 09/30/2011 Payroll 09/30/11 22281 12.90 Total 27.78 0.00 982.56 190-045-000-42260 Workman's Compensation Balance Forward 12,465.28 Total 0.00 0.00 12,465.28 190-045-000-42290 Pre-employment Physicals/Testing Balance Forward 195.50 09/01/2011 Pre-emp testing 20832 Mary A. Connell, Ed.D., ABPP 993 117.48 09/01/2011 Pre-employment physicals/testing-Sampson 20858 First Check Applicant Screening 2205 15.90 09/01/2011 Pre-employment physicals/testing-Sampson 20860 CareNow 866755 18.28 09/01/2011 Pre-employment physicals/testing 20862 CareNow 866754 18.28 Total 169.94 0.00 365.44 190-045-000-50100 Professional Outside Services Balance Forward 0.00 Total 0.00 0.00 0.00 190-045-000-54100 Physicals/Testing Balance Forward 0.00 Total 0.00 0.00 0.00 190-045-000-60100 Office Supplies Balance Forward 215.63 Total 0.00 0.00 215.63 190-045-000-60300 Postage Balance Forward 229.08 09/30/2011 September Postage Meter usage 22130 2.36 Total 2.36 0.00 231.44 190-045-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 09/30/2011 D. Thomas 22255 JP Morgan Chase Bank NA 092611 29.95 Total 29.95 0.00 29.95 190-045-000-61000 Fuel Balance Forward 10,836.10 09/22/2011 TIFMAS Wildland Deployment-Fuel for Brus 21284 Dusten Hards 092211 147.00 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 42.29 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 49.75 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 12.67 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 56.88 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 51.56 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 100.00 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 67.00 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 13.48 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 64.00 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 65.00 09/30/2011 September gas log 22145 866.16 Total 1,535.79 0.00 12,371.89 190-045-000-62100 Uniforms Balance Forward 4,276.77 09/24/2011 Cleaners/Fire Dress Uniform cleaning 21282 Donnie Gene Hurd II 092411 24.82 09/28/2011 Dry cleaning Calss A uniforms 21847 Donnie Gene Hurd II 092811 41.15 Total 65.97 0.00 4,342.74 190-045-000-62150 Protective Clothing Balance Forward 6,178.18 Total 0.00 0.00 6,178.18 190-045-000-62300 Chemicals Balance Forward 305.00 Total 0.00 0.00 305.00 190-045-000-72100 Electricity/Gas Balance Forward 10,425.77 09/16/2011 Electricity 8/15-9/14 21865 Star-Tex Power 6175975 326.05 09/19/2011 Electricity 8/12-9/13 21290 Hudson Energy 2331474 1,005.35 09/20/2011 Gas/Fire Station 21837 Atmos Energy 092111 77.34 Total 1,408.74 0.00 11,834.51 190-045-000-72200 Water Balance Forward 444.61 09/21/2011 August water 20904 Trophy Club MUD - Water Bills 083111 25.42 09/21/2011 August water 20904 Trophy Club MUD - Water Bills 083111 30.38 Total 55.80 0.00 500.41 190-045-000-73100 Telephone Balance Forward 129.98 Total 0.00 0.00 129.98 190-045-000-73200 Communications /Pagers/Mobiles Balance Forward 2,241.45 09/21/2011 Cells 20864 Verizon Wireless 090611 208.58 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 192.39 09/27/2011 Mike P.22197 Bank of America 092711 30.97 Total 431.94 0.00 2,673.39 190-045-000-73300 Advertising Balance Forward 0.00 Total 0.00 0.00 0.00 190-045-000-73400 Printing Balance Forward 0.00 Total 0.00 0.00 0.00 190-045-000-74100 Dues & Membership Balance Forward 6,466.60 09/01/2011 2011 Membership Dues/Fire Chief 21304 Texas Fire Chiefs Association 82511 150.00 09/13/2011 Annual Department renewal 20846 Texas Commission on Fire Protection 091311 1,445.00 Total 1,595.00 0.00 8,061.60 190-045-000-74200 Travel & per diem Balance Forward 3,531.41 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 13.31 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 4.16 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 19.85 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 14.84 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 4.72 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 26.26 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 7.57 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 18.00 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 14.23 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 11.65 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 7.44 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 4.32 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 7.55 Total 153.90 0.00 3,685.31 190-045-000-74300 Schools & Training Balance Forward 3,666.93 09/01/2011 Donnie Hurd 20148 JP Morgan Chase Bank NA 08062011 334.00 09/29/2011 Fire Prevention Materials 21881 National Fire Safety Council, Inc.785636 200.00 09/30/2011 Beck 22255 JP Morgan Chase Bank NA 092611 595.00 Total 1,129.00 0.00 4,795.93 190-045-000-74400 Emergency Management Balance Forward 1,000.00 Total 0.00 0.00 1,000.00 190-045-000-74600 Meetings Balance Forward 22.00 Total 0.00 0.00 22.00 190-045-000-75000 Insurance Balance Forward 8,714.00 Total 0.00 0.00 8,714.00 190-045-000-77300 Fire Inspections/Enforcement Balance Forward 205.12 Total 0.00 0.00 205.12 190-045-000-78200 Small Tools Balance Forward 5,179.95 09/30/2011 Sipes 22255 JP Morgan Chase Bank NA 092611 399.99 09/30/2011 Sipes 22255 JP Morgan Chase Bank NA 092611 9.48 09/30/2011 Sipes 22255 JP Morgan Chase Bank NA 092611 43.19 09/30/2011 Sipes 22255 JP Morgan Chase Bank NA 092611 299.99 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 91.01 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 52.95 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 290.00 09/30/2011 Grunt 22255 JP Morgan Chase Bank NA 092611 199.98 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 23.98 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 414.97 Total 1,825.54 0.00 7,005.49 190-045-000-79200 Building Rental/Lease Balance Forward 308,000.00 Total 0.00 0.00 308,000.00 190-045-000-79999 Miscellaneous Expense Balance Forward 240.47 09/01/2011 Janet Grunt 20148 JP Morgan Chase Bank NA 08062011 100.00 09/01/2011 Gary Sipes 20148 JP Morgan Chase Bank NA 08062011 91.17 09/01/2011 Plaques for Fire Station grand opening 20844 Keller Trophy and Awards, LTD 46333 60.00 09/30/2011 Grunt 22255 JP Morgan Chase Bank NA 092611 10.00 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/30/2011 Grunt 22255 JP Morgan Chase Bank NA 092611 26.00 09/30/2011 Grunt 22255 JP Morgan Chase Bank NA 092611 170.00 09/30/2011 Grunt 22255 JP Morgan Chase Bank NA 092611 8.00 09/30/2011 Grunt 22255 JP Morgan Chase Bank NA 092611 71.98 09/30/2011 Sipes 22255 JP Morgan Chase Bank NA 092611 7.00 Total 544.15 0.00 784.62 190-045-000-80250 Maintenance and Repairs Balance Forward 3,557.84 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 438.00 Total 438.00 0.00 3,995.84 190-045-000-81200 Building Maintenance Balance Forward 8,066.62 09/01/2011 Supply & install input module/telephones 20872 American Communications 57526 245.00 09/01/2011 Donnie Hurd 20148 JP Morgan Chase Bank NA 08062011 91.56 09/01/2011 Shane Beck 20148 JP Morgan Chase Bank NA 08062011 1,019.25 09/01/2011 Danny Thomas 20148 JP Morgan Chase Bank NA 08062011 19.94 09/26/2011 September purchases 21841 Costco Wholesale 092611 248.43 09/30/2011 Directv Refund/Account closed 22137 98.99 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 106.53 09/30/2011 D. Thomas 22255 JP Morgan Chase Bank NA 092611 200.20 09/30/2011 D. Thomas 22255 JP Morgan Chase Bank NA 092611 97.11 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 106.83 09/30/2011 Thomas 22259 JP Morgan Chase Bank NA 100511 151.06 09/30/2011 Beck 22259 JP Morgan Chase Bank NA 100511 74.95 Total 2,360.86 98.99 10,328.49 190-045-000-81300 Vehicle Maintenance Balance Forward 12,864.04 09/01/2011 Donnie Hurd 20148 JP Morgan Chase Bank NA 08062011 65.75 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 14.50 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 61.07 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 76.32 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 91.04 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 96.93 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 45.82 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 218.00 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 400.19 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 32.97 Total 1,102.59 0.00 13,966.63 190-045-000-81350 Equipment Maintenance Balance Forward 622.10 09/08/2011 Annual service/Bauer UN3 10H 20894 August Industries, Inc.025610 634.60 Total 634.60 0.00 1,256.70 190-045-000-81400 Radio Maintenance Balance Forward 465.00 Total 0.00 0.00 465.00 190-045-000-81800 Flags & Repairs Balance Forward 1,972.50 09/21/2011 Flag repair 21302 Symonds Flags & Poles, Inc 3538 75.00 Total 75.00 0.00 2,047.50 190-045-000-81900 Maintenance Supplies Balance Forward 1,420.38 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report9/30/201109/26/2011 September purchases 21841 Costco Wholesale 092611 13.80Total13.80 0.00 1,434.18190-045-000-85000 Grant Match Balance Forward 1,308.60Total0.00 0.00 1,308.60190-045-000-87100 Programs & Special Projects Balance Forward 2,877.8409/01/2011 Helium rental for grand opening/Fire Sta 20906 Apple Oxygen Supply, Inc.30510 107.7009/01/2011 April Reiling 20148 JP Morgan Chase Bank NA 08062011 240.0009/01/2011 Gary Sipes 20148 JP Morgan Chase Bank NA 08062011 804.6509/01/2011 Shane Beck 20148 JP Morgan Chase Bank NA 08062011 40.00Total1,192.35 0.00 4,070.19190-045-000-90100 Radios Balance Forward 1,007.37Total0.00 0.00 1,007.37190-045-000-90200 Fire Engine 681 Payment Balance Forward 73,887.90Total0.00 0.00 73,887.90190-045-000-93200 Vehicles Balance Forward 4,164.55Total0.00 0.00 4,164.55190-045-000-93600 Airpacks Balance Forward 2,245.00Total0.00 0.00 2,245.00 GRAND TOTAL 95,559.82 98.99 1,146,346.33 Journal #Name Debit Credit 20782 Payroll 74,803.97 74,803.97 22279 Payroll 69,321.72 69,321.72 22281 Payroll 76,881.35 76,881.35 20832 Invoice # I11-003247 117.48 117.48 20858 Invoice # I11-003265 15.90 15.90 20860 Invoice # I11-003266 18.28 18.28 20862 Invoice # I11-003267 18.28 18.28 22130 September Postage Mete 470.46 470.46 22255 Invoice # I11-003458 9,638.67 9,638.67 21284 Invoice # I11-003333 147.00 147.00 22259 Invoice # I11-003461 12,450.72 12,450.72 22145 September gas log 11,175.20 11,175.20 21282 Invoice # I11-003332 24.82 24.82 21847 Invoice # I11-003430 41.15 41.15 21865 Invoice # I11-003438 326.05 326.05 21290 Invoice # I11-003336 1,005.35 1,005.35 21837 Invoice # I11-003415 77.34 77.34 20904 Invoice # I11-003288 235.18 235.18 20864 Invoice # I11-003268 965.35 965.35 21875 Invoice # I11-003442 1,026.88 1,026.88 22197 Invoice # I11-003449 7,179.91 7,179.91 Municipal Utility District No 1 Fire Station Construction 2010 General Obligation $2M Bond Fund Interim Balance Sheet 12/12 Months (100% of Fiscal Year) Balance @ 9/30/2011 ASSETS ASSETS INVESTMENTS -$ OTHER RECEIVABLES - TOTAL ASSETS -$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE 118,335$ TOTAL LIABILITIES 118,335 FUND BALANCE DESIGNATED FOR FIRE STATION CONSTRUCTION (118,335) TOTAL LIABILITIES AND FUND BALANCE -$ * General Fund will transfer to cover expenditures over bond money received. September 30, 2011 Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 09/30/2011 From Account: 491-000-000-35050 To Account: 491-000-000-39200 Run Date: 10/13/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 309,158.99 581,877.64 -581,877.64 0.00% [FUND] SubTotal : 491 : Bond Fund 2010 GO 2M Fire 1,295.00 309,158.99 582,931.22 -581,636.22 -44,913.99% Grand Total : 1,295.00 309,158.99 582,931.22 -581,636.22 -44,913.99% PAGE 1 491-045-000-94000 Temporary Housing and Storage 0.00 10,500.00 3,826.07 15,538.89 (5,038.89) 148.0 491-045-000-95000 Construction 0.00 1,405,652.00 302,218.02 2,101,141.22 (695,489.22) 149.5 491-045-000-96300 Engineering 0.00 41,000.00 0.00 40,443.85 556.15 98.6 Total Fire Department 0.00 1,457,152.00 306,044.09 2,157,123.96 (699,971.96) page 1 Budget to Actual - Fire Const Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance 491-045-000-94000 Temporary Housing and Storage Balance Forward 11,712.82 09/02/2011 Temporary storage 20896 Williams Scotsman, Inc 95901610 170.00 09/17/2011 Temporary storage 8/17-8/26, tear down a 20892 Modular Space Corporation 105925162 3,363.80 09/27/2011 Steve Z.22197 Bank of America 092711 292.27 Total 3,826.07 0.00 15,538.89 491-045-000-95000 Construction Balance Forward 1,798,923.20 09/01/2011 Danny Thomas 20148 JP Morgan Chase Bank NA 08062011 497.46 09/01/2011 August Charges 20856 Costco Wholesale 082611 529.98 09/02/2011 Fire Station App 14 20019 Prime Construction Co App 14 269,365.13 09/02/2011 Retainage/Prime App 14/July 20027 14,177.11 09/13/2011 Fire Station furniture/Balance due 20886 National Business Furniture, LLC CV49697 13,571.94 09/27/2011 Mike P.22197 Bank of America 092711 3,758.40 09/27/2011 Steve Z.22197 Bank of America 092711 318.00 Total 302,218.02 0.00 2,101,141.22 491-045-000-96100 Legal Balance Forward 0.00 Total 0.00 0.00 0.00 491-045-000-96300 Engineering Balance Forward 40,443.85 Total 0.00 0.00 40,443.85 491-045-000-96500 Bond Issuance Cost Balance Forward 0.00 Total 0.00 0.00 0.00 GRAND TOTAL 306,044.09 0.00 2,157,123.96 Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 9/30/2011 ASSETS ASSETS CASH AND CASH IN BANK -$ INVESTMENTS 107,847 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 13,591 TOTAL ASSETS 121,438$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 13,591$ TOTAL LIABILITIES 13,591 FUND BALANCE DESIGNATED FOR DEBT SERVICE 107,847 TOTAL LIABILITIES AND FUND BALANCE 121,438$ September 30, 2011 12/12 Months 100% of Fiscal Year) Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 09/30/2011 From Account: 680-000-000-30100 To Account: 680-000-000-39200 Run Date: 10/13/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 8,026.78 766,518.35 -10,806.35 -1.43% 680-000-000-30125 : Property Taxes/Delinquent 0.00 292.51 5,112.55 -5,112.55 0.00% 680-000-000-30150 : Property Taxes/Penalty & Interest 9,500.00 1,781.59 6,017.40 3,482.60 36.66% 680-000-000-35050 : Interest Income 500.00 7.47 985.38 -485.38 -97.08% 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 10,108.35 1,332,733.68 -12,921.68 -0.98% Grand Total : 1,319,812.00 10,108.35 1,332,733.68 -12,921.68 -0.98% PAGE 1 680-680-000-89000 Bond Principal 1,115,000.00 1,115,000.00 0.00 1,115,000.00 0.00 100.0 680-680-000-89100 Bond Interest 379,559.00 379,559.00 0.00 379,558.55 0.45 100.0 680-680-000-89200 Paying Agent Fees 3,500.00 3,500.00 0.00 2,460.00 1,040.00 70.3 Total Debt Service 1,498,059.00 1,498,059.00 0.00 1,497,018.55 1,040.45 page 1 Budget to Actual -Debt Service Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance 680-680-000-89000 Bond Principal Balance Forward 1,115,000.00 Total 0.00 0.00 1,115,000.00 680-680-000-89100 Bond Interest Balance Forward 379,558.55 Total 0.00 0.00 379,558.55 680-680-000-89200 Paying Agent Fees Balance Forward 2,460.00 Total 0.00 0.00 2,460.00 GRAND TOTAL 0.00 0.00 1,497,018.55 Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011