The URL can be used to link to this page

Home My WebLink AboutOct 2011 Financial Summary Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 10/31/2011 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 840,930 INVESTMENTS 2,206,310 RESTRICTED ASSETS: INVESTMENTS 406,716 PREPAID EXPENSES 15,053 ADVALOREM PROPERTY TAXES RECEIVABLE 98,280 UTILITY AND OTHER ACCOUNTS RECEIVABLE 684,958 TOTAL ASSETS 4,252,647$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 98,280$ ACCOUNTS PAYABLE 536,141 CUSTOMER DEPOSITS 187,302 TOTAL LIABILITIES 821,724 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT 219,414 UNDESIGNATED FUND BALANCE 3,211,510 TOTAL FUND BALANCE 3,430,923 TOTAL LIABILITIES AND FUND BALANCE 4,252,647$ October 31, 2011 1/12 Months (9% of Fiscal Year) 180-000-000-30100 Property Taxes 97,495.00 97,495.00 365.39 365.39 97,129.61 0.4 180-000-000-30125 Property Taxes/Delinquent 0.00 0.00 (156.71) (156.71) 156.71 # 180-000-000-30150 Property Taxes/Penalty & Interest 1,334.00 1,334.00 (552.24) (552.24) 1,886.24 41.4- 180-000-000-35050 Interest Income 4,500.00 4,500.00 334.88 334.88 4,165.12 7.4 180-000-000-35150 Cell Tower Lease Revenue 0.00 0.00 847.00 847.00 (847.00) # 180-000-000-35170 Building Rent 7,000.00 7,000.00 583.33 583.33 6,416.67 8.3 180-000-000-36100 Gas Well Revenues 800.00 800.00 0.00 0.00 800.00 # 180-000-000-36500 Vending Revenue 600.00 600.00 0.00 0.00 600.00 # 180-000-000-36700 Miscellaneous Revenue 10,000.00 10,000.00 17.00 17.00 9,983.00 0.2 180-000-000-37100 Prior Year Reserves 241,981.00 241,981.00 0.00 0.00 241,981.00 # 180-000-000-38100 Water - Residential 1,990,800.00 1,990,800.00 179,668.75 179,668.75 1,811,131.25 9.0 180-000-000-38120 Water - Commercial 825,000.00 825,000.00 85,225.78 85,225.78 739,774.22 10.3 180-000-000-38130 Water - PID 425,000.00 425,000.00 43,404.77 43,404.77 381,595.23 10.2 180-000-000-38140 Portable Meters - Out of District 41,595.00 41,595.00 8,381.34 8,381.34 33,213.66 20.1 180-000-000-38200 Sewer - Residential 1,325,000.00 1,325,000.00 107,204.19 107,204.19 1,217,795.81 8.1 180-000-000-38220 Sewer - Commercial 360,000.00 360,000.00 30,191.15 30,191.15 329,808.85 8.4 180-000-000-38230 Sewer - PID 185,000.00 185,000.00 20,395.84 20,395.84 164,604.16 11.0 180-000-000-38240 Sewer - Out of District 11,807.00 11,807.00 960.31 960.31 10,846.69 8.1 180-000-000-38250 TCCC Effluent Charges 57,500.00 57,500.00 0.00 0.00 57,500.00 # 180-000-000-38300 Standby 775.00 775.00 66.00 66.00 709.00 8.5 180-000-000-38320 Penalties 50,500.00 50,500.00 7,066.30 7,066.30 43,433.70 14.0 180-000-000-38340 Service Charges 17,500.00 17,500.00 1,728.00 1,728.00 15,772.00 9.9 180-000-000-38360 Penalities - Out of District 300.00 300.00 0.00 0.00 300.00 # 180-000-000-38400 Plumbing Inspections 1,200.00 1,200.00 0.00 0.00 1,200.00 # 180-000-000-38420 Sewer Inspections 4,500.00 4,500.00 0.00 0.00 4,500.00 # 180-000-000-38500 PID Utility Fees 338,880.00 338,880.00 37,580.00 37,580.00 301,300.00 11.1 180-000-000-38560 Fire Line Fees 5,000.00 5,000.00 0.00 0.00 5,000.00 # 180-000-000-38600 Oversize Meter Reimbursements 64,000.00 64,000.00 5,548.00 5,548.00 58,452.00 8.7 180-000-000-39290 Transfer In - Future Replacement Reserve 26,911.00 26,911.00 0.00 0.00 26,911.00 # Total Fire Department 6,094,978.00 6,094,978.00 528,859.08 528,859.08 5,566,118.92 page 1 Budget Revenue - General Fund Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-010-000-40100 Salaries - Regular 199,759.00 199,759.00 12,581.46 12,581.46 187,177.54 6.3 180-010-000-40130 Salaries - Overtime 13,250.00 13,250.00 1,184.97 1,184.97 12,065.03 8.9 180-010-000-40140 Salaries - Longevity 2,620.00 2,620.00 0.00 0.00 2,620.00 # 180-010-000-40160 Salaries - Certification 1,800.00 1,800.00 150.00 150.00 1,650.00 8.3 180-010-000-41200 Retirement 25,508.00 25,508.00 1,970.57 1,970.57 23,537.43 7.7 180-010-000-41210 Medical Insurance 22,607.00 22,607.00 1,883.94 1,883.94 20,723.06 8.3 180-010-000-41215 Dental Insurance 2,169.00 2,169.00 134.28 134.28 2,034.72 6.2 180-010-000-41216 Vision Insurance 576.00 576.00 31.76 31.76 544.24 5.5 180-010-000-41218 Life Insurance & Other 1,161.00 1,161.00 0.00 0.00 1,161.00 # 180-010-000-42220 Social Security Taxes 13,481.00 13,481.00 809.57 809.57 12,671.43 6.0 180-010-000-42225 Medicare Taxes 3,153.00 3,153.00 189.34 189.34 2,963.66 6.0 180-010-000-42250 Unemployment Taxes 945.00 945.00 0.00 0.00 945.00 # 180-010-000-42260 Workman's Compensation 5,581.00 5,581.00 5,581.00 5,581.00 0.00 100.0 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 0.00 350.00 # 180-010-000-50500 Engineering 1,500.00 1,500.00 0.00 0.00 1,500.00 # 180-010-000-52400 Lab Analysis 4,500.00 4,500.00 180.00 180.00 4,320.00 4.0 180-010-000-57000 Independent Labor 500.00 500.00 0.00 0.00 500.00 # 180-010-000-58000 Bulk Water 1,720,000.00 1,720,000.00 0.00 0.00 1,720,000.00 # 180-010-000-60300 Postage 500.00 500.00 0.00 0.00 500.00 # 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 0.00 0.00 15,216.00 # 180-010-000-62100 Uniforms 3,690.00 3,690.00 638.21 638.21 3,051.79 17.3 180-010-000-62300 Chemicals 6,200.00 6,200.00 0.00 0.00 6,200.00 # 180-010-000-72100 Electricity/Gas 162,000.00 162,000.00 8,342.00 8,342.00 153,658.00 5.1 180-010-000-73200 Communications /Pagers/Mobiles 1,599.00 1,599.00 0.00 0.00 1,599.00 # 180-010-000-73350 Copies 50.00 50.00 0.00 0.00 50.00 # 180-010-000-73400 Printing 150.00 150.00 58.50 58.50 91.50 39.0 180-010-000-74100 Dues & Membership 150.00 150.00 0.00 0.00 150.00 # 180-010-000-74200 Travel & per diem 3,200.00 3,200.00 78.82 78.82 3,121.18 2.5 180-010-000-74300 Schools & Training 2,800.00 2,800.00 280.00 280.00 2,520.00 10.0 180-010-000-74700 Safety Program 500.00 500.00 0.00 0.00 500.00 # 180-010-000-75200 Annual Permit Fee 6,600.00 6,600.00 0.00 0.00 6,600.00 # 180-010-000-78100 Meter Expense 85,000.00 85,000.00 4,407.00 4,407.00 80,593.00 5.2 180-010-000-78200 Small Tools 2,500.00 2,500.00 0.00 0.00 2,500.00 # 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 0.00 500.00 # page 1 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/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 0.00 4,200.00 # 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 550.00 550.00 28,950.00 1.9 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 0.00 4,200.00 # 180-010-000-81200 Building Maintenance 750.00 750.00 365.50 365.50 384.50 48.7 180-010-000-81300 Vehicle Maintenance 3,380.00 3,380.00 112.89 112.89 3,267.11 3.3 180-010-000-81360 Maintenance - Backhoe/Skid Loader 2,900.00 2,900.00 0.00 0.00 2,900.00 # 180-010-000-81500 Lawn Maintenance 2,000.00 2,000.00 0.00 0.00 2,000.00 # 180-010-000-81900 Maintenance Supplies 32,000.00 32,000.00 498.67 498.67 31,501.33 1.6 180-010-000-91000 Capital Lease 11,490.00 11,490.00 0.00 0.00 11,490.00 # 180-010-000-93200 Vehicles 27,000.00 27,000.00 0.00 0.00 27,000.00 # 180-010-000-93700 Capital Expenses 888,432.00 888,432.00 597.19 597.19 887,834.81 0.1 180-010-000-97000 Capital Repairs 24,000.00 24,000.00 0.00 0.00 24,000.00 # 180-010-000-97100 Capital Repairs - Ground Storage 124,771.00 124,771.00 0.00 0.00 124,771.00 # 180-010-000-99500 Transfer to Future Replacement Reserve 30,000.00 30,000.00 0.00 0.00 30,000.00 # Total Water 3,501,238.00 3,501,238.00 40,625.67 40,625.67 3,460,612.33 page 2 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-020-000-40100 Salaries - Regular 182,147.00 182,147.00 30,713.97 30,713.97 151,433.03 16.9 180-020-000-40130 Salaries - Overtime 10,166.00 10,166.00 716.26 716.26 9,449.74 7.0 180-020-000-40140 Salaries - Longevity 3,976.00 3,976.00 1,387.50 1,387.50 2,588.50 34.9 180-020-000-40160 Salaries - Certification 2,400.00 2,400.00 200.00 200.00 2,200.00 8.3 180-020-000-41200 Retirement 27,816.00 27,816.00 4,675.31 4,675.31 23,140.69 16.8 180-020-000-41210 Medical Insurance 30,805.00 30,805.00 2,486.94 2,486.94 28,318.06 8.1 180-020-000-41215 Dental Insurance 1,981.00 1,981.00 185.96 185.96 1,795.04 9.4 180-020-000-41216 Vision Insurance 552.00 552.00 45.92 45.92 506.08 8.3 180-020-000-41218 Life Insurance & Other 884.00 884.00 0.00 0.00 884.00 # 180-020-000-42220 Social Security Taxes 8,597.00 8,597.00 1,909.78 1,909.78 6,687.22 22.2 180-020-000-42225 Medicare Taxes 2,011.00 2,011.00 446.64 446.64 1,564.36 22.2 180-020-000-42250 Unemployment Taxes 567.00 567.00 0.00 0.00 567.00 # 180-020-000-42260 Workman's Compensation 2,685.00 2,685.00 2,685.00 2,685.00 0.00 100.0 180-020-000-42960 Employee Relations 350.00 350.00 0.00 0.00 350.00 # 180-020-000-52400 Lab Analysis 22,760.00 22,760.00 1,074.57 1,074.57 21,685.43 4.7 180-020-000-57000 Independent Labor 750.00 750.00 0.00 0.00 750.00 # 180-020-000-60100 Office Supplies 400.00 400.00 0.00 0.00 400.00 # 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 438.17 438.17 61.83 87.6 180-020-000-61000 Fuel 6,875.00 6,875.00 0.00 0.00 6,875.00 # 180-020-000-62100 Uniforms 3,140.00 3,140.00 0.00 0.00 3,140.00 # 180-020-000-62300 Chemicals 13,180.00 13,180.00 1,350.00 1,350.00 11,830.00 10.2 180-020-000-62800 Lab Supplies 19,160.00 19,160.00 0.00 0.00 19,160.00 # 180-020-000-62900 Other Consumables 110.00 110.00 0.00 0.00 110.00 # 180-020-000-72100 Electricity/Gas 205,000.00 205,000.00 7,574.14 7,574.14 197,425.86 3.7 180-020-000-72200 Water 1,900.00 1,900.00 0.00 0.00 1,900.00 # 180-020-000-72400 Dumpster Services 35,000.00 35,000.00 1,612.50 1,612.50 33,387.50 4.6 180-020-000-73100 Telephone 0.00 0.00 6.20 6.20 (6.20) # 180-020-000-73200 Communications /Pagers/Mobiles 3,000.00 3,000.00 0.00 0.00 3,000.00 # 180-020-000-74200 Travel & per diem 1,750.00 1,750.00 116.55 116.55 1,633.45 6.7 180-020-000-74300 Schools & Training 1,320.00 1,320.00 0.00 0.00 1,320.00 # 180-020-000-74700 Safety Program 200.00 200.00 0.00 0.00 200.00 # 180-020-000-75200 Annual Permit Fee 7,500.00 7,500.00 7,432.50 7,432.50 67.50 99.1 180-020-000-78200 Small Tools 1,260.00 1,260.00 0.00 0.00 1,260.00 # 180-020-000-78300 Safety Equipment 925.00 925.00 0.00 0.00 925.00 # 180-020-000-78600 Hardware 525.00 525.00 0.00 0.00 525.00 # 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 525.00 0.00 0.00 525.00 # 180-020-000-80250 Maintenance and Repairs 17,750.00 17,750.00 3,120.94 3,120.94 14,629.06 17.6 180-020-000-81200 Building Maintenance 1,400.00 1,400.00 0.00 0.00 1,400.00 # page 3 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-020-000-81300 Vehicle Maintenance 4,998.00 4,998.00 0.00 0.00 4,998.00 # 180-020-000-81360 Maintenance - Backhoe/Skid Loader 2,950.00 2,950.00 0.00 0.00 2,950.00 # 180-020-000-81500 Lawn Maintenance 525.00 525.00 0.00 0.00 525.00 # 180-020-000-81900 Maintenance Supplies 8,860.00 8,860.00 155.14 155.14 8,704.86 1.8 180-020-000-93700 Capital Expenses 161,189.00 161,189.00 0.00 0.00 161,189.00 # 180-020-000-97000 Capital Repairs 56,000.00 56,000.00 0.00 0.00 56,000.00 # Total Wastewater 854,709.00 854,709.00 68,333.99 68,333.99 786,375.01 page 4 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-021-000-40100 Salaries - Regular 145,481.00 145,481.00 11,082.16 11,082.16 134,398.84 7.6 180-021-000-40130 Salaries - Overtime 7,297.00 7,297.00 651.72 651.72 6,645.28 8.9 180-021-000-40140 Salaries - Longevity 3,548.00 3,548.00 0.00 0.00 3,548.00 # 180-021-000-40160 Salaries - Certification 1,500.00 1,500.00 125.00 125.00 1,375.00 8.3 180-021-000-41200 Retirement 21,074.00 21,074.00 1,679.22 1,679.22 19,394.78 8.0 180-021-000-41210 Medical Insurance 22,983.00 22,983.00 1,702.68 1,702.68 21,280.32 7.4 180-021-000-41215 Dental Insurance 1,533.00 1,533.00 117.38 117.38 1,415.62 7.7 180-021-000-41216 Vision Insurance 357.00 357.00 29.72 29.72 327.28 8.3 180-021-000-41218 Life Insurance & Other 978.00 978.00 0.00 0.00 978.00 # 180-021-000-42220 Social Security Taxes 9,785.00 9,785.00 676.27 676.27 9,108.73 6.9 180-021-000-42225 Medicare Taxes 2,288.00 2,288.00 158.16 158.16 2,129.84 6.9 180-021-000-42250 Unemployment Taxes 567.00 567.00 0.00 0.00 567.00 # 180-021-000-42260 Workman's Compensation 3,056.00 3,056.00 3,056.00 3,056.00 0.00 100.0 180-021-000-42960 Employee Relations 250.00 250.00 0.00 0.00 250.00 # 180-021-000-50500 Engineering 1,500.00 1,500.00 0.00 0.00 1,500.00 # 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 0.00 0.00 11,700.00 # 180-021-000-62100 Uniforms 2,505.00 2,505.00 0.00 0.00 2,505.00 # 180-021-000-62300 Chemicals 12,500.00 12,500.00 0.00 0.00 12,500.00 # 180-021-000-72100 Electricity/Gas 23,625.00 23,625.00 645.48 645.48 22,979.52 2.7 180-021-000-72200 Water 750.00 750.00 0.00 0.00 750.00 # 180-021-000-73100 Telephone 0.00 0.00 3.23 3.23 (3.23) # 180-021-000-73200 Communications /Pagers/Mobiles 2,796.00 2,796.00 0.00 0.00 2,796.00 # 180-021-000-74100 Dues & Membership 255.00 255.00 0.00 0.00 255.00 # 180-021-000-74200 Travel & per diem 1,500.00 1,500.00 96.58 96.58 1,403.42 6.4 180-021-000-74300 Schools & Training 2,818.00 2,818.00 0.00 0.00 2,818.00 # 180-021-000-74700 Safety Program 750.00 750.00 0.00 0.00 750.00 # 180-021-000-78200 Small Tools 1,500.00 1,500.00 0.00 0.00 1,500.00 # 180-021-000-78300 Safety Equipment 1,150.00 1,150.00 0.00 0.00 1,150.00 # 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 158.45 158.45 23,541.55 0.7 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 1,943.00 1,943.00 130.00 130.00 1,813.00 6.7 180-021-000-81900 Maintenance Supplies 16,050.00 16,050.00 0.00 0.00 16,050.00 # 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 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Total Collection 407,796.00 407,796.00 20,312.05 20,312.05 387,483.95 page 6 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/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 800.00 800.00 9,200.00 8.0 180-130-000-42220 Social Security Taxes 620.00 620.00 49.60 49.60 570.40 8.0 180-130-000-42225 Medicare Taxes 145.00 145.00 11.60 11.60 133.40 8.0 180-130-000-42250 Unemployment Taxes 210.00 210.00 6.40 6.40 203.60 3.0 180-130-000-42260 Workman's Compensation 120.00 120.00 120.00 120.00 0.00 100.0 180-130-000-60100 Office Supplies 50.00 50.00 0.00 0.00 50.00 # 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 100.00 100.00 2,000.00 4.8 180-130-000-74200 Travel & per diem 6,199.00 6,199.00 0.00 0.00 6,199.00 # 180-130-000-74300 Schools & Training 4,150.00 4,150.00 80.00 80.00 4,070.00 1.9 180-130-000-74600 Meetings 1,278.00 1,278.00 44.00 44.00 1,234.00 3.4 180-130-000-79999 Miscellaneous Expense 3,200.00 3,200.00 0.00 0.00 3,200.00 # Total Board of Directors 28,122.00 28,122.00 1,211.60 1,211.60 26,910.40 page 7 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-140-000-40100 Salaries - Regular 236,831.00 236,831.00 13,653.88 13,653.88 223,177.12 5.8 180-140-000-40130 Salaries - Overtime 1,000.00 1,000.00 201.36 201.36 798.64 20.1 180-140-000-40140 Salaries - Longevity 1,845.00 1,845.00 0.00 0.00 1,845.00 # 180-140-000-41200 Retirement 33,471.00 33,471.00 1,961.92 1,961.92 31,509.08 5.9 180-140-000-41210 Medical Insurance 18,798.00 18,798.00 1,269.12 1,269.12 17,528.88 6.8 180-140-000-41215 Dental Insurance 1,242.00 1,242.00 94.62 94.62 1,147.38 7.6 180-140-000-41216 Vision Insurance 341.00 341.00 23.98 23.98 317.02 7.0 180-140-000-41218 Life Insurance & Other 1,337.00 1,337.00 0.00 0.00 1,337.00 # 180-140-000-42220 Social Security Taxes 14,860.00 14,860.00 817.09 817.09 14,042.91 5.5 180-140-000-42225 Medicare Taxes 3,475.00 3,475.00 191.10 191.10 3,283.90 5.5 180-140-000-42250 Unemployment Taxes 756.00 756.00 9.94 9.94 746.06 1.3 180-140-000-42260 Workman's Compensation 580.00 580.00 580.00 580.00 0.00 100.0 180-140-000-42960 Employee Relations 5,000.00 5,000.00 56.57 56.57 4,943.43 1.1 180-140-000-50100 Professional Outside Services 176,870.00 176,870.00 0.00 0.00 176,870.00 # 180-140-000-52100 Elections 2,500.00 2,500.00 0.00 0.00 2,500.00 # 180-140-000-54200 Records Management 500.00 500.00 0.00 0.00 500.00 # 180-140-000-57000 Independent Labor 840.00 840.00 33.75 33.75 806.25 4.0 180-140-000-60100 Office Supplies 2,450.00 2,450.00 117.66 117.66 2,332.34 4.8 180-140-000-60300 Postage 0.00 0.00 237.92 237.92 (237.92) # 180-140-000-60400 Publications/Books/Subscriptions 450.00 450.00 0.00 0.00 450.00 # 180-140-000-73100 Telephone 300.00 300.00 40.37 40.37 259.63 13.5 180-140-000-73200 Communications /Pagers/Mobiles 2,420.00 2,420.00 0.00 0.00 2,420.00 # 180-140-000-73300 Advertising 4,700.00 4,700.00 0.00 0.00 4,700.00 # 180-140-000-73400 Printing 515.00 515.00 0.00 0.00 515.00 # 180-140-000-74100 Dues & Membership 1,742.00 1,742.00 250.00 250.00 1,492.00 14.4 180-140-000-74200 Travel & per diem 3,851.00 3,851.00 36.85 36.85 3,814.15 1.0 180-140-000-74300 Schools & Training 2,555.00 2,555.00 130.00 130.00 2,425.00 5.1 180-140-000-74600 Meetings 312.00 312.00 0.00 0.00 312.00 # 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 2,225.00 2,225.00 0.00 0.00 2,225.00 # 180-140-000-79999 Miscellaneous Expense 100.00 100.00 0.00 0.00 100.00 # Total Managers Office 531,866.00 531,866.00 19,706.13 19,706.13 512,159.87 page 8 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-611-000-40100 Salaries - Regular 94,404.00 94,404.00 7,500.00 7,500.00 86,904.00 7.9 180-611-000-40130 Salaries - Overtime 1,000.00 1,000.00 187.78 187.78 812.22 18.8 180-611-000-40140 Salaries - Longevity 1,823.00 1,823.00 0.00 0.00 1,823.00 # 180-611-000-41200 Retirement 13,612.00 13,612.00 1,088.58 1,088.58 12,523.42 8.0 180-611-000-41210 Medical Insurance 11,060.00 11,060.00 921.35 921.35 10,138.65 8.3 180-611-000-41215 Dental Insurance 773.00 773.00 73.49 73.49 699.51 9.5 180-611-000-41216 Vision Insurance 207.00 207.00 12.49 12.49 194.51 6.0 180-611-000-41218 Life Insurance & Other 567.00 567.00 0.00 0.00 567.00 # 180-611-000-42220 Social Security Taxes 5,386.00 5,386.00 408.43 408.43 4,977.57 7.6 180-611-000-42225 Medicare Taxes 1,260.00 1,260.00 95.52 95.52 1,164.48 7.6 180-611-000-42250 Unemployment Taxes 284.00 284.00 0.00 0.00 284.00 # 180-611-000-42260 Workman's Compensation 235.00 235.00 211.00 211.00 24.00 89.8 180-611-000-50100 Professional Outside Services 5,000.00 5,000.00 0.00 0.00 5,000.00 # 180-611-000-60100 Office Supplies 849.00 849.00 0.00 0.00 849.00 # 180-611-000-60300 Postage 700.00 700.00 33.44 33.44 666.56 4.8 180-611-000-60400 Publications/Books/Subscriptions 500.00 500.00 0.00 0.00 500.00 # 180-611-000-73100 Telephone 103.00 103.00 11.44 11.44 91.56 11.1 180-611-000-73200 Communications /Pagers/Mobiles 683.00 683.00 0.00 0.00 683.00 # 180-611-000-73300 Advertising 1,210.00 1,210.00 0.00 0.00 1,210.00 # 180-611-000-73400 Printing 515.00 515.00 0.00 0.00 515.00 # 180-611-000-73600 Service Charges & Fees 79.00 79.00 0.00 0.00 79.00 # 180-611-000-74100 Dues & Membership 660.00 660.00 0.00 0.00 660.00 # 180-611-000-74200 Travel & per diem 1,500.00 1,500.00 15.04 15.04 1,484.96 1.0 180-611-000-74300 Schools & Training 2,000.00 2,000.00 0.00 0.00 2,000.00 # 180-611-000-74600 Meetings 300.00 300.00 22.00 22.00 278.00 7.3 180-611-000-79999 Miscellaneous Expense 200.00 200.00 0.00 0.00 200.00 # Total Finance 144,910.00 144,910.00 10,580.56 10,580.56 134,329.44 page 9 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-620-000-40100 Salaries - Regular 84,946.00 84,946.00 6,575.76 6,575.76 78,370.24 7.7 180-620-000-40130 Salaries - Overtime 2,000.00 2,000.00 24.95 24.95 1,975.05 1.2 180-620-000-40140 Salaries - Longevity 220.00 220.00 0.00 0.00 220.00 # 180-620-000-41200 Retirement 12,203.00 12,203.00 934.65 934.65 11,268.35 7.7 180-620-000-41210 Medical Insurance 12,321.00 12,321.00 924.36 924.36 11,396.64 7.5 180-620-000-41215 Dental Insurance 1,026.00 1,026.00 91.66 91.66 934.34 8.9 180-620-000-41216 Vision Insurance 260.00 260.00 21.63 21.63 238.37 8.3 180-620-000-41218 Life Insurance & Other 604.00 604.00 0.00 0.00 604.00 # 180-620-000-42220 Social Security Taxes 5,404.00 5,404.00 373.48 373.48 5,030.52 6.9 180-620-000-42225 Medicare Taxes 1,264.00 1,264.00 87.34 87.34 1,176.66 6.9 180-620-000-42250 Unemployment Taxes 473.00 473.00 9.98 9.98 463.02 2.1 180-620-000-42260 Workman's Compensation 211.00 211.00 235.00 235.00 (24.00) 111.4 180-620-000-56200 Utility Billing Contract 11,000.00 11,000.00 917.72 917.72 10,082.28 8.3 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 39.94 39.94 660.06 5.7 180-620-000-60300 Postage 18,000.00 18,000.00 1,403.12 1,403.12 16,596.88 7.8 180-620-000-73100 Telephone 100.00 100.00 20.91 20.91 79.09 20.9 180-620-000-73200 Communications /Pagers/Mobiles 472.00 472.00 0.00 0.00 472.00 # 180-620-000-73400 Printing 3,250.00 3,250.00 0.00 0.00 3,250.00 # 180-620-000-73600 Service Charges & Fees 18,000.00 18,000.00 3,166.50 3,166.50 14,833.50 17.6 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 0.00 605.00 # 180-620-000-74300 Schools & Training 800.00 800.00 0.00 0.00 800.00 # 180-620-000-75600 TCEQ Annual Assessment Fee 22,500.00 22,500.00 0.00 0.00 22,500.00 # 180-620-000-79999 Miscellaneous Expense 200.00 200.00 0.00 0.00 200.00 # Total Utility Billing 197,430.00 197,430.00 14,827.00 14,827.00 182,603.00 page 10 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-630-000-42290 Pre-employment Physicals/Testing 1,560.00 1,560.00 0.00 0.00 1,560.00 # 180-630-000-42960 Employee Relations 1,967.00 1,967.00 50.11 50.11 1,916.89 2.5 180-630-000-43240 Tuition Reimbursement 1,561.00 1,561.00 0.00 0.00 1,561.00 # 180-630-000-60100 Office Supplies 437.00 437.00 0.00 0.00 437.00 # 180-630-000-60300 Postage 106.00 106.00 0.00 0.00 106.00 # 180-630-000-60400 Publications/Books/Subscriptions 485.00 485.00 0.00 0.00 485.00 # 180-630-000-73100 Telephone 28.00 28.00 0.00 0.00 28.00 # 180-630-000-73400 Printing 116.00 116.00 0.00 0.00 116.00 # 180-630-000-74100 Dues & Membership 555.00 555.00 0.00 0.00 555.00 # 180-630-000-74200 Travel & per diem 8.00 8.00 0.00 0.00 8.00 # 180-630-000-74300 Schools & Training 594.00 594.00 0.00 0.00 594.00 # 180-630-000-74600 Meetings 138.00 138.00 0.00 0.00 138.00 # Total Human Resources 7,555.00 7,555.00 50.11 50.11 7,504.89 page 11 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/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 0.00 1,350.00 # 180-640-000-55000 Software & Support 64,149.00 64,149.00 1,747.76 1,747.76 62,401.24 2.7 180-640-000-57000 Independent Labor 1,650.00 1,650.00 218.75 218.75 1,431.25 13.3 180-640-000-60100 Office Supplies 371.00 371.00 0.00 0.00 371.00 # 180-640-000-60200 Printer Supplies 5,732.00 5,732.00 589.88 589.88 5,142.12 10.3 180-640-000-73100 Telephone 6,540.00 6,540.00 818.25 818.25 5,721.75 12.5 180-640-000-78600 Hardware 83,238.00 83,238.00 2,139.36 2,139.36 81,098.64 2.6 180-640-000-79100 Copier Rental/Lease 3,450.00 3,450.00 0.00 0.00 3,450.00 # 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 193,391.00 193,391.00 5,514.00 5,514.00 187,877.00 page 12 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-710-000-40100 Salaries - Regular 31,512.00 31,512.00 0.00 0.00 31,512.00 # 180-710-000-41200 Retirement 4,412.00 4,412.00 0.00 0.00 4,412.00 # 180-710-000-41210 Medical Insurance 9,027.00 9,027.00 0.00 0.00 9,027.00 # 180-710-000-41215 Dental Insurance 549.00 549.00 0.00 0.00 549.00 # 180-710-000-41216 Vision Insurance 138.00 138.00 0.00 0.00 138.00 # 180-710-000-41218 Life Insurance & Other 228.00 228.00 0.00 0.00 228.00 # 180-710-000-42220 Social Security Taxes 1,954.00 1,954.00 0.00 0.00 1,954.00 # 180-710-000-42225 Medicare Taxes 457.00 457.00 0.00 0.00 457.00 # 180-710-000-42250 Unemployment Taxes 189.00 189.00 0.00 0.00 189.00 # 180-710-000-42260 Workman's Compensation 861.00 861.00 861.00 861.00 0.00 100.0 180-710-000-42290 Pre-employment Physicals/Testing 250.00 250.00 0.00 0.00 250.00 # 180-710-000-62520 Vending Machine Supplies 1,000.00 1,000.00 19.69 19.69 980.31 2.0 180-710-000-72100 Electricity/Gas 21,940.00 21,940.00 427.45 427.45 21,512.55 1.9 180-710-000-72200 Water 1,093.00 1,093.00 0.00 0.00 1,093.00 # 180-710-000-75000 Insurance 32,635.00 32,635.00 28,589.50 28,589.50 4,045.50 87.6 180-710-000-78500 Furniture/Equipment<$5,000 2,500.00 2,500.00 0.00 0.00 2,500.00 # 180-710-000-79200 Building Rental/Lease 13,182.00 13,182.00 1,098.51 1,098.51 12,083.49 8.3 180-710-000-81200 Building Maintenance 5,000.00 5,000.00 31.98 31.98 4,968.02 0.6 180-710-000-81600 Cleaning Services 0.00 0.00 678.18 678.18 (678.18) # 180-710-000-81900 Maintenance Supplies 2,205.00 2,205.00 168.22 168.22 2,036.78 7.6 Total Facilities Maintenance 129,132.00 129,132.00 31,874.53 31,874.53 97,257.47 page 13 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-810-000-50200 Auditing 20,200.00 20,200.00 5,050.00 5,050.00 15,150.00 25.0 180-810-000-50300 Legal 55,000.00 55,000.00 0.00 0.00 55,000.00 # 180-810-000-51100 Appraisal 20,000.00 20,000.00 3,060.83 3,060.83 16,939.17 15.3 180-810-000-51150 Tax Administration 3,629.00 3,629.00 0.00 0.00 3,629.00 # Total Non Departmental 98,829.00 98,829.00 8,110.83 8,110.83 90,718.17 Total Expenses 6,094,978.00 6,094,978.00 221,146.47 221,146.47 5,873,831.53 page 14 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Trophy Club Municipal Utility Dist #1 G/L Transaction Detail From Date: 10/01/2011 To Date: 10/31/2011 From Account: 180-000-000-30100 To Account: 180-810-000-99510 Run Date: 11/10/2011 User: rgonzales G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 180-000-000-30100 Property Taxes Balance Forward 0.00 10/07/2011 USR MUD 1 AV Taxes 23097 16.81 10/18/2011 USR MUD 1 AV Taxes 23107 11.80 10/19/2011 USR MUD 1 AV Taxes 23099 52.83 10/20/2011 USR MUD 1 AV Taxes 23101 16.28 10/21/2011 USR MUD 1 AV Taxes 23103 40.85 10/25/2011 USR MUD 1 AV Taxes 23105 45.44 10/26/2011 USR MUD 1 AV Taxes 23109 38.08 10/27/2011 USR MUD 1 AV Taxes 23113 22.48 10/28/2011 USR MUD 1 AV Taxes 23318 101.58 10/31/2011 USR MUD 1 AV Taxes 23399 19.24 TOTAL 0.00 365.39 365.39CR 180-000-000-30125 Property Taxes/Delinquent Balance Forward 0.00 10/05/2011 RV MUD 1 AV Taxes 23609 23.02 10/05/2011 USR MUD 1 AV Taxes Corrected of JE 23093 23611 23.02 10/05/2011 USR Advalorem Taxes 22991 81.74 10/05/2011 USR MUD 1 AV Taxes 23093 23.02 10/06/2011 USR MUD 1 AV Taxes 23095 17.51 10/18/2011 USR MUD 1 AV Taxes 23107 280.21 10/28/2011 USR MUD 1 AV Taxes 23318 1.23 TOTAL 303.23 146.52 156.71 180-000-000-30150 Property Taxes/Penalty & Interest Balance Forward 0.00 10/05/2011 RV Advalorem Taxes 23609 4.15 10/05/2011 USR Advalorem Taxes 23611 4.15 10/05/2011 USR Advalorem Taxes 22991 27.78 10/05/2011 USR Advalorem Taxes 23093 4.15 10/06/2011 USR Advalorem Taxes 23095 3.50 10/18/2011 USR MUD 1 AV Taxes 23107 590.56 10/28/2011 USR Advalorem Taxes 23318 0.30 10/28/2011 USR Rendition Penalty 23318 2.59 TOTAL 594.71 42.47 552.24 180-000-000-35050 Interest Income Balance Forward 0.00 10/31/2011 USR October Bank interest 23605 136.18 10/31/2011 USR October Bank interest 23605 198.70 TOTAL 0.00 334.88 334.88CR 180-000-000-35150 Cell Tower Lease Revenue Balance Forward 0.00 10/10/2011 USR AT&T Cell Tower lease/Oct 22921 847.00 TOTAL 0.00 847.00 847.00CR page 1 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 180-000-000-35160 Lease/Rental Revenue Balance Forward 0.00 180-000-000-35170 Building Rent Balance Forward 0.00 10/26/2011 USR Town/Oct Maint Barn rent 22935 583.33 TOTAL 0.00 583.33 583.33CR 180-000-000-35420 Loan Proceeds Balance Forward 0.00 180-000-000-35430 Capital Lease Proceeds Balance Forward 0.00 180-000-000-36100 Gas Well Revenues Balance Forward 0.00 180-000-000-36400 Auction Sales Balance Forward 0.00 180-000-000-36500 Vending Revenue Balance Forward 0.00 180-000-000-36700 Miscellaneous Revenue Balance Forward 0.00 10/14/2011 USR Moore-ORR 22931 16.00 10/26/2011 USR Moore/ORR 22939 1.00 TOTAL 0.00 17.00 17.00CR 180-000-000-36900 Recovery of Prior Year Expense Balance Forward 0.00 180-000-000-37100 Prior Year Reserves Balance Forward 0.00 180-000-000-38100 Water - Residential Balance Forward 0.00 10/06/2011 USR UB 10/6/11 Adjustments 23322 116.56 10/20/2011 USR UB Penalty Adjustments 23215 3.34 10/25/2011 USR UB Adjustments 23227 33.80 10/31/2011 USR Oct Utility billing 23306 178,276.97 10/31/2011 USR UB Credit Adjustments/Oct 23308 1,545.48 TOTAL 153.70 179,822.45 179,668.75CR 180-000-000-38120 Water - Commercial Balance Forward 0.00 10/01/2011 USR UB Adjustments 23157 4,045.57 10/31/2011 USR Oct Utility billing 23306 81,482.73 10/31/2011 USR UB Credit Adjustments/Oct 23308 302.52 TOTAL 302.52 85,528.30 85,225.78CR 180-000-000-38130 Water - PID Balance Forward 0.00 10/31/2011 USR Oct Utility billing 23306 44,263.77 10/31/2011 USR UB Credit Adjustments/Oct 23308 859.00 TOTAL 859.00 44,263.77 43,404.77CR 180-000-000-38140 Portable Meters - Out of District Balance Forward 0.00 10/21/2011 USR UB Late Fees 23221 878.37 10/31/2011 USR Oct Utility billing 23306 7,502.97 TOTAL 0.00 8,381.34 8,381.34CR 180-000-000-38200 Sewer - Residential Balance Forward 0.00 10/31/2011 USR Oct Utility billing 23306 108,725.78 10/31/2011 USR UB Credit Adjustments/Oct 23308 1,521.59 TOTAL 1,521.59 108,725.78 107,204.19CR 180-000-000-38220 Sewer - Commercial Balance Forward 0.00 10/31/2011 USR Oct Utility billing 23306 30,256.12 10/31/2011 USR UB Credit Adjustments/Oct 23308 64.97 TOTAL 64.97 30,256.12 30,191.15CR 180-000-000-38230 Sewer - PID Balance Forward 0.00 10/31/2011 USR Oct Utility billing 23306 20,632.44 10/31/2011 USR UB Credit Adjustments/Oct 23308 236.60 TOTAL 236.60 20,632.44 20,395.84CR 180-000-000-38240 Sewer - Out of District Balance Forward 0.00 10/31/2011 USR Oct Utility billing 23306 960.31 page 2 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance TOTAL 0.00 960.31 960.31CR 180-000-000-38250 TCCC Effluent Charges Balance Forward 0.00 10/26/2011 USR Club Corp/Sept Effluent 22933 13,850.59 10/26/2011 USR Correct JE23952 Sept TCCC Effluent 23954 13,850.59 TOTAL 13,850.59 13,850.59 0.00 180-000-000-38300 Standby Balance Forward 0.00 10/31/2011 USR Oct Utility billing 23306 78.00 10/31/2011 USR UB Credit Adjustments/Oct 23308 12.00 TOTAL 12.00 78.00 66.00CR 180-000-000-38320 Penalties Balance Forward 0.00 10/03/2011 USR UB Penalties 23159 39.29 10/20/2011 USR UB Penalty Adjustments 23215 238.39 10/21/2011 USR UB Late Fees 23221 7,317.17 10/26/2011 USR UB Adjustments Penalties 23237 454.08 10/28/2011 USR UB ADJUSTMENTS PENALTIES 23264 10.94 10/31/2011 USR UB Credit Adjustments/Oct 23308 926.42 10/31/2011 USR UB Late Fees 23280 434.59 TOTAL 1,177.29 8,243.59 7,066.30CR 180-000-000-38340 Service Charges Balance Forward 0.00 10/06/2011 USR UB Adjustments 23171 300.00 10/06/2011 USR UB 10/6/11 Adjustments 23322 1,325.00 10/19/2011 USR UB Adjustments Service Chgs 23203 25.00 10/20/2011 USR UB Penalty Adjustments 23215 25.00 10/21/2011 USR UB Service Charges 23248 100.00 10/26/2011 USR UB Adjustments Penalties 23237 25.00 10/31/2011 USR Oct Utility billing 23306 3.00 10/31/2011 USR UB Credit Adjustments/Oct 23308 25.00 TOTAL 50.00 1,778.00 1,728.00CR 180-000-000-38360 Penalities - Out of District Balance Forward 0.00 180-000-000-38400 Plumbing Inspections Balance Forward 0.00 180-000-000-38420 Sewer Inspections Balance Forward 0.00 180-000-000-38500 PID Utility Fees Balance Forward 0.00 10/31/2011 USR Recode Utility Fees/Oct 23272 37,580.00 TOTAL 0.00 37,580.00 37,580.00CR 180-000-000-38520 Tap Fees Balance Forward 0.00 180-000-000-38540 Sewer/Septic Dump Fees Balance Forward 0.00 180-000-000-38560 Fire Line Fees Balance Forward 0.00 180-000-000-38600 Oversize Meter Reimbursements Balance Forward 0.00 10/04/2011 USR Permits 10/4/11 22945 584.00 10/05/2011 USR Permits 10/5/11 22947 292.00 10/06/2011 USR Permits 10/6/11 22949 292.00 10/12/2011 USR Permits 10/12/11 22951 292.00 10/14/2011 USR Permits 10/14/11 22953 584.00 10/17/2011 USR Permits 10/17/11 22955 876.00 10/20/2011 USR Permits 10/20/11 22957 1,460.00 10/21/2011 USR Permits 10/21/11 22959 292.00 10/21/2011 SYS 2402 TC Drive previously 23041 Lennar Homes 102111 292.00 page 3 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance permitted 2008- 10/26/2011 USR Permits 10/26/11 22961 876.00 10/28/2011 USR Permits 10/28/11 23241 292.00 TOTAL 292.00 5,840.00 5,548.00CR 180-000-000-39200 Transfer In - General Fund Balance Forward 0.00 180-000-000-39290 Transfer In - Future Replacement Reserve Balance Forward 0.00 180-010-000-40100 Salaries - Regular Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 6,290.73 10/28/2011 USR Payroll 10/28/11 23603 6,290.73 TOTAL 12,581.46 0.00 12,581.46 180-010-000-40130 Salaries - Overtime Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 607.69 10/28/2011 USR Payroll 10/28/11 23603 577.28 TOTAL 1,184.97 0.00 1,184.97 180-010-000-40140 Salaries - Longevity Balance Forward 0.00 180-010-000-40160 Salaries - Certification Balance Forward 0.00 10/28/2011 USR Payroll 10/28/11 23603 150.00 TOTAL 150.00 0.00 150.00 180-010-000-41200 Retirement Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 976.82 10/28/2011 USR Payroll 10/28/11 23603 993.75 TOTAL 1,970.57 0.00 1,970.57 180-010-000-41210 Medical Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 941.97 10/28/2011 USR Payroll 10/28/11 23603 941.97 TOTAL 1,883.94 0.00 1,883.94 180-010-000-41215 Dental Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 67.14 10/28/2011 USR Payroll 10/28/11 23603 67.14 TOTAL 134.28 0.00 134.28 180-010-000-41216 Vision Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 15.88 10/28/2011 USR Payroll 10/28/11 23603 15.88 TOTAL 31.76 0.00 31.76 180-010-000-41218 Life Insurance & Other Balance Forward 0.00 180-010-000-42220 Social Security Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 401.08 10/28/2011 USR Payroll 10/28/11 23603 408.49 TOTAL 809.57 0.00 809.57 180-010-000-42225 Medicare Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 93.81 10/28/2011 USR Payroll 10/28/11 23603 95.53 TOTAL 189.34 0.00 189.34 180-010-000-42250 Unemployment Taxes Balance Forward 0.00 180-010-000-42260 Workman's Compensation Balance Forward 0.00 10/01/2011 SYS Workers Comp 22481 TML Intergovernmental Risk 3411/MUD W/C 5,581.00 TOTAL 5,581.00 0.00 5,581.00 180-010-000-42290 Pre-employment Physicals/Testing Balance Forward 0.00 180-010-000-42960 Employee Relations Balance Forward 0.00 page 4 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 180-010-000-50500 Engineering Balance Forward 0.00 180-010-000-52400 Lab Analysis Balance Forward 0.00 10/31/2011 SYS Water testing/Oct 23896 Tarrant County Public Health Lab 21334 180.00 TOTAL 180.00 0.00 180.00 180-010-000-57000 Independent Labor Balance Forward 0.00 180-010-000-58000 Bulk Water Balance Forward 0.00 180-010-000-60300 Postage Balance Forward 0.00 180-010-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 180-010-000-61000 Fuel Balance Forward 0.00 180-010-000-62100 Uniforms Balance Forward 0.00 10/20/2011 SYS McMahon 23394 JP Morgan Chase Bank NA 102011 148.74 10/20/2011 SYS McMahon 23394 JP Morgan Chase Bank NA 102011 169.99 10/20/2011 SYS McMahon 23394 JP Morgan Chase Bank NA 102011 153.74 10/20/2011 SYS McMahon 23394 JP Morgan Chase Bank NA 102011 165.74 TOTAL 638.21 0.00 638.21 180-010-000-62300 Chemicals Balance Forward 0.00 180-010-000-72100 Electricity/Gas Balance Forward 0.00 10/04/2011 SYS Electricity/Oct 22493 Tri County Electric 2309888001 Oct 3.28 10/13/2011 SYS Electricity/Oct 22471 Hudson Energy 2410425 Oct 102.56 10/13/2011 SYS Electricity/Oct 22467 Hudson Energy 17359 Oct 8,236.16 TOTAL 8,342.00 0.00 8,342.00 180-010-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 180-010-000-73350 Copies Balance Forward 0.00 180-010-000-73400 Printing Balance Forward 0.00 10/18/2011 SYS Business Cards/Womack 23439 Forms One 34539 58.50 TOTAL 58.50 0.00 58.50 180-010-000-74100 Dues & Membership Balance Forward 0.00 180-010-000-74200 Travel & per diem Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 35.53 10/28/2011 USR Payroll 10/28/11 23603 43.29 TOTAL 78.82 0.00 78.82 180-010-000-74300 Schools & Training Balance Forward 0.00 10/31/2011 SYS Womack 23918 JP Morgan Chase Bank NA 110711 90.00 10/31/2011 SYS McMahon 23918 JP Morgan Chase Bank NA 110711 190.00 TOTAL 280.00 0.00 280.00 180-010-000-74700 Safety Program Balance Forward 0.00 180-010-000-75200 Annual Permit Fee Balance Forward 0.00 180-010-000-78100 Meter Expense Balance Forward 0.00 10/20/2011 SYS Womack 23394 JP Morgan Chase Bank NA 102011 4,407.00 TOTAL 4,407.00 0.00 4,407.00 180-010-000-78200 Small Tools Balance Forward 0.00 180-010-000-78300 Safety Equipment Balance Forward 0.00 180-010-000-78500 Furniture/Equipment<$5,000 Balance Forward 0.00 180-010-000-78600 Hardware Balance Forward 0.00 180-010-000-79150 Equipment Rental/Lease Balance Forward 0.00 180-010-000-79400 Bad Debt Expense Balance Forward 0.00 180-010-000-79999 Miscellaneous Expense Balance Forward 0.00 180-010-000-80250 Maintenance and Repairs Balance Forward 0.00 page 5 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 10/14/2011 SYS Concrete/Main breaks 23013 Lattimore Materials Co 426673 200.00 10/20/2011 SYS Womack 23394 JP Morgan Chase Bank NA 102011 350.00 TOTAL 550.00 0.00 550.00 180-010-000-80300 Non-routine Maintenance Balance Forward 0.00 180-010-000-81100 Property Maintenance Balance Forward 0.00 180-010-000-81200 Building Maintenance Balance Forward 0.00 10/11/2011 SYS Fire extinquisher inspections 23019 Kimbrough Fire Extinquisher Co, Inc. 174661 365.50 TOTAL 365.50 0.00 365.50 180-010-000-81300 Vehicle Maintenance Balance Forward 0.00 10/20/2011 SYS McMahon 23394 JP Morgan Chase Bank NA 102011 60.27 10/20/2011 SYS Womack 23394 JP Morgan Chase Bank NA 102011 52.62 TOTAL 112.89 0.00 112.89 180-010-000-81360 Maintenance - Backhoe/Skid Loader Balance Forward 0.00 180-010-000-81500 Lawn Maintenance Balance Forward 0.00 180-010-000-81900 Maintenance Supplies Balance Forward 0.00 10/20/2011 SYS Womack 23394 JP Morgan Chase Bank NA 102011 6.57 10/20/2011 SYS Womack 23394 JP Morgan Chase Bank NA 102011 366.35 10/20/2011 SYS Womack 23394 JP Morgan Chase Bank NA 102011 70.00 10/26/2011 SYS Oct purchases 23437 Costco Wholesale 102611 55.75 TOTAL 498.67 0.00 498.67 180-010-000-91000 Capital Lease Balance Forward 0.00 180-010-000-93200 Vehicles Balance Forward 0.00 180-010-000-93700 Capital Expenses Balance Forward 0.00 10/01/2011 USR Reverse Prepaid-VFD interest payment 22135 597.19 TOTAL 597.19 0.00 597.19 180-010-000-97000 Capital Repairs Balance Forward 0.00 180-010-000-97100 Capital Repairs - Ground Storage Balance Forward 0.00 180-010-000-99100 Transfer to General Fund Balance Forward 0.00 180-010-000-99500 Transfer to Future Replacement Reserve Balance Forward 0.00 180-020-000-40100 Salaries - Regular Balance Forward 0.00 10/13/2011 USR Supplemental Payroll #4 22433 10,000.00 10/13/2011 USR Supplemental Payroll #1 22427 3,298.68 10/13/2011 USR Supplemental Payroll #3 22431 5,739.15 10/14/2011 USR Payroll 10/14/11 23597 6,937.63 10/14/2011 RV Supplemental Payroll 4 - 10/14/11 23639 10,000.00 10/14/2011 USR Supplemental Payroll 1 - 10/14/11 23623 3,298.68 10/14/2011 USR Supplemental Payroll 3 - 10/14/11 23623 5,739.15 10/14/2011 USR Supplemental Payroll 4 - 10/14/11 23623 10,000.00 10/14/2011 RV Supplemental Payroll 1 - 10/14/11 23639 3,298.68 10/14/2011 RV Supplemental Payroll 3 - 10/14/11 23639 5,739.15 10/28/2011 USR Payroll 10/28/11 23603 4,738.51 page 6 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance TOTAL 49,751.80 19,037.83 30,713.97 180-020-000-40130 Salaries - Overtime Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 335.84 10/28/2011 USR Payroll 10/28/11 23603 380.42 TOTAL 716.26 0.00 716.26 180-020-000-40140 Salaries - Longevity Balance Forward 0.00 10/13/2011 USR Supplemental Payroll #2 22429 1,387.50 10/14/2011 USR Supplemental Payroll 2 - 10/14/11 23623 1,387.50 10/14/2011 RV Supplemental Payroll 2 - 10/14/11 23639 1,387.50 TOTAL 2,775.00 1,387.50 1,387.50 180-020-000-40160 Salaries - Certification Balance Forward 0.00 10/13/2011 USR Supplemental Payroll #1 22427 75.00 10/14/2011 USR Supplemental Payroll 1 - 10/14/11 23623 75.00 10/14/2011 RV Supplemental Payroll 1 - 10/14/11 23639 75.00 10/28/2011 USR Payroll 10/28/11 23603 125.00 TOTAL 275.00 75.00 200.00 180-020-000-41200 Retirement Balance Forward 0.00 10/13/2011 USR Supplemental Payroll #1 22427 477.71 10/13/2011 USR Supplemental Payroll #2 22429 196.47 10/13/2011 USR Supplemental Payroll #3 22431 812.66 10/13/2011 USR Supplemental Payroll #4 22433 1,416.00 10/14/2011 RV Supplemental Payroll 2 - 10/14/11 23639 196.47 10/14/2011 RV Supplemental Payroll 3 - 10/14/11 23639 812.66 10/14/2011 USR Payroll 10/14/11 23597 1,029.93 10/14/2011 USR Supplemental Payroll 1 - 10/14/11 23623 477.71 10/14/2011 RV Supplemental Payroll 4 - 10/14/11 23639 1,416.00 10/14/2011 RV Supplemental Payroll 1 - 10/14/11 23639 477.71 10/14/2011 USR Supplemental Payroll 2 - 10/14/11 23623 196.47 10/14/2011 USR Supplemental Payroll 3 - 10/14/11 23623 812.66 10/14/2011 USR Supplemental Payroll 4 - 10/14/11 23623 1,416.00 10/28/2011 USR Payroll 10/28/11 23603 742.54 TOTAL 7,578.15 2,902.84 4,675.31 180-020-000-41210 Medical Insurance Balance Forward 0.00 10/13/2011 USR Supplemental Payroll #1 22427 376.13 10/14/2011 USR Payroll 10/14/11 23597 1,243.47 10/14/2011 USR Supplemental Payroll 1 - 10/14/11 23623 376.13 page 7 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 10/14/2011 RV Supplemental Payroll 1 - 10/14/11 23639 376.13 10/28/2011 USR Payroll 10/28/11 23603 867.34 TOTAL 2,863.07 376.13 2,486.94 180-020-000-41215 Dental Insurance Balance Forward 0.00 10/13/2011 USR Supplemental Payroll #1 22427 24.51 10/14/2011 USR Payroll 10/14/11 23597 92.98 10/14/2011 USR Supplemental Payroll 1 - 10/14/11 23623 24.51 10/14/2011 RV Supplemental Payroll 1 - 10/14/11 23639 24.51 10/28/2011 USR Payroll 10/28/11 23603 68.47 TOTAL 210.47 24.51 185.96 180-020-000-41216 Vision Insurance Balance Forward 0.00 10/13/2011 USR Supplemental Payroll #1 22427 5.74 10/14/2011 USR Payroll 10/14/11 23597 22.96 10/14/2011 USR Supplemental Payroll 1 - 10/14/11 23623 5.74 10/14/2011 RV Supplemental Payroll 1 - 10/14/11 23639 5.74 10/28/2011 USR Payroll 10/28/11 23603 17.22 TOTAL 51.66 5.74 45.92 180-020-000-41218 Life Insurance & Other Balance Forward 0.00 180-020-000-42220 Social Security Taxes Balance Forward 0.00 10/13/2011 USR Supplemental Payroll #1 22427 185.45 10/13/2011 USR Supplemental Payroll #2 22429 86.03 10/13/2011 USR Supplemental Payroll #3 22431 355.82 10/13/2011 USR Supplemental Payroll #4 22433 620.00 10/14/2011 USR Supplemental Payroll 1 - 10/14/11 23623 185.45 10/14/2011 USR Supplemental Payroll 2 - 10/14/11 23623 86.03 10/14/2011 USR Supplemental Payroll 3 - 10/14/11 23623 355.82 10/14/2011 USR Supplemental Payroll 4 - 10/14/11 23623 620.00 10/14/2011 USR Payroll 10/14/11 23597 382.18 10/14/2011 RV Supplemental Payroll 2 - 10/14/11 23639 86.03 10/14/2011 RV Supplemental Payroll 3 - 10/14/11 23639 355.82 10/14/2011 RV Supplemental Payroll 4 - 10/14/11 23639 620.00 10/14/2011 RV Supplemental Payroll 1 - 10/14/11 23639 185.45 10/28/2011 USR Payroll 10/28/11 23603 280.30 TOTAL 3,157.08 1,247.30 1,909.78 180-020-000-42225 Medicare Taxes Balance Forward 0.00 10/13/2011 USR Supplemental Payroll #1 22427 43.37 page 8 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 10/13/2011 USR Supplemental Payroll #2 22429 20.12 10/13/2011 USR Supplemental Payroll #3 22431 83.22 10/13/2011 USR Supplemental Payroll #4 22433 145.00 10/14/2011 RV Supplemental Payroll 1 - 10/14/11 23639 43.37 10/14/2011 RV Supplemental Payroll 2 - 10/14/11 23639 20.12 10/14/2011 USR Supplemental Payroll 1 - 10/14/11 23623 43.37 10/14/2011 RV Supplemental Payroll 3 - 10/14/11 23639 83.22 10/14/2011 RV Supplemental Payroll 4 - 10/14/11 23639 145.00 10/14/2011 USR Supplemental Payroll 2 - 10/14/11 23623 20.12 10/14/2011 USR Supplemental Payroll 3 - 10/14/11 23623 83.22 10/14/2011 USR Supplemental Payroll 4 - 10/14/11 23623 145.00 10/14/2011 USR Payroll 10/14/11 23597 89.38 10/28/2011 USR Payroll 10/28/11 23603 65.55 TOTAL 738.35 291.71 446.64 180-020-000-42250 Unemployment Taxes Balance Forward 0.00 180-020-000-42260 Workman's Compensation Balance Forward 0.00 10/01/2011 SYS Workers Comp 22481 TML Intergovernmental Risk 3411/MUD W/C 2,685.00 TOTAL 2,685.00 0.00 2,685.00 180-020-000-42960 Employee Relations Balance Forward 0.00 180-020-000-50500 Engineering Balance Forward 0.00 180-020-000-52400 Lab Analysis Balance Forward 0.00 10/20/2011 SYS Richey 23394 JP Morgan Chase Bank NA 102011 139.57 10/20/2011 SYS Slaght 23394 JP Morgan Chase Bank NA 102011 935.00 TOTAL 1,074.57 0.00 1,074.57 180-020-000-57000 Independent Labor Balance Forward 0.00 180-020-000-60100 Office Supplies Balance Forward 0.00 180-020-000-60300 Postage Balance Forward 0.00 180-020-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 10/31/2011 SYS Slaght 23918 JP Morgan Chase Bank NA 110711 438.17 TOTAL 438.17 0.00 438.17 180-020-000-61000 Fuel Balance Forward 0.00 180-020-000-62100 Uniforms Balance Forward 0.00 180-020-000-62300 Chemicals Balance Forward 0.00 10/31/2011 SYS Womack 23918 JP Morgan Chase Bank NA 110711 1,350.00 TOTAL 1,350.00 0.00 1,350.00 180-020-000-62800 Lab Supplies Balance Forward 0.00 180-020-000-62900 Other Consumables Balance Forward 0.00 180-020-000-72100 Electricity/Gas Balance Forward 0.00 10/13/2011 SYS Electricity/Oct 22475 Hudson Energy 17358 Oct 7,574.14 TOTAL 7,574.14 0.00 7,574.14 180-020-000-72200 Water Balance Forward 0.00 page 9 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 180-020-000-72400 Dumpster Services Balance Forward 0.00 10/29/2011 SYS Sludge Haul off 23465 L.H. Chaney Materials, Inc 40316 1,612.50 TOTAL 1,612.50 0.00 1,612.50 180-020-000-73100 Telephone Balance Forward 0.00 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 2.81 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 3.39 TOTAL 6.20 0.00 6.20 180-020-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 180-020-000-74200 Travel & per diem Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 46.62 10/28/2011 USR Payroll 10/28/11 23603 69.93 TOTAL 116.55 0.00 116.55 180-020-000-74300 Schools & Training Balance Forward 0.00 180-020-000-74700 Safety Program Balance Forward 0.00 180-020-000-75200 Annual Permit Fee Balance Forward 0.00 10/31/2011 SYS WW Permit fee 23677 Texas Commission Environmental Quality CWQ0033886 7,432.50 TOTAL 7,432.50 0.00 7,432.50 180-020-000-78200 Small Tools Balance Forward 0.00 180-020-000-78300 Safety Equipment Balance Forward 0.00 180-020-000-78600 Hardware Balance Forward 0.00 180-020-000-79150 Equipment Rental/Lease Balance Forward 0.00 180-020-000-79999 Miscellaneous Expense Balance Forward 0.00 180-020-000-80250 Maintenance and Repairs Balance Forward 0.00 10/17/2011 SYS Site visit, assess UV system for defects 23027 Newman Regency Group, Inc4713 1,712.50 10/20/2011 SYS Richey 23394 JP Morgan Chase Bank NA 102011 37.96 10/20/2011 SYS Rodney Greenwood 23394 JP Morgan Chase Bank NA 102011 26.58 10/31/2011 SYS Womack 23918 JP Morgan Chase Bank NA 110711 1,249.99 10/31/2011 SYS Womack 23918 JP Morgan Chase Bank NA 110711 23.94 10/31/2011 SYS Richey 23918 JP Morgan Chase Bank NA 110711 11.96 10/31/2011 SYS Richey 23918 JP Morgan Chase Bank NA 110711 58.01 TOTAL 3,120.94 0.00 3,120.94 180-020-000-81100 Property Maintenance Balance Forward 0.00 180-020-000-81200 Building Maintenance Balance Forward 0.00 180-020-000-81300 Vehicle Maintenance Balance Forward 0.00 180-020-000-81360 Maintenance - Backhoe/Skid Loader Balance Forward 0.00 180-020-000-81500 Lawn Maintenance Balance Forward 0.00 180-020-000-81900 Maintenance Supplies Balance Forward 0.00 10/20/2011 SYS Slaght 23394 JP Morgan Chase Bank NA 102011 20.62 10/26/2011 SYS Oct purchases 23437 Costco Wholesale 102611 36.03 10/31/2011 SYS Womack 23918 JP Morgan Chase Bank NA 110711 50.61 10/31/2011 SYS Womack 23918 JP Morgan Chase Bank NA 110711 47.88 TOTAL 155.14 0.00 155.14 180-020-000-93700 Capital Expenses Balance Forward 0.00 180-020-000-97000 Capital Repairs Balance Forward 0.00 180-021-000-40100 Salaries - Regular Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 5,541.08 10/28/2011 USR Payroll 10/28/11 23603 5,541.08 page 10 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance TOTAL 11,082.16 0.00 11,082.16 180-021-000-40130 Salaries - Overtime Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 473.16 10/28/2011 USR Payroll 10/28/11 23603 178.56 TOTAL 651.72 0.00 651.72 180-021-000-40140 Salaries - Longevity Balance Forward 0.00 180-021-000-40160 Salaries - Certification Balance Forward 0.00 10/28/2011 USR Payroll 10/28/11 23603 125.00 TOTAL 125.00 0.00 125.00 180-021-000-41200 Retirement Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 851.62 10/28/2011 USR Payroll 10/28/11 23603 827.60 TOTAL 1,679.22 0.00 1,679.22 180-021-000-41210 Medical Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 851.34 10/28/2011 USR Payroll 10/28/11 23603 851.34 TOTAL 1,702.68 0.00 1,702.68 180-021-000-41215 Dental Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 58.69 10/28/2011 USR Payroll 10/28/11 23603 58.69 TOTAL 117.38 0.00 117.38 180-021-000-41216 Vision Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 14.86 10/28/2011 USR Payroll 10/28/11 23603 14.86 TOTAL 29.72 0.00 29.72 180-021-000-41218 Life Insurance & Other Balance Forward 0.00 180-021-000-42220 Social Security Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 343.39 10/28/2011 USR Payroll 10/28/11 23603 332.88 TOTAL 676.27 0.00 676.27 180-021-000-42225 Medicare Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 80.31 10/28/2011 USR Payroll 10/28/11 23603 77.85 TOTAL 158.16 0.00 158.16 180-021-000-42250 Unemployment Taxes Balance Forward 0.00 180-021-000-42260 Workman's Compensation Balance Forward 0.00 10/01/2011 SYS Workers Comp 22481 TML Intergovernmental Risk 3411/MUD W/C 3,056.00 TOTAL 3,056.00 0.00 3,056.00 180-021-000-42960 Employee Relations Balance Forward 0.00 180-021-000-50500 Engineering Balance Forward 0.00 180-021-000-57000 Independent Labor Balance Forward 0.00 180-021-000-60300 Postage Balance Forward 0.00 180-021-000-61000 Fuel Balance Forward 0.00 180-021-000-62100 Uniforms Balance Forward 0.00 180-021-000-62300 Chemicals Balance Forward 0.00 180-021-000-72100 Electricity/Gas Balance Forward 0.00 10/04/2011 SYS Electricity/Oct 22485 Tri County Electric 2009888001 Oct 34.50 10/04/2011 SYS Electricity/Oct 22489 Tri County Electric 2209888001 Oct 18.98 10/13/2011 SYS Electricity Oct 22783 Hudson Energy 17358-b 155.36 page 11 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 10/13/2011 SYS Electricity/Oct 22463 Hudson Energy 17357 Oct 364.22 10/13/2011 SYS Electricity/Oct 22475 Hudson Energy 17358 Oct 72.42 TOTAL 645.48 0.00 645.48 180-021-000-72200 Water Balance Forward 0.00 180-021-000-73100 Telephone Balance Forward 0.00 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 2.52 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 0.71 TOTAL 3.23 0.00 3.23 180-021-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 180-021-000-74100 Dues & Membership Balance Forward 0.00 180-021-000-74200 Travel & per diem Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 80.48 10/28/2011 USR Payroll 10/28/11 23603 16.10 TOTAL 96.58 0.00 96.58 180-021-000-74300 Schools & Training Balance Forward 0.00 180-021-000-74700 Safety Program Balance Forward 0.00 180-021-000-78200 Small Tools Balance Forward 0.00 180-021-000-78300 Safety Equipment Balance Forward 0.00 180-021-000-78600 Hardware Balance Forward 0.00 180-021-000-79150 Equipment Rental/Lease Balance Forward 0.00 180-021-000-79999 Miscellaneous Expense Balance Forward 0.00 180-021-000-80250 Maintenance and Repairs Balance Forward 0.00 10/31/2011 SYS Womack 23918 JP Morgan Chase Bank NA 110711 118.65 10/31/2011 SYS Womack 23918 JP Morgan Chase Bank NA 110711 39.80 TOTAL 158.45 0.00 158.45 180-021-000-81100 Property Maintenance Balance Forward 0.00 180-021-000-81200 Building Maintenance Balance Forward 0.00 180-021-000-81300 Vehicle Maintenance Balance Forward 0.00 10/31/2011 SYS Womack 23918 JP Morgan Chase Bank NA 110711 130.00 TOTAL 130.00 0.00 130.00 180-021-000-81900 Maintenance Supplies Balance Forward 0.00 180-021-000-93700 Capital Expenses Balance Forward 0.00 180-021-000-97000 Capital Repairs Balance Forward 0.00 180-130-000-40100 Salaries - Regular Balance Forward 0.00 10/28/2011 USR Payroll 10/28/11 23603 800.00 TOTAL 800.00 0.00 800.00 180-130-000-42220 Social Security Taxes Balance Forward 0.00 10/28/2011 USR Payroll 10/28/11 23603 49.60 TOTAL 49.60 0.00 49.60 180-130-000-42225 Medicare Taxes Balance Forward 0.00 10/28/2011 USR Payroll 10/28/11 23603 11.60 TOTAL 11.60 0.00 11.60 180-130-000-42250 Unemployment Taxes Balance Forward 0.00 10/28/2011 USR Payroll 10/28/11 23603 6.40 TOTAL 6.40 0.00 6.40 180-130-000-42260 Workman's Compensation Balance Forward 0.00 10/01/2011 SYS Workers Comp 22481 TML Intergovernmental Risk 3411/MUD W/C 120.00 TOTAL 120.00 0.00 120.00 180-130-000-50100 Professional Outside Services Balance Forward 0.00 page 12 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 180-130-000-60100 Office Supplies Balance Forward 0.00 180-130-000-60300 Postage Balance Forward 0.00 180-130-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 180-130-000-73300 Advertising Balance Forward 0.00 180-130-000-73400 Printing Balance Forward 0.00 180-130-000-74100 Dues & Membership Balance Forward 0.00 10/07/2011 SYS 11-12 Dues/Jim Moss 22713 North Central Texas COG 66589 100.00 TOTAL 100.00 0.00 100.00 180-130-000-74200 Travel & per diem Balance Forward 0.00 180-130-000-74300 Schools & Training Balance Forward 0.00 10/20/2011 SYS Slaght 23394 JP Morgan Chase Bank NA 102011 80.00 TOTAL 80.00 0.00 80.00 180-130-000-74600 Meetings Balance Forward 0.00 10/05/2011 SYS Chamber luncheon 21859 Northwest Metroport Chamber 8228 44.00 TOTAL 44.00 0.00 44.00 180-130-000-79999 Miscellaneous Expense Balance Forward 0.00 180-130-000-87110 Water Conservation Program/Public Information Balance Forward 0.00 180-140-000-40100 Salaries - Regular Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 6,826.94 10/28/2011 USR Payroll 10/28/11 23603 6,826.94 TOTAL 13,653.88 0.00 13,653.88 180-140-000-40130 Salaries - Overtime Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 72.59 10/28/2011 USR Payroll 10/28/11 23603 128.77 TOTAL 201.36 0.00 201.36 180-140-000-40140 Salaries - Longevity Balance Forward 0.00 180-140-000-41200 Retirement Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 977.00 10/28/2011 USR Payroll 10/28/11 23603 984.92 TOTAL 1,961.92 0.00 1,961.92 180-140-000-41210 Medical Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 634.68 10/28/2011 USR Payroll 10/28/11 23603 634.44 TOTAL 1,269.12 0.00 1,269.12 180-140-000-41215 Dental Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 47.32 10/28/2011 USR Payroll 10/28/11 23603 47.30 TOTAL 94.62 0.00 94.62 180-140-000-41216 Vision Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 12.00 10/28/2011 USR Payroll 10/28/11 23603 11.98 TOTAL 23.98 0.00 23.98 180-140-000-41218 Life Insurance & Other Balance Forward 0.00 180-140-000-42220 Social Security Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 406.73 10/28/2011 USR Payroll 10/28/11 23603 410.36 TOTAL 817.09 0.00 817.09 180-140-000-42225 Medicare Taxes Balance Forward 0.00 page 13 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 10/14/2011 USR Payroll 10/14/11 23597 95.12 10/28/2011 USR Payroll 10/28/11 23603 95.98 TOTAL 191.10 0.00 191.10 180-140-000-42250 Unemployment Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 4.96 10/28/2011 USR Payroll 10/28/11 23603 4.98 TOTAL 9.94 0.00 9.94 180-140-000-42260 Workman's Compensation Balance Forward 0.00 10/01/2011 SYS Workers Comp 22481 TML Intergovernmental Risk 3411/MUD W/C 580.00 TOTAL 580.00 0.00 580.00 180-140-000-42290 Pre-employment Physicals/Testing Balance Forward 0.00 180-140-000-42960 Employee Relations Balance Forward 0.00 10/20/2011 SYS Slaght 23394 JP Morgan Chase Bank NA 102011 39.00 10/26/2011 SYS Oct purchases 23437 Costco Wholesale 102611 8.62 10/31/2011 SYS Slaght 23918 JP Morgan Chase Bank NA 110711 8.95 TOTAL 56.57 0.00 56.57 180-140-000-50100 Professional Outside Services Balance Forward 0.00 180-140-000-52100 Elections Balance Forward 0.00 180-140-000-54200 Records Management Balance Forward 0.00 180-140-000-57000 Independent Labor Balance Forward 0.00 10/18/2011 SYS Record MUD meeting 22715 Miguel Cruz 101811 33.75 TOTAL 33.75 0.00 33.75 180-140-000-60100 Office Supplies Balance Forward 0.00 10/11/2011 SYS Office supplies 22723 Office Depot 582481044001 95.27 10/11/2011 SYS Office Supplies 22721 Office Depot 582481148001 7.62 10/19/2011 SYS Office Supples 23017 Office Depot 583522193001 8.99 10/19/2011 SYS Office Supplies 23015 Office Depot 583521795001 5.78 TOTAL 117.66 0.00 117.66 180-140-000-60300 Postage Balance Forward 0.00 10/17/2011 SYS TCEQ 23035 Federal Express Corp 7-667-84483 28.91 10/20/2011 SYS Permit 3 renewal 23039 U.S. Postal Service permit 3 190.00 10/31/2011 USR Oct Postage meter usage 23781 19.01 TOTAL 237.92 0.00 237.92 180-140-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 180-140-000-73100 Telephone Balance Forward 0.00 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 17.29 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 23.08 TOTAL 40.37 0.00 40.37 180-140-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 180-140-000-73300 Advertising Balance Forward 0.00 180-140-000-73400 Printing Balance Forward 0.00 180-140-000-73600 Service Charges & Fees Balance Forward 0.00 180-140-000-74100 Dues & Membership Balance Forward 0.00 10/31/2011 SYS Slaght 23918 JP Morgan Chase Bank NA 110711 250.00 TOTAL 250.00 0.00 250.00 180-140-000-74200 Travel & per diem Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 29.08 10/28/2011 USR Payroll 10/28/11 23603 7.77 TOTAL 36.85 0.00 36.85 page 14 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 180-140-000-74300 Schools & Training Balance Forward 0.00 10/31/2011 SYS Slaght 23918 JP Morgan Chase Bank NA 110711 130.00 TOTAL 130.00 0.00 130.00 180-140-000-74600 Meetings Balance Forward 0.00 180-140-000-76700 July 4 Celebration Balance Forward 0.00 180-140-000-78500 Furniture/Equipment<$5,000 Balance Forward 0.00 180-140-000-79999 Miscellaneous Expense Balance Forward 0.00 180-611-000-40100 Salaries - Regular Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 3,750.00 10/28/2011 USR Payroll 10/28/11 23603 3,750.00 TOTAL 7,500.00 0.00 7,500.00 180-611-000-40130 Salaries - Overtime Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 64.81 10/28/2011 USR Payroll 10/28/11 23603 122.97 TOTAL 187.78 0.00 187.78 180-611-000-40140 Salaries - Longevity Balance Forward 0.00 180-611-000-41200 Retirement Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 540.17 10/28/2011 USR Payroll 10/28/11 23603 548.41 TOTAL 1,088.58 0.00 1,088.58 180-611-000-41210 Medical Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 460.50 10/28/2011 USR Payroll 10/28/11 23603 460.85 TOTAL 921.35 0.00 921.35 180-611-000-41215 Dental Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 36.73 10/28/2011 USR Payroll 10/28/11 23603 36.76 TOTAL 73.49 0.00 73.49 180-611-000-41216 Vision Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 6.24 10/28/2011 USR Payroll 10/28/11 23603 6.25 TOTAL 12.49 0.00 12.49 180-611-000-41218 Life Insurance & Other Balance Forward 0.00 180-611-000-42220 Social Security Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 202.42 10/28/2011 USR Payroll 10/28/11 23603 206.01 TOTAL 408.43 0.00 408.43 180-611-000-42225 Medicare Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 47.35 10/28/2011 USR Payroll 10/28/11 23603 48.17 TOTAL 95.52 0.00 95.52 180-611-000-42250 Unemployment Taxes Balance Forward 0.00 180-611-000-42260 Workman's Compensation Balance Forward 0.00 10/01/2011 SYS Workers Comp 22481 TML Intergovernmental Risk 3411/MUD W/C 211.00 TOTAL 211.00 0.00 211.00 180-611-000-42290 Pre-employment Physicals/Testing Balance Forward 0.00 180-611-000-50100 Professional Outside Services Balance Forward 0.00 180-611-000-60100 Office Supplies Balance Forward 0.00 180-611-000-60300 Postage Balance Forward 0.00 page 15 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 10/31/2011 USR Oct Postage meter usage 23781 33.44 TOTAL 33.44 0.00 33.44 180-611-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 180-611-000-73100 Telephone Balance Forward 0.00 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 10.49 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 0.95 TOTAL 11.44 0.00 11.44 180-611-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 180-611-000-73300 Advertising Balance Forward 0.00 180-611-000-73400 Printing Balance Forward 0.00 180-611-000-73600 Service Charges & Fees Balance Forward 0.00 180-611-000-74100 Dues & Membership Balance Forward 0.00 180-611-000-74200 Travel & per diem Balance Forward 0.00 10/28/2011 USR Payroll 10/28/11 23603 15.04 TOTAL 15.04 0.00 15.04 180-611-000-74300 Schools & Training Balance Forward 0.00 180-611-000-74600 Meetings Balance Forward 0.00 10/05/2011 SYS Chamber luncheon 21859 Northwest Metroport Chamber 8228 22.00 TOTAL 22.00 0.00 22.00 180-611-000-78500 Furniture/Equipment<$5,000 Balance Forward 0.00 180-611-000-79999 Miscellaneous Expense Balance Forward 0.00 180-620-000-40100 Salaries - Regular Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 3,281.16 10/28/2011 USR Payroll 10/28/11 23603 3,294.60 TOTAL 6,575.76 0.00 6,575.76 180-620-000-40130 Salaries - Overtime Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 11.24 10/28/2011 USR Payroll 10/28/11 23603 13.71 TOTAL 24.95 0.00 24.95 180-620-000-40140 Salaries - Longevity Balance Forward 0.00 180-620-000-41200 Retirement Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 466.19 10/28/2011 USR Payroll 10/28/11 23603 468.46 TOTAL 934.65 0.00 934.65 180-620-000-41210 Medical Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 462.18 10/28/2011 USR Payroll 10/28/11 23603 462.18 TOTAL 924.36 0.00 924.36 180-620-000-41215 Dental Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 45.83 10/28/2011 USR Payroll 10/28/11 23603 45.83 TOTAL 91.66 0.00 91.66 180-620-000-41216 Vision Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 10.81 10/28/2011 USR Payroll 10/28/11 23603 10.82 TOTAL 21.63 0.00 21.63 180-620-000-41218 Life Insurance & Other Balance Forward 0.00 180-620-000-42220 Social Security Taxes Balance Forward 0.00 page 16 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 10/14/2011 USR Payroll 10/14/11 23597 186.08 10/28/2011 USR Payroll 10/28/11 23603 187.40 TOTAL 373.48 0.00 373.48 180-620-000-42225 Medicare Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 43.51 10/28/2011 USR Payroll 10/28/11 23603 43.83 TOTAL 87.34 0.00 87.34 180-620-000-42250 Unemployment Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 4.98 10/28/2011 USR Payroll 10/28/11 23603 5.00 TOTAL 9.98 0.00 9.98 180-620-000-42260 Workman's Compensation Balance Forward 0.00 10/01/2011 SYS Workers Comp 22481 TML Intergovernmental Risk 3411/MUD W/C 235.00 TOTAL 235.00 0.00 235.00 180-620-000-42290 Pre-employment Physicals/Testing Balance Forward 0.00 180-620-000-56200 Utility Billing Contract Balance Forward 0.00 10/29/2011 SYS October water billing 23894 CSG Systems, Inc. 75607 917.72 TOTAL 917.72 0.00 917.72 180-620-000-57000 Independent Labor Balance Forward 0.00 180-620-000-60100 Office Supplies Balance Forward 0.00 10/11/2011 SYS Office supplies 22723 Office Depot 582481044001 2.82 10/19/2011 SYS Office Supplies 23015 Office Depot 583521795001 13.22 10/31/2011 SYS Kari 23918 JP Morgan Chase Bank NA 110711 23.90 TOTAL 39.94 0.00 39.94 180-620-000-60300 Postage Balance Forward 0.00 10/29/2011 SYS October water billing 23894 CSG Systems, Inc. 75607 1,403.12 TOTAL 1,403.12 0.00 1,403.12 180-620-000-73100 Telephone Balance Forward 0.00 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 11.20 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 9.71 TOTAL 20.91 0.00 20.91 180-620-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 180-620-000-73400 Printing Balance Forward 0.00 180-620-000-73600 Service Charges & Fees Balance Forward 0.00 10/05/2011 USR World Pay Credit card fees 23320 1,986.91 10/05/2011 USR World Pay Credit card fees 23320 1,169.60 10/05/2011 USR World Pay Credit card fees 23320 9.99 TOTAL 3,166.50 0.00 3,166.50 180-620-000-74100 Dues & Membership Balance Forward 0.00 180-620-000-74200 Travel & per diem Balance Forward 0.00 180-620-000-74300 Schools & Training Balance Forward 0.00 180-620-000-75600 TCEQ Annual Assessment Fee Balance Forward 0.00 180-620-000-79999 Miscellaneous Expense Balance Forward 0.00 180-620-000-99100 Transfer to General Fund Balance Forward 0.00 180-630-000-42290 Pre-employment Physicals/Testing Balance Forward 0.00 180-630-000-42960 Employee Relations Balance Forward 0.00 10/31/2011 SYS Huggins 23918 JP Morgan Chase Bank NA 110711 40.47 10/31/2011 SYS Huggins 23918 JP Morgan Chase Bank NA 110711 9.64 TOTAL 50.11 0.00 50.11 page 17 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 180-630-000-43240 Tuition Reimbursement Balance Forward 0.00 180-630-000-60100 Office Supplies Balance Forward 0.00 180-630-000-60300 Postage Balance Forward 0.00 180-630-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 180-630-000-73100 Telephone Balance Forward 0.00 180-630-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 180-630-000-73400 Printing Balance Forward 0.00 180-630-000-74100 Dues & Membership Balance Forward 0.00 180-630-000-74200 Travel & per diem Balance Forward 0.00 180-630-000-74300 Schools & Training Balance Forward 0.00 180-630-000-74600 Meetings Balance Forward 0.00 180-630-000-99100 Transfer to General Fund Balance Forward 0.00 180-640-000-50700 Security Balance Forward 0.00 180-640-000-55000 Software & Support Balance Forward 0.00 10/19/2011 SYS Texas Parks & Wildlife video for Channel 23021 City of Waco 101911 25.00 10/27/2011 SYS Pastor 23646 Bank of America 102711 25.00 10/27/2011 SYS Pastor 23646 Bank of America 102711 800.00 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 373.70 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 54.99 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 53.38 10/28/2011 SYS Format HD for old Admkyocera 23681 Technifax Office Solutions 92820A 47.50 10/28/2011 SYS Format HD for old PWkyocera 23892 Technifax Office Solutions 92821A 47.50 10/31/2011 SYS Gonzales 23918 JP Morgan Chase Bank NA 110711 320.69 TOTAL 1,747.76 0.00 1,747.76 180-640-000-57000 Independent Labor Balance Forward 0.00 10/26/2011 SYS VPN configuration of firewall 23471 Acclaim Networks LLC 69740 218.75 TOTAL 218.75 0.00 218.75 180-640-000-60100 Office Supplies Balance Forward 0.00 180-640-000-60200 Printer Supplies Balance Forward 0.00 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 85.38 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 504.50 TOTAL 589.88 0.00 589.88 180-640-000-73100 Telephone Balance Forward 0.00 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 453.70 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 364.55 TOTAL 818.25 0.00 818.25 180-640-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 180-640-000-74200 Travel & per diem Balance Forward 0.00 180-640-000-75900 Prompt Payment Interest Balance Forward 0.00 180-640-000-78600 Hardware Balance Forward 0.00 10/18/2011 SYS Data jacks and wall plates 23023 SHI Governmental Solutions GB00044989 17.70 10/20/2011 SYS Wall Plates 23671 SHI Governmental Solutions GB00045158 1.12 10/21/2011 SYS Blank for wall plates 23673 SHI Governmental Solutions GB00045232 1.20 10/26/2011 SYS UPS 23675 SHI Governmental Solutions GB00045435 333.50 10/27/2011 SYS Pastor 23646 Bank of America 102711 684.74 10/27/2011 SYS Pastor 23646 Bank of America 102711 78.49 10/27/2011 SYS Pastor 23646 Bank of America 102711 25.00 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 509.21 page 18 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 114.99 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 259.98 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 105.75 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 7.68 TOTAL 2,139.36 0.00 2,139.36 180-640-000-79100 Copier Rental/Lease Balance Forward 0.00 180-640-000-99100 Transfer to General Fund Balance Forward 0.00 180-640-000-99500 Transfer to Future Replacement Reserve Balance Forward 0.00 180-710-000-40100 Salaries - Regular Balance Forward 0.00 180-710-000-41200 Retirement Balance Forward 0.00 180-710-000-41210 Medical Insurance Balance Forward 0.00 180-710-000-41215 Dental Insurance Balance Forward 0.00 180-710-000-41216 Vision Insurance Balance Forward 0.00 180-710-000-41218 Life Insurance & Other Balance Forward 0.00 180-710-000-42220 Social Security Taxes Balance Forward 0.00 180-710-000-42225 Medicare Taxes Balance Forward 0.00 180-710-000-42250 Unemployment Taxes Balance Forward 0.00 180-710-000-42260 Workman's Compensation Balance Forward 0.00 10/01/2011 SYS Workers Comp 22481 TML Intergovernmental Risk 3411/MUD W/C 861.00 TOTAL 861.00 0.00 861.00 180-710-000-42290 Pre-employment Physicals/Testing Balance Forward 0.00 180-710-000-52400 Lab Analysis Balance Forward 0.00 180-710-000-62520 Vending Machine Supplies Balance Forward 0.00 10/26/2011 SYS Oct purchases 23437 Costco Wholesale 102611 5.24 10/26/2011 SYS Oct purchases 23437 Costco Wholesale 102611 14.45 TOTAL 19.69 0.00 19.69 180-710-000-72100 Electricity/Gas Balance Forward 0.00 10/13/2011 SYS Electricity/Oct 23433 Direct Energy Business Svcs 1171980 Oct 427.45 TOTAL 427.45 0.00 427.45 180-710-000-72200 Water Balance Forward 0.00 180-710-000-75000 Insurance Balance Forward 0.00 10/01/2011 SYS 2011-12 Insurance renewal 21871 TML Intergovernmental Risk 100111 28,539.50 10/01/2011 SYS Bond/Gonzales 22495 Victor O Schinnerer & Co, Inc$110055683 50.00 TOTAL 28,589.50 0.00 28,589.50 180-710-000-78500 Furniture/Equipment<$5,000 Balance Forward 0.00 180-710-000-79200 Building Rental/Lease Balance Forward 0.00 10/01/2011 SYS Public Services Bldg rent 21883 Town of Trophy Club 100111 1,098.51 TOTAL 1,098.51 0.00 1,098.51 180-710-000-81200 Building Maintenance Balance Forward 0.00 10/20/2011 SYS Womack 23394 JP Morgan Chase Bank NA 102011 31.98 TOTAL 31.98 0.00 31.98 180-710-000-81600 Cleaning Services Balance Forward 0.00 10/01/2011 SYS October Janitorial service 21835 ABM Janitorial Services, Inc 3022546 559.50 10/20/2011 SYS Slaght 23394 JP Morgan Chase Bank NA 102011 118.68 TOTAL 678.18 0.00 678.18 180-710-000-81900 Maintenance Supplies Balance Forward 0.00 10/20/2011 SYS Huggins 23394 JP Morgan Chase Bank NA 102011 43.26 10/20/2011 SYS Slaght 23394 JP Morgan Chase Bank NA 102011 58.50 10/26/2011 SYS Oct purchases 23437 Costco Wholesale 102611 17.25 page 19 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 10/26/2011 SYS Oct purchases 23437 Costco Wholesale 102611 31.25 10/31/2011 SYS Womack 23918 JP Morgan Chase Bank NA 110711 17.96 TOTAL 168.22 0.00 168.22 180-710-000-93300 Equipment Balance Forward 0.00 180-810-000-50200 Auditing Balance Forward 0.00 10/01/2011 SYS Audit Interim Fieldwork 22477 Lafollett & Company PLLC 100111Interim 5,050.00 TOTAL 5,050.00 0.00 5,050.00 180-810-000-50300 Legal Balance Forward 0.00 180-810-000-51100 Appraisal Balance Forward 0.00 10/18/2011 SYS Annual Tax admin 23037 Tarrant Appraisal District 101811 3,060.83 TOTAL 3,060.83 0.00 3,060.83 180-810-000-51150 Tax Administration Balance Forward 0.00 180-810-000-99510 Transfer to Fire Construction Fund Balance Forward 0.00 GRAND TOTAL 265,913.23 573,625.84 307,712.61CR Journal # Name Description Debit Credit 23097 MUD 1 AV Taxes MUD 1 AV Taxes 595.00 595.00 23107 MUD 1 AV Taxes MUD 1 AV Taxes 12,814.43 12,814.43 23099 MUD 1 AV Taxes MUD 1 AV Taxes 1,869.62 1,869.62 23101 MUD 1 AV Taxes MUD 1 AV Taxes 576.28 576.28 23103 MUD 1 AV Taxes MUD 1 AV Taxes 1,445.50 1,445.50 23105 MUD 1 AV Taxes MUD 1 AV Taxes 1,608.02 1,608.02 23109 MUD 1 AV Taxes MUD 1 AV Taxes 1,347.72 1,347.72 23113 MUD 1 AV Taxes MUD 1 AV Taxes 795.38 795.38 23318 MUD 1 AV Taxes MUD 1 AV Taxes 3,658.17 3,658.17 23399 MUD 1 AV Taxes MUD 1 AV Taxes 680.92 680.92 23609 rev-JE23093 AV Taxes rev-JE23093 AV Taxes 1,113.48 1,113.48 23611 MUD 1 AV Taxes Corrected of JE 23093 MUD 1 AV Taxes Corrected of JE 23093 1,113.50 1,113.50 22991 FKA2 AV Taxes FKA2 AV Taxes 1,852.51 1,852.51 23093 MUD 1 AV Taxes MUD 1 AV Taxes 1,113.48 1,113.48 23095 MUD 1 AV Taxes MUD 1 AV Taxes 854.50 854.50 23605 October Bank interest October Bank interest 478.75 478.75 22921 AT&T Cell Tower lease/Oct AT&T Cell Tower lease/Oct 1,694.00 1,694.00 22935 Town/Oct Maint Barn rent Town/Oct Maint Barn rent 1,166.66 1,166.66 22931 Moore-ORR Moore-ORR 32.00 32.00 22939 Moore/ORR Moore/ORR 2.00 2.00 23322 UB 10/6/11 Adjustments UB 10/6/11 Adjustments 1,325.00 1,325.00 23215 UB Penalty Adjustments UB Penalty Adjustments 266.73 266.73 23227 UB Adjustments UB Adjustments 33.80 33.80 23306 Oct Utility billing Oct Utility billing 530,585.14 530,585.14 23308 UB Credit Adjustments/Oct UB Credit Adjustments/Oct 4,933.67 4,933.67 23157 UB Adjustments UB Adjustments 4,045.57 4,045.57 23221 UB Late Fees UB Late Fees 8,195.54 8,195.54 22933 Club Corp/Sept Effluent Club Corp/Sept Effluent 27,701.18 27,701.18 23954 Correct JE23952 Sept TCCC Effluent Correct JE23952 Sept TCCC Effluent 13,850.59 13,850.59 23159 UB Penalties UB Penalties 39.29 39.29 23237 UB Adjustments Penalties UB Adjustments Penalties 479.08 479.08 page 20 Journal # Name Description Debit Credit 23264 UB ADJUSTMENTS PENALTIES UB ADJUSTMENTS PENALTIES 10.94 10.94 23280 UB Late Fees UB Late Fees 434.59 434.59 23171 UB Adjustments UB Adjustments 300.00 300.00 23203 UB Adjustments Service Chgs UB Adjustments Service Chgs 25.00 25.00 23248 UB Service Charges UB Service Charges 100.00 100.00 23272 Recode Utility Fees/Oct Recode Utility Fees/Oct 150,320.00 150,320.00 22945 Permits 10/4/11 Permits 10/4/11 19,036.00 19,036.00 22947 Permits 10/5/11 Permits 10/5/11 9,518.00 9,518.00 22949 Permits 10/6/11 Permits 10/6/11 9,518.00 9,518.00 22951 Permits 10/12/11 Permits 10/12/11 9,518.00 9,518.00 22953 Permits 10/14/11 Permits 10/14/11 19,036.00 19,036.00 22955 Permits 10/17/11 Permits 10/17/11 28,554.00 28,554.00 22957 Permits 10/20/11 Permits 10/20/11 47,590.00 47,590.00 22959 Permits 10/21/11 Permits 10/21/11 9,518.00 9,518.00 23041 Invoice # I12-003526 Invoice # I12-003526 4,834.00 4,834.00 22961 Permits 10/26/11 Permits 10/26/11 28,554.00 28,554.00 23241 Permits 10/28/11 Permits 10/28/11 9,518.00 9,518.00 23597 Payroll Payroll 10/14/11 10/14/2011 PR - imported 67,975.73 67,975.73 23603 Payroll Payroll 10/28/11 10/28/2011 PR - imported 71,718.57 71,718.57 22481 Invoice # I12-003449 Invoice # I12-003449 21,638.50 21,638.50 23896 Invoice # I12-003611 Invoice # I12-003611 180.00 180.00 23394 Invoice # I12-003548 Invoice # I12-003548 8,088.89 8,088.89 22493 Invoice # I12-003452 Invoice # I12-003452 3.28 3.28 22471 Invoice # I12-003446 Invoice # I12-003446 102.56 102.56 22467 Invoice # I12-003445 Invoice # I12-003445 8,236.16 8,236.16 23439 Invoice # I12-003536 Invoice # I12-003536 58.50 58.50 23918 Invoice # I12-003616 Invoice # I12-003616 14,752.18 14,752.18 23013 Invoice # I12-003512 Invoice # I12-003512 200.00 200.00 23019 Invoice # I12-003515 Invoice # I12-003515 467.50 467.50 23437 Invoice # I12-003535 Invoice # I12-003535 168.59 168.59 22135 Reverse Prepaid-VFD interest payment Reverse Prepaid-VFD interest payment 597.19 597.19 22433 Supplemental Payroll #4 Supplemental Payroll #4 12,181.00 12,181.00 22427 Supplemental Payroll #1 Supplemental Payroll #1 4,486.59 4,486.59 22431 Supplemental Payroll #3 Supplemental Payroll #3 6,990.85 6,990.85 23639 rev-Supp P/R - 10/14/11 Duplicate entry rev-Supp P/R- 10/14/11 Duplicate entry 25,348.56 25,348.56 23623 Payroll Supplemental Payroll 1 - 10/14/11 10/14/2011 PR - imported 25,348.56 25,348.56 22429 Supplemental Payroll #2 Supplemental Payroll #2 1,690.12 1,690.12 22475 Invoice # I12-003447 Invoice # I12-003447 7,646.56 7,646.56 23465 Invoice # I12-003550 Invoice # I12-003550 1,612.50 1,612.50 23646 Invoice # I12-003589 Invoice # I12-003589 4,666.84 4,666.84 23677 Invoice # I12-003582 Invoice # I12-003582 7,432.50 7,432.50 23027 Invoice # I12-003519 Invoice # I12-003519 1,712.50 1,712.50 22485 Invoice # I12-003450 Invoice # I12-003450 34.50 34.50 22489 Invoice # I12-003451 Invoice # I12-003451 18.98 18.98 22783 Invoice # I12-003480 Invoice # I12-003480 155.36 155.36 22463 Invoice # I12-003444 Invoice # I12-003444 364.22 364.22 22713 Invoice # I12-003475 Invoice # I12-003475 100.00 100.00 21859 Invoice # I12-003405 Invoice # I12-003405 66.00 66.00 22715 Invoice # I12-003477 Invoice # I12-003477 33.75 33.75 22723 Invoice # I12-003479 Invoice # I12-003479 98.09 98.09 page 21 Journal # Name Description Debit Credit 22721 Invoice # I12-003478 Invoice # I12-003478 7.62 7.62 23017 Invoice # I12-003514 Invoice # I12-003514 8.99 8.99 23015 Invoice # I12-003513 Invoice # I12-003513 19.00 19.00 23035 Invoice # I12-003523 Invoice # I12-003523 28.91 28.91 23039 Invoice # I12-003525 Invoice # I12-003525 190.00 190.00 23781 Oct Postage meter usage Oct Postage meter usage 219.68 219.68 23894 Invoice # I12-003610 Invoice # I12-003610 2,320.84 2,320.84 23320 World Pay Credit card fees World Pay Credit card fees 6,333.00 6,333.00 23021 Invoice # I12-003517 Invoice # I12-003517 25.00 25.00 23681 Invoice # I12-003592 Invoice # I12-003592 47.50 47.50 23892 Invoice # I12-003595 Invoice # I12-003595 47.50 47.50 23471 Invoice # I12-003566 Invoice # I12-003566 218.75 218.75 23023 Invoice # I12-003518 Invoice # I12-003518 17.70 17.70 23671 Invoice # I12-003579 Invoice # I12-003579 1.12 1.12 23673 Invoice # I12-003580 Invoice # I12-003580 1.20 1.20 23675 Invoice # I12-003581 Invoice # I12-003581 333.50 333.50 23433 Invoice # I12-003533 Invoice # I12-003533 427.45 427.45 21871 Invoice # I12-003406 Invoice # I12-003406 36,617.50 36,617.50 22495 Invoice # I12-003453 Invoice # I12-003453 50.00 50.00 21883 Invoice # I12-003407 Invoice # I12-003407 1,098.51 1,098.51 21835 Invoice # I11-003412 Invoice # I11-003412 559.50 559.50 22477 Invoice # I12-003448 Invoice # I12-003448 5,050.00 5,050.00 23037 Invoice # I12-003524 Invoice # I12-003524 3,060.83 3,060.83 page 22 Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 10/31/2011 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 301,126 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 1,077,922 ACCOUNTS RECEIVABLE - PID EMERGENCY SERVICES ASSESSMENTS 191,863 OTHER RECEIVABLES 59,001 TOTAL ASSETS 1,629,912$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 1,269,785$ ACCOUNTS PAYABLE 141,610 TOTAL LIABILITIES 1,411,396$ FUND BALANCE UNDESIGNATED FUND BALANCE 218,516 TOTAL LIABILITIES AND FUND BALANCE 1,629,912$ October 31, 2011 1/12 Months (9% of Fiscal Year) 190-000-000-30050 Emergency Service Assessment 193,233.00 193,233.00 3,760.12 3,760.12 189,472.88 1.9 190-000-000-30055 Emergency Services Assessment - Delinquent 0.00 0.00 7.75 7.75 (7.75) # 190-000-000-30060 Emergency Services Assessment - Penalty & Interest 0.00 0.00 1.54 1.54 (1.54) # 190-000-000-30100 Property Taxes 1,076,976.00 1,076,976.00 4,036.29 4,036.29 1,072,939.71 0.4 190-000-000-30125 Property Taxes/Delinquent 0.00 0.00 (2,571.23) (2,571.23) 2,571.23 # 190-000-000-30150 Property Taxes/Penalty & Interest 7,500.00 7,500.00 238.74 238.74 7,261.26 3.2 190-000-000-33420 Denton/Tarrant County - Fire 10,000.00 10,000.00 0.00 0.00 10,000.00 # 190-000-000-36700 Miscellaneous Revenue 1,124.00 1,124.00 0.00 0.00 1,124.00 # 190-000-000-37100 Prior Year Reserves 23,101.00 23,101.00 0.00 0.00 23,101.00 # Total Fire Department 1,311,934.00 1,311,934.00 5,473.21 5,473.21 1,306,460.79 page 1 Budget Revenue - Fire Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 190-045-000-40100 Salaries - Regular 425,748.00 425,748.00 32,428.89 32,428.89 393,319.11 7.6 190-045-000-40130 Salaries - Overtime 42,000.00 42,000.00 4,062.33 4,062.33 37,937.67 9.7 190-045-000-40140 Salaries - Longevity 3,647.00 3,647.00 0.00 0.00 3,647.00 # 190-045-000-40160 Salaries - Certification 4,073.00 4,073.00 494.70 494.70 3,578.30 12.1 190-045-000-40180 Salaries - Holiday Pay 12,133.00 12,133.00 0.00 0.00 12,133.00 # 190-045-000-41200 Retirement 68,264.00 68,264.00 5,042.15 5,042.15 63,221.85 7.4 190-045-000-41210 Medical Insurance 53,184.00 53,184.00 3,340.28 3,340.28 49,843.72 6.3 190-045-000-41215 Dental Insurance 3,288.00 3,288.00 291.96 291.96 2,996.04 8.9 190-045-000-41216 Vision Insurance 857.00 857.00 65.95 65.95 791.05 7.7 190-045-000-41218 Life Insurance & Other 2,740.00 2,740.00 0.00 0.00 2,740.00 # 190-045-000-42220 Social Security Taxes 30,231.00 30,231.00 2,106.90 2,106.90 28,124.10 7.0 190-045-000-42225 Medicare Taxes 7,070.00 7,070.00 492.78 492.78 6,577.22 7.0 190-045-000-42250 Unemployment Taxes 1,476.00 1,476.00 24.54 24.54 1,451.46 1.7 190-045-000-42260 Workman's Compensation 8,793.00 8,793.00 8,309.50 8,309.50 483.50 94.5 190-045-000-42290 Pre-employment Physicals/Testing 675.00 675.00 0.00 0.00 675.00 # 190-045-000-50100 Professional Outside Services 20,000.00 20,000.00 0.00 0.00 20,000.00 # 190-045-000-54100 Physicals/Testing 1,918.00 1,918.00 0.00 0.00 1,918.00 # 190-045-000-60100 Office Supplies 329.00 329.00 50.96 50.96 278.04 15.5 190-045-000-60300 Postage 97.00 97.00 8.87 8.87 88.13 9.1 190-045-000-60400 Publications/Books/Subscriptions 401.00 401.00 0.00 0.00 401.00 # 190-045-000-61000 Fuel 17,414.00 17,414.00 0.00 0.00 17,414.00 # 190-045-000-62100 Uniforms 4,357.00 4,357.00 359.00 359.00 3,998.00 8.2 190-045-000-62150 Protective Clothing 7,600.00 7,600.00 0.00 0.00 7,600.00 # 190-045-000-62300 Chemicals 1,545.00 1,545.00 0.00 0.00 1,545.00 # 190-045-000-72100 Electricity/Gas 18,270.00 18,270.00 600.93 600.93 17,669.07 3.3 190-045-000-72200 Water 3,289.00 3,289.00 0.00 0.00 3,289.00 # 190-045-000-73100 Telephone 106.00 106.00 11.09 11.09 94.91 10.5 190-045-000-73200 Communications /Pagers/Mobiles 4,411.00 4,411.00 30.98 30.98 4,380.02 0.7 190-045-000-73300 Advertising 156.00 156.00 0.00 0.00 156.00 # 190-045-000-73400 Printing 106.00 106.00 0.00 0.00 106.00 # 190-045-000-74100 Dues & Membership 8,560.00 8,560.00 5,176.34 5,176.34 3,383.66 60.5 190-045-000-74200 Travel & per diem 6,788.00 6,788.00 1,620.88 1,620.88 5,167.12 23.9 190-045-000-74300 Schools & Training 6,946.00 6,946.00 0.00 0.00 6,946.00 # 190-045-000-74400 Emergency Management 1,000.00 1,000.00 0.00 0.00 1,000.00 # 190-045-000-75000 Insurance 20,974.00 20,974.00 8,078.00 8,078.00 12,896.00 38.5 190-045-000-77300 Fire Inspections/Enforcement 1,900.00 1,900.00 0.00 0.00 1,900.00 # 190-045-000-78200 Small Tools 8,371.00 8,371.00 92.50 92.50 8,278.50 1.1 page 1 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 190-045-000-79200 Building Rental/Lease 308,000.00 308,000.00 0.00 0.00 308,000.00 # 190-045-000-79999 Miscellaneous Expense 1,237.00 1,237.00 0.00 0.00 1,237.00 # 190-045-000-80250 Maintenance and Repairs 9,562.00 9,562.00 0.00 0.00 9,562.00 # 190-045-000-81200 Building Maintenance 11,000.00 11,000.00 711.65 711.65 10,288.35 6.5 190-045-000-81300 Vehicle Maintenance 14,850.00 14,850.00 0.00 0.00 14,850.00 # 190-045-000-81350 Equipment Maintenance 9,808.00 9,808.00 0.00 0.00 9,808.00 # 190-045-000-81400 Radio Maintenance 1,103.00 1,103.00 0.00 0.00 1,103.00 # 190-045-000-81800 Flags & Repairs 2,543.00 2,543.00 402.50 402.50 2,140.50 15.8 190-045-000-81900 Maintenance Supplies 2,785.00 2,785.00 21.75 21.75 2,763.25 0.8 190-045-000-85000 Grant Match 3,000.00 3,000.00 0.00 0.00 3,000.00 # 190-045-000-87100 Programs & Special Projects 4,162.00 4,162.00 624.91 624.91 3,537.09 15.0 190-045-000-90100 Radios 2,500.00 2,500.00 0.00 0.00 2,500.00 # 190-045-000-90200 Fire Engine 681 Payment 73,203.00 73,203.00 0.00 0.00 73,203.00 # 190-045-000-93200 Vehicles 13,709.00 13,709.00 0.00 0.00 13,709.00 # 190-045-000-93600 Airpacks 13,865.00 13,865.00 0.00 0.00 13,865.00 # 190-045-000-99500 Transfer to Future Replacement Reserve 41,890.00 41,890.00 0.00 0.00 41,890.00 # Total Fire Department 1,311,934.00 1,311,934.00 74,450.34 74,450.34 1,237,483.66 page 2 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Trophy Club Municipal Utility Dist #1 G/L Transaction Detail From Date: 10/01/2011 To Date: 10/31/2011 From Account: 190-000-000-30050 To Account: 190-045-000-99500 Run Date: 11/09/2011 User: rgonzales G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 190-000-000-30050 Emergency Service Assessment Balance Forward 0.00 10/05/2011 USR PID Assessments 22981 0.01 10/20/2011 USR PID Assessments 22989 1,770.47 10/21/2011 USR PID Assessments 22983 438.66 10/24/2011 USR PID Assessments 22987 98.11 10/25/2011 USR PID Assessments 22985 388.07 10/27/2011 USR PID Assessments 23111 36.39 10/28/2011 USR PID Assessments 23316 1,028.41 10/28/2011 USR PID Assessments 23401 1,028.41 10/28/2011 RV PID Assessments 23607 1,028.41 TOTAL 1,028.41 4,788.53 3,760.12CR 190-000-000-30055 Emergency Services Assessment - Delinquent Balance Forward 0.00 10/05/2011 USR PID Assessments 22981 7.75 TOTAL 0.00 7.75 7.75CR 190-000-000-30060 Emergency Services Assessment - Penalty & Interest Balance Forward 0.00 10/05/2011 USR PID Assessments 22981 1.54 TOTAL 0.00 1.54 1.54CR 190-000-000-30100 Property Taxes Balance Forward 0.00 10/05/2011 USR MUD 1 AV Taxes Corrected of JE 23093 23611 0.01 10/07/2011 USR MUD 1 AV Taxes 23097 185.73 10/18/2011 USR MUD 1 AV Taxes 23107 130.39 10/19/2011 USR MUD 1 AV Taxes 23099 583.58 10/20/2011 USR MUD 1 AV Taxes 23101 179.89 10/21/2011 USR MUD 1 AV Taxes 23103 451.20 10/25/2011 USR MUD 1 AV Taxes 23105 501.93 10/26/2011 USR MUD 1 AV Taxes 23109 420.68 10/27/2011 USR MUD 1 AV Taxes 23113 248.27 10/28/2011 USR MUD 1 AV Taxes 23318 1,122.06 10/31/2011 USR MUD 1 AV Taxes 23399 212.55 TOTAL 0.00 4,036.29 4,036.29CR 190-000-000-30125 Property Taxes/Delinquent Balance Forward 0.00 10/05/2011 USR Advalorem Taxes 22991 392.54 10/05/2011 USR Advalorem Taxes 23093 286.09 10/05/2011 RV Advalorem Taxes 23609 286.09 10/05/2011 USR Advalorem Taxes 23611 286.09 10/06/2011 USR Advalorem Taxes 23095 217.61 10/18/2011 USR Advalorem Taxes 23107 3,482.76 10/28/2011 USR Advalorem Taxes 23318 15.29 page 1 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance TOTAL 3,768.85 1,197.62 2,571.23 190-000-000-30150 Property Taxes/Penalty & Interest Balance Forward 0.00 10/05/2011 USR Advalorem Taxes 22991 139.81 10/05/2011 USR Advalorem Taxes 23093 51.65 10/05/2011 RV Advalorem Taxes 23609 51.65 10/05/2011 USR Advalorem Taxes 23611 51.65 10/06/2011 USR Advalorem Taxes 23095 43.52 10/28/2011 USR Advalorem Taxes 23318 3.76 TOTAL 51.65 290.39 238.74CR 190-000-000-32014 Fire Permits/Sprinkler Balance Forward 0.00 190-000-000-33050 Fire Inspections Balance Forward 0.00 190-000-000-33420 Denton/Tarrant County - Fire Balance Forward 0.00 190-000-000-35050 Interest Income Balance Forward 0.00 190-000-000-35370 Donations Balance Forward 0.00 190-000-000-36700 Miscellaneous Revenue Balance Forward 0.00 190-000-000-37100 Prior Year Reserves Balance Forward 0.00 190-000-000-39200 Transfer In - General Fund Balance Forward 0.00 190-045-000-40100 Salaries - Regular Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 16,168.36 10/28/2011 USR Payroll 10/28/11 23603 16,260.53 TOTAL 32,428.89 0.00 32,428.89 190-045-000-40130 Salaries - Overtime Balance Forward 0.00 10/28/2011 USR Payroll 10/28/11 23603 4,062.33 TOTAL 4,062.33 0.00 4,062.33 190-045-000-40140 Salaries - Longevity Balance Forward 0.00 190-045-000-40160 Salaries - Certification Balance Forward 0.00 10/28/2011 USR Payroll 10/28/11 23603 494.70 TOTAL 494.70 0.00 494.70 190-045-000-40180 Salaries - Holiday Pay Balance Forward 0.00 190-045-000-41200 Retirement Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 2,200.02 10/28/2011 USR Payroll 10/28/11 23603 2,842.13 TOTAL 5,042.15 0.00 5,042.15 190-045-000-41210 Medical Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 1,663.56 10/28/2011 USR Payroll 10/28/11 23603 1,676.72 TOTAL 3,340.28 0.00 3,340.28 190-045-000-41215 Dental Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 145.26 10/28/2011 USR Payroll 10/28/11 23603 146.70 TOTAL 291.96 0.00 291.96 190-045-000-41216 Vision Insurance Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 32.84 10/28/2011 USR Payroll 10/28/11 23603 33.11 TOTAL 65.95 0.00 65.95 190-045-000-41218 Life Insurance & Other Balance Forward 0.00 190-045-000-42220 Social Security Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 909.10 10/28/2011 USR Payroll 10/28/11 23603 1,197.80 page 2 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance TOTAL 2,106.90 0.00 2,106.90 190-045-000-42225 Medicare Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 212.63 10/28/2011 USR Payroll 10/28/11 23603 280.15 TOTAL 492.78 0.00 492.78 190-045-000-42250 Unemployment Taxes Balance Forward 0.00 10/14/2011 USR Payroll 10/14/11 23597 10.77 10/28/2011 USR Payroll 10/28/11 23603 13.77 TOTAL 24.54 0.00 24.54 190-045-000-42260 Workman's Compensation Balance Forward 0.00 10/01/2011 SYS Workers Comp 22481 TML Intergovernmental Risk 3411/MUD W/C 8,309.50 TOTAL 8,309.50 0.00 8,309.50 190-045-000-42290 Pre-employment Physicals/Testing Balance Forward 0.00 190-045-000-50100 Professional Outside Services Balance Forward 0.00 190-045-000-54100 Physicals/Testing Balance Forward 0.00 190-045-000-60100 Office Supplies Balance Forward 0.00 10/20/2011 SYS Grunt 23394 JP Morgan Chase Bank NA 102011 50.96 TOTAL 50.96 0.00 50.96 190-045-000-60300 Postage Balance Forward 0.00 10/31/2011 USR Oct Postage meter usage 23781 8.87 TOTAL 8.87 0.00 8.87 190-045-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 190-045-000-61000 Fuel Balance Forward 0.00 190-045-000-62100 Uniforms Balance Forward 0.00 10/21/2011 SYS Breat Cancer awareness tshirts 23009 Sam Johnson 536524 240.00 10/31/2011 SYS Thomas 23918 JP Morgan Chase Bank NA 110711 119.00 TOTAL 359.00 0.00 359.00 190-045-000-62150 Protective Clothing Balance Forward 0.00 190-045-000-62300 Chemicals Balance Forward 0.00 190-045-000-72100 Electricity/Gas Balance Forward 0.00 10/20/2011 SYS Electricity 10/1-10/12 23031 Hudson Energy 2439341 Oct 555.12 10/26/2011 SYS Gas/Oct 23461 Atmos Energy 005534734/Oct 45.81 TOTAL 600.93 0.00 600.93 190-045-000-72200 Water Balance Forward 0.00 190-045-000-73100 Telephone Balance Forward 0.00 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 6.91 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 4.18 TOTAL 11.09 0.00 11.09 190-045-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 10/27/2011 SYS Pastor 23646 Bank of America 102711 30.98 TOTAL 30.98 0.00 30.98 190-045-000-73300 Advertising Balance Forward 0.00 190-045-000-73400 Printing Balance Forward 0.00 190-045-000-74100 Dues & Membership Balance Forward 0.00 10/01/2011 SYS Dept Membership 2012 23685 Fire Instructors Assoc of N Texas 100111 100.00 10/31/2011 SYS 2011-12 Membership dues 23900 North East Fire Dept Assoc 11-028 5,076.34 TOTAL 5,176.34 0.00 5,176.34 190-045-000-74200 Travel & per diem Balance Forward 0.00 page 3 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 10/14/2011 SYS Mileage/Fire Investigator & Educator tra 23011 Gary Sipes 101411 222.00 10/20/2011 SYS Donnie Hurd II 23394 JP Morgan Chase Bank NA 102011 40.61 10/20/2011 SYS Donnie Hurd II 23394 JP Morgan Chase Bank NA 102011 58.01 10/20/2011 SYS Donnie Hurd II 23394 JP Morgan Chase Bank NA 102011 11.69 10/20/2011 SYS Donnie Hurd II 23394 JP Morgan Chase Bank NA 102011 36.18 10/20/2011 SYS Donnie Hurd II 23394 JP Morgan Chase Bank NA 102011 11.69 10/20/2011 SYS Sipes 23394 JP Morgan Chase Bank NA 102011 37.42 10/20/2011 SYS Sipes 23394 JP Morgan Chase Bank NA 102011 29.19 10/20/2011 SYS Sipes 23394 JP Morgan Chase Bank NA 102011 37.37 10/20/2011 SYS Sipes 23394 JP Morgan Chase Bank NA 102011 11.69 10/31/2011 SYS Hurd 23918 JP Morgan Chase Bank NA 110711 488.75 10/31/2011 SYS Hurd 23918 JP Morgan Chase Bank NA 110711 488.75 10/31/2011 SYS Sipes 23918 JP Morgan Chase Bank NA 110711 11.19 10/31/2011 SYS Sipes 23918 JP Morgan Chase Bank NA 110711 14.90 10/31/2011 SYS Sipes 23918 JP Morgan Chase Bank NA 110711 38.96 10/31/2011 SYS Thomas 23918 JP Morgan Chase Bank NA 110711 19.65 10/31/2011 SYS Hurd 23918 JP Morgan Chase Bank NA 110711 11.19 10/31/2011 SYS Hurd 23918 JP Morgan Chase Bank NA 110711 14.31 10/31/2011 SYS Hurd 23918 JP Morgan Chase Bank NA 110711 37.33 TOTAL 1,620.88 0.00 1,620.88 190-045-000-74300 Schools & Training Balance Forward 0.00 190-045-000-74400 Emergency Management Balance Forward 0.00 190-045-000-74600 Meetings Balance Forward 0.00 190-045-000-75000 Insurance Balance Forward 0.00 10/01/2011 SYS 2011-12 Insurance renewal 21871 TML Intergovernmental Risk 100111 8,078.00 TOTAL 8,078.00 0.00 8,078.00 190-045-000-77300 Fire Inspections/Enforcement Balance Forward 0.00 190-045-000-78200 Small Tools Balance Forward 0.00 10/31/2011 SYS Hurd 23918 JP Morgan Chase Bank NA 110711 92.50 TOTAL 92.50 0.00 92.50 190-045-000-79200 Building Rental/Lease Balance Forward 0.00 190-045-000-79999 Miscellaneous Expense Balance Forward 0.00 190-045-000-80250 Maintenance and Repairs Balance Forward 0.00 190-045-000-81200 Building Maintenance Balance Forward 0.00 10/11/2011 SYS Fire extinquisher inspections 23019 Kimbrough Fire Extinquisher Co, Inc. 174661 102.00 10/20/2011 SYS Donnie Hurd II 23394 JP Morgan Chase Bank NA 102011 8.82 10/20/2011 SYS Danny Thomas 23394 JP Morgan Chase Bank NA 102011 162.68 10/20/2011 SYS Donnie Hurd II 23394 JP Morgan Chase Bank NA 102011 110.41 10/31/2011 SYS Thomas 23918 JP Morgan Chase Bank NA 110711 93.17 10/31/2011 SYS Thomas 23918 JP Morgan Chase Bank NA 110711 40.93 10/31/2011 SYS Thomas 23918 JP Morgan Chase Bank NA 110711 151.06 10/31/2011 SYS Thomas 23918 JP Morgan Chase Bank NA 110711 42.58 TOTAL 711.65 0.00 711.65 190-045-000-81300 Vehicle Maintenance Balance Forward 0.00 190-045-000-81350 Equipment Maintenance Balance Forward 0.00 190-045-000-81400 Radio Maintenance Balance Forward 0.00 190-045-000-81800 Flags & Repairs Balance Forward 0.00 page 4 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 10/13/2011 SYS Flag 22497 Symonds Flags & Poles, Inc 3683 402.50 TOTAL 402.50 0.00 402.50 190-045-000-81900 Maintenance Supplies Balance Forward 0.00 10/31/2011 SYS Hurd 23918 JP Morgan Chase Bank NA 110711 21.75 TOTAL 21.75 0.00 21.75 190-045-000-85000 Grant Match Balance Forward 0.00 190-045-000-87100 Programs & Special Projects Balance Forward 0.00 10/14/2011 SYS Side click pens 23033 River City Supply, LLC 100711-I 265.67 10/31/2011 SYS Sipes 23918 JP Morgan Chase Bank NA 110711 40.24 10/31/2011 SYS Sipes 23918 JP Morgan Chase Bank NA 110711 319.00 TOTAL 624.91 0.00 624.91 190-045-000-90100 Radios Balance Forward 0.00 190-045-000-90200 Fire Engine 681 Payment Balance Forward 0.00 190-045-000-93200 Vehicles Balance Forward 0.00 190-045-000-93600 Airpacks Balance Forward 0.00 190-045-000-99500 Transfer to Future Replacement Reserve Balance Forward 0.00 GRAND TOTAL 79,299.25 10,322.12 68,977.13 Journal # Name Description Debit Credit 22981 PID Assessments PID Assessments 17.06 17.06 22989 PID Assessments PID Assessments 3,540.94 3,540.94 22983 PID Assessments PID Assessments 877.32 877.32 22987 PID Assessments PID Assessments 196.22 196.22 22985 PID Assessments PID Assessments 776.14 776.14 23111 PID Assessments PID Assessments 72.78 72.78 23316 PID Assessments PID Assessments 2,056.82 2,056.82 23401 PID Assessments PID Assessments 2,056.82 2,056.82 23607 rev-PID Assessments JE 23401/Duplicate rev-PID Assessments JE 23401/Duplicate 2,056.82 2,056.82 23611 MUD 1 AV Taxes Corrected of JE 23093 MUD 1 AV Taxes Corrected of JE 23093 1,113.50 1,113.50 23097 MUD 1 AV Taxes MUD 1 AV Taxes 595.00 595.00 23107 MUD 1 AV Taxes MUD 1 AV Taxes 12,814.43 12,814.43 23099 MUD 1 AV Taxes MUD 1 AV Taxes 1,869.62 1,869.62 23101 MUD 1 AV Taxes MUD 1 AV Taxes 576.28 576.28 23103 MUD 1 AV Taxes MUD 1 AV Taxes 1,445.50 1,445.50 23105 MUD 1 AV Taxes MUD 1 AV Taxes 1,608.02 1,608.02 23109 MUD 1 AV Taxes MUD 1 AV Taxes 1,347.72 1,347.72 23113 MUD 1 AV Taxes MUD 1 AV Taxes 795.38 795.38 23318 MUD 1 AV Taxes MUD 1 AV Taxes 3,658.17 3,658.17 23399 MUD 1 AV Taxes MUD 1 AV Taxes 680.92 680.92 22991 FKA2 AV Taxes FKA2 AV Taxes 1,852.51 1,852.51 23093 MUD 1 AV Taxes MUD 1 AV Taxes 1,113.48 1,113.48 23609 rev-JE23093 AV Taxes rev-JE23093 AV Taxes 1,113.48 1,113.48 23095 MUD 1 AV Taxes MUD 1 AV Taxes 854.50 854.50 23597 Payroll Payroll 10/14/11 10/14/2011 PR - imported 67,975.73 67,975.73 23603 Payroll Payroll 10/28/11 10/28/2011 PR - imported 71,718.57 71,718.57 22481 Invoice # I12-003449 Invoice # I12-003449 21,638.50 21,638.50 23394 Invoice # I12-003548 Invoice # I12-003548 8,088.89 8,088.89 page 5 Journal # Name Description Debit Credit 23781 Oct Postage meter usage Oct Postage meter usage 219.68 219.68 23009 Invoice # I12-003510 Invoice # I12-003510 240.00 240.00 23918 Invoice # I12-003616 Invoice # I12-003616 14,752.18 14,752.18 23031 Invoice # I12-003521 Invoice # I12-003521 555.12 555.12 23461 Invoice # I12-003549 Invoice # I12-003549 45.81 45.81 23646 Invoice # I12-003589 Invoice # I12-003589 4,666.84 4,666.84 23685 Invoice # I12-003594 Invoice # I12-003594 100.00 100.00 23900 Invoice # I12-003613 Invoice # I12-003613 5,076.34 5,076.34 23011 Invoice # I12-003511 Invoice # I12-003511 222.00 222.00 21871 Invoice # I12-003406 Invoice # I12-003406 36,617.50 36,617.50 23019 Invoice # I12-003515 Invoice # I12-003515 467.50 467.50 22497 Invoice # I12-003454 Invoice # I12-003454 402.50 402.50 23033 Invoice # I12-003522 Invoice # I12-003522 265.67 265.67 page 6 Municipal Utility District No 1 Fire Station Construction 2010 General Obligation $2M Bond Fund Interim Balance Sheet 1/12 Months (9% of Fiscal Year) Balance @ 10/31/2011 ASSETS ASSETS INVESTMENTS -$ OTHER RECEIVABLES - TOTAL ASSETS -$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE 116,737$ TOTAL LIABILITIES 116,737 FUND BALANCE DESIGNATED FOR FIRE STATION CONSTRUCTION (116,737) TOTAL LIABILITIES AND FUND BALANCE -$ * General Fund will transfer to cover expenditures over bond money received. October 31, 2011 491-000-000-36400 Auction Sales 0.00 0.00 22,570.00 22,570.00 (22,570.00) # Total Fire Department 0.00 0.00 22,570.00 22,570.00 (22,570.00) page 1 Budget Revenue - Fire Const Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 491-045-000-94000 Temporary Housing and Storage 0.00 0.00 41.58 41.58 (41.58) # Total Fire Department 0.00 0.00 41.58 41.58 (41.58) page 1 Budget to Actual - Fire Const Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Trophy Club Municipal Utility Dist #1 G/L Transaction Detail From Date: 10/01/2011 To Date: 10/31/2011 From Account: 491-000-000-35050 To Account: 491-045-000-96500 Run Date: 11/10/2011 User: rgonzales G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 491-000-000-35050 Interest Income Balance Forward 0.00 491-000-000-36400 Auction Sales Balance Forward 0.00 10/26/2011 USR Bates Auctioneers/sale of temp tent 22941 22,570.00 TOTAL 0.00 22,570.00 22,570.00CR 491-000-000-39200 Transfer In - General Fund Balance Forward 0.00 491-045-000-94000 Temporary Housing and Storage Balance Forward 0.00 10/27/2011 SYS Steve Z. 23646 Bank of America 102711 41.58 TOTAL 41.58 0.00 41.58 491-045-000-95000 Construction Balance Forward 0.00 491-045-000-96100 Legal Balance Forward 0.00 491-045-000-96300 Engineering Balance Forward 0.00 491-045-000-96500 Bond Issuance Cost Balance Forward 0.00 GRAND TOTAL 41.58 22,570.00 22,528.42CR Journal # Name Description Debit Credit 22941 Bates Auctioneers/sale of temp tent Bates Auctioneers/sale of temp tent 45,140.00 45,140.00 23646 Invoice # I12-003589 Invoice # I12-003589 4,666.84 4,666.84 page 1 Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 10/31/2011 ASSETS ASSETS CASH AND CASH IN BANK 6,120$ INVESTMENTS 108,326 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 558,231 TOTAL ASSETS 672,677$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 558,231$ TOTAL LIABILITIES 558,231 FUND BALANCE DESIGNATED FOR DEBT SERVICE 114,446 TOTAL LIABILITIES AND FUND BALANCE 672,677$ October 31, 2011 1/12 Months (9% of Fiscal Year) 680-000-000-30100 Property Taxes 550,663.00 550,663.00 2,063.74 2,063.74 548,599.26 0.4 680-000-000-30125 Property Taxes/Delinquent 0.00 0.00 (1,777.51) (1,777.51) 1,777.51 # 680-000-000-30150 Property Taxes/Penalty & Interest 5,017.00 5,017.00 185.10 185.10 4,831.90 3.7 680-000-000-35050 Interest Income 500.00 500.00 7.69 7.69 492.31 1.5 680-000-000-35170 Building Rent 308,000.00 308,000.00 0.00 0.00 308,000.00 # 680-000-000-38500 PID Utility Fees 6,120.00 6,120.00 6,120.00 6,120.00 0.00 100.0 Total Fire Department 870,300.00 870,300.00 6,599.02 6,599.02 863,700.98 page 1 Budget Revenue - Debt Service Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 680-680-000-89000 Bond Principal 565,000.00 565,000.00 0.00 0.00 565,000.00 # 680-680-000-89100 Bond Interest 301,300.00 301,300.00 0.00 0.00 301,300.00 # 680-680-000-89200 Paying Agent Fees 4,000.00 4,000.00 0.00 0.00 4,000.00 # Total Debt Service 870,300.00 870,300.00 0.00 0.00 870,300.00 page 1 Budget to Actual -Debt Service Trophy Club Municipal Utility Dist #1 For Period Ending 10/31/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Trophy Club Municipal Utility Dist #1 G/L Transaction Detail From Date: 10/01/2011 To Date: 10/31/2011 From Account: 680-000-000-30100 To Account: 680-680-000-89200 Run Date: 11/09/2011 User: rgonzales G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 680-000-000-30100 Property Taxes Balance Forward 0.00 10/07/2011 USR MUD 1 AV Taxes 23097 94.96 10/18/2011 USR MUD 1 AV Taxes 23107 66.66 10/19/2011 USR MUD 1 AV Taxes 23099 298.40 10/20/2011 USR MUD 1 AV Taxes 23101 91.97 10/21/2011 USR MUD 1 AV Taxes 23103 230.70 10/25/2011 USR MUD 1 AV Taxes 23105 256.64 10/26/2011 USR MUD 1 AV Taxes 23109 215.10 10/27/2011 USR MUD 1 AV Taxes 23113 126.94 10/28/2011 USR MUD 1 AV Taxes 23318 573.70 10/31/2011 USR MUD 1 AV Taxes 23399 108.67 TOTAL 0.00 2,063.74 2,063.74CR 680-000-000-30125 Property Taxes/Delinquent Balance Forward 0.00 10/05/2011 USR Advalorem Taxes 22991 310.28 10/05/2011 USR Advalorem Taxes 23093 201.54 10/05/2011 RV Advalorem Taxes 23609 201.54 10/05/2011 USR Advalorem Taxes 23611 201.54 10/06/2011 USR Advalorem Taxes 23095 153.29 10/18/2011 USR Advalorem Taxes 23107 2,453.39 10/28/2011 USR Advalorem Taxes 23318 10.77 TOTAL 2,654.93 877.42 1,777.51 680-000-000-30150 Property Taxes/Penalty & Interest Balance Forward 0.00 10/05/2011 USR Advalorem Taxes 22991 115.80 10/05/2011 USR Advalorem Taxes 23093 36.38 10/05/2011 RV Advalorem Taxes 23609 36.38 10/05/2011 USR Advalorem Taxes 23611 36.38 10/06/2011 USR Advalorem Taxes 23095 30.66 10/28/2011 USR Advalorem Taxes 23318 2.26 TOTAL 36.38 221.48 185.10CR 680-000-000-35050 Interest Income Balance Forward 0.00 10/31/2011 USR October Bank interest 23605 7.69 TOTAL 0.00 7.69 7.69CR 680-000-000-35170 Building Rent Balance Forward 0.00 680-000-000-36900 Recovery of Prior Year Expense Balance Forward 0.00 680-000-000-37100 Prior Year Reserves Balance Forward 0.00 680-000-000-38500 PID Utility Fees Balance Forward 0.00 10/04/2011 USR Permits 10/4/11 22945 4,600.00 10/05/2011 USR Permits 10/5/11 22947 2,300.00 10/06/2011 USR Permits 10/6/11 22949 2,300.00 page 1 G/L # Effective Date Ref Id Description Journal # Vendor Name Vendor Inv # Debit Credit Balance 10/12/2011 USR Permits 10/12/11 22951 2,300.00 10/14/2011 USR Permits 10/14/11 22953 4,600.00 10/17/2011 USR Permits 10/17/11 22955 6,900.00 10/20/2011 USR Permits 10/20/11 22957 11,500.00 10/21/2011 USR Permits 10/21/11 22959 2,300.00 10/21/2011 SYS 2402 TC Drive previously permitted 2008- 23041 Lennar Homes 102111 2,300.00 10/26/2011 USR Permits 10/26/11 22961 6,900.00 10/28/2011 USR Permits 10/28/11 23241 2,300.00 10/31/2011 USR Recode Utility Fees/Oct 23272 37,580.00 TOTAL 39,880.00 46,000.00 6,120.00CR 680-000-000-39200 Transfer In - General Fund Balance Forward 0.00 680-680-000-89000 Bond Principal Balance Forward 0.00 680-680-000-89100 Bond Interest Balance Forward 0.00 680-680-000-89200 Paying Agent Fees Balance Forward 0.00 GRAND TOTAL 42,571.31 49,170.33 6,599.02CR Journal # Name Description Debit Credit 23097 MUD 1 AV Taxes MUD 1 AV Taxes 595.00 595.00 23107 MUD 1 AV Taxes MUD 1 AV Taxes 12,814.43 12,814.43 23099 MUD 1 AV Taxes MUD 1 AV Taxes 1,869.62 1,869.62 23101 MUD 1 AV Taxes MUD 1 AV Taxes 576.28 576.28 23103 MUD 1 AV Taxes MUD 1 AV Taxes 1,445.50 1,445.50 23105 MUD 1 AV Taxes MUD 1 AV Taxes 1,608.02 1,608.02 23109 MUD 1 AV Taxes MUD 1 AV Taxes 1,347.72 1,347.72 23113 MUD 1 AV Taxes MUD 1 AV Taxes 795.38 795.38 23318 MUD 1 AV Taxes MUD 1 AV Taxes 3,658.17 3,658.17 23399 MUD 1 AV Taxes MUD 1 AV Taxes 680.92 680.92 22991 FKA2 AV Taxes FKA2 AV Taxes 1,852.51 1,852.51 23093 MUD 1 AV Taxes MUD 1 AV Taxes 1,113.48 1,113.48 23609 rev-JE23093 AV Taxes rev-JE23093 AV Taxes 1,113.48 1,113.48 23611 MUD 1 AV Taxes Corrected of JE 23093 MUD 1 AV Taxes Corrected of JE 23093 1,113.50 1,113.50 23095 MUD 1 AV Taxes MUD 1 AV Taxes 854.50 854.50 23605 October Bank interest October Bank interest 478.75 478.75 22945 Permits 10/4/11 Permits 10/4/11 19,036.00 19,036.00 22947 Permits 10/5/11 Permits 10/5/11 9,518.00 9,518.00 22949 Permits 10/6/11 Permits 10/6/11 9,518.00 9,518.00 22951 Permits 10/12/11 Permits 10/12/11 9,518.00 9,518.00 22953 Permits 10/14/11 Permits 10/14/11 19,036.00 19,036.00 22955 Permits 10/17/11 Permits 10/17/11 28,554.00 28,554.00 22957 Permits 10/20/11 Permits 10/20/11 47,590.00 47,590.00 22959 Permits 10/21/11 Permits 10/21/11 9,518.00 9,518.00 23041 Invoice # I12-003526 Invoice # I12-003526 4,834.00 4,834.00 22961 Permits 10/26/11 Permits 10/26/11 28,554.00 28,554.00 23241 Permits 10/28/11 Permits 10/28/11 9,518.00 9,518.00 23272 Recode Utility Fees/Oct Recode Utility Fees/Oct 150,320.00 150,320.00 page 2