Loading...
HomeMy WebLinkAboutApril 2012 MUD Financials Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 4/30/2012 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 824,086 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 43,566 ACCOUNTS RECEIVABLE - PID EMER SERVICES 3,272 OTHER RECEIVABLES 45,239 TOTAL ASSETS 916,163$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 46,838$ ACCOUNTS PAYABLE 104,471 TOTAL LIABILITIES 151,309$ FUND BALANCE ASSIGNED FUND BALANCE 23,101 UNASSIGNED FUND BALANCE 741,753 TOTAL LIABILITIES AND FUND BALANCE 916,163$ April 30, 2012 7/12 Months (59% of Fiscal Year) Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 4/30/2012 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 175,865 INVESTMENTS 2,628,668 RESTRICTED ASSETS: INVESTMENTS 415,181 PREPAID EXPENSES 4,993 ADVALOREM PROPERTY TAXES RECEIVABLE 4,873 UTILITY AND OTHER ACCOUNTS RECEIVABLE 481,502 TOTAL ASSETS 3,711,482$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,873$ ACCOUNTS PAYABLE 428,537 CUSTOMER DEPOSITS 195,767 TOTAL LIABILITIES 629,177 FUND BALANCE NON-SPENDABLE FUND BALANCE 7,755 ASSIGNED/WATER REPLACEMENT 60,000 ASSIGNED/TECHNOLOGY REPLACEMENT 159,414 ASSIGNED FUND BALANCE 578,742 UNASSIGNED FUND BALANCE 2,276,394 TOTAL FUND BALANCE 3,082,305 TOTAL LIABILITIES AND FUND BALANCE 3,711,482$ April 30, 2012 7/12 Months (59% of Fiscal Year) Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 4/30/2012 ASSETS ASSETS CASH AND CASH IN BANK 6,120$ INVESTMENTS 806,201 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 29,187 TOTAL ASSETS 841,509$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 29,187$ TOTAL LIABILITIES 29,187 FUND BALANCE ASSIGNED FUND BALANCE 812,321 TOTAL LIABILITIES AND FUND BALANCE 841,509$ April 30, 2012 7/12 Months (59% of Fiscal Year) . glbase_tbam rgonzale Trophy Club Entities Page 1 17:53 05/10/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 193,233.00- 193,233.00- 3,124.24- 189,332.56- 97.981 3,900.44- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,900.00- 1,049.53- 5,906.22- 120.535 1,006.22 122-40010-000-000 Property Taxes/MUD Fire 1,076,976.00- 1,076,976.00- 5,029.98- 1,051,613.65- 97.645 25,362.35- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,603.00- .29- 5,461.77 -97.479 11,064.77- 122-40015-000-000 Property Taxes/Assessments P&I 725.00- 878.63- 1,831.00- 252.552 1,106.00 122-40020-000-000 Property Taxes/Fire P&I 7,500.00- 7,500.00- 419.63- 2,192.89- 29.239 5,307.11- Subtotal: 1,277,709.00- 1,288,937.00- 10,502.30- 1,245,414.55- 96.623 43,522.45- 122-42014-000-000 Fire Permits/Sprinkler 6,000.00- 6,000.00- 100.000 Subtotal: 6,000.00- 6,000.00- 100.000 122-43400-000-000 Fire Inspections 500.00- 1,125.00- 225.000 625.00 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 122-43599-000-000 Misc Fire Revenue 1,124.00- 1,124.00- 1,124.00- Subtotal: 11,124.00- 11,624.00- 11,125.00- 95.707 499.00- 122-49035-000-000 Prior Year Reserves 23,101.00- 122-49900-000-000 Miscellaneous Income 7,998.00- 100.00- 9,221.95- 115.303 1,223.95 Subtotal: 23,101.00- 7,998.00- 100.00- 9,221.95- 115.303 1,223.95 Program number: 1,311,934.00- 1,314,559.00- 10,602.30- 1,271,761.50- 96.744 42,797.50- Department number: Fire Revenues 1,311,934.00- 1,314,559.00- 10,602.30- 1,271,761.50- 96.744 42,797.50- Revenues Subtotal ----------- 1,311,934.00- 1,314,559.00- 10,602.30- 1,271,761.50- 96.744 42,797.50- . glbase_tbam rgonzale Trophy Club Entities Page 2 17:53 05/10/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 425,748.00 425,748.00 33,203.74 238,852.05 56.102 186,895.95 122-50010-045-000 Overtime 42,000.00 42,000.00 2,669.95 25,295.31 60.227 16,704.69 122-50011-045-000 DPS Holiday Pay 12,133.00 13,773.00 13,773.02 100.000 .02- 122-50016-045-000 Longevity 3,647.00 3,647.00 3,714.46 101.850 67.46- 122-50017-045-000 Certification 4,073.00 4,073.00 3,053.20 74.962 1,019.80 122-50020-045-000 Retirement 68,264.00 68,264.00 4,710.29 38,863.64 56.931 29,400.36 122-50026-045-000 Medical Insurance 53,184.00 53,184.00 3,327.07 23,369.79 43.941 29,814.21 122-50027-045-000 Dental Insurance 3,288.00 3,288.00 290.46 2,042.18 62.110 1,245.82 122-50028-045-000 Vision Insurance 857.00 857.00 65.62 461.28 53.825 395.72 122-50029-045-000 Life Insurance & Other 2,740.00 2,740.00 2,740.00 122-50030-045-000 Social Security Taxes 30,231.00 30,231.00 2,033.76 16,838.59 55.700 13,392.41 122-50035-045-000 Medicare Taxes 7,070.00 7,070.00 475.58 3,938.09 55.701 3,131.91 122-50040-045-000 Unemployment Taxes 1,476.00 1,476.00 13.72 623.61 42.250 852.39 122-50045-045-000 Workman's Compensation 8,793.00 9,209.00 9,208.69 99.997 .31 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 89.00 13.185 586.00 Subtotal: 664,179.00 666,235.00 46,790.19 380,122.91 57.055 286,112.09 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 1,355.75 3,872.39 40.498 5,689.61 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 3,051.59 4,851.81 32.672 9,998.19 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 4,137.18 42.182 5,670.82 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 2,407.43 5,540.61 50.369 5,459.39 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 393.00 786.00 71.260 317.00 122-55160-045-000 Professional Outside Services 20,000.00 19,623.00 19,623.00 Subtotal: 66,323.00 65,946.00 7,207.77 19,187.99 29.097 46,758.01 122-60005-045-000 Telephone 106.00 106.00 2.29 29.70 28.019 76.30 122-60010-045-000 Communications/Pagers/Mobiles 4,411.00 4,411.00 134.81 1,346.93 30.536 3,064.07 122-60020-045-000 Electricity/Gas 18,270.00 18,270.00 948.25 6,711.73 36.736 11,558.27 122-60025-045-000 Water 3,289.00 3,289.00 131.13 1,796.99 54.636 1,492.01 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 100.000 122-60035-045-000 Postage 97.00 97.00 4.65 28.00 28.866 69.00 122-60055-045-000 Insurance 20,974.00 20,974.00 8,078.00 38.514 12,896.00 122-60066-045-000 Publications/Books/Subscrips 401.00 401.00 401.00 122-60070-045-000 Dues & Memberships 8,560.00 8,560.00 150.00 6,330.34 73.953 2,229.66 122-60075-045-000 Meetings 75.00 22.00 29.333 53.00 122-60080-045-000 Schools & Training 6,946.00 6,946.00 646.70 1,844.17 26.550 5,101.83 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 6,788.00 6,788.00 160.76 1,806.85 26.618 4,981.15 122-60110-045-000 Physicals/Testing 1,918.00 1,918.00 1,918.00 122-60125-045-000 Advertising 156.00 156.00 156.00 122-60160-045-000 Programs & Special Projects 4,162.00 4,162.00 52.39 1,901.96 45.698 2,260.04 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 394.95 20.787 1,505.05 . glbase_tbam rgonzale Trophy Club Entities Page 3 17:53 05/10/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60195-045-000 Flags & Repair 2,543.00 2,543.00 1,012.50 39.815 1,530.50 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 28.92 691.79 55.925 545.21 Subtotal: 390,758.00 390,833.00 2,259.90 340,995.91 87.248 49,837.09 122-65005-045-000 Fuel & Lube 17,414.00 17,414.00 689.60 3,305.31 18.981 14,108.69 122-65010-045-000 Uniforms 4,357.00 4,357.00 92.87 1,378.60 31.641 2,978.40 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 5,810.00 5,893.50 77.546 1,706.50 122-65030-045-000 Chemicals 1,545.00 1,545.00 1,545.00 122-65035-045-000 Small Tools 8,371.00 8,371.00 194.85 1,659.81 19.828 6,711.19 122-65085-045-000 Office Supplies 329.00 1,200.00 632.64 52.720 567.36 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 244.17 1,101.09 39.536 1,683.91 122-65105-045-000 Printing 106.00 106.00 24.77 23.368 81.23 Subtotal: 42,507.00 43,378.00 7,031.49 13,995.72 32.265 29,382.28 122-69006-045-000 Grant Match 3,000.00 3,000.00 3,000.00 122-69035-045-000 Vehicles 13,709.00 13,709.00 13,333.09 97.258 375.91 122-69050-045-000 Radios 2,500.00 2,500.00 2,500.00 122-69195-045-000 GASB34/Reserve for Replacement 41,890.00 41,890.00 41,890.00 122-69251-045-000 Engine 681 Payment 73,203.00 73,203.00 4,351.65 5.945 68,851.35 122-69255-045-000 Airpacks 13,865.00 13,865.00 14,526.00 14,526.00 104.767 661.00- Subtotal: 148,167.00 148,167.00 14,526.00 32,210.74 21.739 115,956.26 Program number: 1,311,934.00 1,314,559.00 77,815.35 786,513.27 59.831 528,045.73 Department number: Fire 1,311,934.00 1,314,559.00 77,815.35 786,513.27 59.831 528,045.73 Expenditures Subtotal ----------- 1,311,934.00 1,314,559.00 77,815.35 786,513.27 59.831 528,045.73 Fund number: 122 Trophy Club MUD Fire Dept. 67,213.05 485,248.23- 485,248.23 . glbase_tbam rgonzale Trophy Club Entities Page 4 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 97,495.00- 97,495.00- 455.36- 95,198.70- 97.645 2,296.30- 135-40002-000-000 Property Taxes/Delinquent 451.00- .03- 671.76 -148.949 1,122.76- 135-40015-000-000 Property Taxes/P & I 1,334.00- 1,334.00- 37.99- 52.77 -3.956 1,386.77- Subtotal: 98,829.00- 99,280.00- 493.38- 94,474.17- 95.159 4,805.83- 135-43215-000-000 Insurance Settlement 3,999.00- 3,999.00 Subtotal: 3,999.00- 3,999.00 135-47000-000-000 Water 1,990,800.00- 1,990,800.00- 111,516.42- 680,051.42- 34.160 1,310,748.58- 135-47005-000-000 Sewer 1,325,000.00- 1,325,000.00- 83,387.02- 520,512.84- 39.284 804,487.16- 135-47010-000-000 Commercial Water 825,000.00- 825,000.00- 41,371.50- 310,654.34- 37.655 514,345.66- 135-47015-000-000 Commercial Sewer 360,000.00- 360,000.00- 22,651.48- 151,833.26- 42.176 208,166.74- 135-47020-000-000 Standby 775.00- 775.00- 54.00- 425.00- 54.839 350.00- 135-47025-000-000 Penalties 50,500.00- 50,500.00- 2,257.45- 28,755.83- 56.942 21,744.17- 135-47030-000-000 Service Charges 17,500.00- 17,500.00- 637.00- 7,879.38- 45.025 9,620.62- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 50.00- 1,100.00- 91.667 100.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 150.00- 3,300.00- 73.333 1,200.00- 135-47070-000-000 TCCC Effluent Charges 57,500.00- 57,500.00- 8,212.62- 14.283 49,287.38- 135-47270-000-000 Fire Line 5,000.00- 5,000.00- 5,000.00- 135-47400-000-000 Water-Out of Dist/Port Meters 41,595.00- 41,595.00- 2,064.03- 20,949.77- 50.366 20,645.23- 135-47405-000-000 Out of District Sewer 11,807.00- 11,807.00- 857.11- 6,508.89- 55.127 5,298.11- 135-47410-000-000 Out of Dist/Portable Penalties 300.00- 300.00- 7.85- 36.16- 12.053 263.84- 135-47600-000-000 PID #1 Water 425,000.00- 425,000.00- 37,788.93- 216,015.82- 50.827 208,984.18- 135-47605-000-000 PID #1 Sewer 185,000.00- 185,000.00- 21,903.59- 126,338.29- 68.291 58,661.71- Subtotal: 5,301,477.00- 5,301,477.00- 324,696.38- 2,082,573.62- 39.283 3,218,903.38- 135-48005-000-000 Utility Fees 338,880.00- 161,000.00- 48,300.00- 421,680.00- 261.913 260,680.00 Subtotal: 338,880.00- 161,000.00- 48,300.00- 421,680.00- 261.913 260,680.00 135-49005-000-000 Loan Proceeds 1,100,000.00- 1,100,000.00- 100.000 135-49010-000-000 Interest Income 4,500.00- 4,500.00- 479.97- 2,879.85- 63.997 1,620.15- 135-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 135-49016-000-000 Cell Tower Revenue 10,164.00- 847.00- 5,929.00- 58.333 4,235.00- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 4,083.31- 58.333 2,916.69- 135-49030-000-000 Vending Revenue 600.00- 600.00- 32.50- 5.417 567.50- 135-49035-000-000 Prior Year Reserves 241,981.00- 265,707.00- 265,707.00- 135-49036-000-000 GASB Reserves 26,911.00- 26,911.00- 26,911.00- 135-49075-000-000 Oversize Meter Reimbursement 64,000.00- 64,000.00- 6,424.00- 65,772.80- 102.770 1,772.80 135-49900-000-000 Miscellaneous Income 10,000.00- 10,000.00- 2,778.11- 27.781 7,221.89- 135-49905-000-000 Gas Well Revenue 800.00- 800.00- 123.00- 15.375 677.00- . glbase_tbam rgonzale Trophy Club Entities Page 5 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 355,792.00- 1,797,682.00- 8,334.30- 1,181,598.57- 65.729 616,083.43- Program number: 6,094,978.00- 7,359,439.00- 381,824.06- 3,784,325.36- 51.421 3,575,113.64- Department number: Revenues 6,094,978.00- 7,359,439.00- 381,824.06- 3,784,325.36- 51.421 3,575,113.64- Revenues Subtotal ----------- 6,094,978.00- 7,359,439.00- 381,824.06- 3,784,325.36- 51.421 3,575,113.64- . glbase_tbam rgonzale Trophy Club Entities Page 6 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 199,759.00 160,600.00 11,776.37 90,456.48 56.324 70,143.52 135-50010-010-000 Overtime 13,250.00 13,250.00 1,795.01 9,736.03 73.479 3,513.97 135-50016-010-000 Longevity 2,620.00 2,620.00 2,620.00 100.000 135-50017-010-000 Certification 1,800.00 1,800.00 900.00 50.000 900.00 135-50020-010-000 Retirement 25,508.00 25,508.00 1,868.76 14,941.83 58.577 10,566.17 135-50026-010-000 Medical Insurance 22,607.00 22,607.00 1,461.81 12,524.31 55.400 10,082.69 135-50027-010-000 Dental Insurance 2,169.00 2,169.00 112.68 909.28 41.922 1,259.72 135-50028-010-000 Vision Insurance 576.00 576.00 28.79 219.35 38.082 356.65 135-50029-010-000 Life Insurance & Other 1,161.00 1,161.00 1,161.00 135-50030-010-000 Social Security Taxes 13,481.00 12,000.00 813.93 6,320.86 52.674 5,679.14 135-50035-010-000 Medicare Taxes 3,153.00 2,700.00 190.35 1,478.26 54.750 1,221.74 135-50040-010-000 Unemployment Taxes 945.00 945.00 288.00 30.476 657.00 135-50045-010-000 Workman's Compensation 5,581.00 5,581.00 5,581.00 100.000 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 350.00 350.00 26.60 118.64 33.897 231.36 Subtotal: 293,160.00 252,067.00 18,074.30 146,094.04 57.958 105,972.96 135-55005-010-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-010-000 Independent Labor 500.00 500.00 500.00 135-55080-010-000 Maintenance & Repairs 29,500.00 29,500.00 992.05 13,258.80 44.945 16,241.20 135-55090-010-000 Vehicle Maintenance 3,380.00 3,380.00 499.63 2,467.40 73.000 912.60 135-55100-010-000 Building Maint & Supplies 750.00 750.00 471.85 62.913 278.15 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 464.49 16.017 2,435.51 135-55135-010-000 Lab Analysis 4,500.00 4,500.00 245.00 1,465.00 32.556 3,035.00 Subtotal: 43,030.00 43,030.00 1,736.68 18,127.54 42.128 24,902.46 135-60010-010-000 Communications/Pagers/Mobiles 1,599.00 1,599.00 178.24 1,184.80 74.096 414.20 135-60020-010-000 Electricity 162,000.00 127,500.00 3,457.04 27,983.75 21.948 99,516.25 135-60035-010-000 Postage 500.00 500.00 6.51 1.302 493.49 135-60050-010-000 Bad Debt Expense 4,200.00 4,200.00 4,200.00 135-60066-010-000 Publications/Books/Subscripts 50.00 50.00 85.00 170.000 35.00- 135-60070-010-000 Dues & Memberships 150.00 150.00 111.00 111.00 74.000 39.00 135-60080-010-000 Schools & Training 2,800.00 2,800.00 1,082.00 38.643 1,718.00 135-60090-010-000 Safety Program 500.00 500.00 500.00 135-60100-010-000 Travel & per diem 3,200.00 3,200.00 73.26 1,010.71 31.585 2,189.29 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 Annual Permit Fee 6,600.00 6,600.00 7,965.75 120.693 1,365.75- 135-60150-010-000 Wholesale Water 1,720,000.00 1,720,000.00 110,026.92 657,453.33 38.224 1,062,546.67 135-60245-010-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 20.38 380.38 9.057 3,819.62 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 2,000.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 1,500.00 299.99 19.999 1,200.01 . glbase_tbam rgonzale Trophy Club Entities Page 7 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 1,910,799.00 1,876,299.00 113,866.84 697,563.22 37.178 1,178,735.78 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 1,155.19 7,188.95 47.246 8,027.05 135-65010-010-000 Uniforms 3,690.00 3,690.00 109.97 1,134.12 30.735 2,555.88 135-65030-010-000 Chemicals 6,200.00 6,200.00 318.30 1,384.77 22.335 4,815.23 135-65035-010-000 Small Tools 2,500.00 2,500.00 135.00 203.00 8.120 2,297.00 135-65040-010-000 Safety Equipment 2,500.00 2,500.00 287.82 11.513 2,212.18 135-65050-010-000 Meter Expense 85,000.00 94,000.00 27,150.00 90,769.07 96.563 3,230.93 135-65055-010-000 Hardware 1,000.00 1,000.00 1,000.00 135-65085-010-000 Office Supplies 30.00 30.00 30.00- 135-65095-010-000 Maintenance Supplies 32,000.00 32,000.00 494.88 10,717.45 33.492 21,282.55 135-65100-010-000 Copies 50.00 50.00 50.00 135-65105-010-000 Printing 150.00 150.00 58.50 39.000 91.50 Subtotal: 148,306.00 157,306.00 29,393.34 111,773.68 71.055 45,532.32 135-69005-010-000 Capital Expenses 888,432.00 1,455,600.00 1,265,870.59 86.966 189,729.41 135-69008-010-000 Short Term Debt Payments 421,050.00 421,050.00 135-69035-010-000 Vehicles 27,000.00 27,000.00 30,213.69 111.903 3,213.69- 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 24,000.00 24,000.00 24,000.00 135-69281-010-000 Capital Repair-Ground Storage 124,771.00 108,817.00 100,816.54 92.648 8,000.46 135-69295-010-000 Unexpected Maintenance 250.00 250.00 250.00 135-69305-010-000 Capital Leases 11,490.00 11,490.00 10,145.26 88.296 1,344.74 Subtotal: 1,105,943.00 2,078,207.00 1,407,046.08 67.705 671,160.92 Program number: 3,501,238.00 4,406,909.00 163,071.16 2,380,604.56 54.020 2,026,304.44 Department number: Water 3,501,238.00 4,406,909.00 163,071.16 2,380,604.56 54.020 2,026,304.44 . glbase_tbam rgonzale Trophy Club Entities Page 8 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 182,147.00 182,147.00 15,611.86 114,700.44 62.971 67,446.56 135-50010-020-000 Overtime 10,166.00 10,166.00 970.71 7,262.09 71.435 2,903.91 135-50016-020-000 Longevity 3,976.00 3,976.00 3,975.00 99.975 1.00 135-50017-020-000 Certification 2,400.00 2,400.00 825.00 34.375 1,575.00 135-50020-020-000 Retirement 27,816.00 27,816.00 2,281.72 18,212.51 65.475 9,603.49 135-50026-020-000 Medical Insurance 30,805.00 30,805.00 2,400.16 15,203.30 49.353 15,601.70 135-50027-020-000 Dental Insurance 1,981.00 1,981.00 181.86 1,166.20 58.869 814.80 135-50028-020-000 Vision Insurance 552.00 552.00 45.05 290.21 52.574 261.79 135-50029-020-000 Life Insurance & Other 884.00 884.00 884.00 135-50030-020-000 Social Security Taxes 8,597.00 11,293.00 913.98 7,354.92 65.128 3,938.08 135-50035-020-000 Medicare Taxes 2,011.00 2,645.00 213.74 1,720.07 65.031 924.93 135-50040-020-000 Unemployment Taxes 567.00 567.00 315.84 55.704 251.16 135-50045-020-000 Workman's Compensation 2,685.00 2,685.00 2,685.00 100.000 135-50060-020-000 Pre-emp Physicals/Testing 200.00 30.45 15.225 169.55 135-50070-020-000 Employee Relations 350.00 350.00 64.45 18.414 285.55 Subtotal: 274,937.00 278,467.00 22,619.08 173,805.48 62.415 104,661.52 135-55070-020-000 Independent Labor 750.00 15,000.00 1,905.67 12.704 13,094.33 135-55080-020-000 Maintenance & Repairs 17,750.00 40,000.00 1,320.98 21,183.95 52.960 18,816.05 135-55090-020-000 Vehicle Maintenance 4,998.00 4,998.00 39.75 234.70 4.696 4,763.30 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 1,400.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 148.50 5.034 2,801.50 135-55125-020-000 Dumpster Services 35,000.00 35,000.00 13,975.00 24,187.50 69.107 10,812.50 135-55135-020-000 Lab Analysis 22,760.00 35,000.00 10,506.12 30.017 24,493.88 Subtotal: 85,608.00 134,348.00 15,335.73 58,166.44 43.295 76,181.56 135-60005-020-000 Telephone 100.00 1.44 12.03 12.030 87.97 135-60010-020-000 Communications/Pagers/Mobiles 3,000.00 3,000.00 163.22 1,541.95 51.398 1,458.05 135-60020-020-000 Electricity 205,000.00 161,160.00 10,252.14 34,373.26 21.329 126,786.74 135-60025-020-000 Water 1,900.00 1,900.00 156.91 1,383.06 72.793 516.94 135-60035-020-000 Postage 120.00 120.00 120.00 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 438.17 87.634 61.83 135-60080-020-000 Schools & Training 1,320.00 1,320.00 111.00 111.00 8.409 1,209.00 135-60090-020-000 Safety Program 200.00 200.00 116.45 58.225 83.55 135-60100-020-000 Travel & per diem 1,750.00 1,750.00 202.02 1,292.60 73.863 457.40 135-60105-020-000 Rent/Lease Equipment 200.00 200.00 901.30 450.650 701.30- 135-60125-020-000 Advertising 1,500.00 987.36 65.824 512.64 135-60135-020-000 Annual Permit Fee 7,500.00 7,500.00 7,432.50 99.100 67.50 135-60245-020-000 Miscellaneous Expenses 525.00 525.00 12.02 76.02 14.480 448.98 135-60285-020-000 Lawn Equipment & Maintenance 525.00 525.00 525.00 Subtotal: 222,540.00 180,300.00 10,898.75 48,665.70 26.992 131,634.30 . glbase_tbam rgonzale Trophy Club Entities Page 9 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 6,875.00 6,875.00 563.62 2,134.23 31.043 4,740.77 135-65010-020-000 Uniforms 3,140.00 3,140.00 1,118.93 35.635 2,021.07 135-65030-020-000 Chemicals 13,180.00 13,180.00 900.00 4,137.57 31.393 9,042.43 135-65035-020-000 Small Tools 1,260.00 1,260.00 1,260.00 135-65040-020-000 Safety Equipment 925.00 925.00 22.75 2.459 902.25 135-65045-020-000 Lab Supplies 19,160.00 12,000.00 1,053.93 4,210.11 35.084 7,789.89 135-65055-020-000 Hardware 525.00 525.00 525.00 135-65085-020-000 Office Supplies 400.00 400.00 48.96 99.54 24.885 300.46 135-65095-020-000 Maintenance Supplies 8,860.00 8,860.00 883.14 1,836.46 20.728 7,023.54 135-65115-020-000 Other Consumables 110.00 110.00 110.00 Subtotal: 54,435.00 47,275.00 3,449.65 13,559.59 28.682 33,715.41 135-69005-020-000 Capital Expenses 161,189.00 111,021.00 43,592.56 39.265 67,428.44 135-69008-020-000 Short Term Debt Payments 118,689.00 118,689.00 135-69280-020-000 Capital Repairs 56,000.00 56,000.00 56,000.00 Subtotal: 217,189.00 285,710.00 43,592.56 15.258 242,117.44 Program number: 854,709.00 926,100.00 52,303.21 337,789.77 36.474 588,310.23 Department number: Wastewater 854,709.00 926,100.00 52,303.21 337,789.77 36.474 588,310.23 . glbase_tbam rgonzale Trophy Club Entities Page 10 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 145,481.00 145,481.00 10,039.90 79,299.25 54.508 66,181.75 135-50010-021-000 Overtime 7,297.00 7,297.00 838.51 5,126.97 70.261 2,170.03 135-50016-021-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50017-021-000 Certification 1,500.00 1,500.00 750.00 50.000 750.00 135-50020-021-000 Retirement 21,074.00 21,074.00 1,503.39 12,806.60 60.770 8,267.40 135-50026-021-000 Medical Insurance 22,983.00 22,983.00 1,423.55 11,639.63 50.645 11,343.37 135-50027-021-000 Dental Insurance 1,533.00 1,533.00 99.19 803.47 52.412 729.53 135-50028-021-000 Vision Insurance 357.00 357.00 25.46 203.78 57.081 153.22 135-50029-021-000 Life Insurance & Other 978.00 978.00 978.00 135-50030-021-000 Social Security Taxes 9,785.00 9,785.00 631.16 5,287.73 54.039 4,497.27 135-50035-021-000 Medicare Taxes 2,288.00 2,288.00 147.61 1,236.65 54.049 1,051.35 135-50040-021-000 Unemployment Taxes 567.00 567.00 216.00 38.095 351.00 135-50045-021-000 Workman's Compensation 3,056.00 3,056.00 3,056.00 100.000 135-50070-021-000 Employee Relations 250.00 250.00 64.43 25.772 185.57 Subtotal: 220,697.00 220,697.00 14,708.77 124,038.01 56.203 96,658.99 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-021-000 Independent Labor 200.00 200.00 200.00 135-55080-021-000 Maintenance & Repairs 23,700.00 23,700.00 209.00 3,992.85 16.847 19,707.15 135-55090-021-000 Vehicle Maintenance 1,943.00 1,943.00 209.50 10.782 1,733.50 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 28,093.00 28,093.00 209.00 4,202.35 14.959 23,890.65 135-60005-021-000 Telephone 50.00 .96 15.17 30.340 34.83 135-60010-021-000 Communications/Pagers/Mobiles 2,796.00 2,796.00 205.10 1,957.21 70.000 838.79 135-60020-021-000 Electricity 23,625.00 21,550.00 1,273.78 5,926.21 27.500 15,623.79 135-60025-021-000 Water 750.00 750.00 750.00 135-60035-021-000 Postage 150.00 150.00 150.00 135-60070-021-000 Dues & Memberships 255.00 255.00 255.00 135-60080-021-000 Schools & Training 2,818.00 2,818.00 2,818.00 135-60090-021-000 Safety Program 750.00 750.00 750.00 135-60100-021-000 Travel & per diem 1,500.00 1,500.00 35.52 464.57 30.971 1,035.43 135-60105-021-000 Rent/Lease Equipment 44,107.00 76,098.00 76,098.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60280-021-000 Property Maintenance 1,000.00 1,000.00 1,000.00 Subtotal: 77,851.00 107,817.00 1,515.36 8,363.16 7.757 99,453.84 135-65005-021-000 Fuel & Lube 11,700.00 11,700.00 898.97 4,903.32 41.909 6,796.68 135-65010-021-000 Uniforms 2,505.00 2,505.00 620.98 24.790 1,884.02 135-65030-021-000 Chemicals 12,500.00 12,500.00 12,500.00 135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00 . glbase_tbam rgonzale Trophy Club Entities Page 11 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65040-021-000 Safety Equipment 1,150.00 1,150.00 22.74 1.977 1,127.26 135-65055-021-000 Hardware 750.00 750.00 44.95 5.993 705.05 135-65095-021-000 Maintenance Supplies 16,050.00 16,050.00 204.14 1.272 15,845.86 Subtotal: 46,155.00 46,155.00 898.97 5,796.13 12.558 40,358.87 135-69005-021-000 Capital Expenses 15,000.00 15,000.00 31,991.00 213.273 16,991.00- 135-69035-021-000 Vehicles 1,001.25 1,001.25 1,001.25- 135-69280-021-000 Capital Repairs 20,000.00 80,000.00 80,000.00 Subtotal: 35,000.00 95,000.00 1,001.25 32,992.25 34.729 62,007.75 Program number: 407,796.00 497,762.00 18,333.35 175,391.90 35.236 322,370.10 Department number: Collection 407,796.00 497,762.00 18,333.35 175,391.90 35.236 322,370.10 . glbase_tbam rgonzale Trophy Club Entities Page 12 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 4,900.00 49.000 5,100.00 135-50030-026-000 Social Security Taxes 620.00 620.00 303.80 49.000 316.20 135-50035-026-000 Medicare Taxes 145.00 145.00 71.05 49.000 73.95 135-50040-026-000 Unemployment Taxes 210.00 210.00 39.20 18.667 170.80 135-50045-026-000 Workman's Compensation 120.00 120.00 120.00 100.000 Subtotal: 11,095.00 11,095.00 5,434.05 48.977 5,660.95 135-60035-026-000 Postage 50.00 26.11 52.220 23.89 135-60066-026-000 Publications/Books/Subscripts 50.00 135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 685.00 32.619 1,415.00 135-60075-026-000 Meetings 1,278.00 1,278.00 262.00 614.56 48.088 663.44 135-60080-026-000 Schools & Training 4,150.00 4,150.00 224.87 1,099.87 26.503 3,050.13 135-60100-026-000 Travel & per diem 6,199.00 6,199.00 32.19 .519 6,166.81 135-60245-026-000 Miscellaneous Expenses 3,200.00 3,200.00 1,017.69 31.803 2,182.31 Subtotal: 16,977.00 16,977.00 486.87 3,475.42 20.471 13,501.58 135-65085-026-000 Office Supplies 50.00 50.00 8.90 17.800 41.10 Subtotal: 50.00 50.00 8.90 17.800 41.10 Program number: 28,122.00 28,122.00 486.87 8,918.37 31.713 19,203.63 Department number: Board of Directors 28,122.00 28,122.00 486.87 8,918.37 31.713 19,203.63 . glbase_tbam rgonzale Trophy Club Entities Page 13 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-027-000 Salaries & Wages 236,831.00 236,831.00 17,953.66 171,856.08 72.565 64,974.92 135-50010-027-000 Overtime 1,000.00 1,028.00 6.15 1,034.12 100.595 6.12- 135-50016-027-000 Longevity 1,845.00 1,845.00 3,705.00 200.813 1,860.00- 135-50020-027-000 Retirement 33,471.00 33,471.00 2,388.11 24,855.44 74.260 8,615.56 135-50026-027-000 Medical Insurance 18,798.00 18,798.00 1,431.62 9,933.76 52.845 8,864.24 135-50027-027-000 Dental Insurance 1,242.00 1,242.00 119.35 764.42 61.548 477.58 135-50028-027-000 Vision Insurance 341.00 341.00 28.03 189.42 55.548 151.58 135-50029-027-000 Life Insurance & Other 1,337.00 1,337.00 1,337.00 135-50030-027-000 Social Security Taxes 14,860.00 14,860.00 1,013.70 10,585.52 71.235 4,274.48 135-50035-027-000 Medicare Taxes 3,475.00 3,475.00 237.08 2,513.53 72.332 961.47 135-50040-027-000 Unemployment Taxes 756.00 756.00 63.12 311.13 41.155 444.87 135-50045-027-000 Workman's Compensation 580.00 580.00 580.00 100.000 135-50060-027-000 Pre-emp Physicals/Testing 35.00 35.00 35.00- 135-50070-027-000 Employee Relations 5,000.00 5,000.00 3,474.16 69.483 1,525.84 Subtotal: 319,536.00 319,564.00 23,275.82 229,837.58 71.922 89,726.42 135-55070-027-000 Independent Labor 840.00 840.00 221.25 26.339 618.75 135-55075-027-000 Records Management 500.00 500.00 500.00 135-55160-027-000 Professional Outside Services 176,870.00 190,979.00 190,769.36 99.890 209.64 Subtotal: 178,210.00 192,319.00 190,990.61 99.309 1,328.39 135-60005-027-000 Telephone 300.00 300.00 44.71 167.15 55.717 132.85 135-60010-027-000 Communications/Pagers/Mobiles 2,420.00 2,420.00 90.86 1,124.91 46.484 1,295.09 135-60035-027-000 Postage 1,800.00 59.59 959.40 53.300 840.60 135-60066-027-000 Publications/Books/Subscripts 450.00 450.00 354.15 78.700 95.85 135-60070-027-000 Dues & Memberships 1,742.00 1,742.00 85.00 527.05 30.255 1,214.95 135-60075-027-000 Meetings 312.00 312.00 22.00 22.00 7.051 290.00 135-60080-027-000 Schools & Training 2,555.00 2,555.00 735.00 1,405.00 54.990 1,150.00 135-60100-027-000 Travel & per diem 3,851.00 3,851.00 628.00 16.307 3,223.00 135-60115-027-000 Elections 2,500.00 2,500.00 2,500.00 135-60125-027-000 Advertising 4,700.00 4,700.00 4,700.00 135-60245-027-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60270-027-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 100.000 135-60360-027-000 Furniture/Equipment < $5000 2,225.00 2,225.00 299.99 13.483 1,925.01 Subtotal: 31,155.00 32,955.00 1,037.16 15,487.65 46.996 17,467.35 135-65085-027-000 Office Supplies 2,450.00 2,450.00 242.94 1,342.32 54.789 1,107.68 135-65105-027-000 Printing 515.00 750.00 589.45 78.593 160.55 Subtotal: 2,965.00 3,200.00 242.94 1,931.77 60.368 1,268.23 . glbase_tbam rgonzale Trophy Club Entities Page 14 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Program number: 531,866.00 548,038.00 24,555.92 438,247.61 79.967 109,790.39 Department number: Manager's Office 531,866.00 548,038.00 24,555.92 438,247.61 79.967 109,790.39 . glbase_tbam rgonzale Trophy Club Entities Page 15 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50070-028-000 Employee Relations 1,967.00 1,967.00 1,470.22 74.744 496.78 135-50075-028-000 Tuition Reimbursement 1,561.00 1,561.00 19.95 1.278 1,541.05 Subtotal: 3,528.00 3,528.00 1,490.17 42.238 2,037.83 135-60005-028-000 Telephone 28.00 28.00 28.00 135-60035-028-000 Postage 106.00 106.00 106.00 135-60066-028-000 Publications/Books/Subscripts 485.00 485.00 485.00 135-60070-028-000 Dues & Memberships 555.00 555.00 555.00 135-60075-028-000 Meetings 138.00 138.00 138.00 135-60080-028-000 Schools & Training 594.00 594.00 594.00 135-60100-028-000 Travel & per diem 8.00 135-60110-028-000 Physicals/Testing 1,560.00 1,560.00 105.00 6.731 1,455.00 Subtotal: 3,474.00 3,466.00 105.00 3.029 3,361.00 135-65085-028-000 Office Supplies 437.00 437.00 437.00 135-65105-028-000 Printing 116.00 116.00 116.00 Subtotal: 553.00 553.00 553.00 Program number: 7,555.00 7,547.00 1,595.17 21.136 5,951.83 Department number: Human Resources 7,555.00 7,547.00 1,595.17 21.136 5,951.83 . glbase_tbam rgonzale Trophy Club Entities Page 16 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-029-000 Salaries & Wages 94,404.00 94,404.00 6,002.36 48,023.85 50.871 46,380.15 135-50010-029-000 Overtime 1,000.00 1,000.00 946.28 94.628 53.72 135-50016-029-000 Longevity 1,823.00 1,823.00 1,822.50 99.973 .50 135-50020-029-000 Retirement 13,612.00 13,612.00 829.52 7,368.60 54.133 6,243.40 135-50026-029-000 Medical Insurance 11,060.00 11,060.00 410.70 4,542.48 41.071 6,517.52 135-50027-029-000 Dental Insurance 773.00 773.00 49.02 428.89 55.484 344.11 135-50028-029-000 Vision Insurance 207.00 207.00 6.76 67.39 32.556 139.61 135-50029-029-000 Life Insurance & Other 567.00 567.00 567.00 135-50030-029-000 Social Security Taxes 5,386.00 5,386.00 345.84 2,950.37 54.778 2,435.63 135-50035-029-000 Medicare Taxes 1,260.00 1,260.00 80.88 690.01 54.763 569.99 135-50040-029-000 Unemployment Taxes 284.00 284.00 79.54 28.007 204.46 135-50045-029-000 Workman's Compensation 235.00 235.00 211.00 89.787 24.00 Subtotal: 130,611.00 130,611.00 7,725.08 67,130.91 51.398 63,480.09 135-55160-029-000 Professional Outside Services 5,000.00 5,000.00 1,105.50 22.110 3,894.50 Subtotal: 5,000.00 5,000.00 1,105.50 22.110 3,894.50 135-60005-029-000 Telephone 103.00 103.00 8.24 54.51 52.922 48.49 135-60010-029-000 Communications/Pagers/Mobiles 683.00 683.00 51.87 357.47 52.338 325.53 135-60035-029-000 Postage 700.00 700.00 26.00 180.09 25.727 519.91 135-60040-029-000 Service Charges & Fees 79.00 79.00 32.50 41.139 46.50 135-60066-029-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-029-000 Dues & Memberships 660.00 660.00 660.00 135-60075-029-000 Meetings 300.00 300.00 22.00 7.333 278.00 135-60080-029-000 Schools & Training 2,000.00 2,000.00 225.00 11.250 1,775.00 135-60100-029-000 Travel & per diem 1,500.00 27.81 27.81- 135-60125-029-000 Advertising 1,210.00 1,210.00 1,210.00 135-60245-029-000 Miscellaneous Expenses 200.00 200.00 200.00 Subtotal: 7,935.00 6,435.00 86.11 899.38 13.976 5,535.62 135-65085-029-000 Office Supplies 849.00 849.00 21.80 128.67 15.155 720.33 135-65105-029-000 Printing 515.00 515.00 515.00 Subtotal: 1,364.00 1,364.00 21.80 128.67 9.433 1,235.33 Program number: 144,910.00 143,410.00 7,832.99 69,264.46 48.298 74,145.54 Department number: Finance 144,910.00 143,410.00 7,832.99 69,264.46 48.298 74,145.54 . glbase_tbam rgonzale Trophy Club Entities Page 17 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55030-033-000 Software & Support 64,149.00 64,149.00 7,353.41 42,558.15 66.343 21,590.85 135-55070-033-000 Independent Labor 1,650.00 1,650.00 375.00 22.727 1,275.00 Subtotal: 65,799.00 65,799.00 7,353.41 42,933.15 65.249 22,865.85 135-60005-033-000 Telephone 6,540.00 6,540.00 763.54 5,298.36 81.015 1,241.64 135-60235-033-000 Security 1,350.00 1,350.00 406.60 30.119 943.40 Subtotal: 7,890.00 7,890.00 763.54 5,704.96 72.306 2,185.04 135-65055-033-000 Hardware 83,238.00 83,238.00 2,435.12 63,630.44 76.444 19,607.56 135-65085-033-000 Office Supplies 371.00 371.00 176.93 47.690 194.07 135-65090-033-000 Printer Supplies & Maintenance 5,732.00 5,732.00 235.00 3,308.38 57.718 2,423.62 Subtotal: 89,341.00 89,341.00 2,670.12 67,115.75 75.123 22,225.25 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 256.85 1,541.10 44.670 1,908.90 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 256.85 1,541.10 5.076 28,819.90 Program number: 193,391.00 193,391.00 11,043.92 117,294.96 60.652 76,096.04 Department number: Information Systems 193,391.00 193,391.00 11,043.92 117,294.96 60.652 76,096.04 . glbase_tbam rgonzale Trophy Club Entities Page 18 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-037-000 Salaries & Wages 31,512.00 135-50020-037-000 Retirement 4,412.00 135-50026-037-000 Medical Insurance 9,027.00 135-50027-037-000 Dental Insurance 549.00 135-50028-037-000 Vision Insurance 138.00 135-50029-037-000 Life Insurance & Other 228.00 135-50030-037-000 Social Security Taxes 1,954.00 135-50035-037-000 Medicare Taxes 457.00 135-50040-037-000 Unemployment Taxes 189.00 135-50045-037-000 Workman's Compensation 861.00 861.00 861.00- 135-50060-037-000 Pre-emp Physicals/Testing 250.00 Subtotal: 49,577.00 861.00 861.00- 135-55100-037-000 Building Maint & Supplies 5,000.00 20,478.00 200.00 924.68 4.515 19,553.32 135-55120-037-000 Cleaning Services 25,000.00 2,021.02 9,540.14 38.161 15,459.86 Subtotal: 5,000.00 45,478.00 2,221.02 10,464.82 23.011 35,013.18 135-60020-037-000 Electricity 21,940.00 21,940.00 1,050.77 6,274.33 28.598 15,665.67 135-60025-037-000 Water 1,093.00 1,093.00 36.86 332.18 30.392 760.82 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 7,689.57 58.334 5,492.43 135-60055-037-000 Insurance 32,635.00 32,635.00 100.00 30,386.73 93.111 2,248.27 135-60360-037-000 Furniture/Equipment < $5000 2,500.00 4,750.00 4,750.00 Subtotal: 71,350.00 73,600.00 2,286.14 44,682.81 60.710 28,917.19 135-65095-037-000 Maintenance Supplies 2,205.00 2,205.00 62.87 714.24 32.392 1,490.76 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 4.00 80.03 8.003 919.97 Subtotal: 3,205.00 3,205.00 66.87 794.27 24.782 2,410.73 Program number: 129,132.00 122,283.00 4,574.03 56,802.90 46.452 65,480.10 Department number: Facilities Maintenance 129,132.00 122,283.00 4,574.03 56,802.90 46.452 65,480.10 . glbase_tbam rgonzale Trophy Club Entities Page 19 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-038-000 Salaries & Wages 84,946.00 84,946.00 6,033.58 47,075.91 55.419 37,870.09 135-50010-038-000 Overtime 2,000.00 2,000.00 3.97 237.20 11.860 1,762.80 135-50016-038-000 Longevity 220.00 220.00 220.00 100.000 135-50020-038-000 Retirement 12,203.00 12,203.00 834.40 6,864.87 56.256 5,338.13 135-50026-038-000 Medical Insurance 12,321.00 12,321.00 851.08 6,396.46 51.915 5,924.54 135-50027-038-000 Dental Insurance 1,026.00 1,026.00 84.55 634.42 61.834 391.58 135-50028-038-000 Vision Insurance 260.00 260.00 19.93 149.67 57.565 110.33 135-50029-038-000 Life Insurance & Other 604.00 604.00 604.00 135-50030-038-000 Social Security Taxes 5,404.00 5,404.00 344.03 2,804.31 51.893 2,599.69 135-50035-038-000 Medicare Taxes 1,264.00 1,264.00 80.47 655.86 51.888 608.14 135-50040-038-000 Unemployment Taxes 473.00 473.00 3.38 189.99 40.167 283.01 135-50045-038-000 Workman's Compensation 211.00 211.00 235.00 111.374 24.00- Subtotal: 120,932.00 120,932.00 8,255.39 65,463.69 54.133 55,468.31 135-55070-038-000 Independent Labor 800.00 800.00 800.00 135-55205-038-000 Utility Billing Contract 11,000.00 11,000.00 6,001.07 54.555 4,998.93 Subtotal: 11,800.00 11,800.00 6,001.07 50.857 5,798.93 135-60005-038-000 Telephone 100.00 100.00 8.74 52.11 52.110 47.89 135-60010-038-000 Communications/Pagers/Mobiles 472.00 472.00 36.90 252.78 53.555 219.22 135-60035-038-000 Postage 18,000.00 18,000.00 8,474.64 47.081 9,525.36 135-60040-038-000 Service Charges & Fees 18,000.00 29,340.00 1,045.32 15,715.60 53.564 13,624.40 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 225.00 28.125 575.00 135-60100-038-000 Travel & per diem 605.00 605.00 605.00 135-60130-038-000 Reg Assessment Fee (5%) 22,500.00 22,500.00 25,071.20 111.428 2,571.20- 135-60245-038-000 Miscellaneous Expenses 200.00 200.00 200.00 Subtotal: 60,748.00 72,088.00 1,090.96 49,791.33 69.070 22,296.67 135-65085-038-000 Office Supplies 700.00 700.00 1.13 661.99 94.570 38.01 135-65105-038-000 Printing 3,250.00 3,250.00 3,250.00 Subtotal: 3,950.00 3,950.00 1.13 661.99 16.759 3,288.01 Program number: 197,430.00 208,770.00 9,347.48 121,918.08 58.398 86,851.92 Department number: Utility Billing 197,430.00 208,770.00 9,347.48 121,918.08 58.398 86,851.92 . glbase_tbam rgonzale Trophy Club Entities Page 20 17:53 05/10/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 55,000.00 70,000.00 10,612.00 55,107.54 78.725 14,892.46 135-55055-039-000 Auditing 20,200.00 20,200.00 20,200.00 100.000 135-55060-039-000 Appraisal 20,000.00 20,000.00 11,074.54 55.373 8,925.46 135-55065-039-000 Tax Admin Fees 3,629.00 3,629.00 2,470.09 68.065 1,158.91 Subtotal: 98,829.00 113,829.00 10,612.00 88,852.17 78.058 24,976.83 135-60344-039-000 Intergov Trans Out (Fire CIP) 2,278.00 2,277.85 99.993 .15 Subtotal: 2,278.00 2,277.85 99.993 .15 Program number: 98,829.00 116,107.00 10,612.00 91,130.02 78.488 24,976.98 Department number: Non Departmental 98,829.00 116,107.00 10,612.00 91,130.02 78.488 24,976.98 Expenditures Subtotal ----------- 6,094,978.00 7,198,439.00 302,160.93 3,798,957.80 52.775 3,399,481.20 Fund number: 135 MUD 1 General Fund 161,000.00- 79,663.13- 14,632.44 -9.088 175,632.44- . glbase_tbam rgonzale Trophy Club Entities Page 21 17:53 05/10/12 Budget Summary with Amendment Fund: 522 2010 GO/Fire Station Department: Revenues Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 522-49025-000-000 Auction Sales 22,570.00- 22,570.00 522-49145-000-000 Intergov Transfer-General Fund 2,277.85- 2,277.85 Subtotal: 24,847.85- 24,847.85 Program number: 24,847.85- 24,847.85 Department number: Revenues 24,847.85- 24,847.85 Revenues Subtotal ----------- 24,847.85- 24,847.85 . glbase_tbam rgonzale Trophy Club Entities Page 22 17:53 05/10/12 Budget Summary with Amendment Fund: 522 2010 GO/Fire Station Department: 65 Construction Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 522-60031-065-000 Temporary Housing & Storage 41.58 41.58- Subtotal: 41.58 41.58- Program number: 41.58 41.58- Department number: Construction 41.58 41.58- Expenditures Subtotal ----------- 41.58 41.58- Fund number: 522 2010 GO/Fire Station 24,806.27- 24,806.27 . glbase_tbam rgonzale Trophy Club Entities Page 23 17:53 05/10/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 550,663.00- 546,716.00- 2,571.85- 537,695.19- 98.350 9,020.81- 533-40002-000-000 Property Taxes/Delinquent 3,947.00- .65- 3,286.91 -83.276 7,233.91- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 215.21- 1,505.61- 30.010 3,511.39- Subtotal: 555,680.00- 555,680.00- 2,787.71- 535,913.89- 96.443 19,766.11- 533-48005-000-000 Utility Fees 6,120.00- 345,000.00- 6,120.00- 1.774 338,880.00- Subtotal: 6,120.00- 345,000.00- 6,120.00- 1.774 338,880.00- 533-49010-000-000 Interest Income 500.00- 1,700.00- 73.42- 928.35- 54.609 771.65- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00 533-49110-000-000 Premium on Bonds Sold 4,661.84- 4,661.84 Subtotal: 308,500.00- 1,700.00- 73.42- 313,590.19- ############### 311,890.19 Program number: 870,300.00- 902,380.00- 2,861.13- 855,624.08- 94.819 46,755.92- Department number: Revenues 870,300.00- 902,380.00- 2,861.13- 855,624.08- 94.819 46,755.92- Revenues Subtotal ----------- 870,300.00- 902,380.00- 2,861.13- 855,624.08- 94.819 46,755.92- . glbase_tbam rgonzale Trophy Club Entities Page 24 17:53 05/10/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 4/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 500.00 12.500 3,500.00 533-70025-051-000 Bond Interest Expense 301,300.00 301,300.00 150,650.00 50.000 150,650.00 533-70035-051-000 Bond Principal Payment 565,000.00 565,000.00 565,000.00 Subtotal: 870,300.00 870,300.00 151,150.00 17.368 719,150.00 Program number: 870,300.00 870,300.00 151,150.00 17.368 719,150.00 Department number: Administration 870,300.00 870,300.00 151,150.00 17.368 719,150.00 Expenditures Subtotal ----------- 870,300.00 870,300.00 151,150.00 17.368 719,150.00 Fund number: 533 MUD 1 I&S CONSOLIDATED 32,080.00- 2,861.13- 704,474.08- 2,195.992 672,394.08 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club Entities Page 1 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 893 04/09/2012 Property Taxes/Assessments (186,208.32) (348.56) (186,556.88) GL 894 04/10/2012 Property Taxes/Assessments (379.34) (186,936.22) GL 898 04/23/2012 Property Taxes/Assessments (374.46) (187,310.68) GL 899 04/24/2012 Property Taxes/Assessments (1,965.29) (189,275.97) GL 942 04/26/2012 Property Taxes/Assessments (56.59) (189,332.56) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (3,124.24) (189,332.56) ** (193,233.00) Budgeted (3,900.44) Remaining 98 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 895 04/11/2012 Property Taxes/Assessments (4,856.69) (842.19) (5,698.88) GL 898 04/23/2012 Property Taxes/Assessments (207.34) (5,906.22) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (1,049.53) (5,906.22) ** (4,900.00) Budgeted 1,006.22 Remaining 121 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 870 04/02/2012 Property Taxes/Assessments (1,046,583.67) (234.70) (1,046,818.37) GL 889 04/03/2012 Property Taxes/Assessments (525.89) (1,047,344.26) GL 890 04/04/2012 Property Taxes/Assessments (650.94) (1,047,995.20) GL 891 04/05/2012 Property Taxes/Assessments (598.82) (1,048,594.02) GL 892 04/09/2012 Property Taxes/Assessments (1,364.16) (1,049,958.18) GL 896 04/16/2012 Property Taxes/Assessments (282.71) (1,050,240.89) GL 897 04/20/2012 Property Taxes/Assessments (124.13) (1,050,365.02) GL 899 04/24/2012 Property Taxes/Assessments (825.96) (1,051,190.98) GL 900 04/25/2012 Property Taxes/Assessments (250.26) (1,051,441.24) GL 942 04/26/2012 Property Taxes/Assessments (14.12) (1,051,455.36) GL 943 04/27/2012 Property Taxes/Assessments (82.39) (1,051,537.75) GL 945 04/30/2012 Property Taxes/Assessments (75.90) (1,051,613.65) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (5,029.98) (1,051,613.65) ** (1,076,976.00) Budgeted (25,362.35) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 892 04/09/2012 Property Taxes/Assessments 5,462.06 (.29) 5,461.77 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (.29) 5,461.77 ** (5,603.00) Budgeted (11,064.77) Remaining -97 % Used . glpdatb2 rgonzale Trophy Club Entities Page 2 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40015-000-000 Property Taxes/Assessments P&I 893 04/09/2012 Property Taxes/Assessments (952.37) (31.37) (983.74) GL 894 04/10/2012 Property Taxes/Assessments (34.13) (1,017.87) GL 895 04/11/2012 Property Taxes/Assessments (226.12) (1,243.99) GL 898 04/23/2012 Property Taxes/Assessments (92.69) (1,336.68) GL 899 04/24/2012 Property Taxes/Assessments (488.09) (1,824.77) GL 942 04/26/2012 Property Taxes/Assessments (6.23) (1,831.00) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (878.63) (1,831.00) ** (725.00) Budgeted 1,106.00 Remaining 253 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 870 04/02/2012 Property Taxes/Assessments (1,773.26) (13.60) (1,786.86) GL 889 04/03/2012 Property Taxes/Assessments (21.11) (1,807.97) GL 890 04/04/2012 Property Taxes/Assessments (42.61) (1,850.58) GL 891 04/05/2012 Property Taxes/Assessments (53.89) (1,904.47) GL 892 04/09/2012 Property Taxes/Assessments (121.51) (2,025.98) GL 896 04/16/2012 Property Taxes/Assessments (25.68) (2,051.66) GL 897 04/20/2012 Property Taxes/Assessments (9.22) (2,060.88) GL 899 04/24/2012 Property Taxes/Assessments (90.85) (2,151.73) GL 900 04/25/2012 Property Taxes/Assessments (27.53) (2,179.26) GL 943 04/27/2012 Property Taxes/Assessments (9.07) (2,188.33) GL 945 04/30/2012 Property Taxes/Assessments (4.56) (2,192.89) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (419.63) (2,192.89) ** (7,500.00) Budgeted (5,307.11) Remaining 29 % Used Account: 122-42014-000-000 Fire Permits/Sprinkler (6,000.00) .00 (6,000.00) _______________ Account: 122-42014-000-000 Fire Permits/Sprinkler Totals: .00 (6,000.00) ** (6,000.00) Budgeted .00 Remaining 100 % Used Account: 122-43400-000-000 Fire Inspections (1,125.00) .00 (1,125.00) _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 (1,125.00) ** (500.00) Budgeted 625.00 Remaining 225 % Used Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire . glpdatb2 rgonzale Trophy Club Entities Page 3 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-43599-000-000 Misc Fire Revenue .00 .00 _______________ Account: 122-43599-000-000 Misc Fire Revenue Totals: .00 .00 ** (1,124.00) Budgeted (1,124.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 912 04/20/2012 Permits 4/20/12 (9,121.95) (100.00) (9,221.95) GL _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (100.00) (9,221.95) ** (7,998.00) Budgeted 1,223.95 Remaining 115 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,271,761.50) ** (1,314,559.00) Budgeted (42,797.50) Remaining 97 % Used . glpdatb2 rgonzale Trophy Club Entities Page 4 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 774 04/13/2012 PAYROLL 4/13/12 Salaries & Wages 205,648.31 16,803.73 222,452.04 PR 932 04/27/2012 Payroll 4/27/12 16,400.01 238,852.05 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 33,203.74 238,852.05 ** 425,748.00 Budgeted 186,895.95 Remaining 56 % Used Account: 122-50010-045-000 Overtime 774 04/13/2012 PAYROLL 4/13/12 Overtime 22,625.36 2,669.95 25,295.31 PR _______________ Account: 122-50010-045-000 Overtime Totals: 2,669.95 25,295.31 ** 42,000.00 Budgeted 16,704.69 Remaining 60 % Used Account: 122-50011-045-000 DPS Holiday Pay 13,773.02 .00 13,773.02 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,773.02 ** 13,773.00 Budgeted (.02) Remaining 100 % Used Account: 122-50016-045-000 Longevity 3,714.46 .00 3,714.46 _______________ Account: 122-50016-045-000 Longevity Totals: .00 3,714.46 ** 3,647.00 Budgeted (67.46) Remaining 102 % Used Account: 122-50017-045-000 Certification 3,053.20 .00 3,053.20 _______________ Account: 122-50017-045-000 Certification Totals: .00 3,053.20 ** 4,073.00 Budgeted 1,019.80 Remaining 75 % Used Account: 122-50020-045-000 Retirement 774 04/13/2012 PAYROLL 4/13/12 Retirement 34,153.35 2,516.17 36,669.52 PR 932 04/27/2012 Payroll 4/27/12 2,194.12 38,863.64 GL _______________ Account: 122-50020-045-000 Retirement Totals: 4,710.29 38,863.64 ** 68,264.00 Budgeted 29,400.36 Remaining 57 % Used . glpdatb2 rgonzale Trophy Club Entities Page 5 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 774 04/13/2012 PAYROLL 4/13/12 Medical Insurance 20,042.72 1,663.55 21,706.27 PR 932 04/27/2012 Payroll 4/27/12 1,663.52 23,369.79 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,327.07 23,369.79 ** 53,184.00 Budgeted 29,814.21 Remaining 44 % Used Account: 122-50027-045-000 Dental Insurance 774 04/13/2012 PAYROLL 4/13/12 Dental Insurance 1,751.72 145.24 1,896.96 PR 932 04/27/2012 Payroll 4/27/12 145.22 2,042.18 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 290.46 2,042.18 ** 3,288.00 Budgeted 1,245.82 Remaining 62 % Used Account: 122-50028-045-000 Vision Insurance 774 04/13/2012 PAYROLL 4/13/12 Vision Insurance 395.66 32.80 428.46 PR 932 04/27/2012 Payroll 4/27/12 32.82 461.28 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 65.62 461.28 ** 857.00 Budgeted 395.72 Remaining 54 % Used Account: 122-50029-045-000 Life Insurance & Other .00 .00 _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: .00 .00 ** 2,740.00 Budgeted 2,740.00 Remaining 0 % Used Account: 122-50030-045-000 Social Security Taxes 774 04/13/2012 PAYROLL 4/13/12 Social Security Taxes 14,804.83 1,114.60 15,919.43 PR 932 04/27/2012 Payroll 4/27/12 919.16 16,838.59 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,033.76 16,838.59 ** 30,231.00 Budgeted 13,392.41 Remaining 56 % Used Account: 122-50035-045-000 Medicare Taxes 774 04/13/2012 PAYROLL 4/13/12 Medicare Taxes 3,462.51 260.62 3,723.13 PR 932 04/27/2012 Payroll 4/27/12 214.96 3,938.09 GL . glpdatb2 rgonzale Trophy Club Entities Page 6 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 475.58 3,938.09 ** 7,070.00 Budgeted 3,131.91 Remaining 56 % Used Account: 122-50040-045-000 Unemployment Taxes 774 04/13/2012 PAYROLL 4/13/12 Unemployment Taxes 609.89 10.15 620.04 PR 932 04/27/2012 Payroll 4/27/12 3.57 623.61 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 13.72 623.61 ** 1,476.00 Budgeted 852.39 Remaining 42 % Used Account: 122-50045-045-000 Workman's Compensation 9,208.69 .00 9,208.69 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 9,208.69 ** 9,209.00 Budgeted .31 Remaining 100 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 89.00 .00 89.00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 89.00 ** 675.00 Budgeted 586.00 Remaining 13 % Used Account: 122-55080-045-000 Maintenance & Repairs 882 04/26/2012 April A/P Repair of Cascade System 2,516.64 455.75 2,972.39 AUGUST INDUSTRIES, INC 31393 AP 882 04/26/2012 April A/P Annual SCBA flow testing and r 900.00 3,872.39 MUNICIPAL EMERGENCY SERVICES 31420 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,355.75 3,872.39 ** 9,562.00 Budgeted 5,689.61 Remaining 40 % Used Account: 122-55090-045-000 Vehicle Maintenance 882 04/26/2012 April A/P March PCards 1,800.22 22.13 1,822.35 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 15.42 1,837.77 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 215.00 2,052.77 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 49.82 2,102.59 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 14.50 2,117.09 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 277.00 2,394.09 JPMORGAN CHASE BANK NA 31401 AP 972 04/30/2012 Apr A/P Pierce Engine/tires 2,457.72 4,851.81 BLAGG TIRE & SERVICE 31443 AP . glpdatb2 rgonzale Trophy Club Entities Page 7 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 3,051.59 4,851.81 ** 14,850.00 Budgeted 9,998.19 Remaining 33 % Used Account: 122-55095-045-000 Equipment Maintenance 4,137.18 .00 4,137.18 _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: .00 4,137.18 ** 9,808.00 Budgeted 5,670.82 Remaining 42 % Used Account: 122-55100-045-000 Building Maintenance 882 04/26/2012 April A/P March PCards 3,133.18 22.29 3,155.47 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 152.46 3,307.93 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 58.06 3,365.99 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 26.38 3,392.37 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 75.40 3,467.77 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 21.65 3,489.42 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 1,770.22 5,259.64 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 128.41 5,388.05 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 152.56 5,540.61 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 122-55100-045-000 Building Maintenance Totals: 2,407.43 5,540.61 ** 11,000.00 Budgeted 5,459.39 Remaining 50 % Used Account: 122-55110-045-000 Maintenance-Radios 882 04/26/2012 April A/P March PCards 393.00 393.00 786.00 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: 393.00 786.00 ** 1,103.00 Budgeted 317.00 Remaining 71 % Used Account: 122-55160-045-000 Professional Outside Services .00 .00 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 .00 ** 19,623.00 Budgeted 19,623.00 Remaining 0 % Used Account: 122-60005-045-000 Telephone 972 04/30/2012 Apr A/P PCards Zieverink-3/28-4/27 27.41 2.29 29.70 BANK OF AMERICA 31441 AP . glpdatb2 rgonzale Trophy Club Entities Page 8 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60005-045-000 Telephone Totals: 2.29 29.70 ** 106.00 Budgeted 76.30 Remaining 28 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 972 04/30/2012 Apr A/P Cell phones 3/23-4/22 1,212.12 134.81 1,346.93 VERIZON WIRELESS 31476 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 134.81 1,346.93 ** 4,411.00 Budgeted 3,064.07 Remaining 31 % Used Account: 122-60020-045-000 Electricity/Gas 882 04/26/2012 April A/P Electricity 3/15-4/16 5,763.48 894.14 6,657.62 HUDSON ENERGY 31400 AP 882 04/26/2012 April A/P Electricity 3/21-4/19 54.11 6,711.73 ATMOS ENERGY 31392 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 948.25 6,711.73 ** 18,270.00 Budgeted 11,558.27 Remaining 37 % Used Account: 122-60025-045-000 Water 972 04/30/2012 Apr A/P April Water 1,665.86 118.42 1,784.28 TROPHY CLUB MUD (WATER BILLS) 31475 AP 972 04/30/2012 Apr A/P April Water 12.71 1,796.99 TROPHY CLUB MUD (WATER BILLS) 31475 AP _______________ Account: 122-60025-045-000 Water Totals: 131.13 1,796.99 ** 3,289.00 Budgeted 1,492.01 Remaining 55 % Used Account: 122-60030-045-000 Rent And/Or Usage 308,000.00 .00 308,000.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 308,000.00 ** 308,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 938 04/30/2012 April Postage Meter usage 23.35 4.65 28.00 GL _______________ Account: 122-60035-045-000 Postage Totals: 4.65 28.00 ** 97.00 Budgeted 69.00 Remaining 29 % Used Account: 122-60055-045-000 Insurance . glpdatb2 rgonzale Trophy Club Entities Page 9 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 8,078.00 .00 8,078.00 _______________ Account: 122-60055-045-000 Insurance Totals: .00 8,078.00 ** 20,974.00 Budgeted 12,896.00 Remaining 39 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 401.00 Budgeted 401.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 882 04/26/2012 April A/P 2012 Dues/D Thomas 6,180.34 150.00 6,330.34 TX FIRE CHIEFS ASSOCIATION 31433 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 150.00 6,330.34 ** 8,560.00 Budgeted 2,229.66 Remaining 74 % Used Account: 122-60075-045-000 Meetings 22.00 .00 22.00 _______________ Account: 122-60075-045-000 Meetings Totals: .00 22.00 ** 75.00 Budgeted 53.00 Remaining 29 % Used Account: 122-60080-045-000 Schools & Training 882 04/26/2012 April A/P TIFMAS Wildland Fire Class 1,197.47 150.00 1,347.47 NORTH EAST FIRE DEPT ASSOC 31421 AP 882 04/26/2012 April A/P March PCards 300.00 1,647.47 JPMORGAN CHASE BANK NA 31401 AP 972 04/30/2012 Apr A/P Acrobat X Standard 196.70 1,844.17 SHI GOVERNMENT SOLUTIONS,INC 31464 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 646.70 1,844.17 ** 6,946.00 Budgeted 5,101.83 Remaining 27 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem . glpdatb2 rgonzale Trophy Club Entities Page 10 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 882 04/26/2012 April A/P March PCards 1,646.09 7.56 1,653.65 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 25.84 1,679.49 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 8.96 1,688.45 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 20.37 1,708.82 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 6.34 1,715.16 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 59.44 1,774.60 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 32.25 1,806.85 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 122-60100-045-000 Travel & per diem Totals: 160.76 1,806.85 ** 6,788.00 Budgeted 4,981.15 Remaining 27 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 1,918.00 Budgeted 1,918.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising .00 .00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 156.00 Budgeted 156.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 882 04/26/2012 April A/P Office Supplies 1,849.57 52.39 1,901.96 OFFICE DEPOT, INC 31422 AP _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 52.39 1,901.96 ** 4,162.00 Budgeted 2,260.04 Remaining 46 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 394.95 .00 394.95 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 394.95 ** 1,900.00 Budgeted 1,505.05 Remaining 21 % Used Account: 122-60195-045-000 Flags & Repair 1,012.50 .00 1,012.50 . glpdatb2 rgonzale Trophy Club Entities Page 11 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 1,012.50 ** 2,543.00 Budgeted 1,530.50 Remaining 40 % Used Account: 122-60245-045-000 Miscellaneous Expense 882 04/26/2012 April A/P March PCards 662.87 28.92 691.79 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 28.92 691.79 ** 1,237.00 Budgeted 545.21 Remaining 56 % Used Account: 122-65005-045-000 Fuel & Lube 934 04/30/2012 April A/P 3/10-4/10 Gas Purchases 2,615.71 689.60 3,305.31 VALERO MARKETING & SUPPLY 31438 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 689.60 3,305.31 ** 17,414.00 Budgeted 14,108.69 Remaining 19 % Used Account: 122-65010-045-000 Uniforms 882 04/26/2012 April A/P March PCards 1,285.73 92.87 1,378.60 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 92.87 1,378.60 ** 4,357.00 Budgeted 2,978.40 Remaining 32 % Used Account: 122-65015-045-000 Protective Clothing 882 04/26/2012 April A/P Replacement Protective Clothin 83.50 5,435.00 5,518.50 CASCO INDUSTRIES INC 31394 AP 882 04/26/2012 April A/P March PCards 375.00 5,893.50 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 5,810.00 5,893.50 ** 7,600.00 Budgeted 1,706.50 Remaining 78 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 1,545.00 Budgeted 1,545.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 882 04/26/2012 April A/P 3'x4' cork bulletin board 1,464.96 43.01 1,507.97 OFFICE DEPOT, INC 31422 AP . glpdatb2 rgonzale Trophy Club Entities Page 12 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 882 04/26/2012 April A/P March PCards 1,464.96 99.43 1,607.40 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards (7.58) 1,599.82 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 59.99 1,659.81 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 122-65035-045-000 Small Tools Totals: 194.85 1,659.81 ** 8,371.00 Budgeted 6,711.19 Remaining 20 % Used Account: 122-65085-045-000 Office Supplies 632.64 .00 632.64 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 632.64 ** 1,200.00 Budgeted 567.36 Remaining 53 % Used Account: 122-65095-045-000 Maintenance Supplies 882 04/26/2012 April A/P March PCards 856.92 196.18 1,053.10 JPMORGAN CHASE BANK NA 31401 AP 972 04/30/2012 Apr A/P Maintenance supplies 47.99 1,101.09 COSTCO WHOLESALE 31448 AP _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 244.17 1,101.09 ** 2,785.00 Budgeted 1,683.91 Remaining 40 % Used Account: 122-65105-045-000 Printing 24.77 .00 24.77 _______________ Account: 122-65105-045-000 Printing Totals: .00 24.77 ** 106.00 Budgeted 81.23 Remaining 23 % Used Account: 122-69006-045-000 Grant Match .00 .00 _______________ Account: 122-69006-045-000 Grant Match Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 122-69035-045-000 Vehicles 13,333.09 .00 13,333.09 _______________ Account: 122-69035-045-000 Vehicles Totals: .00 13,333.09 ** 13,709.00 Budgeted 375.91 Remaining 97 % Used . glpdatb2 rgonzale Trophy Club Entities Page 13 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 41,890.00 Budgeted 41,890.00 Remaining 0 % Used Account: 122-69251-045-000 Engine 681 Payment 4,351.65 .00 4,351.65 _______________ Account: 122-69251-045-000 Engine 681 Payment Totals: .00 4,351.65 ** 73,203.00 Budgeted 68,851.35 Remaining 6 % Used Account: 122-69255-045-000 Airpacks 882 04/26/2012 April A/P Payoff Airpack loan 14,526.00 14,526.00 TEXAS FOREST SERVICE 31432 AP _______________ Account: 122-69255-045-000 Airpacks Totals: 14,526.00 14,526.00 ** 13,865.00 Budgeted (661.00) Remaining 105 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 786,513.27 ** 1,314,559.00 Budgeted 528,045.73 Remaining 60 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (485,248.23) .00 Budgeted 485,248.23 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 14 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 870 04/02/2012 Property Taxes/Assessments (94,743.34) (21.25) (94,764.59) GL 889 04/03/2012 Property Taxes/Assessments (47.61) (94,812.20) GL 890 04/04/2012 Property Taxes/Assessments (58.93) (94,871.13) GL 891 04/05/2012 Property Taxes/Assessments (54.21) (94,925.34) GL 892 04/09/2012 Property Taxes/Assessments (123.49) (95,048.83) GL 896 04/16/2012 Property Taxes/Assessments (25.59) (95,074.42) GL 897 04/20/2012 Property Taxes/Assessments (11.24) (95,085.66) GL 899 04/24/2012 Property Taxes/Assessments (74.77) (95,160.43) GL 900 04/25/2012 Property Taxes/Assessments (22.66) (95,183.09) GL 942 04/26/2012 Property Taxes/Assessments (1.28) (95,184.37) GL 943 04/27/2012 Property Taxes/Assessments (7.46) (95,191.83) GL 945 04/30/2012 Property Taxes/Assessments (6.87) (95,198.70) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (455.36) (95,198.70) ** (97,495.00) Budgeted (2,296.30) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 892 04/09/2012 Property Taxes/Assessments 671.79 (.03) 671.76 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (.03) 671.76 ** (451.00) Budgeted (1,122.76) Remaining ########## Account: 135-40015-000-000 Property Taxes/P & I 870 04/02/2012 Property Taxes/Assessments 90.76 (1.23) 89.53 GL 889 04/03/2012 Property Taxes/Assessments (1.91) 87.62 GL 890 04/04/2012 Property Taxes/Assessments (3.85) 83.77 GL 891 04/05/2012 Property Taxes/Assessments (4.88) 78.89 GL 892 04/09/2012 Property Taxes/Assessments (11.01) 67.88 GL 896 04/16/2012 Property Taxes/Assessments (2.33) 65.55 GL 897 04/20/2012 Property Taxes/Assessments (.83) 64.72 GL 899 04/24/2012 Property Taxes/Assessments (8.23) 56.49 GL 900 04/25/2012 Property Taxes/Assessments (2.49) 54.00 GL 943 04/27/2012 Property Taxes/Assessments (.82) 53.18 GL 945 04/30/2012 Property Taxes/Assessments (.41) 52.77 GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (37.99) 52.77 ** (1,334.00) Budgeted (1,386.77) Remaining -4 % Used Account: 135-43215-000-000 Insurance Settlement . glpdatb2 rgonzale Trophy Club Entities Page 15 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (3,999.00) .00 (3,999.00) _______________ Account: 135-43215-000-000 Insurance Settlement Totals: .00 (3,999.00) ** .00 Budgeted 3,999.00 Remaining 0 % Used Account: 135-47000-000-000 Water 952 04/01/2012 2/22 CC return/Selzer JE848 (568,535.00) 22.71 (568,512.29) GL 848 04/19/2012 UB 04/19/2012 Adjustments UB 20120419-20120419 User: (22.71) (568,535.00) UB 867 04/23/2012 UB 04/23/2012 Adjustments UB 20120423-20120423 User: 108.95 (568,426.05) UB 924 04/30/2012 UB 4/30/12 Billing UB 20120430-20120430 User: (111,625.37) (680,051.42) UB _______________ Account: 135-47000-000-000 Water Totals: (111,516.42) (680,051.42) ** (1,990,800.00) Budgeted (1,310,748.58) Remaining 34 % Used Account: 135-47005-000-000 Sewer 952 04/01/2012 2/22 CC return/Selzer JE848 (437,125.82) 22.71 (437,103.11) GL 848 04/19/2012 UB 04/19/2012 Adjustments UB 20120419-20120419 User: (22.71) (437,125.82) UB 867 04/23/2012 UB 04/23/2012 Adjustments UB 20120423-20120423 User: 5.00 (437,120.82) UB 924 04/30/2012 UB 4/30/12 Billing UB 20120430-20120430 User: (83,392.02) (520,512.84) UB _______________ Account: 135-47005-000-000 Sewer Totals: (83,387.02) (520,512.84) ** (1,325,000.00) Budgeted (804,487.16) Remaining 39 % Used Account: 135-47010-000-000 Commercial Water 924 04/30/2012 UB 4/30/12 Billing UB 20120430-20120430 User: (269,282.84) (41,371.50) (310,654.34) UB _______________ Account: 135-47010-000-000 Commercial Water Totals: (41,371.50) (310,654.34) ** (825,000.00) Budgeted (514,345.66) Remaining 38 % Used Account: 135-47015-000-000 Commercial Sewer 924 04/30/2012 UB 4/30/12 Billing UB 20120430-20120430 User: (129,181.78) (22,651.48) (151,833.26) UB _______________ Account: 135-47015-000-000 Commercial Sewer Totals: (22,651.48) (151,833.26) ** (360,000.00) Budgeted (208,166.74) Remaining 42 % Used Account: 135-47020-000-000 Standby 924 04/30/2012 UB 4/30/12 Billing UB 20120430-20120430 User: (371.00) (54.00) (425.00) UB . glpdatb2 rgonzale Trophy Club Entities Page 16 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47020-000-000 Standby Totals: (54.00) (425.00) ** (775.00) Budgeted (350.00) Remaining 55 % Used Account: 135-47025-000-000 Penalties 863 04/23/2012 UB 4/23/12 Charges-Penalties UB 20120423-20120423 User: (26,498.38) (2,306.12) (28,804.50) UB 923 04/30/2012 UB 04/30/2012 Adjustment UB 20120430-20120430 User: 111.51 (28,692.99) UB 924 04/30/2012 UB 4/30/12 Billing UB 20120430-20120430 User: (62.84) (28,755.83) UB _______________ Account: 135-47025-000-000 Penalties Totals: (2,257.45) (28,755.83) ** (50,500.00) Budgeted (21,744.17) Remaining 57 % Used Account: 135-47030-000-000 Service Charges 749 04/02/2012 UB 4/2/12 Adj 3/1 reversal UB 20120402-20120402 User: (7,242.38) 25.00 (7,217.38) UB 778 04/10/2012 UB 04/10/2012 Adjustments UB 20120410-20120410 User: (650.00) (7,867.38) UB 867 04/23/2012 UB 04/23/2012 Adjustments UB 20120423-20120423 User: (50.00) (7,917.38) UB 924 04/30/2012 UB 4/30/12 Billing UB 20120430-20120430 User: 38.00 (7,879.38) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (637.00) (7,879.38) ** (17,500.00) Budgeted (9,620.62) Remaining 45 % Used Account: 135-47035-000-000 Plumbing Inspections 912 04/20/2012 Permits 4/20/12 (1,050.00) (50.00) (1,100.00) GL _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (50.00) (1,100.00) ** (1,200.00) Budgeted (100.00) Remaining 92 % Used Account: 135-47045-000-000 Sewer Inspections 912 04/20/2012 Permits 4/20/12 (3,150.00) (150.00) (3,300.00) GL _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (150.00) (3,300.00) ** (4,500.00) Budgeted (1,200.00) Remaining 73 % Used Account: 135-47070-000-000 TCCC Effluent Charges (8,212.62) .00 (8,212.62) _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (8,212.62) ** (57,500.00) Budgeted (49,287.38) Remaining 14 % Used . glpdatb2 rgonzale Trophy Club Entities Page 17 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47270-000-000 Fire Line .00 .00 _______________ Account: 135-47270-000-000 Fire Line Totals: .00 .00 ** (5,000.00) Budgeted (5,000.00) Remaining 0 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 878 04/25/2012 UB 04/25/2012 Adjustments UB 20120425-20120425 User: (18,885.74) (200.00) (19,085.74) UB 924 04/30/2012 UB 4/30/12 Billing UB 20120430-20120430 User: (1,864.03) (20,949.77) UB _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: (2,064.03) (20,949.77) ** (41,595.00) Budgeted (20,645.23) Remaining 50 % Used Account: 135-47405-000-000 Out of District Sewer 924 04/30/2012 UB 4/30/12 Billing UB 20120430-20120430 User: (5,651.78) (857.11) (6,508.89) UB _______________ Account: 135-47405-000-000 Out of District Sewer Totals: (857.11) (6,508.89) ** (11,807.00) Budgeted (5,298.11) Remaining 55 % Used Account: 135-47410-000-000 Out of Dist/Portable Penalties 863 04/23/2012 UB 4/23/12 Charges-Penalties UB 20120423-20120423 User: (28.31) (7.85) (36.16) UB _______________ Account: 135-47410-000-000 Out of Dist/Portable Penalties Totals: (7.85) (36.16) ** (300.00) Budgeted (263.84) Remaining 12 % Used Account: 135-47600-000-000 PID #1 Water 924 04/30/2012 UB 4/30/12 Billing UB 20120430-20120430 User: (178,226.89) (37,788.93) (216,015.82) UB _______________ Account: 135-47600-000-000 PID #1 Water Totals: (37,788.93) (216,015.82) ** (425,000.00) Budgeted (208,984.18) Remaining 51 % Used Account: 135-47605-000-000 PID #1 Sewer 924 04/30/2012 UB 4/30/12 Billing UB 20120430-20120430 User: (104,434.70) (21,903.59) (126,338.29) UB _______________ Account: 135-47605-000-000 PID #1 Sewer Totals: (21,903.59) (126,338.29) ** (185,000.00) Budgeted (58,661.71) Remaining 68 % Used Account: 135-48005-000-000 Utility Fees . glpdatb2 rgonzale Trophy Club Entities Page 18 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 904 04/03/2012 Permits 4/3/12 (373,380.00) (2,300.00) (375,680.00) GL 905 04/04/2012 Permits 4/4/12 (2,300.00) (377,980.00) GL 906 04/05/2012 Permits 4/5/12 (9,200.00) (387,180.00) GL 907 04/10/2012 Permits 4/10/12 (13,800.00) (400,980.00) GL 908 04/13/2012 Permits 4/13/12 (4,600.00) (405,580.00) GL 909 04/16/2012 Permits 4/16/12 (6,900.00) (412,480.00) GL 910 04/17/2012 Permits 4/17/12 (2,300.00) (414,780.00) GL 911 04/18/2012 Permits 4/18/12 (2,300.00) (417,080.00) GL 912 04/20/2012 Permits 4/20/12 (4,600.00) (421,680.00) GL _______________ Account: 135-48005-000-000 Utility Fees Totals: (48,300.00) (421,680.00) ** (161,000.00) Budgeted 260,680.00 Remaining 262 % Used Account: 135-49005-000-000 Loan Proceeds (1,100,000.00) .00 (1,100,000.00) _______________ Account: 135-49005-000-000 Loan Proceeds Totals: .00 (1,100,000.00) ** (1,100,000.00) Budgeted .00 Remaining 100 % Used Account: 135-49010-000-000 Interest Income 950 04/01/2012 Refund Int on Loan payoff/VFD (2,399.88) (13.12) (2,413.00) GL 925 04/30/2012 April Interest/FF Bank (29.11) (2,442.11) GL 925 04/30/2012 April Interest/FF Bank (76.94) (2,519.05) GL 946 04/30/2012 Texpool Interest/Apr (360.80) (2,879.85) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (479.97) (2,879.85) ** (4,500.00) Budgeted (1,620.15) Remaining 64 % Used Account: 135-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 135-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (308,000.00) Budgeted (308,000.00) Remaining 0 % Used Account: 135-49016-000-000 Cell Tower Revenue 902 04/27/2012 AT&T Antenna Lease/April (5,082.00) (847.00) (5,929.00) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (847.00) (5,929.00) ** (10,164.00) Budgeted (4,235.00) Remaining 58 % Used . glpdatb2 rgonzale Trophy Club Entities Page 19 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49018-000-000 Building Rent Income 901 04/27/2012 April Maint Barn rent (3,499.98) (583.33) (4,083.31) GL _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (4,083.31) ** (7,000.00) Budgeted (2,916.69) Remaining 58 % Used Account: 135-49030-000-000 Vending Revenue (32.50) .00 (32.50) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (32.50) ** (600.00) Budgeted (567.50) Remaining 5 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (265,707.00) Budgeted (265,707.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (26,911.00) Budgeted (26,911.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 904 04/03/2012 Permits 4/3/12 (59,348.80) (292.00) (59,640.80) GL 905 04/04/2012 Permits 4/4/12 (292.00) (59,932.80) GL 906 04/05/2012 Permits 4/5/12 (1,168.00) (61,100.80) GL 907 04/10/2012 Permits 4/10/12 (1,752.00) (62,852.80) GL 908 04/13/2012 Permits 4/13/12 (584.00) (63,436.80) GL 909 04/16/2012 Permits 4/16/12 (876.00) (64,312.80) GL 910 04/17/2012 Permits 4/17/12 (292.00) (64,604.80) GL 911 04/18/2012 Permits 4/18/12 (292.00) (64,896.80) GL 912 04/20/2012 Permits 4/20/12 (876.00) (65,772.80) GL _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (6,424.00) (65,772.80) ** (64,000.00) Budgeted 1,772.80 Remaining 103 % Used Account: 135-49900-000-000 Miscellaneous Income . glpdatb2 rgonzale Trophy Club Entities Page 20 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (2,778.11) .00 (2,778.11) _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: .00 (2,778.11) ** (10,000.00) Budgeted (7,221.89) Remaining 28 % Used Account: 135-49905-000-000 Gas Well Revenue (123.00) .00 (123.00) _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 (123.00) ** (800.00) Budgeted (677.00) Remaining 15 % Used Department Totals: ------------------------------------------------------------------------------------------------ (3,784,325.36) ** (7,359,439.00) Budgeted (3,575,113.64) Remaining 51 % Used . glpdatb2 rgonzale Trophy Club Entities Page 21 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 774 04/13/2012 PAYROLL 4/13/12 Salaries & Wages 78,680.11 6,512.03 85,192.14 PR 932 04/27/2012 Payroll 4/27/12 5,264.34 90,456.48 GL _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 11,776.37 90,456.48 ** 160,600.00 Budgeted 70,143.52 Remaining 56 % Used Account: 135-50010-010-000 Overtime 774 04/13/2012 PAYROLL 4/13/12 Overtime 7,941.02 1,255.40 9,196.42 PR 932 04/27/2012 Payroll 4/27/12 539.61 9,736.03 GL _______________ Account: 135-50010-010-000 Overtime Totals: 1,795.01 9,736.03 ** 13,250.00 Budgeted 3,513.97 Remaining 73 % Used Account: 135-50016-010-000 Longevity 2,620.00 .00 2,620.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,620.00 ** 2,620.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 882 04/26/2012 April A/P March PCards 900.00 111.00 1,011.00 JPMORGAN CHASE BANK NA 31401 AP 991 04/26/2012 Recode JPChase/Slaght Recode License renewal (111.00) 900.00 GL _______________ Account: 135-50017-010-000 Certification Totals: .00 900.00 ** 1,800.00 Budgeted 900.00 Remaining 50 % Used Account: 135-50020-010-000 Retirement 774 04/13/2012 PAYROLL 4/13/12 Retirement 13,073.07 1,073.45 14,146.52 PR 932 04/27/2012 Payroll 4/27/12 795.31 14,941.83 GL _______________ Account: 135-50020-010-000 Retirement Totals: 1,868.76 14,941.83 ** 25,508.00 Budgeted 10,566.17 Remaining 59 % Used Account: 135-50026-010-000 Medical Insurance 774 04/13/2012 PAYROLL 4/13/12 Medical Insurance 11,062.50 821.40 11,883.90 PR 932 04/27/2012 Payroll 4/27/12 640.41 12,524.31 GL . glpdatb2 rgonzale Trophy Club Entities Page 22 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,461.81 12,524.31 ** 22,607.00 Budgeted 10,082.69 Remaining 55 % Used Account: 135-50027-010-000 Dental Insurance 774 04/13/2012 PAYROLL 4/13/12 Dental Insurance 796.60 62.60 859.20 PR 932 04/27/2012 Payroll 4/27/12 50.08 909.28 GL _______________ Account: 135-50027-010-000 Dental Insurance Totals: 112.68 909.28 ** 2,169.00 Budgeted 1,259.72 Remaining 42 % Used Account: 135-50028-010-000 Vision Insurance 774 04/13/2012 PAYROLL 4/13/12 Vision Insurance 190.56 15.88 206.44 PR 932 04/27/2012 Payroll 4/27/12 12.91 219.35 GL _______________ Account: 135-50028-010-000 Vision Insurance Totals: 28.79 219.35 ** 576.00 Budgeted 356.65 Remaining 38 % Used Account: 135-50029-010-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: .00 .00 ** 1,161.00 Budgeted 1,161.00 Remaining 0 % Used Account: 135-50030-010-000 Social Security Taxes 774 04/13/2012 PAYROLL 4/13/12 Social Security Taxes 5,506.93 469.36 5,976.29 PR 932 04/27/2012 Payroll 4/27/12 344.57 6,320.86 GL _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 813.93 6,320.86 ** 12,000.00 Budgeted 5,679.14 Remaining 53 % Used Account: 135-50035-010-000 Medicare Taxes 774 04/13/2012 PAYROLL 4/13/12 Medicare Taxes 1,287.91 109.76 1,397.67 PR 932 04/27/2012 Payroll 4/27/12 80.59 1,478.26 GL _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 190.35 1,478.26 ** 2,700.00 Budgeted 1,221.74 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club Entities Page 23 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-010-000 Unemployment Taxes 288.00 .00 288.00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 288.00 ** 945.00 Budgeted 657.00 Remaining 30 % Used Account: 135-50045-010-000 Workman's Compensation 5,581.00 .00 5,581.00 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 5,581.00 ** 5,581.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations 882 04/26/2012 April A/P March PCards 92.04 26.60 118.64 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 135-50070-010-000 Employee Relations Totals: 26.60 118.64 ** 350.00 Budgeted 231.36 Remaining 34 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55070-010-000 Independent Labor .00 .00 _______________ Account: 135-55070-010-000 Independent Labor Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club Entities Page 24 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 882 04/26/2012 April A/P March PCards 12,266.75 17.00 12,283.75 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 44.72 12,328.47 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 9.99 12,338.46 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 395.40 12,733.86 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 33.75 12,767.61 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 86.85 12,854.46 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 404.34 13,258.80 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 992.05 13,258.80 ** 29,500.00 Budgeted 16,241.20 Remaining 45 % Used Account: 135-55090-010-000 Vehicle Maintenance 882 04/26/2012 April A/P March PCards 1,967.77 355.70 2,323.47 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 143.93 2,467.40 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 499.63 2,467.40 ** 3,380.00 Budgeted 912.60 Remaining 73 % Used Account: 135-55100-010-000 Building Maint & Supplies 471.85 .00 471.85 _______________ Account: 135-55100-010-000 Building Maint & Supplies Totals: .00 471.85 ** 750.00 Budgeted 278.15 Remaining 63 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 464.49 .00 464.49 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 464.49 ** 2,900.00 Budgeted 2,435.51 Remaining 16 % Used Account: 135-55135-010-000 Lab Analysis 972 04/30/2012 Apr A/P Water samples/April 1,220.00 245.00 1,465.00 TARRANT CTY PUBLIC HEALTH LAB 31470 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 245.00 1,465.00 ** 4,500.00 Budgeted 3,035.00 Remaining 33 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 972 04/30/2012 Apr A/P Cell phones 3/23-4/22 1,006.56 178.24 1,184.80 VERIZON WIRELESS 31476 AP . glpdatb2 rgonzale Trophy Club Entities Page 25 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 178.24 1,184.80 ** 1,599.00 Budgeted 414.20 Remaining 74 % Used Account: 135-60020-010-000 Electricity 872 04/25/2012 April A/P Electricity 3/2-4/2 24,526.71 278.06 24,804.77 TRI COUNTY ELECTRIC 31389 AP 882 04/26/2012 April A/P Electricity 3/15-4/16 280.83 25,085.60 HUDSON ENERGY 31400 AP 882 04/26/2012 April A/P Electricity 3/15-4/16 1,230.33 26,315.93 HUDSON ENERGY 31400 AP 882 04/26/2012 April A/P Electricity 3/15-4/16 234.76 26,550.69 HUDSON ENERGY 31400 AP 882 04/26/2012 April A/P Electricity 3/15-4/16 1,315.70 27,866.39 HUDSON ENERGY 31400 AP 882 04/26/2012 April A/P Electricity 3/15-4/16 9.77 27,876.16 HUDSON ENERGY 31400 AP 882 04/26/2012 April A/P Electricity 3/15-4/16 107.59 27,983.75 HUDSON ENERGY 31400 AP _______________ Account: 135-60020-010-000 Electricity Totals: 3,457.04 27,983.75 ** 127,500.00 Budgeted 99,516.25 Remaining 22 % Used Account: 135-60035-010-000 Postage 6.51 .00 6.51 _______________ Account: 135-60035-010-000 Postage Totals: .00 6.51 ** 500.00 Budgeted 493.49 Remaining 1 % Used Account: 135-60050-010-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-010-000 Bad Debt Expense Totals: .00 .00 ** 4,200.00 Budgeted 4,200.00 Remaining 0 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 864 04/24/2012 Void ck 31327/Reissue Training book-Jeff Richey 85.00 (85.00) .00 CITY OF FORT WORTH 31327 AP 882 04/26/2012 April A/P Reissue for voided check #3132 85.00 85.00 CITY OF FORT WORTH 31397 AP 884 04/26/2012 Void A/P ck 31327/City of FW Reissue for voided check #3132 (85.00) .00 CITY OF FORT WORTH 31397 AP 885 04/26/2012 April A/P Replace voided ck 31397 85.00 85.00 CITY OF FORT WORTH WATER 31437 AP _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 85.00 ** 50.00 Budgeted (35.00) Remaining 170 % Used Account: 135-60070-010-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club Entities Page 26 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 991 04/26/2012 Recode JPChase/Slaght Recode License Renewal 111.00 111.00 GL _______________ Account: 135-60070-010-000 Dues & Memberships Totals: 111.00 111.00 ** 150.00 Budgeted 39.00 Remaining 74 % Used Account: 135-60080-010-000 Schools & Training 1,082.00 .00 1,082.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 1,082.00 ** 2,800.00 Budgeted 1,718.00 Remaining 39 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 774 04/13/2012 PAYROLL 4/13/12 Travel & per diem 937.45 73.26 1,010.71 PR _______________ Account: 135-60100-010-000 Travel & per diem Totals: 73.26 1,010.71 ** 3,200.00 Budgeted 2,189.29 Remaining 32 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60135-010-000 Annual Permit Fee 7,965.75 .00 7,965.75 _______________ Account: 135-60135-010-000 Annual Permit Fee Totals: .00 7,965.75 ** 6,600.00 Budgeted (1,365.75) Remaining 121 % Used Account: 135-60150-010-000 Wholesale Water 972 04/30/2012 Apr A/P Wholesale water/March 547,426.41 110,026.92 657,453.33 CITY OF FORT WORTH 31447 AP . glpdatb2 rgonzale Trophy Club Entities Page 27 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60150-010-000 Wholesale Water Totals: 110,026.92 657,453.33 ** 1,720,000.00 Budgeted 1,062,546.67 Remaining 38 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 882 04/26/2012 April A/P March PCards 360.00 20.38 380.38 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 135-60280-010-000 Property Maintenance Totals: 20.38 380.38 ** 4,200.00 Budgeted 3,819.62 Remaining 9 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 299.99 .00 299.99 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 299.99 ** 1,500.00 Budgeted 1,200.01 Remaining 20 % Used Account: 135-65005-010-000 Fuel & Lube 934 04/30/2012 April A/P 3/10-4/10 Gas Purchases 6,033.76 134.22 6,167.98 VALERO MARKETING & SUPPLY 31438 AP 934 04/30/2012 April A/P 3/10-4/10 Gas Purchases 1,020.97 7,188.95 VALERO MARKETING & SUPPLY 31438 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,155.19 7,188.95 ** 15,216.00 Budgeted 8,027.05 Remaining 47 % Used Account: 135-65010-010-000 Uniforms 882 04/26/2012 April A/P March PCards 1,024.15 109.97 1,134.12 JPMORGAN CHASE BANK NA 31401 AP . glpdatb2 rgonzale Trophy Club Entities Page 28 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-010-000 Uniforms Totals: 109.97 1,134.12 ** 3,690.00 Budgeted 2,555.88 Remaining 31 % Used Account: 135-65030-010-000 Chemicals 882 04/26/2012 April A/P March PCards 1,066.47 67.10 1,133.57 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 251.20 1,384.77 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 318.30 1,384.77 ** 6,200.00 Budgeted 4,815.23 Remaining 22 % Used Account: 135-65035-010-000 Small Tools 882 04/26/2012 April A/P March PCards 68.00 135.00 203.00 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 135-65035-010-000 Small Tools Totals: 135.00 203.00 ** 2,500.00 Budgeted 2,297.00 Remaining 8 % Used Account: 135-65040-010-000 Safety Equipment 287.82 .00 287.82 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 287.82 ** 2,500.00 Budgeted 2,212.18 Remaining 12 % Used Account: 135-65050-010-000 Meter Expense 872 04/25/2012 April A/P 100 1" meters 63,619.07 27,150.00 90,769.07 ATLAS UTILITY SUPPLY CO. 31391 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 27,150.00 90,769.07 ** 94,000.00 Budgeted 3,230.93 Remaining 97 % Used Account: 135-65055-010-000 Hardware .00 .00 _______________ Account: 135-65055-010-000 Hardware Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65085-010-000 Office Supplies 882 04/26/2012 April A/P March PCards 30.00 30.00 JPMORGAN CHASE BANK NA 31401 AP . glpdatb2 rgonzale Trophy Club Entities Page 29 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65085-010-000 Office Supplies Totals: 30.00 30.00 ** .00 Budgeted (30.00) Remaining 0 % Used Account: 135-65095-010-000 Maintenance Supplies 882 04/26/2012 April A/P March PCards 10,222.57 170.16 10,392.73 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 180.42 10,573.15 JPMORGAN CHASE BANK NA 31401 AP 972 04/30/2012 Apr A/P Maintenance supplies 144.30 10,717.45 COSTCO WHOLESALE 31448 AP _______________ Account: 135-65095-010-000 Maintenance Supplies Totals: 494.88 10,717.45 ** 32,000.00 Budgeted 21,282.55 Remaining 33 % Used Account: 135-65100-010-000 Copies .00 .00 _______________ Account: 135-65100-010-000 Copies Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 135-65105-010-000 Printing 58.50 .00 58.50 _______________ Account: 135-65105-010-000 Printing Totals: .00 58.50 ** 150.00 Budgeted 91.50 Remaining 39 % Used Account: 135-69005-010-000 Capital Expenses 1,265,870.59 .00 1,265,870.59 _______________ Account: 135-69005-010-000 Capital Expenses Totals: .00 1,265,870.59 ** 1,455,600.00 Budgeted 189,729.41 Remaining 87 % Used Account: 135-69008-010-000 Short Term Debt Payments .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt Payments Totals: .00 .00 ** 421,050.00 Budgeted 421,050.00 Remaining 0 % Used Account: 135-69035-010-000 Vehicles . glpdatb2 rgonzale Trophy Club Entities Page 30 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 30,213.69 .00 30,213.69 _______________ Account: 135-69035-010-000 Vehicles Totals: .00 30,213.69 ** 27,000.00 Budgeted (3,213.69) Remaining 112 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-69280-010-000 Capital Repairs .00 .00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** 24,000.00 Budgeted 24,000.00 Remaining 0 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 ** 108,817.00 Budgeted 8,000.46 Remaining 93 % Used Account: 135-69295-010-000 Unexpected Maintenance .00 .00 _______________ Account: 135-69295-010-000 Unexpected Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-69305-010-000 Capital Leases 10,145.26 .00 10,145.26 _______________ Account: 135-69305-010-000 Capital Leases Totals: .00 10,145.26 ** 11,490.00 Budgeted 1,344.74 Remaining 88 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,380,604.56 ** 4,406,909.00 Budgeted 2,026,304.44 Remaining 54 % Used . glpdatb2 rgonzale Trophy Club Entities Page 31 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 754 04/04/2012 SUPPLEMENTAL-PERALES - 4/4/12 Salaries & Wages 99,088.58 2,630.88 101,719.46 PR 774 04/13/2012 PAYROLL 4/13/12 Salaries & Wages 4,833.29 106,552.75 PR 932 04/27/2012 Payroll 4/27/12 8,147.69 114,700.44 GL _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 15,611.86 114,700.44 ** 182,147.00 Budgeted 67,446.56 Remaining 63 % Used Account: 135-50010-020-000 Overtime 774 04/13/2012 PAYROLL 4/13/12 Overtime 6,291.38 622.82 6,914.20 PR 932 04/27/2012 Payroll 4/27/12 347.89 7,262.09 GL _______________ Account: 135-50010-020-000 Overtime Totals: 970.71 7,262.09 ** 10,166.00 Budgeted 2,903.91 Remaining 71 % Used Account: 135-50016-020-000 Longevity 3,975.00 .00 3,975.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 3,975.00 ** 3,976.00 Budgeted 1.00 Remaining 100 % Used Account: 135-50017-020-000 Certification 825.00 .00 825.00 _______________ Account: 135-50017-020-000 Certification Totals: .00 825.00 ** 2,400.00 Budgeted 1,575.00 Remaining 34 % Used Account: 135-50020-020-000 Retirement 754 04/04/2012 SUPPLEMENTAL-PERALES - 4/4/12 Retirement 15,930.79 363.59 16,294.38 PR 774 04/13/2012 PAYROLL 4/13/12 Retirement 754.04 17,048.42 PR 932 04/27/2012 Payroll 4/27/12 1,164.09 18,212.51 GL _______________ Account: 135-50020-020-000 Retirement Totals: 2,281.72 18,212.51 ** 27,816.00 Budgeted 9,603.49 Remaining 65 % Used Account: 135-50026-020-000 Medical Insurance 754 04/04/2012 SUPPLEMENTAL-PERALES - 4/4/12 Medical Insurance 12,803.14 205.35 13,008.49 PR 774 04/13/2012 PAYROLL 4/13/12 Medical Insurance 867.34 13,875.83 PR . glpdatb2 rgonzale Trophy Club Entities Page 32 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 932 04/27/2012 Payroll 4/27/12 12,803.14 1,327.47 15,203.30 GL _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,400.16 15,203.30 ** 30,805.00 Budgeted 15,601.70 Remaining 49 % Used Account: 135-50027-020-000 Dental Insurance 754 04/04/2012 SUPPLEMENTAL-PERALES - 4/4/12 Dental Insurance 984.34 14.21 998.55 PR 774 04/13/2012 PAYROLL 4/13/12 Dental Insurance 68.47 1,067.02 PR 932 04/27/2012 Payroll 4/27/12 99.18 1,166.20 GL _______________ Account: 135-50027-020-000 Dental Insurance Totals: 181.86 1,166.20 ** 1,981.00 Budgeted 814.80 Remaining 59 % Used Account: 135-50028-020-000 Vision Insurance 754 04/04/2012 SUPPLEMENTAL-PERALES - 4/4/12 Vision Insurance 245.16 3.38 248.54 PR 774 04/13/2012 PAYROLL 4/13/12 Vision Insurance 17.22 265.76 PR 932 04/27/2012 Payroll 4/27/12 24.45 290.21 GL _______________ Account: 135-50028-020-000 Vision Insurance Totals: 45.05 290.21 ** 552.00 Budgeted 261.79 Remaining 53 % Used Account: 135-50029-020-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: .00 .00 ** 884.00 Budgeted 884.00 Remaining 0 % Used Account: 135-50030-020-000 Social Security Taxes 754 04/04/2012 SUPPLEMENTAL-PERALES - 4/4/12 Social Security Taxes 6,440.94 162.14 6,603.08 PR 774 04/13/2012 PAYROLL 4/13/12 Social Security Taxes 291.78 6,894.86 PR 932 04/27/2012 Payroll 4/27/12 460.06 7,354.92 GL _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 913.98 7,354.92 ** 11,293.00 Budgeted 3,938.08 Remaining 65 % Used Account: 135-50035-020-000 Medicare Taxes 754 04/04/2012 SUPPLEMENTAL-PERALES - 4/4/12 Medicare Taxes 1,506.33 37.92 1,544.25 PR 774 04/13/2012 PAYROLL 4/13/12 Medicare Taxes 68.23 1,612.48 PR . glpdatb2 rgonzale Trophy Club Entities Page 33 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 932 04/27/2012 Payroll 4/27/12 1,506.33 107.59 1,720.07 GL _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 213.74 1,720.07 ** 2,645.00 Budgeted 924.93 Remaining 65 % Used Account: 135-50040-020-000 Unemployment Taxes 315.84 .00 315.84 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 315.84 ** 567.00 Budgeted 251.16 Remaining 56 % Used Account: 135-50045-020-000 Workman's Compensation 2,685.00 .00 2,685.00 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 2,685.00 ** 2,685.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 30.45 .00 30.45 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 30.45 ** 200.00 Budgeted 169.55 Remaining 15 % Used Account: 135-50070-020-000 Employee Relations 64.45 .00 64.45 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 64.45 ** 350.00 Budgeted 285.55 Remaining 18 % Used Account: 135-55070-020-000 Independent Labor 1,905.67 .00 1,905.67 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 1,905.67 ** 15,000.00 Budgeted 13,094.33 Remaining 13 % Used Account: 135-55080-020-000 Maintenance & Repairs 882 04/26/2012 April A/P Repairs at WWTP 19,862.97 300.00 20,162.97 CHANEY ENVIRONMENTAL 31395 AP . glpdatb2 rgonzale Trophy Club Entities Page 34 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 882 04/26/2012 April A/P Tarp pipe, Roll off box tarp, 19,862.97 372.00 20,534.97 CHANEY ENVIRONMENTAL 31395 AP 972 04/30/2012 Apr A/P Repair WWTP road 648.98 21,183.95 BIG CITY CRUSHED CONCRETE, LP 31442 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 1,320.98 21,183.95 ** 40,000.00 Budgeted 18,816.05 Remaining 53 % Used Account: 135-55090-020-000 Vehicle Maintenance 882 04/26/2012 April A/P March PCards 194.95 39.75 234.70 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 39.75 234.70 ** 4,998.00 Budgeted 4,763.30 Remaining 5 % Used Account: 135-55100-020-000 Building Maint & Supplies .00 .00 _______________ Account: 135-55100-020-000 Building Maint & Supplies Totals: .00 .00 ** 1,400.00 Budgeted 1,400.00 Remaining 0 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 148.50 .00 148.50 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 148.50 ** 2,950.00 Budgeted 2,801.50 Remaining 5 % Used Account: 135-55125-020-000 Dumpster Services 882 04/26/2012 April A/P Sludge haul off 10,212.50 537.50 10,750.00 CHANEY ENVIRONMENTAL 31395 AP 882 04/26/2012 April A/P Sludge haul off 1,075.00 11,825.00 CHANEY ENVIRONMENTAL 31395 AP 882 04/26/2012 April A/P Sludge haul off 537.50 12,362.50 CHANEY ENVIRONMENTAL 31395 AP 882 04/26/2012 April A/P Sludge haul off 1,075.00 13,437.50 CHANEY ENVIRONMENTAL 31395 AP 882 04/26/2012 April A/P Sludge haul off 1,075.00 14,512.50 CHANEY ENVIRONMENTAL 31395 AP 882 04/26/2012 April A/P Sludge haul off 1,075.00 15,587.50 CHANEY ENVIRONMENTAL 31395 AP 882 04/26/2012 April A/P Sludge haul off 537.50 16,125.00 CHANEY ENVIRONMENTAL 31395 AP 882 04/26/2012 April A/P Sludge haul off 537.50 16,662.50 CHANEY ENVIRONMENTAL 31395 AP 882 04/26/2012 April A/P Sludge haul off 1,075.00 17,737.50 CHANEY ENVIRONMENTAL 31395 AP 882 04/26/2012 April A/P Sludge haul off 1,075.00 18,812.50 CHANEY ENVIRONMENTAL 31395 AP 882 04/26/2012 April A/P Sludge haul off 3,762.50 22,575.00 CHANEY ENVIRONMENTAL 31395 AP 882 04/26/2012 April A/P Sludge haul off 1,075.00 23,650.00 CHANEY ENVIRONMENTAL 31395 AP 972 04/30/2012 Apr A/P Sludge haul off 537.50 24,187.50 CHANEY ENVIRONMENTAL 31446 AP . glpdatb2 rgonzale Trophy Club Entities Page 35 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55125-020-000 Dumpster Services Totals: 13,975.00 24,187.50 ** 35,000.00 Budgeted 10,812.50 Remaining 69 % Used Account: 135-55135-020-000 Lab Analysis 10,506.12 .00 10,506.12 _______________ Account: 135-55135-020-000 Lab Analysis Totals: .00 10,506.12 ** 35,000.00 Budgeted 24,493.88 Remaining 30 % Used Account: 135-60005-020-000 Telephone 972 04/30/2012 Apr A/P PCards Zieverink-3/28-4/27 10.59 1.44 12.03 BANK OF AMERICA 31441 AP _______________ Account: 135-60005-020-000 Telephone Totals: 1.44 12.03 ** 100.00 Budgeted 87.97 Remaining 12 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 972 04/30/2012 Apr A/P Cell phones 3/23-4/22 1,378.73 163.22 1,541.95 VERIZON WIRELESS 31476 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 163.22 1,541.95 ** 3,000.00 Budgeted 1,458.05 Remaining 51 % Used Account: 135-60020-020-000 Electricity 882 04/26/2012 April A/P Electricity 3/15-4/16 24,121.12 10,252.14 34,373.26 HUDSON ENERGY 31400 AP _______________ Account: 135-60020-020-000 Electricity Totals: 10,252.14 34,373.26 ** 161,160.00 Budgeted 126,786.74 Remaining 21 % Used Account: 135-60025-020-000 Water 972 04/30/2012 Apr A/P April Water 1,226.15 156.91 1,383.06 TROPHY CLUB MUD (WATER BILLS) 31475 AP _______________ Account: 135-60025-020-000 Water Totals: 156.91 1,383.06 ** 1,900.00 Budgeted 516.94 Remaining 73 % Used Account: 135-60035-020-000 Postage .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 36 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60035-020-000 Postage Totals: .00 .00 ** 120.00 Budgeted 120.00 Remaining 0 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 438.17 .00 438.17 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 438.17 ** 500.00 Budgeted 61.83 Remaining 88 % Used Account: 135-60080-020-000 Schools & Training 882 04/26/2012 April A/P March PCards 111.00 111.00 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 135-60080-020-000 Schools & Training Totals: 111.00 111.00 ** 1,320.00 Budgeted 1,209.00 Remaining 8 % Used Account: 135-60090-020-000 Safety Program 116.45 .00 116.45 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 116.45 ** 200.00 Budgeted 83.55 Remaining 58 % Used Account: 135-60100-020-000 Travel & per diem 768 04/09/2012 April A/P Mileage reimbursement 1,090.58 132.09 1,222.67 RUBEN PERALES 31371 AP 774 04/13/2012 PAYROLL 4/13/12 Travel & per diem 69.93 1,292.60 PR _______________ Account: 135-60100-020-000 Travel & per diem Totals: 202.02 1,292.60 ** 1,750.00 Budgeted 457.40 Remaining 74 % Used Account: 135-60105-020-000 Rent/Lease Equipment 901.30 .00 901.30 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 901.30 ** 200.00 Budgeted (701.30) Remaining 451 % Used Account: 135-60125-020-000 Advertising 987.36 .00 987.36 . glpdatb2 rgonzale Trophy Club Entities Page 37 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60125-020-000 Advertising Totals: .00 987.36 ** 1,500.00 Budgeted 512.64 Remaining 66 % Used Account: 135-60135-020-000 Annual Permit Fee 7,432.50 .00 7,432.50 _______________ Account: 135-60135-020-000 Annual Permit Fee Totals: .00 7,432.50 ** 7,500.00 Budgeted 67.50 Remaining 99 % Used Account: 135-60245-020-000 Miscellaneous Expenses 882 04/26/2012 April A/P Late fees 64.00 12.02 76.02 USA BLUEBOOK 31434 AP _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: 12.02 76.02 ** 525.00 Budgeted 448.98 Remaining 14 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 525.00 Budgeted 525.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 934 04/30/2012 April A/P 3/10-4/10 Gas Purchases 1,570.61 563.62 2,134.23 VALERO MARKETING & SUPPLY 31438 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 563.62 2,134.23 ** 6,875.00 Budgeted 4,740.77 Remaining 31 % Used Account: 135-65010-020-000 Uniforms 1,118.93 .00 1,118.93 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,118.93 ** 3,140.00 Budgeted 2,021.07 Remaining 36 % Used Account: 135-65030-020-000 Chemicals 882 04/26/2012 April A/P Chemicals 3,237.57 900.00 4,137.57 POLYDYNE, INC 31423 AP . glpdatb2 rgonzale Trophy Club Entities Page 38 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65030-020-000 Chemicals Totals: 900.00 4,137.57 ** 13,180.00 Budgeted 9,042.43 Remaining 31 % Used Account: 135-65035-020-000 Small Tools .00 .00 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment 22.75 .00 22.75 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 22.75 ** 925.00 Budgeted 902.25 Remaining 2 % Used Account: 135-65045-020-000 Lab Supplies 882 04/26/2012 April A/P Lab Supplies 3,156.18 1,053.93 4,210.11 USA BLUEBOOK 31434 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,053.93 4,210.11 ** 12,000.00 Budgeted 7,789.89 Remaining 35 % Used Account: 135-65055-020-000 Hardware .00 .00 _______________ Account: 135-65055-020-000 Hardware Totals: .00 .00 ** 525.00 Budgeted 525.00 Remaining 0 % Used Account: 135-65085-020-000 Office Supplies 882 04/26/2012 April A/P March PCards 50.58 48.96 99.54 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 135-65085-020-000 Office Supplies Totals: 48.96 99.54 ** 400.00 Budgeted 300.46 Remaining 25 % Used Account: 135-65095-020-000 Maintenance Supplies 882 04/26/2012 April A/P March PCards 953.32 630.89 1,584.21 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 50.78 1,634.99 JPMORGAN CHASE BANK NA 31401 AP . glpdatb2 rgonzale Trophy Club Entities Page 39 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 882 04/26/2012 April A/P March PCards 953.32 12.97 1,647.96 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 29.97 1,677.93 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 123.76 1,801.69 JPMORGAN CHASE BANK NA 31401 AP 972 04/30/2012 Apr A/P Maintenance supplies 34.77 1,836.46 COSTCO WHOLESALE 31448 AP _______________ Account: 135-65095-020-000 Maintenance Supplies Totals: 883.14 1,836.46 ** 8,860.00 Budgeted 7,023.54 Remaining 21 % Used Account: 135-65115-020-000 Other Consumables .00 .00 _______________ Account: 135-65115-020-000 Other Consumables Totals: .00 .00 ** 110.00 Budgeted 110.00 Remaining 0 % Used Account: 135-69005-020-000 Capital Expenses 43,592.56 .00 43,592.56 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .00 43,592.56 ** 111,021.00 Budgeted 67,428.44 Remaining 39 % Used Account: 135-69008-020-000 Short Term Debt Payments .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt Payments Totals: .00 .00 ** 118,689.00 Budgeted 118,689.00 Remaining 0 % Used Account: 135-69280-020-000 Capital Repairs .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 56,000.00 Budgeted 56,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 337,789.77 ** 926,100.00 Budgeted 588,310.23 Remaining 36 % Used . glpdatb2 rgonzale Trophy Club Entities Page 40 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-021-000 Salaries & Wages 774 04/13/2012 PAYROLL 4/13/12 Salaries & Wages 69,259.35 5,651.92 74,911.27 PR 932 04/27/2012 Payroll 4/27/12 4,387.98 79,299.25 GL _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 10,039.90 79,299.25 ** 145,481.00 Budgeted 66,181.75 Remaining 55 % Used Account: 135-50010-021-000 Overtime 774 04/13/2012 PAYROLL 4/13/12 Overtime 4,288.46 838.51 5,126.97 PR _______________ Account: 135-50010-021-000 Overtime Totals: 838.51 5,126.97 ** 7,297.00 Budgeted 2,170.03 Remaining 70 % Used Account: 135-50016-021-000 Longevity 3,547.50 .00 3,547.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 3,547.50 ** 3,548.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 750.00 .00 750.00 _______________ Account: 135-50017-021-000 Certification Totals: .00 750.00 ** 1,500.00 Budgeted 750.00 Remaining 50 % Used Account: 135-50020-021-000 Retirement 774 04/13/2012 PAYROLL 4/13/12 Retirement 11,303.21 896.97 12,200.18 PR 932 04/27/2012 Payroll 4/27/12 606.42 12,806.60 GL _______________ Account: 135-50020-021-000 Retirement Totals: 1,503.39 12,806.60 ** 21,074.00 Budgeted 8,267.40 Remaining 61 % Used Account: 135-50026-021-000 Medical Insurance 774 04/13/2012 PAYROLL 4/13/12 Medical Insurance 10,216.08 851.34 11,067.42 PR 932 04/27/2012 Payroll 4/27/12 572.21 11,639.63 GL _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,423.55 11,639.63 ** 22,983.00 Budgeted 11,343.37 Remaining 51 % Used . glpdatb2 rgonzale Trophy Club Entities Page 41 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-021-000 Dental Insurance 774 04/13/2012 PAYROLL 4/13/12 Dental Insurance 704.28 58.69 762.97 PR 932 04/27/2012 Payroll 4/27/12 40.50 803.47 GL _______________ Account: 135-50027-021-000 Dental Insurance Totals: 99.19 803.47 ** 1,533.00 Budgeted 729.53 Remaining 52 % Used Account: 135-50028-021-000 Vision Insurance 774 04/13/2012 PAYROLL 4/13/12 Vision Insurance 178.32 14.86 193.18 PR 932 04/27/2012 Payroll 4/27/12 10.60 203.78 GL _______________ Account: 135-50028-021-000 Vision Insurance Totals: 25.46 203.78 ** 357.00 Budgeted 153.22 Remaining 57 % Used Account: 135-50029-021-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: .00 .00 ** 978.00 Budgeted 978.00 Remaining 0 % Used Account: 135-50030-021-000 Social Security Taxes 774 04/13/2012 PAYROLL 4/13/12 Social Security Taxes 4,656.57 372.92 5,029.49 PR 932 04/27/2012 Payroll 4/27/12 258.24 5,287.73 GL _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 631.16 5,287.73 ** 9,785.00 Budgeted 4,497.27 Remaining 54 % Used Account: 135-50035-021-000 Medicare Taxes 774 04/13/2012 PAYROLL 4/13/12 Medicare Taxes 1,089.04 87.21 1,176.25 PR 932 04/27/2012 Payroll 4/27/12 60.40 1,236.65 GL _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 147.61 1,236.65 ** 2,288.00 Budgeted 1,051.35 Remaining 54 % Used Account: 135-50040-021-000 Unemployment Taxes 216.00 .00 216.00 _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 216.00 ** 567.00 Budgeted 351.00 Remaining 38 % Used . glpdatb2 rgonzale Trophy Club Entities Page 42 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-021-000 Workman's Compensation 3,056.00 .00 3,056.00 _______________ Account: 135-50045-021-000 Workman's Compensation Totals: .00 3,056.00 ** 3,056.00 Budgeted .00 Remaining 100 % Used Account: 135-50070-021-000 Employee Relations 64.43 .00 64.43 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 64.43 ** 250.00 Budgeted 185.57 Remaining 26 % Used Account: 135-55005-021-000 Engineering .00 .00 _______________ Account: 135-55005-021-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55070-021-000 Independent Labor .00 .00 _______________ Account: 135-55070-021-000 Independent Labor Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 882 04/26/2012 April A/P March PCards 3,783.85 209.00 3,992.85 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 209.00 3,992.85 ** 23,700.00 Budgeted 19,707.15 Remaining 17 % Used Account: 135-55090-021-000 Vehicle Maintenance 209.50 .00 209.50 _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 209.50 ** 1,943.00 Budgeted 1,733.50 Remaining 11 % Used Account: 135-55100-021-000 Building Maint & Supplies . glpdatb2 rgonzale Trophy Club Entities Page 43 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-55100-021-000 Building Maint & Supplies Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60005-021-000 Telephone 972 04/30/2012 Apr A/P PCards Zieverink-3/28-4/27 14.21 .96 15.17 BANK OF AMERICA 31441 AP _______________ Account: 135-60005-021-000 Telephone Totals: .96 15.17 ** 50.00 Budgeted 34.83 Remaining 30 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 972 04/30/2012 Apr A/P Cell phones 3/23-4/22 1,752.11 205.10 1,957.21 VERIZON WIRELESS 31476 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 205.10 1,957.21 ** 2,796.00 Budgeted 838.79 Remaining 70 % Used Account: 135-60020-021-000 Electricity 872 04/25/2012 April A/P Electricity 3/2-4/2 4,652.43 136.41 4,788.84 TRI COUNTY ELECTRIC 31389 AP 872 04/25/2012 April A/P Electricity 3/2-4/2 27.95 4,816.79 TRI COUNTY ELECTRIC 31389 AP 882 04/26/2012 April A/P Electricity 3/14-4/16 848.54 5,665.33 HUDSON ENERGY 31400 AP 882 04/26/2012 April A/P Electricity 3/15-4/16 225.84 5,891.17 HUDSON ENERGY 31400 AP 882 04/26/2012 April A/P Electricity 3/14-4/13 35.04 5,926.21 HUDSON ENERGY 31400 AP _______________ Account: 135-60020-021-000 Electricity Totals: 1,273.78 5,926.21 ** 21,550.00 Budgeted 15,623.79 Remaining 27 % Used Account: 135-60025-021-000 Water .00 .00 _______________ Account: 135-60025-021-000 Water Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60035-021-000 Postage .00 .00 _______________ Account: 135-60035-021-000 Postage Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 44 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 255.00 Budgeted 255.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training .00 .00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 .00 ** 2,818.00 Budgeted 2,818.00 Remaining 0 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 774 04/13/2012 PAYROLL 4/13/12 Travel & per diem 429.05 35.52 464.57 PR _______________ Account: 135-60100-021-000 Travel & per diem Totals: 35.52 464.57 ** 1,500.00 Budgeted 1,035.43 Remaining 31 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 76,098.00 Budgeted 76,098.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-60280-021-000 Property Maintenance . glpdatb2 rgonzale Trophy Club Entities Page 45 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60280-021-000 Property Maintenance Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 882 04/26/2012 April A/P March PCards 4,004.35 74.25 4,078.60 JPMORGAN CHASE BANK NA 31401 AP 934 04/30/2012 April A/P 3/10-4/10 Gas Purchases 824.72 4,903.32 VALERO MARKETING & SUPPLY 31438 AP _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 898.97 4,903.32 ** 11,700.00 Budgeted 6,796.68 Remaining 42 % Used Account: 135-65010-021-000 Uniforms 620.98 .00 620.98 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 620.98 ** 2,505.00 Budgeted 1,884.02 Remaining 25 % Used Account: 135-65030-021-000 Chemicals .00 .00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 .00 ** 12,500.00 Budgeted 12,500.00 Remaining 0 % Used Account: 135-65035-021-000 Small Tools .00 .00 _______________ Account: 135-65035-021-000 Small Tools Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-65040-021-000 Safety Equipment 22.74 .00 22.74 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 22.74 ** 1,150.00 Budgeted 1,127.26 Remaining 2 % Used Account: 135-65055-021-000 Hardware . glpdatb2 rgonzale Trophy Club Entities Page 46 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 44.95 .00 44.95 _______________ Account: 135-65055-021-000 Hardware Totals: .00 44.95 ** 750.00 Budgeted 705.05 Remaining 6 % Used Account: 135-65095-021-000 Maintenance Supplies 204.14 .00 204.14 _______________ Account: 135-65095-021-000 Maintenance Supplies Totals: .00 204.14 ** 16,050.00 Budgeted 15,845.86 Remaining 1 % Used Account: 135-69005-021-000 Capital Expenses 31,991.00 .00 31,991.00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 31,991.00 ** 15,000.00 Budgeted (16,991.00) Remaining 213 % Used Account: 135-69035-021-000 Vehicles 882 04/26/2012 April A/P March PCards 1,001.25 1,001.25 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 135-69035-021-000 Vehicles Totals: 1,001.25 1,001.25 ** .00 Budgeted (1,001.25) Remaining 0 % Used Account: 135-69280-021-000 Capital Repairs .00 .00 _______________ Account: 135-69280-021-000 Capital Repairs Totals: .00 .00 ** 80,000.00 Budgeted 80,000.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 175,391.90 ** 497,762.00 Budgeted 322,370.10 Remaining 35 % Used . glpdatb2 rgonzale Trophy Club Entities Page 47 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 4,900.00 .00 4,900.00 _______________ Account: 135-50005-026-000 Salaries & Wages Totals: .00 4,900.00 ** 10,000.00 Budgeted 5,100.00 Remaining 49 % Used Account: 135-50030-026-000 Social Security Taxes 303.80 .00 303.80 _______________ Account: 135-50030-026-000 Social Security Taxes Totals: .00 303.80 ** 620.00 Budgeted 316.20 Remaining 49 % Used Account: 135-50035-026-000 Medicare Taxes 71.05 .00 71.05 _______________ Account: 135-50035-026-000 Medicare Taxes Totals: .00 71.05 ** 145.00 Budgeted 73.95 Remaining 49 % Used Account: 135-50040-026-000 Unemployment Taxes 39.20 .00 39.20 _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .00 39.20 ** 210.00 Budgeted 170.80 Remaining 19 % Used Account: 135-50045-026-000 Workman's Compensation 120.00 .00 120.00 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 120.00 ** 120.00 Budgeted .00 Remaining 100 % Used Account: 135-60035-026-000 Postage 26.11 .00 26.11 _______________ Account: 135-60035-026-000 Postage Totals: .00 26.11 ** 50.00 Budgeted 23.89 Remaining 52 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club Entities Page 48 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 685.00 .00 685.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 685.00 ** 2,100.00 Budgeted 1,415.00 Remaining 33 % Used Account: 135-60075-026-000 Meetings 768 04/09/2012 April A/P Chamber luncheon/Sanders & McK 352.56 22.00 374.56 NORTHWEST METROPORT CHAMBER 31368 AP 882 04/26/2012 April A/P March PCards 224.87 599.43 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 240.00 839.43 JPMORGAN CHASE BANK NA 31401 AP 991 04/26/2012 Recode JPChase/Slaght AWBD/Kevin (224.87) 614.56 GL _______________ Account: 135-60075-026-000 Meetings Totals: 262.00 614.56 ** 1,278.00 Budgeted 663.44 Remaining 48 % Used Account: 135-60080-026-000 Schools & Training 991 04/26/2012 Recode JPChase/Slaght AWBD/Kevin 875.00 224.87 1,099.87 GL _______________ Account: 135-60080-026-000 Schools & Training Totals: 224.87 1,099.87 ** 4,150.00 Budgeted 3,050.13 Remaining 27 % Used Account: 135-60100-026-000 Travel & per diem 32.19 .00 32.19 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 32.19 ** 6,199.00 Budgeted 6,166.81 Remaining 1 % Used Account: 135-60245-026-000 Miscellaneous Expenses 1,017.69 .00 1,017.69 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,017.69 ** 3,200.00 Budgeted 2,182.31 Remaining 32 % Used Account: 135-65085-026-000 Office Supplies 8.90 .00 8.90 _______________ Account: 135-65085-026-000 Office Supplies Totals: .00 8.90 ** 50.00 Budgeted 41.10 Remaining 18 % Used . glpdatb2 rgonzale Trophy Club Entities Page 49 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 26 Totals: ------------------------------------------------------------------------------------------------ 8,918.37 ** 28,122.00 Budgeted 19,203.63 Remaining 32 % Used . glpdatb2 rgonzale Trophy Club Entities Page 50 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-027-000 Salaries & Wages 774 04/13/2012 PAYROLL 4/13/12 Salaries & Wages 153,902.42 9,822.69 163,725.11 PR 932 04/27/2012 Payroll 4/27/12 8,130.97 171,856.08 GL _______________ Account: 135-50005-027-000 Salaries & Wages Totals: 17,953.66 171,856.08 ** 236,831.00 Budgeted 64,974.92 Remaining 73 % Used Account: 135-50010-027-000 Overtime 774 04/13/2012 PAYROLL 4/13/12 Overtime 1,027.97 .71 1,028.68 PR 932 04/27/2012 Payroll 4/27/12 5.44 1,034.12 GL _______________ Account: 135-50010-027-000 Overtime Totals: 6.15 1,034.12 ** 1,028.00 Budgeted (6.12) Remaining 101 % Used Account: 135-50016-027-000 Longevity 3,705.00 .00 3,705.00 _______________ Account: 135-50016-027-000 Longevity Totals: .00 3,705.00 ** 1,845.00 Budgeted (1,860.00) Remaining 201 % Used Account: 135-50020-027-000 Retirement 774 04/13/2012 PAYROLL 4/13/12 Retirement 22,467.33 1,357.59 23,824.92 PR 932 04/27/2012 Payroll 4/27/12 1,030.52 24,855.44 GL _______________ Account: 135-50020-027-000 Retirement Totals: 2,388.11 24,855.44 ** 33,471.00 Budgeted 8,615.56 Remaining 74 % Used Account: 135-50026-027-000 Medical Insurance 774 04/13/2012 PAYROLL 4/13/12 Medical Insurance 8,502.14 679.21 9,181.35 PR 932 04/27/2012 Payroll 4/27/12 752.41 9,933.76 GL _______________ Account: 135-50026-027-000 Medical Insurance Totals: 1,431.62 9,933.76 ** 18,798.00 Budgeted 8,864.24 Remaining 53 % Used Account: 135-50027-027-000 Dental Insurance 774 04/13/2012 PAYROLL 4/13/12 Dental Insurance 645.07 56.12 701.19 PR 932 04/27/2012 Payroll 4/27/12 63.23 764.42 GL . glpdatb2 rgonzale Trophy Club Entities Page 51 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-027-000 Dental Insurance Totals: 119.35 764.42 ** 1,242.00 Budgeted 477.58 Remaining 62 % Used Account: 135-50028-027-000 Vision Insurance 774 04/13/2012 PAYROLL 4/13/12 Vision Insurance 161.39 13.17 174.56 PR 932 04/27/2012 Payroll 4/27/12 14.86 189.42 GL _______________ Account: 135-50028-027-000 Vision Insurance Totals: 28.03 189.42 ** 341.00 Budgeted 151.58 Remaining 56 % Used Account: 135-50029-027-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-027-000 Life Insurance & Other Totals: .00 .00 ** 1,337.00 Budgeted 1,337.00 Remaining 0 % Used Account: 135-50030-027-000 Social Security Taxes 774 04/13/2012 PAYROLL 4/13/12 Social Security Taxes 9,571.82 564.20 10,136.02 PR 932 04/27/2012 Payroll 4/27/12 449.50 10,585.52 GL _______________ Account: 135-50030-027-000 Social Security Taxes Totals: 1,013.70 10,585.52 ** 14,860.00 Budgeted 4,274.48 Remaining 71 % Used Account: 135-50035-027-000 Medicare Taxes 774 04/13/2012 PAYROLL 4/13/12 Medicare Taxes 2,276.45 131.95 2,408.40 PR 932 04/27/2012 Payroll 4/27/12 105.13 2,513.53 GL _______________ Account: 135-50035-027-000 Medicare Taxes Totals: 237.08 2,513.53 ** 3,475.00 Budgeted 961.47 Remaining 72 % Used Account: 135-50040-027-000 Unemployment Taxes 774 04/13/2012 PAYROLL 4/13/12 Unemployment Taxes 248.01 54.59 302.60 PR 932 04/27/2012 Payroll 4/27/12 8.53 311.13 GL _______________ Account: 135-50040-027-000 Unemployment Taxes Totals: 63.12 311.13 ** 756.00 Budgeted 444.87 Remaining 41 % Used . glpdatb2 rgonzale Trophy Club Entities Page 52 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-027-000 Workman's Compensation 580.00 .00 580.00 _______________ Account: 135-50045-027-000 Workman's Compensation Totals: .00 580.00 ** 580.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-027-000 Pre-emp Physicals/Testing 972 04/30/2012 Apr A/P Pre-emp testing/McKnight 35.00 35.00 CARENOW CORPORATE 31445 AP _______________ Account: 135-50060-027-000 Pre-emp Physicals/Testing Totals: 35.00 35.00 ** .00 Budgeted (35.00) Remaining 0 % Used Account: 135-50070-027-000 Employee Relations 3,474.16 .00 3,474.16 _______________ Account: 135-50070-027-000 Employee Relations Totals: .00 3,474.16 ** 5,000.00 Budgeted 1,525.84 Remaining 69 % Used Account: 135-55070-027-000 Independent Labor 221.25 .00 221.25 _______________ Account: 135-55070-027-000 Independent Labor Totals: .00 221.25 ** 840.00 Budgeted 618.75 Remaining 26 % Used Account: 135-55075-027-000 Records Management .00 .00 _______________ Account: 135-55075-027-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55160-027-000 Professional Outside Services 190,769.36 .00 190,769.36 _______________ Account: 135-55160-027-000 Professional Outside Services Totals: .00 190,769.36 ** 190,979.00 Budgeted 209.64 Remaining 100 % Used Account: 135-60005-027-000 Telephone . glpdatb2 rgonzale Trophy Club Entities Page 53 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 972 04/30/2012 Apr A/P PCards Zieverink-3/28-4/27 122.44 44.71 167.15 BANK OF AMERICA 31441 AP _______________ Account: 135-60005-027-000 Telephone Totals: 44.71 167.15 ** 300.00 Budgeted 132.85 Remaining 56 % Used Account: 135-60010-027-000 Communications/Pagers/Mobiles 972 04/30/2012 Apr A/P Cell phones 3/23-4/22 1,034.05 90.86 1,124.91 VERIZON WIRELESS 31476 AP _______________ Account: 135-60010-027-000 Communications/Pagers/Mobiles Totals: 90.86 1,124.91 ** 2,420.00 Budgeted 1,295.09 Remaining 46 % Used Account: 135-60035-027-000 Postage 938 04/30/2012 April Postage Meter usage 899.81 59.59 959.40 GL _______________ Account: 135-60035-027-000 Postage Totals: 59.59 959.40 ** 1,800.00 Budgeted 840.60 Remaining 53 % Used Account: 135-60066-027-000 Publications/Books/Subscripts 354.15 .00 354.15 _______________ Account: 135-60066-027-000 Publications/Books/Subscripts Totals: .00 354.15 ** 450.00 Budgeted 95.85 Remaining 79 % Used Account: 135-60070-027-000 Dues & Memberships 882 04/26/2012 April A/P Notary-McKnight 442.05 85.00 527.05 VICTOR O SCHINNERER & CO, INC 31435 AP _______________ Account: 135-60070-027-000 Dues & Memberships Totals: 85.00 527.05 ** 1,742.00 Budgeted 1,214.95 Remaining 30 % Used Account: 135-60075-027-000 Meetings 768 04/09/2012 April A/P Chamber luncheon/Sanders & McK 22.00 22.00 NORTHWEST METROPORT CHAMBER 31368 AP 882 04/26/2012 April A/P March PCards 495.00 517.00 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 240.00 757.00 JPMORGAN CHASE BANK NA 31401 AP 991 04/26/2012 Recode JPChase/Slaght Recode Tx Water (495.00) 262.00 GL 991 04/26/2012 Recode JPChase/Slaght Recode COG/PFIA training (240.00) 22.00 GL _______________ Account: 135-60075-027-000 Meetings Totals: 22.00 22.00 ** 312.00 Budgeted 290.00 Remaining 7 % Used . glpdatb2 rgonzale Trophy Club Entities Page 54 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60080-027-000 Schools & Training 991 04/26/2012 Recode JPChase/Slaght Recode Tx Water 670.00 495.00 1,165.00 GL 991 04/26/2012 Recode JPChase/Slaght Recode COG/PFIA training 240.00 1,405.00 GL _______________ Account: 135-60080-027-000 Schools & Training Totals: 735.00 1,405.00 ** 2,555.00 Budgeted 1,150.00 Remaining 55 % Used Account: 135-60100-027-000 Travel & per diem 628.00 .00 628.00 _______________ Account: 135-60100-027-000 Travel & per diem Totals: .00 628.00 ** 3,851.00 Budgeted 3,223.00 Remaining 16 % Used Account: 135-60115-027-000 Elections .00 .00 _______________ Account: 135-60115-027-000 Elections Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60125-027-000 Advertising .00 .00 _______________ Account: 135-60125-027-000 Advertising Totals: .00 .00 ** 4,700.00 Budgeted 4,700.00 Remaining 0 % Used Account: 135-60245-027-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-027-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-60270-027-000 4th of July Celebration 10,000.00 .00 10,000.00 _______________ Account: 135-60270-027-000 4th of July Celebration Totals: .00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 135-60360-027-000 Furniture/Equipment < $5000 . glpdatb2 rgonzale Trophy Club Entities Page 55 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 299.99 .00 299.99 _______________ Account: 135-60360-027-000 Furniture/Equipment < $5000 Totals: .00 299.99 ** 2,225.00 Budgeted 1,925.01 Remaining 13 % Used Account: 135-65085-027-000 Office Supplies 882 04/26/2012 April A/P Office Supplies 1,099.38 11.98 1,111.36 OFFICE DEPOT, INC 31422 AP 882 04/26/2012 April A/P Office Supplies 90.49 1,201.85 OFFICE DEPOT, INC 31422 AP 882 04/26/2012 April A/P Office Supplies 60.21 1,262.06 OFFICE DEPOT, INC 31422 AP 972 04/30/2012 Apr A/P Office supplies 80.26 1,342.32 OFFICE DEPOT, INC 31458 AP _______________ Account: 135-65085-027-000 Office Supplies Totals: 242.94 1,342.32 ** 2,450.00 Budgeted 1,107.68 Remaining 55 % Used Account: 135-65105-027-000 Printing 589.45 .00 589.45 _______________ Account: 135-65105-027-000 Printing Totals: .00 589.45 ** 750.00 Budgeted 160.55 Remaining 79 % Used Department 27 Totals: ------------------------------------------------------------------------------------------------ 438,247.61 ** 548,038.00 Budgeted 109,790.39 Remaining 80 % Used . glpdatb2 rgonzale Trophy Club Entities Page 56 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50070-028-000 Employee Relations 1,470.22 .00 1,470.22 _______________ Account: 135-50070-028-000 Employee Relations Totals: .00 1,470.22 ** 1,967.00 Budgeted 496.78 Remaining 75 % Used Account: 135-50075-028-000 Tuition Reimbursement 19.95 .00 19.95 _______________ Account: 135-50075-028-000 Tuition Reimbursement Totals: .00 19.95 ** 1,561.00 Budgeted 1,541.05 Remaining 1 % Used Account: 135-60005-028-000 Telephone .00 .00 _______________ Account: 135-60005-028-000 Telephone Totals: .00 .00 ** 28.00 Budgeted 28.00 Remaining 0 % Used Account: 135-60035-028-000 Postage .00 .00 _______________ Account: 135-60035-028-000 Postage Totals: .00 .00 ** 106.00 Budgeted 106.00 Remaining 0 % Used Account: 135-60066-028-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-028-000 Publications/Books/Subscripts Totals: .00 .00 ** 485.00 Budgeted 485.00 Remaining 0 % Used Account: 135-60070-028-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-028-000 Dues & Memberships Totals: .00 .00 ** 555.00 Budgeted 555.00 Remaining 0 % Used Account: 135-60075-028-000 Meetings . glpdatb2 rgonzale Trophy Club Entities Page 57 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60075-028-000 Meetings Totals: .00 .00 ** 138.00 Budgeted 138.00 Remaining 0 % Used Account: 135-60080-028-000 Schools & Training .00 .00 _______________ Account: 135-60080-028-000 Schools & Training Totals: .00 .00 ** 594.00 Budgeted 594.00 Remaining 0 % Used Account: 135-60110-028-000 Physicals/Testing 105.00 .00 105.00 _______________ Account: 135-60110-028-000 Physicals/Testing Totals: .00 105.00 ** 1,560.00 Budgeted 1,455.00 Remaining 7 % Used Account: 135-65085-028-000 Office Supplies .00 .00 _______________ Account: 135-65085-028-000 Office Supplies Totals: .00 .00 ** 437.00 Budgeted 437.00 Remaining 0 % Used Account: 135-65105-028-000 Printing .00 .00 _______________ Account: 135-65105-028-000 Printing Totals: .00 .00 ** 116.00 Budgeted 116.00 Remaining 0 % Used Department 28 Totals: ------------------------------------------------------------------------------------------------ 1,595.17 ** 7,547.00 Budgeted 5,951.83 Remaining 21 % Used . glpdatb2 rgonzale Trophy Club Entities Page 58 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-029-000 Salaries & Wages 774 04/13/2012 PAYROLL 4/13/12 Salaries & Wages 42,021.49 3,001.18 45,022.67 PR 932 04/27/2012 Payroll 4/27/12 3,001.18 48,023.85 GL _______________ Account: 135-50005-029-000 Salaries & Wages Totals: 6,002.36 48,023.85 ** 94,404.00 Budgeted 46,380.15 Remaining 51 % Used Account: 135-50010-029-000 Overtime 946.28 .00 946.28 _______________ Account: 135-50010-029-000 Overtime Totals: .00 946.28 ** 1,000.00 Budgeted 53.72 Remaining 95 % Used Account: 135-50016-029-000 Longevity 1,822.50 .00 1,822.50 _______________ Account: 135-50016-029-000 Longevity Totals: .00 1,822.50 ** 1,823.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-029-000 Retirement 774 04/13/2012 PAYROLL 4/13/12 Retirement 6,539.08 414.76 6,953.84 PR 932 04/27/2012 Payroll 4/27/12 414.76 7,368.60 GL _______________ Account: 135-50020-029-000 Retirement Totals: 829.52 7,368.60 ** 13,612.00 Budgeted 6,243.40 Remaining 54 % Used Account: 135-50026-029-000 Medical Insurance 774 04/13/2012 PAYROLL 4/13/12 Medical Insurance 4,131.78 205.35 4,337.13 PR 932 04/27/2012 Payroll 4/27/12 205.35 4,542.48 GL _______________ Account: 135-50026-029-000 Medical Insurance Totals: 410.70 4,542.48 ** 11,060.00 Budgeted 6,517.52 Remaining 41 % Used Account: 135-50027-029-000 Dental Insurance 774 04/13/2012 PAYROLL 4/13/12 Dental Insurance 379.87 24.51 404.38 PR 932 04/27/2012 Payroll 4/27/12 24.51 428.89 GL _______________ Account: 135-50027-029-000 Dental Insurance Totals: 49.02 428.89 ** 773.00 Budgeted 344.11 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club Entities Page 59 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-029-000 Vision Insurance 774 04/13/2012 PAYROLL 4/13/12 Vision Insurance 60.63 3.38 64.01 PR 932 04/27/2012 Payroll 4/27/12 3.38 67.39 GL _______________ Account: 135-50028-029-000 Vision Insurance Totals: 6.76 67.39 ** 207.00 Budgeted 139.61 Remaining 33 % Used Account: 135-50029-029-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-029-000 Life Insurance & Other Totals: .00 .00 ** 567.00 Budgeted 567.00 Remaining 0 % Used Account: 135-50030-029-000 Social Security Taxes 774 04/13/2012 PAYROLL 4/13/12 Social Security Taxes 2,604.53 172.92 2,777.45 PR 932 04/27/2012 Payroll 4/27/12 172.92 2,950.37 GL _______________ Account: 135-50030-029-000 Social Security Taxes Totals: 345.84 2,950.37 ** 5,386.00 Budgeted 2,435.63 Remaining 55 % Used Account: 135-50035-029-000 Medicare Taxes 774 04/13/2012 PAYROLL 4/13/12 Medicare Taxes 609.13 40.44 649.57 PR 932 04/27/2012 Payroll 4/27/12 40.44 690.01 GL _______________ Account: 135-50035-029-000 Medicare Taxes Totals: 80.88 690.01 ** 1,260.00 Budgeted 569.99 Remaining 55 % Used Account: 135-50040-029-000 Unemployment Taxes 79.54 .00 79.54 _______________ Account: 135-50040-029-000 Unemployment Taxes Totals: .00 79.54 ** 284.00 Budgeted 204.46 Remaining 28 % Used Account: 135-50045-029-000 Workman's Compensation 211.00 .00 211.00 _______________ Account: 135-50045-029-000 Workman's Compensation Totals: .00 211.00 ** 235.00 Budgeted 24.00 Remaining 90 % Used . glpdatb2 rgonzale Trophy Club Entities Page 60 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55160-029-000 Professional Outside Services 1,105.50 .00 1,105.50 _______________ Account: 135-55160-029-000 Professional Outside Services Totals: .00 1,105.50 ** 5,000.00 Budgeted 3,894.50 Remaining 22 % Used Account: 135-60005-029-000 Telephone 972 04/30/2012 Apr A/P PCards Zieverink-3/28-4/27 46.27 8.24 54.51 BANK OF AMERICA 31441 AP _______________ Account: 135-60005-029-000 Telephone Totals: 8.24 54.51 ** 103.00 Budgeted 48.49 Remaining 53 % Used Account: 135-60010-029-000 Communications/Pagers/Mobiles 972 04/30/2012 Apr A/P Cell phones 3/23-4/22 305.60 51.87 357.47 VERIZON WIRELESS 31476 AP _______________ Account: 135-60010-029-000 Communications/Pagers/Mobiles Totals: 51.87 357.47 ** 683.00 Budgeted 325.53 Remaining 52 % Used Account: 135-60035-029-000 Postage 938 04/30/2012 April Postage Meter usage 154.09 26.00 180.09 GL _______________ Account: 135-60035-029-000 Postage Totals: 26.00 180.09 ** 700.00 Budgeted 519.91 Remaining 26 % Used Account: 135-60040-029-000 Service Charges & Fees 32.50 .00 32.50 _______________ Account: 135-60040-029-000 Service Charges & Fees Totals: .00 32.50 ** 79.00 Budgeted 46.50 Remaining 41 % Used Account: 135-60066-029-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-029-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-029-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club Entities Page 61 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60070-029-000 Dues & Memberships Totals: .00 .00 ** 660.00 Budgeted 660.00 Remaining 0 % Used Account: 135-60075-029-000 Meetings 22.00 .00 22.00 _______________ Account: 135-60075-029-000 Meetings Totals: .00 22.00 ** 300.00 Budgeted 278.00 Remaining 7 % Used Account: 135-60080-029-000 Schools & Training 225.00 .00 225.00 _______________ Account: 135-60080-029-000 Schools & Training Totals: .00 225.00 ** 2,000.00 Budgeted 1,775.00 Remaining 11 % Used Account: 135-60100-029-000 Travel & per diem 27.81 .00 27.81 _______________ Account: 135-60100-029-000 Travel & per diem Totals: .00 27.81 ** .00 Budgeted (27.81) Remaining 0 % Used Account: 135-60125-029-000 Advertising .00 .00 _______________ Account: 135-60125-029-000 Advertising Totals: .00 .00 ** 1,210.00 Budgeted 1,210.00 Remaining 0 % Used Account: 135-60245-029-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-029-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65085-029-000 Office Supplies 882 04/26/2012 April A/P Office Supplies 106.87 7.77 114.64 OFFICE DEPOT, INC 31422 AP . glpdatb2 rgonzale Trophy Club Entities Page 62 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 972 04/30/2012 Apr A/P Office supplies 106.87 14.03 128.67 OFFICE DEPOT, INC 31458 AP _______________ Account: 135-65085-029-000 Office Supplies Totals: 21.80 128.67 ** 849.00 Budgeted 720.33 Remaining 15 % Used Account: 135-65105-029-000 Printing .00 .00 _______________ Account: 135-65105-029-000 Printing Totals: .00 .00 ** 515.00 Budgeted 515.00 Remaining 0 % Used Department 29 Totals: ------------------------------------------------------------------------------------------------ 69,264.46 ** 143,410.00 Budgeted 74,145.54 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club Entities Page 63 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55030-033-000 Software & Support 768 04/09/2012 April A/P Annual CRM/Intouch Maint agree 35,204.74 690.00 35,894.74 WEBQA, INC 31388 AP 882 04/26/2012 April A/P March PCards 326.69 36,221.43 JPMORGAN CHASE BANK NA 31401 AP 972 04/30/2012 Apr A/P Vision & January support 5,903.38 42,124.81 STW INC 31468 AP 972 04/30/2012 Apr A/P Pcards/Pastor 3/28-4/27 25.00 42,149.81 BANK OF AMERICA 31441 AP 972 04/30/2012 Apr A/P Pcards/Pastor 3/28-4/27 299.97 42,449.78 BANK OF AMERICA 31441 AP 972 04/30/2012 Apr A/P PCards Zieverink-3/28-4/27 54.99 42,504.77 BANK OF AMERICA 31441 AP 972 04/30/2012 Apr A/P PCards Zieverink-3/28-4/27 53.38 42,558.15 BANK OF AMERICA 31441 AP _______________ Account: 135-55030-033-000 Software & Support Totals: 7,353.41 42,558.15 ** 64,149.00 Budgeted 21,590.85 Remaining 66 % Used Account: 135-55070-033-000 Independent Labor 375.00 .00 375.00 _______________ Account: 135-55070-033-000 Independent Labor Totals: .00 375.00 ** 1,650.00 Budgeted 1,275.00 Remaining 23 % Used Account: 135-60005-033-000 Telephone 972 04/30/2012 Apr A/P PCards Zieverink-3/28-4/27 4,534.82 394.01 4,928.83 BANK OF AMERICA 31441 AP 972 04/30/2012 Apr A/P PCards Zieverink-3/28-4/27 369.53 5,298.36 BANK OF AMERICA 31441 AP _______________ Account: 135-60005-033-000 Telephone Totals: 763.54 5,298.36 ** 6,540.00 Budgeted 1,241.64 Remaining 81 % Used Account: 135-60235-033-000 Security 406.60 .00 406.60 _______________ Account: 135-60235-033-000 Security Totals: .00 406.60 ** 1,350.00 Budgeted 943.40 Remaining 30 % Used Account: 135-65055-033-000 Hardware 882 04/26/2012 April A/P Repalce projectors 61,195.32 2,034.98 63,230.30 SHI GOVERNMENT SOLUTIONS,INC 31430 AP 882 04/26/2012 April A/P Projector mounting kits 211.00 63,441.30 SHI GOVERNMENT SOLUTIONS,INC 31430 AP 972 04/30/2012 Apr A/P Patch cable, Modular plug 17.65 63,458.95 SHI GOVERNMENT SOLUTIONS,INC 31464 AP 972 04/30/2012 Apr A/P Trendnet media converter 61.50 63,520.45 SHI GOVERNMENT SOLUTIONS,INC 31464 AP 972 04/30/2012 Apr A/P PCards Zieverink-3/28-4/27 109.99 63,630.44 BANK OF AMERICA 31441 AP _______________ Account: 135-65055-033-000 Hardware Totals: 2,435.12 63,630.44 ** 83,238.00 Budgeted 19,607.56 Remaining 76 % Used . glpdatb2 rgonzale Trophy Club Entities Page 64 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65085-033-000 Office Supplies 176.93 .00 176.93 _______________ Account: 135-65085-033-000 Office Supplies Totals: .00 176.93 ** 371.00 Budgeted 194.07 Remaining 48 % Used Account: 135-65090-033-000 Printer Supplies & Maintenance 972 04/30/2012 Apr A/P Drum Kit, Toner cartridges 3,073.38 235.00 3,308.38 SHI GOVERNMENT SOLUTIONS,INC 31464 AP _______________ Account: 135-65090-033-000 Printer Supplies & Maintenance Totals: 235.00 3,308.38 ** 5,732.00 Budgeted 2,423.62 Remaining 58 % Used Account: 135-69170-033-000 Copier Lease Installments 882 04/26/2012 April A/P Copier lease/April 1,284.25 256.85 1,541.10 KYOCERA MITA AMERICA, INC. 31405 AP _______________ Account: 135-69170-033-000 Copier Lease Installments Totals: 256.85 1,541.10 ** 3,450.00 Budgeted 1,908.90 Remaining 45 % Used Account: 135-69195-033-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-033-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 26,911.00 Budgeted 26,911.00 Remaining 0 % Used Department 33 Totals: ------------------------------------------------------------------------------------------------ 117,294.96 ** 193,391.00 Budgeted 76,096.04 Remaining 61 % Used . glpdatb2 rgonzale Trophy Club Entities Page 65 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-037-000 Workman's Compensation 861.00 .00 861.00 _______________ Account: 135-50045-037-000 Workman's Compensation Totals: .00 861.00 ** .00 Budgeted (861.00) Remaining 0 % Used Account: 135-55100-037-000 Building Maint & Supplies 972 04/30/2012 Apr A/P Window cleaning 724.68 200.00 924.68 SQUEAKY CLEAN WINDOWS 31466 AP _______________ Account: 135-55100-037-000 Building Maint & Supplies Totals: 200.00 924.68 ** 20,478.00 Budgeted 19,553.32 Remaining 5 % Used Account: 135-55120-037-000 Cleaning Services 768 04/09/2012 April A/P Janitorial Service/April 7,519.12 1,678.51 9,197.63 ABM JANITORIAL SERVICES, INC 31358 AP 882 04/26/2012 April A/P March PCards 55.05 9,252.68 JPMORGAN CHASE BANK NA 31401 AP 882 04/26/2012 April A/P March PCards 287.46 9,540.14 JPMORGAN CHASE BANK NA 31401 AP _______________ Account: 135-55120-037-000 Cleaning Services Totals: 2,021.02 9,540.14 ** 25,000.00 Budgeted 15,459.86 Remaining 38 % Used Account: 135-60020-037-000 Electricity 882 04/26/2012 April A/P Electricity 2/15-3/15 5,223.56 1,050.77 6,274.33 DIRECT ENERGY BUSINESS SVCS 31398 AP _______________ Account: 135-60020-037-000 Electricity Totals: 1,050.77 6,274.33 ** 21,940.00 Budgeted 15,665.67 Remaining 29 % Used Account: 135-60025-037-000 Water 972 04/30/2012 Apr A/P April Water 295.32 36.86 332.18 TROPHY CLUB MUD (WATER BILLS) 31475 AP _______________ Account: 135-60025-037-000 Water Totals: 36.86 332.18 ** 1,093.00 Budgeted 760.82 Remaining 30 % Used Account: 135-60030-037-000 Rent And/Or Usage 768 04/09/2012 April A/P April Public Services Rent 6,591.06 1,098.51 7,689.57 TOWN OF TROPHY CLUB 31379 AP _______________ Account: 135-60030-037-000 Rent And/Or Usage Totals: 1,098.51 7,689.57 ** 13,182.00 Budgeted 5,492.43 Remaining 58 % Used . glpdatb2 rgonzale Trophy Club Entities Page 66 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60055-037-000 Insurance 882 04/26/2012 April A/P Bond-D'Andria 30,286.73 50.00 30,336.73 VICTOR O SCHINNERER & CO, INC 31435 AP 882 04/26/2012 April A/P Bond-McKnight 50.00 30,386.73 VICTOR O SCHINNERER & CO, INC 31435 AP _______________ Account: 135-60055-037-000 Insurance Totals: 100.00 30,386.73 ** 32,635.00 Budgeted 2,248.27 Remaining 93 % Used Account: 135-60360-037-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-037-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 4,750.00 Budgeted 4,750.00 Remaining 0 % Used Account: 135-65095-037-000 Maintenance Supplies 882 04/26/2012 April A/P March PCards 651.37 35.38 686.75 JPMORGAN CHASE BANK NA 31401 AP 972 04/30/2012 Apr A/P Maintenance supplies 27.49 714.24 COSTCO WHOLESALE 31448 AP _______________ Account: 135-65095-037-000 Maintenance Supplies Totals: 62.87 714.24 ** 2,205.00 Budgeted 1,490.76 Remaining 32 % Used Account: 135-65097-037-000 Vending Machine Supplies 972 04/30/2012 Apr A/P Maintenance supplies 76.03 4.00 80.03 COSTCO WHOLESALE 31448 AP _______________ Account: 135-65097-037-000 Vending Machine Supplies Totals: 4.00 80.03 ** 1,000.00 Budgeted 919.97 Remaining 8 % Used Department 37 Totals: ------------------------------------------------------------------------------------------------ 56,802.90 ** 122,283.00 Budgeted 65,480.10 Remaining 46 % Used . glpdatb2 rgonzale Trophy Club Entities Page 67 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-038-000 Salaries & Wages 774 04/13/2012 PAYROLL 4/13/12 Salaries & Wages 41,042.33 3,342.17 44,384.50 PR 932 04/27/2012 Payroll 4/27/12 2,691.41 47,075.91 GL _______________ Account: 135-50005-038-000 Salaries & Wages Totals: 6,033.58 47,075.91 ** 84,946.00 Budgeted 37,870.09 Remaining 55 % Used Account: 135-50010-038-000 Overtime 774 04/13/2012 PAYROLL 4/13/12 Overtime 233.23 3.97 237.20 PR _______________ Account: 135-50010-038-000 Overtime Totals: 3.97 237.20 ** 2,000.00 Budgeted 1,762.80 Remaining 12 % Used Account: 135-50016-038-000 Longevity 220.00 .00 220.00 _______________ Account: 135-50016-038-000 Longevity Totals: .00 220.00 ** 220.00 Budgeted .00 Remaining 100 % Used Account: 135-50020-038-000 Retirement 774 04/13/2012 PAYROLL 4/13/12 Retirement 6,030.47 462.44 6,492.91 PR 932 04/27/2012 Payroll 4/27/12 371.96 6,864.87 GL _______________ Account: 135-50020-038-000 Retirement Totals: 834.40 6,864.87 ** 12,203.00 Budgeted 5,338.13 Remaining 56 % Used Account: 135-50026-038-000 Medical Insurance 774 04/13/2012 PAYROLL 4/13/12 Medical Insurance 5,545.38 462.14 6,007.52 PR 932 04/27/2012 Payroll 4/27/12 388.94 6,396.46 GL _______________ Account: 135-50026-038-000 Medical Insurance Totals: 851.08 6,396.46 ** 12,321.00 Budgeted 5,924.54 Remaining 52 % Used Account: 135-50027-038-000 Dental Insurance 774 04/13/2012 PAYROLL 4/13/12 Dental Insurance 549.87 45.83 595.70 PR 932 04/27/2012 Payroll 4/27/12 38.72 634.42 GL _______________ Account: 135-50027-038-000 Dental Insurance Totals: 84.55 634.42 ** 1,026.00 Budgeted 391.58 Remaining 62 % Used . glpdatb2 rgonzale Trophy Club Entities Page 68 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-038-000 Vision Insurance 774 04/13/2012 PAYROLL 4/13/12 Vision Insurance 129.74 10.81 140.55 PR 932 04/27/2012 Payroll 4/27/12 9.12 149.67 GL _______________ Account: 135-50028-038-000 Vision Insurance Totals: 19.93 149.67 ** 260.00 Budgeted 110.33 Remaining 58 % Used Account: 135-50029-038-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-038-000 Life Insurance & Other Totals: .00 .00 ** 604.00 Budgeted 604.00 Remaining 0 % Used Account: 135-50030-038-000 Social Security Taxes 774 04/13/2012 PAYROLL 4/13/12 Social Security Taxes 2,460.28 189.58 2,649.86 PR 932 04/27/2012 Payroll 4/27/12 154.45 2,804.31 GL _______________ Account: 135-50030-038-000 Social Security Taxes Totals: 344.03 2,804.31 ** 5,404.00 Budgeted 2,599.69 Remaining 52 % Used Account: 135-50035-038-000 Medicare Taxes 774 04/13/2012 PAYROLL 4/13/12 Medicare Taxes 575.39 44.35 619.74 PR 932 04/27/2012 Payroll 4/27/12 36.12 655.86 GL _______________ Account: 135-50035-038-000 Medicare Taxes Totals: 80.47 655.86 ** 1,264.00 Budgeted 608.14 Remaining 52 % Used Account: 135-50040-038-000 Unemployment Taxes 774 04/13/2012 PAYROLL 4/13/12 Unemployment Taxes 186.61 3.38 189.99 PR _______________ Account: 135-50040-038-000 Unemployment Taxes Totals: 3.38 189.99 ** 473.00 Budgeted 283.01 Remaining 40 % Used Account: 135-50045-038-000 Workman's Compensation 235.00 .00 235.00 _______________ Account: 135-50045-038-000 Workman's Compensation Totals: .00 235.00 ** 211.00 Budgeted (24.00) Remaining 111 % Used . glpdatb2 rgonzale Trophy Club Entities Page 69 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55070-038-000 Independent Labor .00 .00 _______________ Account: 135-55070-038-000 Independent Labor Totals: .00 .00 ** 800.00 Budgeted 800.00 Remaining 0 % Used Account: 135-55205-038-000 Utility Billing Contract 6,001.07 .00 6,001.07 _______________ Account: 135-55205-038-000 Utility Billing Contract Totals: .00 6,001.07 ** 11,000.00 Budgeted 4,998.93 Remaining 55 % Used Account: 135-60005-038-000 Telephone 972 04/30/2012 Apr A/P PCards Zieverink-3/28-4/27 43.37 8.74 52.11 BANK OF AMERICA 31441 AP _______________ Account: 135-60005-038-000 Telephone Totals: 8.74 52.11 ** 100.00 Budgeted 47.89 Remaining 52 % Used Account: 135-60010-038-000 Communications/Pagers/Mobiles 972 04/30/2012 Apr A/P Cell phones 3/23-4/22 215.88 36.90 252.78 VERIZON WIRELESS 31476 AP _______________ Account: 135-60010-038-000 Communications/Pagers/Mobiles Totals: 36.90 252.78 ** 472.00 Budgeted 219.22 Remaining 54 % Used Account: 135-60035-038-000 Postage 8,474.64 .00 8,474.64 _______________ Account: 135-60035-038-000 Postage Totals: .00 8,474.64 ** 18,000.00 Budgeted 9,525.36 Remaining 47 % Used Account: 135-60040-038-000 Service Charges & Fees 951 04/03/2012 Authorize.net fees/Mar 14,670.28 62.25 14,732.53 GL 926 04/05/2012 CC fees/April 876.00 15,608.53 GL 926 04/05/2012 CC fees/April 97.03 15,705.56 GL 926 04/05/2012 CC fees/April 9.99 15,715.55 GL 926 04/05/2012 CC fees/April .05 15,715.60 GL _______________ Account: 135-60040-038-000 Service Charges & Fees Totals: 1,045.32 15,715.60 ** 29,340.00 Budgeted 13,624.40 Remaining 54 % Used . glpdatb2 rgonzale Trophy Club Entities Page 70 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-038-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-038-000 Dues & Memberships Totals: .00 .00 ** 71.00 Budgeted 71.00 Remaining 0 % Used Account: 135-60080-038-000 Schools & Training 225.00 .00 225.00 _______________ Account: 135-60080-038-000 Schools & Training Totals: .00 225.00 ** 800.00 Budgeted 575.00 Remaining 28 % Used Account: 135-60100-038-000 Travel & per diem .00 .00 _______________ Account: 135-60100-038-000 Travel & per diem Totals: .00 .00 ** 605.00 Budgeted 605.00 Remaining 0 % Used Account: 135-60130-038-000 Reg Assessment Fee (5%) 25,071.20 .00 25,071.20 _______________ Account: 135-60130-038-000 Reg Assessment Fee (5%) Totals: .00 25,071.20 ** 22,500.00 Budgeted (2,571.20) Remaining 111 % Used Account: 135-60245-038-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-038-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65085-038-000 Office Supplies 882 04/26/2012 April A/P Office Supplies 660.86 1.13 661.99 OFFICE DEPOT, INC 31422 AP _______________ Account: 135-65085-038-000 Office Supplies Totals: 1.13 661.99 ** 700.00 Budgeted 38.01 Remaining 95 % Used Account: 135-65105-038-000 Printing . glpdatb2 rgonzale Trophy Club Entities Page 71 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-65105-038-000 Printing Totals: .00 .00 ** 3,250.00 Budgeted 3,250.00 Remaining 0 % Used Department 38 Totals: ------------------------------------------------------------------------------------------------ 121,918.08 ** 208,770.00 Budgeted 86,851.92 Remaining 58 % Used . glpdatb2 rgonzale Trophy Club Entities Page 72 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 882 04/26/2012 April A/P March legal 44,495.54 6,503.30 50,998.84 WHITAKER CHALK SWINDLE 31436 AP 882 04/26/2012 April A/P March legal 181.50 51,180.34 WHITAKER CHALK SWINDLE 31436 AP 972 04/30/2012 Apr A/P April legal 3,927.20 55,107.54 THE LISTON LAW FIRM, P.C. 31471 AP _______________ Account: 135-55045-039-000 Legal Totals: 10,612.00 55,107.54 ** 70,000.00 Budgeted 14,892.46 Remaining 79 % Used Account: 135-55055-039-000 Auditing 20,200.00 .00 20,200.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 20,200.00 ** 20,200.00 Budgeted .00 Remaining 100 % Used Account: 135-55060-039-000 Appraisal 11,074.54 .00 11,074.54 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 11,074.54 ** 20,000.00 Budgeted 8,925.46 Remaining 55 % Used Account: 135-55065-039-000 Tax Admin Fees 2,470.09 .00 2,470.09 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,470.09 ** 3,629.00 Budgeted 1,158.91 Remaining 68 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 2,277.85 .00 2,277.85 _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: .00 2,277.85 ** 2,278.00 Budgeted .15 Remaining 100 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 91,130.02 ** 116,107.00 Budgeted 24,976.98 Remaining 78 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 14,632.44 (161,000.00) Budgeted (175,632.44) Remaining -9 % Used . glpdatb2 rgonzale Trophy Club Entities Page 73 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 522 2010 GO/Fire Station Department: Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 522-49025-000-000 Auction Sales (22,570.00) .00 (22,570.00) _______________ Account: 522-49025-000-000 Auction Sales Totals: .00 (22,570.00) ** .00 Budgeted 22,570.00 Remaining 0 % Used Account: 522-49145-000-000 Intergov Transfer-General Fund (2,277.85) .00 (2,277.85) _______________ Account: 522-49145-000-000 Intergov Transfer-General Fund Totals: .00 (2,277.85) ** .00 Budgeted 2,277.85 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (24,847.85) ** .00 Budgeted 24,847.85 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 74 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 522 2010 GO/Fire Station Department: 65 Construction Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 522-60031-065-000 Temporary Housing & Storage 41.58 .00 41.58 _______________ Account: 522-60031-065-000 Temporary Housing & Storage Totals: .00 41.58 ** .00 Budgeted (41.58) Remaining 0 % Used Department 65 Totals: ------------------------------------------------------------------------------------------------ 41.58 ** .00 Budgeted (41.58) Remaining 0 % Used Fund 522 Totals: ------------------------------------------------------------------------------------------------------ (24,806.27) .00 Budgeted 24,806.27 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 75 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 870 04/02/2012 Property Taxes/Assessments (535,123.34) (120.01) (535,243.35) GL 889 04/03/2012 Property Taxes/Assessments (268.87) (535,512.22) GL 890 04/04/2012 Property Taxes/Assessments (332.84) (535,845.06) GL 891 04/05/2012 Property Taxes/Assessments (306.16) (536,151.22) GL 892 04/09/2012 Property Taxes/Assessments (697.51) (536,848.73) GL 896 04/16/2012 Property Taxes/Assessments (144.56) (536,993.29) GL 897 04/20/2012 Property Taxes/Assessments (63.47) (537,056.76) GL 899 04/24/2012 Property Taxes/Assessments (422.32) (537,479.08) GL 900 04/25/2012 Property Taxes/Assessments (127.96) (537,607.04) GL 942 04/26/2012 Property Taxes/Assessments (7.22) (537,614.26) GL 943 04/27/2012 Property Taxes/Assessments (42.12) (537,656.38) GL 945 04/30/2012 Property Taxes/Assessments (38.81) (537,695.19) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (2,571.85) (537,695.19) ** (546,716.00) Budgeted (9,020.81) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 892 04/09/2012 Property Taxes/Assessments 3,287.56 (.65) 3,286.91 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (.65) 3,286.91 ** (3,947.00) Budgeted (7,233.91) Remaining -83 % Used Account: 533-40015-000-000 Property Taxes/P & I 870 04/02/2012 Property Taxes/Assessments (1,290.40) (6.95) (1,297.35) GL 889 04/03/2012 Property Taxes/Assessments (10.79) (1,308.14) GL 890 04/04/2012 Property Taxes/Assessments (21.80) (1,329.94) GL 891 04/05/2012 Property Taxes/Assessments (27.56) (1,357.50) GL 892 04/09/2012 Property Taxes/Assessments (62.75) (1,420.25) GL 896 04/16/2012 Property Taxes/Assessments (13.14) (1,433.39) GL 897 04/20/2012 Property Taxes/Assessments (4.72) (1,438.11) GL 899 04/24/2012 Property Taxes/Assessments (46.46) (1,484.57) GL 900 04/25/2012 Property Taxes/Assessments (14.08) (1,498.65) GL 943 04/27/2012 Property Taxes/Assessments (4.63) (1,503.28) GL 945 04/30/2012 Property Taxes/Assessments (2.33) (1,505.61) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (215.21) (1,505.61) ** (5,017.00) Budgeted (3,511.39) Remaining 30 % Used Account: 533-48005-000-000 Utility Fees . glpdatb2 rgonzale Trophy Club Entities Page 76 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (6,120.00) .00 (6,120.00) _______________ Account: 533-48005-000-000 Utility Fees Totals: .00 (6,120.00) ** (345,000.00) Budgeted (338,880.00) Remaining 2 % Used Account: 533-49010-000-000 Interest Income 946 04/30/2012 Texpool Interest/Apr (854.93) (73.42) (928.35) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (73.42) (928.35) ** (1,700.00) Budgeted (771.65) Remaining 55 % Used Account: 533-49015-000-000 Lease/Rental Income (308,000.00) .00 (308,000.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (308,000.00) ** .00 Budgeted 308,000.00 Remaining 0 % Used Account: 533-49110-000-000 Premium on Bonds Sold (4,661.84) .00 (4,661.84) _______________ Account: 533-49110-000-000 Premium on Bonds Sold Totals: .00 (4,661.84) ** .00 Budgeted 4,661.84 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (855,624.08) ** (902,380.00) Budgeted (46,755.92) Remaining 95 % Used . glpdatb2 rgonzale Trophy Club Entities Page 77 17:53 05/10/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 4/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 500.00 .00 500.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 500.00 ** 4,000.00 Budgeted 3,500.00 Remaining 13 % Used Account: 533-70025-051-000 Bond Interest Expense 150,650.00 .00 150,650.00 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 150,650.00 ** 301,300.00 Budgeted 150,650.00 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 565,000.00 Budgeted 565,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 151,150.00 ** 870,300.00 Budgeted 719,150.00 Remaining 17 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (704,474.08) (32,080.00) Budgeted 672,394.08 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (1,199,896.14) **** (193,080.00) Budgeted 1,006,816.14 Remaining 621 % Used ******* End of Report ********* BUDGET VARIANCE REPORT FUND:122 - Fire O&M FINANCIALS MONTH:April 2012 REVENUE VARIANCE:50% EXPENSE VARIANCE:69% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD %VARIANCE EXPLANATION FIRE REVENUE 122-40001 Assessment- Emergency Svcs (193,233)$ (3,124)$ (189,333)$ 98%Majority of Taxes collected by January 31 122-40003 Emergency Services/Assessments- Delinquent (4,900)$ (1,050)$ (5,906)$ 121%Prior year assessment refunds caused a debit balance. 122-40010 Property Taxes/MUD Fire (1,076,976)$ (5,030)$ (1,051,614)$ 98%Majority of Taxes collected by January 31 122-40011 Property Taxes/Fire-Delinquent (5,603)$ (0)$ 5,462$ -97%Prior year tax refunds caused a debit balance. 122-40015 Property Taxes Assessments P&I (725)$ (879)$ (1,831)$ 253%P&I for delinquent taxes 122-49900 Miscellaneous Income (7,998)$ (100)$ (9,222)$ 115%Miscellaneous permits FIRE EXPENSES 122-55110-045 Maintenance-Radios 1,103$ 393$ 786$ 71%Operational Radio repair 122-60070-045 Dues & Memberships 8,560$ 50$ 6,180$ 72%Annual dues 122-65015-045 Protective Clothing 7,600$ 5,810$ 5,894$ 78%Replaced 3 sets of gear for the next 4 years. 122-69255-045 Airpacks 13,865$ 14,526$ 14,526$ 105%Paid off 20 yr note for old airpacks Explanation provided for all accounts with a Year-To-Date percentage (YTD%)less than the Revenue Variance and greater than or equal to the Expense Variance.The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 10% for expenses. BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:April 2012 REVENUE VARIANCE:50% EXPENSE VARIANCE:69% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD %VARIANCE EXPLANATION REVENUE 135-40000 Property Taxes (97,495) (455) (95,199)98%Majority of Taxes collected by January 31st 135-40002 Property Taxes/Delinquent (451)$ (0)$ 672$ -149%Prior year tax refunds caused a debit balance. 135-40015 Property Taxes/P&I (1,334)$ (38)$ 53$ -4%Prior year tax refunds caused a debit balance. 135-47035 Plumbing Inspections (1,200)$ (50)$ (1,100)$ 92%Inspections on new construction 135-47045 Sewer Inspections (4,500)$ (150)$ (3,300)$ 73%Inspections on new construction 135-47405 Out of District Sewer (11,807)$ (857)$ (6,509)$ 55%Misread from prior month corrected 135-48005 Utility Fees 161,000$ (48,300)$ (421,680)$ -262%PID Connections,%will go down once budget is reversed. 135-49075 Oversize Meter Reimbursement (64,000)$ (6,424)$ (65,773)$ 103%Charged for all meters 1" and above WATER 135-69005-010 Capital Expenses 888,432$ 350,304$ 1,265,871$ 142%Meters and Ground Storage expansion 135-69305-010 Capital Leases 11,490$ 10,145$ 10,145$ 88%Final payment/Vac Hunter Trailer 135-65050-010 Meter Expense 94,000$ 27,150$ 90,769$ 97%Additional meters needed WASTEWATER 135-50010-020 Overtime 10,166$ 971$ 7,262$ 71%On call overtime 135-60025-020 Water 1,900$ 157$ 1,383$ 73%Water usage 135-60100-020 Travel & Per Diem 1,750$ 202$ 1,293$ 74%Mileage for training classes,on call mileage COLLECTIONS 135-60016-021 Communications/Mobiles 2,796$ 205$ 1,957$ 70%Monthly Mobiles MANAGER'S OFFICE 135-50005-027 Salaries & Wages 236,831$ 17,954$ 171,856$ 73%Robert Scott Contract 135-50010-027 Overtime 1,000$ 6$ 1,034$ 103%Front desk overtime 135-50020-027 Retirement 33,471$ 2,388$ 24,855$ 74%Robert Scott Contract 135-50030-027 Social Security Taxes 14,860$ 1,014$ 10,586$ 71%Robert Scott Contract 135-50035-027 Medicare Taxes 3,475$ 237$ 2,514$ 72%Robert Scott Contract INFORMATION SYSTEMS 135-60005-033 Telephone 6,540$ 764$ 5,298$ 81%Monthly Telephone 135-65055-033 Hardware 83,238$ 2,435$ 63,630$ 76%Misc hardware purchases FACILITIES MAINTENANCE 135-60055-037 Insurance 32,635$ 100$ 30,387$ 93%Insurance paid at beginning of year,paid part deductible on Carter claim UTILITY BILLING 135-65085-038 Office Supplies 700$ 1$ 662$ 95%Office supplies Explanation provided for all accounts with a Year-To-Date percentage (YTD%)less than the Revenue Variance and greater than or equal to the Expense Variance.The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%),less 8.3% for revenues and plus 10% for expenses. BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:April 2012 REVENUE VARIANCE:50% EXPENSE VARIANCE:69% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD %VARIANCE EXPLANATION Explanation provided for all accounts with a Year-To-Date percentage (YTD%)less than the Revenue Variance and greater than or equal to the Expense Variance.The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%),less 8.3% for revenues and plus 10% for expenses. NON-DEPARTMENTAL 135-55045-039 Legal 70,000$ 10,612$ 55,108$ 79%Legal