Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
September 2012 MUD Financials
Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 9/30/2012 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 678,371 INVESTMENTS 2,222,415 RESTRICTED ASSETS: INVESTMENTS 426,041 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 2,646 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,316,061 TOTAL ASSETS 4,645,934$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,646$ ACCOUNTS PAYABLE 696,981 CUSTOMER DEPOSITS 206,627 TOTAL LIABILITIES 906,254 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,933,769 TOTAL FUND BALANCE 3,739,680 TOTAL LIABILITIES AND FUND BALANCE 4,645,934$ September 30, 2012 12/12 Months (100% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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- 203.70- 97,356.72- 99.858 138.28- 135-40002-000-000 Property Taxes/Delinquent 451.00- 17.50- 542.69 -120.330 993.69- 135-40015-000-000 Property Taxes/P & I 1,334.00- 200.00- 10.51- 243.55- 121.775 43.55 Subtotal: 98,829.00- 98,146.00- 231.71- 97,057.58- 98.891 1,088.42- 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- 209,374.42- 1,846,859.56- 92.770 143,940.44- 135-47005-000-000 Sewer 1,325,000.00- 1,325,000.00- 104,476.87- 1,053,518.19- 79.511 271,481.81- 135-47010-000-000 Commercial Water 825,000.00- 825,000.00- 102,930.38- 842,890.21- 102.169 17,890.21 135-47015-000-000 Commercial Sewer 360,000.00- 360,000.00- 26,331.87- 291,058.24- 80.850 68,941.76- 135-47020-000-000 Standby 775.00- 775.00- 54.00- 697.35- 89.981 77.65- 135-47025-000-000 Penalties 50,500.00- 45,000.00- 6,056.35- 56,444.31- 125.432 11,444.31 135-47030-000-000 Service Charges 17,500.00- 15,000.00- 1,053.00- 11,213.48- 74.757 3,786.52- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,500.00- 2,000.00- 133.333 500.00 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 300.00- 6,300.00- 140.000 1,800.00 135-47070-000-000 TCCC Effluent Charges 57,500.00- 75,000.00- 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,587.46- 37,686.01- 90.602 3,908.99- 135-47405-000-000 Out of District Sewer 11,807.00- 11,807.00- 905.27- 11,970.92- 101.388 163.92 135-47410-000-000 Out of Dist/Portable Penalties 300.00- 100.00- 56.77- 56.770 43.23- 135-47600-000-000 PID #1 Water 425,000.00- 500,000.00- 79,148.15- 615,798.76- 123.160 115,798.76 135-47605-000-000 PID #1 Sewer 185,000.00- 250,000.00- 34,360.19- 280,403.52- 112.161 30,403.52 Subtotal: 5,301,477.00- 5,446,077.00- 567,577.96- 5,113,389.61- 93.891 332,687.39- 135-48005-000-000 Utility Fees 338,880.00- 621,000.00- 69,000.00- 647,080.00- 104.200 26,080.00 Subtotal: 338,880.00- 621,000.00- 69,000.00- 647,080.00- 104.200 26,080.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- 558.01- 5,705.68- 126.793 1,205.68 135-49016-000-000 Cell Tower Revenue 10,164.00- 847.00- 10,164.00- 100.000 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 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- 14.60- 564.84- 94.140 35.16- 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- 15,072.94- 109,435.99- 140.663 31,635.99 135-49900-000-000 Miscellaneous Income 10,000.00- 5,400.00- 100.00- 6,518.82- 120.719 1,118.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 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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- 16,592.55- 1,243,233.96- 94.625 70,624.04- Program number: 6,094,978.00- 7,483,080.00- 653,402.22- 7,104,760.15- 94.944 378,319.85- Department number: Revenues 6,094,978.00- 7,483,080.00- 653,402.22- 7,104,760.15- 94.944 378,319.85- Revenues Subtotal ----------- 6,094,978.00- 7,483,080.00- 653,402.22- 7,104,760.15- 94.944 378,319.85- . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 12,793.62 157,930.80 98.338 2,669.20 135-50010-010-000 Overtime 13,250.00 13,250.00 2,689.95 21,479.05 162.106 8,229.05- 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 275.00 1,625.00 90.278 175.00 135-50020-010-000 Retirement 25,508.00 25,508.00 2,177.83 25,963.06 101.784 455.06- 135-50026-010-000 Medical Insurance 22,607.00 22,607.00 1,642.80 20,372.09 90.114 2,234.91 135-50027-010-000 Dental Insurance 2,169.00 2,169.00 125.20 1,509.94 69.615 659.06 135-50028-010-000 Vision Insurance 576.00 576.00 31.76 372.13 64.606 203.87 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 952.60 11,143.08 92.859 856.92 135-50035-010-000 Medicare Taxes 3,153.00 2,700.00 222.77 2,606.01 96.519 93.99 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 20,911.53 251,608.80 99.818 458.20 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 2,288.49 19,068.63 64.639 10,431.37 135-55090-010-000 Vehicle Maintenance 3,380.00 3,380.00 140.60 3,901.16 115.419 521.16- 135-55100-010-000 Building Maint & Supplies 750.00 750.00 365.33 3,815.79 508.772 3,065.79- 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 888.00 4,103.95 91.199 396.05 Subtotal: 43,030.00 41,530.00 3,682.42 31,354.02 75.497 10,175.98 135-60010-010-000 Communications/Pagers/Mobiles 1,599.00 2,100.00 1,889.95 89.998 210.05 135-60020-010-000 Electricity 162,000.00 100,000.00 16,610.23 105,294.89 105.295 5,294.89- 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 917.14 7,204.37 171.533 3,004.37- 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 221.00 332.00 221.333 182.00- 135-60080-010-000 Schools & Training 2,800.00 2,800.00 525.00 1,718.00 61.357 1,082.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 111.56 1,649.23 51.538 1,550.77 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 TCEQ Fees & Permits 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 229,516.49 1,660,348.27 96.532 59,651.73 135-60245-010-000 Miscellaneous Expenses 1,000.00 500.00 136.97 27.394 363.03 135-60280-010-000 Property Maintenance 4,200.00 2,200.00 153.80 760.59 34.572 1,439.41 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 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 248,055.22 1,788,923.17 96.781 59,499.83 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 58.35 13,679.19 89.900 1,536.81 135-65010-010-000 Uniforms 3,690.00 3,690.00 1,615.72 43.786 2,074.28 135-65030-010-000 Chemicals 6,200.00 5,000.00 1,688.59 5,497.65 109.953 497.65- 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 6,060.00 103,830.57 103.831 3,830.57- 135-65055-010-000 Hardware 1,000.00 1,000.00 1,000.00 135-65085-010-000 Office Supplies 30.00 43.47 73.47 244.900 43.47- 135-65095-010-000 Maintenance Supplies 32,000.00 32,000.00 904.69 21,888.74 68.402 10,111.26 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 8,755.10 147,296.43 92.270 12,339.57 135-69005-010-000 Capital Expenses 888,432.00 1,455,600.00 39,174.68 1,344,382.82 92.359 111,217.18 135-69008-010-000 Short Term Debt Payments 421,050.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 39,174.68 1,902,693.76 91.825 169,383.24 Program number: 3,501,238.00 4,373,733.00 320,578.95 4,121,876.18 94.242 251,856.82 Department number: Water 3,501,238.00 4,373,733.00 320,578.95 4,121,876.18 94.242 251,856.82 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 14,224.10 190,542.44 104.609 8,395.44- 135-50010-020-000 Overtime 10,166.00 10,166.00 1,744.82 14,227.59 139.953 4,061.59- 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 300.00 1,500.00 62.500 900.00 135-50020-020-000 Retirement 27,816.00 27,816.00 2,248.38 29,716.61 106.833 1,900.61- 135-50026-020-000 Medical Insurance 30,805.00 30,805.00 2,360.69 26,478.56 85.955 4,326.44 135-50027-020-000 Dental Insurance 1,981.00 1,981.00 175.84 2,016.24 101.779 35.24- 135-50028-020-000 Vision Insurance 552.00 552.00 45.92 508.34 92.091 43.66 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 884.38 11,936.84 105.701 643.84- 135-50035-020-000 Medicare Taxes 2,011.00 2,645.00 206.82 2,791.63 105.544 146.63- 135-50040-020-000 Unemployment Taxes 567.00 567.00 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 22,190.95 287,089.40 103.096 8,622.40- 135-55070-020-000 Independent Labor 750.00 32,000.00 3,082.50 19,988.17 62.463 12,011.83 135-55080-020-000 Maintenance & Repairs 17,750.00 43,000.00 1,087.54 45,042.56 104.750 2,042.56- 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 441.13 763.48 54.534 636.52 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 35,836.33 102.390 836.33- 135-55135-020-000 Lab Analysis 22,760.00 25,000.00 1,960.00 22,776.62 91.106 2,223.38 Subtotal: 85,608.00 140,850.00 6,571.17 124,958.59 88.717 15,891.41 135-60005-020-000 Telephone 100.00 64.70 64.700 35.30 135-60010-020-000 Communications/Pagers/Mobiles 3,000.00 3,000.00 2,464.55 82.152 535.45 135-60020-020-000 Electricity 205,000.00 110,000.00 11,331.51 87,547.91 79.589 22,452.09 135-60025-020-000 Water 1,900.00 1,900.00 29.77 1,754.26 92.329 145.74 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 200.00 703.50 53.295 616.50 135-60090-020-000 Safety Program 200.00 200.00 399.96 516.41 258.205 316.41- 135-60100-020-000 Travel & per diem 1,750.00 1,750.00 297.48 2,079.59 118.834 329.59- 135-60105-020-000 Rent/Lease Equipment 200.00 200.00 1,020.00 1,921.30 960.650 1,721.30- 135-60125-020-000 Advertising 1,500.00 1,152.36 76.824 347.64 135-60135-020-000 TCEQ Fees & Permits 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 13,278.72 106,235.06 82.263 22,904.94 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 5,021.23 73.036 1,853.77 135-65010-020-000 Uniforms 3,140.00 3,140.00 1,734.22 55.230 1,405.78 135-65030-020-000 Chemicals 13,180.00 13,180.00 900.00 8,699.63 66.006 4,480.37 135-65035-020-000 Small Tools 1,260.00 1,260.00 1,194.87 1,324.54 105.122 64.54- 135-65040-020-000 Safety Equipment 925.00 925.00 841.49 90.972 83.51 135-65045-020-000 Lab Supplies 19,160.00 12,000.00 3,910.00 11,591.16 96.593 408.84 135-65055-020-000 Hardware 525.00 525.00 525.00 135-65085-020-000 Office Supplies 400.00 400.00 1,029.66 257.415 629.66- 135-65095-020-000 Maintenance Supplies 8,860.00 8,860.00 269.46 8,718.43 98.402 141.57 135-65115-020-000 Other Consumables 110.00 110.00 8.69 7.900 101.31 Subtotal: 54,435.00 47,275.00 6,274.33 38,969.05 82.431 8,305.95 135-69005-020-000 Capital Expenses 161,189.00 111,021.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 9,665.29 19,845.66 35.439 36,154.34 Subtotal: 217,189.00 285,752.00 9,665.29 213,539.07 74.729 72,212.93 Program number: 854,709.00 881,484.00 57,980.46 770,791.17 87.442 110,692.83 Department number: Wastewater 854,709.00 881,484.00 57,980.46 770,791.17 87.442 110,692.83 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/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 11,297.66 140,594.30 96.641 4,886.70 135-50010-021-000 Overtime 7,297.00 7,297.00 696.45 10,546.65 144.534 3,249.65- 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 150.00 1,225.00 81.667 275.00 135-50020-021-000 Retirement 21,074.00 21,074.00 1,685.21 22,088.81 104.815 1,014.81- 135-50026-021-000 Medical Insurance 22,983.00 22,983.00 1,702.68 19,795.44 86.131 3,187.56 135-50027-021-000 Dental Insurance 1,533.00 1,533.00 117.38 1,367.07 89.176 165.93 135-50028-021-000 Vision Insurance 357.00 357.00 29.72 346.91 97.174 10.09 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 697.06 9,177.21 93.789 607.79 135-50035-021-000 Medicare Taxes 2,288.00 2,288.00 163.02 2,146.27 93.806 141.73 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 16,539.18 214,171.59 97.043 6,525.41 135-55005-021-000 Engineering 1,500.00 1,500.00 410.00 410.00 27.333 1,090.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 193.36 4,350.89 29.006 10,649.11 135-55085-021-000 Maintenance-Jet Trailer 330.03 330.03- 135-55090-021-000 Vehicle Maintenance 1,943.00 1,943.00 254.00 1,102.22 56.728 840.78 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 28,093.00 19,393.00 857.36 6,193.14 31.935 13,199.86 135-60005-021-000 Telephone 50.00 38.74 77.480 11.26 135-60010-021-000 Communications/Pagers/Mobiles 2,796.00 2,796.00 2,804.38 100.300 8.38- 135-60020-021-000 Electricity 23,625.00 15,000.00 1,427.92 12,475.18 83.168 2,524.82 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 26.09 735.98 49.065 764.02 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,454.01 58,241.78 57.513 43,025.22 135-65005-021-000 Fuel & Lube 11,700.00 11,700.00 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 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/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 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 18,850.55 325,045.18 69.676 141,466.82 Department number: Collection 407,796.00 466,512.00 18,850.55 325,045.18 69.676 141,466.82 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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 500.00 9,300.00 93.000 700.00 135-50030-026-000 Social Security Taxes 620.00 620.00 31.00 576.60 93.000 43.40 135-50035-026-000 Medicare Taxes 145.00 145.00 7.25 134.85 93.000 10.15 135-50040-026-000 Unemployment Taxes 210.00 210.00 14.50 135.30 64.429 74.70 135-50045-026-000 Workman's Compensation 120.00 120.00 120.00 100.000 Subtotal: 11,095.00 11,095.00 552.75 10,266.75 92.535 828.25 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 702.56 54.973 575.44 135-60080-026-000 Schools & Training 4,150.00 4,150.00 1,989.87 47.949 2,160.13 135-60100-026-000 Travel & per diem 6,199.00 6,199.00 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 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 552.75 16,735.72 59.511 11,386.28 Department number: Board of Directors 28,122.00 28,122.00 552.75 16,735.72 59.511 11,386.28 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 9/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 13,359.17 248,163.05 104.785 11,332.05- 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 1,764.72 34,882.43 104.217 1,411.43- 135-50026-027-000 Medical Insurance 18,798.00 18,798.00 1,211.86 16,432.50 87.416 2,365.50 135-50027-027-000 Dental Insurance 1,242.00 1,242.00 98.04 1,297.25 104.448 55.25- 135-50028-027-000 Vision Insurance 341.00 341.00 22.96 314.37 92.191 26.63 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 749.28 14,889.97 100.202 29.97- 135-50035-027-000 Medicare Taxes 3,475.00 3,475.00 175.24 3,520.24 101.302 45.24- 135-50040-027-000 Unemployment Taxes 756.00 756.00 17.11 392.04 51.857 363.96 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 17,398.38 329,481.91 103.086 9,864.91- 135-55070-027-000 Independent Labor 840.00 840.00 82.50 468.75 55.804 371.25 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 192,967.23 100.981 1,874.23- Subtotal: 178,210.00 192,433.00 82.50 193,435.98 100.521 1,002.98- 135-60005-027-000 Telephone 300.00 300.00 284.29 94.763 15.71 135-60010-027-000 Communications/Pagers/Mobiles 2,420.00 2,420.00 75.00 1,711.41 70.719 708.59 135-60035-027-000 Postage 2,400.00 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 55.00 920.90 52.865 821.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 267.54 1,383.41 35.923 2,467.59 135-60115-027-000 Elections 2,500.00 2,500.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.970 36.97- 135-60270-027-000 4th of July Celebration 10,000.00 10,500.00 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 397.54 23,116.40 67.880 10,938.60 135-65085-027-000 Office Supplies 2,450.00 2,450.00 162.99 3,441.01 140.449 991.01- 135-65105-027-000 Printing 515.00 750.00 1,745.08 232.677 995.08- Subtotal: 2,965.00 3,200.00 162.99 5,186.09 162.065 1,986.09- . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 9/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 18,041.41 551,220.38 100.349 1,915.38- Department number: Manager's Office 531,866.00 549,305.00 18,041.41 551,220.38 100.349 1,915.38- . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 9/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 130.78 1,653.91 84.083 313.09 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 130.78 1,873.33 53.099 1,654.67 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 5.10 5.10 1.167 431.90 135-65105-028-000 Printing 116.00 116.00 116.00 Subtotal: 553.00 553.00 5.10 5.10 .922 547.90 Program number: 7,555.00 7,547.00 135.88 2,065.66 27.371 5,481.34 Department number: Human Resources 7,555.00 7,547.00 135.88 2,065.66 27.371 5,481.34 . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 9/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-029-000 Salaries & Wages 94,404.00 94,404.00 6,002.40 81,057.42 85.862 13,346.58 135-50010-029-000 Overtime 1,000.00 1,000.00 946.28 94.628 53.72 135-50016-029-000 Longevity 1,823.00 1,823.00 1,822.50 99.973 .50 135-50020-029-000 Retirement 13,612.00 13,612.00 829.54 11,931.07 87.651 1,680.93 135-50026-029-000 Medical Insurance 11,060.00 11,060.00 410.70 6,639.50 60.032 4,420.50 135-50027-029-000 Dental Insurance 773.00 773.00 49.02 673.99 87.191 99.01 135-50028-029-000 Vision Insurance 207.00 207.00 6.76 101.19 48.884 105.81 135-50029-029-000 Life Insurance & Other 567.00 567.00 567.00 135-50030-029-000 Social Security Taxes 5,386.00 5,386.00 345.84 4,865.64 90.339 520.36 135-50035-029-000 Medicare Taxes 1,260.00 1,260.00 80.88 1,094.41 86.858 165.59 135-50040-029-000 Unemployment Taxes 284.00 284.00 79.54 28.007 204.46 135-50045-029-000 Workman's Compensation 235.00 235.00 211.00 89.787 24.00 Subtotal: 130,611.00 130,611.00 7,725.14 109,422.54 83.777 21,188.46 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 70.26 68.214 32.74 135-60010-029-000 Communications/Pagers/Mobiles 683.00 683.00 563.07 82.441 119.93 135-60035-029-000 Postage 700.00 700.00 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 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 13.21 41.02 102.550 1.02- 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 13.21 1,334.59 20.611 5,140.41 135-65085-029-000 Office Supplies 849.00 849.00 178.59 21.035 670.41 135-65105-029-000 Printing 515.00 515.00 293.56 57.002 221.44 Subtotal: 1,364.00 1,364.00 472.15 34.615 891.85 Program number: 144,910.00 143,450.00 7,738.35 112,334.78 78.309 31,115.22 Department number: Finance 144,910.00 143,450.00 7,738.35 112,334.78 78.309 31,115.22 . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 9/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 68,799.26 107.249 4,650.26- 135-55070-033-000 Independent Labor 1,650.00 1,650.00 858.75 52.045 791.25 Subtotal: 65,799.00 65,799.00 69,658.01 105.865 3,859.01- 135-60005-033-000 Telephone 6,540.00 6,540.00 8,354.86 127.750 1,814.86- 135-60010-033-000 Communications/Pagers/Mobiles 21.64 21.64 21.64- 135-60235-033-000 Security 1,350.00 1,350.00 747.84 55.396 602.16 Subtotal: 7,890.00 7,890.00 21.64 9,124.34 115.644 1,234.34- 135-65055-033-000 Hardware 83,238.00 83,238.00 1,317.32 79,824.84 95.900 3,413.16 135-65085-033-000 Office Supplies 371.00 371.00 607.50 1,305.50 351.887 934.50- 135-65090-033-000 Printer Supplies & Maintenance 5,732.00 5,732.00 6,744.67 117.667 1,012.67- Subtotal: 89,341.00 89,341.00 1,924.82 87,875.01 98.359 1,465.99 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 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 2,837.54 9.346 27,523.46 Program number: 193,391.00 193,391.00 1,946.46 169,494.90 87.644 23,896.10 Department number: Information Systems 193,391.00 193,391.00 1,946.46 169,494.90 87.644 23,896.10 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 9/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 276.51 1,660.79 8.110 18,817.21 135-55120-037-000 Cleaning Services 25,000.00 1,845.59 20,442.24 81.769 4,557.76 Subtotal: 5,000.00 45,478.00 2,122.10 22,103.03 48.602 23,374.97 135-60020-037-000 Electricity 21,940.00 21,940.00 1,253.67 11,777.48 53.680 10,162.52 135-60025-037-000 Water 1,093.00 1,093.00 902.82 82.600 190.18 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 12,083.61 91.668 1,098.39 135-60055-037-000 Insurance 32,635.00 32,635.00 34,080.49 104.429 1,445.49- 135-60360-037-000 Furniture/Equipment < $5000 2,500.00 4,750.00 209.78 4.416 4,540.22 Subtotal: 71,350.00 73,600.00 1,253.67 59,054.18 80.237 14,545.82 135-65095-037-000 Maintenance Supplies 2,205.00 2,205.00 95.77 1,139.62 51.683 1,065.38 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 95.77 1,219.65 38.055 1,985.35 Program number: 129,132.00 123,144.00 3,471.54 83,284.71 67.632 39,859.29 Department number: Facilities Maintenance 129,132.00 123,144.00 3,471.54 83,284.71 67.632 39,859.29 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 9/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 7,317.36 84,696.30 99.706 249.70 135-50010-038-000 Overtime 2,000.00 2,000.00 23.06 348.65 17.433 1,651.35 135-50016-038-000 Longevity 220.00 220.00 220.00 100.000 135-50020-038-000 Retirement 12,203.00 12,203.00 932.95 11,724.79 96.081 478.21 135-50026-038-000 Medical Insurance 12,321.00 12,321.00 924.38 10,798.58 87.644 1,522.42 135-50027-038-000 Dental Insurance 1,026.00 1,026.00 91.67 1,071.41 104.426 45.41- 135-50028-038-000 Vision Insurance 260.00 260.00 21.64 252.73 97.204 7.27 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 419.35 4,981.27 92.177 422.73 135-50035-038-000 Medicare Taxes 1,264.00 1,264.00 98.09 1,118.18 88.464 145.82 135-50040-038-000 Unemployment Taxes 473.00 473.00 17.10 261.25 55.233 211.75 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 9,845.60 115,734.63 95.675 5,232.37 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 1,466.54 11,023.95 100.218 23.95- Subtotal: 11,800.00 11,800.00 1,466.54 11,023.95 93.423 776.05 135-60005-038-000 Telephone 100.00 100.00 68.99 68.990 31.01 135-60010-038-000 Communications/Pagers/Mobiles 472.00 472.00 398.68 84.466 73.32 135-60035-038-000 Postage 18,000.00 18,000.00 1,451.88 15,413.77 85.632 2,586.23 135-60040-038-000 Service Charges & Fees 18,000.00 29,340.00 2,782.10 24,594.40 83.825 4,745.60 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 4,233.98 65,772.05 88.062 8,915.95 135-65085-038-000 Office Supplies 700.00 700.00 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 694.89 17.592 3,255.11 Program number: 197,430.00 211,405.00 15,546.12 193,225.52 91.401 18,179.48 Department number: Utility Billing 197,430.00 211,405.00 15,546.12 193,225.52 91.401 18,179.48 . glbase_tbam rgonzale Trophy Club MUD #1 Page 20 17:32 10/11/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/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 523.75 74,766.00 84.961 13,234.00 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 2,540.89 16,156.32 80.782 3,843.68 135-55065-039-000 Tax Admin Fees 3,629.00 3,629.00 2,543.22 70.080 1,085.78 Subtotal: 98,829.00 131,829.00 3,064.64 113,665.54 86.222 18,163.46 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 3,064.64 115,943.39 86.456 18,163.61 Department number: Non Departmental 98,829.00 134,107.00 3,064.64 115,943.39 86.456 18,163.61 Expenditures Subtotal ----------- 6,094,978.00 7,112,200.00 447,907.11 6,462,017.59 90.858 650,182.41 Fund number: 135 MUD 1 General Fund 370,880.00- 205,495.11- 642,742.56- 173.302 271,862.56 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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 1815 09/04/2012 Property Tax/Assessment (97,153.02) (29.25) (97,182.27) GL 1816 09/10/2012 Property Tax/Assessment (4.20) (97,186.47) GL 1817 09/12/2012 Property Tax/Assessment (19.07) (97,205.54) GL 1818 09/14/2012 Property Tax/Assessment (108.65) (97,314.19) GL 1819 09/25/2012 Property Tax/Assessment (22.98) (97,337.17) GL 1820 09/28/2012 Property Tax/Assessment (19.55) (97,356.72) GL 1830 09/28/2012 Property Tax/Assessment Revers 19.55 (97,337.17) GL 1831 09/28/2012 Property Taxes/Assessments (19.55) (97,356.72) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (203.70) (97,356.72) ** (97,495.00) Budgeted (138.28) Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1831 09/28/2012 Property Taxes/Assessments 560.19 (17.50) 542.69 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (17.50) 542.69 ** (451.00) Budgeted (993.69) Remaining ########## Account: 135-40015-000-000 Property Taxes/P & I 1815 09/04/2012 Property Tax/Assessment (233.04) (.22) (233.26) GL 1816 09/10/2012 Property Tax/Assessment (.29) (233.55) GL 1817 09/12/2012 Property Tax/Assessment (3.81) (237.36) GL 1818 09/14/2012 Property Tax/Assessment (21.70) (259.06) GL 1744 09/21/2012 Sept A/P Refund tax shortage 20.48 (238.58) DENTON COUNTY TAX OFFICE 31785 AP 1819 09/25/2012 Property Tax/Assessment (1.61) (240.19) GL 1820 09/28/2012 Property Tax/Assessment (1.04) (241.23) GL 1830 09/28/2012 Property Tax/Assessment Revers 1.04 (240.19) GL 1831 09/28/2012 Property Taxes/Assessments (3.36) (243.55) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (10.51) (243.55) ** (200.00) Budgeted 43.55 Remaining 122 % 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 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1813 09/30/2012 UB 9/30/12 Billing UB20120930-20120930 User: (1,637,485.14) (209,374.42) (1,846,859.56) UB _______________ Account: 135-47000-000-000 Water Totals: (209,374.42) (1,846,859.56) ** (1,990,800.00) Budgeted (143,940.44) Remaining 93 % Used Account: 135-47005-000-000 Sewer 1813 09/30/2012 UB 9/30/12 Billing UB20120930-20120930 User: (949,041.32) (104,476.87) (1,053,518.19) UB _______________ Account: 135-47005-000-000 Sewer Totals: (104,476.87) (1,053,518.19) ** (1,325,000.00) Budgeted (271,481.81) Remaining 80 % Used Account: 135-47010-000-000 Commercial Water 1813 09/30/2012 UB 9/30/12 Billing UB20120930-20120930 User: (739,959.83) (102,930.38) (842,890.21) UB _______________ Account: 135-47010-000-000 Commercial Water Totals: (102,930.38) (842,890.21) ** (825,000.00) Budgeted 17,890.21 Remaining 102 % Used Account: 135-47015-000-000 Commercial Sewer 1813 09/30/2012 UB 9/30/12 Billing UB20120930-20120930 User: (264,726.37) (26,331.87) (291,058.24) UB _______________ Account: 135-47015-000-000 Commercial Sewer Totals: (26,331.87) (291,058.24) ** (360,000.00) Budgeted (68,941.76) Remaining 81 % Used Account: 135-47020-000-000 Standby 1813 09/30/2012 UB 9/30/12 Billing UB20120930-20120930 User: (643.35) (54.00) (697.35) UB _______________ Account: 135-47020-000-000 Standby Totals: (54.00) (697.35) ** (775.00) Budgeted (77.65) Remaining 90 % Used Account: 135-47025-000-000 Penalties 1747 09/21/2012 UB 9/21/12 Penalties UB20120921-20120921 User: (50,387.96) (6,111.26) (56,499.22) UB 1798 09/27/2012 UB 09/27/2012 Adjustments UB20120927-20120927 User: 179.19 (56,320.03) UB 1797 09/28/2012 UB 09/28/12 Adjustments UB20120928-20120928 User: 1.49 (56,318.54) UB 1813 09/30/2012 UB 9/30/12 Billing UB20120930-20120930 User: (125.77) (56,444.31) UB _______________ Account: 135-47025-000-000 Penalties Totals: (6,056.35) (56,444.31) ** (45,000.00) Budgeted 11,444.31 Remaining 125 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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-47030-000-000 Service Charges 1753 09/01/2012 UB 9/1/12 Adjustment UB20120901-20120901 User: (10,160.48) (25.00) (10,185.48) UB 1755 09/04/2012 UB 9/4/12 Adjustments UB20120904-20120904 User: (25.00) (10,210.48) UB 1649 09/06/2012 UB 9/6/12 Cut Off Fees UB20120906-20120906 User: (975.00) (11,185.48) UB 1759 09/17/2012 UB 9/17/12 Adjustments UB20120917-20120917 User: (25.00) (11,210.48) UB 1813 09/30/2012 UB 9/30/12 Billing UB20120930-20120930 User: (3.00) (11,213.48) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,053.00) (11,213.48) ** (15,000.00) Budgeted (3,786.52) Remaining 75 % Used Account: 135-47035-000-000 Plumbing Inspections (2,000.00) .00 (2,000.00) _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: .00 (2,000.00) ** (1,500.00) Budgeted 500.00 Remaining 133 % Used Account: 135-47045-000-000 Sewer Inspections 1789 09/26/2012 Permits 9/26/12 (6,000.00) (300.00) (6,300.00) GL _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (6,300.00) ** (4,500.00) Budgeted 1,800.00 Remaining 140 % Used Account: 135-47070-000-000 TCCC Effluent Charges (56,492.29) .00 (56,492.29) _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (56,492.29) ** (75,000.00) Budgeted (18,507.71) Remaining 75 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 1718 09/17/2012 UB 9/17/12 Adjustment UB20120917-20120917 User: (35,098.55) (100.00) (35,198.55) UB 1813 09/30/2012 UB 9/30/12 Billing UB20120930-20120930 User: (2,487.46) (37,686.01) UB _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: (2,587.46) (37,686.01) ** (41,595.00) Budgeted (3,908.99) Remaining 91 % Used Account: 135-47405-000-000 Out of District Sewer 1813 09/30/2012 UB 9/30/12 Billing UB20120930-20120930 User: (11,065.65) (905.27) (11,970.92) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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 Totals: (905.27) (11,970.92) ** (11,807.00) Budgeted 163.92 Remaining 101 % Used Account: 135-47410-000-000 Out of Dist/Portable Penalties (56.77) .00 (56.77) _______________ Account: 135-47410-000-000 Out of Dist/Portable Penalties Totals: .00 (56.77) ** (100.00) Budgeted (43.23) Remaining 57 % Used Account: 135-47600-000-000 PID #1 Water 1813 09/30/2012 UB 9/30/12 Billing UB20120930-20120930 User: (536,650.61) (79,148.15) (615,798.76) UB _______________ Account: 135-47600-000-000 PID #1 Water Totals: (79,148.15) (615,798.76) ** (500,000.00) Budgeted 115,798.76 Remaining 123 % Used Account: 135-47605-000-000 PID #1 Sewer 1813 09/30/2012 UB 9/30/12 Billing UB20120930-20120930 User: (246,043.33) (34,360.19) (280,403.52) UB _______________ Account: 135-47605-000-000 PID #1 Sewer Totals: (34,360.19) (280,403.52) ** (250,000.00) Budgeted 30,403.52 Remaining 112 % Used Account: 135-48005-000-000 Utility Fees 1779 09/05/2012 Permits 9/5/12 (578,080.00) (4,600.00) (582,680.00) GL 1780 09/06/2012 Permits 9/6/12 (6,900.00) (589,580.00) GL 1781 09/07/2012 Permits 9/7/12 (2,300.00) (591,880.00) GL 1782 09/10/2012 Permits 9/10/12 (2,300.00) (594,180.00) GL 1783 09/12/2012 Permits 9/12/12 (2,300.00) (596,480.00) GL 1784 09/17/2012 Permits 9/17/12 (16,100.00) (612,580.00) GL 1785 09/18/2012 Permits 9/18/12 (2,300.00) (614,880.00) GL 1786 09/19/2012 Permits 9/19/12 (2,300.00) (617,180.00) GL 1787 09/20/2012 Permits 9/20/12 (4,600.00) (621,780.00) GL 1788 09/25/2012 Permits 9/25/12 (16,100.00) (637,880.00) GL 1789 09/26/2012 Permits 9/26/12 (9,200.00) (647,080.00) GL 1801 09/27/2012 Permits 9/27/12 (2,300.00) (649,380.00) GL 1803 09/28/2012 Sept A/P Refund 2521 Roseville, duplica 2,300.00 (647,080.00) Pulte Homes AP _______________ Account: 135-48005-000-000 Utility Fees Totals: (69,000.00) (647,080.00) ** (621,000.00) Budgeted 26,080.00 Remaining 104 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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 1822 09/30/2012 September Bank Interest (5,147.67) (114.43) (5,262.10) GL 1822 09/30/2012 September Bank Interest (443.58) (5,705.68) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (558.01) (5,705.68) ** (4,500.00) Budgeted 1,205.68 Remaining 127 % Used Account: 135-49016-000-000 Cell Tower Revenue 1774 09/04/2012 Cell Tower Lease (9,317.00) (847.00) (10,164.00) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (847.00) (10,164.00) ** (10,164.00) Budgeted .00 Remaining 100 % Used Account: 135-49018-000-000 Building Rent Income (6,416.63) .00 (6,416.63) _______________ Account: 135-49018-000-000 Building Rent Income Totals: .00 (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 1775 09/04/2012 Coffee/Vending (550.24) (14.60) (564.84) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (14.60) (564.84) ** (600.00) Budgeted (35.16) Remaining 94 % Used Account: 135-49036-000-000 GASB Reserves . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/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 1779 09/05/2012 Permits 9/5/12 (94,363.05) (584.00) (94,947.05) GL 1780 09/06/2012 Permits 9/6/12 (876.00) (95,823.05) GL 1781 09/07/2012 Permits 9/7/12 (5,728.94) (101,551.99) GL 1782 09/10/2012 Permits 9/10/12 (292.00) (101,843.99) GL 1783 09/12/2012 Permits 9/12/12 (292.00) (102,135.99) GL 1784 09/17/2012 Permits 9/17/12 (2,336.00) (104,471.99) GL 1785 09/18/2012 Permits 9/18/12 (292.00) (104,763.99) GL 1786 09/19/2012 Permits 9/19/12 (292.00) (105,055.99) GL 1787 09/20/2012 Permits 9/20/12 (584.00) (105,639.99) GL 1788 09/25/2012 Permits 9/25/12 (2,044.00) (107,683.99) GL 1789 09/26/2012 Permits 9/26/12 (1,752.00) (109,435.99) GL 1801 09/27/2012 Permits 9/27/12 (292.00) (109,727.99) GL 1803 09/28/2012 Sept A/P Refund 2521 Roseville, duplica 292.00 (109,435.99) Pulte Homes AP _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (15,072.94) (109,435.99) ** (77,800.00) Budgeted 31,635.99 Remaining 141 % Used Account: 135-49900-000-000 Miscellaneous Income 1789 09/26/2012 Permits 9/26/12 (6,418.82) (100.00) (6,518.82) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (100.00) (6,518.82) ** (5,400.00) Budgeted 1,118.82 Remaining 121 % 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: ------------------------------------------------------------------------------------------------ (7,104,760.15) ** (7,483,080.00) Budgeted (378,319.85) Remaining 95 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 1823 09/14/2012 9/14/12 Payroll 145,137.18 6,516.65 151,653.83 GL 1824 09/28/2012 9/28/2012 Payroll 6,276.97 157,930.80 GL _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 12,793.62 157,930.80 ** 160,600.00 Budgeted 2,669.20 Remaining 98 % Used Account: 135-50010-010-000 Overtime 1823 09/14/2012 9/14/12 Payroll 18,789.10 1,560.62 20,349.72 GL 1823 09/14/2012 9/14/12 Payroll 160.00 20,509.72 GL 1824 09/28/2012 9/28/2012 Payroll 809.33 21,319.05 GL 1824 09/28/2012 9/28/2012 Payroll 160.00 21,479.05 GL _______________ Account: 135-50010-010-000 Overtime Totals: 2,689.95 21,479.05 ** 13,250.00 Budgeted (8,229.05) Remaining 162 % 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 1823 09/14/2012 9/14/12 Payroll 1,350.00 275.00 1,625.00 GL _______________ Account: 135-50017-010-000 Certification Totals: 275.00 1,625.00 ** 1,800.00 Budgeted 175.00 Remaining 90 % Used Account: 135-50020-010-000 Retirement 1823 09/14/2012 9/14/12 Payroll 23,785.23 1,176.39 24,961.62 GL 1824 09/28/2012 9/28/2012 Payroll 1,001.44 25,963.06 GL _______________ Account: 135-50020-010-000 Retirement Totals: 2,177.83 25,963.06 ** 25,508.00 Budgeted (455.06) Remaining 102 % Used Account: 135-50026-010-000 Medical Insurance 1823 09/14/2012 9/14/12 Payroll 18,729.29 821.40 19,550.69 GL 1824 09/28/2012 9/28/2012 Payroll 821.40 20,372.09 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,642.80 20,372.09 ** 22,607.00 Budgeted 2,234.91 Remaining 90 % Used Account: 135-50027-010-000 Dental Insurance 1823 09/14/2012 9/14/12 Payroll 1,384.74 62.60 1,447.34 GL 1824 09/28/2012 9/28/2012 Payroll 62.60 1,509.94 GL _______________ Account: 135-50027-010-000 Dental Insurance Totals: 125.20 1,509.94 ** 2,169.00 Budgeted 659.06 Remaining 70 % Used Account: 135-50028-010-000 Vision Insurance 1823 09/14/2012 9/14/12 Payroll 340.37 15.88 356.25 GL 1824 09/28/2012 9/28/2012 Payroll 15.88 372.13 GL _______________ Account: 135-50028-010-000 Vision Insurance Totals: 31.76 372.13 ** 576.00 Budgeted 203.87 Remaining 65 % 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 1823 09/14/2012 9/14/12 Payroll 10,190.48 515.54 10,706.02 GL 1824 09/28/2012 9/28/2012 Payroll 437.06 11,143.08 GL _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 952.60 11,143.08 ** 12,000.00 Budgeted 856.92 Remaining 93 % Used Account: 135-50035-010-000 Medicare Taxes 1823 09/14/2012 9/14/12 Payroll 2,383.24 120.56 2,503.80 GL 1824 09/28/2012 9/28/2012 Payroll 102.21 2,606.01 GL _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 222.77 2,606.01 ** 2,700.00 Budgeted 93.99 Remaining 97 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-010-000 Unemployment Taxes 288.00 .00 288.00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 288.00 ** 945.00 Budgeted 657.00 Remaining 30 % Used Account: 135-50045-010-000 Workman's Compensation 5,581.00 .00 5,581.00 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 5,581.00 ** 5,581.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations 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 1744 09/21/2012 Sept A/P Concrete for driveway pour 16,780.14 288.75 17,068.89 LATTIMORE MATERIALS CO 31790 AP 1763 09/25/2012 Sept A/P August PCards 251.24 17,320.13 JPMORGAN CHASE BANK NA 31809 AP 1803 09/28/2012 Sept A/P Driveway repair 224 Oak Hill 700.00 18,020.13 LATTIMORE MATERIALS CO AP 1814 09/30/2012 Sept A/P PCards 8/7-9/5 1,048.50 19,068.63 JPMORGAN CHASE BANK NA 31813 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 2,288.49 19,068.63 ** 29,500.00 Budgeted 10,431.37 Remaining 65 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-55090-010-000 Vehicle Maintenance 1763 09/25/2012 Sept A/P August PCards 3,760.56 140.60 3,901.16 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 140.60 3,901.16 ** 3,380.00 Budgeted (521.16) Remaining 115 % Used Account: 135-55100-010-000 Building Maint & Supplies 1744 09/21/2012 Sept A/P Pump room A/C 4 yr parts warra 3,450.46 275.00 3,725.46 COVENTRY & GATTIS A/C INC 31782 AP 1763 09/25/2012 Sept A/P August PCards 54.22 3,779.68 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 36.11 3,815.79 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-55100-010-000 Building Maint & Supplies Totals: 365.33 3,815.79 ** 750.00 Budgeted (3,065.79) Remaining 509 % 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 1744 09/21/2012 Sept A/P Lab Analysis 3,215.95 260.00 3,475.95 TARRANT CTY PUBLIC HEALTH LAB 31804 AP 1744 09/21/2012 Sept A/P Lab Analysis 628.00 4,103.95 LOWER COLORADO RIVER AUTHORITY 31791 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 888.00 4,103.95 ** 4,500.00 Budgeted 396.05 Remaining 91 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1,889.95 .00 1,889.95 _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: .00 1,889.95 ** 2,100.00 Budgeted 210.05 Remaining 90 % Used Account: 135-60020-010-000 Electricity 1744 09/21/2012 Sept A/P Electricity 8/14-9/13 88,684.66 15,914.16 104,598.82 HUDSON ENERGY 31788 AP 1744 09/21/2012 Sept A/P Electricity 8/13-9/12 29.54 104,628.36 HUDSON ENERGY 31788 AP 1744 09/21/2012 Sept A/P Electricity 8/14-9/12 666.53 105,294.89 HUDSON ENERGY 31788 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 Totals: 16,610.23 105,294.89 ** 100,000.00 Budgeted (5,294.89) Remaining 105 % 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 1812 09/28/2012 UB 9/28/12 Write Offs3 UB20120928-20120928 User: 6,287.23 917.14 7,204.37 UB _______________ Account: 135-60050-010-000 Bad Debt Expense Totals: 917.14 7,204.37 ** 4,200.00 Budgeted (3,004.37) Remaining 172 % 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 1744 09/21/2012 Sept A/P Membership renewal 111.00 110.00 221.00 COSTCO WHOLESALE 31781 AP 1763 09/25/2012 Sept A/P August PCards 111.00 332.00 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-60070-010-000 Dues & Memberships Totals: 221.00 332.00 ** 150.00 Budgeted (182.00) Remaining 221 % Used Account: 135-60080-010-000 Schools & Training 1752 09/24/2012 Void A/P checks 31745, 31789 Reimburse Class/Backflow Prev 1,193.00 (111.00) 1,082.00 BERT COOPER 31745 AP 1763 09/25/2012 Sept A/P Backflow Prevention Assy Teste 111.00 1,193.00 TX COMMISSION ENVIRONMENTAL QU 31811 AP 1763 09/25/2012 Sept A/P August PCards 225.00 1,418.00 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 300.00 1,718.00 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 525.00 1,718.00 ** 2,800.00 Budgeted 1,082.00 Remaining 61 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 1823 09/14/2012 9/14/12 Payroll 1,537.67 76.04 1,613.71 GL 1824 09/28/2012 9/28/2012 Payroll 35.52 1,649.23 GL _______________ Account: 135-60100-010-000 Travel & per diem Totals: 111.56 1,649.23 ** 3,200.00 Budgeted 1,550.77 Remaining 52 % 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 TCEQ Fees & Permits 7,965.75 .00 7,965.75 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 7,965.75 ** 8,000.00 Budgeted 34.25 Remaining 100 % Used Account: 135-60150-010-000 Wholesale Water 1803 09/28/2012 Sept A/P August Bulk Water 1,430,831.78 229,516.49 1,660,348.27 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 229,516.49 1,660,348.27 ** 1,720,000.00 Budgeted 59,651.73 Remaining 97 % Used Account: 135-60245-010-000 Miscellaneous Expenses 136.97 .00 136.97 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 136.97 ** 500.00 Budgeted 363.03 Remaining 27 % Used Account: 135-60280-010-000 Property Maintenance . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1763 09/25/2012 Sept A/P August PCards 606.79 161.80 768.59 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards (116.00) 652.59 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 108.00 760.59 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-60280-010-000 Property Maintenance Totals: 153.80 760.59 ** 2,200.00 Budgeted 1,439.41 Remaining 35 % 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 1763 09/25/2012 Sept A/P August PCards 13,620.84 58.35 13,679.19 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 58.35 13,679.19 ** 15,216.00 Budgeted 1,536.81 Remaining 90 % Used Account: 135-65010-010-000 Uniforms 1,615.72 .00 1,615.72 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,615.72 ** 3,690.00 Budgeted 2,074.28 Remaining 44 % Used Account: 135-65030-010-000 Chemicals 1763 09/25/2012 Sept A/P August PCards 3,809.06 455.95 4,265.01 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 520.44 4,785.45 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 416.35 5,201.80 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 295.85 5,497.65 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,688.59 5,497.65 ** 5,000.00 Budgeted (497.65) Remaining 110 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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 1763 09/25/2012 Sept A/P August PCards 97,770.57 6,060.00 103,830.57 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 6,060.00 103,830.57 ** 100,000.00 Budgeted (3,830.57) Remaining 104 % 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 1763 09/25/2012 Sept A/P August PCards 30.00 13.50 43.50 JPMORGAN CHASE BANK NA 31809 AP 1803 09/28/2012 Sept A/P Office supplies 29.97 73.47 OFFICE DEPOT, INC AP _______________ Account: 135-65085-010-000 Office Supplies Totals: 43.47 73.47 ** 30.00 Budgeted (43.47) Remaining 245 % Used Account: 135-65095-010-000 Maintenance Supplies 1694 09/10/2012 Sept A/P Traffic Paint 20,984.05 294.67 21,278.72 DALLAS LITE & BARRICADE, INC 31773 AP 1763 09/25/2012 Sept A/P August PCards 591.08 21,869.80 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 18.94 21,888.74 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-65095-010-000 Maintenance Supplies Totals: 904.69 21,888.74 ** 32,000.00 Budgeted 10,111.26 Remaining 68 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-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 1628 09/04/2012 August A/P Roundabout App 4 1,305,208.14 39,174.68 1,344,382.82 CPS CIVIL, LLC 31739 AP _______________ Account: 135-69005-010-000 Capital Expenses Totals: 39,174.68 1,344,382.82 ** 1,455,600.00 Budgeted 111,217.18 Remaining 92 % Used Account: 135-69008-010-000 Short Term Debt Payments 417,135.45 .00 417,135.45 _______________ Account: 135-69008-010-000 Short Term Debt Payments Totals: .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 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/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-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: ------------------------------------------------------------------------------------------------ 4,121,876.18 ** 4,373,733.00 Budgeted 251,856.82 Remaining 94 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 1823 09/14/2012 9/14/12 Payroll 176,318.34 7,292.88 183,611.22 GL 1824 09/28/2012 9/28/2012 Payroll 6,931.22 190,542.44 GL _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,224.10 190,542.44 ** 182,147.00 Budgeted (8,395.44) Remaining 105 % Used Account: 135-50010-020-000 Overtime 1823 09/14/2012 9/14/12 Payroll 12,482.77 1,025.09 13,507.86 GL 1823 09/14/2012 9/14/12 Payroll 80.00 13,587.86 GL 1824 09/28/2012 9/28/2012 Payroll 559.73 14,147.59 GL 1824 09/28/2012 9/28/2012 Payroll 80.00 14,227.59 GL _______________ Account: 135-50010-020-000 Overtime Totals: 1,744.82 14,227.59 ** 10,166.00 Budgeted (4,061.59) Remaining 140 % 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 1823 09/14/2012 9/14/12 Payroll 1,200.00 300.00 1,500.00 GL _______________ Account: 135-50017-020-000 Certification Totals: 300.00 1,500.00 ** 2,400.00 Budgeted 900.00 Remaining 63 % Used Account: 135-50020-020-000 Retirement 1823 09/14/2012 9/14/12 Payroll 27,468.23 1,202.07 28,670.30 GL 1824 09/28/2012 9/28/2012 Payroll 1,046.31 29,716.61 GL _______________ Account: 135-50020-020-000 Retirement Totals: 2,248.38 29,716.61 ** 27,816.00 Budgeted (1,900.61) Remaining 107 % Used Account: 135-50026-020-000 Medical Insurance 1823 09/14/2012 9/14/12 Payroll 24,117.87 1,180.35 25,298.22 GL 1824 09/28/2012 9/28/2012 Payroll 1,180.34 26,478.56 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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 Totals: 2,360.69 26,478.56 ** 30,805.00 Budgeted 4,326.44 Remaining 86 % Used Account: 135-50027-020-000 Dental Insurance 1823 09/14/2012 9/14/12 Payroll 1,840.40 87.92 1,928.32 GL 1824 09/28/2012 9/28/2012 Payroll 87.92 2,016.24 GL _______________ Account: 135-50027-020-000 Dental Insurance Totals: 175.84 2,016.24 ** 1,981.00 Budgeted (35.24) Remaining 102 % Used Account: 135-50028-020-000 Vision Insurance 1823 09/14/2012 9/14/12 Payroll 462.42 22.96 485.38 GL 1824 09/28/2012 9/28/2012 Payroll 22.96 508.34 GL _______________ Account: 135-50028-020-000 Vision Insurance Totals: 45.92 508.34 ** 552.00 Budgeted 43.66 Remaining 92 % 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 1823 09/14/2012 9/14/12 Payroll 11,052.46 477.13 11,529.59 GL 1824 09/28/2012 9/28/2012 Payroll 407.25 11,936.84 GL _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 884.38 11,936.84 ** 11,293.00 Budgeted (643.84) Remaining 106 % Used Account: 135-50035-020-000 Medicare Taxes 1823 09/14/2012 9/14/12 Payroll 2,584.81 111.58 2,696.39 GL 1824 09/28/2012 9/28/2012 Payroll 95.24 2,791.63 GL _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 206.82 2,791.63 ** 2,645.00 Budgeted (146.63) Remaining 106 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-020-000 Unemployment Taxes 531.25 .00 531.25 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 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 1744 09/21/2012 Sept A/P WWTP Study 16,905.67 3,082.50 19,988.17 THE WALLACE GROUP, INC. 31805 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 3,082.50 19,988.17 ** 32,000.00 Budgeted 12,011.83 Remaining 62 % Used Account: 135-55080-020-000 Maintenance & Repairs 1744 09/21/2012 Sept A/P Module Test box for Trojan UV 43,955.02 217.50 44,172.52 NEWMAN REGENCY GROUP, INC 31795 AP 1763 09/25/2012 Sept A/P August PCards 56.74 44,229.26 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 126.66 44,355.92 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 109.90 44,465.82 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 183.41 44,649.23 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 27.70 44,676.93 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 119.95 44,796.88 JPMORGAN CHASE BANK NA 31809 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1763 09/25/2012 Sept A/P August PCards 43,955.02 119.95 44,916.83 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 119.95 45,036.78 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 5.78 45,042.56 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 1,087.54 45,042.56 ** 43,000.00 Budgeted (2,042.56) Remaining 105 % 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 1763 09/25/2012 Sept A/P August PCards 322.35 49.99 372.34 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 43.14 415.48 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 348.00 763.48 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-55100-020-000 Building Maint & Supplies Totals: 441.13 763.48 ** 1,400.00 Budgeted 636.52 Remaining 55 % 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 35,836.33 .00 35,836.33 _______________ Account: 135-55125-020-000 Dumpster Services Totals: .00 35,836.33 ** 35,000.00 Budgeted (836.33) Remaining 102 % Used Account: 135-55135-020-000 Lab Analysis 1744 09/21/2012 Sept A/P Wet Chem analysis 20,816.62 1,960.00 22,776.62 TALEM, INC 31802 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,960.00 22,776.62 ** 25,000.00 Budgeted 2,223.38 Remaining 91 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-60005-020-000 Telephone 64.70 .00 64.70 _______________ Account: 135-60005-020-000 Telephone Totals: .00 64.70 ** 100.00 Budgeted 35.30 Remaining 65 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 2,464.55 .00 2,464.55 _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: .00 2,464.55 ** 3,000.00 Budgeted 535.45 Remaining 82 % Used Account: 135-60020-020-000 Electricity 1744 09/21/2012 Sept A/P Electricity 8/14-9/13 76,216.40 11,331.51 87,547.91 HUDSON ENERGY 31788 AP _______________ Account: 135-60020-020-000 Electricity Totals: 11,331.51 87,547.91 ** 110,000.00 Budgeted 22,452.09 Remaining 80 % Used Account: 135-60025-020-000 Water 1744 09/21/2012 Sept A/P Water/WWTP 1,724.49 29.77 1,754.26 OZARKA DIRECT 31797 AP _______________ Account: 135-60025-020-000 Water Totals: 29.77 1,754.26 ** 1,900.00 Budgeted 145.74 Remaining 92 % Used Account: 135-60035-020-000 Postage .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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1763 09/25/2012 Sept A/P August PCards 503.50 200.00 703.50 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-60080-020-000 Schools & Training Totals: 200.00 703.50 ** 1,320.00 Budgeted 616.50 Remaining 53 % Used Account: 135-60090-020-000 Safety Program 1763 09/25/2012 Sept A/P August PCards 116.45 199.98 316.43 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 199.98 516.41 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-60090-020-000 Safety Program Totals: 399.96 516.41 ** 200.00 Budgeted (316.41) Remaining 258 % Used Account: 135-60100-020-000 Travel & per diem 1823 09/14/2012 9/14/12 Payroll 1,782.11 209.79 1,991.90 GL 1824 09/28/2012 9/28/2012 Payroll 87.69 2,079.59 GL _______________ Account: 135-60100-020-000 Travel & per diem Totals: 297.48 2,079.59 ** 1,750.00 Budgeted (329.59) Remaining 119 % Used Account: 135-60105-020-000 Rent/Lease Equipment 1687 09/10/2012 Sept A/P Waste Pump rental 901.30 1,020.00 1,921.30 XYLEM WATER SOLUTIONS USA INC 31771 AP _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: 1,020.00 1,921.30 ** 200.00 Budgeted (1,721.30) Remaining 961 % Used Account: 135-60125-020-000 Advertising 1,152.36 .00 1,152.36 _______________ Account: 135-60125-020-000 Advertising Totals: .00 1,152.36 ** 1,500.00 Budgeted 347.64 Remaining 77 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 7,432.50 .00 7,432.50 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 7,432.50 ** 7,500.00 Budgeted 67.50 Remaining 99 % Used Account: 135-60245-020-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 5,021.23 .00 5,021.23 _______________ Account: 135-65005-020-000 Fuel & Lube Totals: .00 5,021.23 ** 6,875.00 Budgeted 1,853.77 Remaining 73 % Used Account: 135-65010-020-000 Uniforms 1,734.22 .00 1,734.22 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,734.22 ** 3,140.00 Budgeted 1,405.78 Remaining 55 % Used Account: 135-65030-020-000 Chemicals 1744 09/21/2012 Sept A/P Clarifloc 7,799.63 450.00 8,249.63 POLYDYNE, INC 31798 AP 1744 09/21/2012 Sept A/P Clarifloc 450.00 8,699.63 POLYDYNE, INC 31798 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 900.00 8,699.63 ** 13,180.00 Budgeted 4,480.37 Remaining 66 % Used Account: 135-65035-020-000 Small Tools 1763 09/25/2012 Sept A/P August PCards 129.67 10.79 140.46 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards (.82) 139.64 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 957.11 1,096.75 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 73.50 1,170.25 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 154.29 1,324.54 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-65035-020-000 Small Tools Totals: 1,194.87 1,324.54 ** 1,260.00 Budgeted (64.54) Remaining 105 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-65040-020-000 Safety Equipment 841.49 .00 841.49 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 841.49 ** 925.00 Budgeted 83.51 Remaining 91 % Used Account: 135-65045-020-000 Lab Supplies 1744 09/21/2012 Sept A/P Supplies 7,681.16 2,027.66 9,708.82 IDEXX DISTRIBUTION, INC 31789 AP 1752 09/24/2012 Void A/P checks 31745, 31789 Supplies (2,027.66) 7,681.16 IDEXX DISTRIBUTION, INC 31789 AP 1763 09/25/2012 Sept A/P August PCards 563.95 8,245.11 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 497.21 8,742.32 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 2,848.84 11,591.16 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 3,910.00 11,591.16 ** 12,000.00 Budgeted 408.84 Remaining 97 % 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 1,029.66 .00 1,029.66 _______________ Account: 135-65085-020-000 Office Supplies Totals: .00 1,029.66 ** 400.00 Budgeted (629.66) Remaining 257 % Used Account: 135-65095-020-000 Maintenance Supplies 1763 09/25/2012 Sept A/P August PCards 8,448.97 18.94 8,467.91 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 43.04 8,510.95 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 12.53 8,523.48 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 4.48 8,527.96 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 241.35 8,769.31 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards (68.26) 8,701.05 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 17.38 8,718.43 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-65095-020-000 Maintenance Supplies Totals: 269.46 8,718.43 ** 8,860.00 Budgeted 141.57 Remaining 98 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/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-65115-020-000 Other Consumables 8.69 .00 8.69 _______________ Account: 135-65115-020-000 Other Consumables Totals: .00 8.69 ** 110.00 Budgeted 101.31 Remaining 8 % Used Account: 135-69005-020-000 Capital Expenses 74,962.56 .00 74,962.56 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .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 1687 09/10/2012 Sept A/P Scum Pump 10,180.37 9,665.29 19,845.66 XYLEM WATER SOLUTIONS USA INC 31771 AP _______________ Account: 135-69280-020-000 Capital Repairs Totals: 9,665.29 19,845.66 ** 56,000.00 Budgeted 36,154.34 Remaining 35 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 770,791.17 ** 881,484.00 Budgeted 110,692.83 Remaining 87 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/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 1823 09/14/2012 9/14/12 Payroll 129,296.64 5,691.10 134,987.74 GL 1824 09/28/2012 9/28/2012 Payroll 5,606.56 140,594.30 GL _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,297.66 140,594.30 ** 145,481.00 Budgeted 4,886.70 Remaining 97 % Used Account: 135-50010-021-000 Overtime 1823 09/14/2012 9/14/12 Payroll 9,850.20 48.11 9,898.31 GL 1824 09/28/2012 9/28/2012 Payroll 568.34 10,466.65 GL 1824 09/28/2012 9/28/2012 Payroll 80.00 10,546.65 GL _______________ Account: 135-50010-021-000 Overtime Totals: 696.45 10,546.65 ** 7,297.00 Budgeted (3,249.65) Remaining 145 % 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 1823 09/14/2012 9/14/12 Payroll 1,075.00 150.00 1,225.00 GL _______________ Account: 135-50017-021-000 Certification Totals: 150.00 1,225.00 ** 1,500.00 Budgeted 275.00 Remaining 82 % Used Account: 135-50020-021-000 Retirement 1823 09/14/2012 9/14/12 Payroll 20,403.60 820.79 21,224.39 GL 1824 09/28/2012 9/28/2012 Payroll 864.42 22,088.81 GL _______________ Account: 135-50020-021-000 Retirement Totals: 1,685.21 22,088.81 ** 21,074.00 Budgeted (1,014.81) Remaining 105 % Used Account: 135-50026-021-000 Medical Insurance 1823 09/14/2012 9/14/12 Payroll 18,092.76 851.34 18,944.10 GL 1824 09/28/2012 9/28/2012 Payroll 851.34 19,795.44 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/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-021-000 Medical Insurance Totals: 1,702.68 19,795.44 ** 22,983.00 Budgeted 3,187.56 Remaining 86 % Used Account: 135-50027-021-000 Dental Insurance 1823 09/14/2012 9/14/12 Payroll 1,249.69 58.69 1,308.38 GL 1824 09/28/2012 9/28/2012 Payroll 58.69 1,367.07 GL _______________ Account: 135-50027-021-000 Dental Insurance Totals: 117.38 1,367.07 ** 1,533.00 Budgeted 165.93 Remaining 89 % Used Account: 135-50028-021-000 Vision Insurance 1823 09/14/2012 9/14/12 Payroll 317.19 14.86 332.05 GL 1824 09/28/2012 9/28/2012 Payroll 14.86 346.91 GL _______________ Account: 135-50028-021-000 Vision Insurance Totals: 29.72 346.91 ** 357.00 Budgeted 10.09 Remaining 97 % 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 1823 09/14/2012 9/14/12 Payroll 8,480.15 338.74 8,818.89 GL 1824 09/28/2012 9/28/2012 Payroll 358.32 9,177.21 GL _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 697.06 9,177.21 ** 9,785.00 Budgeted 607.79 Remaining 94 % Used Account: 135-50035-021-000 Medicare Taxes 1823 09/14/2012 9/14/12 Payroll 1,983.25 79.22 2,062.47 GL 1824 09/28/2012 9/28/2012 Payroll 83.80 2,146.27 GL _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 163.02 2,146.27 ** 2,288.00 Budgeted 141.73 Remaining 94 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/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-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 1744 09/21/2012 Sept A/P Engineering/Canterbury Hills P 410.00 410.00 DELTATEK ENGINEERING 31784 AP _______________ Account: 135-55005-021-000 Engineering Totals: 410.00 410.00 ** 1,500.00 Budgeted 1,090.00 Remaining 27 % 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 1763 09/25/2012 Sept A/P August PCards 4,157.53 193.36 4,350.89 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 193.36 4,350.89 ** 15,000.00 Budgeted 10,649.11 Remaining 29 % Used Account: 135-55085-021-000 Maintenance-Jet Trailer . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 1763 09/25/2012 Sept A/P August PCards 848.22 254.00 1,102.22 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 254.00 1,102.22 ** 1,943.00 Budgeted 840.78 Remaining 57 % 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 38.74 .00 38.74 _______________ Account: 135-60005-021-000 Telephone Totals: .00 38.74 ** 50.00 Budgeted 11.26 Remaining 77 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 2,804.38 .00 2,804.38 _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: .00 2,804.38 ** 2,796.00 Budgeted (8.38) Remaining 100 % Used Account: 135-60020-021-000 Electricity 1744 09/21/2012 Sept A/P Electricity 7/30-8/28 11,047.26 300.58 11,347.84 TRI COUNTY ELECTRIC 31806 AP 1744 09/21/2012 Sept A/P Electricity 7/30-8/28 168.17 11,516.01 TRI COUNTY ELECTRIC 31806 AP 1744 09/21/2012 Sept A/P Electricity 7/30-8/28 27.45 11,543.46 TRI COUNTY ELECTRIC 31806 AP 1744 09/21/2012 Sept A/P Electricity 8/14-9/12 671.46 12,214.92 HUDSON ENERGY 31788 AP 1744 09/21/2012 Sept A/P Electricity 8/14-9/13 209.01 12,423.93 HUDSON ENERGY 31788 AP 1744 09/21/2012 Sept A/P Electricity PID LS 8/13-9/12 51.25 12,475.18 HUDSON ENERGY 31788 AP _______________ Account: 135-60020-021-000 Electricity Totals: 1,427.92 12,475.18 ** 15,000.00 Budgeted 2,524.82 Remaining 83 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/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-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 Account: 135-60100-021-000 Travel & per diem 1824 09/28/2012 9/28/2012 Payroll 709.89 26.09 735.98 GL _______________ Account: 135-60100-021-000 Travel & per diem Totals: 26.09 735.98 ** 1,500.00 Budgeted 764.02 Remaining 49 % Used Account: 135-60105-021-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 9,538.08 .00 9,538.08 _______________ Account: 135-65005-021-000 Fuel & Lube Totals: .00 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 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/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-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 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 9/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-69280-021-000 Capital Repairs Totals: .00 .00 ** 80,000.00 Budgeted 80,000.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 325,045.18 ** 466,512.00 Budgeted 141,466.82 Remaining 70 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/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 1824 09/28/2012 9/28/2012 Payroll 8,800.00 500.00 9,300.00 GL _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 500.00 9,300.00 ** 10,000.00 Budgeted 700.00 Remaining 93 % Used Account: 135-50030-026-000 Social Security Taxes 1824 09/28/2012 9/28/2012 Payroll 545.60 31.00 576.60 GL _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 31.00 576.60 ** 620.00 Budgeted 43.40 Remaining 93 % Used Account: 135-50035-026-000 Medicare Taxes 1824 09/28/2012 9/28/2012 Payroll 127.60 7.25 134.85 GL _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 7.25 134.85 ** 145.00 Budgeted 10.15 Remaining 93 % Used Account: 135-50040-026-000 Unemployment Taxes 1824 09/28/2012 9/28/2012 Payroll 120.80 14.50 135.30 GL _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 14.50 135.30 ** 210.00 Budgeted 74.70 Remaining 64 % Used Account: 135-50045-026-000 Workman's Compensation 120.00 .00 120.00 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 120.00 ** 120.00 Budgeted .00 Remaining 100 % Used Account: 135-60035-026-000 Postage 26.11 .00 26.11 _______________ Account: 135-60035-026-000 Postage Totals: .00 26.11 ** 50.00 Budgeted 23.89 Remaining 52 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 685.00 .00 685.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 685.00 ** 2,100.00 Budgeted 1,415.00 Remaining 33 % Used Account: 135-60075-026-000 Meetings 702.56 .00 702.56 _______________ Account: 135-60075-026-000 Meetings Totals: .00 702.56 ** 1,278.00 Budgeted 575.44 Remaining 55 % Used Account: 135-60080-026-000 Schools & Training 1,989.87 .00 1,989.87 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,989.87 ** 4,150.00 Budgeted 2,160.13 Remaining 48 % Used Account: 135-60100-026-000 Travel & per diem 1,816.84 .00 1,816.84 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 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 _______________ Account: 135-65085-026-000 Office Supplies Totals: .00 30.90 ** 50.00 Budgeted 19.10 Remaining 62 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 16,735.72 ** 28,122.00 Budgeted 11,386.28 Remaining 60 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 9/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 1823 09/14/2012 9/14/12 Payroll 234,803.88 6,648.68 241,452.56 GL 1824 09/28/2012 9/28/2012 Payroll 6,710.49 248,163.05 GL _______________ Account: 135-50005-027-000 Salaries & Wages Totals: 13,359.17 248,163.05 ** 236,831.00 Budgeted (11,332.05) Remaining 105 % 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 1823 09/14/2012 9/14/12 Payroll 33,117.71 882.36 34,000.07 GL 1824 09/28/2012 9/28/2012 Payroll 882.36 34,882.43 GL _______________ Account: 135-50020-027-000 Retirement Totals: 1,764.72 34,882.43 ** 33,471.00 Budgeted (1,411.43) Remaining 104 % Used Account: 135-50026-027-000 Medical Insurance 1823 09/14/2012 9/14/12 Payroll 15,220.64 605.93 15,826.57 GL 1824 09/28/2012 9/28/2012 Payroll 605.93 16,432.50 GL _______________ Account: 135-50026-027-000 Medical Insurance Totals: 1,211.86 16,432.50 ** 18,798.00 Budgeted 2,365.50 Remaining 87 % Used Account: 135-50027-027-000 Dental Insurance 1823 09/14/2012 9/14/12 Payroll 1,199.21 49.02 1,248.23 GL 1824 09/28/2012 9/28/2012 Payroll 49.02 1,297.25 GL _______________ Account: 135-50027-027-000 Dental Insurance Totals: 98.04 1,297.25 ** 1,242.00 Budgeted (55.25) Remaining 104 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-027-000 Vision Insurance 1823 09/14/2012 9/14/12 Payroll 291.41 11.48 302.89 GL 1824 09/28/2012 9/28/2012 Payroll 11.48 314.37 GL _______________ Account: 135-50028-027-000 Vision Insurance Totals: 22.96 314.37 ** 341.00 Budgeted 26.63 Remaining 92 % 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 1823 09/14/2012 9/14/12 Payroll 14,140.69 372.72 14,513.41 GL 1824 09/28/2012 9/28/2012 Payroll 376.56 14,889.97 GL _______________ Account: 135-50030-027-000 Social Security Taxes Totals: 749.28 14,889.97 ** 14,860.00 Budgeted (29.97) Remaining 100 % Used Account: 135-50035-027-000 Medicare Taxes 1823 09/14/2012 9/14/12 Payroll 3,345.00 87.17 3,432.17 GL 1824 09/28/2012 9/28/2012 Payroll 88.07 3,520.24 GL _______________ Account: 135-50035-027-000 Medicare Taxes Totals: 175.24 3,520.24 ** 3,475.00 Budgeted (45.24) Remaining 101 % Used Account: 135-50040-027-000 Unemployment Taxes 1823 09/14/2012 9/14/12 Payroll 374.93 7.66 382.59 GL 1824 09/28/2012 9/28/2012 Payroll 9.45 392.04 GL _______________ Account: 135-50040-027-000 Unemployment Taxes Totals: 17.11 392.04 ** 756.00 Budgeted 363.96 Remaining 52 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 9/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-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 1744 09/21/2012 Sept A/P Record MUD meeting 386.25 82.50 468.75 MIGUEL CRUZ 31793 AP _______________ Account: 135-55070-027-000 Independent Labor Totals: 82.50 468.75 ** 840.00 Budgeted 371.25 Remaining 56 % 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 192,967.23 .00 192,967.23 _______________ Account: 135-55160-027-000 Professional Outside Services Totals: .00 192,967.23 ** 191,093.00 Budgeted (1,874.23) Remaining 101 % Used Account: 135-60005-027-000 Telephone 284.29 .00 284.29 _______________ Account: 135-60005-027-000 Telephone Totals: .00 284.29 ** 300.00 Budgeted 15.71 Remaining 95 % Used Account: 135-60010-027-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1823 09/14/2012 9/14/12 Payroll 1,636.41 75.00 1,711.41 GL _______________ Account: 135-60010-027-000 Communications/Pagers/Mobiles Totals: 75.00 1,711.41 ** 2,420.00 Budgeted 708.59 Remaining 71 % Used Account: 135-60035-027-000 Postage 2,096.49 .00 2,096.49 _______________ Account: 135-60035-027-000 Postage Totals: .00 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 1744 09/21/2012 Sept A/P Membership renewal 865.90 55.00 920.90 COSTCO WHOLESALE 31781 AP _______________ Account: 135-60070-027-000 Dues & Memberships Totals: 55.00 920.90 ** 1,742.00 Budgeted 821.10 Remaining 53 % Used Account: 135-60075-027-000 Meetings 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 1763 09/25/2012 Sept A/P August PCards 1,115.87 23.00 1,138.87 JPMORGAN CHASE BANK NA 31809 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1763 09/25/2012 Sept A/P August PCards 1,115.87 1.79 1,140.66 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 218.50 1,359.16 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 24.25 1,383.41 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-60100-027-000 Travel & per diem Totals: 267.54 1,383.41 ** 3,851.00 Budgeted 2,467.59 Remaining 36 % Used Account: 135-60115-027-000 Elections 2,607.32 .00 2,607.32 _______________ Account: 135-60115-027-000 Elections Totals: .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 136.97 .00 136.97 _______________ Account: 135-60245-027-000 Miscellaneous Expenses Totals: .00 136.97 ** 100.00 Budgeted (36.97) Remaining 137 % Used Account: 135-60270-027-000 4th of July Celebration 10,281.97 .00 10,281.97 _______________ Account: 135-60270-027-000 4th of July Celebration Totals: .00 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1744 09/21/2012 Sept A/P Office Supplies 3,278.02 91.28 3,369.30 OFFICE DEPOT, INC 31796 AP 1803 09/28/2012 Sept A/P Office Supplies 71.71 3,441.01 OFFICE DEPOT, INC AP _______________ Account: 135-65085-027-000 Office Supplies Totals: 162.99 3,441.01 ** 2,450.00 Budgeted (991.01) Remaining 140 % 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: ------------------------------------------------------------------------------------------------ 551,220.38 ** 549,305.00 Budgeted (1,915.38) Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 9/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 1763 09/25/2012 Sept A/P August PCards 1,523.13 11.03 1,534.16 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 32.68 1,566.84 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 40.47 1,607.31 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 46.60 1,653.91 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-50070-028-000 Employee Relations Totals: 130.78 1,653.91 ** 1,967.00 Budgeted 313.09 Remaining 84 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 9/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-60075-028-000 Meetings .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 1763 09/25/2012 Sept A/P August PCards 5.10 5.10 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-65085-028-000 Office Supplies Totals: 5.10 5.10 ** 437.00 Budgeted 431.90 Remaining 1 % 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: ------------------------------------------------------------------------------------------------ 2,065.66 ** 7,547.00 Budgeted 5,481.34 Remaining 27 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 9/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 1823 09/14/2012 9/14/12 Payroll 75,055.02 3,001.20 78,056.22 GL 1824 09/28/2012 9/28/2012 Payroll 3,001.20 81,057.42 GL _______________ Account: 135-50005-029-000 Salaries & Wages Totals: 6,002.40 81,057.42 ** 94,404.00 Budgeted 13,346.58 Remaining 86 % 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 1823 09/14/2012 9/14/12 Payroll 11,101.53 414.77 11,516.30 GL 1824 09/28/2012 9/28/2012 Payroll 414.77 11,931.07 GL _______________ Account: 135-50020-029-000 Retirement Totals: 829.54 11,931.07 ** 13,612.00 Budgeted 1,680.93 Remaining 88 % Used Account: 135-50026-029-000 Medical Insurance 1823 09/14/2012 9/14/12 Payroll 6,228.80 205.35 6,434.15 GL 1824 09/28/2012 9/28/2012 Payroll 205.35 6,639.50 GL _______________ Account: 135-50026-029-000 Medical Insurance Totals: 410.70 6,639.50 ** 11,060.00 Budgeted 4,420.50 Remaining 60 % Used Account: 135-50027-029-000 Dental Insurance 1823 09/14/2012 9/14/12 Payroll 624.97 24.51 649.48 GL 1824 09/28/2012 9/28/2012 Payroll 24.51 673.99 GL _______________ Account: 135-50027-029-000 Dental Insurance Totals: 49.02 673.99 ** 773.00 Budgeted 99.01 Remaining 87 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-029-000 Vision Insurance 1823 09/14/2012 9/14/12 Payroll 94.43 3.38 97.81 GL 1824 09/28/2012 9/28/2012 Payroll 3.38 101.19 GL _______________ Account: 135-50028-029-000 Vision Insurance Totals: 6.76 101.19 ** 207.00 Budgeted 105.81 Remaining 49 % 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 1823 09/14/2012 9/14/12 Payroll 4,519.80 172.92 4,692.72 GL 1824 09/28/2012 9/28/2012 Payroll 172.92 4,865.64 GL _______________ Account: 135-50030-029-000 Social Security Taxes Totals: 345.84 4,865.64 ** 5,386.00 Budgeted 520.36 Remaining 90 % Used Account: 135-50035-029-000 Medicare Taxes 1823 09/14/2012 9/14/12 Payroll 1,013.53 40.44 1,053.97 GL 1824 09/28/2012 9/28/2012 Payroll 40.44 1,094.41 GL _______________ Account: 135-50035-029-000 Medicare Taxes Totals: 80.88 1,094.41 ** 1,260.00 Budgeted 165.59 Remaining 87 % Used Account: 135-50040-029-000 Unemployment Taxes 79.54 .00 79.54 _______________ Account: 135-50040-029-000 Unemployment Taxes Totals: .00 79.54 ** 284.00 Budgeted 204.46 Remaining 28 % Used Account: 135-50045-029-000 Workman's Compensation 211.00 .00 211.00 _______________ Account: 135-50045-029-000 Workman's Compensation Totals: .00 211.00 ** 235.00 Budgeted 24.00 Remaining 90 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55160-029-000 Professional Outside Services 1,105.50 .00 1,105.50 _______________ Account: 135-55160-029-000 Professional Outside Services Totals: .00 1,105.50 ** 5,000.00 Budgeted 3,894.50 Remaining 22 % Used Account: 135-60005-029-000 Telephone 70.26 .00 70.26 _______________ Account: 135-60005-029-000 Telephone Totals: .00 70.26 ** 103.00 Budgeted 32.74 Remaining 68 % Used Account: 135-60010-029-000 Communications/Pagers/Mobiles 563.07 .00 563.07 _______________ Account: 135-60010-029-000 Communications/Pagers/Mobiles Totals: .00 563.07 ** 683.00 Budgeted 119.93 Remaining 82 % Used Account: 135-60035-029-000 Postage 285.74 .00 285.74 _______________ Account: 135-60035-029-000 Postage Totals: .00 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 Account: 135-60066-029-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-029-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-029-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 95.00 .00 95.00 _______________ Account: 135-60070-029-000 Dues & Memberships Totals: .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 1824 09/28/2012 9/28/2012 Payroll 27.81 13.21 41.02 GL _______________ Account: 135-60100-029-000 Travel & per diem Totals: 13.21 41.02 ** 40.00 Budgeted (1.02) Remaining 103 % Used Account: 135-60125-029-000 Advertising .00 .00 _______________ Account: 135-60125-029-000 Advertising Totals: .00 .00 ** 1,210.00 Budgeted 1,210.00 Remaining 0 % Used Account: 135-60245-029-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-029-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65085-029-000 Office Supplies 178.59 .00 178.59 . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 9/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-029-000 Office Supplies Totals: .00 178.59 ** 849.00 Budgeted 670.41 Remaining 21 % Used Account: 135-65105-029-000 Printing 293.56 .00 293.56 _______________ Account: 135-65105-029-000 Printing Totals: .00 293.56 ** 515.00 Budgeted 221.44 Remaining 57 % Used Department 29 Totals: ------------------------------------------------------------------------------------------------ 112,334.78 ** 143,450.00 Budgeted 31,115.22 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 62 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 9/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 68,799.26 .00 68,799.26 _______________ Account: 135-55030-033-000 Software & Support Totals: .00 68,799.26 ** 64,149.00 Budgeted (4,650.26) Remaining 107 % Used Account: 135-55070-033-000 Independent Labor 858.75 .00 858.75 _______________ Account: 135-55070-033-000 Independent Labor Totals: .00 858.75 ** 1,650.00 Budgeted 791.25 Remaining 52 % Used Account: 135-60005-033-000 Telephone 8,354.86 .00 8,354.86 _______________ Account: 135-60005-033-000 Telephone Totals: .00 8,354.86 ** 6,540.00 Budgeted (1,814.86) Remaining 128 % Used Account: 135-60010-033-000 Communications/Pagers/Mobiles 1763 09/25/2012 Sept A/P August PCards 21.64 21.64 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-60010-033-000 Communications/Pagers/Mobiles Totals: 21.64 21.64 ** .00 Budgeted (21.64) Remaining 0 % Used Account: 135-60235-033-000 Security 747.84 .00 747.84 _______________ Account: 135-60235-033-000 Security Totals: .00 747.84 ** 1,350.00 Budgeted 602.16 Remaining 55 % Used Account: 135-65055-033-000 Hardware 1744 09/21/2012 Sept A/P UPS for Lift Station 78,507.52 243.00 78,750.52 SHI GOVERNMENT SOLUTIONS,INC 31800 AP 1744 09/21/2012 Sept A/P UPS for Lift Station 648.00 79,398.52 SHI GOVERNMENT SOLUTIONS,INC 31800 AP 1744 09/21/2012 Sept A/P Cable patch 27.00 79,425.52 SHI GOVERNMENT SOLUTIONS,INC 31800 AP 1744 09/21/2012 Sept A/P Industrial Device Server-Exter 379.40 79,804.92 SHI GOVERNMENT SOLUTIONS,INC 31800 AP 1763 09/25/2012 Sept A/P Adm to PW Fiber install 19.92 79,824.84 SHI GOVERNMENT SOLUTIONS,INC 31810 AP _______________ Account: 135-65055-033-000 Hardware Totals: 1,317.32 79,824.84 ** 83,238.00 Budgeted 3,413.16 Remaining 96 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 63 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65085-033-000 Office Supplies 1744 09/21/2012 Sept A/P Bond paper, 1 roll vinyl 698.00 15.00 713.00 SHI GOVERNMENT SOLUTIONS,INC 31800 AP 1763 09/25/2012 Sept A/P HP toner 91.00 804.00 SHI GOVERNMENT SOLUTIONS,INC 31810 AP 1803 09/28/2012 Sept A/P Toner for copiers 501.50 1,305.50 SHI GOVERNMENT SOLUTIONS,INC AP _______________ Account: 135-65085-033-000 Office Supplies Totals: 607.50 1,305.50 ** 371.00 Budgeted (934.50) Remaining 352 % Used Account: 135-65090-033-000 Printer Supplies & Maintenance 6,744.67 .00 6,744.67 _______________ Account: 135-65090-033-000 Printer Supplies & Maintenance Totals: .00 6,744.67 ** 5,732.00 Budgeted (1,012.67) Remaining 118 % Used Account: 135-69170-033-000 Copier Lease Installments 2,837.54 .00 2,837.54 _______________ Account: 135-69170-033-000 Copier Lease Installments Totals: .00 2,837.54 ** 3,450.00 Budgeted 612.46 Remaining 82 % Used Account: 135-69195-033-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-033-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 26,911.00 Budgeted 26,911.00 Remaining 0 % Used Department 33 Totals: ------------------------------------------------------------------------------------------------ 169,494.90 ** 193,391.00 Budgeted 23,896.10 Remaining 88 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 64 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 9/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 1814 09/30/2012 Sept A/P PCards 8/7-9/5 1,384.28 61.40 1,445.68 JPMORGAN CHASE BANK NA 31813 AP 1814 09/30/2012 Sept A/P PCards 8/7-9/5 101.00 1,546.68 JPMORGAN CHASE BANK NA 31813 AP 1814 09/30/2012 Sept A/P PCards 8/7-9/5 114.11 1,660.79 JPMORGAN CHASE BANK NA 31813 AP _______________ Account: 135-55100-037-000 Building Maint & Supplies Totals: 276.51 1,660.79 ** 20,478.00 Budgeted 18,817.21 Remaining 8 % Used Account: 135-55120-037-000 Cleaning Services 1744 09/21/2012 Sept A/P Janitorial Services/Sept 18,596.65 1,678.51 20,275.16 ABM JANITORIAL SERVICES, INC 31779 AP 1763 09/25/2012 Sept A/P August PCards 167.08 20,442.24 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 135-55120-037-000 Cleaning Services Totals: 1,845.59 20,442.24 ** 25,000.00 Budgeted 4,557.76 Remaining 82 % Used Account: 135-60020-037-000 Electricity 1744 09/21/2012 Sept A/P Electricity 7/16-8/14 10,523.81 1,253.67 11,777.48 DIRECT ENERGY BUSINESS SVCS 31786 AP _______________ Account: 135-60020-037-000 Electricity Totals: 1,253.67 11,777.48 ** 21,940.00 Budgeted 10,162.52 Remaining 54 % Used Account: 135-60025-037-000 Water 902.82 .00 902.82 _______________ Account: 135-60025-037-000 Water Totals: .00 902.82 ** 1,093.00 Budgeted 190.18 Remaining 83 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 65 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 9/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 12,083.61 .00 12,083.61 _______________ Account: 135-60030-037-000 Rent And/Or Usage Totals: .00 12,083.61 ** 13,182.00 Budgeted 1,098.39 Remaining 92 % Used Account: 135-60055-037-000 Insurance 34,080.49 .00 34,080.49 _______________ Account: 135-60055-037-000 Insurance Totals: .00 34,080.49 ** 32,635.00 Budgeted (1,445.49) Remaining 104 % Used Account: 135-60360-037-000 Furniture/Equipment < $5000 209.78 .00 209.78 _______________ Account: 135-60360-037-000 Furniture/Equipment < $5000 Totals: .00 209.78 ** 4,750.00 Budgeted 4,540.22 Remaining 4 % Used Account: 135-65095-037-000 Maintenance Supplies 1763 09/25/2012 Sept A/P August PCards 1,043.85 58.91 1,102.76 JPMORGAN CHASE BANK NA 31809 AP 1814 09/30/2012 Sept A/P PCards 8/7-9/5 36.86 1,139.62 JPMORGAN CHASE BANK NA 31813 AP _______________ Account: 135-65095-037-000 Maintenance Supplies Totals: 95.77 1,139.62 ** 2,205.00 Budgeted 1,065.38 Remaining 52 % 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 Department 37 Totals: ------------------------------------------------------------------------------------------------ 83,284.71 ** 123,144.00 Budgeted 39,859.29 Remaining 68 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 66 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 9/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 1823 09/14/2012 9/14/12 Payroll 77,378.94 3,623.22 81,002.16 GL 1824 09/28/2012 9/28/2012 Payroll 3,694.14 84,696.30 GL _______________ Account: 135-50005-038-000 Salaries & Wages Totals: 7,317.36 84,696.30 ** 84,946.00 Budgeted 249.70 Remaining 100 % Used Account: 135-50010-038-000 Overtime 1823 09/14/2012 9/14/12 Payroll 325.59 18.90 344.49 GL 1824 09/28/2012 9/28/2012 Payroll 4.16 348.65 GL _______________ Account: 135-50010-038-000 Overtime Totals: 23.06 348.65 ** 2,000.00 Budgeted 1,651.35 Remaining 17 % 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 1823 09/14/2012 9/14/12 Payroll 10,791.84 466.86 11,258.70 GL 1824 09/28/2012 9/28/2012 Payroll 466.09 11,724.79 GL _______________ Account: 135-50020-038-000 Retirement Totals: 932.95 11,724.79 ** 12,203.00 Budgeted 478.21 Remaining 96 % Used Account: 135-50026-038-000 Medical Insurance 1823 09/14/2012 9/14/12 Payroll 9,874.20 462.19 10,336.39 GL 1824 09/28/2012 9/28/2012 Payroll 462.19 10,798.58 GL _______________ Account: 135-50026-038-000 Medical Insurance Totals: 924.38 10,798.58 ** 12,321.00 Budgeted 1,522.42 Remaining 88 % Used Account: 135-50027-038-000 Dental Insurance 1823 09/14/2012 9/14/12 Payroll 979.74 45.83 1,025.57 GL 1824 09/28/2012 9/28/2012 Payroll 45.84 1,071.41 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 67 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 9/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-038-000 Dental Insurance Totals: 91.67 1,071.41 ** 1,026.00 Budgeted (45.41) Remaining 104 % Used Account: 135-50028-038-000 Vision Insurance 1823 09/14/2012 9/14/12 Payroll 231.09 10.82 241.91 GL 1824 09/28/2012 9/28/2012 Payroll 10.82 252.73 GL _______________ Account: 135-50028-038-000 Vision Insurance Totals: 21.64 252.73 ** 260.00 Budgeted 7.27 Remaining 97 % 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 1823 09/14/2012 9/14/12 Payroll 4,561.92 207.94 4,769.86 GL 1824 09/28/2012 9/28/2012 Payroll 211.41 4,981.27 GL _______________ Account: 135-50030-038-000 Social Security Taxes Totals: 419.35 4,981.27 ** 5,404.00 Budgeted 422.73 Remaining 92 % Used Account: 135-50035-038-000 Medicare Taxes 1823 09/14/2012 9/14/12 Payroll 1,020.09 48.64 1,068.73 GL 1824 09/28/2012 9/28/2012 Payroll 49.45 1,118.18 GL _______________ Account: 135-50035-038-000 Medicare Taxes Totals: 98.09 1,118.18 ** 1,264.00 Budgeted 145.82 Remaining 88 % Used Account: 135-50040-038-000 Unemployment Taxes 1823 09/14/2012 9/14/12 Payroll 244.15 7.65 251.80 GL 1824 09/28/2012 9/28/2012 Payroll 9.45 261.25 GL _______________ Account: 135-50040-038-000 Unemployment Taxes Totals: 17.10 261.25 ** 473.00 Budgeted 211.75 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 68 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 9/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-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 1744 09/21/2012 Sept A/P Printing of water bills/August 9,557.41 1,466.54 11,023.95 CSG SYSTEMS, INC. 31783 AP _______________ Account: 135-55205-038-000 Utility Billing Contract Totals: 1,466.54 11,023.95 ** 11,000.00 Budgeted (23.95) Remaining 100 % Used Account: 135-60005-038-000 Telephone 68.99 .00 68.99 _______________ Account: 135-60005-038-000 Telephone Totals: .00 68.99 ** 100.00 Budgeted 31.01 Remaining 69 % Used Account: 135-60010-038-000 Communications/Pagers/Mobiles 398.68 .00 398.68 _______________ Account: 135-60010-038-000 Communications/Pagers/Mobiles Totals: .00 398.68 ** 472.00 Budgeted 73.32 Remaining 84 % Used Account: 135-60035-038-000 Postage . glpdatb2 rgonzale Trophy Club MUD #1 Page 69 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1744 09/21/2012 Sept A/P Printing of water bills/August 13,961.89 1,451.88 15,413.77 CSG SYSTEMS, INC. 31783 AP _______________ Account: 135-60035-038-000 Postage Totals: 1,451.88 15,413.77 ** 18,000.00 Budgeted 2,586.23 Remaining 86 % Used Account: 135-60040-038-000 Service Charges & Fees 1827 09/05/2012 Credit Card fees/August 21,812.30 76.20 21,888.50 GL 1827 09/05/2012 Credit Card fees/August 77.56 21,966.06 GL 1827 09/05/2012 Credit Card fees/August 2,628.34 24,594.40 GL _______________ Account: 135-60040-038-000 Service Charges & Fees Totals: 2,782.10 24,594.40 ** 29,340.00 Budgeted 4,745.60 Remaining 84 % 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 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 70 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .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 694.89 .00 694.89 _______________ Account: 135-65085-038-000 Office Supplies Totals: .00 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: ------------------------------------------------------------------------------------------------ 193,225.52 ** 211,405.00 Budgeted 18,179.48 Remaining 91 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 71 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/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 1744 09/21/2012 Sept A/P August Legal 74,242.25 491.75 74,734.00 WHITAKER CHALK SWINDLE 31807 AP 1744 09/21/2012 Sept A/P August Legal 32.00 74,766.00 WHITAKER CHALK SWINDLE 31807 AP _______________ Account: 135-55045-039-000 Legal Totals: 523.75 74,766.00 ** 88,000.00 Budgeted 13,234.00 Remaining 85 % 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 1684 09/10/2012 Sept A/P 4th Quarter Budget 13,615.43 2,540.89 16,156.32 DENTON CENTRAL APPRAISAL DISTR 31750 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,540.89 16,156.32 ** 20,000.00 Budgeted 3,843.68 Remaining 81 % Used Account: 135-55065-039-000 Tax Admin Fees 2,543.22 .00 2,543.22 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 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: ------------------------------------------------------------------------------------------------ 115,943.39 ** 134,107.00 Budgeted 18,163.61 Remaining 86 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (642,742.56) (370,880.00) Budgeted 271,862.56 Remaining 173 % Used Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 9/30/2012 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 788,097 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 19,119 ACCOUNTS RECEIVABLE - PID EMER SERVICES 5 OTHER RECEIVABLES 25,733 TOTAL ASSETS 832,954$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 19,124$ ACCOUNTS PAYABLE 408,936 TOTAL LIABILITIES 428,060$ FUND BALANCE ASSIGNED FUND BALANCE 23,101 UNASSIGNED FUND BALANCE 381,793 TOTAL LIABILITIES AND FUND BALANCE 832,954$ September 30, 2012 12/12 Months (100% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 17:32 10/11/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/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- 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- 2,250.10- 1,075,452.49- 99.859 1,523.51- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,603.00- 217.48- 4,425.67 -78.988 10,028.67- 122-40015-000-000 Property Taxes/Assessments P&I 725.00- 2,259.22- 311.617 1,534.22 122-40020-000-000 Property Taxes/Fire P&I 7,500.00- 7,500.00- 345.61- 5,357.59- 71.435 2,142.41- 122-40970-000-000 Insurance Settlements 9,739.43- 9,739.43 Subtotal: 1,277,709.00- 1,288,937.00- 2,813.19- 1,287,489.37- 99.888 1,447.63- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 400.00- 10,400.00- 173.333 4,400.00 Subtotal: 6,000.00- 400.00- 10,400.00- 173.333 4,400.00 122-43400-000-000 Fire Inspections 500.00- 75.00- 1,950.00- 390.000 1,450.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,950.00- 113.810 1,450.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- 725.00- 14,630.92- 160.392 5,508.92 122-49901-000-000 Records Management 5.00- 5.00 Subtotal: 23,101.00- 9,122.00- 725.00- 16,538.42- 181.303 7,416.42 Program number: 1,311,934.00- 1,314,559.00- 4,013.19- 1,326,377.79- 100.899 11,818.79 Department number: Fire Revenues 1,311,934.00- 1,314,559.00- 4,013.19- 1,326,377.79- 100.899 11,818.79 Revenues Subtotal ----------- 1,311,934.00- 1,314,559.00- 4,013.19- 1,326,377.79- 100.899 11,818.79 . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 17:32 10/11/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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 35,628.04 437,230.89 102.697 11,482.89- 122-50010-045-000 Overtime 42,000.00 42,000.00 1,883.49 33,578.99 79.950 8,421.01 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 130.55 3,910.11 96.001 162.89 122-50020-045-000 Retirement 68,264.00 68,264.00 4,948.73 66,033.99 96.733 2,230.01 122-50026-045-000 Medical Insurance 53,184.00 53,184.00 3,473.46 40,517.79 76.184 12,666.21 122-50027-045-000 Dental Insurance 3,288.00 3,288.00 304.65 3,544.26 107.794 256.26- 122-50028-045-000 Vision Insurance 857.00 857.00 68.97 766.72 89.466 90.28 122-50029-045-000 Life Insurance & Other 2,740.00 2,740.00 2,740.00 122-50030-045-000 Social Security Taxes 30,231.00 30,231.00 2,141.70 28,747.03 95.091 1,483.97 122-50035-045-000 Medicare Taxes 7,070.00 7,070.00 500.86 6,723.08 95.093 346.92 122-50040-045-000 Unemployment Taxes 1,476.00 1,476.00 27.31 806.92 54.669 669.08 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 49,107.76 648,215.28 97.295 18,019.72 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 187.75 5,719.64 59.816 3,842.36 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 17,152.88 38,613.46 260.023 23,763.46- 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 6,818.05 69.515 2,989.95 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 277.85 7,583.90 68.945 3,416.10 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 51.94 837.94 75.969 265.06 122-55160-045-000 Professional Outside Services 20,000.00 19,623.00 5,000.00 5,142.69 26.207 14,480.31 Subtotal: 66,323.00 65,946.00 22,670.42 64,715.68 98.134 1,230.32 122-60005-045-000 Telephone 106.00 106.00 46.95 44.292 59.05 122-60010-045-000 Communications/Pagers/Mobiles 4,411.00 4,411.00 150.00 2,361.01 53.526 2,049.99 122-60020-045-000 Electricity/Gas 18,270.00 18,270.00 1,152.12 12,505.84 68.450 5,764.16 122-60025-045-000 Water 3,289.00 3,289.00 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 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 28.392 287.15 122-60070-045-000 Dues & Memberships 8,560.00 8,560.00 55.00 6,705.34 78.333 1,854.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 33.00 3,950.96 56.881 2,995.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 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 3,772.49 90.641 389.51 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 704.26 37.066 1,195.74 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 17:32 10/11/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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 3,399.85 133.694 856.85- 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 911.53 73.689 325.47 Subtotal: 390,758.00 390,833.00 1,390.12 357,692.46 91.521 33,140.54 122-65005-045-000 Fuel & Lube 17,414.00 17,414.00 7,799.83 44.791 9,614.17 122-65010-045-000 Uniforms 4,357.00 4,357.00 105.48 4,059.26 93.166 297.74 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 421.06 7,321.56 96.336 278.44 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 3,842.60 5,850.20 69.887 2,520.80 122-65085-045-000 Office Supplies 329.00 1,200.00 11.29 788.30 65.692 411.70 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 224.10 2,140.74 76.867 644.26 122-65105-045-000 Printing 106.00 106.00 24.77 23.368 81.23 Subtotal: 42,507.00 43,378.00 4,604.53 28,809.66 66.415 14,568.34 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 345.70 594.39 23.776 1,905.61 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 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 345.70 101,656.78 68.610 46,510.22 Program number: 1,311,934.00 1,314,559.00 78,118.53 1,201,089.86 91.368 113,469.14 Department number: Fire 1,311,934.00 1,314,559.00 78,118.53 1,201,089.86 91.368 113,469.14 Expenditures Subtotal ----------- 1,311,934.00 1,314,559.00 78,118.53 1,201,089.86 91.368 113,469.14 Fund number: 122 Trophy Club MUD Fire Dept. 74,105.34 125,287.93- 125,287.93 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/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 (191,760.19) .00 (191,760.19) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (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 1815 09/04/2012 Property Tax/Assessment (1,073,202.39) (323.07) (1,073,525.46) GL 1816 09/10/2012 Property Tax/Assessment (46.35) (1,073,571.81) GL 1817 09/12/2012 Property Tax/Assessment (210.60) (1,073,782.41) GL 1818 09/14/2012 Property Tax/Assessment (1,200.18) (1,074,982.59) GL 1819 09/25/2012 Property Tax/Assessment (253.89) (1,075,236.48) GL 1820 09/28/2012 Property Tax/Assessment (216.01) (1,075,452.49) GL 1830 09/28/2012 Property Tax/Assessment Revers 216.01 (1,075,236.48) GL 1831 09/28/2012 Property Taxes/Assessments (216.01) (1,075,452.49) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (2,250.10) (1,075,452.49) ** (1,076,976.00) Budgeted (1,523.51) Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1831 09/28/2012 Property Taxes/Assessments 4,643.15 (217.48) 4,425.67 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (217.48) 4,425.67 ** (5,603.00) Budgeted (10,028.67) Remaining -79 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I (2,259.22) .00 (2,259.22) _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 (2,259.22) ** (725.00) Budgeted 1,534.22 Remaining 312 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1815 09/04/2012 Property Tax/Assessment (5,011.98) (2.45) (5,014.43) GL 1816 09/10/2012 Property Tax/Assessment (3.25) (5,017.68) GL 1817 09/12/2012 Property Tax/Assessment (42.12) (5,059.80) GL 1818 09/14/2012 Property Tax/Assessment (239.76) (5,299.56) GL 1819 09/25/2012 Property Tax/Assessment (17.77) (5,317.33) GL 1820 09/28/2012 Property Tax/Assessment (11.40) (5,328.73) GL 1830 09/28/2012 Property Tax/Assessment Revers 11.40 (5,317.33) GL 1831 09/28/2012 Property Taxes/Assessments (40.26) (5,357.59) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (345.61) (5,357.59) ** (7,500.00) Budgeted (2,142.41) Remaining 71 % 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 1789 09/26/2012 Permits 9/26/12 (10,000.00) (400.00) (10,400.00) GL _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (10,400.00) ** (6,000.00) Budgeted 4,400.00 Remaining 173 % Used Account: 122-43400-000-000 Fire Inspections 1789 09/26/2012 Permits 9/26/12 (1,875.00) (75.00) (1,950.00) GL _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (1,950.00) ** (500.00) Budgeted 1,450.00 Remaining 390 % 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 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/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 1789 09/26/2012 Permits 9/26/12 (13,905.92) (725.00) (14,630.92) GL _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (725.00) (14,630.92) ** (9,122.00) Budgeted 5,508.92 Remaining 160 % 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,326,377.79) ** (1,314,559.00) Budgeted 11,818.79 Remaining 101 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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 1823 09/14/2012 9/14/12 Payroll 401,602.85 16,899.67 418,502.52 GL 1824 09/28/2012 9/28/2012 Payroll 18,728.37 437,230.89 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 35,628.04 437,230.89 ** 425,748.00 Budgeted (11,482.89) Remaining 103 % Used Account: 122-50010-045-000 Overtime 1824 09/28/2012 9/28/2012 Payroll 31,695.50 1,883.49 33,578.99 GL _______________ Account: 122-50010-045-000 Overtime Totals: 1,883.49 33,578.99 ** 42,000.00 Budgeted 8,421.01 Remaining 80 % 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 1823 09/14/2012 9/14/12 Payroll 3,779.56 130.55 3,910.11 GL _______________ Account: 122-50017-045-000 Certification Totals: 130.55 3,910.11 ** 4,073.00 Budgeted 162.89 Remaining 96 % Used Account: 122-50020-045-000 Retirement 1823 09/14/2012 9/14/12 Payroll 61,085.26 2,286.11 63,371.37 GL 1824 09/28/2012 9/28/2012 Payroll 2,662.62 66,033.99 GL _______________ Account: 122-50020-045-000 Retirement Totals: 4,948.73 66,033.99 ** 68,264.00 Budgeted 2,230.01 Remaining 97 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 1823 09/14/2012 9/14/12 Payroll 37,044.33 1,736.74 38,781.07 GL 1824 09/28/2012 9/28/2012 Payroll 1,736.72 40,517.79 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,473.46 40,517.79 ** 53,184.00 Budgeted 12,666.21 Remaining 76 % Used Account: 122-50027-045-000 Dental Insurance 1823 09/14/2012 9/14/12 Payroll 3,239.61 152.32 3,391.93 GL 1824 09/28/2012 9/28/2012 Payroll 152.33 3,544.26 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 304.65 3,544.26 ** 3,288.00 Budgeted (256.26) Remaining 108 % Used Account: 122-50028-045-000 Vision Insurance 1823 09/14/2012 9/14/12 Payroll 697.75 34.49 732.24 GL 1824 09/28/2012 9/28/2012 Payroll 34.48 766.72 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 68.97 766.72 ** 857.00 Budgeted 90.28 Remaining 89 % 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 1823 09/14/2012 9/14/12 Payroll 26,605.33 962.06 27,567.39 GL 1824 09/28/2012 9/28/2012 Payroll 1,179.64 28,747.03 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,141.70 28,747.03 ** 30,231.00 Budgeted 1,483.97 Remaining 95 % Used Account: 122-50035-045-000 Medicare Taxes 1823 09/14/2012 9/14/12 Payroll 6,222.22 225.00 6,447.22 GL 1824 09/28/2012 9/28/2012 Payroll 275.86 6,723.08 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 500.86 6,723.08 ** 7,070.00 Budgeted 346.92 Remaining 95 % Used Account: 122-50040-045-000 Unemployment Taxes 1823 09/14/2012 9/14/12 Payroll 779.61 10.74 790.35 GL 1824 09/28/2012 9/28/2012 Payroll 16.57 806.92 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 27.31 806.92 ** 1,476.00 Budgeted 669.08 Remaining 55 % 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 1744 09/21/2012 Sept A/P Qtrly Air Test on Bauer UN3 5,531.89 187.75 5,719.64 AUGUST INDUSTRIES, INC 31780 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 187.75 5,719.64 ** 9,562.00 Budgeted 3,842.36 Remaining 60 % Used Account: 122-55090-045-000 Vehicle Maintenance 1684 09/10/2012 Sept A/P Engine Prev Maint 21,460.58 3,286.30 24,746.88 SIDDONS-MARTIN EMERGENCY GROUP 31801 AP 1684 09/10/2012 Sept A/P Engine Prev Maint 1,846.73 26,593.61 SIDDONS-MARTIN EMERGENCY GROUP 31766 AP 1744 09/21/2012 Sept A/P 2007 Pier Arrow/Pumper repair 11,904.79 38,498.40 SIDDONS-MARTIN EMERGENCY GROUP 31801 AP 1763 09/25/2012 Sept A/P August PCards 39.94 38,538.34 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 32.45 38,570.79 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 31.44 38,602.23 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 11.23 38,613.46 JPMORGAN CHASE BANK NA 31809 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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: 17,152.88 38,613.46 ** 14,850.00 Budgeted (23,763.46) Remaining 260 % Used Account: 122-55095-045-000 Equipment Maintenance 6,818.05 .00 6,818.05 _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: .00 6,818.05 ** 9,808.00 Budgeted 2,989.95 Remaining 70 % Used Account: 122-55100-045-000 Building Maintenance 1763 09/25/2012 Sept A/P August PCards 7,306.05 152.56 7,458.61 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 128.41 7,587.02 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 32.96 7,619.98 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 157.56 7,777.54 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 46.36 7,823.90 JPMORGAN CHASE BANK NA 31809 AP 1776 09/26/2012 Fire Dept Aug/Sept cable (240.00) 7,583.90 GL _______________ Account: 122-55100-045-000 Building Maintenance Totals: 277.85 7,583.90 ** 11,000.00 Budgeted 3,416.10 Remaining 69 % Used Account: 122-55110-045-000 Maintenance-Radios 1763 09/25/2012 Sept A/P August PCards 786.00 51.94 837.94 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: 51.94 837.94 ** 1,103.00 Budgeted 265.06 Remaining 76 % Used Account: 122-55160-045-000 Professional Outside Services 1763 09/25/2012 Sept A/P Balance due Salary study 142.69 5,000.00 5,142.69 WELLSPRING INSURANCE AGENCY IN 31812 AP _______________ Account: 122-55160-045-000 Professional Outside Services Totals: 5,000.00 5,142.69 ** 19,623.00 Budgeted 14,480.31 Remaining 26 % Used Account: 122-60005-045-000 Telephone 46.95 .00 46.95 _______________ Account: 122-60005-045-000 Telephone Totals: .00 46.95 ** 106.00 Budgeted 59.05 Remaining 44 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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-60010-045-000 Communications/Pagers/Mobiles 1823 09/14/2012 9/14/12 Payroll 2,211.01 150.00 2,361.01 GL _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 150.00 2,361.01 ** 4,411.00 Budgeted 2,049.99 Remaining 54 % Used Account: 122-60020-045-000 Electricity/Gas 1744 09/21/2012 Sept A/P Electricity 8/14-9/13 11,353.72 1,104.40 12,458.12 HUDSON ENERGY 31788 AP 1763 09/25/2012 Sept A/P Gas/Fire Station 8/17-9/19 47.72 12,505.84 ATMOS ENERGY 31808 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 1,152.12 12,505.84 ** 18,270.00 Budgeted 5,764.16 Remaining 68 % Used Account: 122-60025-045-000 Water 3,135.11 .00 3,135.11 _______________ Account: 122-60025-045-000 Water Totals: .00 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 46.55 .00 46.55 _______________ Account: 122-60035-045-000 Postage Totals: .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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 113.85 .00 113.85 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 113.85 ** 401.00 Budgeted 287.15 Remaining 28 % Used Account: 122-60070-045-000 Dues & Memberships 1744 09/21/2012 Sept A/P Membership renewal 6,650.34 55.00 6,705.34 COSTCO WHOLESALE 31781 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 55.00 6,705.34 ** 8,560.00 Budgeted 1,854.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 1744 09/21/2012 Sept A/P Training/Rader 3,917.96 33.00 3,950.96 TARRANT COUNTY COLLEGE 31803 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 33.00 3,950.96 ** 6,946.00 Budgeted 2,995.04 Remaining 57 % 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 2,938.72 .00 2,938.72 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 2,938.72 ** 6,788.00 Budgeted 3,849.28 Remaining 43 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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-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 3,772.49 .00 3,772.49 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 3,772.49 ** 4,162.00 Budgeted 389.51 Remaining 91 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 704.26 .00 704.26 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 704.26 ** 1,900.00 Budgeted 1,195.74 Remaining 37 % Used Account: 122-60195-045-000 Flags & Repair 3,399.85 .00 3,399.85 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 3,399.85 ** 2,543.00 Budgeted (856.85) Remaining 134 % Used Account: 122-60245-045-000 Miscellaneous Expense 911.53 .00 911.53 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 911.53 ** 1,237.00 Budgeted 325.47 Remaining 74 % Used Account: 122-65005-045-000 Fuel & Lube 7,799.83 .00 7,799.83 . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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-65005-045-000 Fuel & Lube Totals: .00 7,799.83 ** 17,414.00 Budgeted 9,614.17 Remaining 45 % Used Account: 122-65010-045-000 Uniforms 1763 09/25/2012 Sept A/P August PCards 3,953.78 105.48 4,059.26 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 105.48 4,059.26 ** 4,357.00 Budgeted 297.74 Remaining 93 % Used Account: 122-65015-045-000 Protective Clothing 1763 09/25/2012 Sept A/P August PCards 6,900.50 353.83 7,254.33 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 7.00 7,261.33 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 55.98 7,317.31 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 4.25 7,321.56 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 421.06 7,321.56 ** 7,600.00 Budgeted 278.44 Remaining 96 % Used 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 1744 09/21/2012 Sept A/P Hose Clamp Screw , Barack moun 2,007.60 602.50 2,610.10 DOOLEY TACKABERRY 31787 AP 1744 09/21/2012 Sept A/P Couplings 2,693.00 5,303.10 METRO FIRE APPARATUS 31792 AP 1744 09/21/2012 Sept A/P Strap assy, face piece 247.13 5,550.23 MUNICIPAL EMERGENCY SERVICES 31794 AP 1803 09/28/2012 Sept A/P Shredders 299.97 5,850.20 OFFICE DEPOT, INC AP _______________ Account: 122-65035-045-000 Small Tools Totals: 3,842.60 5,850.20 ** 8,371.00 Budgeted 2,520.80 Remaining 70 % Used Account: 122-65085-045-000 Office Supplies 1744 09/21/2012 Sept A/P Office Supplies 777.01 11.29 788.30 OFFICE DEPOT, INC 31796 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 11.29 788.30 ** 1,200.00 Budgeted 411.70 Remaining 66 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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-65095-045-000 Maintenance Supplies 1763 09/25/2012 Sept A/P August PCards 1,916.64 61.06 1,977.70 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 112.81 2,090.51 JPMORGAN CHASE BANK NA 31809 AP 1763 09/25/2012 Sept A/P August PCards 50.23 2,140.74 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 224.10 2,140.74 ** 2,785.00 Budgeted 644.26 Remaining 77 % Used Account: 122-65105-045-000 Printing 24.77 .00 24.77 _______________ Account: 122-65105-045-000 Printing Totals: .00 24.77 ** 106.00 Budgeted 81.23 Remaining 23 % Used Account: 122-69006-045-000 Grant Match .00 .00 _______________ Account: 122-69006-045-000 Grant Match Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 122-69035-045-000 Vehicles 13,333.09 .00 13,333.09 _______________ Account: 122-69035-045-000 Vehicles Totals: .00 13,333.09 ** 13,709.00 Budgeted 375.91 Remaining 97 % Used Account: 122-69050-045-000 Radios 1763 09/25/2012 Sept A/P August PCards 248.69 345.70 594.39 JPMORGAN CHASE BANK NA 31809 AP _______________ Account: 122-69050-045-000 Radios Totals: 345.70 594.39 ** 2,500.00 Budgeted 1,905.61 Remaining 24 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/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-69251-045-000 Engine 681 Payment 73,203.30 .00 73,203.30 _______________ Account: 122-69251-045-000 Engine 681 Payment Totals: .00 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,201,089.86 ** 1,314,559.00 Budgeted 113,469.14 Remaining 91 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (125,287.93) .00 Budgeted 125,287.93 Remaining 0 % Used Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 9/30/2012 ASSETS ASSETS CASH AND CASH IN BANK 6,120$ INVESTMENTS 130,297 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 16,395 TOTAL ASSETS 152,812$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 16,395$ TOTAL LIABILITIES 16,395 FUND BALANCE ASSIGNED FUND BALANCE 136,417 TOTAL LIABILITIES AND FUND BALANCE 152,812$ September 30, 2012 12/12 Months (100% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 21 17:32 10/11/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 9/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- 1,150.49- 549,884.09- 100.579 3,168.09 533-40002-000-000 Property Taxes/Delinquent 3,947.00- 153.20- 2,296.66 -58.187 6,243.66- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 182.30- 3,225.70- 64.295 1,791.30- Subtotal: 555,680.00- 555,680.00- 1,485.99- 550,813.13- 99.124 4,866.87- 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- 16.67- 1,293.70- 76.100 406.30- 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- 16.67- 313,955.54- 101.374 4,255.54 Program number: 870,300.00- 871,500.00- 1,502.66- 870,888.67- 99.930 611.33- Department number: Revenues 870,300.00- 871,500.00- 1,502.66- 870,888.67- 99.930 611.33- Revenues Subtotal ----------- 870,300.00- 871,500.00- 1,502.66- 870,888.67- 99.930 611.33- . glbase_tbam rgonzale Trophy Club MUD #1 Page 22 17:32 10/11/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 9/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 275,518.75 91.443 25,781.25 533-70035-051-000 Bond Principal Payment 565,000.00 565,000.00 565,000.00 100.000 Subtotal: 870,300.00 870,300.00 842,318.75 96.785 27,981.25 Program number: 870,300.00 870,300.00 842,318.75 96.785 27,981.25 Department number: Administration 870,300.00 870,300.00 842,318.75 96.785 27,981.25 Expenditures Subtotal ----------- 870,300.00 870,300.00 842,318.75 96.785 27,981.25 Fund number: 533 MUD 1 I&S CONSOLIDATED 1,200.00- 1,502.66- 28,569.92- 2,380.827 27,369.92 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 72 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 9/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 1815 09/04/2012 Property Tax/Assessment (548,733.60) (165.19) (548,898.79) GL 1816 09/10/2012 Property Tax/Assessment (23.70) (548,922.49) GL 1817 09/12/2012 Property Tax/Assessment (107.69) (549,030.18) GL 1818 09/14/2012 Property Tax/Assessment (613.65) (549,643.83) GL 1819 09/25/2012 Property Tax/Assessment (129.81) (549,773.64) GL 1820 09/28/2012 Property Tax/Assessment (110.45) (549,884.09) GL 1830 09/28/2012 Property Tax/Assessment Revers 110.45 (549,773.64) GL 1831 09/28/2012 Property Taxes/Assessments (110.45) (549,884.09) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,150.49) (549,884.09) ** (546,716.00) Budgeted 3,168.09 Remaining 101 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1831 09/28/2012 Property Taxes/Assessments 2,449.86 (153.20) 2,296.66 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (153.20) 2,296.66 ** (3,947.00) Budgeted (6,243.66) Remaining -58 % Used Account: 533-40015-000-000 Property Taxes/P & I 1815 09/04/2012 Property Tax/Assessment (3,043.40) (1.25) (3,044.65) GL 1816 09/10/2012 Property Tax/Assessment (1.66) (3,046.31) GL 1817 09/12/2012 Property Tax/Assessment (21.54) (3,067.85) GL 1818 09/14/2012 Property Tax/Assessment (122.60) (3,190.45) GL 1819 09/25/2012 Property Tax/Assessment (9.09) (3,199.54) GL 1820 09/28/2012 Property Tax/Assessment (5.83) (3,205.37) GL 1830 09/28/2012 Property Tax/Assessment Revers 5.83 (3,199.54) GL 1831 09/28/2012 Property Taxes/Assessments (26.16) (3,225.70) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (182.30) (3,225.70) ** (5,017.00) Budgeted (1,791.30) Remaining 64 % 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 73 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 9/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1822 09/30/2012 September Bank Interest (1,277.03) (16.67) (1,293.70) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (16.67) (1,293.70) ** (1,700.00) Budgeted (406.30) Remaining 76 % 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: ------------------------------------------------------------------------------------------------ (870,888.67) ** (871,500.00) Budgeted (611.33) Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 74 17:32 10/11/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 9/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 275,518.75 .00 275,518.75 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 275,518.75 ** 301,300.00 Budgeted 25,781.25 Remaining 91 % Used Account: 533-70035-051-000 Bond Principal Payment 565,000.00 .00 565,000.00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .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: ------------------------------------------------------------------------------------------------------ (28,569.92) (1,200.00) Budgeted 27,369.92 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (796,600.41) **** (372,080.00) Budgeted 424,520.41 Remaining 214 % Used ******* End of Report *********