Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
July 2011 Budget Summary
Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 7/31/2011 ASSETS ASSETS CASH ON HAND 450 CASH IN BANK 832,141 INVESTMENTS 2,296,169 RESTRICTED ASSETS: INVESTMENTS 344,540 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 3,006 UTILITY AND OTHER ACCOUNTS RECEIVABLE 445,094 TOTAL ASSETS 3,921,400$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,006$ ACCOUNTS PAYABLE 490,908 CUSTOMER DEPOSITS 182,037 TOTAL LIABILITIES 675,951 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT 162,503 UNDESIGNATED FUND BALANCE 3,082,946 TOTAL FUND BALANCE 3,245,449 TOTAL LIABILITIES AND FUND BALANCE 3,921,400$ July 31, 2011 10/12 Months (84% of Fiscal Year) Account/DescriptionYTD BudgetTotal BudgetMTD RevYTD RevTotal VarianceRemaining %[FUND] 180 : MUD 1 General Fund180-000-000-30100 : Property Taxes86,314.0086,314.00231.3286,555.36-241.36-0.28180-000-000-30125 : Property Taxes/Delinquent0.000.0019.36767.24-767.240.00180-000-000-30150 : Property Taxes/Penalty & Interest0.000.0026.191,407.11-1,407.110.00180-000-000-35050 : Interest Income2,000.002,000.00352.734,757.21-2,757.21-137.86180-000-000-35150 : Cell Tower Lease Revenue10,164.0010,164.00847.008,470.001,694.0016.67180-000-000-35170 : Building Rent7,000.007,000.00583.335,833.301,166.7016.67180-000-000-36100 : Gas Well Revenues2,000.002,000.0086.29765.351,234.6561.73180-000-000-36400 : Auction Sales0.000.000.00202.12-202.120.00180-000-000-36500 : Vending Revenue850.00850.00367.81830.8119.192.26180-000-000-36700 : Miscellaneous Revenue14,500.0014,500.00100.009,311.105,188.9035.79180-000-000-36900 : Recovery of Prior Year Expense0.000.000.002,119.00-2,119.000.00180-000-000-38100 : Water - Residential1,709,811.001,709,811.00251,205.771,423,090.59286,720.4116.77180-000-000-38120 : Water - Commercial777,075.00777,075.0089,330.47581,568.69195,506.3125.16180-000-000-38130 : Water - PID195,249.00195,249.0047,069.23235,260.09-40,011.09-20.49180-000-000-38140 : Portable Meters - Out of District16,000.0016,000.0012,071.0739,493.67-23,493.67-146.84180-000-000-38200 : Sewer - Residential1,098,146.001,098,146.00113,041.60913,112.80185,033.2016.85180-000-000-38220 : Sewer - Commercial300,403.00300,403.0032,776.06233,367.7667,035.2422.32180-000-000-38230 : Sewer - PID74,364.0074,364.0018,738.12128,816.61-54,452.61-73.22180-000-000-38240 : Sewer - Out of District10,000.0010,000.001,947.6713,690.42-3,690.42-36.90180-000-000-38250 : TCCC Effluent Charges47,500.0047,500.0015,140.1944,098.533,401.477.16180-000-000-38300 : Standby0.000.0066.00607.60-607.600.00180-000-000-38320 : Penalties50,000.0050,000.006,355.0636,675.7513,324.2526.65180-000-000-38340 : Service Charges17,500.0017,500.001,453.0012,936.424,563.5826.08180-000-000-38360 : Penalities - Out of District500.00500.000.00270.19229.8145.96180-000-000-38400 : Plumbing Inspections0.000.00250.001,800.00-1,800.000.00180-000-000-38420 : Sewer Inspections3,000.003,000.00750.005,400.00-2,400.00-80.00180-000-000-38500 : PID Utility Fees167,900.00167,900.0069,000.0080,500.0087,400.0052.06180-000-000-38540 : Sewer/Septic Dump Fees48,000.0048,000.000.000.0048,000.00100.00180-000-000-38560 : Fire Line Fees5,000.005,000.000.00525.004,475.0089.50180-000-000-38600 : Oversize Meter Reimbursements50,000.0050,000.0014,058.6954,447.69-4,447.69-8.90180-000-000-39290 : Transfer In - Future Replacement Reserve54,314.0054,314.000.000.0054,314.00100.00[FUND] SubTotal : 180 : MUD 1 General Fund4,747,590.004,747,590.00675,866.963,926,680.41820,909.5917.29 Grand Total : 4,747,590.004,747,590.00675,866.963,926,680.41820,909.5917.29Run Date: 08/11/2011User: rgonzalesTrophy Club Municipal Utility Dist #1Budget Revenue ReportTo Date: 07/31/2011 180-010-000-40100 Salaries - Regular 165,718.00 165,718.00 12,273.86 110,193.11 55,524.89 66.5 180-010-000-40130 Salaries - Overtime 8,814.00 8,814.00 1,992.16 12,312.26 (3,498.26) 139.7 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,430.00 70.00 95.3 180-010-000-41200 Retirement 24,945.00 24,945.00 2,041.29 17,887.05 7,057.95 71.7 180-010-000-41210 Medical Insurance 27,748.00 27,748.00 2,125.96 18,023.26 9,724.74 65.0 180-010-000-41215 Dental Insurance 1,446.00 1,446.00 127.44 1,061.46 384.54 73.4 180-010-000-41216 Vision Insurance 269.00 269.00 22.28 190.43 78.57 70.8 180-010-000-41218 Life Insurance & Other 1,177.00 1,177.00 0.00 301.92 875.08 25.7 180-010-000-42220 Social Security Taxes 10,994.00 10,994.00 842.99 7,458.95 3,535.05 67.8 180-010-000-42225 Medicare Taxes 2,571.00 2,571.00 197.15 1,744.43 826.57 67.9 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 1,842.17 7,368.69 395.31 94.9 180-010-000-42290 Pre-employment Physicals/Testing 200.00 200.00 0.00 0.00 200.00 # 180-010-000-42960 Employee Relations 350.00 350.00 0.00 226.04 123.96 64.6 180-010-000-50500 Engineering 1,500.00 1,500.00 0.00 80.15 1,419.85 5.3 180-010-000-52400 Lab Analysis 3,850.00 3,850.00 165.00 2,073.00 1,777.00 53.8 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 167,542.59 931,001.06 478,998.94 66.0 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,862.36 7,994.11 7,221.89 52.5 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 0.00 3,214.64 2,985.36 51.8 180-010-000-72100 Electricity 175,000.00 175,000.00 22,253.55 115,076.42 59,923.58 65.8 180-010-000-73200 Communications /Pagers/Mobiles 1,599.00 1,599.00 164.84 1,515.13 83.87 94.8 180-010-000-73350 Copies 50.00 50.00 0.00 0.00 50.00 # 180-010-000-73400 Printing 150.00 150.00 0.00 0.00 150.00 # 180-010-000-74100 Dues & Membership 150.00 150.00 0.00 61.00 89.00 40.7 180-010-000-74200 Travel & per diem 3,200.00 3,200.00 182.07 866.94 2,333.06 27.1 180-010-000-74300 Schools & Training 2,800.00 2,800.00 0.00 1,508.00 1,292.00 53.9 180-010-000-74700 Safety Program 500.00 500.00 0.00 7.17 492.83 1.4 180-010-000-75200 Annual Permit Fee 6,600.00 6,600.00 0.00 6,133.95 466.05 92.9 180-010-000-78100 Meter Expense 85,000.00 85,000.00 0.00 83,182.24 1,817.76 97.9 180-010-000-78200 Small Tools 2,500.00 2,500.00 0.00 284.87 2,215.13 11.4 180-010-000-78300 Safety Equipment 2,500.00 2,500.00 0.00 0.00 2,500.00 # 180-010-000-78500 Furniture/Equipment<$5,000 1,500.00 1,500.00 0.00 0.00 1,500.00 # 180-010-000-78600 Hardware 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-010-000-79150 Equipment Rental/Lease 500.00 500.00 0.00 770.00 (270.00) 154.0 page 1 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-010-000-79400 Bad Debt Expense 4,200.00 4,200.00 0.00 2,172.73 2,027.27 51.7 180-010-000-79999 Miscellaneous Expense 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-010-000-80250 Maintenance and Repairs 29,500.00 29,500.00 112.50 7,329.61 22,170.39 24.8 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 0.00 702.85 3,497.15 16.7 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 0.00 2,182.50 1,197.50 64.6 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 0.00 8,128.51 23,871.49 25.4 180-010-000-91000 Capital Lease 11,490.00 11,490.00 0.00 0.00 11,490.00 # 180-010-000-93700 Capital Expenses 130,932.00 130,932.00 0.00 215,853.45 (84,921.45) 164.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-99500 Transfer to Future Replacement Reserve 30,000.00 30,000.00 0.00 0.00 30,000.00 # Total Water 2,367,044.00 2,367,044.00 213,898.21 1,670,453.19 696,590.81 page 2 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-020-000-40100 Salaries - Regular 176,791.00 176,791.00 13,603.20 139,514.05 37,276.95 78.9 180-020-000-40130 Salaries - Overtime 10,166.00 10,166.00 1,396.27 11,442.47 (1,276.47) 112.6 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 1,975.00 575.00 77.5 180-020-000-41200 Retirement 27,019.00 27,019.00 2,152.25 22,103.56 4,915.44 81.8 180-020-000-41210 Medical Insurance 37,298.00 37,298.00 2,785.32 27,853.41 9,444.59 74.7 180-020-000-41215 Dental Insurance 1,983.00 1,983.00 154.98 1,534.35 448.65 77.4 180-020-000-41216 Vision Insurance 341.00 341.00 29.76 297.60 43.40 87.3 180-020-000-41218 Life Insurance & Other 1,237.00 1,237.00 0.00 415.01 821.99 33.5 180-020-000-42220 Social Security Taxes 10,504.00 10,504.00 799.31 8,439.08 2,064.92 80.3 180-020-000-42225 Medicare Taxes 2,457.00 2,457.00 186.94 1,973.66 483.34 80.3 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 1,995.46 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 0.00 9,978.75 8,771.25 53.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 7.24 392.76 1.8 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 670.88 2,291.15 4,583.85 33.3 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 0.00 4,028.28 8,971.72 31.0 180-020-000-62800 Lab Supplies 6,085.00 6,085.00 0.00 3,559.06 2,525.94 58.5 180-020-000-62900 Other Consumables 110.00 110.00 0.00 50.14 59.86 45.6 180-020-000-72100 Electricity 205,000.00 205,000.00 17,153.85 165,748.95 39,251.05 80.9 180-020-000-72200 Water 1,900.00 1,900.00 48.82 1,288.84 611.16 67.8 180-020-000-72400 Dumpster Services 35,000.00 35,000.00 0.00 11,319.25 23,680.75 32.3 180-020-000-73100 Telephone 0.00 10.00 2.00 3.36 6.64 33.6 180-020-000-73200 Communications /Pagers/Mobiles 3,000.00 3,000.00 242.66 2,848.56 151.44 95.0 180-020-000-74200 Travel & per diem 1,750.00 1,750.00 208.59 1,910.40 (160.40) 109.2 180-020-000-74300 Schools & Training 1,320.00 1,320.00 0.00 900.00 420.00 68.2 180-020-000-74700 Safety Program 200.00 200.00 0.00 7.18 192.82 3.6 180-020-000-75200 Annual Permit Fee 7,500.00 7,500.00 0.00 10,704.14 (3,204.14) 142.7 180-020-000-78200 Small Tools 1,260.00 1,260.00 0.00 481.71 778.29 38.2 180-020-000-78300 Safety Equipment 540.00 540.00 0.00 658.23 (118.23) 121.9 180-020-000-78600 Hardware 525.00 525.00 0.00 35.81 489.19 6.8 180-020-000-79150 Equipment Rental/Lease 200.00 200.00 0.00 0.00 200.00 # 180-020-000-79999 Miscellaneous Expense 525.00 515.00 0.00 0.00 515.00 # 180-020-000-80250 Maintenance and Repairs 17,750.00 17,750.00 0.00 11,439.01 6,310.99 64.4 page 3 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-020-000-81200 Building Maintenance 1,400.00 1,400.00 0.00 0.00 1,400.00 # 180-020-000-81300 Vehicle Maintenance 4,998.00 4,998.00 0.00 1,049.74 3,948.26 21.0 180-020-000-81360 Maintenance - Backhoe/Skid Loader 2,950.00 2,950.00 0.00 1,126.76 1,823.24 38.2 180-020-000-81500 Lawn Maintenance 525.00 525.00 0.00 95.90 429.10 18.3 180-020-000-81900 Maintenance Supplies 5,860.00 5,860.00 0.00 761.82 5,098.18 13.0 180-020-000-93700 Capital Expenses 136,189.00 136,189.00 118,689.39 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 160,319.68 588,192.68 211,203.32 page 4 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-021-000-40100 Salaries - Regular 136,341.00 136,341.00 10,518.72 107,736.96 28,604.04 79.0 180-021-000-40130 Salaries - Overtime 14,145.00 14,145.00 696.66 13,816.44 328.56 97.7 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,250.00 (50.00) 104.2 180-021-000-41200 Retirement 21,674.00 21,674.00 1,605.80 17,778.40 3,895.60 82.0 180-021-000-41210 Medical Insurance 28,228.00 28,228.00 1,978.38 18,871.57 9,356.43 66.9 180-021-000-41215 Dental Insurance 1,426.00 1,426.00 118.88 1,129.69 296.31 79.2 180-021-000-41216 Vision Insurance 253.00 253.00 19.86 190.56 62.44 75.3 180-021-000-41218 Life Insurance & Other 942.00 942.00 0.00 316.23 625.77 33.6 180-021-000-42220 Social Security Taxes 8,769.00 8,769.00 619.97 7,210.71 1,558.29 82.2 180-021-000-42225 Medicare Taxes 2,051.00 2,051.00 145.00 1,688.89 362.11 82.3 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 1,046.84 4,187.36 224.64 94.9 180-021-000-42960 Employee Relations 250.00 250.00 0.00 191.59 58.41 76.6 180-021-000-50500 Engineering 1,500.00 1,500.00 0.00 80.14 1,419.86 5.3 180-021-000-57000 Independent Labor 200.00 200.00 0.00 0.00 200.00 # 180-021-000-60300 Postage 150.00 150.00 0.00 0.00 150.00 # 180-021-000-61000 Fuel 11,700.00 11,700.00 2,137.41 8,065.44 3,634.56 68.9 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 0.00 12,500.00 # 180-021-000-72100 Electricity 23,625.00 23,625.00 404.47 13,961.36 9,663.64 59.1 180-021-000-72200 Water 750.00 750.00 0.00 0.00 750.00 # 180-021-000-73100 Telephone 0.00 0.00 1.05 21.63 (21.63) # 180-021-000-73200 Communications /Pagers/Mobiles 2,796.00 2,796.00 203.63 2,332.91 463.09 83.4 180-021-000-74100 Dues & Membership 255.00 255.00 61.00 61.00 194.00 23.9 180-021-000-74200 Travel & per diem 1,500.00 1,500.00 32.64 583.90 916.10 38.9 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 16.50 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 5,200.00 5,841.37 2,301.63 71.7 180-021-000-81900 Maintenance Supplies 16,050.00 16,050.00 0.00 2,050.63 13,999.37 12.8 180-021-000-93700 Capital Expenses 15,000.00 15,000.00 0.00 0.00 15,000.00 # 180-021-000-97000 Capital Repairs 20,000.00 20,000.00 0.00 0.00 20,000.00 # page 5 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Total Collection 416,658.00 416,658.00 24,931.81 216,241.58 200,416.42 page 6 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-130-000-40100 Salaries - Regular 10,000.00 10,000.00 1,200.00 5,400.00 4,600.00 54.0 180-130-000-42220 Social Security Taxes 620.00 620.00 74.40 334.80 285.20 54.0 180-130-000-42225 Medicare Taxes 145.00 145.00 17.40 78.30 66.70 54.0 180-130-000-42250 Unemployment Taxes 210.00 210.00 9.60 66.60 143.40 31.7 180-130-000-42260 Workman's Compensation 120.00 120.00 28.47 113.88 6.12 94.9 180-130-000-60100 Office Supplies 50.00 50.00 0.00 0.00 50.00 # 180-130-000-60300 Postage 0.00 0.00 0.00 (1.86) 1.86 # 180-130-000-60400 Publications/Books/Subscriptions 50.00 50.00 0.00 0.00 50.00 # 180-130-000-74100 Dues & Membership 2,100.00 2,100.00 0.00 79.00 2,021.00 3.8 180-130-000-74200 Travel & per diem 5,805.00 5,805.00 209.24 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 0.00 289.00 989.00 22.6 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,539.11 11,802.70 12,725.30 page 7 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-140-000-40100 Salaries - Regular 214,374.00 214,374.00 22,634.06 170,359.06 44,014.94 79.5 180-140-000-40130 Salaries - Overtime 500.00 500.00 40.58 262.06 237.94 52.4 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 3,034.16 23,871.54 6,488.46 78.6 180-140-000-41210 Medical Insurance 17,925.00 17,925.00 866.08 13,981.25 3,943.75 78.0 180-140-000-41215 Dental Insurance 930.00 930.00 51.64 796.29 133.71 85.6 180-140-000-41216 Vision Insurance 179.00 179.00 9.96 147.96 31.04 82.7 180-140-000-41218 Life Insurance & Other 1,205.00 1,205.00 0.00 373.34 831.66 31.0 180-140-000-42220 Social Security Taxes 13,474.00 13,474.00 1,388.13 10,721.90 2,752.10 79.6 180-140-000-42225 Medicare Taxes 3,151.00 3,151.00 324.64 2,531.23 619.77 80.3 180-140-000-42250 Unemployment Taxes 630.00 630.00 19.29 447.87 182.13 71.1 180-140-000-42260 Workman's Compensation 783.00 783.00 185.78 743.12 39.88 94.9 180-140-000-42290 Pre-employment Physicals/Testing 0.00 0.00 22.47 74.92 (74.92) # 180-140-000-42960 Employee Relations 1,000.00 1,000.00 0.00 906.17 93.83 90.6 180-140-000-50100 Professional Outside Services 229,076.00 229,076.00 0.00 228,075.63 1,000.37 99.6 180-140-000-52100 Elections 2,500.00 2,500.00 0.00 1,952.65 547.35 78.1 180-140-000-54200 Records Management 500.00 500.00 0.00 120.00 380.00 24.0 180-140-000-57000 Independent Labor 840.00 840.00 84.37 406.87 433.13 48.4 180-140-000-60100 Office Supplies 2,450.00 2,450.00 113.64 1,346.19 1,103.81 54.9 180-140-000-60300 Postage 1,571.00 1,571.00 617.94 1,954.09 (383.09) 124.4 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 16.48 196.73 3.27 98.4 180-140-000-73200 Communications /Pagers/Mobiles 1,798.00 1,798.00 157.63 2,326.73 (528.73) 129.4 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 0.00 1,714.50 (102.50) 106.4 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 1,640.93 914.07 64.2 180-140-000-74600 Meetings 312.00 312.00 0.00 116.00 196.00 37.2 180-140-000-76700 July 4 Celebration 10,000.00 10,000.00 0.00 0.00 10,000.00 # 180-140-000-78500 Furniture/Equipment<$5,000 1,750.00 1,750.00 3,405.57 4,081.30 (2,331.30) 233.2 180-140-000-79999 Miscellaneous Expense 100.00 100.00 0.00 0.00 100.00 # Total Managers Office 547,908.00 547,908.00 32,972.42 476,522.24 71,385.76 page 8 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-611-000-40100 Salaries - Regular 70,839.00 70,839.00 5,449.60 54,921.96 15,917.04 77.5 180-611-000-40130 Salaries - Overtime 3,500.00 3,500.00 1,047.85 12,042.79 (8,542.79) 344.1 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 920.04 9,805.74 841.26 92.1 180-611-000-41210 Medical Insurance 8,583.00 8,583.00 715.24 6,964.43 1,618.57 81.1 180-611-000-41215 Dental Insurance 393.00 393.00 43.06 409.72 (16.72) 104.3 180-611-000-41216 Vision Insurance 75.00 75.00 4.98 49.80 25.20 66.4 180-611-000-41218 Life Insurance & Other 424.00 424.00 0.00 140.01 283.99 33.0 180-611-000-42220 Social Security Taxes 4,697.00 4,697.00 342.38 3,806.37 890.63 81.0 180-611-000-42225 Medicare Taxes 1,099.00 1,099.00 80.07 890.20 208.80 81.0 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 65.01 260.04 13.96 94.9 180-611-000-50100 Professional Outside Services 5,000.00 5,000.00 0.00 2,437.50 2,562.50 48.7 180-611-000-60100 Office Supplies 600.00 600.00 14.16 495.65 104.35 82.6 180-611-000-60300 Postage 500.00 500.00 0.00 306.75 193.25 61.4 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 1.59 13.18 86.82 13.2 180-611-000-73200 Communications /Pagers/Mobiles 670.00 670.00 52.81 560.98 109.02 83.7 180-611-000-73300 Advertising 500.00 500.00 0.00 207.40 292.60 41.5 180-611-000-73400 Printing 500.00 500.00 0.00 0.00 500.00 # 180-611-000-73600 Service Charges & Fees 77.00 77.00 0.00 0.00 77.00 # 180-611-000-74100 Dues & Membership 413.00 413.00 0.00 22.00 391.00 5.3 180-611-000-74200 Travel & per diem 1,547.00 1,547.00 0.00 145.13 1,401.87 9.4 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 0.00 0.00 88.00 # Total Finance 113,706.00 113,706.00 8,736.79 95,628.24 18,077.76 page 9 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-620-000-40100 Salaries - Regular 112,537.00 112,537.00 8,061.23 72,676.73 39,860.27 64.6 180-620-000-40130 Salaries - Overtime 1,500.00 1,500.00 94.99 706.43 793.57 47.1 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,154.92 9,942.88 6,056.12 62.1 180-620-000-41210 Medical Insurance 21,773.00 21,773.00 1,399.44 13,779.58 7,993.42 63.3 180-620-000-41215 Dental Insurance 1,136.00 1,136.00 92.07 902.77 233.23 79.5 180-620-000-41216 Vision Insurance 209.00 209.00 16.03 159.43 49.57 76.3 180-620-000-41218 Life Insurance & Other 800.00 800.00 0.00 249.23 550.77 31.2 180-620-000-42220 Social Security Taxes 7,029.00 7,029.00 454.58 4,368.44 2,660.56 62.1 180-620-000-42225 Medicare Taxes 1,644.00 1,644.00 106.31 1,021.65 622.35 62.1 180-620-000-42250 Unemployment Taxes 540.00 540.00 9.12 393.60 146.40 72.9 180-620-000-42260 Workman's Compensation 411.00 411.00 97.52 390.08 20.92 94.9 180-620-000-42290 Pre-employment Physicals/Testing 0.00 0.00 22.48 22.48 (22.48) # 180-620-000-56200 Utility Billing Contract 11,000.00 11,000.00 1,054.04 8,840.88 2,159.12 80.4 180-620-000-57000 Independent Labor 800.00 800.00 0.00 0.00 800.00 # 180-620-000-60100 Office Supplies 700.00 700.00 221.90 405.99 294.01 58.0 180-620-000-60300 Postage 18,000.00 18,000.00 1,369.95 13,158.75 4,841.25 73.1 180-620-000-73100 Telephone 100.00 100.00 2.93 98.28 1.72 98.3 180-620-000-73200 Communications /Pagers/Mobiles 472.00 472.00 37.33 410.36 61.64 86.9 180-620-000-73400 Printing 3,000.00 3,000.00 0.00 2,152.00 848.00 71.7 180-620-000-73600 Service Charges & Fees 18,000.00 18,000.00 1,975.43 18,155.75 (155.75) 100.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 0.00 30.09 574.91 5.0 180-620-000-74300 Schools & Training 800.00 800.00 46.44 46.44 753.56 5.8 180-620-000-75600 TCEQ Annual Assessment Fee 20,000.00 20,000.00 0.00 19,248.17 751.83 96.2 180-620-000-79999 Miscellaneous Expense 200.00 200.00 0.00 1.84 198.16 0.9 Total Utility Billing 237,571.00 237,571.00 16,216.71 167,566.85 70,004.15 page 10 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-630-000-42290 Pre-employment Physicals/Testing 1,260.00 1,260.00 0.00 152.41 1,107.59 12.1 180-630-000-42960 Employee Relations 1,788.00 1,788.00 43.88 518.85 1,269.15 29.0 180-630-000-43240 Tuition Reimbursement 1,530.00 1,530.00 0.00 74.65 1,455.35 4.9 180-630-000-60100 Office Supplies 424.00 424.00 0.00 0.00 424.00 # 180-630-000-60300 Postage 104.00 104.00 0.00 0.00 104.00 # 180-630-000-60400 Publications/Books/Subscriptions 462.00 462.00 0.00 0.00 462.00 # 180-630-000-73100 Telephone 27.00 27.00 0.00 0.00 27.00 # 180-630-000-73400 Printing 113.00 113.00 0.00 0.00 113.00 # 180-630-000-74100 Dues & Membership 529.00 529.00 0.00 0.00 529.00 # 180-630-000-74200 Travel & per diem 8.00 8.00 0.00 0.00 8.00 # 180-630-000-74300 Schools & Training 566.00 566.00 0.00 0.00 566.00 # 180-630-000-74600 Meetings 134.00 134.00 0.00 0.00 134.00 # Total Human Resources 6,945.00 6,945.00 43.88 745.91 6,199.09 page 11 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-640-000-50700 Security 1,350.00 1,350.00 0.00 42.51 1,307.49 3.1 180-640-000-55000 Software & Support 50,453.00 50,453.00 3,897.28 43,436.45 7,016.55 86.1 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 0.00 244.61 126.39 65.9 180-640-000-60200 Printer Supplies 5,732.00 5,732.00 448.00 5,236.46 495.54 91.4 180-640-000-73100 Telephone 8,040.00 8,040.00 803.36 8,779.13 (739.13) 109.2 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 413.36 37,054.63 23,097.37 61.6 180-640-000-79100 Copier Rental/Lease 3,450.00 3,450.00 273.29 2,459.61 990.39 71.3 180-640-000-99500 Transfer to Future Replacement Reserve 26,911.00 26,911.00 0.00 0.00 26,911.00 # Total Information Services 157,923.00 157,923.00 5,835.29 99,632.86 58,290.14 page 12 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-710-000-52400 Lab Analysis 0.00 0.00 0.00 1,168.75 (1,168.75) # 180-710-000-62520 Vending Machine Supplies 1,000.00 1,000.00 0.00 429.28 570.72 42.9 180-710-000-72100 Electricity 20,895.00 20,895.00 1,315.49 10,964.97 9,930.03 52.5 180-710-000-72200 Water 1,061.00 1,061.00 81.12 560.41 500.59 52.8 180-710-000-75000 Insurance 31,081.00 31,081.00 0.00 23,475.81 7,605.19 75.5 180-710-000-79200 Building Rental/Lease 13,182.00 13,182.00 1,098.51 10,985.10 2,196.90 83.3 180-710-000-81200 Building Maintenance 11,970.00 11,970.00 64.00 13,398.94 (1,428.94) 111.9 180-710-000-81600 Cleaning Services 9,450.00 9,450.00 559.50 6,863.45 2,586.55 72.6 180-710-000-81900 Maintenance Supplies 2,100.00 2,100.00 65.68 1,530.46 569.54 72.9 Total Facilities Maintenance 90,739.00 90,739.00 3,184.30 69,377.17 21,361.83 page 13 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-810-000-50200 Auditing 27,500.00 27,500.00 0.00 27,500.00 0.00 100.0 180-810-000-50300 Legal 35,000.00 35,000.00 0.00 27,933.31 7,066.69 79.8 180-810-000-51100 Appraisal 20,211.00 20,211.00 (62.73) 12,269.68 7,941.32 60.7 180-810-000-51150 Tax Administration 3,603.00 3,603.00 56.24 2,696.56 906.44 74.8 Total Non Departmental 86,314.00 86,314.00 (6.49)70,399.55 15,914.45 Total Expenses 4,848,732.00 4,848,732.00 467,671.71 3,466,562.97 1,382,169.03 page 14 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance180-000-000-30100Property TaxesBalance Forward-86,324.04CR07/06/2011MUD 1 AV Taxes1668936.9807/08/2011MUD 1 AV Taxes1671530.8207/11/2011MUD 1 AV Taxes1673328.6607/11/2011MUD 1 AV Taxes1669130.8207/11/2011MUD 1 AV Taxes1671330.8207/12/2011MUD 1 AV Taxes1673529.7807/13/2011MUD 1 AV Taxes1680113.4207/15/2011MUD 1 AV Taxes169688.4107/18/2011MUD 1 AV Taxes171323.2507/19/2011MUD 1 AV Taxes174607.2007/22/2011MUD 1 AV Taxes177703.2007/25/2011MUD 1 AV Taxes1776817.2307/26/2011MUD 1 AV Taxes1777215.2207/27/2011MUD 1 AV Taxes1777410.9607/28/2011MUD 1 AV Taxes1782422.3807/29/2011MUD 1 AV Taxes178263.81Total30.82262.14 -86,555.36 CR180-000-000-30125Property Taxes/DelinquentBalance Forward-747.88CR07/15/2011MUD 1 AV Taxes169681.5107/21/2011MUD 1 AV Taxes174620.1407/26/2011MUD 1 AV Taxes1777217.71Total0.0019.36-767.24 CR180-000-000-30150Property Taxes/Penalty & InterestBalance Forward-1,380.92CR07/06/2011Advalorem Taxes166895.5507/08/2011 Advalorem Taxes 167154.6307/11/2011 Advalorem Taxes 167330.0807/11/2011 Advalorem Taxes 166914.6307/11/2011 Advalorem Taxes 167134.6307/12/2011 Advalorem Taxes 167353.8107/13/2011 Advalorem Taxes 168010.0407/15/2011 Advalorem Taxes 169681.6207/19/2011 Advalorem Taxes 174601.2907/21/2011 Advalorem Taxes 174620.0607/25/2011 Advalorem Taxes 177680.4107/26/2011 Advalorem Taxes 177720.9407/28/2011 Advalorem Taxes 178247.76Total4.63 30.82 -1,407.11 CR180-000-000-35050Interest IncomeBalance Forward-4,404.48CR07/31/2011July Bank Interst18202166.7007/31/2011July Bank Interst18202186.03Total0.00352.73 -4,757.21 CR180-000-000-35150Cell Tower Lease RevenueBalance Forward-7,623.00CR07/05/2011Cell Tower Revenue/July17798847.00Total0.00847.00 -8,470.00 CR180-000-000-35160Lease/Rental RevenueBalance Forward0.00Total0.00 0.00 0.00180-000-000-35170Building RentBalance Forward-5,249.97CR07/29/2011Town/July Maint Barn Rent18150583.33Total0.00583.33 -5,833.30 CRTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-000-000-35420Loan ProceedsBalanceForward0.00Total0.00 0.00 0.00180-000-000-35430Capital Lease ProceedsBalance Forward0.00Total0.00 0.00 0.00180-000-000-36100Gas Well RevenuesBalance Forward-679.06CR07/29/2011Encana/Gas Well Revenue1781086.29Total0.0086.29-765.35 CR180-000-000-36400Auction SalesBalance Forward-202.12CRTotal0.00 0.00 -202.12 CR180-000-000-36500Vending RevenueBalance Forward-463.00CR07/14/2011WWTP Vending Revenue17800367.81Total0.00367.81-830.81 CR180-000-000-36700Miscellaneous RevenueBalance Forward-9,211.10CR07/18/2011Permits 7/18/1117146100.00Total0.00100.00 -9,311.10 CR180-000-000-36900Recovery of Prior Year ExpenseBalance Forward-2,119.00CRTotal0.00 0.00 -2,119.00 CR180-000-000-37100Prior Year ReservesBalance Forward0.00Total0.00 0.00 0.00180-000-000-38100Water - ResidentialBalance Forward-1,171,884.82CR07/31/2011UB July Credit Adjustments181362,456.9607/31/2011UB July Billings18140248,748.81Total0.00 251,205.77 -1,423,090.59 CR180-000-000-38120Water - CommercialBalance Forward-492,238.22CR07/29/2011UB Adjustments178347,303.1207/31/2011UB July Credit Adjustments181361,593.9607/31/2011UB July Billings1814098,227.55Total8,897.08 98,227.55 -581,568.69 CR180-000-000-38130Water - PIDBalance Forward-188,190.86CR07/20/2011PID June Water billed1780247,069.23Total0.00 47,069.23 -235,260.09 CR180-000-000-38140Portable Meters - Out of DistrictBalance Forward-27,422.60CR07/18/2011UB Adjustments16964200.0007/21/2011UB Late Fees17324213.5907/28/2011UB Adjustments Penalties17818182.2407/31/2011UB July Credit Adjustments18136182.2407/31/2011UB July Billings1814011,657.48Total182.24 12,253.31 -39,493.67 CR180-000-000-38200Sewer - ResidentialBalance Forward-800,071.20CR07/31/2011UB July Credit Adjustments181362,020.9907/31/2011UB July Billings18140115,062.59Total2,020.99 115,062.59 -913,112.80 CR180-000-000-38220Sewer - CommercialBalance Forward-200,591.70CR G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 201107/31/2011UB July Credit Adjustments1813689.7907/31/2011UB July Billings1814032,865.85Total89.79 32,865.85 -233,367.76 CR180-000-000-38230Sewer - PIDBalance Forward-110,078.49CR07/20/2011PID June Water billed1780218,738.12Total0.00 18,738.12 -128,816.61 CR180-000-000-38240Sewer - Out of DistrictBalance Forward-11,742.75CR07/31/2011UB July Credit Adjustments18136182.2407/31/2011UB July Billings181402,129.91Total182.24 2,129.91 -13,690.42 CR180-000-000-38250TCCC Effluent ChargesBalance Forward-28,958.34CR07/21/2011TCCC June Effluent1780415,140.19Total0.00 15,140.19 -44,098.53 CR180-000-000-38300StandbyBalance Forward-541.60CR07/31/2011UB July Credit Adjustments1813612.0007/31/2011UB July Billings1814078.00Total12.0078.00-607.60 CR180-000-000-38320PenaltiesBalance Forward-30,320.69CR07/11/2011UB Adjustments16725241.1707/21/2011UB Late Fees173246,632.7807/28/2011UB Adjustments Penalties178181,948.0507/29/2011UB Adjustments1783437.2707/31/2011UB July Credit Adjustments181361,948.77Total2,226.49 8,581.55 -36,675.75 CR180-000-000-38340Service ChargesBalance Forward-11,483.42CR07/06/2011UB Adjustments163591,250.0007/06/2011UB Adjustments17836125.0007/11/2011UB Adjustments1772625.0007/12/2011UB Adjustments1773025.0007/18/2011UB Adjustments1773425.0007/21/2011UB Adjustments1773825.0007/28/2011UB Adjustments Penalties1781825.0007/31/2011UB July Billings181403.00Total25.00 1,478.00 -12,936.42 CR180-000-000-38360Penalities - Out of DistrictBalance Forward-270.19CRTotal0.00 0.00 -270.19 CR180-000-000-38400Plumbing InspectionsBalance Forward-1,550.00CR07/05/2011Permits 7/5/111713650.0007/11/2011Permits 7/11/111714050.0007/18/2011Permits 7/18/111714650.0007/20/2011Permits 7/20/111778250.0007/22/2011Permits 7/22/111778450.00Total0.00250.00 -1,800.00 CR180-000-000-38420Sewer InspectionsBalance Forward-4,650.00CR07/05/2011Permits 7/5/1117136150.0007/11/2011 Permits 7/11/11 17140150.0007/18/2011 Permits 7/18/11 17146150.0007/20/2011 Permits 7/20/11 17782150.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 201107/22/2011Permits 7/22/1117784150.00Total0.00750.00 -5,400.00 CR180-000-000-38500PID Utility FeesBalance Forward-11,500.00CR07/08/2011Permits 7/8/11171389,200.0007/11/2011Permits 7/11/111714011,500.0007/15/2011Permits 7/15/11171422,300.0007/19/2011Permits 7/19/11171484,600.0007/22/2011Permits 7/22/111778425,300.0007/27/2011Permits 7/27/11182062,300.0007/28/2011Permits 7/28/11182082,300.0007/29/2011Permits 7/29/111821011,500.00Total0.00 69,000.00 -80,500.00 CR180-000-000-38520Tap FeesBalance Forward0.00Total0.00 0.00 0.00180-000-000-38540Sewer/Septic Dump FeesBalance Forward0.00Total0.00 0.00 0.00180-000-000-38560Fire Line FeesBalance Forward-525.00CRTotal0.00 0.00 -525.00 CR180-000-000-38600Oversize Meter ReimbursementsBalance Forward-40,389.00CR07/05/2011Permits 7/5/1117136292.0007/08/2011 Permits 7/8/11 171381,168.0007/11/2011 Permits 7/11/11 171401,752.0007/15/2011 Permits 7/15/11 17142292.0007/18/2011 Permits 7/18/11 17146292.0007/19/2011 Permits 7/19/11 17148584.0007/20/2011 Permits 7/20/11 17782292.0007/22/2011 Permits 7/22/11 177843,504.0007/26/2011 Permits 7/26/11 182043,838.6907/27/2011 Permits 7/27/11 18206292.0007/28/2011 Permits 7/28/11 18208292.0007/29/2011 Permits 7/29/11 182101,460.00Total0.00 14,058.69 -54,447.69 CR180-000-000-39200Transfer In - General FundBalance Forward0.00Total0.00 0.00 0.00180-000-000-39290Transfer In - Future Replacement ReservBalance Forward0.00Total0.00 0.00 0.00180-010-000-40100Salaries - RegularBalance Forward97,919.2507/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174306,157.7007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171646,116.16Total12,273.86 0.00 110,193.11180-010-000-40130Salaries - OvertimeBalance Forward10,320.1007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430732.8407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171641,259.32Total1,992.16 0.00 12,312.26180-010-000-40140Salaries - LongevityBalance Forward2,150.00Total0.00 0.00 2,150.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-010-000-40160Salaries - CertificationBalanceForward1,280.0007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164150.00Total150.00 0.00 1,430.00180-010-000-41200RetirementBalance Forward15,845.7607/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430975.6907/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171641,065.60Total2,041.29 0.00 17,887.05180-010-000-41210Medical InsuranceBalance Forward15,897.3007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174301,062.9807/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171641,062.98Total2,125.96 0.00 18,023.26180-010-000-41215Dental InsuranceBalance Forward934.0207/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743063.7207/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716463.72Total127.44 0.00 1,061.46180-010-000-41216Vision InsuranceBalance Forward168.1507/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743011.1407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716411.14Total22.28 0.00 190.43180-010-000-41218Life Insurance & OtherBalance Forward301.92Total0.00 0.00 301.92180-010-000-42220Social Security TaxesBalance Forward6,615.9607/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430401.8007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164441.19Total842.99 0.00 7,458.95180-010-000-42225Medicare TaxesBalance Forward1,547.2807/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743093.9807/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164103.17Total197.15 0.00 1,744.43180-010-000-42250Unemployment TaxesBalance Forward329.40Total0.00 0.00 329.40180-010-000-42260Workman's CompensationBalance Forward5,526.5207/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 1,842.17Total1,842.17 0.00 7,368.69180-010-000-42290Pre-employment Physicals/TestingBalance Forward0.00Total0.00 0.00 0.00180-010-000-42960Employee RelationsBalance Forward226.04Total0.00 0.00 226.04180-010-000-50500EngineeringBalance Forward80.15Total0.00 0.00 80.15180-010-000-52400Lab AnalysisBalance Forward1,908.0007/01/2011 Water analysis/June 16757 Tarrant County Public Health Lab 20960 165.00Total165.00 0.00 2,073.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-010-000-57000Independent LaborBalanceForward0.00Total0.00 0.00 0.00180-010-000-58000Bulk WaterBalance Forward763,458.4707/01/2011 June bulk water 17872 City of Fort Worth 063011 167,542.59Total167,542.59 0.00 931,001.06180-010-000-60300PostageBalance Forward13.35Total0.00 0.00 13.35180-010-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00180-010-000-61000FuelBalance Forward6,131.7507/01/2011 May Gas Log 17794774.2507/01/2011 June Gas Log 177961,088.11Total1,862.36 0.00 7,994.11180-010-000-62100UniformsBalance Forward1,882.87Total0.00 0.00 1,882.87180-010-000-62300ChemicalsBalance Forward3,214.64Total0.00 0.00 3,214.64180-010-000-72100ElectricityBalance Forward92,822.8707/15/2011 Electricity 6/15-7/15 17882 Hudson Energy 2133450 625.0607/15/2011 Electricity 6/15-7/15 17884 Hudson Energy 16468 21,628.49Total22,253.55 0.00 115,076.42180-010-000-73200Communications /Pagers/MobilesBalance Forward1,350.2907/22/2011 Cell phones 18218 Verizon Wireless 6609304057 164.84Total164.84 0.00 1,515.13180-010-000-73350CopiesBalance Forward0.00Total0.00 0.00 0.00180-010-000-73400PrintingBalance Forward0.00Total0.00 0.00 0.00180-010-000-74100Dues & MembershipBalance Forward61.00Total0.00 0.00 61.00180-010-000-74200Travel & per diemBalance Forward684.8707/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743069.8707/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164112.20Total182.07 0.00 866.94180-010-000-74300Schools & TrainingBalance Forward1,508.00Total0.00 0.00 1,508.00180-010-000-74700Safety ProgramBalance Forward7.17Total0.00 0.00 7.17180-010-000-75200Annual Permit FeeBalance Forward6,133.95 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total0.00 0.00 6,133.95180-010-000-78100Meter ExpenseBalance Forward83,182.24Total0.00 0.00 83,182.24180-010-000-78200Small ToolsBalance Forward284.87Total0.00 0.00 284.87180-010-000-78300Safety EquipmentBalance Forward0.00Total0.00 0.00 0.00180-010-000-78500Furniture/Equipment<$5,000Balance Forward0.00Total0.00 0.00 0.00180-010-000-78600HardwareBalance Forward0.00Total0.00 0.00 0.00180-010-000-79150Equipment Rental/LeaseBalance Forward770.00Total0.00 0.00 770.00180-010-000-79400Bad Debt ExpenseBalance Forward2,172.73Total0.00 0.00 2,172.73180-010-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.00 0.00 0.00180-010-000-80250Maintenance and RepairsBalance Forward7,217.1107/14/2011 Concrete/Indian Creek 17930 Lattimore Materials Co 406456 112.50Total112.50 0.00 7,329.61180-010-000-80300Non-routine MaintenanceBalance Forward0.00Total0.00 0.00 0.00180-010-000-81100Property MaintenanceBalance Forward702.85Total0.00 0.00 702.85180-010-000-81200Building MaintenanceBalance Forward0.00Total0.00 0.00 0.00180-010-000-81300Vehicle MaintenanceBalance Forward2,182.50Total0.00 0.00 2,182.50180-010-000-81360Maintenance - Backhoe/Skid LoaderBalance Forward0.00Total0.00 0.00 0.00180-010-000-81500Lawn MaintenanceBalance Forward0.00Total0.00 0.00 0.00180-010-000-81900Maintenance SuppliesBalance Forward8,128.51Total0.00 0.00 8,128.51180-010-000-91000Capital LeaseBalance Forward0.00Total0.00 0.00 0.00180-010-000-93700Capital ExpensesBalance Forward215,853.45 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total0.00 0.00 215,853.45180-010-000-97000Capital RepairsBalance Forward0.00Total0.00 0.00 0.00180-010-000-97100Capital Repairs - Ground StorageBalance Forward97,741.64Total0.00 0.00 97,741.64180-010-000-99100Transfer to General FundBalance Forward0.00Total0.00 0.00 0.00180-010-000-99500Transfer to Future Replacement ReserveBalance Forward0.00Total0.00 0.00 0.00180-020-000-40100Salaries - RegularBalance Forward125,910.8507/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174306,801.6007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171646,801.60Total13,603.20 0.00 139,514.05180-020-000-40130Salaries - OvertimeBalance Forward10,046.2007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430119.6407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171641,276.63Total1,396.27 0.00 11,442.47180-020-000-40140Salaries - LongevityBalance Forward3,482.50Total0.00 0.00 3,482.50180-020-000-40160Salaries - CertificationBalance Forward1,775.0007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164200.00Total200.00 0.00 1,975.00180-020-000-41200RetirementBalance Forward19,951.3107/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430980.0507/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171641,172.20Total2,152.25 0.00 22,103.56180-020-000-41210Medical InsuranceBalance Forward25,068.0907/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174301,392.6607/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171641,392.66Total2,785.32 0.00 27,853.41180-020-000-41215Dental InsuranceBalance Forward1,379.3707/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743077.4907/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716477.49Total154.98 0.00 1,534.35180-020-000-41216Vision InsuranceBalance Forward267.8407/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743014.8807/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716414.88Total29.76 0.00 297.60180-020-000-41218Life Insurance & OtherBalance Forward415.01Total0.00 0.00 415.01180-020-000-42220Social Security TaxesBalance Forward7,639.7707/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430357.58 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 201107/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164441.73Total799.310.00 8,439.08180-020-000-42225Medicare TaxesBalance Forward1,786.7207/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743083.6307/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164103.31Total186.94 0.00 1,973.66180-020-000-42250Unemployment TaxesBalance Forward434.45Total0.00 0.00 434.45180-020-000-42260Workman's CompensationBalance Forward5,986.3607/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 1,995.46Total1,995.46 0.00 7,981.82180-020-000-42960Employee RelationsBalance Forward151.88Total0.00 0.00 151.88180-020-000-50500EngineeringBalance Forward2,800.00Total0.00 0.00 2,800.00180-020-000-52400Lab AnalysisBalance Forward9,978.75Total0.00 0.00 9,978.75180-020-000-57000Independent LaborBalance Forward0.00Total0.00 0.00 0.00180-020-000-60100Office SuppliesBalance Forward7.24Total0.00 0.00 7.24180-020-000-60300PostageBalance Forward0.00Total0.00 0.00 0.00180-020-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00180-020-000-61000FuelBalance Forward1,620.2707/01/2011 May Gas Log 17794295.6307/01/2011 June Gas Log 17796375.25Total670.88 0.00 2,291.15180-020-000-62100UniformsBalance Forward1,449.17Total0.00 0.00 1,449.17180-020-000-62300ChemicalsBalance Forward4,028.28Total0.00 0.00 4,028.28180-020-000-62800Lab SuppliesBalance Forward3,559.06Total0.00 0.00 3,559.06180-020-000-62900Other ConsumablesBalance Forward50.14Total0.00 0.00 50.14180-020-000-72100ElectricityBalance Forward148,595.1007/15/2011 Electricity 6/15-7/15 17880 Hudson Energy 16417 17,153.85 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total17,153.85 0.00 165,748.95180-020-000-72200WaterBalance Forward1,240.0207/31/2011 July Water 18220 Trophy Club MUD - Water Bills 073111 48.82Total48.82 0.00 1,288.84180-020-000-72400Dumpster ServicesBalance Forward11,319.25Total0.00 0.00 11,319.25180-020-000-73100TelephoneBalance Forward1.3607/27/2011 Steve Z. 18212 Bank of America 072711 2.00Total2.00 0.00 3.36180-020-000-73200Communications /Pagers/MobilesBalance Forward2,605.9007/22/2011 Cell phones 18218 Verizon Wireless 6609304057 242.66Total242.66 0.00 2,848.56180-020-000-74200Travel & per diemBalance Forward1,701.8107/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743021.4207/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164187.17Total208.59 0.00 1,910.40180-020-000-74300Schools & TrainingBalance Forward900.00Total0.00 0.00 900.00180-020-000-74700Safety ProgramBalance Forward7.18Total0.00 0.00 7.18180-020-000-75200Annual Permit FeeBalance Forward10,704.14Total0.00 0.00 10,704.14180-020-000-78200Small ToolsBalance Forward481.71Total0.00 0.00 481.71180-020-000-78300Safety EquipmentBalance Forward658.23Total0.00 0.00 658.23180-020-000-78600HardwareBalance Forward35.81Total0.00 0.00 35.81180-020-000-79150Equipment Rental/LeaseBalance Forward0.00Total0.00 0.00 0.00180-020-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.00 0.00 0.00180-020-000-80250Maintenance and RepairsBalance Forward11,439.01Total0.00 0.00 11,439.01180-020-000-81100Property MaintenanceBalance Forward0.00Total0.00 0.00 0.00180-020-000-81200Building MaintenanceBalance Forward0.00Total0.00 0.00 0.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-020-000-81300Vehicle MaintenanceBalanceForward1,049.74Total0.00 0.00 1,049.74180-020-000-81360Maintenance - Backhoe/Skid LoaderBalance Forward1,126.76Total0.00 0.00 1,126.76180-020-000-81500Lawn MaintenanceBalance Forward95.90Total0.00 0.00 95.90180-020-000-81900Maintenance SuppliesBalance Forward761.82Total0.00 0.00 761.82180-020-000-93700Capital ExpensesBalance Forward5,861.0007/24/2011 Membrane Filters loan payment 17342 American National Bank of Texas 88112909 073011 118,689.39Total118,689.39 0.00 124,550.39180-020-000-97000Capital RepairsBalance Forward1,500.00Total0.00 0.00 1,500.00180-021-000-40100Salaries - RegularBalance Forward97,218.2407/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174305,259.3607/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171645,259.36Total10,518.72 0.00 107,736.96180-021-000-40130Salaries - OvertimeBalance Forward13,119.7807/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430414.2407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164282.42Total696.66 0.00 13,816.44180-021-000-40140Salaries - LongevityBalance Forward3,160.00Total0.00 0.00 3,160.00180-021-000-40160Salaries - CertificationBalance Forward1,125.0007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164125.00Total125.00 0.00 1,250.00180-021-000-41200RetirementBalance Forward16,172.6007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430803.3807/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164802.42Total1,605.80 0.00 17,778.40180-021-000-41210Medical InsuranceBalance Forward16,893.1907/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430989.1907/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164989.19Total1,978.38 0.00 18,871.57180-021-000-41215Dental InsuranceBalance Forward1,010.8107/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743059.4407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716459.44Total118.88 0.00 1,129.69180-021-000-41216Vision InsuranceBalance Forward170.7007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174309.9307/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171649.93Total19.86 0.00 190.56 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-021-000-41218Life Insurance & OtherBalanceForward316.23Total0.00 0.00 316.23180-021-000-42220Social Security TaxesBalance Forward6,590.7407/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430310.1907/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164309.78Total619.97 0.00 7,210.71180-021-000-42225Medicare TaxesBalance Forward1,543.8907/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743072.5407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716472.46Total145.00 0.00 1,688.89180-021-000-42250Unemployment TaxesBalance Forward333.23Total0.00 0.00 333.23180-021-000-42260Workman's CompensationBalance Forward3,140.5207/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 1,046.84Total1,046.84 0.00 4,187.36180-021-000-42960Employee RelationsBalance Forward191.59Total0.00 0.00 191.59180-021-000-50500EngineeringBalance Forward80.14Total0.00 0.00 80.14180-021-000-57000Independent LaborBalance Forward0.00Total0.00 0.00 0.00180-021-000-60300PostageBalance Forward0.00Total0.00 0.00 0.00180-021-000-61000FuelBalance Forward5,928.0307/01/2011 May Gas Log 177941,084.9207/01/2011 June Gas Log 177961,052.49Total2,137.41 0.00 8,065.44180-021-000-62100UniformsBalance Forward860.75Total0.00 0.00 860.75180-021-000-62300ChemicalsBalance Forward0.00Total0.00 0.00 0.00180-021-000-72100ElectricityBalance Forward13,556.8907/15/2011 Electricity 6/15-7/15 17880 Hudson Energy 16417 404.47Total404.47 0.00 13,961.36180-021-000-72200WaterBalance Forward0.00Total0.00 0.00 0.00180-021-000-73100TelephoneBalance Forward20.5807/27/2011 Steve Z. 18212 Bank of America 072711 1.05Total1.05 0.00 21.63180-021-000-73200Communications /Pagers/MobilesBalance Forward2,129.28 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 201107/22/2011Cell phones18218Verizon Wireless6609304057203.63Total203.630.00 2,332.91180-021-000-74100Dues & MembershipBalance Forward0.0007/19/2011 Commercial license/Valadez (GapVax) 17366 Texas Dept of Public Safety 071911 61.00Total61.00 0.00 61.00180-021-000-74200Travel & per diemBalance Forward551.2607/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743032.64Total32.64 0.00 583.90180-021-000-74300Schools & TrainingBalance Forward55.00Total0.00 0.00 55.00180-021-000-74700Safety ProgramBalance Forward7.18Total0.00 0.00 7.18180-021-000-78200Small ToolsBalance Forward220.58Total0.00 0.00 220.58180-021-000-78300Safety EquipmentBalance Forward62.84Total0.00 0.00 62.84180-021-000-78600HardwareBalance Forward0.00Total0.00 0.00 0.00180-021-000-79150Equipment Rental/LeaseBalance Forward0.00Total0.00 0.00 0.00180-021-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.00 0.00 0.00180-021-000-80250Maintenance and RepairsBalance Forward4,158.7207/20/2011 12V Faston 17886 Interstate All Battery Center, Inc 1712702000653 16.50Total16.50 0.00 4,175.22180-021-000-81100Property MaintenanceBalance Forward0.00Total0.00 0.00 0.00180-021-000-81200Building MaintenanceBalance Forward0.00Total0.00 0.00 0.00180-021-000-81300Vehicle MaintenanceBalance Forward641.3707/26/2011 Vehicle Maint Contract/GapVax 17928 Texas Underground, Inc 0079091-IN 5,200.00Total5,200.00 0.00 5,841.37180-021-000-81900Maintenance SuppliesBalance Forward2,050.63Total0.00 0.00 2,050.63180-021-000-93700Capital ExpensesBalance Forward0.0007/26/2011 GAPVAX Loan pmt deposited in error 1780610,979.2507/26/2011 GAPVAX loan payment. Ck 30686 deposited 17870 First Financial Bank 91500007041 0811B10,979.25Total10,979.25 10,979.25 0.00180-021-000-97000Capital RepairsBalance Forward0.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total0.00 0.00 0.00180-130-000-40100Salaries - RegularBalance Forward4,200.0007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430900.0007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164300.00Total1,200.00 0.00 5,400.00180-130-000-42220Social Security TaxesBalance Forward260.4007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743055.8007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716418.60Total74.40 0.00 334.80180-130-000-42225Medicare TaxesBalance Forward60.9007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743013.0507/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171644.35Total17.40 0.00 78.30180-130-000-42250Unemployment TaxesBalance Forward57.0007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174307.2007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171642.40Total9.60 0.00 66.60180-130-000-42260Workman's CompensationBalance Forward85.4107/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 28.47Total28.47 0.00 113.88180-130-000-50100Professional Outside ServicesBalance Forward0.00Total0.00 0.00 0.00180-130-000-60100Office SuppliesBalance Forward0.00Total0.00 0.00 0.00180-130-000-60300PostageBalance Forward-1.86CRTotal0.00 0.00 -1.86 CR180-130-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00180-130-000-73300AdvertisingBalance Forward0.00Total0.00 0.00 0.00180-130-000-73400PrintingBalance Forward0.00Total0.00 0.00 0.00180-130-000-74100Dues & MembershipBalance Forward79.00Total0.00 0.00 79.00180-130-000-74200Travel & per diemBalance Forward759.0207/01/2011 Reimburse expenses 16743 James C. Thomas 032811 128.0407/01/2011 AWBD expenses 16745 James C. Thomas 061011 AWBD 81.20Total209.24 0.00 968.26180-130-000-74300Schools & TrainingBalance Forward2,140.00Total0.00 0.00 2,140.00180-130-000-74600MeetingsBalance Forward289.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total0.00 0.00 289.00180-130-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.00 0.00 0.00180-130-000-87110Water Conservation Program/Public InforBalance Forward2,334.72Total0.00 0.00 2,334.72180-140-000-40100Salaries - RegularBalance Forward147,725.0007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174308,184.2707/22/2011 Payroll Cycle 15 - M MOORE FINAL CHECK 174326,356.3407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171648,093.45Total22,634.06 0.00 170,359.06180-140-000-40130Salaries - OvertimeBalance Forward221.4807/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743016.5007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716424.08Total40.58 0.00 262.06180-140-000-40140Salaries - LongevityBalance Forward2,755.00Total0.00 0.00 2,755.00180-140-000-41200RetirementBalance Forward20,837.3807/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430984.6307/22/2011 Payroll Cycle 15 - M MOORE FINAL CHECK 17432900.0607/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171641,149.47Total3,034.16 0.00 23,871.54180-140-000-41210Medical InsuranceBalance Forward13,115.1707/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430433.0407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164433.04Total866.08 0.00 13,981.25180-140-000-41215Dental InsuranceBalance Forward744.6507/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743025.8207/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716425.82Total51.64 0.00 796.29180-140-000-41216Vision InsuranceBalance Forward138.0007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174304.9807/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171644.98Total9.96 0.00 147.96180-140-000-41218Life Insurance & OtherBalance Forward373.34Total0.00 0.00 373.34180-140-000-42220Social Security TaxesBalance Forward9,333.7707/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430506.5007/22/2011 Payroll Cycle 15 - M MOORE FINAL CHECK 17432394.1007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164487.53Total1,388.13 0.00 10,721.90180-140-000-42225Medicare TaxesBalance Forward2,206.5907/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430118.4607/22/2011 Payroll Cycle 15 - M MOORE FINAL CHECK 1743292.1707/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164114.01 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total324.64 0.00 2,531.23180-140-000-42250Unemployment TaxesBalance Forward428.5807/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174309.9807/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171649.31Total19.29 0.00 447.87180-140-000-42260Workman's CompensationBalance Forward557.3407/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 185.78Total185.78 0.00 743.12180-140-000-42290Pre-employment Physicals/TestingBalance Forward52.4507/01/2011 Pre emp testing/Schultz 16755 CareNow 863314 17.5007/01/2011 Pre emp testing/Schultz 16761 First Check Applicant Screening 2089 4.97Total22.47 0.00 74.92180-140-000-42960Employee RelationsBalance Forward906.17Total0.00 0.00 906.17180-140-000-50100Professional Outside ServicesBalance Forward228,075.63Total0.00 0.00 228,075.63180-140-000-52100ElectionsBalance Forward1,952.65Total0.00 0.00 1,952.65180-140-000-54200Records ManagementBalance Forward120.00Total0.00 0.00 120.00180-140-000-57000Independent LaborBalance Forward322.5007/19/2011 Recording Joint Town/MUD meeting 17344 Miguel Cruz 071911 35.6207/20/2011 Record MUD meeting 17346 Miguel Cruz 072011 48.75Total84.37 0.00 406.87180-140-000-60100Office SuppliesBalance Forward1,232.5507/27/2011 Pastor 18212 Bank of America 072711 20.1107/29/2011 Office Supplies 18224 Office Depot 573106286001 83.9007/29/2011 Office Supplies 18228 Office Depot 573108337001 9.63Total113.64 0.00 1,346.19180-140-000-60300PostageBalance Forward1,336.1507/08/2011 Postage for UB mailing 16159 U.S. Postal Service 070811 588.9007/21/2011 Letter to TCEQ 17874 Federal Express Corp 7-568-74256 29.04Total617.94 0.00 1,954.09180-140-000-60400Publications/Books/SubscriptionsBalance Forward215.40Total0.00 0.00 215.40180-140-000-73100TelephoneBalance Forward180.2507/27/2011 Steve Z. 18212 Bank of America 072711 16.48Total16.48 0.00 196.73180-140-000-73200Communications /Pagers/MobilesBalance Forward2,169.1007/22/2011 Cell phones 18218 Verizon Wireless 6609304057 157.63Total157.63 0.00 2,326.73180-140-000-73300AdvertisingBalance Forward0.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total0.00 0.00 0.00180-140-000-73400PrintingBalance Forward3,170.00Total0.00 0.00 3,170.00180-140-000-73600Service Charges & FeesBalance Forward32.50Total0.00 0.00 32.50180-140-000-74100Dues & MembershipBalance Forward1,714.50Total0.00 0.00 1,714.50180-140-000-74200Travel & per diemBalance Forward1,201.01Total0.00 0.00 1,201.01180-140-000-74300Schools & TrainingBalance Forward1,640.93Total0.00 0.00 1,640.93180-140-000-74600MeetingsBalance Forward116.00Total0.00 0.00 116.00180-140-000-76700July 4 CelebrationBalance Forward0.00Total0.00 0.00 0.00180-140-000-78500Furniture/Equipment<$5,000Balance Forward675.7307/01/2011 Furniture for remodel 17892 National Business Furniture, LLC CV748845 3,405.57Total3,405.57 0.00 4,081.30180-140-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.00 0.00 0.00180-611-000-40100Salaries - RegularBalance Forward49,472.3607/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174302,724.8007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171642,724.80Total5,449.60 0.00 54,921.96180-611-000-40130Salaries - OvertimeBalance Forward10,994.9407/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430341.2807/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164706.57Total1,047.85 0.00 12,042.79180-611-000-40140Salaries - LongevityBalance Forward1,710.00Total0.00 0.00 1,710.00180-611-000-41200RetirementBalance Forward8,885.7007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430434.1507/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164485.89Total920.04 0.00 9,805.74180-611-000-41210Medical InsuranceBalance Forward6,249.1907/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430357.6207/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164357.62Total715.24 0.00 6,964.43180-611-000-41215Dental InsuranceBalance Forward366.6607/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743021.5307/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716421.53 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total43.06 0.00 409.72180-611-000-41216Vision InsuranceBalance Forward44.8207/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174302.4907/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171642.49Total4.98 0.00 49.80180-611-000-41218Life Insurance & OtherBalance Forward140.01Total0.00 0.00 140.01180-611-000-42220Social Security TaxesBalance Forward3,463.9907/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430159.8607/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164182.52Total342.38 0.00 3,806.37180-611-000-42225Medicare TaxesBalance Forward810.1307/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743037.3907/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716442.68Total80.07 0.00 890.20180-611-000-42250Unemployment TaxesBalance Forward129.59Total0.00 0.00 129.59180-611-000-42260Workman's CompensationBalance Forward195.0307/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 65.01Total65.01 0.00 260.04180-611-000-42290Pre-employment Physicals/TestingBalance Forward0.00Total0.00 0.00 0.00180-611-000-50100Professional Outside ServicesBalance Forward2,437.50Total0.00 0.00 2,437.50180-611-000-60100Office SuppliesBalance Forward481.4907/29/2011 Office Supplies 18224 Office Depot 573106286001 14.16Total14.16 0.00 495.65180-611-000-60300PostageBalance Forward306.75Total0.00 0.00 306.75180-611-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00180-611-000-73100TelephoneBalance Forward11.5907/27/2011 Steve Z. 18212 Bank of America 072711 1.59Total1.59 0.00 13.18180-611-000-73200Communications /Pagers/MobilesBalance Forward508.1707/22/2011 Cell phones 18218 Verizon Wireless 6609304057 52.81Total52.81 0.00 560.98180-611-000-73300AdvertisingBalance Forward207.40Total0.00 0.00 207.40180-611-000-73400PrintingBalance Forward0.00Total0.00 0.00 0.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-611-000-73600Service Charges & FeesBalanceForward0.00Total0.00 0.00 0.00180-611-000-74100Dues & MembershipBalance Forward22.00Total0.00 0.00 22.00180-611-000-74200Travel & per diemBalance Forward145.13Total0.00 0.00 145.13180-611-000-74300Schools & TrainingBalance Forward309.00Total0.00 0.00 309.00180-611-000-74600MeetingsBalance Forward0.00Total0.00 0.00 0.00180-611-000-78500Furniture/Equipment<$5,000Balance Forward0.00Total0.00 0.00 0.00180-611-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.00 0.00 0.00180-620-000-40100Salaries - RegularBalance Forward64,615.5007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174302,505.8607/22/2011 Payroll Cycle 15 - D MCMAHON FINAL CHECK 17434881.7607/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171644,673.61Total8,061.23 0.00 72,676.73180-620-000-40130Salaries - OvertimeBalance Forward611.4407/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174303.7507/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716491.24Total94.99 0.00 706.43180-620-000-40140Salaries - LongevityBalance Forward405.00Total0.00 0.00 405.00180-620-000-41200RetirementBalance Forward8,787.9607/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430355.3607/22/2011 Payroll Cycle 15 - D MCMAHON FINAL CHECK 17434124.8607/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164674.70Total1,154.92 0.00 9,942.88180-620-000-41210Medical InsuranceBalance Forward12,380.1407/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430575.2407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164824.20Total1,399.44 0.00 13,779.58180-620-000-41215Dental InsuranceBalance Forward810.7007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743039.5807/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716452.49Total92.07 0.00 902.77180-620-000-41216Vision InsuranceBalance Forward143.4007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174306.7707/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171649.26Total16.03 0.00 159.43 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-620-000-41218Life Insurance & OtherBalanceForward249.23Total0.00 0.00 249.23180-620-000-42220Social Security TaxesBalance Forward3,913.8607/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430136.7807/22/2011 Payroll Cycle 15 - D MCMAHON FINAL CHECK 1743454.6707/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164263.13Total454.58 0.00 4,368.44180-620-000-42225Medicare TaxesBalance Forward915.3407/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743031.9807/22/2011 Payroll Cycle 15 - D MCMAHON FINAL CHECK 1743412.7907/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716461.54Total106.31 0.00 1,021.65180-620-000-42250Unemployment TaxesBalance Forward384.4807/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171649.12Total9.12 0.00 393.60180-620-000-42260Workman's CompensationBalance Forward292.5607/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 97.52Total97.52 0.00 390.08180-620-000-42290Pre-employment Physicals/TestingBalance Forward0.0007/01/2011 Pre emp testing/Schultz 16755 CareNow 863314 17.5007/01/2011 Pre emp testing/Schultz 16761 First Check Applicant Screening 2089 4.98Total22.48 0.00 22.48180-620-000-56200Utility Billing ContractBalance Forward7,786.8407/31/2011 July water billing 17910 CSG Systems, Inc. 73825 1,054.04Total1,054.04 0.00 8,840.88180-620-000-57000Independent LaborBalance Forward0.00Total0.00 0.00 0.00180-620-000-60100Office SuppliesBalance Forward184.0907/07/2011 Colored Copy Paper for Confidentiality m 18222 Office Depot 1361478690 28.6207/27/2011 Steve Z. 18212 Bank of America 072711 49.9807/29/2011 Office Supplies 18224 Office Depot 573106286001 132.4707/29/2011 Office Supplies 18226 Office Depot 573108336001 10.83Total221.90 0.00 405.99180-620-000-60300PostageBalance Forward11,788.8007/31/2011 July water billing 17910 CSG Systems, Inc. 73825 1,369.95Total1,369.95 0.00 13,158.75180-620-000-73100TelephoneBalance Forward95.3507/27/2011 Steve Z. 18212 Bank of America 072711 2.93Total2.93 0.00 98.28180-620-000-73200Communications /Pagers/MobilesBalance Forward373.0307/22/2011 Cell phones 18218 Verizon Wireless 6609304057 37.33Total37.33 0.00 410.36180-620-000-73400PrintingBalance Forward2,152.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total0.00 0.00 2,152.00180-620-000-73600Service Charges & FeesBalance Forward16,180.3207/06/2011 World Pay Credit card fees/June 177861,656.3507/06/2011 World Pay Credit card fees/June 17786309.0907/06/2011 World Pay Credit card fees/June 177869.99Total1,975.43 0.00 18,155.75180-620-000-74100Dues & MembershipBalance Forward0.00Total0.00 0.00 0.00180-620-000-74200Travel & per diemBalance Forward30.09Total0.00 0.00 30.09180-620-000-74300Schools & TrainingBalance Forward0.0007/21/2011 Excel Book purchased at class 17898 Nicole D'Andria 072111 46.44Total46.44 0.00 46.44180-620-000-75600TCEQ Annual Assessment FeeBalance Forward19,248.17Total0.00 0.00 19,248.17180-620-000-79999Miscellaneous ExpenseBalance Forward1.84Total0.00 0.00 1.84180-620-000-99100Transfer to General FundBalance Forward0.00Total0.00 0.00 0.00180-630-000-42290Pre-employment Physicals/TestingBalance Forward152.41Total0.00 0.00 152.41180-630-000-42960Employee RelationsBalance Forward474.9707/27/2011 Pastor 18212 Bank of America 072711 21.9407/27/2011 Steve Z. 18212 Bank of America 072711 21.94Total43.88 0.00 518.85180-630-000-43240Tuition ReimbursementBalance Forward74.65Total0.00 0.00 74.65180-630-000-60100Office SuppliesBalance Forward0.00Total0.00 0.00 0.00180-630-000-60300PostageBalance Forward0.00Total0.00 0.00 0.00180-630-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00180-630-000-73100TelephoneBalance Forward0.00Total0.00 0.00 0.00180-630-000-73200Communications /Pagers/MobilesBalance Forward0.00Total0.00 0.00 0.00180-630-000-73400PrintingBalance Forward0.00Total0.00 0.00 0.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-630-000-74100Dues & MembershipBalanceForward0.00Total0.00 0.00 0.00180-630-000-74200Travel & per diemBalance Forward0.00Total0.00 0.00 0.00180-630-000-74300Schools & TrainingBalance Forward0.00Total0.00 0.00 0.00180-630-000-74600MeetingsBalance Forward0.00Total0.00 0.00 0.00180-630-000-99100Transfer to General FundBalance Forward0.00Total0.00 0.00 0.00180-640-000-50700SecurityBalance Forward42.51Total0.00 0.00 42.51180-640-000-55000Software & SupportBalance Forward39,539.1707/01/2011 Internet 16747 Bandwidth.com, Inc. IN07152011-200714329.6907/01/2011 Annual support for Remit Plus 17340 Jack Henry & Assoc 0912418 1,750.0007/18/2011 STW Support for Innoprise conversion 17356 STW Inc 071811 328.7507/26/2011 Annual connect software support 17932 Badger Meter, Inc 92644601 989.0407/27/2011 Pastor 18212 Bank of America 072711 25.0007/27/2011 Pastor 18212 Bank of America 072711 77.5207/27/2011 Steve Z. 18212 Bank of America 072711 293.9107/27/2011 Steve Z. 18212 Bank of America 072711 49.9907/27/2011 Steve Z. 18212 Bank of America 072711 53.38Total3,897.28 0.00 43,436.45180-640-000-57000Independent LaborBalance Forward2,348.75Total0.00 0.00 2,348.75180-640-000-60100Office SuppliesBalance Forward244.61Total0.00 0.00 244.61180-640-000-60200Printer SuppliesBalance Forward4,788.4607/12/2011 Printer supplies 17362 SHI Governmental Solutions GB00038296 306.5007/12/2011 Printer supplies 17364 SHI Governmental Solutions GB00038309 141.50Total448.00 0.00 5,236.46180-640-000-73100TelephoneBalance Forward7,975.7707/27/2011 Steve Z. 18212 Bank of America 072711 451.8807/27/2011 Steve Z. 18212 Bank of America 072711 351.48Total803.36 0.00 8,779.13180-640-000-73200Communications /Pagers/MobilesBalance Forward0.00Total0.00 0.00 0.00180-640-000-74200Travel & per diemBalance Forward16.18Total0.00 0.00 16.18180-640-000-75900Prompt Payment InterestBalance Forward14.53Total0.00 0.00 14.53 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-640-000-78600HardwareBalanceForward36,641.2707/08/2011 Video Converters 17358 SHI Governmental Solutions GB00038175 11.0007/11/2011 Video Converters 17360 SHI Governmental Solutions GB00038221 12.3607/22/2011 Printer for MUD Barn 17902 SHI Governmental Solutions GB00039016 390.00Total413.36 0.00 37,054.63180-640-000-79100Copier Rental/LeaseBalance Forward2,186.3207/01/2011 July Adm Copier lease 16749 Kyocera Mita America, Inc 110646593 146.7607/01/2011 July PW Copier lease 16751 Kyocera Mita America, Inc 110646602 115.6207/01/2011 July PW Fax lease 16753 Kyocera Mita America, Inc 110646603 10.91Total273.29 0.00 2,459.61180-640-000-99100Transfer to General FundBalance Forward0.00Total0.00 0.00 0.00180-640-000-99500Transfer to Future Replacement ReserveBalance Forward0.00Total0.00 0.00 0.00180-710-000-52400Lab AnalysisBalance Forward1,168.75Total0.00 0.00 1,168.75180-710-000-62520Vending Machine SuppliesBalance Forward429.28Total0.00 0.00 429.28180-710-000-72100ElectricityBalance Forward9,649.4807/27/2011 Electricity 6/14-7/15 17908 Direct Energy Business Svcs 1159824 1,315.49Total1,315.49 0.00 10,964.97180-710-000-72200WaterBalance Forward479.2907/31/2011 July Water 18220 Trophy Club MUD - Water Bills 073111 81.12Total81.12 0.00 560.41180-710-000-75000InsuranceBalance Forward23,475.81Total0.00 0.00 23,475.81180-710-000-79200Building Rental/LeaseBalance Forward9,886.5907/01/2011 Public Services Building rent/July 15946 Town of Trophy Club 070111 PS Rent 1,098.51Total1,098.51 0.00 10,985.10180-710-000-81200Building MaintenanceBalance Forward13,334.9407/01/2011 AC repair 17900 North Texas Heating & Air, Inc. 040631 64.00Total64.00 0.00 13,398.94180-710-000-81600Cleaning ServicesBalance Forward6,303.9507/01/2011 July Janitorial service 16763 ABM Janitorial Services, Inc 2671042 559.50Total559.50 0.00 6,863.45180-710-000-81900Maintenance SuppliesBalance Forward1,464.7807/01/2011 June purchases 16741 Costco Wholesale 062611 65.68Total65.68 0.00 1,530.46180-810-000-50200AuditingBalance Forward27,500.00Total0.00 0.00 27,500.00180-810-000-50300LegalBalance Forward27,933.31Total0.00 0.00 27,933.31 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-810-000-51100AppraisalBalanceForward12,332.4107/29/2011 Tarrant Appraisal/2010 Budget Refund 1780862.73Total0.00 62.73 12,269.68180-810-000-51150Tax AdministrationBalance Forward2,640.3207/13/2011 Tax collection notices 17352 Denton County Tax Office 071311 56.24Total56.24 0.00 2,696.56GRAND TOTAL492,384.97 700,580.22 -460,117.44 380-010-000-93700 Capital Expenses 0.00 0.00 0.00 112,162.31 (112,162.31) # 380-020-000-93700 Capital Expenses 0.00 0.00 152,000.00 210,220.60 (210,220.60) # Total Capital Projects 0.00 0.00 152,000.00 322,382.91 (322,382.91) page 1 Budget to Actual - Capital Pro Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective DateDescriptionJournal #Vendor NameVendor Invoice #DebitCreditBalance380-010-000-93700Capital ExpensesBalanceForward112,162.31Total0.000.00112,162.31380-020-000-93700Capital ExpensesBalanceForward58,220.6007/01/2011Retainage Fryer App #4173367,600.0007/01/2011Screen Rake App #417354Fryer Construction Company App #4144,400.00Total152,000.000.00 210,220.60GRAND TOTAL152,000.000.00 322,382.91Trophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011 Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 7/31/2011 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 477,071 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 25,568 ACCOUNTS RECEIVABLE - PID EMERGENCY SERVICES ASSESSMENTS 4,864 OTHER RECEIVABLES 18,855 TOTAL ASSETS 526,359$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 30,433$ ACCOUNTS PAYABLE 29,773 TOTAL LIABILITIES 60,205 FUND BALANCE UNDESIGNATED FUND BALANCE 466,154 TOTAL LIABILITIES AND FUND BALANCE 526,359$ July 31, 2011 10/12 Months (84% of Fiscal Year) Account/DescriptionYTD BudgetTotal BudgetMTD RevYTD RevTotal VarianceRemaining %[FUND] 190 : Fire Department Operations190-000-000-30050 : Emergency Service Assessment111,648.00111,648.004,510.70120,126.77-8,478.77-7.59190-000-000-30060 : Emergency Services Assessment - P&I0.000.00704.631,729.10-1,729.100.00190-000-000-30100 : Property Taxes1,072,786.001,072,786.002,874.881,071,346.561,439.440.13190-000-000-30125 : Property Taxes/Delinquent0.000.00146.998,750.49-8,750.490.00190-000-000-30150 : Property Taxes/Penalty & Interest7,500.007,500.00308.394,917.482,582.5234.43190-000-000-32014 : Fire Permits/Sprinkler0.000.00400.001,600.00-1,600.000.00190-000-000-33050 : Fire Inspections0.000.0075.00225.00-225.000.00190-000-000-33420 : Denton/Tarrant County - Fire13,750.0013,750.000.0010,000.003,750.0027.27190-000-000-35050 : Interest Income0.000.000.0075.00-75.000.00190-000-000-36700 : Miscellaneous Revenue2,500.002,500.00725.001,775.00725.0029.00[FUND] SubTotal : 190 : Fire Department Operations1,208,184.001,208,184.009,745.591,220,545.40-12,361.40-1.02 Grand Total : 1,208,184.001,208,184.009,745.591,220,545.40-12,361.40-1.02Run Date: 08/11/2011User: rgonzalesTrophy Club Municipal Utility Dist #1Budget Revenue ReportTo Date: 07/31/2011 190-045-000-40100 Salaries - Regular 390,466.00 390,466.00 31,327.81 312,161.11 78,304.89 79.9 190-045-000-40130 Salaries - Overtime 40,298.00 40,298.00 3,293.39 42,155.85 (1,857.85) 104.6 190-045-000-40140 Salaries - Longevity 2,946.00 2,946.00 0.00 2,986.99 (40.99) 101.4 190-045-000-40160 Salaries - Certification 5,401.00 5,401.00 494.70 6,582.94 (1,181.94) 121.9 190-045-000-40180 Salaries - Holiday Pay 11,604.00 11,604.00 0.00 12,154.86 (550.86) 104.7 190-045-000-41200 Retirement 63,016.00 63,016.00 4,518.44 51,262.97 11,753.03 81.3 190-045-000-41210 Medical Insurance 54,809.00 54,809.00 3,919.66 40,060.34 14,748.66 73.1 190-045-000-41215 Dental Insurance 2,819.00 2,819.00 244.31 2,446.63 372.37 86.8 190-045-000-41216 Vision Insurance 505.00 505.00 37.77 393.61 111.39 77.9 190-045-000-41218 Life Insurance & Other 2,491.00 2,491.00 0.00 843.63 1,647.37 33.9 190-045-000-42220 Social Security Taxes 26,252.00 26,252.00 1,978.84 21,734.36 4,517.64 82.8 190-045-000-42225 Medicare Taxes 6,140.00 6,140.00 462.80 5,086.09 1,053.91 82.8 190-045-000-42250 Unemployment Taxes 1,387.00 1,387.00 13.52 934.49 452.51 67.4 190-045-000-42260 Workman's Compensation 13,134.00 13,134.00 3,116.32 12,465.28 668.72 94.9 190-045-000-42290 Pre-employment Physicals/Testing 675.00 675.00 0.00 195.50 479.50 29.0 190-045-000-50100 Professional Outside Services 40,000.00 40,000.00 0.00 0.00 40,000.00 # 190-045-000-54100 Physicals/Testing 1,880.00 1,880.00 0.00 0.00 1,880.00 # 190-045-000-60100 Office Supplies 319.00 319.00 0.00 215.63 103.37 67.6 190-045-000-60300 Postage 95.00 95.00 0.00 92.26 2.74 97.1 190-045-000-60400 Publications/Books/Subscriptions 382.00 382.00 0.00 0.00 382.00 # 190-045-000-61000 Fuel 16,585.00 16,585.00 1,584.10 8,595.62 7,989.38 51.8 190-045-000-62100 Uniforms 4,357.00 4,357.00 0.00 3,530.32 826.68 81.0 190-045-000-62150 Protective Clothing 7,600.00 7,600.00 0.00 756.18 6,843.82 9.9 190-045-000-62300 Chemicals 1,545.00 1,545.00 0.00 305.00 1,240.00 19.7 190-045-000-72100 Electricity 17,400.00 17,400.00 1,331.22 9,176.47 8,223.53 52.7 190-045-000-72200 Water 3,193.00 3,193.00 43.20 444.61 2,748.39 13.9 190-045-000-73100 Telephone 103.00 103.00 9.95 124.20 (21.20) 120.6 190-045-000-73200 Communications /Pagers/Mobiles 1,874.00 1,874.00 197.29 2,211.93 (337.93) 118.0 190-045-000-73300 Advertising 153.00 153.00 0.00 0.00 153.00 # 190-045-000-73400 Printing 103.00 103.00 0.00 0.00 103.00 # 190-045-000-74100 Dues & Membership 8,358.00 8,358.00 0.00 6,466.60 1,891.40 77.4 190-045-000-74200 Travel & per diem 7,107.00 7,107.00 0.00 3,531.41 3,575.59 49.7 190-045-000-74300 Schools & Training 6,615.00 6,615.00 0.00 3,316.95 3,298.05 50.1 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 190-045-000-78200 Small Tools 8,127.00 8,127.00 0.00 4,564.53 3,562.47 56.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 0.00 205.76 1,007.24 17.0 190-045-000-80250 Maintenance and Repairs 5,562.00 5,562.00 1,341.50 3,293.78 2,268.22 59.2 190-045-000-81200 Building Maintenance 11,000.00 11,000.00 160.99 6,965.63 4,034.37 63.3 190-045-000-81300 Vehicle Maintenance 13,500.00 13,500.00 0.00 8,458.68 5,041.32 62.7 190-045-000-81350 Equipment Maintenance 3,675.00 3,675.00 0.00 521.71 3,153.29 14.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 0.00 1,972.50 449.50 81.4 190-045-000-81900 Maintenance Supplies 2,652.00 2,652.00 0.00 925.60 1,726.40 34.9 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,190.00 2,072.85 2,007.15 50.8 190-045-000-90100 Radios 2,500.00 2,500.00 0.00 807.50 1,692.50 32.3 190-045-000-90200 Fire Engine 681 Payment 73,388.00 73,388.00 0.00 5,693.95 67,694.05 7.8 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 0.00 2,245.00 # page 1 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Total Fire Department 1,208,184.00 1,208,184.00 55,265.81 909,593.59 298,590.41 page 2 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance190-000-000-30100Property TaxesBalance Forward-1,068,471.68CR07/06/2011 MUD 1 AV Taxes16689459.6707/08/2011 MUD 1 AV Taxes16715383.1007/11/2011 MUD 1 AV Taxes16733356.2307/11/2011 MUD 1 AV Taxes16691383.1007/11/2011 MUD 1 AV Taxes16713383.1007/12/2011 MUD 1 AV Taxes16735370.1307/13/2011 MUD 1 AV Taxes16801166.7407/15/2011 MUD 1 AV Taxes16968104.5607/18/2011 MUD 1 AV Taxes1713240.3907/19/2011 MUD 1 AV Taxes1746089.4407/22/2011 MUD 1 AV Taxes1777039.7407/25/2011 MUD 1 AV Taxes17768214.1007/26/2011 MUD 1 AV Taxes17772189.2007/27/2011 MUD 1 AV Taxes17774136.1607/28/2011 MUD 1 AV Taxes17824278.1307/29/2011 MUD 1 AV Taxes1782647.29Total383.10 3,257.98 -1,071,346.56 CR190-000-000-30125Property Taxes/DelinquentBalance Forward-8,603.50CR07/15/2011 Advalorem Taxes169686.9607/21/2011 Advalorem Taxes174621.0907/26/2011 Advalorem Taxes17772138.94Total0.00146.99 -8,750.49 CR190-000-000-30150Property Taxes/Penalty & InterestBalance Forward-4,609.09CR07/06/2011 Advalorem Taxes1668968.9407/08/2011 Advalorem Taxes1671557.4607/11/2011 Advalorem Taxes167331.0407/11/2011 Advalorem Taxes1669157.4607/11/2011 Advalorem Taxes1671357.4607/12/2011 Advalorem Taxes1673547.3507/13/2011 Advalorem Taxes168010.5907/15/2011 Advalorem Taxes169687.1707/19/2011 Advalorem Taxes1746016.1107/21/2011 Advalorem Taxes174620.4607/25/2011 Advalorem Taxes177685.1907/26/2011 Advalorem Taxes177727.5807/28/2011 Advalorem Taxes1782496.50Total57.46365.85 -4,917.48 CR190-000-000-32014Fire Permits/SprinklerBalance Forward-1,200.00CR07/22/2011 Permits 7/22/1117784400.00Total0.00400.00 -1,600.00 CR190-000-000-33050Fire InspectionsBalance Forward-150.00CR07/22/2011 Permits 7/22/111778475.00Total0.0075.00-225.00 CR190-000-000-33420Denton/Tarrant County - FireBalance Forward-10,000.00CRTotal0.00 0.00 -10,000.00 CR190-000-000-35050Interest IncomeBalance Forward-75.00CRTotal0.00 0.00 -75.00 CRTrophy Club Municipal Utility Dist #1 Fire DepartmentG/L Transaction Detail Report July 31, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1 Fire DepartmentG/L Transaction Detail Report July 31, 2011190-000-000-35370DonationsBalanceForward0.00Total0.00 0.00 0.00190-000-000-36700Miscellaneous RevenueBalance Forward-1,050.00CR07/20/2011 Permits 7/20/1117782100.0007/22/2011 Permits 7/22/1117784625.00Total0.00725.00 -1,775.00 CR190-000-000-39200Transfer In - General FundBalance Forward0.00Total0.00 0.00 0.00190-045-000-40100Salaries - RegularBalance Forward280,833.3007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743015,577.7407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716415,750.07Total31,327.81 0.00 312,161.11190-045-000-40130Salaries - OvertimeBalance Forward38,862.4607/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174303,293.39Total3,293.39 0.00 42,155.85190-045-000-40140Salaries - LongevityBalance Forward2,986.99Total0.00 0.00 2,986.99190-045-000-40160Salaries - CertificationBalance Forward6,088.2407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164494.70Total494.70 0.00 6,582.94190-045-000-40180Salaries - Holiday PayBalance Forward12,154.86Total0.00 0.00 12,154.86190-045-000-41200RetirementBalance Forward46,744.5307/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174302,457.3307/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171642,061.11Total4,518.44 0.00 51,262.97190-045-000-41210Medical InsuranceBalance Forward36,140.6807/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174301,949.7007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171641,969.96Total3,919.66 0.00 40,060.34190-045-000-41215Dental InsuranceBalance Forward2,202.3207/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430121.4007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164122.91Total244.31 0.00 2,446.63190-045-000-41216Vision InsuranceBalance Forward355.8407/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743018.7807/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716418.99Total37.77 0.00 393.61190-045-000-41218Life Insurance & OtherBalance Forward843.63Total0.00 0.00 843.63 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1 Fire DepartmentG/L Transaction Detail Report July 31, 2011190-045-000-42220Social Security TaxesBalanceForward19,755.5207/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174301,071.3407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164907.50Total1,978.84 0.00 21,734.36190-045-000-42225Medicare TaxesBalance Forward4,623.2907/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430250.5607/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164212.24Total462.80 0.00 5,086.09190-045-000-42250Unemployment TaxesBalance Forward920.9707/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174302.6507/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716410.87Total13.52 0.00 934.49190-045-000-42260Workman's CompensationBalance Forward9,348.9607/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 3,116.32Total3,116.32 0.00 12,465.28190-045-000-42290Pre-employment Physicals/TestingBalance Forward195.50Total0.00 0.00 195.50190-045-000-50100Professional Outside ServicesBalance Forward0.00Total0.00 0.00 0.00190-045-000-54100Physicals/TestingBalance Forward0.00Total0.00 0.00 0.00190-045-000-60100Office SuppliesBalance Forward215.63Total0.00 0.00 215.63190-045-000-60300PostageBalance Forward92.26Total0.00 0.00 92.26190-045-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00190-045-000-61000FuelBalance Forward7,011.5207/01/2011 May Gas Log 17794706.1607/01/2011 June Gas Log 17796877.94Total1,584.10 0.00 8,595.62190-045-000-62100UniformsBalance Forward3,530.32Total0.00 0.00 3,530.32190-045-000-62150Protective ClothingBalance Forward756.18Total0.00 0.00 756.18190-045-000-62300ChemicalsBalance Forward305.00Total0.00 0.00 305.00 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1 Fire DepartmentG/L Transaction Detail Report July 31, 2011190-045-000-72100ElectricityBalanceForward7,845.2507/19/2011 Electricity 6/15-7/15 17350 Star-Tex Power 5836897 1,331.22Total1,331.22 0.00 9,176.47190-045-000-72200WaterBalance Forward401.4107/31/2011 July Water 17914 Trophy Club MUD - Water Bills 073111 43.20Total43.20 0.00 444.61190-045-000-73100TelephoneBalance Forward114.2507/27/2011 Steve Z. 18212 Bank of America 072711 9.95Total9.95 0.00 124.20190-045-000-73200Communications /Pagers/MobilesBalance Forward2,014.6407/22/2011 Cell phones 18218 Verizon Wireless 6609304057 167.7407/27/2011 Pastor 18212 Bank of America 072711 29.55Total197.29 0.00 2,211.93190-045-000-73300AdvertisingBalance Forward0.00Total0.00 0.00 0.00190-045-000-73400PrintingBalance Forward0.00Total0.00 0.00 0.00190-045-000-74100Dues & MembershipBalance Forward6,466.60Total0.00 0.00 6,466.60190-045-000-74200Travel & per diemBalance Forward3,531.41Total0.00 0.00 3,531.41190-045-000-74300Schools & TrainingBalance Forward3,316.95Total0.00 0.00 3,316.95190-045-000-74400Emergency ManagementBalance Forward1,000.00Total0.00 0.00 1,000.00190-045-000-74600MeetingsBalance Forward22.00Total0.00 0.00 22.00190-045-000-75000InsuranceBalance Forward8,714.00Total0.00 0.00 8,714.00190-045-000-77300Fire Inspections/EnforcementBalance Forward205.12Total0.00 0.00 205.12190-045-000-78200Small ToolsBalance Forward4,564.53Total0.00 0.00 4,564.53190-045-000-79200Building Rental/LeaseBalance Forward308,000.00Total0.00 0.00 308,000.00190-045-000-79999Miscellaneous ExpenseBalance Forward205.76Total0.00 0.00 205.76 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1 Fire DepartmentG/L Transaction Detail Report July 31, 2011190-045-000-80250Maintenance and RepairsBalanceForward1,952.2807/15/2011 EMW-2007-FO-06597 16737 DHS/FEMA 071511 323.5007/18/2011 CO Sensor, Beam Interrupter brackets 17372Air Technology Solutions of Delaware, LLCR218131,018.00Total1,341.500.00 3,293.78190-045-000-81200Building MaintenanceBalance Forward6,804.6407/16/2011 Cable 7/16-8/15 17498 DIRECTV 15602286746 50.9907/31/2011 Pest control/Fire Station 17878 Gann's Pest Control 073111 110.00Total160.99 0.00 6,965.63190-045-000-81300Vehicle MaintenanceBalance Forward8,458.68Total0.00 0.00 8,458.68190-045-000-81350Equipment MaintenanceBalance Forward521.71Total0.00 0.00 521.71190-045-000-81400Radio MaintenanceBalance Forward465.00Total0.00 0.00 465.00190-045-000-81800Flags & RepairsBalance Forward1,972.50Total0.00 0.00 1,972.50190-045-000-81900Maintenance SuppliesBalance Forward925.60Total0.00 0.00 925.60190-045-000-85000Grant MatchBalance Forward1,308.60Total0.00 0.00 1,308.60190-045-000-87100Programs & Special ProjectsBalance Forward882.8507/06/2011 Photo booth/Fire Station Open House 17924 Party Booths 10028 395.0007/18/2011 Face Painting, Balloon Sculptures/Fire S 17918 Fun Time Entertainment Group, Inc. 11-0827TCLUB 570.0007/28/2011 Slide, Sno Cone Machine/Fire Station Ope 17920 Bay Shay Bounce Houses 072811 225.00Total1,190.00 0.00 2,072.85190-045-000-90100RadiosBalance Forward807.50Total0.00 0.00 807.50190-045-000-90200Fire Engine 681 PaymentBalance Forward5,693.95Total0.00 0.00 5,693.95190-045-000-93200VehiclesBalance Forward4,164.55Total0.00 0.00 4,164.55190-045-000-93600AirpacksBalance Forward0.00Total0.00 0.00 0.00GRAND TOTAL55,706.37 4,970.82 -189,095.94 Municipal Utility District No 1 Fire Station Construction 2010 General Obligation $2M Bond Fund Interim Balance Sheet 10/12 Months (84% of Fiscal Year) Balance @ 7/31/2011 ASSETS ASSETS INVESTMENTS (246,951)$ OTHER RECEIVABLES - TOTAL ASSETS (246,951)$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE 101,269$ TOTAL LIABILITIES 101,269 FUND BALANCE DESIGNATED FOR FIRE STATION CONSTRUCTION (348,219) TOTAL LIABILITIES AND FUND BALANCE (246,951)$ * General Fund will transfer to cover expenditures over bond money received. July 31, 2011 Segments/AccountsYTD BudgetTotal BudgetMTD RevYTD RevYTD VarianceYTD %Total VarianceRemaining %[FUND] 491 : Bond Fund 2010 GO 2M Fire491-000-000-35050 : Interest Income1,295.001,295.000.001,053.58241.4218.64241.4218.64 Grand Total : 1,295.001,295.000.001,053.58241.4218.64241.4218.64User: rgonzalesTrophy Club Municipal Utility Dist #1 Fire ConstructionBudget Revenue ReportTo Date: 07/31/2011Run Date: 08/11/2011 491-045-000-94000 Temporary Housing and Storage 0.00 10,500.00 1,044.27 10,485.52 14.48 99.9 491-045-000-95000 Construction 0.00 1,405,652.00 207,152.43 1,755,035.09 (349,383.09) 124.9 491-045-000-96300 Engineering 0.00 41,000.00 0.00 39,609.75 1,390.25 96.6 Total Fire Department 0.00 1,457,152.00 208,196.70 1,805,130.36 (347,978.36) page 1 Budget to Actual - Fire Const Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance491-045-000-94000Temporary Housing and StorageBalance Forward9,441.2507/06/2011 Temporary Housing 6/17-7/16 16759 Modular Space Corporation 105860772 845.1007/27/2011 Steve Z. 18212 Bank of America 072711 199.17Total1,044.27 0.00 10,485.52491-045-000-95000ConstructionBalance Forward1,547,882.6607/01/2011 Fire Station App 13 17368 Prime Construction Co App 13 194,867.7507/01/2011 Retainage/Prime App 13 1733410,256.2007/24/2011 Electricity/Fire Station 17348 Hudson Energy 2131623 251.1607/29/2011 7 Articulating Keyboard trays 17894 National Business Furniture, LLC CV754465-ERO 954.6607/29/2011 Metal stools 17896 National Business Furniture, LLC CV755349-KFI 822.66Total207,152.43 0.00 1,755,035.09491-045-000-96100LegalBalance Forward0.00Total0.00 0.00 0.00491-045-000-96300EngineeringBalance Forward39,609.75Total0.00 0.00 39,609.75491-045-000-96500Bond Issuance CostBalance Forward0.00Total0.00 0.00 0.00GRAND TOTAL208,196.70 0.00 1,805,130.36Trophy Club Municipal Utility Dist #1 Fire ConstructionG/L Transaction Detail Report July 31, 2011 Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 7/31/2011 ASSETS ASSETS CASH AND CASH IN BANK 46,000$ INVESTMENTS 1,339,322 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 23,329 TOTAL ASSETS 1,408,652$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 23,329$ TOTAL LIABILITIES 23,329 FUND BALANCE DESIGNATED FOR DEBT SERVICE 1,385,322 TOTAL LIABILITIES AND FUND BALANCE 1,408,652$ July 31, 2011 10/12 Months 84% of Fiscal Year) Account/DescriptionYTD BudgetTotal BudgetMTD RevYTD RevYTD VarianceRemaining %[FUND] 680 : Debt Service680-000-000-30100 : Property Taxes755,712.00755,712.002,025.16757,514.31-1,802.31-0.24680-000-000-30125 : Property Taxes/Delinquent0.000.00123.694,395.51-4,395.510.00680-000-000-30150 : Property Taxes/Penalty & Interest9,500.009,500.00164.133,793.095,706.9160.07680-000-000-35050 : Interest Income500.00500.0075.58895.79-395.79-79.16680-000-000-35170 : Building Rent308,000.00308,000.000.00308,000.000.000.00680-000-000-38500 : PID Utility Fees246,100.00246,100.000.00246,100.000.000.00[FUND] SubTotal : 680 : Debt Service1,319,812.001,319,812.002,388.561,320,698.70-886.70-0.07 Grand Total : 1,319,812.001,319,812.002,388.561,320,698.70-886.70-0.07Run Date: 08/11/2011User: rgonzalesTrophy Club Municipal Utility Dist #1 Debt ServiceBudget Revenue ReportTo Date: 07/31/2011 680-680-000-89000 Bond Principal 1,115,000.00 1,115,000.00 0.00 0.00 1,115,000.00 # 680-680-000-89100 Bond Interest 379,559.00 379,559.00 0.00 206,598.55 172,960.45 54.4 680-680-000-89200 Paying Agent Fees 3,500.00 3,500.00 0.00 910.00 2,590.00 26.0 Total Debt Service 1,498,059.00 1,498,059.00 0.00 207,508.55 1,290,550.45 page 1 Budget to Actual -Debt Service Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance680-000-000-30100Property TaxesBalance Forward-755,489.15CR07/06/2011 MUD 1 AV Taxes16689323.8107/08/2011 MUD 1 AV Taxes16715269.8707/11/2011 MUD 1 AV Taxes16733250.9307/11/2011 MUD 1 AV Taxes16691269.8707/11/2011 MUD 1 AV Taxes16713269.8707/12/2011 MUD 1 AV Taxes16735260.7207/13/2011 MUD 1 AV Taxes16801117.4807/15/2011 MUD 1 AV Taxes1696873.6507/18/2011 MUD 1 AV Taxes1713228.4507/19/2011 MUD 1 AV Taxes1746063.0107/22/2011 MUD 1 AV Taxes1777028.0007/25/2011 MUD 1 AV Taxes17768150.8207/26/2011 MUD 1 AV Taxes17772133.2807/27/2011 MUD 1 AV Taxes1777495.9107/28/2011 MUD 1 AV Taxes17824195.9107/29/2011 MUD 1 AV Taxes1782633.32Total269.87 2,295.03 -757,514.31 CR680-000-000-30125Property Taxes/DelinquentBalance Forward-4,271.82CR07/15/2011 Advalorem Taxes1696810.0107/21/2011 Advalorem Taxes174620.8907/26/2011 Advalorem Taxes17772112.79Total0.00123.69 -4,395.51 CR680-000-000-30150Property Taxes/Penalty & InterestBalance Forward-3,628.96CR07/06/2011 Advalorem Taxes1668948.5707/08/2011 Advalorem Taxes1671540.4807/11/2011 Advalorem Taxes167330.7307/11/2011 MUD 1 AV Taxes1669140.4807/11/2011 MUD 1 AV Taxes1671340.4807/12/2011 Advalorem Taxes1673533.3607/13/2011 Advalorem Taxes168010.4107/15/2011 Advalorem Taxes169688.3807/19/2011 Advalorem Taxes1746011.3407/21/2011 Advalorem Taxes174620.3707/25/2011 Advalorem Taxes177683.6507/26/2011 Advalorem Taxes177726.0907/28/2011 Advalorem Taxes1782410.75Total40.48204.61 -3,793.09 CR680-000-000-35050Interest IncomeBalance Forward-820.21CR07/31/2011 July Bank Interst1820275.58Total0.0075.58-895.79 CR680-000-000-35170Building RentBalance Forward-308,000.00CRTotal0.00 0.00 -308,000.00 CR680-000-000-36900Recovery of Prior Year ExpenseBalance Forward0.00Total0.00 0.00 0.00680-000-000-37100Prior Year ReservesBalance Forward0.00Total0.00 0.00 0.00Trophy Club Municipal Utility Dist #1 Debt ServiceG/L Transaction Detail Report July 31, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1 Debt ServiceG/L Transaction Detail Report July 31, 2011680-000-000-38500PID Utility FeesBalanceForward-246,100.00CRTotal0.00 0.00 -246,100.00 CR680-000-000-39200Transfer In - General FundBalance Forward0.00Total0.00 0.00 0.00680-680-000-89000Bond PrincipalBalance Forward0.00Total0.00 0.00 0.00680-680-000-89100Bond InterestBalance Forward206,598.55Total0.00 0.00 206,598.55680-680-000-89200Paying Agent FeesBalance Forward910.00Total0.00 0.00 910.00GRAND TOTAL310.35 2,698.91 -1,113,190.15 BUDGET VARIANCE REPORT FUND:190 - Fire O&M FINANCIALS MONTH: July 2011 REVENUE VARIANCE: 76% EXPENSE VARIANCE: 92% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % VARIANCE EXPLANATION FIRE REVENUE 190-000-000-33420 Denton/Tarrant County-Fire 13,750 - 10,000 Interlocal agreement with Tarrant, will not receive payment FIRE EXPENSES 190-045-000-40130 Overtime 40,298$ 3,293$ 42,156$ 105% Covering vacation shifts 190-045-000-40140 Longevity 2,946$ -$ 2,987$ 101% Paid annually in December. 190-045-000-40160 Certification Pay 5,401$ 495$ 6,583$ 122% Firefighters have advanced their certifications 190-045-000-40180 Holiday Pay 11,604$ -$ 12,155$ 105% Paid annually in December 190-045-000-60300 Postage 95$ -$ 92$ 97% Postage meter usage and overnight letter 190-045-000-73100 Telephone 103$ 10$ 124$ 121% Long Distance & faxes 190-045-000-73200 Communications 1,874$ 197$ 2,212$ 118% Cell Phones 190-045-000-74400 Emergency Management 1,000$ -$ 1,000$ 100% Annual payment 190-045-000-79200 Building Rental/Lease 308,000$ -$ 308,000$ 100% One time annual payment after 1/31 taxes have been received 190-045-000-93200 Vehicles 4,183$ -$ 4,165$ 100% Final payment Fire Chief vehicle Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 8.3% for expenses. All variances over $1000 will be addressed. BUDGET VARIANCE REPORT FUND:180 - MUD 1 O&M FINANCIALS MONTH: July-2011 REVENUE VARIANCE: 76% EXPENSE VARIANCE: 92% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % VARIANCE EXPLANATION REVENUE 180-000-000-36100 Gas Well Revenue 2,000$ 86$ 765$ 38% Revenue less than anticipated. 180-000-000-38120 Water-Commercial 777,075$ 89,330$ 581,569$ 75% Dependent upon usage, higher usage in summer months. 180-000-000-38140 Portable Meters-Out of District 16,000$ 12,071$ 39,494$ 247% Dependent upon usage. 180-000-000-38220 Sewer-Commercial 300,403$ 32,776$ 233,368$ 78% Dependent upon usage, higher usage in summer months. 180-000-000-38500 PID Utility Fees 167,900$ 69,000$ 80,500$ 48% First 107 connections go to I&S. I&S has received the 107 for this year 180-000-000-38540 Sewer/Septic Dump Fees 48,000$ -$ -$ 0% Stopped for Screen Rake installation 180-000-000-38560 Fire Line Fees 5,000$ -$ 525$ 11% Revenue less than anticipated. 180-000-000-39290 GASB Reserves 54,314$ -$ -$ 0% Used to offset expenses. Will be transferred at a later date. WATER 180-010-000-40130 Salaries-Overtime 8,814$ 1,992$ 12,312$ 140% Based on number of after hours main breaks & reconnects 180-010-000-40140 Salaries-Longevity 2,150$ -$ 2,150$ 100% Paid annually in November. 180-010-000-40160 Salaries-Certification 1,500$ 150$ 1,430$ 95% Dependent on completed certifications and added during the year. 180-010-000-73200 Communications 1,599$ 165$ 1,515$ 95% Cell phones 180-010-000-75200 Annual Permit Fee 6,600$ -$ 6,134$ 93% Annual payment. 180-010-000-78100 Meter Expense 85,000$ -$ 83,182$ 98% Purchase in bulk, upfront. Sold 2" irrigation meter for Fire station 180-010-000-79150 Equipment Rental/Lease 500$ -$ 770$ 154% Crane rental for generator caused overage 180-010-000-93700 Capital Expense 130,932$ -$ 215,853$ 165% Meters and Badger Orion Upgrade. WASTEWATER 180-020-000-40130 Salaries-Overtime 10,166$ 1,396$ 11,442$ 113% Based on number of after hours main breaks & reconnects 180-020-000-40140 Salaries-Longevity 3,483$ -$ 3,483$ 100% Paid annually in November. 180-020-000-73200 Communications 3,000$ 243$ 2,849$ 95% Cell phones 180-020-000-74200 Travel and Per Diem 1,750$ 209$ 1,910$ 109% Based on number of training classes 180-020-000-75200 Annual Permit Fee 7,500$ -$ 10,704$ 143% Annual Permit, and application fee for 4 year permit 180-020-000-78300 Safety Equipment 540$ -$ 658$ 122% Supplies for first aid cabinet COLLECTIONS 180-021-000-40130 Salaries-Overtime 14,145$ 697$ 13,816$ 98% Based on number of after hours main breaks & reconnects 180-021-000-40140 Salaries-Longevity 3,128$ -$ 3,160$ 101% Paid annually in November. 180-021-000-40160 Salaries-Certification 1,200$ 125$ 1,250$ 104% Based on Certification testing. Paid monthly BOARD OF DIRECTORS 180-130-000-87110 Water Conservation/Public Information -$ -$ 2,335$ Water Conservation Program-not budgeted Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 8.3% for expenses. All variances over $1000 will be addressed. BUDGET VARIANCE REPORT FUND:180 - MUD 1 O&M FINANCIALS MONTH: July-2011 REVENUE VARIANCE: 76% EXPENSE VARIANCE: 92% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % VARIANCE EXPLANATION Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 8.3% for expenses. All variances over $1000 will be addressed. MANAGER'S OFFICE 180-140-000-40140 Salaries-Longevity 2,580$ -$ 2,755$ 107% Paid annually in November 180-140-000-42290 Pre-employment Physicals/Testing -$ 22$ 75$ 0% Receptionist position 180-140-000-50100 Professional Outside Services 229,076$ -$ 228,076$ 100% Semo Contract with Town-paid in two installments 180-140-000-73200 Communications 1,798$ 158$ 2,327$ 129% Cell phones 180-140-000-73400 Printing 515$ -$ 3,170$ 616% Shared cost with Town/printing of calendars mailed to residents 180-140-000-74100 Dues & Memberships 1,612$ -$ 1,715$ 106% Majority of dues paid in Oct/Nov. 180-140-000-78500 Furniture/Equipment < $5,000 1,750$ 3,406$ 4,081$ 233% MUD share of furniture purchase for remodel FINANCE 180-611-000-40130 Salaries-Overtime 3,500$ 1,048$ 12,043$ 344% Attend MUD meeting, work on budget, and monthly closeout & financial preparation for meeting. Catch up from taking vacation. 180-611-000-40140 Salaries-Longevity 3,128$ -$ 3,160$ 101% Paid annually in November 180-611-000-41215 Dental Insurance 393$ 43$ 407$ 103% Change in family status UTILITY BILLING 180-620-000-40140 Salaries-Longevity 245$ -$ 405$ 165% Paid annually in November, Utility Billing Clerk not budgeted for Longevity in the amount of $160 180-620-000-73600 Service Charges & Fees 18,000$ 1,975$ 18,156$ 101% WorldPay monthly credit card transaction fees. Added second machine for front desk. 180-620-000-75600 TCEQ Annual Assessment Fee 20,000$ -$ 19,248$ 96% Paid annually after calendar year end INFORMATION SERVICES 180-640-000-57000 Independent Labor 1,464$ -$ 2,349$ 160% Outside services 180-640-000-73100 Telephone 8,040$ 803$ 8,779$ 109% expenses related to new phone system FACILITIES MANAGEMENT 180-710-000-81200 Building Maintenance 11,970$ 64$ 13,399$ 112% Air conditioning repair/MUD building NON-DEPARTMENTAL 180-810-000-50200 Auditing 27,500$ -$ 27,500$ 100% Annual Auditing contract