Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
August 2012 MUD Financials
Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 8/31/2012 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 610,714 INVESTMENTS 2,226,214 RESTRICTED ASSETS: INVESTMENTS 421,546 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 2,875 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,137,536 TOTAL ASSETS 4,399,285$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,875$ ACCOUNTS PAYABLE 660,093 CUSTOMER DEPOSITS 202,132 TOTAL LIABILITIES 865,100 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,728,274 TOTAL FUND BALANCE 3,534,185 TOTAL LIABILITIES AND FUND BALANCE 4,399,285$ August 31, 2012 11/12 Months (92% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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- 359.43- 97,153.02- 99.649 341.98- 135-40002-000-000 Property Taxes/Delinquent 451.00- 560.19 -124.211 1,011.19- 135-40015-000-000 Property Taxes/P & I 1,334.00- 200.00- 66.01- 233.04- 116.520 33.04 Subtotal: 98,829.00- 98,146.00- 425.44- 96,825.87- 98.655 1,320.13- 135-43215-000-000 Insurance Settlement 3,999.00- 3,999.00- 100.000 Subtotal: 3,999.00- 3,999.00- 100.000 135-47000-000-000 Water 1,990,800.00- 1,990,800.00- 278,319.45- 1,637,485.14- 82.253 353,314.86- 135-47005-000-000 Sewer 1,325,000.00- 1,325,000.00- 110,602.53- 949,041.32- 71.626 375,958.68- 135-47010-000-000 Commercial Water 825,000.00- 825,000.00- 131,298.30- 739,959.83- 89.692 85,040.17- 135-47015-000-000 Commercial Sewer 360,000.00- 360,000.00- 32,452.79- 264,726.37- 73.535 95,273.63- 135-47020-000-000 Standby 775.00- 775.00- 60.00- 643.35- 83.013 131.65- 135-47025-000-000 Penalties 50,500.00- 45,000.00- 5,460.64- 50,387.96- 111.973 5,387.96 135-47030-000-000 Service Charges 17,500.00- 15,000.00- 653.00- 10,160.48- 67.737 4,839.52- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,500.00- 200.00- 2,000.00- 133.333 500.00 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 600.00- 6,000.00- 133.333 1,500.00 135-47070-000-000 TCCC Effluent Charges 57,500.00- 75,000.00- 15,464.80- 56,492.29- 75.323 18,507.71- 135-47270-000-000 Fire Line 5,000.00- 135-47400-000-000 Water-Out of Dist/Port Meters 41,595.00- 41,595.00- 2,100.19- 35,098.55- 84.382 6,496.45- 135-47405-000-000 Out of District Sewer 11,807.00- 11,807.00- 1,345.59- 11,065.65- 93.721 741.35- 135-47410-000-000 Out of Dist/Portable Penalties 300.00- 100.00- 15.32- 56.77- 56.770 43.23- 135-47600-000-000 PID #1 Water 425,000.00- 500,000.00- 102,186.58- 536,650.61- 107.330 36,650.61 135-47605-000-000 PID #1 Sewer 185,000.00- 250,000.00- 34,468.33- 246,043.33- 98.417 3,956.67- Subtotal: 5,301,477.00- 5,446,077.00- 715,227.52- 4,545,811.65- 83.469 900,265.35- 135-48005-000-000 Utility Fees 338,880.00- 621,000.00- 27,600.00- 578,080.00- 93.089 42,920.00- Subtotal: 338,880.00- 621,000.00- 27,600.00- 578,080.00- 93.089 42,920.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- 606.15- 5,147.67- 114.393 647.67 135-49016-000-000 Cell Tower Revenue 10,164.00- 847.00- 9,317.00- 91.667 847.00- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 6,416.63- 91.666 583.37- 135-49025-000-000 Auction Sales 4,305.00- 4,305.00- 100.000 135-49030-000-000 Vending Revenue 600.00- 600.00- 111.00- 550.24- 91.707 49.76- 135-49035-000-000 Prior Year Reserves 241,981.00- 135-49036-000-000 GASB Reserves 26,911.00- 103,966.00- 103,966.00- 135-49075-000-000 Oversize Meter Reimbursement 64,000.00- 77,800.00- 4,672.00- 94,363.05- 121.289 16,563.05 135-49900-000-000 Miscellaneous Income 10,000.00- 5,400.00- 1,000.00- 6,418.82- 118.867 1,018.82 135-49905-000-000 Gas Well Revenue 800.00- 123.00- 123.00- 100.000 . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 355,792.00- 1,313,858.00- 7,819.48- 1,226,641.41- 93.362 87,216.59- Program number: 6,094,978.00- 7,483,080.00- 751,072.44- 6,451,357.93- 86.213 1,031,722.07- Department number: Revenues 6,094,978.00- 7,483,080.00- 751,072.44- 6,451,357.93- 86.213 1,031,722.07- Revenues Subtotal ----------- 6,094,978.00- 7,483,080.00- 751,072.44- 6,451,357.93- 86.213 1,031,722.07- . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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 19,097.76 145,137.18 90.372 15,462.82 135-50010-010-000 Overtime 13,250.00 13,250.00 4,656.96 18,789.10 141.805 5,539.10- 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 150.00 1,350.00 75.000 450.00 135-50020-010-000 Retirement 25,508.00 25,508.00 3,303.62 23,785.23 93.246 1,722.77 135-50026-010-000 Medical Insurance 22,607.00 22,607.00 1,642.80 18,729.29 82.847 3,877.71 135-50027-010-000 Dental Insurance 2,169.00 2,169.00 125.20 1,384.74 63.842 784.26 135-50028-010-000 Vision Insurance 576.00 576.00 31.76 340.37 59.092 235.63 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 1,457.65 10,190.48 84.921 1,809.52 135-50035-010-000 Medicare Taxes 3,153.00 2,700.00 340.90 2,383.24 88.268 316.76 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 118.64 33.897 231.36 Subtotal: 293,160.00 252,067.00 30,806.65 230,697.27 91.522 21,369.73 135-55005-010-000 Engineering 1,500.00 500.00 500.00 135-55070-010-000 Independent Labor 500.00 135-55080-010-000 Maintenance & Repairs 29,500.00 29,500.00 832.46 16,780.14 56.882 12,719.86 135-55090-010-000 Vehicle Maintenance 3,380.00 3,380.00 39.75 3,760.56 111.259 380.56- 135-55100-010-000 Building Maint & Supplies 750.00 750.00 207.19 3,450.46 460.061 2,700.46- 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 1,070.00 3,215.95 71.466 1,284.05 Subtotal: 43,030.00 41,530.00 2,149.40 27,671.60 66.630 13,858.40 135-60010-010-000 Communications/Pagers/Mobiles 1,599.00 2,100.00 351.13 1,889.95 89.998 210.05 135-60020-010-000 Electricity 162,000.00 100,000.00 20,861.67 88,684.66 88.685 11,315.34 135-60035-010-000 Postage 500.00 688.00 687.40 99.913 .60 135-60050-010-000 Bad Debt Expense 4,200.00 4,200.00 34.41 6,287.23 149.696 2,087.23- 135-60066-010-000 Publications/Books/Subscripts 50.00 85.00 85.00 100.000 135-60070-010-000 Dues & Memberships 150.00 150.00 111.00 74.000 39.00 135-60080-010-000 Schools & Training 2,800.00 2,800.00 111.00 1,193.00 42.607 1,607.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 330.79 1,537.67 48.052 1,662.33 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 Annual Permit Fee 6,600.00 8,000.00 7,965.75 99.572 34.25 135-60150-010-000 Wholesale Water 1,720,000.00 1,720,000.00 452,362.72 1,430,831.78 83.188 289,168.22 135-60245-010-000 Miscellaneous Expenses 1,000.00 500.00 136.97 136.97 27.394 363.03 135-60280-010-000 Property Maintenance 4,200.00 2,200.00 198.50 606.79 27.581 1,593.21 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 550.76 27.538 1,449.24 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 MUD #1 Page 7 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 1,910,799.00 1,848,423.00 474,387.19 1,540,867.95 83.361 307,555.05 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 2,399.52 13,620.84 89.517 1,595.16 135-65010-010-000 Uniforms 3,690.00 3,690.00 214.73 1,615.72 43.786 2,074.28 135-65030-010-000 Chemicals 6,200.00 5,000.00 520.44 3,809.06 76.181 1,190.94 135-65035-010-000 Small Tools 2,500.00 1,500.00 203.00 13.533 1,297.00 135-65040-010-000 Safety Equipment 2,500.00 1,000.00 449.59 44.959 550.41 135-65050-010-000 Meter Expense 85,000.00 100,000.00 4,074.00 97,770.57 97.771 2,229.43 135-65055-010-000 Hardware 1,000.00 1,000.00 1,000.00 135-65085-010-000 Office Supplies 30.00 30.00 100.000 135-65095-010-000 Maintenance Supplies 32,000.00 32,000.00 6,397.74 20,984.05 65.575 11,015.95 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 159,636.00 13,606.43 138,541.33 86.786 21,094.67 135-69005-010-000 Capital Expenses 888,432.00 1,455,600.00 38,475.00 1,343,683.14 92.311 111,916.86 135-69008-010-000 Short Term Debt Payments 421,050.00 382,785.00 417,135.45 99.070 3,914.55 135-69035-010-000 Vehicles 27,000.00 30,215.00 30,213.69 99.996 1.31 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 100,817.00 100,816.54 100.000 .46 135-69295-010-000 Unexpected Maintenance 250.00 250.00 250.00 135-69305-010-000 Capital Leases 11,490.00 10,145.00 10,145.26 100.003 .26- Subtotal: 1,105,943.00 2,072,077.00 38,475.00 382,785.00 1,901,994.08 91.792 170,082.92 Program number: 3,501,238.00 4,373,733.00 38,475.00 903,734.67 3,839,772.23 87.792 533,960.77 Department number: Water 3,501,238.00 4,373,733.00 38,475.00 903,734.67 3,839,772.23 87.792 533,960.77 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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 20,699.20 176,318.34 96.800 5,828.66 135-50010-020-000 Overtime 10,166.00 10,166.00 2,350.96 12,482.77 122.789 2,316.77- 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 125.00 1,200.00 50.000 1,200.00 135-50020-020-000 Retirement 27,816.00 27,816.00 3,202.82 27,468.23 98.750 347.77 135-50026-020-000 Medical Insurance 30,805.00 30,805.00 2,360.69 24,117.87 78.292 6,687.13 135-50027-020-000 Dental Insurance 1,981.00 1,981.00 175.84 1,840.40 92.903 140.60 135-50028-020-000 Vision Insurance 552.00 552.00 45.92 462.42 83.772 89.58 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 1,312.56 11,052.46 97.870 240.54 135-50035-020-000 Medicare Taxes 2,011.00 2,645.00 306.97 2,584.81 97.724 60.19 135-50040-020-000 Unemployment Taxes 567.00 567.00 72.10 531.25 93.695 35.75 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 115.45 57.725 84.55 135-50070-020-000 Employee Relations 350.00 350.00 64.45 18.414 285.55 Subtotal: 274,937.00 278,467.00 30,652.06 264,898.45 95.127 13,568.55 135-55070-020-000 Independent Labor 750.00 32,000.00 16,905.67 52.830 15,094.33 135-55080-020-000 Maintenance & Repairs 17,750.00 43,000.00 6,394.63 43,955.02 102.221 955.02- 135-55090-020-000 Vehicle Maintenance 4,998.00 1,500.00 234.70 15.647 1,265.30 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 322.35 23.025 1,077.65 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 316.73 10.737 2,633.27 135-55125-020-000 Dumpster Services 35,000.00 35,000.00 3,586.33 35,836.33 102.390 836.33- 135-55135-020-000 Lab Analysis 22,760.00 25,000.00 2,762.25 20,816.62 83.266 4,183.38 Subtotal: 85,608.00 140,850.00 12,743.21 118,387.42 84.052 22,462.58 135-60005-020-000 Telephone 100.00 42.08 64.70 64.700 35.30 135-60010-020-000 Communications/Pagers/Mobiles 3,000.00 3,000.00 471.47 2,464.55 82.152 535.45 135-60020-020-000 Electricity 205,000.00 110,000.00 10,491.24 76,216.40 69.288 33,783.60 135-60025-020-000 Water 1,900.00 1,900.00 2.97 1,724.49 90.763 175.51 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 325.00 503.50 38.144 816.50 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 303.03 1,782.11 101.835 32.11- 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 165.00 1,152.36 76.824 347.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 76.02 14.480 448.98 135-60285-020-000 Lawn Equipment & Maintenance 525.00 525.00 83.79 15.960 441.21 Subtotal: 222,540.00 129,140.00 11,800.79 92,956.34 71.981 36,183.66 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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 1,266.45 5,021.23 73.036 1,853.77 135-65010-020-000 Uniforms 3,140.00 3,140.00 615.29 1,734.22 55.230 1,405.78 135-65030-020-000 Chemicals 13,180.00 13,180.00 799.95 7,799.63 59.178 5,380.37 135-65035-020-000 Small Tools 1,260.00 1,260.00 123.73 129.67 10.291 1,130.33 135-65040-020-000 Safety Equipment 925.00 925.00 738.06 841.49 90.972 83.51 135-65045-020-000 Lab Supplies 19,160.00 12,000.00 68.26 7,681.16 64.010 4,318.84 135-65055-020-000 Hardware 525.00 525.00 525.00 135-65085-020-000 Office Supplies 400.00 400.00 61.09 1,029.66 257.415 629.66- 135-65095-020-000 Maintenance Supplies 8,860.00 8,860.00 5,426.70 8,448.97 95.361 411.03 135-65115-020-000 Other Consumables 110.00 110.00 8.69 8.69 7.900 101.31 Subtotal: 54,435.00 47,275.00 9,108.22 32,694.72 69.159 14,580.28 135-69005-020-000 Capital Expenses 161,189.00 111,021.00 750.00 74,962.56 67.521 36,058.44 135-69008-020-000 Short Term Debt Payments 118,731.00 118,730.85 100.000 .15 135-69280-020-000 Capital Repairs 56,000.00 56,000.00 10,180.37 10,180.37 18.179 45,819.63 Subtotal: 217,189.00 285,752.00 10,930.37 203,873.78 71.346 81,878.22 Program number: 854,709.00 881,484.00 75,234.65 712,810.71 80.865 168,673.29 Department number: Wastewater 854,709.00 881,484.00 75,234.65 712,810.71 80.865 168,673.29 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/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 16,849.94 129,296.64 88.875 16,184.36 135-50010-021-000 Overtime 7,297.00 7,297.00 2,180.11 9,850.20 134.990 2,553.20- 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 125.00 1,075.00 71.667 425.00 135-50020-021-000 Retirement 21,074.00 21,074.00 2,647.22 20,403.60 96.819 670.40 135-50026-021-000 Medical Insurance 22,983.00 22,983.00 1,702.68 18,092.76 78.722 4,890.24 135-50027-021-000 Dental Insurance 1,533.00 1,533.00 117.38 1,249.69 81.519 283.31 135-50028-021-000 Vision Insurance 357.00 357.00 29.72 317.19 88.849 39.81 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 1,128.65 8,480.15 86.665 1,304.85 135-50035-021-000 Medicare Taxes 2,288.00 2,288.00 263.95 1,983.25 86.681 304.75 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 25,044.65 197,632.41 89.549 23,064.59 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 15,000.00 4,157.53 27.717 10,842.47 135-55085-021-000 Maintenance-Jet Trailer 330.03 330.03- 135-55090-021-000 Vehicle Maintenance 1,943.00 1,943.00 334.00 848.22 43.655 1,094.78 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 28,093.00 19,393.00 334.00 5,335.78 27.514 14,057.22 135-60005-021-000 Telephone 50.00 7.12 38.74 77.480 11.26 135-60010-021-000 Communications/Pagers/Mobiles 2,796.00 2,796.00 442.11 2,804.38 100.300 8.38- 135-60020-021-000 Electricity 23,625.00 15,000.00 1,419.13 11,047.26 73.648 3,952.74 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 111.00 3.939 2,707.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 93.80 709.89 47.326 790.11 135-60105-021-000 Rent/Lease Equipment 44,107.00 76,098.00 42,076.50 55.293 34,021.50 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 101,267.00 1,962.16 56,787.77 56.077 44,479.23 135-65005-021-000 Fuel & Lube 11,700.00 11,700.00 2,443.40 9,538.08 81.522 2,161.92 135-65010-021-000 Uniforms 2,505.00 2,505.00 832.88 33.249 1,672.12 135-65030-021-000 Chemicals 12,500.00 6,500.00 2,616.00 40.246 3,884.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00 135-65040-021-000 Safety Equipment 1,150.00 1,150.00 61.87 5.380 1,088.13 135-65055-021-000 Hardware 750.00 750.00 44.95 5.993 705.05 135-65095-021-000 Maintenance Supplies 16,050.00 6,050.00 352.64 5.829 5,697.36 Subtotal: 46,155.00 30,155.00 2,443.40 13,446.42 44.591 16,708.58 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- 135-69280-021-000 Capital Repairs 20,000.00 80,000.00 80,000.00 Subtotal: 35,000.00 95,000.00 32,992.25 34.729 62,007.75 Program number: 407,796.00 466,512.00 29,784.21 306,194.63 65.635 160,317.37 Department number: Collection 407,796.00 466,512.00 29,784.21 306,194.63 65.635 160,317.37 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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 2,000.00 8,800.00 88.000 1,200.00 135-50030-026-000 Social Security Taxes 620.00 620.00 124.00 545.60 88.000 74.40 135-50035-026-000 Medicare Taxes 145.00 145.00 29.00 127.60 88.000 17.40 135-50040-026-000 Unemployment Taxes 210.00 210.00 58.00 120.80 57.524 89.20 135-50045-026-000 Workman's Compensation 120.00 120.00 120.00 100.000 Subtotal: 11,095.00 11,095.00 2,211.00 9,714.00 87.553 1,381.00 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 66.00 702.56 54.973 575.44 135-60080-026-000 Schools & Training 4,150.00 4,150.00 890.00 1,989.87 47.949 2,160.13 135-60100-026-000 Travel & per diem 6,199.00 6,199.00 1,784.65 1,816.84 29.309 4,382.16 135-60245-026-000 Miscellaneous Expenses 3,200.00 3,200.00 1,217.69 38.053 1,982.31 Subtotal: 16,977.00 16,977.00 2,740.65 6,438.07 37.922 10,538.93 135-65085-026-000 Office Supplies 50.00 50.00 30.90 61.800 19.10 Subtotal: 50.00 50.00 30.90 61.800 19.10 Program number: 28,122.00 28,122.00 4,951.65 16,182.97 57.546 11,939.03 Department number: Board of Directors 28,122.00 28,122.00 4,951.65 16,182.97 57.546 11,939.03 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 8/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 19,714.28 234,803.88 99.144 2,027.12 135-50010-027-000 Overtime 1,000.00 1,028.00 1,124.91 109.427 96.91- 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,593.92 33,117.71 98.944 353.29 135-50026-027-000 Medical Insurance 18,798.00 18,798.00 1,211.86 15,220.64 80.969 3,577.36 135-50027-027-000 Dental Insurance 1,242.00 1,242.00 98.04 1,199.21 96.555 42.79 135-50028-027-000 Vision Insurance 341.00 341.00 22.96 291.41 85.457 49.59 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,143.28 14,140.69 95.159 719.31 135-50035-027-000 Medicare Taxes 3,475.00 3,475.00 267.39 3,345.00 96.259 130.00 135-50040-027-000 Unemployment Taxes 756.00 756.00 27.41 374.93 49.594 381.07 135-50045-027-000 Workman's Compensation 580.00 580.00 580.00 100.000 135-50060-027-000 Pre-emp Physicals/Testing 53.00 61.48 116.000 8.48- 135-50070-027-000 Employee Relations 5,000.00 5,000.00 4,118.67 82.373 881.33 Subtotal: 319,536.00 319,617.00 25,079.14 312,083.53 97.643 7,533.47 135-55070-027-000 Independent Labor 840.00 840.00 97.50 386.25 45.982 453.75 135-55075-027-000 Records Management 500.00 500.00 500.00 135-55160-027-000 Professional Outside Services 176,870.00 191,093.00 1,875.00 192,967.23 100.981 1,874.23- Subtotal: 178,210.00 192,433.00 1,972.50 193,353.48 100.478 920.48- 135-60005-027-000 Telephone 300.00 300.00 62.44 284.29 94.763 15.71 135-60010-027-000 Communications/Pagers/Mobiles 2,420.00 2,420.00 182.32 1,636.41 67.620 783.59 135-60035-027-000 Postage 2,400.00 204.75 2,096.49 87.354 303.51 135-60066-027-000 Publications/Books/Subscripts 450.00 450.00 371.15 82.478 78.85 135-60070-027-000 Dues & Memberships 1,742.00 1,742.00 38.85 865.90 49.707 876.10 135-60075-027-000 Meetings 312.00 312.00 42.44 13.603 269.56 135-60080-027-000 Schools & Training 2,555.00 2,555.00 1,405.00 54.990 1,150.00 135-60100-027-000 Travel & per diem 3,851.00 3,851.00 1,115.87 28.976 2,735.13 135-60115-027-000 Elections 2,500.00 2,500.00 76.00 2,607.32 104.293 107.32- 135-60125-027-000 Advertising 4,700.00 4,700.00 258.06 5.491 4,441.94 135-60245-027-000 Miscellaneous Expenses 100.00 100.00 136.97 136.97 136.970 36.97- 135-60270-027-000 4th of July Celebration 10,000.00 10,500.00 43.46 10,281.97 97.924 218.03 135-60360-027-000 Furniture/Equipment < $5000 2,225.00 2,225.00 1,616.99 72.674 608.01 Subtotal: 31,155.00 34,055.00 744.79 22,718.86 66.712 11,336.14 135-65085-027-000 Office Supplies 2,450.00 2,450.00 606.39 3,278.02 133.797 828.02- 135-65105-027-000 Printing 515.00 750.00 1,745.08 232.677 995.08- Subtotal: 2,965.00 3,200.00 606.39 5,023.10 156.972 1,823.10- . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 8/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Program number: 531,866.00 549,305.00 28,402.82 533,178.97 97.064 16,126.03 Department number: Manager's Office 531,866.00 549,305.00 28,402.82 533,178.97 97.064 16,126.03 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 8/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 44.41 1,523.13 77.434 443.87 135-50075-028-000 Tuition Reimbursement 1,561.00 1,561.00 219.42 14.056 1,341.58 Subtotal: 3,528.00 3,528.00 44.41 1,742.55 49.392 1,785.45 135-60005-028-000 Telephone 28.00 28.00 28.00 135-60035-028-000 Postage 106.00 106.00 22.23 20.972 83.77 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 165.00 10.577 1,395.00 Subtotal: 3,474.00 3,466.00 187.23 5.402 3,278.77 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 44.41 1,929.78 25.570 5,617.22 Department number: Human Resources 7,555.00 7,547.00 44.41 1,929.78 25.570 5,617.22 . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 8/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 9,003.60 75,055.02 79.504 19,348.98 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 1,244.31 11,101.53 81.557 2,510.47 135-50026-029-000 Medical Insurance 11,060.00 11,060.00 454.22 6,228.80 56.318 4,831.20 135-50027-029-000 Dental Insurance 773.00 773.00 49.02 624.97 80.850 148.03 135-50028-029-000 Vision Insurance 207.00 207.00 6.76 94.43 45.618 112.57 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 531.91 4,519.80 83.918 866.20 135-50035-029-000 Medicare Taxes 1,260.00 1,260.00 80.88 1,013.53 80.439 246.47 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 11,370.70 101,697.40 77.863 28,913.60 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 3.84 70.26 68.214 32.74 135-60010-029-000 Communications/Pagers/Mobiles 683.00 683.00 102.42 563.07 82.441 119.93 135-60035-029-000 Postage 700.00 700.00 26.10 285.74 40.820 414.26 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 95.00 95.00 14.394 565.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 40.00 27.81 69.525 12.19 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,475.00 227.36 1,321.38 20.407 5,153.62 135-65085-029-000 Office Supplies 849.00 849.00 30.07 178.59 21.035 670.41 135-65105-029-000 Printing 515.00 515.00 293.56 293.56 57.002 221.44 Subtotal: 1,364.00 1,364.00 323.63 472.15 34.615 891.85 Program number: 144,910.00 143,450.00 11,921.69 104,596.43 72.915 38,853.57 Department number: Finance 144,910.00 143,450.00 11,921.69 104,596.43 72.915 38,853.57 . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 8/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 9,016.63 68,799.26 107.249 4,650.26- 135-55070-033-000 Independent Labor 1,650.00 1,650.00 483.75 858.75 52.045 791.25 Subtotal: 65,799.00 65,799.00 9,500.38 69,658.01 105.865 3,859.01- 135-60005-033-000 Telephone 6,540.00 6,540.00 1,530.67 8,354.86 127.750 1,814.86- 135-60235-033-000 Security 1,350.00 1,350.00 64.99 747.84 55.396 602.16 Subtotal: 7,890.00 7,890.00 1,595.66 9,102.70 115.370 1,212.70- 135-65055-033-000 Hardware 83,238.00 83,238.00 6,154.56 78,507.52 94.317 4,730.48 135-65085-033-000 Office Supplies 371.00 371.00 338.00 698.00 188.140 327.00- 135-65090-033-000 Printer Supplies & Maintenance 5,732.00 5,732.00 1,042.00 6,744.67 117.667 1,012.67- Subtotal: 89,341.00 89,341.00 7,534.56 85,950.19 96.205 3,390.81 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 519.79 2,837.54 82.248 612.46 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 519.79 2,837.54 9.346 27,523.46 Program number: 193,391.00 193,391.00 19,150.39 167,548.44 86.637 25,842.56 Department number: Information Systems 193,391.00 193,391.00 19,150.39 167,548.44 86.637 25,842.56 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 8/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 46.85 46.85- 135-50040-037-000 Unemployment Taxes 189.00 135-50045-037-000 Workman's Compensation 861.00 861.00 861.00 100.000 135-50060-037-000 Pre-emp Physicals/Testing 250.00 Subtotal: 49,577.00 861.00 907.85 105.441 46.85- 135-55100-037-000 Building Maint & Supplies 5,000.00 20,478.00 1,384.28 6.760 19,093.72 135-55120-037-000 Cleaning Services 25,000.00 3,490.68 18,596.65 74.387 6,403.35 Subtotal: 5,000.00 45,478.00 3,490.68 19,980.93 43.935 25,497.07 135-60020-037-000 Electricity 21,940.00 21,940.00 1,204.48 10,523.81 47.966 11,416.19 135-60025-037-000 Water 1,093.00 1,093.00 345.42 902.82 82.600 190.18 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 12,083.61 91.668 1,098.39 135-60055-037-000 Insurance 32,635.00 32,635.00 450.00 34,080.49 104.429 1,445.49- 135-60360-037-000 Furniture/Equipment < $5000 2,500.00 4,750.00 209.78 209.78 4.416 4,540.22 Subtotal: 71,350.00 73,600.00 3,308.19 57,800.51 78.533 15,799.49 135-65095-037-000 Maintenance Supplies 2,205.00 2,205.00 167.20 1,043.85 47.340 1,161.15 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 80.03 8.003 919.97 Subtotal: 3,205.00 3,205.00 167.20 1,123.88 35.066 2,081.12 Program number: 129,132.00 123,144.00 6,966.07 79,813.17 64.813 43,330.83 Department number: Facilities Maintenance 129,132.00 123,144.00 6,966.07 79,813.17 64.813 43,330.83 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 8/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 11,045.56 77,378.94 91.092 7,567.06 135-50010-038-000 Overtime 2,000.00 2,000.00 25.51 325.59 16.279 1,674.41 135-50016-038-000 Longevity 220.00 220.00 220.00 100.000 135-50020-038-000 Retirement 12,203.00 12,203.00 1,399.44 10,791.84 88.436 1,411.16 135-50026-038-000 Medical Insurance 12,321.00 12,321.00 924.36 9,874.20 80.141 2,446.80 135-50027-038-000 Dental Insurance 1,026.00 1,026.00 91.66 979.74 95.491 46.26 135-50028-038-000 Vision Insurance 260.00 260.00 21.62 231.09 88.881 28.91 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 650.66 4,561.92 84.417 842.08 135-50035-038-000 Medicare Taxes 1,264.00 1,264.00 152.18 1,020.09 80.703 243.91 135-50040-038-000 Unemployment Taxes 473.00 473.00 27.40 244.15 51.617 228.85 135-50045-038-000 Workman's Compensation 211.00 211.00 235.00 111.374 24.00- 135-50060-038-000 Pre-emp Physicals/Testing 35.00 26.47 75.629 8.53 Subtotal: 120,932.00 120,967.00 14,338.39 105,889.03 87.535 15,077.97 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 819.19 9,557.41 86.886 1,442.59 Subtotal: 11,800.00 11,800.00 819.19 9,557.41 80.995 2,242.59 135-60005-038-000 Telephone 100.00 100.00 12.33 68.99 68.990 31.01 135-60010-038-000 Communications/Pagers/Mobiles 472.00 472.00 72.54 398.68 84.466 73.32 135-60035-038-000 Postage 18,000.00 18,000.00 1,245.16 13,961.89 77.566 4,038.11 135-60040-038-000 Service Charges & Fees 18,000.00 29,340.00 2,012.93 21,812.30 74.343 7,527.70 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 25,100.00 25,071.20 99.885 28.80 135-60245-038-000 Miscellaneous Expenses 200.00 200.00 .01 .005 199.99 Subtotal: 60,748.00 74,688.00 3,342.96 61,538.07 82.394 13,149.93 135-65085-038-000 Office Supplies 700.00 700.00 24.70 694.89 99.270 5.11 135-65105-038-000 Printing 3,250.00 3,250.00 3,250.00 Subtotal: 3,950.00 3,950.00 24.70 694.89 17.592 3,255.11 Program number: 197,430.00 211,405.00 18,525.24 177,679.40 84.047 33,725.60 Department number: Utility Billing 197,430.00 211,405.00 18,525.24 177,679.40 84.047 33,725.60 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 19:41 09/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/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 88,000.00 2,765.46 74,242.25 84.366 13,757.75 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 13,615.43 68.077 6,384.57 135-55065-039-000 Tax Admin Fees 3,629.00 3,629.00 73.13 2,543.22 70.080 1,085.78 Subtotal: 98,829.00 131,829.00 2,838.59 110,600.90 83.897 21,228.10 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 134,107.00 2,838.59 112,878.75 84.171 21,228.25 Department number: Non Departmental 98,829.00 134,107.00 2,838.59 112,878.75 84.171 21,228.25 Expenditures Subtotal ----------- 6,094,978.00 7,112,200.00 38,475.00 1,101,554.39 6,052,585.48 85.101 1,059,614.52 Fund number: 135 MUD 1 General Fund 370,880.00- 38,475.00 350,481.95 398,772.45- 107.521 27,892.45 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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 1633 08/01/2012 Property Tax/Assessment (96,793.59) (8.06) (96,801.65) GL 1635 08/02/2012 Property Tax/Assessments (6.64) (96,808.29) GL 1636 08/03/2012 Property Tax/Assessments (2.86) (96,811.15) GL 1637 08/06/2012 Property Tax/Assessments (20.62) (96,831.77) GL 1639 08/08/2012 Property Tax/Assessments 18.95 (96,812.82) GL 1640 08/09/2012 Property Tax/Assessments (5.66) (96,818.48) GL 1641 08/17/2012 Property Tax/Assessments (23.64) (96,842.12) GL 1642 08/30/2012 Property Tax/Assessments (310.90) (97,153.02) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (359.43) (97,153.02) ** (97,495.00) Budgeted (341.98) Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1633 08/01/2012 Property Tax/Assessment 560.19 (75.47) 484.72 GL 1638 08/07/2012 Property Tax/Assessments 75.47 560.19 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: .00 560.19 ** (451.00) Budgeted (1,011.19) Remaining ########## Account: 135-40015-000-000 Property Taxes/P & I 1633 08/01/2012 Property Tax/Assessment (167.03) (34.90) (201.93) GL 1635 08/02/2012 Property Tax/Assessments (1.19) (203.12) GL 1636 08/03/2012 Property Tax/Assessments (.20) (203.32) GL 1638 08/07/2012 Property Tax/Assessments 34.90 (168.42) GL 1640 08/09/2012 Property Tax/Assessments (1.07) (169.49) GL 1641 08/17/2012 Property Tax/Assessments (4.49) (173.98) GL 1642 08/30/2012 Property Tax/Assessments (59.06) (233.04) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (66.01) (233.04) ** (200.00) Budgeted 33.04 Remaining 117 % Used Account: 135-43215-000-000 Insurance Settlement (3,999.00) .00 (3,999.00) _______________ Account: 135-43215-000-000 Insurance Settlement Totals: .00 (3,999.00) ** (3,999.00) Budgeted .00 Remaining 100 % Used Account: 135-47000-000-000 Water . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1623 08/31/2012 UB 8/31/12 Billing UB20120831-20120831 User: (1,359,165.69) (278,319.45) (1,637,485.14) UB _______________ Account: 135-47000-000-000 Water Totals: (278,319.45) (1,637,485.14) ** (1,990,800.00) Budgeted (353,314.86) Remaining 82 % Used Account: 135-47005-000-000 Sewer 1623 08/31/2012 UB 8/31/12 Billing UB20120831-20120831 User: (838,438.79) (110,602.53) (949,041.32) UB _______________ Account: 135-47005-000-000 Sewer Totals: (110,602.53) (949,041.32) ** (1,325,000.00) Budgeted (375,958.68) Remaining 72 % Used Account: 135-47010-000-000 Commercial Water 1615 08/30/2012 UB 8/30/12 Adjustments UB20120830-20120830 User: (608,661.53) 306.75 (608,354.78) UB 1623 08/31/2012 UB 8/31/12 Billing UB20120831-20120831 User: (131,605.05) (739,959.83) UB _______________ Account: 135-47010-000-000 Commercial Water Totals: (131,298.30) (739,959.83) ** (825,000.00) Budgeted (85,040.17) Remaining 90 % Used Account: 135-47015-000-000 Commercial Sewer 1615 08/30/2012 UB 8/30/12 Adjustments UB20120830-20120830 User: (232,273.58) 63.35 (232,210.23) UB 1623 08/31/2012 UB 8/31/12 Billing UB20120831-20120831 User: (32,516.14) (264,726.37) UB _______________ Account: 135-47015-000-000 Commercial Sewer Totals: (32,452.79) (264,726.37) ** (360,000.00) Budgeted (95,273.63) Remaining 74 % Used Account: 135-47020-000-000 Standby 1623 08/31/2012 UB 8/31/12 Billing UB20120831-20120831 User: (583.35) (60.00) (643.35) UB _______________ Account: 135-47020-000-000 Standby Totals: (60.00) (643.35) ** (775.00) Budgeted (131.65) Remaining 83 % Used Account: 135-47025-000-000 Penalties 1437 08/01/2012 UB 08/01/2012 Adjustments UB20120801-20120801 User: (44,927.32) 46.66 (44,880.66) UB 1569 08/21/2012 UB 8/21/12 Penalties UB20120821-20120821 User: (5,510.96) (50,391.62) UB 1572 08/21/2012 UB 8/21/12 Adjustments UB20120821-20120821 User: (36.76) (50,428.38) UB 1615 08/30/2012 UB 8/30/12 Adjustments UB20120830-20120830 User: 373.64 (50,054.74) UB 1623 08/31/2012 UB 8/31/12 Billing UB20120831-20120831 User: (333.22) (50,387.96) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-47025-000-000 Penalties Totals: (5,460.64) (50,387.96) ** (45,000.00) Budgeted 5,387.96 Remaining 112 % Used Account: 135-47030-000-000 Service Charges 1509 08/08/2012 UB 8/8/12 Disconnect Fees UB20120808-20120808 User: (9,507.48) (625.00) (10,132.48) UB 1610 08/22/2012 UB 8/22/12 Adjustment UB20120822-20120822 User: (25.00) (10,157.48) UB 1623 08/31/2012 UB 8/31/12 Billing UB20120831-20120831 User: (3.00) (10,160.48) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (653.00) (10,160.48) ** (15,000.00) Budgeted (4,839.52) Remaining 68 % Used Account: 135-47035-000-000 Plumbing Inspections 1655 08/22/2012 Permits 8/22/12 (1,800.00) (50.00) (1,850.00) GL 1656 08/23/2012 Permits 8/23/12 (50.00) (1,900.00) GL 1657 08/24/2012 Permits 8/24/12 (100.00) (2,000.00) GL _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (200.00) (2,000.00) ** (1,500.00) Budgeted 500.00 Remaining 133 % Used Account: 135-47045-000-000 Sewer Inspections 1655 08/22/2012 Permits 8/22/12 (5,400.00) (150.00) (5,550.00) GL 1656 08/23/2012 Permits 8/23/12 (150.00) (5,700.00) GL 1657 08/24/2012 Permits 8/24/12 (300.00) (6,000.00) GL _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (600.00) (6,000.00) ** (4,500.00) Budgeted 1,500.00 Remaining 133 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1665 08/31/2012 TCCC July Effluent (41,027.49) (15,464.80) (56,492.29) GL _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (15,464.80) (56,492.29) ** (75,000.00) Budgeted (18,507.71) Remaining 75 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 1623 08/31/2012 UB 8/31/12 Billing UB20120831-20120831 User: (32,998.36) (2,100.19) (35,098.55) UB _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: (2,100.19) (35,098.55) ** (41,595.00) Budgeted (6,496.45) Remaining 84 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-47405-000-000 Out of District Sewer 1623 08/31/2012 UB 8/31/12 Billing UB20120831-20120831 User: (9,720.06) (1,345.59) (11,065.65) UB _______________ Account: 135-47405-000-000 Out of District Sewer Totals: (1,345.59) (11,065.65) ** (11,807.00) Budgeted (741.35) Remaining 94 % Used Account: 135-47410-000-000 Out of Dist/Portable Penalties 1569 08/21/2012 UB 8/21/12 Penalties UB20120821-20120821 User: (41.45) (15.32) (56.77) UB _______________ Account: 135-47410-000-000 Out of Dist/Portable Penalties Totals: (15.32) (56.77) ** (100.00) Budgeted (43.23) Remaining 57 % Used Account: 135-47600-000-000 PID #1 Water 1623 08/31/2012 UB 8/31/12 Billing UB20120831-20120831 User: (434,464.03) (102,186.58) (536,650.61) UB _______________ Account: 135-47600-000-000 PID #1 Water Totals: (102,186.58) (536,650.61) ** (500,000.00) Budgeted 36,650.61 Remaining 107 % Used Account: 135-47605-000-000 PID #1 Sewer 1623 08/31/2012 UB 8/31/12 Billing UB20120831-20120831 User: (211,575.00) (34,468.33) (246,043.33) UB _______________ Account: 135-47605-000-000 PID #1 Sewer Totals: (34,468.33) (246,043.33) ** (250,000.00) Budgeted (3,956.67) Remaining 98 % Used Account: 135-48005-000-000 Utility Fees 1544 08/01/2012 Permits 8/1/12 (550,480.00) (2,300.00) (552,780.00) GL 1545 08/02/2012 Permits 8/2/12 (2,300.00) (555,080.00) GL 1546 08/03/2012 Permits 8/3/12 (2,300.00) (557,380.00) GL 1547 08/07/2012 Permits 8/7/12 (2,300.00) (559,680.00) GL 1652 08/13/2012 Permits 8/13/12 (2,300.00) (561,980.00) GL 1653 08/15/2012 Permits 8/15/12 (6,900.00) (568,880.00) GL 1654 08/21/2012 Permits 8/21/12 (2,300.00) (571,180.00) GL 1657 08/24/2012 Permits 8/24/12 (2,300.00) (573,480.00) GL 1658 08/27/2012 Permits 8/27/12 (2,300.00) (575,780.00) GL 1659 08/28/2012 Permits 8/28/12 (2,300.00) (578,080.00) GL _______________ Account: 135-48005-000-000 Utility Fees Totals: (27,600.00) (578,080.00) ** (621,000.00) Budgeted (42,920.00) Remaining 93 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-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 1626 08/31/2012 August Bank Interest (4,541.52) (217.25) (4,758.77) GL 1626 08/31/2012 August Bank Interest (388.90) (5,147.67) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (606.15) (5,147.67) ** (4,500.00) Budgeted 647.67 Remaining 114 % Used Account: 135-49016-000-000 Cell Tower Revenue 1663 08/22/2012 AT&T Antenna Lease (8,470.00) (847.00) (9,317.00) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (847.00) (9,317.00) ** (10,164.00) Budgeted (847.00) Remaining 92 % Used Account: 135-49018-000-000 Building Rent Income 1664 08/22/2012 Town/July postage/Maint Barn (5,833.30) (583.33) (6,416.63) GL _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (6,416.63) ** (7,000.00) Budgeted (583.37) Remaining 92 % Used Account: 135-49025-000-000 Auction Sales (4,305.00) .00 (4,305.00) _______________ Account: 135-49025-000-000 Auction Sales Totals: .00 (4,305.00) ** (4,305.00) Budgeted .00 Remaining 100 % Used Account: 135-49030-000-000 Vending Revenue 1661 08/07/2012 Vending (439.24) (111.00) (550.24) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (111.00) (550.24) ** (600.00) Budgeted (49.76) Remaining 92 % Used Account: 135-49036-000-000 GASB Reserves . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 8/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-49036-000-000 GASB Reserves Totals: .00 .00 ** (103,966.00) Budgeted (103,966.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1544 08/01/2012 Permits 8/1/12 (89,691.05) (292.00) (89,983.05) GL 1545 08/02/2012 Permits 8/2/12 (292.00) (90,275.05) GL 1546 08/03/2012 Permits 8/3/12 (292.00) (90,567.05) GL 1547 08/07/2012 Permits 8/7/12 (292.00) (90,859.05) GL 1652 08/13/2012 Permits 8/13/12 (292.00) (91,151.05) GL 1653 08/15/2012 Permits 8/15/12 (876.00) (92,027.05) GL 1654 08/21/2012 Permits 8/21/12 (292.00) (92,319.05) GL 1655 08/22/2012 Permits 8/22/12 (292.00) (92,611.05) GL 1656 08/23/2012 Permits 8/23/12 (292.00) (92,903.05) GL 1657 08/24/2012 Permits 8/24/12 (876.00) (93,779.05) GL 1658 08/27/2012 Permits 8/27/12 (292.00) (94,071.05) GL 1659 08/28/2012 Permits 8/28/12 (292.00) (94,363.05) GL _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (4,672.00) (94,363.05) ** (77,800.00) Budgeted 16,563.05 Remaining 121 % Used Account: 135-49900-000-000 Miscellaneous Income 1662 08/07/2012 KenRan Plumb-Repair 8" SW Main (5,418.82) (1,000.00) (6,418.82) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (1,000.00) (6,418.82) ** (5,400.00) Budgeted 1,018.82 Remaining 119 % 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) ** (123.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (6,451,357.93) ** (7,483,080.00) Budgeted (1,031,722.07) Remaining 86 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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 1634 08/03/2012 8/3/12 Payroll 126,039.42 6,344.47 132,383.89 GL 1646 08/17/2012 8/17/12 Payroll 6,356.88 138,740.77 GL 1660 08/31/2012 8/31/12 Payroll 6,396.41 145,137.18 GL _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 19,097.76 145,137.18 ** 160,600.00 Budgeted 15,462.82 Remaining 90 % Used Account: 135-50010-010-000 Overtime 1634 08/03/2012 8/3/12 Payroll 14,132.14 1,560.24 15,692.38 GL 1634 08/03/2012 8/3/12 Payroll 160.00 15,852.38 GL 1646 08/17/2012 8/17/12 Payroll 1,144.24 16,996.62 GL 1646 08/17/2012 8/17/12 Payroll 80.00 17,076.62 GL 1660 08/31/2012 8/31/12 Payroll 1,632.48 18,709.10 GL 1660 08/31/2012 8/31/12 Payroll 80.00 18,789.10 GL _______________ Account: 135-50010-010-000 Overtime Totals: 4,656.96 18,789.10 ** 13,250.00 Budgeted (5,539.10) Remaining 142 % 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 1646 08/17/2012 8/17/12 Payroll 1,200.00 150.00 1,350.00 GL _______________ Account: 135-50017-010-000 Certification Totals: 150.00 1,350.00 ** 1,800.00 Budgeted 450.00 Remaining 75 % Used Account: 135-50020-010-000 Retirement 1634 08/03/2012 8/3/12 Payroll 20,481.61 1,114.54 21,596.15 GL 1646 08/17/2012 8/17/12 Payroll 1,068.44 22,664.59 GL 1660 08/31/2012 8/31/12 Payroll 1,120.64 23,785.23 GL _______________ Account: 135-50020-010-000 Retirement Totals: 3,303.62 23,785.23 ** 25,508.00 Budgeted 1,722.77 Remaining 93 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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 1634 08/03/2012 8/3/12 Payroll 17,086.49 821.40 17,907.89 GL 1646 08/17/2012 8/17/12 Payroll 821.40 18,729.29 GL _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,642.80 18,729.29 ** 22,607.00 Budgeted 3,877.71 Remaining 83 % Used Account: 135-50027-010-000 Dental Insurance 1634 08/03/2012 8/3/12 Payroll 1,259.54 62.60 1,322.14 GL 1646 08/17/2012 8/17/12 Payroll 62.60 1,384.74 GL _______________ Account: 135-50027-010-000 Dental Insurance Totals: 125.20 1,384.74 ** 2,169.00 Budgeted 784.26 Remaining 64 % Used Account: 135-50028-010-000 Vision Insurance 1634 08/03/2012 8/3/12 Payroll 308.61 15.88 324.49 GL 1646 08/17/2012 8/17/12 Payroll 15.88 340.37 GL _______________ Account: 135-50028-010-000 Vision Insurance Totals: 31.76 340.37 ** 576.00 Budgeted 235.63 Remaining 59 % 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 1634 08/03/2012 8/3/12 Payroll 8,732.83 487.79 9,220.62 GL 1646 08/17/2012 8/17/12 Payroll 467.11 9,687.73 GL 1660 08/31/2012 8/31/12 Payroll 502.75 10,190.48 GL _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,457.65 10,190.48 ** 12,000.00 Budgeted 1,809.52 Remaining 85 % Used Account: 135-50035-010-000 Medicare Taxes 1634 08/03/2012 8/3/12 Payroll 2,042.34 114.08 2,156.42 GL 1646 08/17/2012 8/17/12 Payroll 109.24 2,265.66 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1660 08/31/2012 8/31/12 Payroll 2,042.34 117.58 2,383.24 GL _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 340.90 2,383.24 ** 2,700.00 Budgeted 316.76 Remaining 88 % Used 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 118.64 .00 118.64 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 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 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1531 08/14/2012 Aug A/P July PCards/McMahon 15,947.68 758.67 16,706.35 JPMORGAN CHASE BANK NA 31708 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1531 08/14/2012 Aug A/P July PCards/McMahon 15,947.68 72.12 16,778.47 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Womack 1.67 16,780.14 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 832.46 16,780.14 ** 29,500.00 Budgeted 12,719.86 Remaining 57 % Used Account: 135-55090-010-000 Vehicle Maintenance 1531 08/14/2012 Aug A/P July PCards/McMahon 3,720.81 39.75 3,760.56 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 39.75 3,760.56 ** 3,380.00 Budgeted (380.56) Remaining 111 % Used Account: 135-55100-010-000 Building Maint & Supplies 1531 08/14/2012 Aug A/P July PCard/Womack 3,243.27 207.19 3,450.46 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-55100-010-000 Building Maint & Supplies Totals: 207.19 3,450.46 ** 750.00 Budgeted (2,700.46) Remaining 460 % 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 1495 08/06/2012 July A/P Lab analysis 2,145.95 785.00 2,930.95 LOWER COLORADO RIVER AUTHORITY 31686 AP 1531 08/14/2012 Aug A/P Bac T samples 285.00 3,215.95 TARRANT CTY PUBLIC HEALTH LAB 31716 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 1,070.00 3,215.95 ** 4,500.00 Budgeted 1,284.05 Remaining 71 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1495 08/06/2012 July A/P Cells 1,538.82 176.23 1,715.05 VERIZON WIRELESS 31698 AP 1693 08/31/2012 Aug A/P Wireless voice/data phones 174.90 1,889.95 VERIZON WIRELESS 31777 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 351.13 1,889.95 ** 2,100.00 Budgeted 210.05 Remaining 90 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-60020-010-000 Electricity 1541 08/16/2012 Aug A/P Electricity 7/13-8/13 Bobcat E 67,822.99 191.85 68,014.84 HUDSON ENERGY 31707 AP 1573 08/22/2012 Aug A/P Electricity 7/16-8/14 19,826.23 87,841.07 HUDSON ENERGY 31726 AP 1573 08/22/2012 Aug A/P Electricity 7/16-8/14 843.59 88,684.66 HUDSON ENERGY 31726 AP _______________ Account: 135-60020-010-000 Electricity Totals: 20,861.67 88,684.66 ** 100,000.00 Budgeted 11,315.34 Remaining 89 % Used Account: 135-60035-010-000 Postage 687.40 .00 687.40 _______________ Account: 135-60035-010-000 Postage Totals: .00 687.40 ** 688.00 Budgeted .60 Remaining 100 % Used Account: 135-60050-010-000 Bad Debt Expense 1495 08/06/2012 July A/P Collection fee 6,252.82 34.41 6,287.23 AMERICAN MUNICIPAL SERVICES 31670 AP _______________ Account: 135-60050-010-000 Bad Debt Expense Totals: 34.41 6,287.23 ** 4,200.00 Budgeted (2,087.23) Remaining 150 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 85.00 .00 85.00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 85.00 ** 85.00 Budgeted .00 Remaining 100 % Used Account: 135-60070-010-000 Dues & Memberships 111.00 .00 111.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 111.00 ** 150.00 Budgeted 39.00 Remaining 74 % Used Account: 135-60080-010-000 Schools & Training 1676 08/31/2012 August A/P Reimburse Class/Backflow Prev 1,082.00 111.00 1,193.00 BERT COOPER 31745 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 111.00 1,193.00 ** 2,800.00 Budgeted 1,607.00 Remaining 43 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-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 1634 08/03/2012 8/3/12 Payroll 1,206.88 70.49 1,277.37 GL 1646 08/17/2012 8/17/12 Payroll 111.56 1,388.93 GL 1660 08/31/2012 8/31/12 Payroll 148.74 1,537.67 GL _______________ Account: 135-60100-010-000 Travel & per diem Totals: 330.79 1,537.67 ** 3,200.00 Budgeted 1,662.33 Remaining 48 % 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 ** 8,000.00 Budgeted 34.25 Remaining 100 % Used Account: 135-60150-010-000 Wholesale Water 1495 08/06/2012 July A/P Wholesale Water-June 978,469.06 171,701.97 1,150,171.03 CITY OF FORT WORTH 31676 AP 1676 08/31/2012 August A/P July Wholesale Water 280,660.75 1,430,831.78 CITY OF FORT WORTH 31748 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 452,362.72 1,430,831.78 ** 1,720,000.00 Budgeted 289,168.22 Remaining 83 % Used Account: 135-60245-010-000 Miscellaneous Expenses 1495 08/06/2012 July A/P Pcards-Zieverink 15.99 15.99 BANK OF AMERICA 31672 AP 1495 08/06/2012 July A/P Pcards-Zieverink 120.98 136.97 BANK OF AMERICA 31672 AP _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: 136.97 136.97 ** 500.00 Budgeted 363.03 Remaining 27 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-60280-010-000 Property Maintenance 1531 08/14/2012 Aug A/P July PCards/McMahon 408.29 54.50 462.79 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Womack 144.00 606.79 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-60280-010-000 Property Maintenance Totals: 198.50 606.79 ** 2,200.00 Budgeted 1,593.21 Remaining 28 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 550.76 .00 550.76 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 550.76 ** 2,000.00 Budgeted 1,449.24 Remaining 28 % 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 1624 08/01/2012 July Gas Log 11,221.32 1,140.22 12,361.54 GL 1697 08/31/2012 August Gas Log 1,259.30 13,620.84 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 2,399.52 13,620.84 ** 15,216.00 Budgeted 1,595.16 Remaining 90 % Used Account: 135-65010-010-000 Uniforms 1531 08/14/2012 Aug A/P July PCard/Slaght 1,400.99 214.73 1,615.72 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-65010-010-000 Uniforms Totals: 214.73 1,615.72 ** 3,690.00 Budgeted 2,074.28 Remaining 44 % Used Account: 135-65030-010-000 Chemicals 1531 08/14/2012 Aug A/P July PCard/Womack 3,288.62 520.44 3,809.06 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 520.44 3,809.06 ** 5,000.00 Budgeted 1,190.94 Remaining 76 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-65035-010-000 Small Tools 203.00 .00 203.00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 203.00 ** 1,500.00 Budgeted 1,297.00 Remaining 14 % Used Account: 135-65040-010-000 Safety Equipment 449.59 .00 449.59 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 449.59 ** 1,000.00 Budgeted 550.41 Remaining 45 % Used Account: 135-65050-010-000 Meter Expense 1531 08/14/2012 Aug A/P July PCard/Womack 93,696.57 1,322.00 95,018.57 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Womack 789.00 95,807.57 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Womack 488.00 96,295.57 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Womack 1,475.00 97,770.57 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 4,074.00 97,770.57 ** 100,000.00 Budgeted 2,229.43 Remaining 98 % 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 30.00 .00 30.00 _______________ Account: 135-65085-010-000 Office Supplies Totals: .00 30.00 ** 30.00 Budgeted .00 Remaining 100 % Used Account: 135-65095-010-000 Maintenance Supplies 1531 08/14/2012 Aug A/P July purchases 14,586.31 47.31 14,633.62 COSTCO WHOLESALE 31701 AP 1531 08/14/2012 Aug A/P July purchases 103.53 14,737.15 COSTCO WHOLESALE 31701 AP 1531 08/14/2012 Aug A/P July PCards/Beck 436.74 15,173.89 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Womack 384.28 15,558.17 JPMORGAN CHASE BANK NA 31708 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1531 08/14/2012 Aug A/P July PCard/Womack 14,586.31 6.39 15,564.56 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Womack 785.90 16,350.46 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Womack 91.50 16,441.96 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Womack 739.80 17,181.76 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Womack 2,126.49 19,308.25 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Womack 1,675.80 20,984.05 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-65095-010-000 Maintenance Supplies Totals: 6,397.74 20,984.05 ** 32,000.00 Budgeted 11,015.95 Remaining 66 % 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,305,208.14 .00 1,305,208.14 _______________ Account: 135-69005-010-000 Capital Expenses Totals: .00 1,305,208.14 ** 1,455,600.00 Budgeted 150,391.86 Remaining 90 % Used Account: 135-69008-010-000 Short Term Debt Payments 1573 08/22/2012 Aug A/P Ground Storage loan payment 34,350.45 382,785.00 417,135.45 FIRST FINANCIAL BANK 31725 AP _______________ Account: 135-69008-010-000 Short Term Debt Payments Totals: 382,785.00 417,135.45 ** 421,050.00 Budgeted 3,914.55 Remaining 99 % Used Account: 135-69035-010-000 Vehicles 30,213.69 .00 30,213.69 _______________ Account: 135-69035-010-000 Vehicles Totals: .00 30,213.69 ** 30,215.00 Budgeted 1.31 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 8/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-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 ** 100,817.00 Budgeted .46 Remaining 100 % 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 ** 10,145.00 Budgeted (.26) Remaining 100 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 3,801,297.23 ** 4,373,733.00 Budgeted 572,435.77 Remaining 87 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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 1634 08/03/2012 8/3/12 Payroll 155,619.14 6,926.40 162,545.54 GL 1646 08/17/2012 8/17/12 Payroll 6,846.40 169,391.94 GL 1660 08/31/2012 8/31/12 Payroll 6,926.40 176,318.34 GL _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 20,699.20 176,318.34 ** 182,147.00 Budgeted 5,828.66 Remaining 97 % Used Account: 135-50010-020-000 Overtime 1634 08/03/2012 8/3/12 Payroll 10,131.81 597.98 10,729.79 GL 1634 08/03/2012 8/3/12 Payroll 80.00 10,809.79 GL 1646 08/17/2012 8/17/12 Payroll 879.66 11,689.45 GL 1646 08/17/2012 8/17/12 Payroll 160.00 11,849.45 GL 1660 08/31/2012 8/31/12 Payroll 553.32 12,402.77 GL 1660 08/31/2012 8/31/12 Payroll 80.00 12,482.77 GL _______________ Account: 135-50010-020-000 Overtime Totals: 2,350.96 12,482.77 ** 10,166.00 Budgeted (2,316.77) Remaining 123 % 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 1646 08/17/2012 8/17/12 Payroll 1,075.00 125.00 1,200.00 GL _______________ Account: 135-50017-020-000 Certification Totals: 125.00 1,200.00 ** 2,400.00 Budgeted 1,200.00 Remaining 50 % Used Account: 135-50020-020-000 Retirement 1634 08/03/2012 8/3/12 Payroll 24,265.41 1,050.92 25,316.33 GL 1646 08/17/2012 8/17/12 Payroll 1,107.14 26,423.47 GL 1660 08/31/2012 8/31/12 Payroll 1,044.76 27,468.23 GL _______________ Account: 135-50020-020-000 Retirement Totals: 3,202.82 27,468.23 ** 27,816.00 Budgeted 347.77 Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-020-000 Medical Insurance 1634 08/03/2012 8/3/12 Payroll 21,757.18 1,180.35 22,937.53 GL 1646 08/17/2012 8/17/12 Payroll 1,180.34 24,117.87 GL _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,360.69 24,117.87 ** 30,805.00 Budgeted 6,687.13 Remaining 78 % Used Account: 135-50027-020-000 Dental Insurance 1634 08/03/2012 8/3/12 Payroll 1,664.56 87.92 1,752.48 GL 1646 08/17/2012 8/17/12 Payroll 87.92 1,840.40 GL _______________ Account: 135-50027-020-000 Dental Insurance Totals: 175.84 1,840.40 ** 1,981.00 Budgeted 140.60 Remaining 93 % Used Account: 135-50028-020-000 Vision Insurance 1634 08/03/2012 8/3/12 Payroll 416.50 22.96 439.46 GL 1646 08/17/2012 8/17/12 Payroll 22.96 462.42 GL _______________ Account: 135-50028-020-000 Vision Insurance Totals: 45.92 462.42 ** 552.00 Budgeted 89.58 Remaining 84 % 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 1634 08/03/2012 8/3/12 Payroll 9,739.90 409.32 10,149.22 GL 1646 08/17/2012 8/17/12 Payroll 434.54 10,583.76 GL 1660 08/31/2012 8/31/12 Payroll 468.70 11,052.46 GL _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,312.56 11,052.46 ** 11,293.00 Budgeted 240.54 Remaining 98 % Used Account: 135-50035-020-000 Medicare Taxes 1634 08/03/2012 8/3/12 Payroll 2,277.84 95.72 2,373.56 GL 1646 08/17/2012 8/17/12 Payroll 101.63 2,475.19 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1660 08/31/2012 8/31/12 Payroll 2,277.84 109.62 2,584.81 GL _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 306.97 2,584.81 ** 2,645.00 Budgeted 60.19 Remaining 98 % Used Account: 135-50040-020-000 Unemployment Taxes 1634 08/03/2012 8/3/12 Payroll 459.15 62.97 522.12 GL 1646 08/17/2012 8/17/12 Payroll 9.13 531.25 GL _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 72.10 531.25 ** 567.00 Budgeted 35.75 Remaining 94 % 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 115.45 .00 115.45 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 115.45 ** 200.00 Budgeted 84.55 Remaining 58 % 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 16,905.67 .00 16,905.67 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 16,905.67 ** 32,000.00 Budgeted 15,094.33 Remaining 53 % Used Account: 135-55080-020-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1531 08/14/2012 Aug A/P July PCards/Richey 37,560.39 109.94 37,670.33 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 481.12 38,151.45 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 263.50 38,414.95 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 729.00 39,143.95 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 505.12 39,649.07 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 97.48 39,746.55 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 1,232.60 40,979.15 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 12.68 40,991.83 JPMORGAN CHASE BANK NA 31708 AP 1573 08/22/2012 Aug A/P pipe, reducer bushing 487.89 41,479.72 LONGHORN 31729 AP 1573 08/22/2012 Aug A/P Reducer Bushing 6.65 41,486.37 LONGHORN 31729 AP 1573 08/22/2012 Aug A/P Reducer Bushing 6.65 41,493.02 LONGHORN 31729 AP 1573 08/22/2012 Aug A/P Pulled pump and installed rent 889.00 42,382.02 XYLEM WATER SOLUTIONS USA INC 31737 AP 1686 08/31/2012 Aug A/P UV repair 1,573.00 43,955.02 NEWMAN REGENCY GROUP, INC 31762 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 6,394.63 43,955.02 ** 43,000.00 Budgeted (955.02) Remaining 102 % Used Account: 135-55090-020-000 Vehicle Maintenance 234.70 .00 234.70 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 234.70 ** 1,500.00 Budgeted 1,265.30 Remaining 16 % Used Account: 135-55100-020-000 Building Maint & Supplies 322.35 .00 322.35 _______________ Account: 135-55100-020-000 Building Maint & Supplies Totals: .00 322.35 ** 1,400.00 Budgeted 1,077.65 Remaining 23 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 316.73 .00 316.73 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 316.73 ** 2,950.00 Budgeted 2,633.27 Remaining 11 % Used Account: 135-55125-020-000 Dumpster Services 1495 08/06/2012 July A/P Sludge haul off 32,250.00 1,653.83 33,903.83 CHANEY ENVIRONMENTAL 31675 AP 1573 08/22/2012 Aug A/P Sludge haul off 966.25 34,870.08 CHANEY ENVIRONMENTAL 31724 AP 1686 08/31/2012 Aug A/P Sludge Haul off 966.25 35,836.33 CHANEY ENVIRONMENTAL 31747 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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: 3,586.33 35,836.33 ** 35,000.00 Budgeted (836.33) Remaining 102 % Used Account: 135-55135-020-000 Lab Analysis 1531 08/14/2012 Aug A/P Wet chem analysis 18,054.37 1,682.25 19,736.62 TALEM, INC 31714 AP 1573 08/22/2012 Aug A/P Biomonitoring Project 1,080.00 20,816.62 HUTHER AND ASSOCIATES,INC 31727 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,762.25 20,816.62 ** 25,000.00 Budgeted 4,183.38 Remaining 83 % Used Account: 135-60005-020-000 Telephone 1495 08/06/2012 July A/P Pcards-Zieverink 22.62 7.37 29.99 BANK OF AMERICA 31672 AP 1676 08/31/2012 August A/P PCards/Zieverink 34.71 64.70 BANK OF AMERICA 31744 AP _______________ Account: 135-60005-020-000 Telephone Totals: 42.08 64.70 ** 100.00 Budgeted 35.30 Remaining 65 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 1495 08/06/2012 July A/P Cells 1,993.08 236.80 2,229.88 VERIZON WIRELESS 31698 AP 1693 08/31/2012 Aug A/P Wireless voice/data phones 234.67 2,464.55 VERIZON WIRELESS 31777 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 471.47 2,464.55 ** 3,000.00 Budgeted 535.45 Remaining 82 % Used Account: 135-60020-020-000 Electricity 1573 08/22/2012 Aug A/P Electricity 7/16-8/14 65,725.16 10,491.24 76,216.40 HUDSON ENERGY 31726 AP _______________ Account: 135-60020-020-000 Electricity Totals: 10,491.24 76,216.40 ** 110,000.00 Budgeted 33,783.60 Remaining 69 % Used Account: 135-60025-020-000 Water 1531 08/14/2012 Aug A/P July PCards/Schlielig 1,721.52 2.97 1,724.49 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-60025-020-000 Water Totals: 2.97 1,724.49 ** 1,900.00 Budgeted 175.51 Remaining 91 % Used Account: 135-60035-020-000 Postage . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-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 1531 08/14/2012 Aug A/P July PCards/Schlielig 178.50 325.00 503.50 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-60080-020-000 Schools & Training Totals: 325.00 503.50 ** 1,320.00 Budgeted 816.50 Remaining 38 % 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 1634 08/03/2012 8/3/12 Payroll 1,479.08 93.24 1,572.32 GL 1646 08/17/2012 8/17/12 Payroll 163.17 1,735.49 GL 1660 08/31/2012 8/31/12 Payroll 46.62 1,782.11 GL _______________ Account: 135-60100-020-000 Travel & per diem Totals: 303.03 1,782.11 ** 1,750.00 Budgeted (32.11) Remaining 102 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1541 08/16/2012 Aug A/P Ad for WW Superintendent posit 987.36 165.00 1,152.36 TX WATER UTILITIES ASSOC 31720 AP _______________ Account: 135-60125-020-000 Advertising Totals: 165.00 1,152.36 ** 1,500.00 Budgeted 347.64 Remaining 77 % 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 76.02 .00 76.02 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 76.02 ** 525.00 Budgeted 448.98 Remaining 14 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 83.79 .00 83.79 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 83.79 ** 525.00 Budgeted 441.21 Remaining 16 % Used Account: 135-65005-020-000 Fuel & Lube 1624 08/01/2012 July Gas Log 3,754.78 593.44 4,348.22 GL 1697 08/31/2012 August Gas Log 673.01 5,021.23 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,266.45 5,021.23 ** 6,875.00 Budgeted 1,853.77 Remaining 73 % Used Account: 135-65010-020-000 Uniforms 1531 08/14/2012 Aug A/P July PCards/Schlielig 1,118.93 169.94 1,288.87 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 60.00 1,348.87 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 310.35 1,659.22 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Slaght 75.00 1,734.22 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 615.29 1,734.22 ** 3,140.00 Budgeted 1,405.78 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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 1531 08/14/2012 Aug A/P July PCards/Schlielig 6,999.68 799.95 7,799.63 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 799.95 7,799.63 ** 13,180.00 Budgeted 5,380.37 Remaining 59 % Used Account: 135-65035-020-000 Small Tools 1531 08/14/2012 Aug A/P July PCards/Schlielig 5.94 123.73 129.67 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-65035-020-000 Small Tools Totals: 123.73 129.67 ** 1,260.00 Budgeted 1,130.33 Remaining 10 % Used Account: 135-65040-020-000 Safety Equipment 1531 08/14/2012 Aug A/P July PCards/Schlielig 103.43 47.76 151.19 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 30.76 181.95 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 659.54 841.49 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 738.06 841.49 ** 925.00 Budgeted 83.51 Remaining 91 % Used Account: 135-65045-020-000 Lab Supplies 1531 08/14/2012 Aug A/P July PCards/Richey 7,612.90 19.88 7,632.78 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Womack 48.38 7,681.16 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 68.26 7,681.16 ** 12,000.00 Budgeted 4,318.84 Remaining 64 % 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 1531 08/14/2012 Aug A/P Office supplies 968.57 61.09 1,029.66 OFFICE DEPOT, INC 31713 AP _______________ Account: 135-65085-020-000 Office Supplies Totals: 61.09 1,029.66 ** 400.00 Budgeted (629.66) Remaining 257 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/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-65095-020-000 Maintenance Supplies 1531 08/14/2012 Aug A/P July purchases 3,022.27 71.55 3,093.82 COSTCO WHOLESALE 31701 AP 1531 08/14/2012 Aug A/P July PCards/Richey 18.84 3,112.66 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Richey 16.14 3,128.80 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Richey 43.85 3,172.65 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 13.62 3,186.27 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 834.95 4,021.22 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 1,092.48 5,113.70 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 16.17 5,129.87 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 12.52 5,142.39 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 23.58 5,165.97 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Schlielig 588.00 5,753.97 JPMORGAN CHASE BANK NA 31708 AP 1685 08/31/2012 Aug A/P Starter and wire new pump moto 2,695.00 8,448.97 ACME ELECTRIC COMPANY 31740 AP _______________ Account: 135-65095-020-000 Maintenance Supplies Totals: 5,426.70 8,448.97 ** 8,860.00 Budgeted 411.03 Remaining 95 % Used Account: 135-65115-020-000 Other Consumables 1531 08/14/2012 Aug A/P July PCards/Schlielig 8.69 8.69 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-65115-020-000 Other Consumables Totals: 8.69 8.69 ** 110.00 Budgeted 101.31 Remaining 8 % Used Account: 135-69005-020-000 Capital Expenses 1676 08/31/2012 August A/P TC Marshall Creek Branch 74,212.56 750.00 74,962.56 DELTATEK ENGINEERING 31749 AP _______________ Account: 135-69005-020-000 Capital Expenses Totals: 750.00 74,962.56 ** 111,021.00 Budgeted 36,058.44 Remaining 68 % Used Account: 135-69008-020-000 Short Term Debt Payments 118,730.85 .00 118,730.85 _______________ Account: 135-69008-020-000 Short Term Debt Payments Totals: .00 118,730.85 ** 118,731.00 Budgeted .15 Remaining 100 % Used Account: 135-69280-020-000 Capital Repairs 1573 08/22/2012 Aug A/P Gearbox 10,180.37 10,180.37 AQUA AEROBIC SYSTEMS INC 31723 AP _______________ Account: 135-69280-020-000 Capital Repairs Totals: 10,180.37 10,180.37 ** 56,000.00 Budgeted 45,819.63 Remaining 18 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 20 Totals: ------------------------------------------------------------------------------------------------ 712,810.71 ** 881,484.00 Budgeted 168,673.29 Remaining 81 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/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 1634 08/03/2012 8/3/12 Payroll 112,446.70 5,640.15 118,086.85 GL 1646 08/17/2012 8/17/12 Payroll 5,717.87 123,804.72 GL 1660 08/31/2012 8/31/12 Payroll 5,491.92 129,296.64 GL _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 16,849.94 129,296.64 ** 145,481.00 Budgeted 16,184.36 Remaining 89 % Used Account: 135-50010-021-000 Overtime 1634 08/03/2012 8/3/12 Payroll 7,670.09 639.44 8,309.53 GL 1634 08/03/2012 8/3/12 Payroll 80.00 8,389.53 GL 1646 08/17/2012 8/17/12 Payroll 159.29 8,548.82 GL 1660 08/31/2012 8/31/12 Payroll 1,141.38 9,690.20 GL 1660 08/31/2012 8/31/12 Payroll 160.00 9,850.20 GL _______________ Account: 135-50010-021-000 Overtime Totals: 2,180.11 9,850.20 ** 7,297.00 Budgeted (2,553.20) Remaining 135 % 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 1646 08/17/2012 8/17/12 Payroll 950.00 125.00 1,075.00 GL _______________ Account: 135-50017-021-000 Certification Totals: 125.00 1,075.00 ** 1,500.00 Budgeted 425.00 Remaining 72 % Used Account: 135-50020-021-000 Retirement 1634 08/03/2012 8/3/12 Payroll 17,756.38 878.89 18,635.27 GL 1646 08/17/2012 8/17/12 Payroll 829.50 19,464.77 GL 1660 08/31/2012 8/31/12 Payroll 938.83 20,403.60 GL _______________ Account: 135-50020-021-000 Retirement Totals: 2,647.22 20,403.60 ** 21,074.00 Budgeted 670.40 Remaining 97 % Used Account: 135-50026-021-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1634 08/03/2012 8/3/12 Payroll 16,390.08 851.34 17,241.42 GL 1646 08/17/2012 8/17/12 Payroll 851.34 18,092.76 GL _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,702.68 18,092.76 ** 22,983.00 Budgeted 4,890.24 Remaining 79 % Used Account: 135-50027-021-000 Dental Insurance 1634 08/03/2012 8/3/12 Payroll 1,132.31 58.69 1,191.00 GL 1646 08/17/2012 8/17/12 Payroll 58.69 1,249.69 GL _______________ Account: 135-50027-021-000 Dental Insurance Totals: 117.38 1,249.69 ** 1,533.00 Budgeted 283.31 Remaining 82 % Used Account: 135-50028-021-000 Vision Insurance 1634 08/03/2012 8/3/12 Payroll 287.47 14.86 302.33 GL 1646 08/17/2012 8/17/12 Payroll 14.86 317.19 GL _______________ Account: 135-50028-021-000 Vision Insurance Totals: 29.72 317.19 ** 357.00 Budgeted 39.81 Remaining 89 % 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 1634 08/03/2012 8/3/12 Payroll 7,351.50 364.81 7,716.31 GL 1646 08/17/2012 8/17/12 Payroll 342.65 8,058.96 GL 1660 08/31/2012 8/31/12 Payroll 421.19 8,480.15 GL _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 1,128.65 8,480.15 ** 9,785.00 Budgeted 1,304.85 Remaining 87 % Used Account: 135-50035-021-000 Medicare Taxes 1634 08/03/2012 8/3/12 Payroll 1,719.30 85.32 1,804.62 GL 1646 08/17/2012 8/17/12 Payroll 80.13 1,884.75 GL 1660 08/31/2012 8/31/12 Payroll 98.50 1,983.25 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/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-50035-021-000 Medicare Taxes Totals: 263.95 1,983.25 ** 2,288.00 Budgeted 304.75 Remaining 87 % 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 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 4,157.53 .00 4,157.53 . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/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-55080-021-000 Maintenance & Repairs Totals: .00 4,157.53 ** 15,000.00 Budgeted 10,842.47 Remaining 28 % Used Account: 135-55085-021-000 Maintenance-Jet Trailer 330.03 .00 330.03 _______________ Account: 135-55085-021-000 Maintenance-Jet Trailer Totals: .00 330.03 ** .00 Budgeted (330.03) Remaining 0 % Used Account: 135-55090-021-000 Vehicle Maintenance 1531 08/14/2012 Aug A/P July PCards/McMahon 514.22 334.00 848.22 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 334.00 848.22 ** 1,943.00 Budgeted 1,094.78 Remaining 44 % Used Account: 135-55100-021-000 Building Maint & Supplies .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 1495 08/06/2012 July A/P Pcards-Zieverink 31.62 .12 31.74 BANK OF AMERICA 31672 AP 1676 08/31/2012 August A/P PCards/Zieverink 7.00 38.74 BANK OF AMERICA 31744 AP _______________ Account: 135-60005-021-000 Telephone Totals: 7.12 38.74 ** 50.00 Budgeted 11.26 Remaining 77 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 1495 08/06/2012 July A/P Cells 2,362.27 223.84 2,586.11 VERIZON WIRELESS 31698 AP 1693 08/31/2012 Aug A/P Wireless voice/data phones 218.27 2,804.38 VERIZON WIRELESS 31777 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 442.11 2,804.38 ** 2,796.00 Budgeted (8.38) Remaining 100 % Used Account: 135-60020-021-000 Electricity . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1531 08/14/2012 Aug A/P Electricity 6/29-7/30 9,628.13 302.74 9,930.87 TRI COUNTY ELECTRIC 31719 AP 1531 08/14/2012 Aug A/P Electricity 6/29-7/30 170.01 10,100.88 TRI COUNTY ELECTRIC 31719 AP 1531 08/14/2012 Aug A/P Electricity 6/29-7/30 27.59 10,128.47 TRI COUNTY ELECTRIC 31719 AP 1541 08/16/2012 Aug A/P Electricity 7/12-8/13 PID Lift 42.41 10,170.88 HUDSON ENERGY 31707 AP 1573 08/22/2012 Aug A/P Electricity 7/12-8/14 660.23 10,831.11 HUDSON ENERGY 31726 AP 1573 08/22/2012 Aug A/P Electricity 7/16-8/14 216.15 11,047.26 HUDSON ENERGY 31726 AP _______________ Account: 135-60020-021-000 Electricity Totals: 1,419.13 11,047.26 ** 15,000.00 Budgeted 3,952.74 Remaining 74 % 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 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 111.00 .00 111.00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 111.00 ** 2,818.00 Budgeted 2,707.00 Remaining 4 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/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-60100-021-000 Travel & per diem 1634 08/03/2012 8/3/12 Payroll 616.09 19.43 635.52 GL 1646 08/17/2012 8/17/12 Payroll 3.33 638.85 GL 1660 08/31/2012 8/31/12 Payroll 71.04 709.89 GL _______________ Account: 135-60100-021-000 Travel & per diem Totals: 93.80 709.89 ** 1,500.00 Budgeted 790.11 Remaining 47 % Used Account: 135-60105-021-000 Rent/Lease Equipment 42,076.50 .00 42,076.50 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 42,076.50 ** 76,098.00 Budgeted 34,021.50 Remaining 55 % 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 .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 1624 08/01/2012 July Gas Log 7,094.68 1,159.52 8,254.20 GL 1697 08/31/2012 August Gas Log 1,283.88 9,538.08 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 2,443.40 9,538.08 ** 11,700.00 Budgeted 2,161.92 Remaining 82 % Used Account: 135-65010-021-000 Uniforms 832.88 .00 832.88 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 832.88 ** 2,505.00 Budgeted 1,672.12 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/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-021-000 Chemicals 2,616.00 .00 2,616.00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 2,616.00 ** 6,500.00 Budgeted 3,884.00 Remaining 40 % 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 61.87 .00 61.87 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 61.87 ** 1,150.00 Budgeted 1,088.13 Remaining 5 % Used Account: 135-65055-021-000 Hardware 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 352.64 .00 352.64 _______________ Account: 135-65095-021-000 Maintenance Supplies Totals: .00 352.64 ** 6,050.00 Budgeted 5,697.36 Remaining 6 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,001.25 .00 1,001.25 _______________ Account: 135-69035-021-000 Vehicles Totals: .00 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: ------------------------------------------------------------------------------------------------ 306,194.63 ** 466,512.00 Budgeted 160,317.37 Remaining 66 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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 1634 08/03/2012 8/3/12 Payroll 6,800.00 1,400.00 8,200.00 GL 1660 08/31/2012 8/31/12 Payroll 600.00 8,800.00 GL _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 2,000.00 8,800.00 ** 10,000.00 Budgeted 1,200.00 Remaining 88 % Used Account: 135-50030-026-000 Social Security Taxes 1634 08/03/2012 8/3/12 Payroll 421.60 86.80 508.40 GL 1660 08/31/2012 8/31/12 Payroll 37.20 545.60 GL _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 124.00 545.60 ** 620.00 Budgeted 74.40 Remaining 88 % Used Account: 135-50035-026-000 Medicare Taxes 1634 08/03/2012 8/3/12 Payroll 98.60 20.30 118.90 GL 1660 08/31/2012 8/31/12 Payroll 8.70 127.60 GL _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 29.00 127.60 ** 145.00 Budgeted 17.40 Remaining 88 % Used Account: 135-50040-026-000 Unemployment Taxes 1634 08/03/2012 8/3/12 Payroll 62.80 40.60 103.40 GL 1660 08/31/2012 8/31/12 Payroll 17.40 120.80 GL _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 58.00 120.80 ** 210.00 Budgeted 89.20 Remaining 58 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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-026-000 Dues & Memberships 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 1531 08/14/2012 Aug A/P Chamber luncheon/Armstrong 636.56 22.00 658.56 NORTHWEST METROPORT CHAMBER 31712 AP 1573 08/22/2012 Aug A/P Chamber Luncheon/Sanders 22.00 680.56 NORTHWEST METROPORT CHAMBER 31732 AP 1676 08/31/2012 August A/P Chamber luncheon/Sanders 22.00 702.56 NORTHWEST METROPORT CHAMBER 31763 AP _______________ Account: 135-60075-026-000 Meetings Totals: 66.00 702.56 ** 1,278.00 Budgeted 575.44 Remaining 55 % Used Account: 135-60080-026-000 Schools & Training 1676 08/31/2012 August A/P AWBD/Carr, Armstrong, and Sand 1,099.87 890.00 1,989.87 AWBD 31743 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 890.00 1,989.87 ** 4,150.00 Budgeted 2,160.13 Remaining 48 % Used Account: 135-60100-026-000 Travel & per diem 1531 08/14/2012 Aug A/P Mileage-AWBD Conf San Antonio 32.19 355.20 387.39 C. NICK SANDERS 31700 AP 1531 08/14/2012 Aug A/P July PCard/Slaght 559.38 946.77 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Slaght 839.07 1,785.84 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Slaght 31.00 1,816.84 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 1,784.65 1,816.84 ** 6,199.00 Budgeted 4,382.16 Remaining 29 % Used Account: 135-60245-026-000 Miscellaneous Expenses 1,217.69 .00 1,217.69 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,217.69 ** 3,200.00 Budgeted 1,982.31 Remaining 38 % Used Account: 135-65085-026-000 Office Supplies 30.90 .00 30.90 . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 8/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-026-000 Office Supplies Totals: .00 30.90 ** 50.00 Budgeted 19.10 Remaining 62 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 16,182.97 ** 28,122.00 Budgeted 11,939.03 Remaining 58 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 8/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 1634 08/03/2012 8/3/12 Payroll 215,089.60 6,532.31 221,621.91 GL 1646 08/17/2012 8/17/12 Payroll 6,490.87 228,112.78 GL 1660 08/31/2012 8/31/12 Payroll 6,691.10 234,803.88 GL _______________ Account: 135-50005-027-000 Salaries & Wages Totals: 19,714.28 234,803.88 ** 236,831.00 Budgeted 2,027.12 Remaining 99 % Used Account: 135-50010-027-000 Overtime 1,124.91 .00 1,124.91 _______________ Account: 135-50010-027-000 Overtime Totals: .00 1,124.91 ** 1,028.00 Budgeted (96.91) Remaining 109 % 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 1634 08/03/2012 8/3/12 Payroll 30,523.79 855.78 31,379.57 GL 1646 08/17/2012 8/17/12 Payroll 855.78 32,235.35 GL 1660 08/31/2012 8/31/12 Payroll 882.36 33,117.71 GL _______________ Account: 135-50020-027-000 Retirement Totals: 2,593.92 33,117.71 ** 33,471.00 Budgeted 353.29 Remaining 99 % Used Account: 135-50026-027-000 Medical Insurance 1634 08/03/2012 8/3/12 Payroll 14,008.78 605.93 14,614.71 GL 1646 08/17/2012 8/17/12 Payroll 605.93 15,220.64 GL _______________ Account: 135-50026-027-000 Medical Insurance Totals: 1,211.86 15,220.64 ** 18,798.00 Budgeted 3,577.36 Remaining 81 % Used Account: 135-50027-027-000 Dental Insurance 1634 08/03/2012 8/3/12 Payroll 1,101.17 49.02 1,150.19 GL 1646 08/17/2012 8/17/12 Payroll 49.02 1,199.21 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 8/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: 98.04 1,199.21 ** 1,242.00 Budgeted 42.79 Remaining 97 % Used Account: 135-50028-027-000 Vision Insurance 1634 08/03/2012 8/3/12 Payroll 268.45 11.48 279.93 GL 1646 08/17/2012 8/17/12 Payroll 11.48 291.41 GL _______________ Account: 135-50028-027-000 Vision Insurance Totals: 22.96 291.41 ** 341.00 Budgeted 49.59 Remaining 85 % 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 1634 08/03/2012 8/3/12 Payroll 12,997.41 365.50 13,362.91 GL 1646 08/17/2012 8/17/12 Payroll 362.93 13,725.84 GL 1660 08/31/2012 8/31/12 Payroll 414.85 14,140.69 GL _______________ Account: 135-50030-027-000 Social Security Taxes Totals: 1,143.28 14,140.69 ** 14,860.00 Budgeted 719.31 Remaining 95 % Used Account: 135-50035-027-000 Medicare Taxes 1634 08/03/2012 8/3/12 Payroll 3,077.61 85.48 3,163.09 GL 1646 08/17/2012 8/17/12 Payroll 84.88 3,247.97 GL 1660 08/31/2012 8/31/12 Payroll 97.03 3,345.00 GL _______________ Account: 135-50035-027-000 Medicare Taxes Totals: 267.39 3,345.00 ** 3,475.00 Budgeted 130.00 Remaining 96 % Used Account: 135-50040-027-000 Unemployment Taxes 1634 08/03/2012 8/3/12 Payroll 347.52 9.86 357.38 GL 1646 08/17/2012 8/17/12 Payroll 8.66 366.04 GL 1660 08/31/2012 8/31/12 Payroll 8.89 374.93 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 8/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-027-000 Unemployment Taxes Totals: 27.41 374.93 ** 756.00 Budgeted 381.07 Remaining 50 % Used 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 61.48 .00 61.48 _______________ Account: 135-50060-027-000 Pre-emp Physicals/Testing Totals: .00 61.48 ** 53.00 Budgeted (8.48) Remaining 116 % Used Account: 135-50070-027-000 Employee Relations 4,118.67 .00 4,118.67 _______________ Account: 135-50070-027-000 Employee Relations Totals: .00 4,118.67 ** 5,000.00 Budgeted 881.33 Remaining 82 % Used Account: 135-55070-027-000 Independent Labor 1573 08/22/2012 Aug A/P Record MUD meeting 288.75 97.50 386.25 MIGUEL CRUZ 31730 AP _______________ Account: 135-55070-027-000 Independent Labor Totals: 97.50 386.25 ** 840.00 Budgeted 453.75 Remaining 46 % 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 1597 08/28/2012 Aug A/P Website design/development 191,092.23 1,875.00 192,967.23 FOUR MAN FURNACE, INC. 31738 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 8/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-027-000 Professional Outside Services Totals: 1,875.00 192,967.23 ** 191,093.00 Budgeted (1,874.23) Remaining 101 % Used Account: 135-60005-027-000 Telephone 1495 08/06/2012 July A/P Pcards-Zieverink 221.85 36.28 258.13 BANK OF AMERICA 31672 AP 1676 08/31/2012 August A/P PCards/Zieverink 26.16 284.29 BANK OF AMERICA 31744 AP _______________ Account: 135-60005-027-000 Telephone Totals: 62.44 284.29 ** 300.00 Budgeted 15.71 Remaining 95 % Used Account: 135-60010-027-000 Communications/Pagers/Mobiles 1495 08/06/2012 July A/P Cells 1,454.09 89.20 1,543.29 VERIZON WIRELESS 31698 AP 1646 08/17/2012 8/17/12 Payroll 75.00 1,618.29 GL 1693 08/31/2012 Aug A/P Wireless voice/data phones 18.12 1,636.41 VERIZON WIRELESS 31777 AP _______________ Account: 135-60010-027-000 Communications/Pagers/Mobiles Totals: 182.32 1,636.41 ** 2,420.00 Budgeted 783.59 Remaining 68 % Used Account: 135-60035-027-000 Postage 1625 08/31/2012 August Postage meter 1,891.74 204.75 2,096.49 GL _______________ Account: 135-60035-027-000 Postage Totals: 204.75 2,096.49 ** 2,400.00 Budgeted 303.51 Remaining 87 % Used Account: 135-60066-027-000 Publications/Books/Subscripts 371.15 .00 371.15 _______________ Account: 135-60066-027-000 Publications/Books/Subscripts Totals: .00 371.15 ** 450.00 Budgeted 78.85 Remaining 82 % Used Account: 135-60070-027-000 Dues & Memberships 1531 08/14/2012 Aug A/P July PCard/Slaght 827.05 38.85 865.90 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-60070-027-000 Dues & Memberships Totals: 38.85 865.90 ** 1,742.00 Budgeted 876.10 Remaining 50 % Used Account: 135-60075-027-000 Meetings . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 42.44 .00 42.44 _______________ Account: 135-60075-027-000 Meetings Totals: .00 42.44 ** 312.00 Budgeted 269.56 Remaining 14 % Used Account: 135-60080-027-000 Schools & Training 1,405.00 .00 1,405.00 _______________ Account: 135-60080-027-000 Schools & Training Totals: .00 1,405.00 ** 2,555.00 Budgeted 1,150.00 Remaining 55 % Used Account: 135-60100-027-000 Travel & per diem 1,115.87 .00 1,115.87 _______________ Account: 135-60100-027-000 Travel & per diem Totals: .00 1,115.87 ** 3,851.00 Budgeted 2,735.13 Remaining 29 % Used Account: 135-60115-027-000 Elections 1531 08/14/2012 Aug A/P Election translations 2,531.32 76.00 2,607.32 DOS AMIGAS TRANSLATIONS 31704 AP _______________ Account: 135-60115-027-000 Elections Totals: 76.00 2,607.32 ** 2,500.00 Budgeted (107.32) Remaining 104 % Used Account: 135-60125-027-000 Advertising 258.06 .00 258.06 _______________ Account: 135-60125-027-000 Advertising Totals: .00 258.06 ** 4,700.00 Budgeted 4,441.94 Remaining 5 % Used Account: 135-60245-027-000 Miscellaneous Expenses 1495 08/06/2012 July A/P Pcards-Zieverink 120.98 120.98 BANK OF AMERICA 31672 AP 1495 08/06/2012 July A/P Pcards-Zieverink 15.99 136.97 BANK OF AMERICA 31672 AP _______________ Account: 135-60245-027-000 Miscellaneous Expenses Totals: 136.97 136.97 ** 100.00 Budgeted (36.97) Remaining 137 % Used Account: 135-60270-027-000 4th of July Celebration . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1540 08/16/2012 Aug A/P 4th of July Booth/Food for wor 10,238.51 43.46 10,281.97 LAURIE SLAGHT 31709 AP _______________ Account: 135-60270-027-000 4th of July Celebration Totals: 43.46 10,281.97 ** 10,500.00 Budgeted 218.03 Remaining 98 % Used Account: 135-60360-027-000 Furniture/Equipment < $5000 1,616.99 .00 1,616.99 _______________ Account: 135-60360-027-000 Furniture/Equipment < $5000 Totals: .00 1,616.99 ** 2,225.00 Budgeted 608.01 Remaining 73 % Used Account: 135-65085-027-000 Office Supplies 1531 08/14/2012 Aug A/P Office supplies 2,671.63 43.20 2,714.83 OFFICE DEPOT, INC 31713 AP 1531 08/14/2012 Aug A/P Office supplies 94.17 2,809.00 OFFICE DEPOT, INC 31713 AP 1531 08/14/2012 Aug A/P Office/Training supplies 26.17 2,835.17 OFFICE DEPOT, INC 31713 AP 1531 08/14/2012 Aug A/P July PCard/Slaght 226.50 3,061.67 JPMORGAN CHASE BANK NA 31708 AP 1676 08/31/2012 August A/P Office Supplies 54.18 3,115.85 OFFICE DEPOT, INC 31764 AP 1676 08/31/2012 August A/P Office Supplies 105.09 3,220.94 OFFICE DEPOT, INC 31764 AP 1676 08/31/2012 August A/P Office Supplies 57.08 3,278.02 OFFICE DEPOT, INC 31764 AP _______________ Account: 135-65085-027-000 Office Supplies Totals: 606.39 3,278.02 ** 2,450.00 Budgeted (828.02) Remaining 134 % Used Account: 135-65105-027-000 Printing 1,745.08 .00 1,745.08 _______________ Account: 135-65105-027-000 Printing Totals: .00 1,745.08 ** 750.00 Budgeted (995.08) Remaining 233 % Used Department 27 Totals: ------------------------------------------------------------------------------------------------ 533,178.97 ** 549,305.00 Budgeted 16,126.03 Remaining 97 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 8/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 1531 08/14/2012 Aug A/P July PCards/Ard 1,478.72 44.41 1,523.13 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-50070-028-000 Employee Relations Totals: 44.41 1,523.13 ** 1,967.00 Budgeted 443.87 Remaining 77 % Used Account: 135-50075-028-000 Tuition Reimbursement 219.42 .00 219.42 _______________ Account: 135-50075-028-000 Tuition Reimbursement Totals: .00 219.42 ** 1,561.00 Budgeted 1,341.58 Remaining 14 % 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 22.23 .00 22.23 _______________ Account: 135-60035-028-000 Postage Totals: .00 22.23 ** 106.00 Budgeted 83.77 Remaining 21 % 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 MUD #1 Page 58 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 8/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 165.00 .00 165.00 _______________ Account: 135-60110-028-000 Physicals/Testing Totals: .00 165.00 ** 1,560.00 Budgeted 1,395.00 Remaining 11 % 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,929.78 ** 7,547.00 Budgeted 5,617.22 Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 8/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 1634 08/03/2012 8/3/12 Payroll 66,051.42 3,001.20 69,052.62 GL 1646 08/17/2012 8/17/12 Payroll 3,001.20 72,053.82 GL 1660 08/31/2012 8/31/12 Payroll 3,001.20 75,055.02 GL _______________ Account: 135-50005-029-000 Salaries & Wages Totals: 9,003.60 75,055.02 ** 94,404.00 Budgeted 19,348.98 Remaining 80 % 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 1634 08/03/2012 8/3/12 Payroll 9,857.22 414.77 10,271.99 GL 1646 08/17/2012 8/17/12 Payroll 414.77 10,686.76 GL 1660 08/31/2012 8/31/12 Payroll 414.77 11,101.53 GL _______________ Account: 135-50020-029-000 Retirement Totals: 1,244.31 11,101.53 ** 13,612.00 Budgeted 2,510.47 Remaining 82 % Used Account: 135-50026-029-000 Medical Insurance 1634 08/03/2012 8/3/12 Payroll 5,774.58 205.35 5,979.93 GL 1646 08/17/2012 8/17/12 Payroll 205.35 6,185.28 GL 1660 08/31/2012 8/31/12 Payroll 43.52 6,228.80 GL _______________ Account: 135-50026-029-000 Medical Insurance Totals: 454.22 6,228.80 ** 11,060.00 Budgeted 4,831.20 Remaining 56 % Used Account: 135-50027-029-000 Dental Insurance 1634 08/03/2012 8/3/12 Payroll 575.95 24.51 600.46 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1646 08/17/2012 8/17/12 Payroll 575.95 24.51 624.97 GL _______________ Account: 135-50027-029-000 Dental Insurance Totals: 49.02 624.97 ** 773.00 Budgeted 148.03 Remaining 81 % Used Account: 135-50028-029-000 Vision Insurance 1634 08/03/2012 8/3/12 Payroll 87.67 3.38 91.05 GL 1646 08/17/2012 8/17/12 Payroll 3.38 94.43 GL _______________ Account: 135-50028-029-000 Vision Insurance Totals: 6.76 94.43 ** 207.00 Budgeted 112.57 Remaining 46 % 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 1634 08/03/2012 8/3/12 Payroll 3,987.89 172.92 4,160.81 GL 1646 08/17/2012 8/17/12 Payroll 172.92 4,333.73 GL 1660 08/31/2012 8/31/12 Payroll 186.07 4,519.80 GL _______________ Account: 135-50030-029-000 Social Security Taxes Totals: 531.91 4,519.80 ** 5,386.00 Budgeted 866.20 Remaining 84 % Used Account: 135-50035-029-000 Medicare Taxes 1634 08/03/2012 8/3/12 Payroll 932.65 40.44 973.09 GL 1646 08/17/2012 8/17/12 Payroll 40.44 1,013.53 GL _______________ Account: 135-50035-029-000 Medicare Taxes Totals: 80.88 1,013.53 ** 1,260.00 Budgeted 246.47 Remaining 80 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 8/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-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 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 1495 08/06/2012 July A/P Pcards-Zieverink 66.42 1.90 68.32 BANK OF AMERICA 31672 AP 1676 08/31/2012 August A/P PCards/Zieverink 1.94 70.26 BANK OF AMERICA 31744 AP _______________ Account: 135-60005-029-000 Telephone Totals: 3.84 70.26 ** 103.00 Budgeted 32.74 Remaining 68 % Used Account: 135-60010-029-000 Communications/Pagers/Mobiles 1495 08/06/2012 July A/P Cells 460.65 51.21 511.86 VERIZON WIRELESS 31698 AP 1693 08/31/2012 Aug A/P Wireless voice/data phones 51.21 563.07 VERIZON WIRELESS 31777 AP _______________ Account: 135-60010-029-000 Communications/Pagers/Mobiles Totals: 102.42 563.07 ** 683.00 Budgeted 119.93 Remaining 82 % Used Account: 135-60035-029-000 Postage 1625 08/31/2012 August Postage meter 259.64 26.10 285.74 GL _______________ Account: 135-60035-029-000 Postage Totals: 26.10 285.74 ** 700.00 Budgeted 414.26 Remaining 41 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 8/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-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 1676 08/31/2012 August A/P Dues/Gonzales 95.00 95.00 GOVT FINANCE OFFICERS ASSOC TX 31754 AP _______________ Account: 135-60070-029-000 Dues & Memberships Totals: 95.00 95.00 ** 660.00 Budgeted 565.00 Remaining 14 % 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 ** 40.00 Budgeted 12.19 Remaining 70 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 63 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 8/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-60245-029-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65085-029-000 Office Supplies 1531 08/14/2012 Aug A/P Office supplies 148.52 1.80 150.32 OFFICE DEPOT, INC 31713 AP 1531 08/14/2012 Aug A/P Office supplies 2.43 152.75 OFFICE DEPOT, INC 31713 AP 1676 08/31/2012 August A/P Office Supplies 25.84 178.59 OFFICE DEPOT, INC 31764 AP _______________ Account: 135-65085-029-000 Office Supplies Totals: 30.07 178.59 ** 849.00 Budgeted 670.41 Remaining 21 % Used Account: 135-65105-029-000 Printing 1676 08/31/2012 August A/P Blank check stock 293.56 293.56 FORMS ONE 31753 AP _______________ Account: 135-65105-029-000 Printing Totals: 293.56 293.56 ** 515.00 Budgeted 221.44 Remaining 57 % Used Department 29 Totals: ------------------------------------------------------------------------------------------------ 104,596.43 ** 143,450.00 Budgeted 38,853.57 Remaining 73 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 64 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 8/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 1495 08/06/2012 July A/P PCards-Pastor 59,782.63 25.00 59,807.63 BANK OF AMERICA 31672 AP 1495 08/06/2012 July A/P PCards-Pastor 20.34 59,827.97 BANK OF AMERICA 31672 AP 1495 08/06/2012 July A/P PCards-Pastor 569.97 60,397.94 BANK OF AMERICA 31672 AP 1495 08/06/2012 July A/P Pcards-Zieverink 55.37 60,453.31 BANK OF AMERICA 31672 AP 1495 08/06/2012 July A/P Pcards-Zieverink 53.38 60,506.69 BANK OF AMERICA 31672 AP 1495 08/06/2012 July A/P Annual CTY 3,429.00 63,935.69 BLACKBOARD CONNECT INC. 31673 AP 1573 08/22/2012 Aug A/P Software support/training 2,426.22 66,361.91 STW INC 31735 AP 1573 08/22/2012 Aug A/P Camera Van Software annual mai 1,900.00 68,261.91 PIPELOGIX, INC 31733 AP 1676 08/31/2012 August A/P PCards/Pastor 189.99 68,451.90 BANK OF AMERICA 31744 AP 1676 08/31/2012 August A/P PCards/Pastor 25.00 68,476.90 BANK OF AMERICA 31744 AP 1676 08/31/2012 August A/P PCards/Pastor 86.91 68,563.81 BANK OF AMERICA 31744 AP 1676 08/31/2012 August A/P PCards/Pastor 83.76 68,647.57 BANK OF AMERICA 31744 AP 1676 08/31/2012 August A/P PCards/Pastor 17.94 68,665.51 BANK OF AMERICA 31744 AP 1676 08/31/2012 August A/P PCards/Pastor 25.00 68,690.51 BANK OF AMERICA 31744 AP 1676 08/31/2012 August A/P PCards/Zieverink 53.38 68,743.89 BANK OF AMERICA 31744 AP 1676 08/31/2012 August A/P PCards/Zieverink 55.37 68,799.26 BANK OF AMERICA 31744 AP _______________ Account: 135-55030-033-000 Software & Support Totals: 9,016.63 68,799.26 ** 64,149.00 Budgeted (4,650.26) Remaining 107 % Used Account: 135-55070-033-000 Independent Labor 1676 08/31/2012 August A/P Marquee sign repair on Trophy 375.00 358.75 733.75 ENTECH ASSOC/ENTECH SIGNS 31752 AP 1693 08/31/2012 Aug A/P Fixed rules in firewall to all 125.00 858.75 ACCLAIM NETWORKS LLC 31772 AP _______________ Account: 135-55070-033-000 Independent Labor Totals: 483.75 858.75 ** 1,650.00 Budgeted 791.25 Remaining 52 % Used Account: 135-60005-033-000 Telephone 1495 08/06/2012 July A/P Pcards-Zieverink 6,824.19 393.83 7,218.02 BANK OF AMERICA 31672 AP 1495 08/06/2012 July A/P Pcards-Zieverink 369.26 7,587.28 BANK OF AMERICA 31672 AP 1676 08/31/2012 August A/P PCards/Zieverink 394.45 7,981.73 BANK OF AMERICA 31744 AP 1676 08/31/2012 August A/P PCards/Zieverink 373.13 8,354.86 BANK OF AMERICA 31744 AP _______________ Account: 135-60005-033-000 Telephone Totals: 1,530.67 8,354.86 ** 6,540.00 Budgeted (1,814.86) Remaining 128 % Used Account: 135-60235-033-000 Security 1676 08/31/2012 August A/P PCards/Pastor 682.85 64.99 747.84 BANK OF AMERICA 31744 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 65 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 8/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-60235-033-000 Security Totals: 64.99 747.84 ** 1,350.00 Budgeted 602.16 Remaining 55 % Used Account: 135-65055-033-000 Hardware 1495 08/06/2012 July A/P Replace UB HP printer & toner 72,352.96 1,644.94 73,997.90 SHI GOVERNMENT SOLUTIONS,INC 31690 AP 1495 08/06/2012 July A/P Patch cable 36.00 74,033.90 SHI GOVERNMENT SOLUTIONS,INC 31690 AP 1495 08/06/2012 July A/P PCards-Pastor 2,472.50 76,506.40 BANK OF AMERICA 31672 AP 1495 08/06/2012 July A/P Pcards-Zieverink 183.00 76,689.40 BANK OF AMERICA 31672 AP 1573 08/22/2012 Aug A/P Tray for UB printer 171.00 76,860.40 SHI GOVERNMENT SOLUTIONS,INC 31734 AP 1676 08/31/2012 August A/P PCards/Pastor 1,052.65 77,913.05 BANK OF AMERICA 31744 AP 1676 08/31/2012 August A/P PCards/Zieverink 495.00 78,408.05 BANK OF AMERICA 31744 AP 1676 08/31/2012 August A/P PCards/Zieverink 34.97 78,443.02 BANK OF AMERICA 31744 AP 1693 08/31/2012 Aug A/P Converter PW/Adm 64.50 78,507.52 SHI GOVERNMENT SOLUTIONS,INC 31774 AP _______________ Account: 135-65055-033-000 Hardware Totals: 6,154.56 78,507.52 ** 83,238.00 Budgeted 4,730.48 Remaining 94 % Used Account: 135-65085-033-000 Office Supplies 1495 08/06/2012 July A/P PCards-Pastor 360.00 287.50 647.50 BANK OF AMERICA 31672 AP 1693 08/31/2012 Aug A/P Toner Cartridge 50.50 698.00 SHI GOVERNMENT SOLUTIONS,INC 31774 AP _______________ Account: 135-65085-033-000 Office Supplies Totals: 338.00 698.00 ** 371.00 Budgeted (327.00) Remaining 188 % Used Account: 135-65090-033-000 Printer Supplies & Maintenance 1495 08/06/2012 July A/P Toner 5,702.67 268.00 5,970.67 SHI GOVERNMENT SOLUTIONS,INC 31690 AP 1495 08/06/2012 July A/P Replace UB HP printer & toner 187.50 6,158.17 SHI GOVERNMENT SOLUTIONS,INC 31690 AP 1573 08/22/2012 Aug A/P Color drum kits 444.00 6,602.17 SHI GOVERNMENT SOLUTIONS,INC 31734 AP 1676 08/31/2012 August A/P HP Toner Cartridge 142.50 6,744.67 SHI GOVERNMENT SOLUTIONS,INC 31765 AP _______________ Account: 135-65090-033-000 Printer Supplies & Maintenance Totals: 1,042.00 6,744.67 ** 5,732.00 Budgeted (1,012.67) Remaining 118 % Used Account: 135-69170-033-000 Copier Lease Installments 1573 08/22/2012 Aug A/P Copier lease 2,317.75 262.94 2,580.69 KYOCERA MITA AMERICA, INC. 31728 AP 1573 08/22/2012 Aug A/P Copier lease 256.85 2,837.54 KYOCERA MITA AMERICA, INC. 31728 AP _______________ Account: 135-69170-033-000 Copier Lease Installments Totals: 519.79 2,837.54 ** 3,450.00 Budgeted 612.46 Remaining 82 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 66 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 8/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-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: ------------------------------------------------------------------------------------------------ 167,548.44 ** 193,391.00 Budgeted 25,842.56 Remaining 87 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 67 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 8/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-50035-037-000 Medicare Taxes 46.85 .00 46.85 _______________ Account: 135-50035-037-000 Medicare Taxes Totals: .00 46.85 ** .00 Budgeted (46.85) Remaining 0 % Used 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 ** 861.00 Budgeted .00 Remaining 100 % Used Account: 135-55100-037-000 Building Maint & Supplies 1,384.28 .00 1,384.28 _______________ Account: 135-55100-037-000 Building Maint & Supplies Totals: .00 1,384.28 ** 20,478.00 Budgeted 19,093.72 Remaining 7 % Used Account: 135-55120-037-000 Cleaning Services 1531 08/14/2012 Aug A/P July PCard/Slaght 15,105.97 133.66 15,239.63 JPMORGAN CHASE BANK NA 31708 AP 1573 08/22/2012 Aug A/P Feb Janitorial Service 1,678.51 16,918.14 ABM JANITORIAL SERVICES, INC 31722 AP 1573 08/22/2012 Aug A/P August Cleaning service 1,678.51 18,596.65 ABM JANITORIAL SERVICES, INC 31722 AP _______________ Account: 135-55120-037-000 Cleaning Services Totals: 3,490.68 18,596.65 ** 25,000.00 Budgeted 6,403.35 Remaining 74 % Used Account: 135-60020-037-000 Electricity 1531 08/14/2012 Aug A/P Electricity 6/14-7/16 9,319.33 1,204.48 10,523.81 DIRECT ENERGY BUSINESS SVCS 31703 AP _______________ Account: 135-60020-037-000 Electricity Totals: 1,204.48 10,523.81 ** 21,940.00 Budgeted 11,416.19 Remaining 48 % Used Account: 135-60025-037-000 Water 1495 08/06/2012 July A/P July Water 557.40 169.26 726.66 TROPHY CLUB MUD (WATER BILLS) 31696 AP 1676 08/31/2012 August A/P August Water 176.16 902.82 TROPHY CLUB MUD (WATER BILLS) 31769 AP _______________ Account: 135-60025-037-000 Water Totals: 345.42 902.82 ** 1,093.00 Budgeted 190.18 Remaining 83 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 68 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 8/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-60030-037-000 Rent And/Or Usage 1531 08/14/2012 Aug A/P August PS Bldg Rent 10,985.10 1,098.51 12,083.61 TOWN OF TROPHY CLUB 31718 AP _______________ Account: 135-60030-037-000 Rent And/Or Usage Totals: 1,098.51 12,083.61 ** 13,182.00 Budgeted 1,098.39 Remaining 92 % Used Account: 135-60055-037-000 Insurance 1495 08/06/2012 July A/P Director Bonds 33,630.49 200.00 33,830.49 VICTOR O SCHINNERER & CO, INC 31699 AP 1495 08/06/2012 July A/P Slaght Bond 50.00 33,880.49 VICTOR O SCHINNERER & CO, INC 31699 AP 1495 08/06/2012 July A/P McKnight 50.00 33,930.49 VICTOR O SCHINNERER & CO, INC 31699 AP 1495 08/06/2012 July A/P Schultz Bond 50.00 33,980.49 VICTOR O SCHINNERER & CO, INC 31699 AP 1573 08/22/2012 Aug A/P Bond/Schaefer 50.00 34,030.49 VICTOR O SCHINNERER & CO, INC 31736 AP 1676 08/31/2012 August A/P Bond/Gonzales 50.00 34,080.49 VICTOR O SCHINNERER & CO, INC 31770 AP _______________ Account: 135-60055-037-000 Insurance Totals: 450.00 34,080.49 ** 32,635.00 Budgeted (1,445.49) Remaining 104 % Used Account: 135-60360-037-000 Furniture/Equipment < $5000 1541 08/16/2012 Aug A/P July PCards/Schultz 197.28 197.28 JPMORGAN CHASE BANK NA 31708 AP 1541 08/16/2012 Aug A/P July PCards/Schultz 12.50 209.78 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-60360-037-000 Furniture/Equipment < $5000 Totals: 209.78 209.78 ** 4,750.00 Budgeted 4,540.22 Remaining 4 % Used Account: 135-65095-037-000 Maintenance Supplies 1531 08/14/2012 Aug A/P July purchases 876.65 20.86 897.51 COSTCO WHOLESALE 31701 AP 1531 08/14/2012 Aug A/P July purchases 18.96 916.47 COSTCO WHOLESALE 31701 AP 1531 08/14/2012 Aug A/P July PCards/Huggins 89.41 1,005.88 JPMORGAN CHASE BANK NA 31708 AP 1541 08/16/2012 Aug A/P July PCards/Schultz 37.97 1,043.85 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 135-65095-037-000 Maintenance Supplies Totals: 167.20 1,043.85 ** 2,205.00 Budgeted 1,161.15 Remaining 47 % Used Account: 135-65097-037-000 Vending Machine Supplies 80.03 .00 80.03 _______________ Account: 135-65097-037-000 Vending Machine Supplies Totals: .00 80.03 ** 1,000.00 Budgeted 919.97 Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 69 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 37 Totals: ------------------------------------------------------------------------------------------------ 79,813.17 ** 123,144.00 Budgeted 43,330.83 Remaining 65 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 70 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 8/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 1634 08/03/2012 8/3/12 Payroll 66,333.38 3,712.84 70,046.22 GL 1646 08/17/2012 8/17/12 Payroll 3,660.42 73,706.64 GL 1660 08/31/2012 8/31/12 Payroll 3,672.30 77,378.94 GL _______________ Account: 135-50005-038-000 Salaries & Wages Totals: 11,045.56 77,378.94 ** 84,946.00 Budgeted 7,567.06 Remaining 91 % Used Account: 135-50010-038-000 Overtime 1634 08/03/2012 8/3/12 Payroll 300.08 1.18 301.26 GL 1646 08/17/2012 8/17/12 Payroll 9.53 310.79 GL 1660 08/31/2012 8/31/12 Payroll 14.80 325.59 GL _______________ Account: 135-50010-038-000 Overtime Totals: 25.51 325.59 ** 2,000.00 Budgeted 1,674.41 Remaining 16 % 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 1634 08/03/2012 8/3/12 Payroll 9,392.40 466.30 9,858.70 GL 1646 08/17/2012 8/17/12 Payroll 465.94 10,324.64 GL 1660 08/31/2012 8/31/12 Payroll 467.20 10,791.84 GL _______________ Account: 135-50020-038-000 Retirement Totals: 1,399.44 10,791.84 ** 12,203.00 Budgeted 1,411.16 Remaining 88 % Used Account: 135-50026-038-000 Medical Insurance 1634 08/03/2012 8/3/12 Payroll 8,949.84 462.18 9,412.02 GL 1646 08/17/2012 8/17/12 Payroll 462.18 9,874.20 GL _______________ Account: 135-50026-038-000 Medical Insurance Totals: 924.36 9,874.20 ** 12,321.00 Budgeted 2,446.80 Remaining 80 % Used Account: 135-50027-038-000 Dental Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 71 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1634 08/03/2012 8/3/12 Payroll 888.08 45.83 933.91 GL 1646 08/17/2012 8/17/12 Payroll 45.83 979.74 GL _______________ Account: 135-50027-038-000 Dental Insurance Totals: 91.66 979.74 ** 1,026.00 Budgeted 46.26 Remaining 95 % Used Account: 135-50028-038-000 Vision Insurance 1634 08/03/2012 8/3/12 Payroll 209.47 10.81 220.28 GL 1646 08/17/2012 8/17/12 Payroll 10.81 231.09 GL _______________ Account: 135-50028-038-000 Vision Insurance Totals: 21.62 231.09 ** 260.00 Budgeted 28.91 Remaining 89 % 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 1634 08/03/2012 8/3/12 Payroll 3,911.26 212.40 4,123.66 GL 1646 08/17/2012 8/17/12 Payroll 209.66 4,333.32 GL 1660 08/31/2012 8/31/12 Payroll 228.60 4,561.92 GL _______________ Account: 135-50030-038-000 Social Security Taxes Totals: 650.66 4,561.92 ** 5,404.00 Budgeted 842.08 Remaining 84 % Used Account: 135-50035-038-000 Medicare Taxes 1634 08/03/2012 8/3/12 Payroll 867.91 49.67 917.58 GL 1646 08/17/2012 8/17/12 Payroll 49.04 966.62 GL 1660 08/31/2012 8/31/12 Payroll 53.47 1,020.09 GL _______________ Account: 135-50035-038-000 Medicare Taxes Totals: 152.18 1,020.09 ** 1,264.00 Budgeted 243.91 Remaining 81 % Used Account: 135-50040-038-000 Unemployment Taxes 1634 08/03/2012 8/3/12 Payroll 216.75 9.86 226.61 GL 1646 08/17/2012 8/17/12 Payroll 8.66 235.27 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 72 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1660 08/31/2012 8/31/12 Payroll 216.75 8.88 244.15 GL _______________ Account: 135-50040-038-000 Unemployment Taxes Totals: 27.40 244.15 ** 473.00 Budgeted 228.85 Remaining 52 % 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 Account: 135-50060-038-000 Pre-emp Physicals/Testing 26.47 .00 26.47 _______________ Account: 135-50060-038-000 Pre-emp Physicals/Testing Totals: .00 26.47 ** 35.00 Budgeted 8.53 Remaining 76 % Used 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 1531 08/14/2012 Aug A/P July Water bills 8,738.22 819.19 9,557.41 CSG SYSTEMS, INC. 31702 AP _______________ Account: 135-55205-038-000 Utility Billing Contract Totals: 819.19 9,557.41 ** 11,000.00 Budgeted 1,442.59 Remaining 87 % Used Account: 135-60005-038-000 Telephone 1495 08/06/2012 July A/P Pcards-Zieverink 56.66 1.76 58.42 BANK OF AMERICA 31672 AP 1676 08/31/2012 August A/P PCards/Zieverink 10.57 68.99 BANK OF AMERICA 31744 AP _______________ Account: 135-60005-038-000 Telephone Totals: 12.33 68.99 ** 100.00 Budgeted 31.01 Remaining 69 % Used Account: 135-60010-038-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club MUD #1 Page 73 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1495 08/06/2012 July A/P Cells 326.14 36.30 362.44 VERIZON WIRELESS 31698 AP 1693 08/31/2012 Aug A/P Wireless voice/data phones 36.24 398.68 VERIZON WIRELESS 31777 AP _______________ Account: 135-60010-038-000 Communications/Pagers/Mobiles Totals: 72.54 398.68 ** 472.00 Budgeted 73.32 Remaining 84 % Used Account: 135-60035-038-000 Postage 1531 08/14/2012 Aug A/P July Water bills 12,716.73 1,245.16 13,961.89 CSG SYSTEMS, INC. 31702 AP _______________ Account: 135-60035-038-000 Postage Totals: 1,245.16 13,961.89 ** 18,000.00 Budgeted 4,038.11 Remaining 78 % Used Account: 135-60040-038-000 Service Charges & Fees 1627 08/02/2012 July CC/Online fees 19,799.37 54.00 19,853.37 GL 1627 08/02/2012 July CC/Online fees 73.65 19,927.02 GL 1627 08/02/2012 July CC/Online fees 1,885.28 21,812.30 GL _______________ Account: 135-60040-038-000 Service Charges & Fees Totals: 2,012.93 21,812.30 ** 29,340.00 Budgeted 7,527.70 Remaining 74 % Used 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 74 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 8/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-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 ** 25,100.00 Budgeted 28.80 Remaining 100 % Used Account: 135-60245-038-000 Miscellaneous Expenses .01 .00 .01 _______________ Account: 135-60245-038-000 Miscellaneous Expenses Totals: .00 .01 ** 200.00 Budgeted 199.99 Remaining 0 % Used Account: 135-65085-038-000 Office Supplies 1541 08/16/2012 Aug A/P Office Supplies 670.19 4.45 674.64 OFFICE DEPOT, INC 31713 AP 1541 08/16/2012 Aug A/P Office Supplies 2.68 677.32 OFFICE DEPOT, INC 31713 AP 1676 08/31/2012 August A/P Office Supplies 99.99 777.31 OFFICE DEPOT, INC 31764 AP 1676 08/31/2012 August A/P Shredder-Returned (99.99) 677.32 OFFICE DEPOT, INC 31764 AP 1676 08/31/2012 August A/P Office Supplies 8.90 686.22 OFFICE DEPOT, INC 31764 AP 1676 08/31/2012 August A/P Office Supplies 2.04 688.26 OFFICE DEPOT, INC 31764 AP 1676 08/31/2012 August A/P Office Supplies 6.63 694.89 OFFICE DEPOT, INC 31764 AP _______________ Account: 135-65085-038-000 Office Supplies Totals: 24.70 694.89 ** 700.00 Budgeted 5.11 Remaining 99 % Used Account: 135-65105-038-000 Printing .00 .00 _______________ Account: 135-65105-038-000 Printing Totals: .00 .00 ** 3,250.00 Budgeted 3,250.00 Remaining 0 % Used Department 38 Totals: ------------------------------------------------------------------------------------------------ 177,679.40 ** 211,405.00 Budgeted 33,725.60 Remaining 84 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 75 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 8/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 1531 08/14/2012 Aug A/P July legal 71,476.79 2,135.46 73,612.25 WHITAKER CHALK SWINDLE 31721 AP 1531 08/14/2012 Aug A/P July legal 630.00 74,242.25 THE LISTON LAW FIRM, P.C. 31717 AP _______________ Account: 135-55045-039-000 Legal Totals: 2,765.46 74,242.25 ** 88,000.00 Budgeted 13,757.75 Remaining 84 % 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 13,615.43 .00 13,615.43 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 13,615.43 ** 20,000.00 Budgeted 6,384.57 Remaining 68 % Used Account: 135-55065-039-000 Tax Admin Fees 1495 08/06/2012 July A/P Deliquent tax statements 2,470.09 73.13 2,543.22 DENTON COUNTY TAX OFFICE 31677 AP _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: 73.13 2,543.22 ** 3,629.00 Budgeted 1,085.78 Remaining 70 % 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: ------------------------------------------------------------------------------------------------ 112,878.75 ** 134,107.00 Budgeted 21,228.25 Remaining 84 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (437,247.45) (370,880.00) Budgeted 66,367.45 Remaining 118 % Used Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 8/31/2012 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 785,284 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 21,671 ACCOUNTS RECEIVABLE - PID EMER SERVICES 5 OTHER RECEIVABLES 24,533 TOTAL ASSETS 831,493$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 21,676$ ACCOUNTS PAYABLE 330,818 TOTAL LIABILITIES 352,494$ FUND BALANCE ASSIGNED FUND BALANCE 23,101 UNASSIGNED FUND BALANCE 455,898 TOTAL LIABILITIES AND FUND BALANCE 831,493$ August 31, 2012 11/12 Months (92% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 19:41 09/11/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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- 32.33- 191,760.19- 99.238 1,472.81- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,900.00- 7,346.12- 149.921 2,446.12 122-40010-000-000 Property Taxes/MUD Fire 1,076,976.00- 1,076,976.00- 3,970.26- 1,073,202.39- 99.650 3,773.61- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,603.00- 4,643.15 -82.869 10,246.15- 122-40015-000-000 Property Taxes/Assessments P&I 725.00- 10.04- 2,259.22- 311.617 1,534.22 122-40020-000-000 Property Taxes/Fire P&I 7,500.00- 7,500.00- 729.42- 5,011.98- 66.826 2,488.02- 122-40970-000-000 Insurance Settlements 9,739.43- 9,739.43 Subtotal: 1,277,709.00- 1,288,937.00- 4,742.05- 1,284,676.18- 99.669 4,260.82- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 400.00- 10,000.00- 166.667 4,000.00 Subtotal: 6,000.00- 400.00- 10,000.00- 166.667 4,000.00 122-43400-000-000 Fire Inspections 500.00- 75.00- 1,875.00- 375.000 1,375.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- Subtotal: 11,124.00- 10,500.00- 75.00- 11,875.00- 113.095 1,375.00 122-49025-000-000 Auction Sales 1,902.50- 1,902.50 122-49035-000-000 Prior Year Reserves 23,101.00- 122-49900-000-000 Miscellaneous Income 9,122.00- 1,241.03 13,905.92- 152.444 4,783.92 122-49901-000-000 Records Management 5.00- 5.00 Subtotal: 23,101.00- 9,122.00- 1,241.03 15,813.42- 173.355 6,691.42 Program number: 1,311,934.00- 1,314,559.00- 3,976.02- 1,322,364.60- 100.594 7,805.60 Department number: Fire Revenues 1,311,934.00- 1,314,559.00- 3,976.02- 1,322,364.60- 100.594 7,805.60 Revenues Subtotal ----------- 1,311,934.00- 1,314,559.00- 3,976.02- 1,322,364.60- 100.594 7,805.60 . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 19:41 09/11/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 52,261.23 401,602.85 94.329 24,145.15 122-50010-045-000 Overtime 42,000.00 42,000.00 6,400.19 31,695.50 75.465 10,304.50 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 326.36 3,779.56 92.795 293.44 122-50020-045-000 Retirement 68,264.00 68,264.00 7,689.16 61,085.26 89.484 7,178.74 122-50026-045-000 Medical Insurance 53,184.00 53,184.00 3,473.58 37,044.33 69.653 16,139.67 122-50027-045-000 Dental Insurance 3,288.00 3,288.00 304.67 3,239.61 98.528 48.39 122-50028-045-000 Vision Insurance 857.00 857.00 68.99 697.75 81.418 159.25 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 3,465.15 26,605.33 88.007 3,625.67 122-50035-045-000 Medicare Taxes 7,070.00 7,070.00 810.38 6,222.22 88.009 847.78 122-50040-045-000 Unemployment Taxes 1,476.00 1,476.00 58.97 779.61 52.819 696.39 122-50045-045-000 Workman's Compensation 8,793.00 9,209.00 8,779.02 95.331 429.98 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 74,858.68 599,107.52 89.924 67,127.48 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 167.00 5,531.89 57.853 4,030.11 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 15,476.13 21,460.58 144.516 6,610.58- 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 39.95 6,818.05 69.515 2,989.95 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 1,099.26 7,306.05 66.419 3,693.95 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 786.00 71.260 317.00 122-55160-045-000 Professional Outside Services 20,000.00 19,623.00 142.69 .727 19,480.31 Subtotal: 66,323.00 65,946.00 16,782.34 42,045.26 63.757 23,900.74 122-60005-045-000 Telephone 106.00 106.00 9.73 46.95 44.292 59.05 122-60010-045-000 Communications/Pagers/Mobiles 4,411.00 4,411.00 430.46 2,211.01 50.125 2,199.99 122-60020-045-000 Electricity/Gas 18,270.00 18,270.00 2,027.77 11,353.72 62.144 6,916.28 122-60025-045-000 Water 3,289.00 3,289.00 768.66 3,135.11 95.321 153.89 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.00 46.55 47.990 50.45 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 113.85 113.85 28.392 287.15 122-60070-045-000 Dues & Memberships 8,560.00 8,560.00 6,650.34 77.691 1,909.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 783.79 3,917.96 56.406 3,028.04 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 20.38 2,938.72 43.293 3,849.28 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 1,130.94 3,772.49 90.641 389.51 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 136.00 704.26 37.066 1,195.74 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 19:41 09/11/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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,715.00 3,399.85 133.694 856.85- 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 86.62 911.53 73.689 325.47 Subtotal: 390,758.00 390,833.00 7,227.20 356,302.34 91.165 34,530.66 122-65005-045-000 Fuel & Lube 17,414.00 17,414.00 2,058.80 7,799.83 44.791 9,614.17 122-65010-045-000 Uniforms 4,357.00 4,357.00 418.00 3,953.78 90.745 403.22 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 6,900.50 90.796 699.50 122-65030-045-000 Chemicals 1,545.00 1,545.00 825.00 53.398 720.00 122-65035-045-000 Small Tools 8,371.00 8,371.00 255.46 2,007.60 23.983 6,363.40 122-65085-045-000 Office Supplies 329.00 1,200.00 144.37 777.01 64.751 422.99 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 51.95 1,916.64 68.820 868.36 122-65105-045-000 Printing 106.00 106.00 24.77 23.368 81.23 Subtotal: 42,507.00 43,378.00 2,928.58 24,205.13 55.800 19,172.87 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 248.69 9.948 2,251.31 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 68,351.65 73,203.30 100.000 .30- 122-69255-045-000 Airpacks 13,865.00 13,865.00 14,526.00 104.767 661.00- Subtotal: 148,167.00 148,167.00 68,351.65 101,311.08 68.376 46,855.92 Program number: 1,311,934.00 1,314,559.00 170,148.45 1,122,971.33 85.426 191,587.67 Department number: Fire 1,311,934.00 1,314,559.00 170,148.45 1,122,971.33 85.426 191,587.67 Expenditures Subtotal ----------- 1,311,934.00 1,314,559.00 170,148.45 1,122,971.33 85.426 191,587.67 Fund number: 122 Trophy Club MUD Fire Dept. 166,172.43 199,393.27- 199,393.27 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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 1643 08/10/2012 Property Tax/Assessments (191,727.86) (52.81) (191,780.67) GL 1644 08/13/2012 Property Tax/Assessments 20.48 (191,760.19) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (32.33) (191,760.19) ** (193,233.00) Budgeted (1,472.81) Remaining 99 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (7,346.12) .00 (7,346.12) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (7,346.12) ** (4,900.00) Budgeted 2,446.12 Remaining 150 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1633 08/01/2012 Property Tax/Assessment (1,069,232.13) (89.04) (1,069,321.17) GL 1635 08/02/2012 Property Tax/Assessments (73.31) (1,069,394.48) GL 1636 08/03/2012 Property Tax/Assessments (31.56) (1,069,426.04) GL 1637 08/06/2012 Property Tax/Assessments (227.78) (1,069,653.82) GL 1639 08/08/2012 Property Tax/Assessments 209.39 (1,069,444.43) GL 1640 08/09/2012 Property Tax/Assessments (62.50) (1,069,506.93) GL 1641 08/17/2012 Property Tax/Assessments (261.15) (1,069,768.08) GL 1642 08/30/2012 Property Tax/Assessments (3,434.31) (1,073,202.39) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,970.26) (1,073,202.39) ** (1,076,976.00) Budgeted (3,773.61) Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1633 08/01/2012 Property Tax/Assessment 4,643.15 (405.29) 4,237.86 GL 1638 08/07/2012 Property Tax/Assessments 405.29 4,643.15 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: .00 4,643.15 ** (5,603.00) Budgeted (10,246.15) Remaining -83 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1643 08/10/2012 Property Tax/Assessments (2,249.18) (10.04) (2,259.22) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (10.04) (2,259.22) ** (725.00) Budgeted 1,534.22 Remaining 312 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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-40020-000-000 Property Taxes/Fire P&I 1633 08/01/2012 Property Tax/Assessment (4,282.56) (195.27) (4,477.83) GL 1635 08/02/2012 Property Tax/Assessments (13.20) (4,491.03) GL 1636 08/03/2012 Property Tax/Assessments (2.21) (4,493.24) GL 1638 08/07/2012 Property Tax/Assessments 195.27 (4,297.97) GL 1640 08/09/2012 Property Tax/Assessments (11.88) (4,309.85) GL 1641 08/17/2012 Property Tax/Assessments (49.62) (4,359.47) GL 1642 08/30/2012 Property Tax/Assessments (652.51) (5,011.98) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (729.42) (5,011.98) ** (7,500.00) Budgeted (2,488.02) Remaining 67 % Used Account: 122-40970-000-000 Insurance Settlements (9,739.43) .00 (9,739.43) _______________ Account: 122-40970-000-000 Insurance Settlements Totals: .00 (9,739.43) ** .00 Budgeted 9,739.43 Remaining 0 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1657 08/24/2012 Permits 8/24/12 (9,600.00) (400.00) (10,000.00) GL _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (10,000.00) ** (6,000.00) Budgeted 4,000.00 Remaining 167 % Used Account: 122-43400-000-000 Fire Inspections 1657 08/24/2012 Permits 8/24/12 (1,800.00) (75.00) (1,875.00) GL _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (1,875.00) ** (500.00) Budgeted 1,375.00 Remaining 375 % Used Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire (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-49025-000-000 Auction Sales (1,902.50) .00 (1,902.50) . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 8/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-49025-000-000 Auction Sales Totals: .00 (1,902.50) ** .00 Budgeted 1,902.50 Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 1606 08/22/2012 Wildfire Reduction pmt/OT (15,146.95) 2,166.03 (12,980.92) GL 1655 08/22/2012 Permits 8/22/12 (100.00) (13,080.92) GL 1656 08/23/2012 Permits 8/23/12 (100.00) (13,180.92) GL 1657 08/24/2012 Permits 8/24/12 (725.00) (13,905.92) GL _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: 1,241.03 (13,905.92) ** (9,122.00) Budgeted 4,783.92 Remaining 152 % Used Account: 122-49901-000-000 Records Management (5.00) .00 (5.00) _______________ Account: 122-49901-000-000 Records Management Totals: .00 (5.00) ** .00 Budgeted 5.00 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,322,364.60) ** (1,314,559.00) Budgeted 7,805.60 Remaining 101 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 1634 08/03/2012 8/3/12 Payroll 349,341.62 17,192.72 366,534.34 GL 1646 08/17/2012 8/17/12 Payroll 17,466.24 384,000.58 GL 1660 08/31/2012 8/31/12 Payroll 17,602.27 401,602.85 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 52,261.23 401,602.85 ** 425,748.00 Budgeted 24,145.15 Remaining 94 % Used Account: 122-50010-045-000 Overtime 1634 08/03/2012 8/3/12 Payroll 25,295.31 2,975.25 28,270.56 GL 1660 08/31/2012 8/31/12 Payroll 3,424.94 31,695.50 GL _______________ Account: 122-50010-045-000 Overtime Totals: 6,400.19 31,695.50 ** 42,000.00 Budgeted 10,304.50 Remaining 75 % 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 1646 08/17/2012 8/17/12 Payroll 3,453.20 326.36 3,779.56 GL _______________ Account: 122-50017-045-000 Certification Totals: 326.36 3,779.56 ** 4,073.00 Budgeted 293.44 Remaining 93 % Used Account: 122-50020-045-000 Retirement 1634 08/03/2012 8/3/12 Payroll 53,396.10 2,673.55 56,069.65 GL 1646 08/17/2012 8/17/12 Payroll 2,284.54 58,354.19 GL 1660 08/31/2012 8/31/12 Payroll 2,731.07 61,085.26 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-50020-045-000 Retirement Totals: 7,689.16 61,085.26 ** 68,264.00 Budgeted 7,178.74 Remaining 89 % Used Account: 122-50026-045-000 Medical Insurance 1634 08/03/2012 8/3/12 Payroll 33,570.75 1,736.81 35,307.56 GL 1646 08/17/2012 8/17/12 Payroll 1,736.77 37,044.33 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,473.58 37,044.33 ** 53,184.00 Budgeted 16,139.67 Remaining 70 % Used Account: 122-50027-045-000 Dental Insurance 1634 08/03/2012 8/3/12 Payroll 2,934.94 152.36 3,087.30 GL 1646 08/17/2012 8/17/12 Payroll 152.31 3,239.61 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 304.67 3,239.61 ** 3,288.00 Budgeted 48.39 Remaining 99 % Used Account: 122-50028-045-000 Vision Insurance 1634 08/03/2012 8/3/12 Payroll 628.76 34.49 663.25 GL 1646 08/17/2012 8/17/12 Payroll 34.50 697.75 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 68.99 697.75 ** 857.00 Budgeted 159.25 Remaining 81 % 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 1634 08/03/2012 8/3/12 Payroll 23,140.18 1,152.13 24,292.31 GL 1646 08/17/2012 8/17/12 Payroll 1,009.32 25,301.63 GL 1660 08/31/2012 8/31/12 Payroll 1,303.70 26,605.33 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 3,465.15 26,605.33 ** 30,231.00 Budgeted 3,625.67 Remaining 88 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 1634 08/03/2012 8/3/12 Payroll 5,411.84 269.45 5,681.29 GL 1646 08/17/2012 8/17/12 Payroll 236.05 5,917.34 GL 1660 08/31/2012 8/31/12 Payroll 304.88 6,222.22 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 810.38 6,222.22 ** 7,070.00 Budgeted 847.78 Remaining 88 % Used Account: 122-50040-045-000 Unemployment Taxes 1634 08/03/2012 8/3/12 Payroll 720.64 14.30 734.94 GL 1646 08/17/2012 8/17/12 Payroll 25.07 760.01 GL 1660 08/31/2012 8/31/12 Payroll 19.60 779.61 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 58.97 779.61 ** 1,476.00 Budgeted 696.39 Remaining 53 % Used Account: 122-50045-045-000 Workman's Compensation 8,779.02 .00 8,779.02 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 8,779.02 ** 9,209.00 Budgeted 429.98 Remaining 95 % 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 1531 08/14/2012 Aug A/P July PCards/Hurd 5,364.89 167.00 5,531.89 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 167.00 5,531.89 ** 9,562.00 Budgeted 4,030.11 Remaining 58 % Used Account: 122-55090-045-000 Vehicle Maintenance 1683 08/31/2012 Aug A/P QUINT REPAIR 5,984.45 14,180.45 20,164.90 INDUSTRIAL POWER TRUCK & EQUIP 31755 AP 1683 08/31/2012 Aug A/P Quint repair 1,295.68 21,460.58 INDUSTRIAL POWER TRUCK & EQUIP 31755 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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: 15,476.13 21,460.58 ** 14,850.00 Budgeted (6,610.58) Remaining 145 % Used Account: 122-55095-045-000 Equipment Maintenance 1531 08/14/2012 Aug A/P 6,778.10 80.76 6,858.86 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P (80.76) 6,778.10 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P 39.95 6,818.05 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: 39.95 6,818.05 ** 9,808.00 Budgeted 2,989.95 Remaining 70 % Used Account: 122-55100-045-000 Building Maintenance 1531 08/14/2012 Aug A/P Pest control/Fire Station 6,206.79 140.00 6,346.79 GANN'S PEST CONTROL 31705 AP 1531 08/14/2012 Aug A/P July PCards/Hurd 24.67 6,371.46 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Hurd 78.60 6,450.06 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Sipes 76.71 6,526.77 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCard/Sipes 14.36 6,541.13 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P 128.41 6,669.54 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P 280.45 6,949.99 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P 157.14 7,107.13 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P 152.56 7,259.69 JPMORGAN CHASE BANK NA 31708 AP 1541 08/16/2012 Aug A/P July PCards/Schultz 46.36 7,306.05 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 122-55100-045-000 Building Maintenance Totals: 1,099.26 7,306.05 ** 11,000.00 Budgeted 3,693.95 Remaining 66 % Used Account: 122-55110-045-000 Maintenance-Radios 786.00 .00 786.00 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 786.00 ** 1,103.00 Budgeted 317.00 Remaining 71 % Used Account: 122-55160-045-000 Professional Outside Services 142.69 .00 142.69 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 142.69 ** 19,623.00 Budgeted 19,480.31 Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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 1495 08/06/2012 July A/P Pcards-Zieverink 37.22 3.24 40.46 BANK OF AMERICA 31672 AP 1676 08/31/2012 August A/P PCards/Zieverink 6.49 46.95 BANK OF AMERICA 31744 AP _______________ Account: 122-60005-045-000 Telephone Totals: 9.73 46.95 ** 106.00 Budgeted 59.05 Remaining 44 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1495 08/06/2012 July A/P Cells 1,780.55 140.05 1,920.60 VERIZON WIRELESS 31698 AP 1646 08/17/2012 8/17/12 Payroll 150.00 2,070.60 GL 1693 08/31/2012 Aug A/P Wireless voice/data phones 140.41 2,211.01 VERIZON WIRELESS 31777 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 430.46 2,211.01 ** 4,411.00 Budgeted 2,199.99 Remaining 50 % Used Account: 122-60020-045-000 Electricity/Gas 1495 08/06/2012 July A/P Gas/Fire Station 6/15-7/20 9,325.95 33.77 9,359.72 ATMOS ENERGY 31671 AP 1573 08/22/2012 Aug A/P Electricity 7/2-8/14 1,940.14 11,299.86 HUDSON ENERGY 31726 AP 1676 08/31/2012 August A/P Gas 7/20-8/17 53.86 11,353.72 ATMOS ENERGY 31742 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 2,027.77 11,353.72 ** 18,270.00 Budgeted 6,916.28 Remaining 62 % Used Account: 122-60025-045-000 Water 1495 08/06/2012 July A/P July Water 2,366.45 110.32 2,476.77 TROPHY CLUB MUD (WATER BILLS) 31696 AP 1495 08/06/2012 July A/P July Water 249.66 2,726.43 TROPHY CLUB MUD (WATER BILLS) 31696 AP 1676 08/31/2012 August A/P August Water 408.68 3,135.11 TROPHY CLUB MUD (WATER BILLS) 31769 AP _______________ Account: 122-60025-045-000 Water Totals: 768.66 3,135.11 ** 3,289.00 Budgeted 153.89 Remaining 95 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1625 08/31/2012 August Postage meter 42.55 4.00 46.55 GL _______________ Account: 122-60035-045-000 Postage Totals: 4.00 46.55 ** 97.00 Budgeted 50.45 Remaining 48 % Used Account: 122-60055-045-000 Insurance 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 1531 08/14/2012 Aug A/P July PCards/Hurd 113.85 113.85 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: 113.85 113.85 ** 401.00 Budgeted 287.15 Remaining 28 % Used Account: 122-60070-045-000 Dues & Memberships 6,650.34 .00 6,650.34 _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 6,650.34 ** 8,560.00 Budgeted 1,909.66 Remaining 78 % 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 1495 08/06/2012 July A/P Boos/Fire Instructor I 3,134.17 150.00 3,284.17 TARRANT COUNTY COLLEGE 31693 AP 1495 08/06/2012 July A/P Rader/CIT Update 66.00 3,350.17 TARRANT COUNTY COLLEGE 31693 AP 1495 08/06/2012 July A/P CRS Renewals 110.00 3,460.17 NEFDA 31688 AP 1531 08/14/2012 Aug A/P Office/Training supplies 46.79 3,506.96 OFFICE DEPOT, INC 31713 AP 1531 08/14/2012 Aug A/P Reimb for TCFP State Cert Fee 85.00 3,591.96 GREGORY BOOS 31706 AP 1531 08/14/2012 Aug A/P 260.00 3,851.96 JPMORGAN CHASE BANK NA 31708 AP 1676 08/31/2012 August A/P Fire Training/Rader, Thomas 66.00 3,917.96 TARRANT COUNTY COLLEGE 31768 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-60080-045-000 Schools & Training Totals: 783.79 3,917.96 ** 6,946.00 Budgeted 3,028.04 Remaining 56 % 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 1531 08/14/2012 Aug A/P 2,918.34 20.38 2,938.72 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 122-60100-045-000 Travel & per diem Totals: 20.38 2,938.72 ** 6,788.00 Budgeted 3,849.28 Remaining 43 % 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 1495 08/06/2012 July A/P Tshirts 2,641.55 395.25 3,036.80 ALL STAR SCREEN PRINTING & TEE 31669 AP 1531 08/14/2012 Aug A/P July purchases 113.21 3,150.01 COSTCO WHOLESALE 31701 AP 1531 08/14/2012 Aug A/P July PCards/Beck 58.48 3,208.49 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P Kid's Fire Safety items 564.00 3,772.49 NATIONAL FIRE SAFETY COUNCIL 31711 AP _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 1,130.94 3,772.49 ** 4,162.00 Budgeted 389.51 Remaining 91 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1531 08/14/2012 Aug A/P Rader/Thomas Inspection/Enforc 568.26 136.00 704.26 TARRANT COUNTY COLLEGE 31715 AP _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 136.00 704.26 ** 1,900.00 Budgeted 1,195.74 Remaining 37 % Used Account: 122-60195-045-000 Flags & Repair 1495 08/06/2012 July A/P On site flag repair 1,684.85 75.00 1,759.85 SYMONDS FLAGS & POLES 31692 AP 1676 08/31/2012 August A/P Flag repair 1,640.00 3,399.85 SYMONDS FLAGS & POLES 31767 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 1,715.00 3,399.85 ** 2,543.00 Budgeted (856.85) Remaining 134 % Used Account: 122-60245-045-000 Miscellaneous Expense 1531 08/14/2012 Aug A/P July PCard/Sipes 824.91 57.82 882.73 JPMORGAN CHASE BANK NA 31708 AP 1676 08/31/2012 August A/P Office Supplies 28.80 911.53 OFFICE DEPOT, INC 31764 AP _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 86.62 911.53 ** 1,237.00 Budgeted 325.47 Remaining 74 % Used Account: 122-65005-045-000 Fuel & Lube 1624 08/01/2012 July Gas Log 5,741.03 914.70 6,655.73 GL 1697 08/31/2012 August Gas Log 1,144.10 7,799.83 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 2,058.80 7,799.83 ** 17,414.00 Budgeted 9,614.17 Remaining 45 % Used Account: 122-65010-045-000 Uniforms 1531 08/14/2012 Aug A/P July PCards/Beck 3,535.78 313.50 3,849.28 JPMORGAN CHASE BANK NA 31708 AP 1531 08/14/2012 Aug A/P July PCards/Beck 104.50 3,953.78 JPMORGAN CHASE BANK NA 31708 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 418.00 3,953.78 ** 4,357.00 Budgeted 403.22 Remaining 91 % Used Account: 122-65015-045-000 Protective Clothing 6,900.50 .00 6,900.50 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 6,900.50 ** 7,600.00 Budgeted 699.50 Remaining 91 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-65030-045-000 Chemicals 825.00 .00 825.00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 825.00 ** 1,545.00 Budgeted 720.00 Remaining 53 % Used Account: 122-65035-045-000 Small Tools 1540 08/16/2012 Aug A/P Tool Drawer 1,752.14 216.46 1,968.60 NATIONAL BUSINESS FURNITURE 31710 AP 1573 08/22/2012 Aug A/P Shipping charges/tool drawers 39.00 2,007.60 NATIONAL BUSINESS FURNITURE 31731 AP _______________ Account: 122-65035-045-000 Small Tools Totals: 255.46 2,007.60 ** 8,371.00 Budgeted 6,363.40 Remaining 24 % Used Account: 122-65085-045-000 Office Supplies 1541 08/16/2012 Aug A/P Office Supplies 632.64 44.38 677.02 OFFICE DEPOT, INC 31713 AP 1541 08/16/2012 Aug A/P Shredder 99.99 777.01 OFFICE DEPOT, INC 31713 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 144.37 777.01 ** 1,200.00 Budgeted 422.99 Remaining 65 % Used Account: 122-65095-045-000 Maintenance Supplies 1531 08/14/2012 Aug A/P July purchases 1,864.69 7.18 1,871.87 COSTCO WHOLESALE 31701 AP 1531 08/14/2012 Aug A/P July purchases 44.77 1,916.64 COSTCO WHOLESALE 31701 AP _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 51.95 1,916.64 ** 2,785.00 Budgeted 868.36 Remaining 69 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 8/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-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 Account: 122-69050-045-000 Radios 248.69 .00 248.69 _______________ Account: 122-69050-045-000 Radios Totals: .00 248.69 ** 2,500.00 Budgeted 2,251.31 Remaining 10 % 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 1672 08/27/2012 Bond/CO payments TC Tx Pub Prop Fin 2007 4,851.65 68,351.65 73,203.30 GL _______________ Account: 122-69251-045-000 Engine 681 Payment Totals: 68,351.65 73,203.30 ** 73,203.00 Budgeted (.30) Remaining 100 % Used Account: 122-69255-045-000 Airpacks 14,526.00 .00 14,526.00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 14,526.00 ** 13,865.00 Budgeted (661.00) Remaining 105 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 1,122,971.33 ** 1,314,559.00 Budgeted 191,587.67 Remaining 85 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (199,393.27) .00 Budgeted 199,393.27 Remaining 0 % Used Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 8/31/2012 ASSETS ASSETS CASH AND CASH IN BANK 6,120$ INVESTMENTS 128,795 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 17,742 TOTAL ASSETS 152,657$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 17,742$ TOTAL LIABILITIES 17,742 FUND BALANCE ASSIGNED FUND BALANCE 134,915 TOTAL LIABILITIES AND FUND BALANCE 152,657$ August 31, 2012 11/12 Months (92% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 19:41 09/11/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 8/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,030.02- 548,733.60- 100.369 2,017.60 533-40002-000-000 Property Taxes/Delinquent 3,947.00- 2,449.86 -62.069 6,396.86- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 372.48- 3,043.40- 60.662 1,973.60- Subtotal: 555,680.00- 555,680.00- 2,402.50- 549,327.14- 98.857 6,352.86- 533-48005-000-000 Utility Fees 6,120.00- 6,120.00- 6,120.00- 100.000 Subtotal: 6,120.00- 6,120.00- 6,120.00- 100.000 533-49010-000-000 Interest Income 500.00- 1,700.00- 78.60- 1,277.03- 75.119 422.97- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- 100.000 533-49110-000-000 Premium on Bonds Sold 4,661.84- 4,661.84 Subtotal: 308,500.00- 309,700.00- 78.60- 313,938.87- 101.369 4,238.87 Program number: 870,300.00- 871,500.00- 2,481.10- 869,386.01- 99.757 2,113.99- Department number: Revenues 870,300.00- 871,500.00- 2,481.10- 869,386.01- 99.757 2,113.99- Revenues Subtotal ----------- 870,300.00- 871,500.00- 2,481.10- 869,386.01- 99.757 2,113.99- . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 19:41 09/11/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 8/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 1,800.00 45.000 2,200.00 533-70025-051-000 Bond Interest Expense 301,300.00 301,300.00 124,868.75 275,518.75 91.443 25,781.25 533-70035-051-000 Bond Principal Payment 565,000.00 565,000.00 565,000.00 565,000.00 100.000 Subtotal: 870,300.00 870,300.00 689,868.75 842,318.75 96.785 27,981.25 Program number: 870,300.00 870,300.00 689,868.75 842,318.75 96.785 27,981.25 Department number: Administration 870,300.00 870,300.00 689,868.75 842,318.75 96.785 27,981.25 Expenditures Subtotal ----------- 870,300.00 870,300.00 689,868.75 842,318.75 96.785 27,981.25 Fund number: 533 MUD 1 I&S CONSOLIDATED 1,200.00- 687,387.65 27,067.26- 2,255.605 25,867.26 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 76 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 8/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 1633 08/01/2012 Property Tax/Assessment (546,703.58) (45.53) (546,749.11) GL 1635 08/02/2012 Property Tax/Assessments (37.48) (546,786.59) GL 1636 08/03/2012 Property Tax/Assessments (16.14) (546,802.73) GL 1637 08/06/2012 Property Tax/Assessments (116.47) (546,919.20) GL 1639 08/08/2012 Property Tax/Assessments 107.06 (546,812.14) GL 1640 08/09/2012 Property Tax/Assessments (31.96) (546,844.10) GL 1641 08/17/2012 Property Tax/Assessments (133.52) (546,977.62) GL 1642 08/30/2012 Property Tax/Assessments (1,755.98) (548,733.60) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (2,030.02) (548,733.60) ** (546,716.00) Budgeted 2,017.60 Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1633 08/01/2012 Property Tax/Assessment 2,449.86 (293.24) 2,156.62 GL 1638 08/07/2012 Property Tax/Assessments 293.24 2,449.86 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: .00 2,449.86 ** (3,947.00) Budgeted (6,396.86) Remaining -62 % Used Account: 533-40015-000-000 Property Taxes/P & I 1633 08/01/2012 Property Tax/Assessment (2,670.92) (143.51) (2,814.43) GL 1677 08/01/2012 Correct JE 1458/AV Taxes .50 (2,813.93) GL 1635 08/02/2012 Property Tax/Assessments (6.75) (2,820.68) GL 1636 08/03/2012 Property Tax/Assessments (1.13) (2,821.81) GL 1638 08/07/2012 Property Tax/Assessments 143.51 (2,678.30) GL 1640 08/09/2012 Property Tax/Assessments (6.07) (2,684.37) GL 1641 08/17/2012 Property Tax/Assessments (25.37) (2,709.74) GL 1642 08/30/2012 Property Tax/Assessments (333.66) (3,043.40) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (372.48) (3,043.40) ** (5,017.00) Budgeted (1,973.60) Remaining 61 % Used Account: 533-48005-000-000 Utility Fees (6,120.00) .00 (6,120.00) _______________ Account: 533-48005-000-000 Utility Fees Totals: .00 (6,120.00) ** (6,120.00) Budgeted .00 Remaining 100 % Used Account: 533-49010-000-000 Interest Income . glpdatb2 rgonzale Trophy Club MUD #1 Page 77 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 8/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1626 08/31/2012 August Bank Interest (1,198.43) (78.60) (1,277.03) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (78.60) (1,277.03) ** (1,700.00) Budgeted (422.97) Remaining 75 % 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) ** (308,000.00) Budgeted .00 Remaining 100 % 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: ------------------------------------------------------------------------------------------------ (869,386.01) ** (871,500.00) Budgeted (2,113.99) Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 78 19:42 09/11/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 8/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 1,800.00 .00 1,800.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,800.00 ** 4,000.00 Budgeted 2,200.00 Remaining 45 % Used Account: 533-70025-051-000 Bond Interest Expense 1672 08/27/2012 Bond/CO payments TCMUD1 Series 12 150,650.00 30,375.00 181,025.00 GL 1672 08/27/2012 Bond/CO payments TCMUDREF05 34,342.50 215,367.50 GL 1672 08/27/2012 Bond/CO payments TCMUD1-10 40,366.25 255,733.75 GL 1672 08/27/2012 Bond/CO payments TROPHYCLUB23 3,177.50 258,911.25 GL 1672 08/27/2012 Bond/CO payments TROPHYCBD203 16,607.50 275,518.75 GL _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: 124,868.75 275,518.75 ** 301,300.00 Budgeted 25,781.25 Remaining 91 % Used Account: 533-70035-051-000 Bond Principal Payment 1672 08/27/2012 Bond/CO payments TCMUDREF05 290,000.00 290,000.00 GL 1672 08/27/2012 Bond/CO payments TCMUD1-10 65,000.00 355,000.00 GL 1672 08/27/2012 Bond/CO payments TROPHYCLUB23 155,000.00 510,000.00 GL 1672 08/27/2012 Bond/CO payments TROPHYCBD203 55,000.00 565,000.00 GL _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: 565,000.00 565,000.00 ** 565,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 842,318.75 ** 870,300.00 Budgeted 27,981.25 Remaining 97 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (27,067.26) (1,200.00) Budgeted 25,867.26 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (663,707.98) **** (372,080.00) Budgeted 291,627.98 Remaining 178 % Used ******* End of Report *********