Loading...
HomeMy WebLinkAboutMarch 2012 MUD Financials Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 3/31/2012 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 813,584 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 48,596 ACCOUNTS RECEIVABLE - PID EMERGENCY SERVICES A 7,446 OTHER RECEIVABLES 45,239 TOTAL ASSETS 914,865$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 56,042$ ACCOUNTS PAYABLE 26,755 TOTAL LIABILITIES 82,798$ FUND BALANCE UNDESIGNATED FUND BALANCE 832,067 TOTAL LIABILITIES AND FUND BALANCE 914,865$ March 31, 2012 6/12 Months (50% of Fiscal Year) . glbase_tbam rgonzale Trophy Club Entities Page 1 09:56 04/20/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/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- 2,345.16- 186,208.32- 96.365 7,024.68- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,900.00- 4,856.69- 99.116 43.31- 122-40010-000-000 Property Taxes/MUD Fire 1,076,976.00- 1,076,976.00- 6,095.12- 1,046,583.67- 97.178 30,392.33- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,603.00- 190.98 5,462.06 -97.485 11,065.06- 122-40015-000-000 Property Taxes/Assessments P&I 725.00- 178.72- 952.37- 131.361 227.37 122-40020-000-000 Property Taxes/Fire P&I 7,500.00- 7,500.00- 507.49- 1,773.26- 23.643 5,726.74- Subtotal: 1,277,709.00- 1,288,937.00- 8,935.51- 1,234,912.25- 95.809 54,024.75- 122-42014-000-000 Fire Permits/Sprinkler 2,000.00- 400.00- 6,000.00- 300.000 4,000.00 Subtotal: 2,000.00- 400.00- 6,000.00- 300.000 4,000.00 122-43400-000-000 Fire Inspections 500.00- 75.00- 1,125.00- 225.000 625.00 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 122-43599-000-000 Misc Fire Revenue 1,124.00- 1,124.00- 1,124.00- Subtotal: 11,124.00- 11,624.00- 75.00- 11,125.00- 95.707 499.00- 122-49035-000-000 Prior Year Reserves 23,101.00- 4,373.00- 4,373.00- 122-49900-000-000 Miscellaneous Income 5,000.00- 725.00- 9,121.95- 182.439 4,121.95 Subtotal: 23,101.00- 9,373.00- 725.00- 9,121.95- 97.322 251.05- Program number: 1,311,934.00- 1,311,934.00- 10,135.51- 1,261,159.20- 96.130 50,774.80- Department number: Fire Revenues 1,311,934.00- 1,311,934.00- 10,135.51- 1,261,159.20- 96.130 50,774.80- Revenues Subtotal ----------- 1,311,934.00- 1,311,934.00- 10,135.51- 1,261,159.20- 96.130 50,774.80- . glbase_tbam rgonzale Trophy Club Entities Page 2 09:56 04/20/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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 50,625.61 205,648.31 48.303 220,099.69 122-50010-045-000 Overtime 42,000.00 42,000.00 2,802.71 22,625.36 53.870 19,374.64 122-50011-045-000 DPS Holiday Pay 12,133.00 12,133.00 13,773.02 113.517 1,640.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 494.70 3,053.20 74.962 1,019.80 122-50020-045-000 Retirement 68,264.00 68,264.00 6,815.69 34,153.35 50.031 34,110.65 122-50026-045-000 Medical Insurance 53,184.00 53,184.00 3,343.58 20,042.72 37.686 33,141.28 122-50027-045-000 Dental Insurance 3,288.00 3,288.00 292.37 1,751.72 53.276 1,536.28 122-50028-045-000 Vision Insurance 857.00 857.00 65.99 395.66 46.168 461.34 122-50029-045-000 Life Insurance & Other 2,740.00 2,740.00 2,740.00 122-50030-045-000 Social Security Taxes 30,231.00 30,231.00 3,156.83 14,804.83 48.972 15,426.17 122-50035-045-000 Medicare Taxes 7,070.00 7,070.00 738.25 3,462.51 48.975 3,607.49 122-50040-045-000 Unemployment Taxes 1,476.00 1,476.00 52.18 609.89 41.320 866.11 122-50045-045-000 Workman's Compensation 8,793.00 8,793.00 899.19 9,208.69 104.728 415.69- 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 36.55 89.00 13.185 586.00 Subtotal: 664,179.00 664,179.00 69,323.65 333,332.72 50.187 330,846.28 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 1,288.43 2,516.64 26.319 7,045.36 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 1,800.22 12.123 13,049.78 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 4,137.18 42.182 5,670.82 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 478.15 3,133.18 28.483 7,866.82 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 393.00 393.00 35.630 710.00 122-55160-045-000 Professional Outside Services 20,000.00 20,000.00 20,000.00 Subtotal: 66,323.00 66,323.00 2,159.58 11,980.22 18.063 54,342.78 122-60005-045-000 Telephone 106.00 106.00 5.13 27.41 25.858 78.59 122-60010-045-000 Communications/Pagers/Mobiles 4,411.00 4,411.00 193.95 1,212.12 27.479 3,198.88 122-60020-045-000 Electricity/Gas 18,270.00 18,270.00 860.45 5,763.48 31.546 12,506.52 122-60025-045-000 Water 3,289.00 3,289.00 281.36 1,665.86 50.649 1,623.14 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 11.00 23.35 24.072 73.65 122-60055-045-000 Insurance 20,974.00 20,974.00 8,078.00 38.514 12,896.00 122-60066-045-000 Publications/Books/Subscrips 401.00 401.00 401.00 122-60070-045-000 Dues & Memberships 8,560.00 8,560.00 50.00 6,180.34 72.200 2,379.66 122-60075-045-000 Meetings 22.00 22.00- 122-60080-045-000 Schools & Training 6,946.00 6,946.00 85.00 1,197.47 17.240 5,748.53 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 13.66 1,646.09 24.250 5,141.91 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 15.46 1,849.57 44.439 2,312.43 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 9.37 394.95 20.787 1,505.05 . glbase_tbam rgonzale Trophy Club Entities Page 3 09:56 04/20/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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 460.00 1,012.50 39.815 1,530.50 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 121.45 662.87 53.587 574.13 Subtotal: 390,758.00 390,758.00 2,106.83 338,736.01 86.687 52,021.99 122-65005-045-000 Fuel & Lube 17,414.00 17,414.00 1,183.55 2,615.71 15.021 14,798.29 122-65010-045-000 Uniforms 4,357.00 4,357.00 228.13 1,285.73 29.510 3,071.27 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 83.50 1.099 7,516.50 122-65030-045-000 Chemicals 1,545.00 1,545.00 1,545.00 122-65035-045-000 Small Tools 8,371.00 8,371.00 995.00 1,464.96 17.500 6,906.04 122-65085-045-000 Office Supplies 329.00 329.00 632.64 192.292 303.64- 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 45.18 856.92 30.769 1,928.08 122-65105-045-000 Printing 106.00 106.00 24.77 23.368 81.23 Subtotal: 42,507.00 42,507.00 2,451.86 6,964.23 16.384 35,542.77 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 72.57 13,333.09 97.258 375.91 122-69050-045-000 Radios 2,500.00 2,500.00 2,500.00 122-69195-045-000 GASB34/Reserve for Replacement 41,890.00 41,890.00 41,890.00 122-69251-045-000 Engine 681 Payment 73,203.00 73,203.00 4,351.65 5.945 68,851.35 122-69255-045-000 Airpacks 13,865.00 13,865.00 13,865.00 Subtotal: 148,167.00 148,167.00 72.57 17,684.74 11.936 130,482.26 Program number: 1,311,934.00 1,311,934.00 76,114.49 708,697.92 54.019 603,236.08 Department number: Fire 1,311,934.00 1,311,934.00 76,114.49 708,697.92 54.019 603,236.08 Expenditures Subtotal ----------- 1,311,934.00 1,311,934.00 76,114.49 708,697.92 54.019 603,236.08 Fund number: 122 Trophy Club MUD Fire Dept. 65,978.98 552,461.28- 552,461.28 . glpdatb2 rgonzale Trophy Club Entities Page 1 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/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 783 03/05/2012 Property Taxes/Assessments (183,863.16) (937.81) (184,800.97) GL 784 03/06/2012 Property Taxes/Assessments (91.70) (184,892.67) GL 785 03/07/2012 Property Taxes/Assessments (92.40) (184,985.07) GL 788 03/12/2012 Property Taxes/Assessments (219.16) (185,204.23) GL 792 03/14/2012 Property Taxes/Assessments (90.78) (185,295.01) GL 794 03/16/2012 Property Taxes/Assessments (54.75) (185,349.76) GL 796 03/20/2012 Property Taxes/Assessments (387.13) (185,736.89) GL 797 03/21/2012 Property Taxes/Assessments (174.97) (185,911.86) GL 800 03/26/2012 Property Taxes/Assessments (181.83) (186,093.69) GL 697 03/27/2012 March A/P Emergency Services Assessment 16.47 (186,077.22) Atmos Energy/Mid-Tex 31320 AP 697 03/27/2012 March A/P Emergency Services Assessment 19.80 (186,057.42) Automotive Rentals Inc. 31322 AP 697 03/27/2012 March A/P Emergency Services Assessment 149.06 (185,908.36) Centex Homes 31324 AP 697 03/27/2012 March A/P Emergency Services Assessment .56 (185,907.80) Culligan Water Conditioner 31328 AP 697 03/27/2012 March A/P Emergency Services Assessment 17.12 (185,890.68) Lease Plan USA Inc. 31336 AP 697 03/27/2012 March A/P Emergency Services Assessment 92.60 (185,798.08) Oncor Electric Delivery 31341 AP 697 03/27/2012 March A/P Emergency Services Assessment 8.97 (185,789.11) Sentry Financial Corporation 31344 AP 697 03/27/2012 March A/P Emergency Services Assessment 17.14 (185,771.97) Southwestern Bell Telephone Co 31347 AP 801 03/27/2012 Property Taxes/Assessments (332.51) (186,104.48) GL 803 03/29/2012 Property Taxes/Assessments (103.84) (186,208.32) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (2,345.16) (186,208.32) ** (193,233.00) Budgeted (7,024.68) Remaining 96 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (4,856.69) .00 (4,856.69) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (4,856.69) ** (4,900.00) Budgeted (43.31) Remaining 99 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 781 03/01/2012 Property Taxes/Assessments (1,040,488.55) (293.13) (1,040,781.68) GL 782 03/02/2012 Property Taxes/Assessments (401.24) (1,041,182.92) GL 783 03/05/2012 Property Taxes/Assessments (736.16) (1,041,919.08) GL 784 03/06/2012 Property Taxes/Assessments (295.61) (1,042,214.69) GL 785 03/07/2012 Property Taxes/Assessments (775.82) (1,042,990.51) GL 787 03/09/2012 Property Taxes/Assessments 1,025.84 (1,041,964.67) GL 788 03/12/2012 Property Taxes/Assessments (977.36) (1,042,942.03) GL 791 03/13/2012 Property Taxes/Assessments (509.30) (1,043,451.33) GL 792 03/14/2012 Property Taxes/Assessments (299.28) (1,043,750.61) GL 793 03/15/2012 Property Taxes/Assessments (1.05) (1,043,751.66) GL . glpdatb2 rgonzale Trophy Club Entities Page 2 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 794 03/16/2012 Property Taxes/Assessments (1,040,488.55) (130.92) (1,043,882.58) GL 795 03/19/2012 Property Taxes/Assessments (408.29) (1,044,290.87) GL 796 03/20/2012 Property Taxes/Assessments (79.20) (1,044,370.07) GL 797 03/21/2012 Property Taxes/Assessments (86.50) (1,044,456.57) GL 798 03/22/2012 Property Taxes/Assessments (52.40) (1,044,508.97) GL 799 03/23/2012 Property Taxes/Assessments (544.06) (1,045,053.03) GL 800 03/26/2012 Property Taxes/Assessments (490.01) (1,045,543.04) GL 801 03/27/2012 Property Taxes/Assessments (340.94) (1,045,883.98) GL 802 03/28/2012 Property Taxes/Assessments (220.21) (1,046,104.19) GL 803 03/29/2012 Property Taxes/Assessments (93.86) (1,046,198.05) GL 804 03/30/2012 Property Taxes/Assessments (385.62) (1,046,583.67) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (6,095.12) (1,046,583.67) ** (1,076,976.00) Budgeted (30,392.33) Remaining 97 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 784 03/06/2012 Property Taxes/Assessments 5,271.08 136.12 5,407.20 GL 784 03/06/2012 Property Taxes/Assessments 191.38 5,598.58 GL 785 03/07/2012 Property Taxes/Assessments (110.10) 5,488.48 GL 785 03/07/2012 Property Taxes/Assessments (53.74) 5,434.74 GL 787 03/09/2012 Property Taxes/Assessments 27.32 5,462.06 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 190.98 5,462.06 ** (5,603.00) Budgeted (11,065.06) Remaining -97 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 783 03/05/2012 Property Taxes/Assessments (773.65) (67.91) (841.56) GL 788 03/12/2012 Property Taxes/Assessments (15.34) (856.90) GL 794 03/16/2012 Property Taxes/Assessments (4.93) (861.83) GL 796 03/20/2012 Property Taxes/Assessments (28.50) (890.33) GL 797 03/21/2012 Property Taxes/Assessments (15.75) (906.08) GL 800 03/26/2012 Property Taxes/Assessments (16.36) (922.44) GL 801 03/27/2012 Property Taxes/Assessments (29.93) (952.37) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (178.72) (952.37) ** (725.00) Budgeted 227.37 Remaining 131 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 781 03/01/2012 Property Taxes/Assessments (1,265.77) (20.53) (1,286.30) GL 782 03/02/2012 Property Taxes/Assessments (35.17) (1,321.47) GL . glpdatb2 rgonzale Trophy Club Entities Page 3 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 783 03/05/2012 Property Taxes/Assessments (1,265.77) (35.49) (1,356.96) GL 784 03/06/2012 Property Taxes/Assessments (26.40) (1,383.36) GL 785 03/07/2012 Property Taxes/Assessments (77.88) (1,461.24) GL 785 03/07/2012 Property Taxes/Assessments (20.41) (1,481.65) GL 788 03/12/2012 Property Taxes/Assessments (56.87) (1,538.52) GL 791 03/13/2012 Property Taxes/Assessments (28.35) (1,566.87) GL 792 03/14/2012 Property Taxes/Assessments (26.94) (1,593.81) GL 793 03/15/2012 Property Taxes/Assessments (.10) (1,593.91) GL 794 03/16/2012 Property Taxes/Assessments (6.32) (1,600.23) GL 795 03/19/2012 Property Taxes/Assessments (32.71) (1,632.94) GL 799 03/23/2012 Property Taxes/Assessments (43.34) (1,676.28) GL 800 03/26/2012 Property Taxes/Assessments (36.47) (1,712.75) GL 801 03/27/2012 Property Taxes/Assessments (20.24) (1,732.99) GL 802 03/28/2012 Property Taxes/Assessments (14.74) (1,747.73) GL 803 03/29/2012 Property Taxes/Assessments (3.97) (1,751.70) GL 804 03/30/2012 Property Taxes/Assessments (21.56) (1,773.26) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (507.49) (1,773.26) ** (7,500.00) Budgeted (5,726.74) Remaining 24 % Used Account: 122-42014-000-000 Fire Permits/Sprinkler 723 03/01/2012 Permits 3/1/12 (5,600.00) (400.00) (6,000.00) GL _______________ Account: 122-42014-000-000 Fire Permits/Sprinkler Totals: (400.00) (6,000.00) ** (2,000.00) Budgeted 4,000.00 Remaining 300 % Used Account: 122-43400-000-000 Fire Inspections 723 03/01/2012 Permits 3/1/12 (1,050.00) (75.00) (1,125.00) GL _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (1,125.00) ** (500.00) Budgeted 625.00 Remaining 225 % 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-43599-000-000 Misc Fire Revenue . glpdatb2 rgonzale Trophy Club Entities Page 4 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/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: 122-43599-000-000 Misc Fire Revenue Totals: .00 .00 ** (1,124.00) Budgeted (1,124.00) Remaining 0 % Used Account: 122-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (4,373.00) Budgeted (4,373.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 723 03/01/2012 Permits 3/1/12 (8,396.95) (525.00) (8,921.95) GL 723 03/01/2012 Permits 3/1/12 (100.00) (9,021.95) GL 726 03/06/2012 Permits 3/6/12 (100.00) (9,121.95) GL _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (725.00) (9,121.95) ** (5,000.00) Budgeted 4,121.95 Remaining 182 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,261,159.20) ** (1,311,934.00) Budgeted (50,774.80) Remaining 96 % Used . glpdatb2 rgonzale Trophy Club Entities Page 5 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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 538 03/02/2012 PAYROLL 3/2/12 Salaries & Wages 155,022.70 17,599.72 172,622.42 PR 647 03/16/2012 PAYROLL 3/16/12 Salaries & Wages 16,309.15 188,931.57 PR 696 03/30/2012 PAYROLL 3/30/12 Salaries & Wages 16,716.74 205,648.31 PR _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 50,625.61 205,648.31 ** 425,748.00 Budgeted 220,099.69 Remaining 48 % Used Account: 122-50010-045-000 Overtime 647 03/16/2012 PAYROLL 3/16/12 Overtime 19,822.65 2,802.71 22,625.36 PR _______________ Account: 122-50010-045-000 Overtime Totals: 2,802.71 22,625.36 ** 42,000.00 Budgeted 19,374.64 Remaining 54 % 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 ** 12,133.00 Budgeted (1,640.02) Remaining 114 % 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 647 03/16/2012 PAYROLL 3/16/12 Certification 2,558.50 494.70 3,053.20 PR _______________ Account: 122-50017-045-000 Certification Totals: 494.70 3,053.20 ** 4,073.00 Budgeted 1,019.80 Remaining 75 % Used Account: 122-50020-045-000 Retirement 538 03/02/2012 PAYROLL 3/2/12 Retirement 27,337.66 2,147.18 29,484.84 PR 647 03/16/2012 PAYROLL 3/16/12 Retirement 2,521.30 32,006.14 PR 696 03/30/2012 PAYROLL 3/30/12 Retirement 2,147.21 34,153.35 PR _______________ Account: 122-50020-045-000 Retirement Totals: 6,815.69 34,153.35 ** 68,264.00 Budgeted 34,110.65 Remaining 50 % Used . glpdatb2 rgonzale Trophy Club Entities Page 6 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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 538 03/02/2012 PAYROLL 3/2/12 Medical Insurance 16,699.14 1,663.55 18,362.69 PR 647 03/16/2012 PAYROLL 3/16/12 Medical Insurance 1,680.03 20,042.72 PR _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,343.58 20,042.72 ** 53,184.00 Budgeted 33,141.28 Remaining 38 % Used Account: 122-50027-045-000 Dental Insurance 538 03/02/2012 PAYROLL 3/2/12 Dental Insurance 1,459.35 145.25 1,604.60 PR 647 03/16/2012 PAYROLL 3/16/12 Dental Insurance 147.12 1,751.72 PR _______________ Account: 122-50027-045-000 Dental Insurance Totals: 292.37 1,751.72 ** 3,288.00 Budgeted 1,536.28 Remaining 53 % Used Account: 122-50028-045-000 Vision Insurance 538 03/02/2012 PAYROLL 3/2/12 Vision Insurance 329.67 32.84 362.51 PR 647 03/16/2012 PAYROLL 3/16/12 Vision Insurance 33.15 395.66 PR _______________ Account: 122-50028-045-000 Vision Insurance Totals: 65.99 395.66 ** 857.00 Budgeted 461.34 Remaining 46 % 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 538 03/02/2012 PAYROLL 3/2/12 Social Security Taxes 11,648.00 998.36 12,646.36 PR 647 03/16/2012 PAYROLL 3/16/12 Social Security Taxes 1,122.02 13,768.38 PR 696 03/30/2012 PAYROLL 3/30/12 Social Security Taxes 1,036.45 14,804.83 PR _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 3,156.83 14,804.83 ** 30,231.00 Budgeted 15,426.17 Remaining 49 % Used Account: 122-50035-045-000 Medicare Taxes 538 03/02/2012 PAYROLL 3/2/12 Medicare Taxes 2,724.26 233.49 2,957.75 PR 647 03/16/2012 PAYROLL 3/16/12 Medicare Taxes 262.37 3,220.12 PR . glpdatb2 rgonzale Trophy Club Entities Page 7 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 696 03/30/2012 PAYROLL 3/30/12 Medicare Taxes 2,724.26 242.39 3,462.51 PR _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 738.25 3,462.51 ** 7,070.00 Budgeted 3,607.49 Remaining 49 % Used Account: 122-50040-045-000 Unemployment Taxes 538 03/02/2012 PAYROLL 3/2/12 Unemployment Taxes 557.71 31.84 589.55 PR 647 03/16/2012 PAYROLL 3/16/12 Unemployment Taxes 10.90 600.45 PR 696 03/30/2012 PAYROLL 3/30/12 Unemployment Taxes 9.44 609.89 PR _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 52.18 609.89 ** 1,476.00 Budgeted 866.11 Remaining 41 % Used Account: 122-50045-045-000 Workman's Compensation 767 03/31/2012 March A/P Add Volunteer Firefighters 8,309.50 899.19 9,208.69 TML INTERGOVERNMENTAL RISK 31377 AP _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 899.19 9,208.69 ** 8,793.00 Budgeted (415.69) Remaining 105 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 697 03/27/2012 March A/P Pre Emp testing 52.45 36.55 89.00 CARENOW CORPORATE 31323 AP _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: 36.55 89.00 ** 675.00 Budgeted 586.00 Remaining 13 % Used Account: 122-55080-045-000 Maintenance & Repairs 697 03/27/2012 March A/P Feb PCards 1,228.21 236.00 1,464.21 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 861.00 2,325.21 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 184.25 2,509.46 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 7.18 2,516.64 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,288.43 2,516.64 ** 9,562.00 Budgeted 7,045.36 Remaining 26 % Used Account: 122-55090-045-000 Vehicle Maintenance 1,800.22 .00 1,800.22 _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: .00 1,800.22 ** 14,850.00 Budgeted 13,049.78 Remaining 12 % Used . glpdatb2 rgonzale Trophy Club Entities Page 8 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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-55095-045-000 Equipment Maintenance 4,137.18 .00 4,137.18 _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: .00 4,137.18 ** 9,808.00 Budgeted 5,670.82 Remaining 42 % Used Account: 122-55100-045-000 Building Maintenance 697 03/27/2012 March A/P Feb PCards 2,655.03 152.56 2,807.59 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 128.41 2,936.00 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 9.97 2,945.97 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 129.71 3,075.68 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Repair ice machine 177.50 3,253.18 INTERCOOL INC 31333 AP 735 03/28/2012 3/28/12 Deposits Firefighters Cable/Mar (120.00) 3,133.18 GL _______________ Account: 122-55100-045-000 Building Maintenance Totals: 478.15 3,133.18 ** 11,000.00 Budgeted 7,866.82 Remaining 28 % Used Account: 122-55110-045-000 Maintenance-Radios 697 03/27/2012 March A/P Feb PCards 393.00 393.00 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: 393.00 393.00 ** 1,103.00 Budgeted 710.00 Remaining 36 % Used Account: 122-55160-045-000 Professional Outside Services .00 .00 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 122-60005-045-000 Telephone 767 03/31/2012 March A/P March PCards-Zieverink 22.28 5.13 27.41 BANK OF AMERICA 31359 AP _______________ Account: 122-60005-045-000 Telephone Totals: 5.13 27.41 ** 106.00 Budgeted 78.59 Remaining 26 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 767 03/31/2012 March A/P Cell phone 1,018.17 193.95 1,212.12 VERIZON WIRELESS 31387 AP . glpdatb2 rgonzale Trophy Club Entities Page 9 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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 Totals: 193.95 1,212.12 ** 4,411.00 Budgeted 3,198.88 Remaining 27 % Used Account: 122-60020-045-000 Electricity/Gas 697 03/27/2012 March A/P Electricity 2/15-3/15/12 4,903.03 752.26 5,655.29 HUDSON ENERGY 31332 AP 697 03/27/2012 March A/P Gas 2/20-3/21 108.19 5,763.48 ATMOS ENERGY 31321 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 860.45 5,763.48 ** 18,270.00 Budgeted 12,506.52 Remaining 32 % Used Account: 122-60025-045-000 Water 697 03/27/2012 March A/P Feb Water 1,384.50 125.02 1,509.52 TROPHY CLUB MUD (WATER BILLS) 31353 AP 697 03/27/2012 March A/P Feb Water 12.71 1,522.23 TROPHY CLUB MUD (WATER BILLS) 31353 AP 767 03/31/2012 March A/P March water 130.92 1,653.15 TROPHY CLUB MUD (WATER BILLS) 31385 AP 767 03/31/2012 March A/P March water 12.71 1,665.86 TROPHY CLUB MUD (WATER BILLS) 31385 AP _______________ Account: 122-60025-045-000 Water Totals: 281.36 1,665.86 ** 3,289.00 Budgeted 1,623.14 Remaining 51 % 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 826 03/31/2012 February Postage 12.35 7.50 19.85 GL 827 03/31/2012 March Postage 3.50 23.35 GL _______________ Account: 122-60035-045-000 Postage Totals: 11.00 23.35 ** 97.00 Budgeted 73.65 Remaining 24 % 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 . glpdatb2 rgonzale Trophy Club Entities Page 10 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 401.00 Budgeted 401.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 697 03/27/2012 March A/P Dues 6,130.34 50.00 6,180.34 TX FIRE MARSHAL'S ASSOC 31355 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 50.00 6,180.34 ** 8,560.00 Budgeted 2,379.66 Remaining 72 % Used Account: 122-60075-045-000 Meetings 22.00 .00 22.00 _______________ Account: 122-60075-045-000 Meetings Totals: .00 22.00 ** .00 Budgeted (22.00) Remaining 0 % Used Account: 122-60080-045-000 Schools & Training 697 03/27/2012 March A/P Test for Cert/Tackett 1,112.47 85.00 1,197.47 TX COMM ON FIRE PROTECTION 31354 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 85.00 1,197.47 ** 6,946.00 Budgeted 5,748.53 Remaining 17 % 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 697 03/27/2012 March A/P Feb PCards 1,632.43 13.66 1,646.09 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 122-60100-045-000 Travel & per diem Totals: 13.66 1,646.09 ** 6,788.00 Budgeted 5,141.91 Remaining 24 % Used Account: 122-60110-045-000 Physicals/Testing . glpdatb2 rgonzale Trophy Club Entities Page 11 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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: 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 697 03/27/2012 March A/P Binder 1,834.11 2.24 1,836.35 OFFICE DEPOT, INC 31340 AP 767 03/31/2012 March A/P Office supplies 13.22 1,849.57 OFFICE DEPOT, INC 31369 AP _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 15.46 1,849.57 ** 4,162.00 Budgeted 2,312.43 Remaining 44 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 697 03/27/2012 March A/P Feb PCards 385.58 9.37 394.95 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 9.37 394.95 ** 1,900.00 Budgeted 1,505.05 Remaining 21 % Used Account: 122-60195-045-000 Flags & Repair 697 03/27/2012 March A/P Flag & Repair 552.50 460.00 1,012.50 SYMONDS FLAGS & POLES 31350 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 460.00 1,012.50 ** 2,543.00 Budgeted 1,530.50 Remaining 40 % Used Account: 122-60245-045-000 Miscellaneous Expense 697 03/27/2012 March A/P Feb PCards 541.42 121.45 662.87 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 121.45 662.87 ** 1,237.00 Budgeted 574.13 Remaining 54 % Used Account: 122-65005-045-000 Fuel & Lube . glpdatb2 rgonzale Trophy Club Entities Page 12 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 840 03/01/2012 Fire Gas Log/Dec-not on JE337 1,432.16 840.42 2,272.58 GL 697 03/27/2012 March A/P Feb PCards 43.10 2,315.68 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 117.54 2,433.22 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Gas Purchases/Feb 182.49 2,615.71 VALERO MARKETING & SUPPLY 31356 AP _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 1,183.55 2,615.71 ** 17,414.00 Budgeted 14,798.29 Remaining 15 % Used Account: 122-65010-045-000 Uniforms 697 03/27/2012 March A/P Feb PCards 1,057.60 183.25 1,240.85 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 44.88 1,285.73 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 228.13 1,285.73 ** 4,357.00 Budgeted 3,071.27 Remaining 30 % Used Account: 122-65015-045-000 Protective Clothing 83.50 .00 83.50 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 83.50 ** 7,600.00 Budgeted 7,516.50 Remaining 1 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 1,545.00 Budgeted 1,545.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 697 03/27/2012 March A/P Feb PCards 469.96 768.00 1,237.96 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 227.00 1,464.96 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 122-65035-045-000 Small Tools Totals: 995.00 1,464.96 ** 8,371.00 Budgeted 6,906.04 Remaining 18 % Used Account: 122-65085-045-000 Office Supplies 632.64 .00 632.64 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 632.64 ** 329.00 Budgeted (303.64) Remaining 192 % Used . glpdatb2 rgonzale Trophy Club Entities Page 13 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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 697 03/27/2012 March A/P Feb PCards 811.74 34.24 845.98 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 10.94 856.92 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 45.18 856.92 ** 2,785.00 Budgeted 1,928.08 Remaining 31 % 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 697 03/27/2012 March A/P Feb PCards 13,260.52 72.57 13,333.09 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 122-69035-045-000 Vehicles Totals: 72.57 13,333.09 ** 13,709.00 Budgeted 375.91 Remaining 97 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 41,890.00 Budgeted 41,890.00 Remaining 0 % Used Account: 122-69251-045-000 Engine 681 Payment . glpdatb2 rgonzale Trophy Club Entities Page 14 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 4,351.65 .00 4,351.65 _______________ Account: 122-69251-045-000 Engine 681 Payment Totals: .00 4,351.65 ** 73,203.00 Budgeted 68,851.35 Remaining 6 % Used Account: 122-69255-045-000 Airpacks .00 .00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 13,865.00 Budgeted 13,865.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 708,697.92 ** 1,311,934.00 Budgeted 603,236.08 Remaining 54 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (552,461.28) .00 Budgeted 552,461.28 Remaining 0 % Used Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 3/31/2012 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 549,191 INVESTMENTS 2,875,720 RESTRICTED ASSETS: INVESTMENTS 417,276 PREPAID EXPENSES 4,387 ADVALOREM PROPERTY TAXES RECEIVABLE 5,328 UTILITY AND OTHER ACCOUNTS RECEIVABLE 353,774 TOTAL ASSETS 4,206,077$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 5,328$ ACCOUNTS PAYABLE 1,000,244 CUSTOMER DEPOSITS 197,862 TOTAL LIABILITIES 1,203,434 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT/WATER 60,000 DESIGNATED FOR FUTURE ASSET REPLACEMENT/TECHNOLOGY 159,414 UNDESIGNATED FUND BALANCE 2,783,228 TOTAL FUND BALANCE 3,002,642 TOTAL LIABILITIES AND FUND BALANCE 4,206,077$ March 31, 2012 6/12 Months (50% of Fiscal Year) . glbase_tbam rgonzale Trophy Club Entities Page 4 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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- 551.75- 94,743.34- 97.178 2,751.66- 135-40002-000-000 Property Taxes/Delinquent 451.00- 30.42 671.79 -148.956 1,122.79- 135-40015-000-000 Property Taxes/P & I 1,334.00- 1,334.00- 47.12- 90.76 -6.804 1,424.76- Subtotal: 98,829.00- 99,280.00- 568.45- 93,980.79- 94.662 5,299.21- 135-43215-000-000 Insurance Settlement 3,999.00- 3,999.00 Subtotal: 3,999.00- 3,999.00 135-47000-000-000 Water 1,990,800.00- 1,990,800.00- 92,206.33- 568,535.00- 28.558 1,422,265.00- 135-47005-000-000 Sewer 1,325,000.00- 1,325,000.00- 75,434.24- 437,125.82- 32.991 887,874.18- 135-47010-000-000 Commercial Water 825,000.00- 825,000.00- 31,614.58- 269,282.84- 32.640 555,717.16- 135-47015-000-000 Commercial Sewer 360,000.00- 360,000.00- 19,343.29- 129,181.78- 35.884 230,818.22- 135-47020-000-000 Standby 775.00- 775.00- 60.00- 371.00- 47.871 404.00- 135-47025-000-000 Penalties 50,500.00- 50,500.00- 2,787.36- 26,498.38- 52.472 24,001.62- 135-47030-000-000 Service Charges 17,500.00- 17,500.00- 553.00- 7,242.38- 41.385 10,257.62- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 200.00- 1,050.00- 87.500 150.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 600.00- 3,150.00- 70.000 1,350.00- 135-47070-000-000 TCCC Effluent Charges 57,500.00- 57,500.00- 8,212.62- 14.283 49,287.38- 135-47270-000-000 Fire Line 5,000.00- 5,000.00- 5,000.00- 135-47400-000-000 Water-Out of Dist/Port Meters 41,595.00- 41,595.00- 2,823.64- 18,885.74- 45.404 22,709.26- 135-47405-000-000 Out of District Sewer 11,807.00- 11,807.00- 51,210.73 5,651.78- 47.868 6,155.22- 135-47410-000-000 Out of Dist/Portable Penalties 300.00- 300.00- 28.31- 9.437 271.69- 135-47600-000-000 PID #1 Water 425,000.00- 425,000.00- 27,902.37- 178,226.89- 41.936 246,773.11- 135-47605-000-000 PID #1 Sewer 185,000.00- 185,000.00- 18,507.83- 104,434.70- 56.451 80,565.30- Subtotal: 5,301,477.00- 5,301,477.00- 220,821.91- 1,757,877.24- 33.158 3,543,599.76- 135-48005-000-000 Utility Fees 338,880.00- 338,880.00- 57,500.00- 373,380.00- 110.181 34,500.00 Subtotal: 338,880.00- 338,880.00- 57,500.00- 373,380.00- 110.181 34,500.00 135-49005-000-000 Loan Proceeds 1,100,000.00- 1,100,000.00 135-49010-000-000 Interest Income 4,500.00- 4,500.00- 524.23- 2,399.88- 53.331 2,100.12- 135-49016-000-000 Cell Tower Revenue 10,164.00- 847.00- 5,082.00- 50.000 5,082.00- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 3,499.98- 50.000 3,500.02- 135-49030-000-000 Vending Revenue 600.00- 600.00- 32.50- 5.417 567.50- 135-49035-000-000 Prior Year Reserves 241,981.00- 265,707.00- 265,707.00- 135-49036-000-000 GASB Reserves 26,911.00- 26,911.00- 26,911.00- 135-49075-000-000 Oversize Meter Reimbursement 64,000.00- 64,000.00- 10,111.00- 59,348.80- 92.733 4,651.20- 135-49900-000-000 Miscellaneous Income 10,000.00- 10,000.00- 75.00- 2,778.11- 27.781 7,221.89- 135-49905-000-000 Gas Well Revenue 800.00- 800.00- 123.00- 15.375 677.00- . glbase_tbam rgonzale Trophy Club Entities Page 5 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 355,792.00- 389,682.00- 12,140.56- 1,173,264.27- 301.082 783,582.27 Program number: 6,094,978.00- 6,129,319.00- 291,030.92- 3,402,501.30- 55.512 2,726,817.70- Department number: Revenues 6,094,978.00- 6,129,319.00- 291,030.92- 3,402,501.30- 55.512 2,726,817.70- Revenues Subtotal ----------- 6,094,978.00- 6,129,319.00- 291,030.92- 3,402,501.30- 55.512 2,726,817.70- . glbase_tbam rgonzale Trophy Club Entities Page 6 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 199,759.00 18,871.41 78,680.11 39.388 121,078.89 135-50010-010-000 Overtime 13,250.00 13,250.00 2,007.62 7,941.02 59.932 5,308.98 135-50016-010-000 Longevity 2,620.00 2,620.00 2,620.00 100.000 135-50017-010-000 Certification 1,800.00 1,800.00 150.00 900.00 50.000 900.00 135-50020-010-000 Retirement 25,508.00 25,508.00 2,906.22 13,073.07 51.251 12,434.93 135-50026-010-000 Medical Insurance 22,607.00 22,607.00 1,642.80 11,062.50 48.934 11,544.50 135-50027-010-000 Dental Insurance 2,169.00 2,169.00 125.20 796.60 36.727 1,372.40 135-50028-010-000 Vision Insurance 576.00 576.00 31.76 190.56 33.083 385.44 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 13,481.00 1,279.35 5,506.93 40.850 7,974.07 135-50035-010-000 Medicare Taxes 3,153.00 3,153.00 299.21 1,287.91 40.847 1,865.09 135-50040-010-000 Unemployment Taxes 945.00 945.00 63.65 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 44.45 92.04 26.297 257.96 Subtotal: 293,160.00 293,160.00 27,421.67 128,019.74 43.669 165,140.26 135-55005-010-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-010-000 Independent Labor 500.00 500.00 500.00 135-55080-010-000 Maintenance & Repairs 29,500.00 29,500.00 3,002.04 12,266.75 41.582 17,233.25 135-55090-010-000 Vehicle Maintenance 3,380.00 3,380.00 78.00 1,967.77 58.218 1,412.23 135-55100-010-000 Building Maint & Supplies 750.00 750.00 471.85 62.913 278.15 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 14.49 464.49 16.017 2,435.51 135-55135-010-000 Lab Analysis 4,500.00 4,500.00 480.00 1,220.00 27.111 3,280.00 Subtotal: 43,030.00 43,030.00 3,574.53 16,390.86 38.092 26,639.14 135-60010-010-000 Communications/Pagers/Mobiles 1,599.00 1,599.00 177.90 1,006.56 62.949 592.44 135-60020-010-000 Electricity 162,000.00 162,000.00 2,158.52 24,526.71 15.140 137,473.29 135-60035-010-000 Postage 500.00 500.00 6.51 1.302 493.49 135-60050-010-000 Bad Debt Expense 4,200.00 4,200.00 4,200.00 135-60066-010-000 Publications/Books/Subscripts 50.00 50.00 85.00 85.00 170.000 35.00- 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 135-60080-010-000 Schools & Training 2,800.00 2,800.00 321.00 1,082.00 38.643 1,718.00 135-60090-010-000 Safety Program 500.00 500.00 500.00 135-60100-010-000 Travel & per diem 3,200.00 3,200.00 260.30 937.45 29.295 2,262.55 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 Annual Permit Fee 6,600.00 6,600.00 7,965.75 120.693 1,365.75- 135-60150-010-000 Wholesale Water 1,720,000.00 1,720,000.00 84,974.25 547,426.41 31.827 1,172,573.59 135-60245-010-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 360.00 360.00 8.571 3,840.00 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 2,000.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 1,500.00 299.99 19.999 1,200.01 . glbase_tbam rgonzale Trophy Club Entities Page 7 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 1,910,799.00 1,910,799.00 88,336.97 583,696.38 30.547 1,327,102.62 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 1,078.27 6,033.76 39.654 9,182.24 135-65010-010-000 Uniforms 3,690.00 3,690.00 1,024.15 27.755 2,665.85 135-65030-010-000 Chemicals 6,200.00 6,200.00 1,066.47 17.201 5,133.53 135-65035-010-000 Small Tools 2,500.00 2,500.00 68.00 2.720 2,432.00 135-65040-010-000 Safety Equipment 2,500.00 2,500.00 287.82 287.82 11.513 2,212.18 135-65050-010-000 Meter Expense 85,000.00 85,000.00 63,619.07 74.846 21,380.93 135-65055-010-000 Hardware 1,000.00 1,000.00 1,000.00 135-65095-010-000 Maintenance Supplies 32,000.00 32,000.00 10,222.57 31.946 21,777.43 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 148,306.00 1,366.09 82,380.34 55.548 65,925.66 135-69005-010-000 Capital Expenses 888,432.00 888,432.00 350,304.45 1,265,870.59 142.484 377,438.59- 135-69035-010-000 Vehicles 27,000.00 27,000.00 30,213.69 111.903 3,213.69- 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 24,000.00 24,000.00 24,000.00 135-69281-010-000 Capital Repair-Ground Storage 124,771.00 124,771.00 100,816.54 80.801 23,954.46 135-69295-010-000 Unexpected Maintenance 250.00 250.00 250.00 135-69305-010-000 Capital Leases 11,490.00 11,490.00 10,145.26 10,145.26 88.296 1,344.74 Subtotal: 1,105,943.00 1,105,943.00 360,449.71 1,407,046.08 127.226 301,103.08- Program number: 3,501,238.00 3,501,238.00 481,148.97 2,217,533.40 63.336 1,283,704.60 Department number: Water 3,501,238.00 3,501,238.00 481,148.97 2,217,533.40 63.336 1,283,704.60 . glbase_tbam rgonzale Trophy Club Entities Page 8 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 21,175.53 99,088.58 54.400 83,058.42 135-50010-020-000 Overtime 10,166.00 10,166.00 1,310.46 6,291.38 61.886 3,874.62 135-50016-020-000 Longevity 3,976.00 3,976.00 3,975.00 99.975 1.00 135-50017-020-000 Certification 2,400.00 2,400.00 125.00 825.00 34.375 1,575.00 135-50020-020-000 Retirement 27,816.00 27,816.00 3,124.84 15,930.79 57.272 11,885.21 135-50026-020-000 Medical Insurance 30,805.00 30,805.00 2,145.38 12,803.14 41.562 18,001.86 135-50027-020-000 Dental Insurance 1,981.00 1,981.00 165.36 984.34 49.689 996.66 135-50028-020-000 Vision Insurance 552.00 552.00 41.20 245.16 44.413 306.84 135-50029-020-000 Life Insurance & Other 884.00 884.00 884.00 135-50030-020-000 Social Security Taxes 8,597.00 8,597.00 1,306.92 6,440.94 74.921 2,156.06 135-50035-020-000 Medicare Taxes 2,011.00 2,011.00 305.65 1,506.33 74.905 504.67 135-50040-020-000 Unemployment Taxes 567.00 567.00 48.18 315.84 55.704 251.16 135-50045-020-000 Workman's Compensation 2,685.00 2,685.00 2,685.00 100.000 135-50060-020-000 Pre-emp Physicals/Testing 200.00 30.45 15.225 169.55 135-50070-020-000 Employee Relations 350.00 350.00 44.45 64.45 18.414 285.55 Subtotal: 274,937.00 275,137.00 29,792.97 151,186.40 54.949 123,950.60 135-55070-020-000 Independent Labor 750.00 750.00 600.00 1,905.67 254.089 1,155.67- 135-55080-020-000 Maintenance & Repairs 17,750.00 17,750.00 4,584.87 19,862.97 111.904 2,112.97- 135-55090-020-000 Vehicle Maintenance 4,998.00 4,998.00 194.95 3.901 4,803.05 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 1,400.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 14.50 148.50 5.034 2,801.50 135-55125-020-000 Dumpster Services 35,000.00 35,000.00 537.50 10,212.50 29.179 24,787.50 135-55135-020-000 Lab Analysis 22,760.00 22,760.00 6,065.55 10,506.12 46.160 12,253.88 Subtotal: 85,608.00 85,608.00 11,802.42 42,830.71 50.031 42,777.29 135-60005-020-000 Telephone 100.00 10.59 10.590 89.41 135-60010-020-000 Communications/Pagers/Mobiles 3,000.00 3,000.00 253.95 1,378.73 45.958 1,621.27 135-60020-020-000 Electricity 205,000.00 205,000.00 813.38 24,121.12 11.766 180,878.88 135-60025-020-000 Water 1,900.00 1,900.00 88.42 1,226.15 64.534 673.85 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 1,320.00 135-60090-020-000 Safety Program 200.00 200.00 116.45 116.45 58.225 83.55 135-60100-020-000 Travel & per diem 1,750.00 1,750.00 344.66 1,090.58 62.319 659.42 135-60105-020-000 Rent/Lease Equipment 200.00 200.00 901.30 450.650 701.30- 135-60125-020-000 Advertising 1,000.00 987.36 98.736 12.64 135-60135-020-000 Annual Permit Fee 7,500.00 7,500.00 7,432.50 99.100 67.50 135-60245-020-000 Miscellaneous Expenses 525.00 525.00 64.00 12.190 461.00 135-60285-020-000 Lawn Equipment & Maintenance 525.00 525.00 525.00 Subtotal: 222,540.00 223,640.00 1,616.86 37,766.95 16.887 185,873.05 . glbase_tbam rgonzale Trophy Club Entities Page 9 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 269.88 1,570.61 22.845 5,304.39 135-65010-020-000 Uniforms 3,140.00 3,140.00 202.00 1,118.93 35.635 2,021.07 135-65030-020-000 Chemicals 13,180.00 13,180.00 680.00 3,237.57 24.564 9,942.43 135-65035-020-000 Small Tools 1,260.00 1,260.00 1,260.00 135-65040-020-000 Safety Equipment 925.00 925.00 22.75 2.459 902.25 135-65045-020-000 Lab Supplies 19,160.00 19,160.00 456.34 3,156.18 16.473 16,003.82 135-65055-020-000 Hardware 525.00 525.00 525.00 135-65085-020-000 Office Supplies 400.00 400.00 50.58 12.645 349.42 135-65095-020-000 Maintenance Supplies 8,860.00 8,860.00 953.32 10.760 7,906.68 135-65115-020-000 Other Consumables 110.00 110.00 110.00 Subtotal: 54,435.00 54,435.00 1,608.22 10,109.94 18.572 44,325.06 135-69005-020-000 Capital Expenses 161,189.00 161,189.00 43,592.56 27.044 117,596.44 135-69280-020-000 Capital Repairs 56,000.00 56,000.00 56,000.00 Subtotal: 217,189.00 217,189.00 43,592.56 20.071 173,596.44 Program number: 854,709.00 856,009.00 44,820.47 285,486.56 33.351 570,522.44 Department number: Wastewater 854,709.00 856,009.00 44,820.47 285,486.56 33.351 570,522.44 . glbase_tbam rgonzale Trophy Club Entities Page 10 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 145,481.00 145,481.00 16,619.55 69,259.35 47.607 76,221.65 135-50010-021-000 Overtime 7,297.00 7,297.00 867.27 4,288.46 58.770 3,008.54 135-50016-021-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50017-021-000 Certification 1,500.00 1,500.00 125.00 750.00 50.000 750.00 135-50020-021-000 Retirement 21,074.00 21,074.00 2,433.95 11,303.21 53.636 9,770.79 135-50026-021-000 Medical Insurance 22,983.00 22,983.00 1,702.68 10,216.08 44.451 12,766.92 135-50027-021-000 Dental Insurance 1,533.00 1,533.00 117.38 704.28 45.941 828.72 135-50028-021-000 Vision Insurance 357.00 357.00 29.72 178.32 49.950 178.68 135-50029-021-000 Life Insurance & Other 978.00 978.00 978.00 135-50030-021-000 Social Security Taxes 9,785.00 9,785.00 1,032.96 4,656.57 47.589 5,128.43 135-50035-021-000 Medicare Taxes 2,288.00 2,288.00 241.58 1,089.04 47.598 1,198.96 135-50040-021-000 Unemployment Taxes 567.00 567.00 35.90 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 44.46 64.43 25.772 185.57 Subtotal: 220,697.00 220,697.00 23,250.45 109,329.24 49.538 111,367.76 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-021-000 Independent Labor 200.00 200.00 200.00 135-55080-021-000 Maintenance & Repairs 23,700.00 23,700.00 248.00 3,783.85 15.966 19,916.15 135-55090-021-000 Vehicle Maintenance 1,943.00 1,943.00 79.50 209.50 10.782 1,733.50 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 28,093.00 28,093.00 327.50 3,993.35 14.215 24,099.65 135-60005-021-000 Telephone 50.00 2.29 14.21 28.420 35.79 135-60010-021-000 Communications/Pagers/Mobiles 2,796.00 2,796.00 207.52 1,752.11 62.665 1,043.89 135-60020-021-000 Electricity 23,625.00 23,625.00 1,211.01 4,652.43 19.693 18,972.57 135-60025-021-000 Water 750.00 750.00 750.00 135-60035-021-000 Postage 150.00 150.00 150.00 135-60070-021-000 Dues & Memberships 255.00 255.00 255.00 135-60080-021-000 Schools & Training 2,818.00 2,818.00 2,818.00 135-60090-021-000 Safety Program 750.00 750.00 750.00 135-60100-021-000 Travel & per diem 1,500.00 1,500.00 42.19 429.05 28.603 1,070.95 135-60105-021-000 Rent/Lease Equipment 44,107.00 76,098.00 76,098.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60280-021-000 Property Maintenance 1,000.00 1,000.00 1,000.00 Subtotal: 77,851.00 109,892.00 1,463.01 6,847.80 6.231 103,044.20 135-65005-021-000 Fuel & Lube 11,700.00 11,700.00 409.06 4,004.35 34.225 7,695.65 135-65010-021-000 Uniforms 2,505.00 2,505.00 620.98 24.790 1,884.02 135-65030-021-000 Chemicals 12,500.00 12,500.00 12,500.00 135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00 . glbase_tbam rgonzale Trophy Club Entities Page 11 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65040-021-000 Safety Equipment 1,150.00 1,150.00 22.74 1.977 1,127.26 135-65055-021-000 Hardware 750.00 750.00 44.95 5.993 705.05 135-65095-021-000 Maintenance Supplies 16,050.00 16,050.00 204.14 1.272 15,845.86 Subtotal: 46,155.00 46,155.00 409.06 4,897.16 10.610 41,257.84 135-69005-021-000 Capital Expenses 15,000.00 15,000.00 31,991.00 213.273 16,991.00- 135-69280-021-000 Capital Repairs 20,000.00 20,000.00 20,000.00 Subtotal: 35,000.00 35,000.00 31,991.00 91.403 3,009.00 Program number: 407,796.00 439,837.00 25,450.02 157,058.55 35.708 282,778.45 Department number: Collection 407,796.00 439,837.00 25,450.02 157,058.55 35.708 282,778.45 . glbase_tbam rgonzale Trophy Club Entities Page 12 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/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 1,900.00 4,900.00 49.000 5,100.00 135-50030-026-000 Social Security Taxes 620.00 620.00 117.80 303.80 49.000 316.20 135-50035-026-000 Medicare Taxes 145.00 145.00 27.55 71.05 49.000 73.95 135-50040-026-000 Unemployment Taxes 210.00 210.00 15.20 39.20 18.667 170.80 135-50045-026-000 Workman's Compensation 120.00 120.00 120.00 100.000 Subtotal: 11,095.00 11,095.00 2,060.55 5,434.05 48.977 5,660.95 135-60035-026-000 Postage 26.11 26.11- 135-60066-026-000 Publications/Books/Subscripts 50.00 50.00 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 133.74 352.56 27.587 925.44 135-60080-026-000 Schools & Training 4,150.00 4,150.00 875.00 21.084 3,275.00 135-60100-026-000 Travel & per diem 6,199.00 6,199.00 32.19 .519 6,166.81 135-60245-026-000 Miscellaneous Expenses 3,200.00 3,200.00 1,017.69 1,017.69 31.803 2,182.31 Subtotal: 16,977.00 16,977.00 1,151.43 2,988.55 17.604 13,988.45 135-65085-026-000 Office Supplies 50.00 50.00 8.90 17.800 41.10 Subtotal: 50.00 50.00 8.90 17.800 41.10 Program number: 28,122.00 28,122.00 3,211.98 8,431.50 29.982 19,690.50 Department number: Board of Directors 28,122.00 28,122.00 3,211.98 8,431.50 29.982 19,690.50 . glbase_tbam rgonzale Trophy Club Entities Page 13 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 3/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 12,485.05 153,902.42 64.984 82,928.58 135-50010-027-000 Overtime 1,000.00 1,000.00 16.63 1,027.97 102.797 27.97- 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,727.74 22,467.33 67.125 11,003.67 135-50026-027-000 Medical Insurance 18,798.00 18,798.00 910.60 8,502.14 45.229 10,295.86 135-50027-027-000 Dental Insurance 1,242.00 1,242.00 77.18 645.07 51.938 596.93 135-50028-027-000 Vision Insurance 341.00 341.00 18.98 161.39 47.328 179.61 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 727.29 9,571.82 64.413 5,288.18 135-50035-027-000 Medicare Taxes 3,475.00 3,475.00 170.10 2,276.45 65.509 1,198.55 135-50040-027-000 Unemployment Taxes 756.00 756.00 39.99 248.01 32.806 507.99 135-50045-027-000 Workman's Compensation 580.00 580.00 580.00 100.000 135-50070-027-000 Employee Relations 5,000.00 5,000.00 105.40 3,474.16 69.483 1,525.84 Subtotal: 319,536.00 319,536.00 16,278.96 206,561.76 64.644 112,974.24 135-55070-027-000 Independent Labor 840.00 840.00 41.25 221.25 26.339 618.75 135-55075-027-000 Records Management 500.00 500.00 500.00 135-55160-027-000 Professional Outside Services 176,870.00 176,870.00 95,384.68 190,769.36 107.859 13,899.36- Subtotal: 178,210.00 178,210.00 95,425.93 190,990.61 107.172 12,780.61- 135-60005-027-000 Telephone 300.00 300.00 25.14 122.44 40.813 177.56 135-60010-027-000 Communications/Pagers/Mobiles 2,420.00 2,420.00 68.14 1,034.05 42.729 1,385.95 135-60035-027-000 Postage 1,000.00 330.29 899.81 89.981 100.19 135-60066-027-000 Publications/Books/Subscripts 450.00 450.00 239.40 354.15 78.700 95.85 135-60070-027-000 Dues & Memberships 1,742.00 1,742.00 21.00 442.05 25.376 1,299.95 135-60075-027-000 Meetings 312.00 312.00 312.00 135-60080-027-000 Schools & Training 2,555.00 2,555.00 225.00 670.00 26.223 1,885.00 135-60100-027-000 Travel & per diem 3,851.00 3,851.00 500.13 628.00 16.307 3,223.00 135-60115-027-000 Elections 2,500.00 2,500.00 2,500.00 135-60125-027-000 Advertising 4,700.00 4,700.00 4,700.00 135-60245-027-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60270-027-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 100.000 135-60360-027-000 Furniture/Equipment < $5000 2,225.00 2,225.00 299.99 13.483 1,925.01 Subtotal: 31,155.00 32,155.00 1,409.10 14,450.49 44.940 17,704.51 135-65085-027-000 Office Supplies 2,450.00 2,450.00 398.10 1,099.38 44.873 1,350.62 135-65105-027-000 Printing 515.00 515.00 126.45 589.45 114.456 74.45- Subtotal: 2,965.00 2,965.00 524.55 1,688.83 56.959 1,276.17 Program number: 531,866.00 532,866.00 113,638.54 413,691.69 77.635 119,174.31 . glbase_tbam rgonzale Trophy Club Entities Page 14 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 3/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: Manager's Office 531,866.00 532,866.00 113,638.54 413,691.69 77.635 119,174.31 . glbase_tbam rgonzale Trophy Club Entities Page 15 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 3/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50070-028-000 Employee Relations 1,967.00 1,967.00 1,470.22 74.744 496.78 135-50075-028-000 Tuition Reimbursement 1,561.00 1,561.00 19.95 1.278 1,541.05 Subtotal: 3,528.00 3,528.00 1,490.17 42.238 2,037.83 135-60005-028-000 Telephone 28.00 28.00 28.00 135-60035-028-000 Postage 106.00 106.00 106.00 135-60066-028-000 Publications/Books/Subscripts 485.00 485.00 485.00 135-60070-028-000 Dues & Memberships 555.00 555.00 555.00 135-60075-028-000 Meetings 138.00 138.00 138.00 135-60080-028-000 Schools & Training 594.00 594.00 594.00 135-60100-028-000 Travel & per diem 8.00 8.00 8.00 135-60110-028-000 Physicals/Testing 1,560.00 1,560.00 105.00 6.731 1,455.00 Subtotal: 3,474.00 3,474.00 105.00 3.022 3,369.00 135-65085-028-000 Office Supplies 437.00 437.00 437.00 135-65105-028-000 Printing 116.00 116.00 116.00 Subtotal: 553.00 553.00 553.00 Program number: 7,555.00 7,555.00 1,595.17 21.114 5,959.83 Department number: Human Resources 7,555.00 7,555.00 1,595.17 21.114 5,959.83 . glbase_tbam rgonzale Trophy Club Entities Page 16 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 3/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 8,826.93 42,021.49 44.512 52,382.51 135-50010-029-000 Overtime 1,000.00 1,000.00 946.28 94.628 53.72 135-50016-029-000 Longevity 1,823.00 1,823.00 1,822.50 99.973 .50 135-50020-029-000 Retirement 13,612.00 13,612.00 1,219.88 6,539.08 48.039 7,072.92 135-50026-029-000 Medical Insurance 11,060.00 11,060.00 410.70 4,131.78 37.358 6,928.22 135-50027-029-000 Dental Insurance 773.00 773.00 49.02 379.87 49.142 393.13 135-50028-029-000 Vision Insurance 207.00 207.00 6.76 60.63 29.290 146.37 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 520.97 2,604.53 48.357 2,781.47 135-50035-029-000 Medicare Taxes 1,260.00 1,260.00 121.84 609.13 48.344 650.87 135-50040-029-000 Unemployment Taxes 284.00 284.00 79.54 28.007 204.46 135-50045-029-000 Workman's Compensation 235.00 235.00 211.00 89.787 24.00 Subtotal: 130,611.00 130,611.00 11,156.10 59,405.83 45.483 71,205.17 135-55160-029-000 Professional Outside Services 5,000.00 5,000.00 132.00 1,105.50 22.110 3,894.50 Subtotal: 5,000.00 5,000.00 132.00 1,105.50 22.110 3,894.50 135-60005-029-000 Telephone 103.00 103.00 9.94 46.27 44.922 56.73 135-60010-029-000 Communications/Pagers/Mobiles 683.00 683.00 51.92 305.60 44.744 377.40 135-60035-029-000 Postage 700.00 700.00 57.10 154.09 22.013 545.91 135-60040-029-000 Service Charges & Fees 79.00 79.00 32.50 41.139 46.50 135-60066-029-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-029-000 Dues & Memberships 660.00 660.00 660.00 135-60075-029-000 Meetings 300.00 300.00 22.00 7.333 278.00 135-60080-029-000 Schools & Training 2,000.00 2,000.00 225.00 225.00 11.250 1,775.00 135-60100-029-000 Travel & per diem 1,500.00 1,500.00 27.81 1.854 1,472.19 135-60125-029-000 Advertising 1,210.00 1,210.00 1,210.00 135-60245-029-000 Miscellaneous Expenses 200.00 200.00 200.00 Subtotal: 7,935.00 7,935.00 343.96 813.27 10.249 7,121.73 135-65085-029-000 Office Supplies 849.00 849.00 6.93 106.87 12.588 742.13 135-65105-029-000 Printing 515.00 515.00 515.00 Subtotal: 1,364.00 1,364.00 6.93 106.87 7.835 1,257.13 Program number: 144,910.00 144,910.00 11,638.99 61,431.47 42.393 83,478.53 Department number: Finance 144,910.00 144,910.00 11,638.99 61,431.47 42.393 83,478.53 . glbase_tbam rgonzale Trophy Club Entities Page 17 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 3/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 5,371.29 35,204.74 54.880 28,944.26 135-55070-033-000 Independent Labor 1,650.00 1,650.00 375.00 22.727 1,275.00 Subtotal: 65,799.00 65,799.00 5,371.29 35,579.74 54.073 30,219.26 135-60005-033-000 Telephone 6,540.00 6,540.00 762.74 4,534.82 69.340 2,005.18 135-60235-033-000 Security 1,350.00 1,350.00 406.60 406.60 30.119 943.40 Subtotal: 7,890.00 7,890.00 1,169.34 4,941.42 62.629 2,948.58 135-65055-033-000 Hardware 83,238.00 83,238.00 282.68 61,195.32 73.518 22,042.68 135-65085-033-000 Office Supplies 371.00 371.00 176.93 47.690 194.07 135-65090-033-000 Printer Supplies & Maintenance 5,732.00 5,732.00 75.00 3,073.38 53.618 2,658.62 Subtotal: 89,341.00 89,341.00 357.68 64,445.63 72.134 24,895.37 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 256.85 1,284.25 37.225 2,165.75 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 256.85 1,284.25 4.230 29,076.75 Program number: 193,391.00 193,391.00 7,155.16 106,251.04 54.941 87,139.96 Department number: Information Systems 193,391.00 193,391.00 7,155.16 106,251.04 54.941 87,139.96 . glbase_tbam rgonzale Trophy Club Entities Page 18 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 3/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-037-000 Salaries & Wages 31,512.00 135-50020-037-000 Retirement 4,412.00 135-50026-037-000 Medical Insurance 9,027.00 135-50027-037-000 Dental Insurance 549.00 135-50028-037-000 Vision Insurance 138.00 135-50029-037-000 Life Insurance & Other 228.00 135-50030-037-000 Social Security Taxes 1,954.00 135-50035-037-000 Medicare Taxes 457.00 135-50040-037-000 Unemployment Taxes 189.00 135-50045-037-000 Workman's Compensation 861.00 861.00 861.00- 135-50060-037-000 Pre-emp Physicals/Testing 250.00 Subtotal: 49,577.00 861.00 861.00- 135-55100-037-000 Building Maint & Supplies 5,000.00 29,577.00 233.00 724.68 2.450 28,852.32 135-55120-037-000 Cleaning Services 25,000.00 1,678.51 7,519.12 30.076 17,480.88 Subtotal: 5,000.00 54,577.00 1,911.51 8,243.80 15.105 46,333.20 135-60020-037-000 Electricity 21,940.00 21,940.00 1,188.35 5,223.56 23.808 16,716.44 135-60025-037-000 Water 1,093.00 1,093.00 91.60 295.32 27.019 797.68 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 6,591.06 50.000 6,590.94 135-60055-037-000 Insurance 32,635.00 32,635.00 1,697.23 30,286.73 92.804 2,348.27 135-60360-037-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 71,350.00 71,350.00 4,075.69 42,396.67 59.421 28,953.33 135-65095-037-000 Maintenance Supplies 2,205.00 2,205.00 32.45 651.37 29.541 1,553.63 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 76.03 7.603 923.97 Subtotal: 3,205.00 3,205.00 32.45 727.40 22.696 2,477.60 Program number: 129,132.00 129,132.00 6,019.65 52,228.87 40.446 76,903.13 Department number: Facilities Maintenance 129,132.00 129,132.00 6,019.65 52,228.87 40.446 76,903.13 . glbase_tbam rgonzale Trophy Club Entities Page 19 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 3/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 9,852.15 41,042.33 48.316 43,903.67 135-50010-038-000 Overtime 2,000.00 2,000.00 27.33 233.23 11.662 1,766.77 135-50016-038-000 Longevity 220.00 220.00 220.00 100.000 135-50020-038-000 Retirement 12,203.00 12,203.00 1,365.33 6,030.47 49.418 6,172.53 135-50026-038-000 Medical Insurance 12,321.00 12,321.00 924.26 5,545.38 45.008 6,775.62 135-50027-038-000 Dental Insurance 1,026.00 1,026.00 91.64 549.87 53.594 476.13 135-50028-038-000 Vision Insurance 260.00 260.00 21.61 129.74 49.900 130.26 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 576.76 2,460.28 45.527 2,943.72 135-50035-038-000 Medicare Taxes 1,264.00 1,264.00 134.88 575.39 45.521 688.61 135-50040-038-000 Unemployment Taxes 473.00 473.00 70.95 186.61 39.452 286.39 135-50045-038-000 Workman's Compensation 211.00 211.00 235.00 111.374 24.00- Subtotal: 120,932.00 120,932.00 13,064.91 57,208.30 47.306 63,723.70 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 892.29 6,001.07 54.555 4,998.93 Subtotal: 11,800.00 11,800.00 892.29 6,001.07 50.857 5,798.93 135-60005-038-000 Telephone 100.00 100.00 5.32 43.37 43.370 56.63 135-60010-038-000 Communications/Pagers/Mobiles 472.00 472.00 36.96 215.88 45.737 256.12 135-60035-038-000 Postage 18,000.00 18,000.00 1,374.50 8,474.64 47.081 9,525.36 135-60040-038-000 Service Charges & Fees 18,000.00 18,000.00 1,562.61 14,670.28 81.502 3,329.72 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 225.00 225.00 28.125 575.00 135-60100-038-000 Travel & per diem 605.00 605.00 605.00 135-60130-038-000 Reg Assessment Fee (5%) 22,500.00 22,500.00 25,071.20 111.428 2,571.20- 135-60245-038-000 Miscellaneous Expenses 200.00 200.00 200.00 Subtotal: 60,748.00 60,748.00 3,204.39 48,700.37 80.168 12,047.63 135-65085-038-000 Office Supplies 700.00 700.00 3.29 660.86 94.409 39.14 135-65105-038-000 Printing 3,250.00 3,250.00 3,250.00 Subtotal: 3,950.00 3,950.00 3.29 660.86 16.731 3,289.14 Program number: 197,430.00 197,430.00 17,164.88 112,570.60 57.018 84,859.40 Department number: Utility Billing 197,430.00 197,430.00 17,164.88 112,570.60 57.018 84,859.40 . glbase_tbam rgonzale Trophy Club Entities Page 20 09:56 04/20/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/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 55,000.00 7,647.15 44,495.54 80.901 10,504.46 135-55055-039-000 Auditing 20,200.00 20,200.00 20,200.00 100.000 135-55060-039-000 Appraisal 20,000.00 20,000.00 2,540.89 11,074.54 55.373 8,925.46 135-55065-039-000 Tax Admin Fees 3,629.00 3,629.00 2,470.09 68.065 1,158.91 Subtotal: 98,829.00 98,829.00 10,188.04 78,240.17 79.167 20,588.83 135-60344-039-000 Intergov Trans Out (Fire CIP) 2,277.85 2,277.85- Subtotal: 2,277.85 2,277.85- Program number: 98,829.00 98,829.00 10,188.04 80,518.02 81.472 18,310.98 Department number: Non Departmental 98,829.00 98,829.00 10,188.04 80,518.02 81.472 18,310.98 Expenditures Subtotal ----------- 6,094,978.00 6,129,319.00 720,436.70 3,496,796.87 57.050 2,632,522.13 Fund number: 135 MUD 1 General Fund 429,405.78 94,295.57 94,295.57- . glpdatb2 rgonzale Trophy Club Entities Page 15 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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 781 03/01/2012 Property Taxes/Assessments (94,191.59) (26.54) (94,218.13) GL 782 03/02/2012 Property Taxes/Assessments (36.32) (94,254.45) GL 783 03/05/2012 Property Taxes/Assessments (66.64) (94,321.09) GL 784 03/06/2012 Property Taxes/Assessments (26.76) (94,347.85) GL 785 03/07/2012 Property Taxes/Assessments (70.23) (94,418.08) GL 787 03/09/2012 Property Taxes/Assessments 92.87 (94,325.21) GL 788 03/12/2012 Property Taxes/Assessments (88.48) (94,413.69) GL 791 03/13/2012 Property Taxes/Assessments (46.10) (94,459.79) GL 792 03/14/2012 Property Taxes/Assessments (27.09) (94,486.88) GL 793 03/15/2012 Property Taxes/Assessments (.10) (94,486.98) GL 794 03/16/2012 Property Taxes/Assessments (11.85) (94,498.83) GL 795 03/19/2012 Property Taxes/Assessments (36.96) (94,535.79) GL 796 03/20/2012 Property Taxes/Assessments (7.17) (94,542.96) GL 797 03/21/2012 Property Taxes/Assessments (7.83) (94,550.79) GL 798 03/22/2012 Property Taxes/Assessments (4.74) (94,555.53) GL 799 03/23/2012 Property Taxes/Assessments (49.25) (94,604.78) GL 800 03/26/2012 Property Taxes/Assessments (44.36) (94,649.14) GL 801 03/27/2012 Property Taxes/Assessments (30.86) (94,680.00) GL 802 03/28/2012 Property Taxes/Assessments (19.93) (94,699.93) GL 803 03/29/2012 Property Taxes/Assessments (8.50) (94,708.43) GL 804 03/30/2012 Property Taxes/Assessments (34.91) (94,743.34) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (551.75) (94,743.34) ** (97,495.00) Budgeted (2,751.66) Remaining 97 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 784 03/06/2012 Property Taxes/Assessments 641.37 10.95 652.32 GL 784 03/06/2012 Property Taxes/Assessments 39.50 691.82 GL 785 03/07/2012 Property Taxes/Assessments (8.86) 682.96 GL 785 03/07/2012 Property Taxes/Assessments (13.36) 669.60 GL 787 03/09/2012 Property Taxes/Assessments 2.19 671.79 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 30.42 671.79 ** (451.00) Budgeted (1,122.79) Remaining ########## Account: 135-40015-000-000 Property Taxes/P & I 781 03/01/2012 Property Taxes/Assessments 137.88 (1.85) 136.03 GL 782 03/02/2012 Property Taxes/Assessments (3.19) 132.84 GL 783 03/05/2012 Property Taxes/Assessments (3.22) 129.62 GL 784 03/06/2012 Property Taxes/Assessments (2.39) 127.23 GL . glpdatb2 rgonzale Trophy Club Entities Page 16 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 785 03/07/2012 Property Taxes/Assessments 137.88 (6.76) 120.47 GL 785 03/07/2012 Property Taxes/Assessments (5.08) 115.39 GL 786 03/08/2012 Property Taxes/Assessments 1.77 117.16 GL 788 03/12/2012 Property Taxes/Assessments (5.15) 112.01 GL 791 03/13/2012 Property Taxes/Assessments (2.57) 109.44 GL 792 03/14/2012 Property Taxes/Assessments (2.44) 107.00 GL 794 03/16/2012 Property Taxes/Assessments (.57) 106.43 GL 795 03/19/2012 Property Taxes/Assessments (2.96) 103.47 GL 799 03/23/2012 Property Taxes/Assessments (3.92) 99.55 GL 800 03/26/2012 Property Taxes/Assessments (3.30) 96.25 GL 801 03/27/2012 Property Taxes/Assessments (1.84) 94.41 GL 802 03/28/2012 Property Taxes/Assessments (1.34) 93.07 GL 803 03/29/2012 Property Taxes/Assessments (.36) 92.71 GL 804 03/30/2012 Property Taxes/Assessments (1.95) 90.76 GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (47.12) 90.76 ** (1,334.00) Budgeted (1,424.76) Remaining -7 % 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) ** .00 Budgeted 3,999.00 Remaining 0 % Used Account: 135-47000-000-000 Water 703 03/28/2012 UB 03/28/2012 Adjustments UB 20120328-20120328 User: (476,328.67) 17.25 (476,311.42) UB 745 03/31/2012 UB 3/31/12 March Billing UB 20120331-20120331 User: (92,223.58) (568,535.00) UB _______________ Account: 135-47000-000-000 Water Totals: (92,206.33) (568,535.00) ** (1,990,800.00) Budgeted (1,422,265.00) Remaining 29 % Used Account: 135-47005-000-000 Sewer 745 03/31/2012 UB 3/31/12 March Billing UB 20120331-20120331 User: (361,691.58) (75,434.24) (437,125.82) UB _______________ Account: 135-47005-000-000 Sewer Totals: (75,434.24) (437,125.82) ** (1,325,000.00) Budgeted (887,874.18) Remaining 33 % Used Account: 135-47010-000-000 Commercial Water 745 03/31/2012 UB 3/31/12 March Billing UB 20120331-20120331 User: (237,668.26) (31,614.58) (269,282.84) UB . glpdatb2 rgonzale Trophy Club Entities Page 17 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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-47010-000-000 Commercial Water Totals: (31,614.58) (269,282.84) ** (825,000.00) Budgeted (555,717.16) Remaining 33 % Used Account: 135-47015-000-000 Commercial Sewer 745 03/31/2012 UB 3/31/12 March Billing UB 20120331-20120331 User: (109,838.49) (19,343.29) (129,181.78) UB _______________ Account: 135-47015-000-000 Commercial Sewer Totals: (19,343.29) (129,181.78) ** (360,000.00) Budgeted (230,818.22) Remaining 36 % Used Account: 135-47020-000-000 Standby 745 03/31/2012 UB 3/31/12 March Billing UB 20120331-20120331 User: (311.00) (60.00) (371.00) UB _______________ Account: 135-47020-000-000 Standby Totals: (60.00) (371.00) ** (775.00) Budgeted (404.00) Remaining 48 % Used Account: 135-47025-000-000 Penalties 680 03/21/2012 UB 03/21/2012 Charge (penalty) UB 20120321-20120321 User: (23,711.02) (2,801.58) (26,512.60) UB 741 03/30/2012 UB 03/30/2012 Adjustments UB 20120330-20120330 User: 91.02 (26,421.58) UB 745 03/31/2012 UB 3/31/12 March Billing UB 20120331-20120331 User: (76.80) (26,498.38) UB _______________ Account: 135-47025-000-000 Penalties Totals: (2,787.36) (26,498.38) ** (50,500.00) Budgeted (24,001.62) Remaining 52 % Used Account: 135-47030-000-000 Service Charges 619 03/01/2012 UB 03/01/2012 Adjustment UB 20120301-20120301 User: (6,689.38) (25.00) (6,714.38) UB 716 03/01/2012 UB 3/1/12 Adjustments UB 20120301-20120301 User: (25.00) (6,739.38) UB 682 03/08/2012 UB 03/08/2012 Adjustments UB 20120308-20120308 User: (400.00) (7,139.38) UB 718 03/13/2012 UB 3/13/12 Adjustments UB 20120313-20120313 User: (25.00) (7,164.38) UB 720 03/22/2012 UB 3/22/12 Adjustments UB 20120322-20120322 User: (75.00) (7,239.38) UB 745 03/31/2012 UB 3/31/12 March Billing UB 20120331-20120331 User: (3.00) (7,242.38) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (553.00) (7,242.38) ** (17,500.00) Budgeted (10,257.62) Remaining 41 % Used Account: 135-47035-000-000 Plumbing Inspections 723 03/01/2012 Permits 3/1/12 (850.00) (50.00) (900.00) GL 724 03/02/2012 Permits 3/2/12 (50.00) (950.00) GL . glpdatb2 rgonzale Trophy Club Entities Page 18 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 726 03/06/2012 Permits 3/6/12 (850.00) (50.00) (1,000.00) GL 734 03/23/2012 Permits 3/23/12 (50.00) (1,050.00) GL _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (200.00) (1,050.00) ** (1,200.00) Budgeted (150.00) Remaining 88 % Used Account: 135-47045-000-000 Sewer Inspections 723 03/01/2012 Permits 3/1/12 (2,550.00) (150.00) (2,700.00) GL 724 03/02/2012 Permits 3/2/12 (150.00) (2,850.00) GL 726 03/06/2012 Permits 3/6/12 (150.00) (3,000.00) GL 734 03/23/2012 Permits 3/23/12 (150.00) (3,150.00) GL _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (600.00) (3,150.00) ** (4,500.00) Budgeted (1,350.00) Remaining 70 % Used Account: 135-47070-000-000 TCCC Effluent Charges (8,212.62) .00 (8,212.62) _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (8,212.62) ** (57,500.00) Budgeted (49,287.38) Remaining 14 % Used Account: 135-47270-000-000 Fire Line .00 .00 _______________ Account: 135-47270-000-000 Fire Line Totals: .00 .00 ** (5,000.00) Budgeted (5,000.00) Remaining 0 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 741 03/30/2012 UB 03/30/2012 Adjustments UB 20120330-20120330 User: (16,062.10) (300.00) (16,362.10) UB 745 03/31/2012 UB 3/31/12 March Billing UB 20120331-20120331 User: (2,523.64) (18,885.74) UB _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: (2,823.64) (18,885.74) ** (41,595.00) Budgeted (22,709.26) Remaining 45 % Used Account: 135-47405-000-000 Out of District Sewer 642 03/09/2012 UB 03/09/2012 Adjustments UB 20120309-20120309 User: (56,862.51) 52,363.68 (4,498.83) UB 745 03/31/2012 UB 3/31/12 March Billing UB 20120331-20120331 User: (1,152.95) (5,651.78) UB . glpdatb2 rgonzale Trophy Club Entities Page 19 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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: 51,210.73 (5,651.78) ** (11,807.00) Budgeted (6,155.22) Remaining 48 % Used Account: 135-47410-000-000 Out of Dist/Portable Penalties (28.31) .00 (28.31) _______________ Account: 135-47410-000-000 Out of Dist/Portable Penalties Totals: .00 (28.31) ** (300.00) Budgeted (271.69) Remaining 9 % Used Account: 135-47600-000-000 PID #1 Water 745 03/31/2012 UB 3/31/12 March Billing UB 20120331-20120331 User: (150,324.52) (27,902.37) (178,226.89) UB _______________ Account: 135-47600-000-000 PID #1 Water Totals: (27,902.37) (178,226.89) ** (425,000.00) Budgeted (246,773.11) Remaining 42 % Used Account: 135-47605-000-000 PID #1 Sewer 745 03/31/2012 UB 3/31/12 March Billing UB 20120331-20120331 User: (85,926.87) (18,507.83) (104,434.70) UB _______________ Account: 135-47605-000-000 PID #1 Sewer Totals: (18,507.83) (104,434.70) ** (185,000.00) Budgeted (80,565.30) Remaining 56 % Used Account: 135-48005-000-000 Utility Fees 724 03/02/2012 Permits 3/2/12 (315,880.00) (2,300.00) (318,180.00) GL 725 03/05/2012 Permits 3/5/12 (6,900.00) (325,080.00) GL 727 03/07/2012 Permits 3/7/12 (2,300.00) (327,380.00) GL 728 03/08/2012 Permits 3/8/12 (2,300.00) (329,680.00) GL 730 03/13/2012 Permits 3/13/12 (2,300.00) (331,980.00) GL 732 03/16/2012 Permits 3/16/12 (9,200.00) (341,180.00) GL 733 03/21/2012 Permits 3/21/12 (18,400.00) (359,580.00) GL 734 03/23/2012 Permits 3/23/12 (6,900.00) (366,480.00) GL 744 03/29/2012 Permits 3/29/12 (6,900.00) (373,380.00) GL _______________ Account: 135-48005-000-000 Utility Fees Totals: (57,500.00) (373,380.00) ** (338,880.00) Budgeted 34,500.00 Remaining 110 % Used Account: 135-49005-000-000 Loan Proceeds (1,100,000.00) .00 (1,100,000.00) . glpdatb2 rgonzale Trophy Club Entities Page 20 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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 Totals: .00 (1,100,000.00) ** .00 Budgeted 1,100,000.00 Remaining 0 % Used Account: 135-49010-000-000 Interest Income 808 03/31/2012 March Bank Interest (1,875.65) (97.92) (1,973.57) GL 808 03/31/2012 March Bank Interest (19.13) (1,992.70) GL 808 03/31/2012 March Bank Interest (407.18) (2,399.88) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (524.23) (2,399.88) ** (4,500.00) Budgeted (2,100.12) Remaining 53 % Used Account: 135-49016-000-000 Cell Tower Revenue 735 03/28/2012 3/28/12 Deposits ATT Call Tower/March (4,235.00) (847.00) (5,082.00) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (847.00) (5,082.00) ** (10,164.00) Budgeted (5,082.00) Remaining 50 % Used Account: 135-49018-000-000 Building Rent Income 735 03/28/2012 3/28/12 Deposits Town/Mar Maint bldg rent (2,916.65) (583.33) (3,499.98) GL _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (3,499.98) ** (7,000.00) Budgeted (3,500.02) Remaining 50 % Used Account: 135-49030-000-000 Vending Revenue (32.50) .00 (32.50) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (32.50) ** (600.00) Budgeted (567.50) Remaining 5 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (265,707.00) Budgeted (265,707.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves . glpdatb2 rgonzale Trophy Club Entities Page 21 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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 ** (26,911.00) Budgeted (26,911.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 723 03/01/2012 Permits 3/1/12 (49,237.80) (292.00) (49,529.80) GL 724 03/02/2012 Permits 3/2/12 (876.00) (50,405.80) GL 725 03/05/2012 Permits 3/5/12 (876.00) (51,281.80) GL 726 03/06/2012 Permits 3/6/12 (198.00) (51,479.80) GL 727 03/07/2012 Permits 3/7/12 (292.00) (51,771.80) GL 728 03/08/2012 Permits 3/8/12 (292.00) (52,063.80) GL 729 03/09/2012 Permits 3/9/12 (1,445.00) (53,508.80) GL 730 03/13/2012 Permits 3/13/12 (292.00) (53,800.80) GL 732 03/16/2012 Permits 3/16/12 (1,168.00) (54,968.80) GL 733 03/21/2012 Permits 3/21/12 (2,336.00) (57,304.80) GL 734 03/23/2012 Permits 3/23/12 (1,168.00) (58,472.80) GL 744 03/29/2012 Permits 3/29/12 (876.00) (59,348.80) GL _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (10,111.00) (59,348.80) ** (64,000.00) Budgeted (4,651.20) Remaining 93 % Used Account: 135-49900-000-000 Miscellaneous Income 731 03/15/2012 Permits 3/15/12 (2,703.11) (75.00) (2,778.11) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (75.00) (2,778.11) ** (10,000.00) Budgeted (7,221.89) Remaining 28 % Used Account: 135-49905-000-000 Gas Well Revenue (123.00) .00 (123.00) _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 (123.00) ** (800.00) Budgeted (677.00) Remaining 15 % Used Department Totals: ------------------------------------------------------------------------------------------------ (3,402,501.30) ** (6,129,319.00) Budgeted (2,726,817.70) Remaining 56 % Used . glpdatb2 rgonzale Trophy Club Entities Page 22 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 538 03/02/2012 PAYROLL 3/2/12 Salaries & Wages 59,808.70 6,290.73 66,099.43 PR 647 03/16/2012 PAYROLL 3/16/12 Salaries & Wages 6,290.73 72,390.16 PR 696 03/30/2012 PAYROLL 3/30/12 Salaries & Wages 6,289.95 78,680.11 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 18,871.41 78,680.11 ** 199,759.00 Budgeted 121,078.89 Remaining 39 % Used Account: 135-50010-010-000 Overtime 538 03/02/2012 PAYROLL 3/2/12 Overtime 5,933.40 667.72 6,601.12 PR 647 03/16/2012 PAYROLL 3/16/12 Overtime 580.25 7,181.37 PR 696 03/30/2012 PAYROLL 3/30/12 Overtime 759.65 7,941.02 PR _______________ Account: 135-50010-010-000 Overtime Totals: 2,007.62 7,941.02 ** 13,250.00 Budgeted 5,308.98 Remaining 60 % 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 647 03/16/2012 PAYROLL 3/16/12 Certification 750.00 150.00 900.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 150.00 900.00 ** 1,800.00 Budgeted 900.00 Remaining 50 % Used Account: 135-50020-010-000 Retirement 538 03/02/2012 PAYROLL 3/2/12 Retirement 10,166.85 961.65 11,128.50 PR 647 03/16/2012 PAYROLL 3/16/12 Retirement 970.31 12,098.81 PR 696 03/30/2012 PAYROLL 3/30/12 Retirement 974.26 13,073.07 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,906.22 13,073.07 ** 25,508.00 Budgeted 12,434.93 Remaining 51 % Used Account: 135-50026-010-000 Medical Insurance 538 03/02/2012 PAYROLL 3/2/12 Medical Insurance 9,419.70 821.40 10,241.10 PR . glpdatb2 rgonzale Trophy Club Entities Page 23 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 647 03/16/2012 PAYROLL 3/16/12 Medical Insurance 9,419.70 821.40 11,062.50 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,642.80 11,062.50 ** 22,607.00 Budgeted 11,544.50 Remaining 49 % Used Account: 135-50027-010-000 Dental Insurance 538 03/02/2012 PAYROLL 3/2/12 Dental Insurance 671.40 62.60 734.00 PR 647 03/16/2012 PAYROLL 3/16/12 Dental Insurance 62.60 796.60 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 125.20 796.60 ** 2,169.00 Budgeted 1,372.40 Remaining 37 % Used Account: 135-50028-010-000 Vision Insurance 538 03/02/2012 PAYROLL 3/2/12 Vision Insurance 158.80 15.88 174.68 PR 647 03/16/2012 PAYROLL 3/16/12 Vision Insurance 15.88 190.56 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 31.76 190.56 ** 576.00 Budgeted 385.44 Remaining 33 % 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 538 03/02/2012 PAYROLL 3/2/12 Social Security Taxes 4,227.58 419.20 4,646.78 PR 647 03/16/2012 PAYROLL 3/16/12 Social Security Taxes 423.07 5,069.85 PR 696 03/30/2012 PAYROLL 3/30/12 Social Security Taxes 437.08 5,506.93 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,279.35 5,506.93 ** 13,481.00 Budgeted 7,974.07 Remaining 41 % Used Account: 135-50035-010-000 Medicare Taxes 538 03/02/2012 PAYROLL 3/2/12 Medicare Taxes 988.70 98.06 1,086.76 PR 647 03/16/2012 PAYROLL 3/16/12 Medicare Taxes 98.93 1,185.69 PR 696 03/30/2012 PAYROLL 3/30/12 Medicare Taxes 102.22 1,287.91 PR . glpdatb2 rgonzale Trophy Club Entities Page 24 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-010-000 Medicare Taxes Totals: 299.21 1,287.91 ** 3,153.00 Budgeted 1,865.09 Remaining 41 % Used Account: 135-50040-010-000 Unemployment Taxes 538 03/02/2012 PAYROLL 3/2/12 Unemployment Taxes 224.35 36.74 261.09 PR 647 03/16/2012 PAYROLL 3/16/12 Unemployment Taxes 22.06 283.15 PR 696 03/30/2012 PAYROLL 3/30/12 Unemployment Taxes 4.85 288.00 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 63.65 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 697 03/27/2012 March A/P Feb PCards 47.59 44.45 92.04 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-50070-010-000 Employee Relations Totals: 44.45 92.04 ** 350.00 Budgeted 257.96 Remaining 26 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55070-010-000 Independent Labor . glpdatb2 rgonzale Trophy Club Entities Page 25 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-55070-010-000 Independent Labor Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 697 03/27/2012 March A/P Feb PCards 9,264.71 598.14 9,862.85 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 47.71 9,910.56 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 18.54 9,929.10 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 975.50 10,904.60 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 179.90 11,084.50 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 214.35 11,298.85 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P 2/7-3/5 PCard 382.38 11,681.23 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 585.52 12,266.75 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 3,002.04 12,266.75 ** 29,500.00 Budgeted 17,233.25 Remaining 42 % Used Account: 135-55090-010-000 Vehicle Maintenance 697 03/27/2012 March A/P Feb PCards 1,889.77 78.00 1,967.77 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 78.00 1,967.77 ** 3,380.00 Budgeted 1,412.23 Remaining 58 % Used Account: 135-55100-010-000 Building Maint & Supplies 471.85 .00 471.85 _______________ Account: 135-55100-010-000 Building Maint & Supplies Totals: .00 471.85 ** 750.00 Budgeted 278.15 Remaining 63 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 697 03/27/2012 March A/P Feb PCards 450.00 14.49 464.49 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 14.49 464.49 ** 2,900.00 Budgeted 2,435.51 Remaining 16 % Used Account: 135-55135-010-000 Lab Analysis 767 03/31/2012 March A/P Feb Lab analysis 740.00 240.00 980.00 TARRANT CTY PUBLIC HEALTH LAB 31375 AP . glpdatb2 rgonzale Trophy Club Entities Page 26 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 767 03/31/2012 March A/P March lab analysis 740.00 240.00 1,220.00 TARRANT CTY PUBLIC HEALTH LAB 31375 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 480.00 1,220.00 ** 4,500.00 Budgeted 3,280.00 Remaining 27 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 767 03/31/2012 March A/P Cell phone 828.66 177.90 1,006.56 VERIZON WIRELESS 31387 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 177.90 1,006.56 ** 1,599.00 Budgeted 592.44 Remaining 63 % Used Account: 135-60020-010-000 Electricity 697 03/27/2012 March A/P Electricity 2/2-3/2 22,368.19 233.69 22,601.88 TRI COUNTY ELECTRIC 31352 AP 697 03/27/2012 March A/P Electricity 2/15-3/15 48.14 22,650.02 HUDSON ENERGY 31332 AP 767 03/31/2012 March A/P Electricity 2/15-3/15 99.90 22,749.92 HUDSON ENERGY 31365 AP 767 03/31/2012 March A/P Electricity 2/15-3/15 263.22 23,013.14 HUDSON ENERGY 31365 AP 767 03/31/2012 March A/P Electricity 2/15-3/15 1,123.42 24,136.56 HUDSON ENERGY 31365 AP 767 03/31/2012 March A/P Electricity 2/15-3/15 390.15 24,526.71 HUDSON ENERGY 31365 AP _______________ Account: 135-60020-010-000 Electricity Totals: 2,158.52 24,526.71 ** 162,000.00 Budgeted 137,473.29 Remaining 15 % Used Account: 135-60035-010-000 Postage 6.51 .00 6.51 _______________ Account: 135-60035-010-000 Postage Totals: .00 6.51 ** 500.00 Budgeted 493.49 Remaining 1 % Used Account: 135-60050-010-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-010-000 Bad Debt Expense Totals: .00 .00 ** 4,200.00 Budgeted 4,200.00 Remaining 0 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 697 03/27/2012 March A/P Training book-Jeff Richey 85.00 85.00 CITY OF FORT WORTH 31327 AP _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 85.00 85.00 ** 50.00 Budgeted (35.00) Remaining 170 % Used . glpdatb2 rgonzale Trophy Club Entities Page 27 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 697 03/27/2012 March A/P Feb PCards 761.00 210.00 971.00 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 111.00 1,082.00 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 321.00 1,082.00 ** 2,800.00 Budgeted 1,718.00 Remaining 39 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 538 03/02/2012 PAYROLL 3/2/12 Travel & per diem 677.15 54.39 731.54 PR 647 03/16/2012 PAYROLL 3/16/12 Travel & per diem 129.87 861.41 PR 696 03/30/2012 PAYROLL 3/30/12 Travel & per diem 76.04 937.45 PR _______________ Account: 135-60100-010-000 Travel & per diem Totals: 260.30 937.45 ** 3,200.00 Budgeted 2,262.55 Remaining 29 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60135-010-000 Annual Permit Fee 7,965.75 .00 7,965.75 _______________ Account: 135-60135-010-000 Annual Permit Fee Totals: .00 7,965.75 ** 6,600.00 Budgeted (1,365.75) Remaining 121 % Used . glpdatb2 rgonzale Trophy Club Entities Page 28 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60150-010-000 Wholesale Water 767 03/31/2012 March A/P February wholesale water 462,452.16 84,974.25 547,426.41 CITY OF FORT WORTH 31360 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 84,974.25 547,426.41 ** 1,720,000.00 Budgeted 1,172,573.59 Remaining 32 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 697 03/27/2012 March A/P Feb PCards 108.00 108.00 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 108.00 216.00 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 36.00 252.00 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 108.00 360.00 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-60280-010-000 Property Maintenance Totals: 360.00 360.00 ** 4,200.00 Budgeted 3,840.00 Remaining 9 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 299.99 .00 299.99 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 299.99 ** 1,500.00 Budgeted 1,200.01 Remaining 20 % Used Account: 135-65005-010-000 Fuel & Lube 697 03/27/2012 March A/P Feb PCards 4,955.49 100.00 5,055.49 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Gas Purchases/Feb 173.01 5,228.50 VALERO MARKETING & SUPPLY 31356 AP 697 03/27/2012 March A/P Gas Purchases/Feb 805.26 6,033.76 VALERO MARKETING & SUPPLY 31356 AP . glpdatb2 rgonzale Trophy Club Entities Page 29 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-65005-010-000 Fuel & Lube Totals: 1,078.27 6,033.76 ** 15,216.00 Budgeted 9,182.24 Remaining 40 % Used Account: 135-65010-010-000 Uniforms 1,024.15 .00 1,024.15 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,024.15 ** 3,690.00 Budgeted 2,665.85 Remaining 28 % Used Account: 135-65030-010-000 Chemicals 1,066.47 .00 1,066.47 _______________ Account: 135-65030-010-000 Chemicals Totals: .00 1,066.47 ** 6,200.00 Budgeted 5,133.53 Remaining 17 % Used Account: 135-65035-010-000 Small Tools 68.00 .00 68.00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 68.00 ** 2,500.00 Budgeted 2,432.00 Remaining 3 % Used Account: 135-65040-010-000 Safety Equipment 697 03/27/2012 March A/P Feb PCards 287.82 287.82 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-65040-010-000 Safety Equipment Totals: 287.82 287.82 ** 2,500.00 Budgeted 2,212.18 Remaining 12 % Used Account: 135-65050-010-000 Meter Expense 63,619.07 .00 63,619.07 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 63,619.07 ** 85,000.00 Budgeted 21,380.93 Remaining 75 % Used Account: 135-65055-010-000 Hardware .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 30 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-65055-010-000 Hardware Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65095-010-000 Maintenance Supplies 10,222.57 .00 10,222.57 _______________ Account: 135-65095-010-000 Maintenance Supplies Totals: .00 10,222.57 ** 32,000.00 Budgeted 21,777.43 Remaining 32 % Used Account: 135-65100-010-000 Copies .00 .00 _______________ Account: 135-65100-010-000 Copies Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 135-65105-010-000 Printing 58.50 .00 58.50 _______________ Account: 135-65105-010-000 Printing Totals: .00 58.50 ** 150.00 Budgeted 91.50 Remaining 39 % Used Account: 135-69005-010-000 Capital Expenses 695 03/25/2012 Phoenix App #6 Retainage 915,566.14 6,435.00 922,001.14 GL 697 03/27/2012 March A/P Final Payment-VFD 34,350.45 956,351.59 FIRST FINANCIAL BANK 31331 AP 767 03/31/2012 March A/P Relocation of water lines for 187,254.00 1,143,605.59 TOWN OF TROPHY CLUB 31380 AP 767 03/31/2012 March A/P Ground storage expansion 122,265.00 1,265,870.59 PHOENIX FABRICATORS & ERECTORS 31370 AP _______________ Account: 135-69005-010-000 Capital Expenses Totals: 350,304.45 1,265,870.59 ** 888,432.00 Budgeted (377,438.59) Remaining 142 % 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 ** 27,000.00 Budgeted (3,213.69) Remaining 112 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement . glpdatb2 rgonzale Trophy Club Entities Page 31 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-69280-010-000 Capital Repairs .00 .00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** 24,000.00 Budgeted 24,000.00 Remaining 0 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 ** 124,771.00 Budgeted 23,954.46 Remaining 81 % 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 686 03/23/2012 March A/P Final Payment Vac Hunter/Trail 10,145.26 10,145.26 FIRST FINANCIAL BANK 31317 AP _______________ Account: 135-69305-010-000 Capital Leases Totals: 10,145.26 10,145.26 ** 11,490.00 Budgeted 1,344.74 Remaining 88 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,217,533.40 ** 3,501,238.00 Budgeted 1,283,704.60 Remaining 63 % Used . glpdatb2 rgonzale Trophy Club Entities Page 32 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 538 03/02/2012 PAYROLL 3/2/12 Salaries & Wages 77,913.05 7,058.51 84,971.56 PR 647 03/16/2012 PAYROLL 3/16/12 Salaries & Wages 7,058.51 92,030.07 PR 696 03/30/2012 PAYROLL 3/30/12 Salaries & Wages 7,058.51 99,088.58 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 21,175.53 99,088.58 ** 182,147.00 Budgeted 83,058.42 Remaining 54 % Used Account: 135-50010-020-000 Overtime 538 03/02/2012 PAYROLL 3/2/12 Overtime 4,980.92 371.95 5,352.87 PR 647 03/16/2012 PAYROLL 3/16/12 Overtime 381.53 5,734.40 PR 696 03/30/2012 PAYROLL 3/30/12 Overtime 556.98 6,291.38 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,310.46 6,291.38 ** 10,166.00 Budgeted 3,874.62 Remaining 62 % 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 647 03/16/2012 PAYROLL 3/16/12 Certification 700.00 125.00 825.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 125.00 825.00 ** 2,400.00 Budgeted 1,575.00 Remaining 34 % Used Account: 135-50020-020-000 Retirement 538 03/02/2012 PAYROLL 3/2/12 Retirement 12,805.95 1,026.89 13,832.84 PR 647 03/16/2012 PAYROLL 3/16/12 Retirement 1,045.49 14,878.33 PR 696 03/30/2012 PAYROLL 3/30/12 Retirement 1,052.46 15,930.79 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,124.84 15,930.79 ** 27,816.00 Budgeted 11,885.21 Remaining 57 % Used Account: 135-50026-020-000 Medical Insurance 538 03/02/2012 PAYROLL 3/2/12 Medical Insurance 10,657.76 1,072.69 11,730.45 PR . glpdatb2 rgonzale Trophy Club Entities Page 33 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 647 03/16/2012 PAYROLL 3/16/12 Medical Insurance 10,657.76 1,072.69 12,803.14 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,145.38 12,803.14 ** 30,805.00 Budgeted 18,001.86 Remaining 42 % Used Account: 135-50027-020-000 Dental Insurance 538 03/02/2012 PAYROLL 3/2/12 Dental Insurance 818.98 82.68 901.66 PR 647 03/16/2012 PAYROLL 3/16/12 Dental Insurance 82.68 984.34 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 165.36 984.34 ** 1,981.00 Budgeted 996.66 Remaining 50 % Used Account: 135-50028-020-000 Vision Insurance 538 03/02/2012 PAYROLL 3/2/12 Vision Insurance 203.96 20.60 224.56 PR 647 03/16/2012 PAYROLL 3/16/12 Vision Insurance 20.60 245.16 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 41.20 245.16 ** 552.00 Budgeted 306.84 Remaining 44 % 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 538 03/02/2012 PAYROLL 3/2/12 Social Security Taxes 5,134.02 413.21 5,547.23 PR 647 03/16/2012 PAYROLL 3/16/12 Social Security Taxes 421.55 5,968.78 PR 696 03/30/2012 PAYROLL 3/30/12 Social Security Taxes 472.16 6,440.94 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,306.92 6,440.94 ** 8,597.00 Budgeted 2,156.06 Remaining 75 % Used Account: 135-50035-020-000 Medicare Taxes 538 03/02/2012 PAYROLL 3/2/12 Medicare Taxes 1,200.68 96.63 1,297.31 PR 647 03/16/2012 PAYROLL 3/16/12 Medicare Taxes 98.59 1,395.90 PR 696 03/30/2012 PAYROLL 3/30/12 Medicare Taxes 110.43 1,506.33 PR . glpdatb2 rgonzale Trophy Club Entities Page 34 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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-020-000 Medicare Taxes Totals: 305.65 1,506.33 ** 2,011.00 Budgeted 504.67 Remaining 75 % Used Account: 135-50040-020-000 Unemployment Taxes 538 03/02/2012 PAYROLL 3/2/12 Unemployment Taxes 267.66 32.16 299.82 PR 647 03/16/2012 PAYROLL 3/16/12 Unemployment Taxes 10.53 310.35 PR 696 03/30/2012 PAYROLL 3/30/12 Unemployment Taxes 5.49 315.84 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 48.18 315.84 ** 567.00 Budgeted 251.16 Remaining 56 % Used Account: 135-50045-020-000 Workman's Compensation 2,685.00 .00 2,685.00 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 2,685.00 ** 2,685.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 30.45 .00 30.45 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 30.45 ** 200.00 Budgeted 169.55 Remaining 15 % Used Account: 135-50070-020-000 Employee Relations 697 03/27/2012 March A/P Feb PCards 20.00 44.45 64.45 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-50070-020-000 Employee Relations Totals: 44.45 64.45 ** 350.00 Budgeted 285.55 Remaining 18 % Used Account: 135-55070-020-000 Independent Labor 767 03/31/2012 March A/P Update WWTP Evaluation, origin 1,305.67 600.00 1,905.67 JOHN ZINK 31366 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 600.00 1,905.67 ** 750.00 Budgeted (1,155.67) Remaining 254 % Used Account: 135-55080-020-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club Entities Page 35 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 697 03/27/2012 March A/P Alternating relay 15,278.10 30.00 15,308.10 ADRIAN WOMACK 31319 AP 697 03/27/2012 March A/P Feb PCards 21.10 15,329.20 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 49.54 15,378.74 JPMORGAN CHASE BANK NA 31334 AP 767 03/31/2012 March A/P Filter screen cage repair 1,250.00 16,628.74 NORTH TEXAS PUMP CO. 31367 AP 767 03/31/2012 March A/P Starter for 25 HP motor, Blowe 884.23 17,512.97 NORTH TEXAS PUMP CO. 31367 AP 767 03/31/2012 March A/P Flygt 3085.183 disassemble, cl 150.00 17,662.97 NORTH TEXAS PUMP CO. 31367 AP 767 03/31/2012 March A/P Flygt 3085.728 Disassemble, cl 150.00 17,812.97 NORTH TEXAS PUMP CO. 31367 AP 767 03/31/2012 March A/P Pump repair 637.50 18,450.47 NORTH TEXAS PUMP CO. 31367 AP 767 03/31/2012 March A/P Hydromatic, disassemble, clean 350.00 18,800.47 NORTH TEXAS PUMP CO. 31367 AP 767 03/31/2012 March A/P Install screen, deliver Hydrom 1,062.50 19,862.97 NORTH TEXAS PUMP CO. 31367 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 4,584.87 19,862.97 ** 17,750.00 Budgeted (2,112.97) Remaining 112 % Used Account: 135-55090-020-000 Vehicle Maintenance 194.95 .00 194.95 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 194.95 ** 4,998.00 Budgeted 4,803.05 Remaining 4 % Used Account: 135-55100-020-000 Building Maint & Supplies .00 .00 _______________ Account: 135-55100-020-000 Building Maint & Supplies Totals: .00 .00 ** 1,400.00 Budgeted 1,400.00 Remaining 0 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 697 03/27/2012 March A/P Feb PCards 134.00 14.50 148.50 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 14.50 148.50 ** 2,950.00 Budgeted 2,801.50 Remaining 5 % Used Account: 135-55125-020-000 Dumpster Services 697 03/27/2012 March A/P Sludge Haul off 9,675.00 537.50 10,212.50 CHANEY ENVIRONMENTAL 31325 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 537.50 10,212.50 ** 35,000.00 Budgeted 24,787.50 Remaining 29 % Used Account: 135-55135-020-000 Lab Analysis . glpdatb2 rgonzale Trophy Club Entities Page 36 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 697 03/27/2012 March A/P Lab Analysis 4,440.57 646.00 5,086.57 TALEM, INC 31351 AP 697 03/27/2012 March A/P Feb PCards 89.22 5,175.79 JPMORGAN CHASE BANK NA 31334 AP 767 03/31/2012 March A/P Wet chem analysis 790.50 5,966.29 TALEM, INC 31374 AP 767 03/31/2012 March A/P Lab analysis 549.13 6,515.42 HACH COMPANY 31364 AP 767 03/31/2012 March A/P Sulfuric acid conc 30.25 6,545.67 HACH COMPANY 31364 AP 767 03/31/2012 March A/P Spectrophotometer 3,799.00 10,344.67 HACH COMPANY 31364 AP 767 03/31/2012 March A/P Glass fiber for lab 161.45 10,506.12 USA BLUEBOOK 31386 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 6,065.55 10,506.12 ** 22,760.00 Budgeted 12,253.88 Remaining 46 % Used Account: 135-60005-020-000 Telephone 10.59 .00 10.59 _______________ Account: 135-60005-020-000 Telephone Totals: .00 10.59 ** 100.00 Budgeted 89.41 Remaining 11 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 767 03/31/2012 March A/P Cell phone 1,124.78 253.95 1,378.73 VERIZON WIRELESS 31387 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 253.95 1,378.73 ** 3,000.00 Budgeted 1,621.27 Remaining 46 % Used Account: 135-60020-020-000 Electricity 697 03/27/2012 March A/P Electricity 2/15-3/15 23,307.74 813.38 24,121.12 HUDSON ENERGY 31332 AP _______________ Account: 135-60020-020-000 Electricity Totals: 813.38 24,121.12 ** 205,000.00 Budgeted 180,878.88 Remaining 12 % Used Account: 135-60025-020-000 Water 697 03/27/2012 March A/P Feb Water 1,137.73 12.71 1,150.44 TROPHY CLUB MUD (WATER BILLS) 31353 AP 767 03/31/2012 March A/P March water 75.71 1,226.15 TROPHY CLUB MUD (WATER BILLS) 31385 AP _______________ Account: 135-60025-020-000 Water Totals: 88.42 1,226.15 ** 1,900.00 Budgeted 673.85 Remaining 65 % Used Account: 135-60035-020-000 Postage .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 37 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60035-020-000 Postage Totals: .00 .00 ** 120.00 Budgeted 120.00 Remaining 0 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 438.17 .00 438.17 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 438.17 ** 500.00 Budgeted 61.83 Remaining 88 % Used Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 1,320.00 Budgeted 1,320.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program 697 03/27/2012 March A/P Safety Supplies 40.31 40.31 CINTAS FAS LOCKBOX 636525 31326 AP 697 03/27/2012 March A/P Safety Supplies 48.15 88.46 CINTAS FAS LOCKBOX 636525 31326 AP 697 03/27/2012 March A/P Safety Supplies 27.99 116.45 CINTAS FAS LOCKBOX 636525 31326 AP _______________ Account: 135-60090-020-000 Safety Program Totals: 116.45 116.45 ** 200.00 Budgeted 83.55 Remaining 58 % Used Account: 135-60100-020-000 Travel & per diem 538 03/02/2012 PAYROLL 3/2/12 Travel & per diem 745.92 69.93 815.85 PR 647 03/16/2012 PAYROLL 3/16/12 Travel & per diem 181.49 997.34 PR 696 03/30/2012 PAYROLL 3/30/12 Travel & per diem 93.24 1,090.58 PR _______________ Account: 135-60100-020-000 Travel & per diem Totals: 344.66 1,090.58 ** 1,750.00 Budgeted 659.42 Remaining 62 % Used Account: 135-60105-020-000 Rent/Lease Equipment 901.30 .00 901.30 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 901.30 ** 200.00 Budgeted (701.30) Remaining 451 % Used . glpdatb2 rgonzale Trophy Club Entities Page 38 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60125-020-000 Advertising 987.36 .00 987.36 _______________ Account: 135-60125-020-000 Advertising Totals: .00 987.36 ** 1,000.00 Budgeted 12.64 Remaining 99 % Used Account: 135-60135-020-000 Annual Permit Fee 7,432.50 .00 7,432.50 _______________ Account: 135-60135-020-000 Annual Permit Fee Totals: .00 7,432.50 ** 7,500.00 Budgeted 67.50 Remaining 99 % Used Account: 135-60245-020-000 Miscellaneous Expenses 64.00 .00 64.00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 64.00 ** 525.00 Budgeted 461.00 Remaining 12 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 525.00 Budgeted 525.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 697 03/27/2012 March A/P Gas Purchases/Feb 1,300.73 269.88 1,570.61 VALERO MARKETING & SUPPLY 31356 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 269.88 1,570.61 ** 6,875.00 Budgeted 5,304.39 Remaining 23 % Used Account: 135-65010-020-000 Uniforms 697 03/27/2012 March A/P Feb PCards 916.93 202.00 1,118.93 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 202.00 1,118.93 ** 3,140.00 Budgeted 2,021.07 Remaining 36 % Used Account: 135-65030-020-000 Chemicals . glpdatb2 rgonzale Trophy Club Entities Page 39 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 767 03/31/2012 March A/P Scoop Polymer 26, 450 lb drum 2,557.57 680.00 3,237.57 SCOOP 31372 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 680.00 3,237.57 ** 13,180.00 Budgeted 9,942.43 Remaining 25 % Used Account: 135-65035-020-000 Small Tools .00 .00 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment 22.75 .00 22.75 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 22.75 ** 925.00 Budgeted 902.25 Remaining 2 % Used Account: 135-65045-020-000 Lab Supplies 767 03/31/2012 March A/P Bottle brushes, Cleaning compo 2,699.84 151.61 2,851.45 USA BLUEBOOK 31386 AP 767 03/31/2012 March A/P Lab supplies 304.73 3,156.18 USA BLUEBOOK 31386 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 456.34 3,156.18 ** 19,160.00 Budgeted 16,003.82 Remaining 16 % 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 50.58 .00 50.58 _______________ Account: 135-65085-020-000 Office Supplies Totals: .00 50.58 ** 400.00 Budgeted 349.42 Remaining 13 % Used Account: 135-65095-020-000 Maintenance Supplies . glpdatb2 rgonzale Trophy Club Entities Page 40 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 953.32 .00 953.32 _______________ Account: 135-65095-020-000 Maintenance Supplies Totals: .00 953.32 ** 8,860.00 Budgeted 7,906.68 Remaining 11 % Used Account: 135-65115-020-000 Other Consumables .00 .00 _______________ Account: 135-65115-020-000 Other Consumables Totals: .00 .00 ** 110.00 Budgeted 110.00 Remaining 0 % Used Account: 135-69005-020-000 Capital Expenses 43,592.56 .00 43,592.56 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .00 43,592.56 ** 161,189.00 Budgeted 117,596.44 Remaining 27 % Used Account: 135-69280-020-000 Capital Repairs .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 56,000.00 Budgeted 56,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 285,486.56 ** 856,009.00 Budgeted 570,522.44 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club Entities Page 41 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/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 538 03/02/2012 PAYROLL 3/2/12 Salaries & Wages 52,639.80 5,538.99 58,178.79 PR 647 03/16/2012 PAYROLL 3/16/12 Salaries & Wages 5,541.08 63,719.87 PR 696 03/30/2012 PAYROLL 3/30/12 Salaries & Wages 5,539.48 69,259.35 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 16,619.55 69,259.35 ** 145,481.00 Budgeted 76,221.65 Remaining 48 % Used Account: 135-50010-021-000 Overtime 538 03/02/2012 PAYROLL 3/2/12 Overtime 3,421.19 376.55 3,797.74 PR 647 03/16/2012 PAYROLL 3/16/12 Overtime 180.69 3,978.43 PR 696 03/30/2012 PAYROLL 3/30/12 Overtime 310.03 4,288.46 PR _______________ Account: 135-50010-021-000 Overtime Totals: 867.27 4,288.46 ** 7,297.00 Budgeted 3,008.54 Remaining 59 % 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 647 03/16/2012 PAYROLL 3/16/12 Certification 625.00 125.00 750.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 125.00 750.00 ** 1,500.00 Budgeted 750.00 Remaining 50 % Used Account: 135-50020-021-000 Retirement 538 03/02/2012 PAYROLL 3/2/12 Retirement 8,869.26 817.52 9,686.78 PR 647 03/16/2012 PAYROLL 3/16/12 Retirement 808.03 10,494.81 PR 696 03/30/2012 PAYROLL 3/30/12 Retirement 808.40 11,303.21 PR _______________ Account: 135-50020-021-000 Retirement Totals: 2,433.95 11,303.21 ** 21,074.00 Budgeted 9,770.79 Remaining 54 % Used Account: 135-50026-021-000 Medical Insurance 538 03/02/2012 PAYROLL 3/2/12 Medical Insurance 8,513.40 851.34 9,364.74 PR . glpdatb2 rgonzale Trophy Club Entities Page 42 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 647 03/16/2012 PAYROLL 3/16/12 Medical Insurance 8,513.40 851.34 10,216.08 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,702.68 10,216.08 ** 22,983.00 Budgeted 12,766.92 Remaining 44 % Used Account: 135-50027-021-000 Dental Insurance 538 03/02/2012 PAYROLL 3/2/12 Dental Insurance 586.90 58.69 645.59 PR 647 03/16/2012 PAYROLL 3/16/12 Dental Insurance 58.69 704.28 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 117.38 704.28 ** 1,533.00 Budgeted 828.72 Remaining 46 % Used Account: 135-50028-021-000 Vision Insurance 538 03/02/2012 PAYROLL 3/2/12 Vision Insurance 148.60 14.86 163.46 PR 647 03/16/2012 PAYROLL 3/16/12 Vision Insurance 14.86 178.32 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 29.72 178.32 ** 357.00 Budgeted 178.68 Remaining 50 % 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 538 03/02/2012 PAYROLL 3/2/12 Social Security Taxes 3,623.61 337.28 3,960.89 PR 647 03/16/2012 PAYROLL 3/16/12 Social Security Taxes 333.01 4,293.90 PR 696 03/30/2012 PAYROLL 3/30/12 Social Security Taxes 362.67 4,656.57 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 1,032.96 4,656.57 ** 9,785.00 Budgeted 5,128.43 Remaining 48 % Used Account: 135-50035-021-000 Medicare Taxes 538 03/02/2012 PAYROLL 3/2/12 Medicare Taxes 847.46 78.88 926.34 PR 647 03/16/2012 PAYROLL 3/16/12 Medicare Taxes 77.88 1,004.22 PR 696 03/30/2012 PAYROLL 3/30/12 Medicare Taxes 84.82 1,089.04 PR . glpdatb2 rgonzale Trophy Club Entities Page 43 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 241.58 1,089.04 ** 2,288.00 Budgeted 1,198.96 Remaining 48 % Used Account: 135-50040-021-000 Unemployment Taxes 538 03/02/2012 PAYROLL 3/2/12 Unemployment Taxes 180.10 22.29 202.39 PR 647 03/16/2012 PAYROLL 3/16/12 Unemployment Taxes 11.59 213.98 PR 696 03/30/2012 PAYROLL 3/30/12 Unemployment Taxes 2.02 216.00 PR _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: 35.90 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 697 03/27/2012 March A/P Feb PCards 19.97 44.46 64.43 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-50070-021-000 Employee Relations Totals: 44.46 64.43 ** 250.00 Budgeted 185.57 Remaining 26 % Used Account: 135-55005-021-000 Engineering .00 .00 _______________ Account: 135-55005-021-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55070-021-000 Independent Labor .00 .00 _______________ Account: 135-55070-021-000 Independent Labor Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs . glpdatb2 rgonzale Trophy Club Entities Page 44 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 697 03/27/2012 March A/P Feb PCards 3,535.85 248.00 3,783.85 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 248.00 3,783.85 ** 23,700.00 Budgeted 19,916.15 Remaining 16 % Used Account: 135-55090-021-000 Vehicle Maintenance 697 03/27/2012 March A/P Feb PCards 130.00 39.75 169.75 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 39.75 209.50 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 79.50 209.50 ** 1,943.00 Budgeted 1,733.50 Remaining 11 % 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 767 03/31/2012 March A/P March PCards-Zieverink 11.92 2.29 14.21 BANK OF AMERICA 31359 AP _______________ Account: 135-60005-021-000 Telephone Totals: 2.29 14.21 ** 50.00 Budgeted 35.79 Remaining 28 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 767 03/31/2012 March A/P Cell phone 1,544.59 207.52 1,752.11 VERIZON WIRELESS 31387 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 207.52 1,752.11 ** 2,796.00 Budgeted 1,043.89 Remaining 63 % Used Account: 135-60020-021-000 Electricity 697 03/27/2012 March A/P Electricity 2/2-3/2 3,441.42 120.77 3,562.19 TRI COUNTY ELECTRIC 31352 AP 697 03/27/2012 March A/P Electricity 2/2-3/2 27.66 3,589.85 TRI COUNTY ELECTRIC 31352 AP 697 03/27/2012 March A/P Electricity 2/14-3/15 727.70 4,317.55 HUDSON ENERGY 31332 AP 697 03/27/2012 March A/P Electricity 2/15-3/15 305.33 4,622.88 HUDSON ENERGY 31332 AP 767 03/31/2012 March A/P Electricity 2/17-3/14 29.55 4,652.43 HUDSON ENERGY 31365 AP _______________ Account: 135-60020-021-000 Electricity Totals: 1,211.01 4,652.43 ** 23,625.00 Budgeted 18,972.57 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club Entities Page 45 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/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 .00 .00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 .00 ** 2,818.00 Budgeted 2,818.00 Remaining 0 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 538 03/02/2012 PAYROLL 3/2/12 Travel & per diem 386.86 22.76 409.62 PR 647 03/16/2012 PAYROLL 3/16/12 Travel & per diem 16.10 425.72 PR 696 03/30/2012 PAYROLL 3/30/12 Travel & per diem 3.33 429.05 PR _______________ Account: 135-60100-021-000 Travel & per diem Totals: 42.19 429.05 ** 1,500.00 Budgeted 1,070.95 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club Entities Page 46 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/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-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 76,098.00 Budgeted 76,098.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-60280-021-000 Property Maintenance .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 697 03/27/2012 March A/P Gas Purchases/Feb 3,595.29 409.06 4,004.35 VALERO MARKETING & SUPPLY 31356 AP _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 409.06 4,004.35 ** 11,700.00 Budgeted 7,695.65 Remaining 34 % Used Account: 135-65010-021-000 Uniforms 620.98 .00 620.98 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 620.98 ** 2,505.00 Budgeted 1,884.02 Remaining 25 % Used Account: 135-65030-021-000 Chemicals .00 .00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 .00 ** 12,500.00 Budgeted 12,500.00 Remaining 0 % Used Account: 135-65035-021-000 Small Tools . glpdatb2 rgonzale Trophy Club Entities Page 47 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/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-65035-021-000 Small Tools Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-65040-021-000 Safety Equipment 22.74 .00 22.74 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 22.74 ** 1,150.00 Budgeted 1,127.26 Remaining 2 % Used Account: 135-65055-021-000 Hardware 44.95 .00 44.95 _______________ Account: 135-65055-021-000 Hardware Totals: .00 44.95 ** 750.00 Budgeted 705.05 Remaining 6 % Used Account: 135-65095-021-000 Maintenance Supplies 204.14 .00 204.14 _______________ Account: 135-65095-021-000 Maintenance Supplies Totals: .00 204.14 ** 16,050.00 Budgeted 15,845.86 Remaining 1 % Used Account: 135-69005-021-000 Capital Expenses 31,991.00 .00 31,991.00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 31,991.00 ** 15,000.00 Budgeted (16,991.00) Remaining 213 % Used Account: 135-69280-021-000 Capital Repairs .00 .00 _______________ Account: 135-69280-021-000 Capital Repairs Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 157,058.55 ** 439,837.00 Budgeted 282,778.45 Remaining 36 % Used . glpdatb2 rgonzale Trophy Club Entities Page 48 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/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 538 03/02/2012 PAYROLL 3/2/12 Salaries & Wages 3,000.00 800.00 3,800.00 PR 647 03/16/2012 PAYROLL 3/16/12 Salaries & Wages 600.00 4,400.00 PR 696 03/30/2012 PAYROLL 3/30/12 Salaries & Wages 500.00 4,900.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,900.00 4,900.00 ** 10,000.00 Budgeted 5,100.00 Remaining 49 % Used Account: 135-50030-026-000 Social Security Taxes 538 03/02/2012 PAYROLL 3/2/12 Social Security Taxes 186.00 49.60 235.60 PR 647 03/16/2012 PAYROLL 3/16/12 Social Security Taxes 37.20 272.80 PR 696 03/30/2012 PAYROLL 3/30/12 Social Security Taxes 31.00 303.80 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 117.80 303.80 ** 620.00 Budgeted 316.20 Remaining 49 % Used Account: 135-50035-026-000 Medicare Taxes 538 03/02/2012 PAYROLL 3/2/12 Medicare Taxes 43.50 11.60 55.10 PR 647 03/16/2012 PAYROLL 3/16/12 Medicare Taxes 8.70 63.80 PR 696 03/30/2012 PAYROLL 3/30/12 Medicare Taxes 7.25 71.05 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 27.55 71.05 ** 145.00 Budgeted 73.95 Remaining 49 % Used Account: 135-50040-026-000 Unemployment Taxes 538 03/02/2012 PAYROLL 3/2/12 Unemployment Taxes 24.00 6.40 30.40 PR 647 03/16/2012 PAYROLL 3/16/12 Unemployment Taxes 4.80 35.20 PR 696 03/30/2012 PAYROLL 3/30/12 Unemployment Taxes 4.00 39.20 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 15.20 39.20 ** 210.00 Budgeted 170.80 Remaining 19 % Used Account: 135-50045-026-000 Workman's Compensation 120.00 .00 120.00 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 120.00 ** 120.00 Budgeted .00 Remaining 100 % Used Account: 135-60035-026-000 Postage . glpdatb2 rgonzale Trophy Club Entities Page 49 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 26.11 .00 26.11 _______________ Account: 135-60035-026-000 Postage Totals: .00 26.11 ** .00 Budgeted (26.11) Remaining 0 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 685.00 .00 685.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 685.00 ** 2,100.00 Budgeted 1,415.00 Remaining 33 % Used Account: 135-60075-026-000 Meetings 697 03/27/2012 March A/P Chamber Luncheon Sanders, Carr 218.82 66.00 284.82 NORTHWEST METROPORT CHAMBER 31339 AP 697 03/27/2012 March A/P Feb PCards 67.74 352.56 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-60075-026-000 Meetings Totals: 133.74 352.56 ** 1,278.00 Budgeted 925.44 Remaining 28 % Used Account: 135-60080-026-000 Schools & Training 875.00 .00 875.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 875.00 ** 4,150.00 Budgeted 3,275.00 Remaining 21 % Used Account: 135-60100-026-000 Travel & per diem 32.19 .00 32.19 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 32.19 ** 6,199.00 Budgeted 6,166.81 Remaining 1 % Used Account: 135-60245-026-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club Entities Page 50 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 697 03/27/2012 March A/P Feb PCards 14.99 14.99 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 500.00 514.99 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 502.70 1,017.69 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 1,017.69 1,017.69 ** 3,200.00 Budgeted 2,182.31 Remaining 32 % Used Account: 135-65085-026-000 Office Supplies 8.90 .00 8.90 _______________ Account: 135-65085-026-000 Office Supplies Totals: .00 8.90 ** 50.00 Budgeted 41.10 Remaining 18 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 8,431.50 ** 28,122.00 Budgeted 19,690.50 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club Entities Page 51 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 3/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 538 03/02/2012 PAYROLL 3/2/12 Salaries & Wages 141,417.37 4,402.89 145,820.26 PR 647 03/16/2012 PAYROLL 3/16/12 Salaries & Wages 3,118.00 148,938.26 PR 696 03/30/2012 PAYROLL 3/30/12 Salaries & Wages 4,964.16 153,902.42 PR _______________ Account: 135-50005-027-000 Salaries & Wages Totals: 12,485.05 153,902.42 ** 236,831.00 Budgeted 82,928.58 Remaining 65 % Used Account: 135-50010-027-000 Overtime 538 03/02/2012 PAYROLL 3/2/12 Overtime 1,011.34 6.61 1,017.95 PR 647 03/16/2012 PAYROLL 3/16/12 Overtime 7.35 1,025.30 PR 696 03/30/2012 PAYROLL 3/30/12 Overtime 2.67 1,027.97 PR _______________ Account: 135-50010-027-000 Overtime Totals: 16.63 1,027.97 ** 1,000.00 Budgeted (27.97) Remaining 103 % 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 538 03/02/2012 PAYROLL 3/2/12 Retirement 20,739.59 609.40 21,348.99 PR 647 03/16/2012 PAYROLL 3/16/12 Retirement 431.92 21,780.91 PR 696 03/30/2012 PAYROLL 3/30/12 Retirement 686.42 22,467.33 PR _______________ Account: 135-50020-027-000 Retirement Totals: 1,727.74 22,467.33 ** 33,471.00 Budgeted 11,003.67 Remaining 67 % Used Account: 135-50026-027-000 Medical Insurance 538 03/02/2012 PAYROLL 3/2/12 Medical Insurance 7,591.54 567.41 8,158.95 PR 647 03/16/2012 PAYROLL 3/16/12 Medical Insurance 343.19 8,502.14 PR _______________ Account: 135-50026-027-000 Medical Insurance Totals: 910.60 8,502.14 ** 18,798.00 Budgeted 10,295.86 Remaining 45 % Used Account: 135-50027-027-000 Dental Insurance . glpdatb2 rgonzale Trophy Club Entities Page 52 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 538 03/02/2012 PAYROLL 3/2/12 Dental Insurance 567.89 45.55 613.44 PR 647 03/16/2012 PAYROLL 3/16/12 Dental Insurance 31.63 645.07 PR _______________ Account: 135-50027-027-000 Dental Insurance Totals: 77.18 645.07 ** 1,242.00 Budgeted 596.93 Remaining 52 % Used Account: 135-50028-027-000 Vision Insurance 538 03/02/2012 PAYROLL 3/2/12 Vision Insurance 142.41 11.54 153.95 PR 647 03/16/2012 PAYROLL 3/16/12 Vision Insurance 7.44 161.39 PR _______________ Account: 135-50028-027-000 Vision Insurance Totals: 18.98 161.39 ** 341.00 Budgeted 179.61 Remaining 47 % 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 538 03/02/2012 PAYROLL 3/2/12 Social Security Taxes 8,844.53 245.20 9,089.73 PR 647 03/16/2012 PAYROLL 3/16/12 Social Security Taxes 174.15 9,263.88 PR 696 03/30/2012 PAYROLL 3/30/12 Social Security Taxes 307.94 9,571.82 PR _______________ Account: 135-50030-027-000 Social Security Taxes Totals: 727.29 9,571.82 ** 14,860.00 Budgeted 5,288.18 Remaining 64 % Used Account: 135-50035-027-000 Medicare Taxes 538 03/02/2012 PAYROLL 3/2/12 Medicare Taxes 2,106.35 57.36 2,163.71 PR 647 03/16/2012 PAYROLL 3/16/12 Medicare Taxes 40.72 2,204.43 PR 696 03/30/2012 PAYROLL 3/30/12 Medicare Taxes 72.02 2,276.45 PR _______________ Account: 135-50035-027-000 Medicare Taxes Totals: 170.10 2,276.45 ** 3,475.00 Budgeted 1,198.55 Remaining 66 % Used Account: 135-50040-027-000 Unemployment Taxes 538 03/02/2012 PAYROLL 3/2/12 Unemployment Taxes 208.02 15.26 223.28 PR 647 03/16/2012 PAYROLL 3/16/12 Unemployment Taxes 5.00 228.28 PR . glpdatb2 rgonzale Trophy Club Entities Page 53 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 696 03/30/2012 PAYROLL 3/30/12 Unemployment Taxes 208.02 19.73 248.01 PR _______________ Account: 135-50040-027-000 Unemployment Taxes Totals: 39.99 248.01 ** 756.00 Budgeted 507.99 Remaining 33 % Used Account: 135-50045-027-000 Workman's Compensation 580.00 .00 580.00 _______________ Account: 135-50045-027-000 Workman's Compensation Totals: .00 580.00 ** 580.00 Budgeted .00 Remaining 100 % Used Account: 135-50070-027-000 Employee Relations 697 03/27/2012 March A/P Feb PCards 3,368.76 18.55 3,387.31 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 18.00 3,405.31 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 35.98 3,441.29 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 11.99 3,453.28 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 19.98 3,473.26 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards .90 3,474.16 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-50070-027-000 Employee Relations Totals: 105.40 3,474.16 ** 5,000.00 Budgeted 1,525.84 Remaining 69 % Used Account: 135-55070-027-000 Independent Labor 697 03/27/2012 March A/P Record MUD Meeting 180.00 41.25 221.25 MIGUEL CRUZ 31338 AP _______________ Account: 135-55070-027-000 Independent Labor Totals: 41.25 221.25 ** 840.00 Budgeted 618.75 Remaining 26 % Used Account: 135-55075-027-000 Records Management .00 .00 _______________ Account: 135-55075-027-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55160-027-000 Professional Outside Services 767 03/31/2012 March A/P Balance due Semo Contract 95,384.68 95,384.68 190,769.36 TOWN OF TROPHY CLUB 31384 AP _______________ Account: 135-55160-027-000 Professional Outside Services Totals: 95,384.68 190,769.36 ** 176,870.00 Budgeted (13,899.36) Remaining 108 % Used . glpdatb2 rgonzale Trophy Club Entities Page 54 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 3/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-027-000 Telephone 767 03/31/2012 March A/P March PCards-Zieverink 97.30 25.14 122.44 BANK OF AMERICA 31359 AP _______________ Account: 135-60005-027-000 Telephone Totals: 25.14 122.44 ** 300.00 Budgeted 177.56 Remaining 41 % Used Account: 135-60010-027-000 Communications/Pagers/Mobiles 767 03/31/2012 March A/P Cell phone 965.91 68.14 1,034.05 VERIZON WIRELESS 31387 AP _______________ Account: 135-60010-027-000 Communications/Pagers/Mobiles Totals: 68.14 1,034.05 ** 2,420.00 Budgeted 1,385.95 Remaining 43 % Used Account: 135-60035-027-000 Postage 697 03/27/2012 March A/P Documents to McCall Parkhurst 569.52 20.91 590.43 FEDERAL EXPRESS CORP 31330 AP 697 03/27/2012 March A/P Docs to Bob West 20.57 611.00 FEDERAL EXPRESS CORP 31330 AP 697 03/27/2012 March A/P Postage meter rental 157.47 768.47 PITNEY BOWES INC 31342 AP 767 03/31/2012 March A/P Documents to Pam Liston 70.89 839.36 FEDERAL EXPRESS CORP 31362 AP 826 03/31/2012 February Postage 14.10 853.46 GL 827 03/31/2012 March Postage 46.35 899.81 GL _______________ Account: 135-60035-027-000 Postage Totals: 330.29 899.81 ** 1,000.00 Budgeted 100.19 Remaining 90 % Used Account: 135-60066-027-000 Publications/Books/Subscripts 697 03/27/2012 March A/P 4/14/12-4/13/13 Newspaper Subs 114.75 239.40 354.15 STAR-TELEGRAM OPERATING LTD 31348 AP _______________ Account: 135-60066-027-000 Publications/Books/Subscripts Totals: 239.40 354.15 ** 450.00 Budgeted 95.85 Remaining 79 % Used Account: 135-60070-027-000 Dues & Memberships 697 03/27/2012 March A/P Notary Renewal/McKnight 421.05 21.00 442.05 SECRETARY OF STATE OF TEXAS 31345 AP _______________ Account: 135-60070-027-000 Dues & Memberships Totals: 21.00 442.05 ** 1,742.00 Budgeted 1,299.95 Remaining 25 % Used Account: 135-60075-027-000 Meetings .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 55 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 3/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-027-000 Meetings Totals: .00 .00 ** 312.00 Budgeted 312.00 Remaining 0 % Used Account: 135-60080-027-000 Schools & Training 697 03/27/2012 March A/P User Conf-McKnight, Gonzales, 445.00 225.00 670.00 STW INC 31349 AP _______________ Account: 135-60080-027-000 Schools & Training Totals: 225.00 670.00 ** 2,555.00 Budgeted 1,885.00 Remaining 26 % Used Account: 135-60100-027-000 Travel & per diem 538 03/02/2012 PAYROLL 3/2/12 Travel & per diem 127.87 43.29 171.16 PR 697 03/27/2012 March A/P Feb PCards 456.84 628.00 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-60100-027-000 Travel & per diem Totals: 500.13 628.00 ** 3,851.00 Budgeted 3,223.00 Remaining 16 % Used Account: 135-60115-027-000 Elections .00 .00 _______________ Account: 135-60115-027-000 Elections Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60125-027-000 Advertising .00 .00 _______________ Account: 135-60125-027-000 Advertising Totals: .00 .00 ** 4,700.00 Budgeted 4,700.00 Remaining 0 % Used Account: 135-60245-027-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-027-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-60270-027-000 4th of July Celebration 10,000.00 .00 10,000.00 . glpdatb2 rgonzale Trophy Club Entities Page 56 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 3/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-60270-027-000 4th of July Celebration Totals: .00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 135-60360-027-000 Furniture/Equipment < $5000 299.99 .00 299.99 _______________ Account: 135-60360-027-000 Furniture/Equipment < $5000 Totals: .00 299.99 ** 2,225.00 Budgeted 1,925.01 Remaining 13 % Used Account: 135-65085-027-000 Office Supplies 767 03/31/2012 March A/P Office supplies 701.28 138.25 839.53 OFFICE DEPOT, INC 31369 AP 767 03/31/2012 March A/P Office supplies 55.66 895.19 OFFICE DEPOT, INC 31369 AP 767 03/31/2012 March A/P Office supplies 35.32 930.51 OFFICE DEPOT, INC 31369 AP 767 03/31/2012 March A/P Office supplies 34.38 964.89 OFFICE DEPOT, INC 31369 AP 767 03/31/2012 March A/P Office Supplies 134.49 1,099.38 OFFICE DEPOT, INC 31369 AP _______________ Account: 135-65085-027-000 Office Supplies Totals: 398.10 1,099.38 ** 2,450.00 Budgeted 1,350.62 Remaining 45 % Used Account: 135-65105-027-000 Printing 767 03/31/2012 March A/P Business Card shells used by M 463.00 44.70 507.70 TOWN OF TROPHY CLUB 31383 AP 767 03/31/2012 March A/P Business cards/McKnight 81.75 589.45 FORMS ONE 31363 AP _______________ Account: 135-65105-027-000 Printing Totals: 126.45 589.45 ** 515.00 Budgeted (74.45) Remaining 114 % Used Department 27 Totals: ------------------------------------------------------------------------------------------------ 413,691.69 ** 532,866.00 Budgeted 119,174.31 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club Entities Page 57 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50070-028-000 Employee Relations 1,470.22 .00 1,470.22 _______________ Account: 135-50070-028-000 Employee Relations Totals: .00 1,470.22 ** 1,967.00 Budgeted 496.78 Remaining 75 % Used Account: 135-50075-028-000 Tuition Reimbursement 19.95 .00 19.95 _______________ Account: 135-50075-028-000 Tuition Reimbursement Totals: .00 19.95 ** 1,561.00 Budgeted 1,541.05 Remaining 1 % Used Account: 135-60005-028-000 Telephone .00 .00 _______________ Account: 135-60005-028-000 Telephone Totals: .00 .00 ** 28.00 Budgeted 28.00 Remaining 0 % Used Account: 135-60035-028-000 Postage .00 .00 _______________ Account: 135-60035-028-000 Postage Totals: .00 .00 ** 106.00 Budgeted 106.00 Remaining 0 % Used Account: 135-60066-028-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-028-000 Publications/Books/Subscripts Totals: .00 .00 ** 485.00 Budgeted 485.00 Remaining 0 % Used Account: 135-60070-028-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-028-000 Dues & Memberships Totals: .00 .00 ** 555.00 Budgeted 555.00 Remaining 0 % Used Account: 135-60075-028-000 Meetings . glpdatb2 rgonzale Trophy Club Entities Page 58 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60075-028-000 Meetings Totals: .00 .00 ** 138.00 Budgeted 138.00 Remaining 0 % Used Account: 135-60080-028-000 Schools & Training .00 .00 _______________ Account: 135-60080-028-000 Schools & Training Totals: .00 .00 ** 594.00 Budgeted 594.00 Remaining 0 % Used Account: 135-60100-028-000 Travel & per diem .00 .00 _______________ Account: 135-60100-028-000 Travel & per diem Totals: .00 .00 ** 8.00 Budgeted 8.00 Remaining 0 % Used Account: 135-60110-028-000 Physicals/Testing 105.00 .00 105.00 _______________ Account: 135-60110-028-000 Physicals/Testing Totals: .00 105.00 ** 1,560.00 Budgeted 1,455.00 Remaining 7 % Used Account: 135-65085-028-000 Office Supplies .00 .00 _______________ Account: 135-65085-028-000 Office Supplies Totals: .00 .00 ** 437.00 Budgeted 437.00 Remaining 0 % Used Account: 135-65105-028-000 Printing .00 .00 _______________ Account: 135-65105-028-000 Printing Totals: .00 .00 ** 116.00 Budgeted 116.00 Remaining 0 % Used Department 28 Totals: ------------------------------------------------------------------------------------------------ 1,595.17 ** 7,555.00 Budgeted 5,959.83 Remaining 21 % Used . glpdatb2 rgonzale Trophy Club Entities Page 59 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 3/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 538 03/02/2012 PAYROLL 3/2/12 Salaries & Wages 33,194.56 2,942.31 36,136.87 PR 647 03/16/2012 PAYROLL 3/16/12 Salaries & Wages 2,942.31 39,079.18 PR 696 03/30/2012 PAYROLL 3/30/12 Salaries & Wages 2,942.31 42,021.49 PR _______________ Account: 135-50005-029-000 Salaries & Wages Totals: 8,826.93 42,021.49 ** 94,404.00 Budgeted 52,382.51 Remaining 45 % 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 538 03/02/2012 PAYROLL 3/2/12 Retirement 5,319.20 406.63 5,725.83 PR 647 03/16/2012 PAYROLL 3/16/12 Retirement 406.62 6,132.45 PR 696 03/30/2012 PAYROLL 3/30/12 Retirement 406.63 6,539.08 PR _______________ Account: 135-50020-029-000 Retirement Totals: 1,219.88 6,539.08 ** 13,612.00 Budgeted 7,072.92 Remaining 48 % Used Account: 135-50026-029-000 Medical Insurance 538 03/02/2012 PAYROLL 3/2/12 Medical Insurance 3,721.08 205.35 3,926.43 PR 647 03/16/2012 PAYROLL 3/16/12 Medical Insurance 205.35 4,131.78 PR _______________ Account: 135-50026-029-000 Medical Insurance Totals: 410.70 4,131.78 ** 11,060.00 Budgeted 6,928.22 Remaining 37 % Used Account: 135-50027-029-000 Dental Insurance 538 03/02/2012 PAYROLL 3/2/12 Dental Insurance 330.85 24.51 355.36 PR 647 03/16/2012 PAYROLL 3/16/12 Dental Insurance 24.51 379.87 PR . glpdatb2 rgonzale Trophy Club Entities Page 60 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 3/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-029-000 Dental Insurance Totals: 49.02 379.87 ** 773.00 Budgeted 393.13 Remaining 49 % Used Account: 135-50028-029-000 Vision Insurance 538 03/02/2012 PAYROLL 3/2/12 Vision Insurance 53.87 3.38 57.25 PR 647 03/16/2012 PAYROLL 3/16/12 Vision Insurance 3.38 60.63 PR _______________ Account: 135-50028-029-000 Vision Insurance Totals: 6.76 60.63 ** 207.00 Budgeted 146.37 Remaining 29 % 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 538 03/02/2012 PAYROLL 3/2/12 Social Security Taxes 2,083.56 169.28 2,252.84 PR 647 03/16/2012 PAYROLL 3/16/12 Social Security Taxes 169.27 2,422.11 PR 696 03/30/2012 PAYROLL 3/30/12 Social Security Taxes 182.42 2,604.53 PR _______________ Account: 135-50030-029-000 Social Security Taxes Totals: 520.97 2,604.53 ** 5,386.00 Budgeted 2,781.47 Remaining 48 % Used Account: 135-50035-029-000 Medicare Taxes 538 03/02/2012 PAYROLL 3/2/12 Medicare Taxes 487.29 39.59 526.88 PR 647 03/16/2012 PAYROLL 3/16/12 Medicare Taxes 39.59 566.47 PR 696 03/30/2012 PAYROLL 3/30/12 Medicare Taxes 42.66 609.13 PR _______________ Account: 135-50035-029-000 Medicare Taxes Totals: 121.84 609.13 ** 1,260.00 Budgeted 650.87 Remaining 48 % Used Account: 135-50040-029-000 Unemployment Taxes 79.54 .00 79.54 _______________ Account: 135-50040-029-000 Unemployment Taxes Totals: .00 79.54 ** 284.00 Budgeted 204.46 Remaining 28 % Used . glpdatb2 rgonzale Trophy Club Entities Page 61 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-029-000 Workman's Compensation 211.00 .00 211.00 _______________ Account: 135-50045-029-000 Workman's Compensation Totals: .00 211.00 ** 235.00 Budgeted 24.00 Remaining 90 % Used Account: 135-55160-029-000 Professional Outside Services 767 03/31/2012 March A/P Conversion and support 973.50 132.00 1,105.50 STW INC 31373 AP _______________ Account: 135-55160-029-000 Professional Outside Services Totals: 132.00 1,105.50 ** 5,000.00 Budgeted 3,894.50 Remaining 22 % Used Account: 135-60005-029-000 Telephone 767 03/31/2012 March A/P March PCards-Zieverink 36.33 9.94 46.27 BANK OF AMERICA 31359 AP _______________ Account: 135-60005-029-000 Telephone Totals: 9.94 46.27 ** 103.00 Budgeted 56.73 Remaining 45 % Used Account: 135-60010-029-000 Communications/Pagers/Mobiles 767 03/31/2012 March A/P Cell phone 253.68 51.92 305.60 VERIZON WIRELESS 31387 AP _______________ Account: 135-60010-029-000 Communications/Pagers/Mobiles Totals: 51.92 305.60 ** 683.00 Budgeted 377.40 Remaining 45 % Used Account: 135-60035-029-000 Postage 826 03/31/2012 February Postage 96.99 31.25 128.24 GL 827 03/31/2012 March Postage 25.85 154.09 GL _______________ Account: 135-60035-029-000 Postage Totals: 57.10 154.09 ** 700.00 Budgeted 545.91 Remaining 22 % 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 . glpdatb2 rgonzale Trophy Club Entities Page 62 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 3/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-60066-029-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-029-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-029-000 Dues & Memberships Totals: .00 .00 ** 660.00 Budgeted 660.00 Remaining 0 % Used Account: 135-60075-029-000 Meetings 22.00 .00 22.00 _______________ Account: 135-60075-029-000 Meetings Totals: .00 22.00 ** 300.00 Budgeted 278.00 Remaining 7 % Used Account: 135-60080-029-000 Schools & Training 697 03/27/2012 March A/P User Conf-McKnight, Gonzales, 225.00 225.00 STW INC 31349 AP _______________ Account: 135-60080-029-000 Schools & Training Totals: 225.00 225.00 ** 2,000.00 Budgeted 1,775.00 Remaining 11 % Used Account: 135-60100-029-000 Travel & per diem 27.81 .00 27.81 _______________ Account: 135-60100-029-000 Travel & per diem Totals: .00 27.81 ** 1,500.00 Budgeted 1,472.19 Remaining 2 % 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 . glpdatb2 rgonzale Trophy Club Entities Page 63 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 3/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-60245-029-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65085-029-000 Office Supplies 767 03/31/2012 March A/P Office supplies 99.94 6.93 106.87 OFFICE DEPOT, INC 31369 AP _______________ Account: 135-65085-029-000 Office Supplies Totals: 6.93 106.87 ** 849.00 Budgeted 742.13 Remaining 13 % Used Account: 135-65105-029-000 Printing .00 .00 _______________ Account: 135-65105-029-000 Printing Totals: .00 .00 ** 515.00 Budgeted 515.00 Remaining 0 % Used Department 29 Totals: ------------------------------------------------------------------------------------------------ 61,431.47 ** 144,910.00 Budgeted 83,478.53 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club Entities Page 64 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 3/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 697 03/27/2012 March A/P Feb PCards 29,833.45 326.69 30,160.14 JPMORGAN CHASE BANK NA 31334 AP 767 03/31/2012 March A/P Conversion and support 4,811.23 34,971.37 STW INC 31373 AP 767 03/31/2012 March A/P March PCard-Pastor 25.00 34,996.37 BANK OF AMERICA 31359 AP 767 03/31/2012 March A/P March PCard-Pastor 100.00 35,096.37 BANK OF AMERICA 31359 AP 767 03/31/2012 March A/P March PCards-Zieverink 53.38 35,149.75 BANK OF AMERICA 31359 AP 767 03/31/2012 March A/P March PCards-Zieverink 54.99 35,204.74 BANK OF AMERICA 31359 AP _______________ Account: 135-55030-033-000 Software & Support Totals: 5,371.29 35,204.74 ** 64,149.00 Budgeted 28,944.26 Remaining 55 % Used Account: 135-55070-033-000 Independent Labor 375.00 .00 375.00 _______________ Account: 135-55070-033-000 Independent Labor Totals: .00 375.00 ** 1,650.00 Budgeted 1,275.00 Remaining 23 % Used Account: 135-60005-033-000 Telephone 767 03/31/2012 March A/P March PCards-Zieverink 3,772.08 394.20 4,166.28 BANK OF AMERICA 31359 AP 767 03/31/2012 March A/P March PCards-Zieverink 368.54 4,534.82 BANK OF AMERICA 31359 AP _______________ Account: 135-60005-033-000 Telephone Totals: 762.74 4,534.82 ** 6,540.00 Budgeted 2,005.18 Remaining 69 % Used Account: 135-60235-033-000 Security 767 03/31/2012 March A/P March PCard-Pastor 406.60 406.60 BANK OF AMERICA 31359 AP _______________ Account: 135-60235-033-000 Security Totals: 406.60 406.60 ** 1,350.00 Budgeted 943.40 Remaining 30 % Used Account: 135-65055-033-000 Hardware 697 03/27/2012 March A/P Batteries for Servers UPS 60,912.64 164.23 61,076.87 SHI GOVERNMENT SOLUTIONS,INC 31346 AP 767 03/31/2012 March A/P March PCard-Pastor 15.01 61,091.88 BANK OF AMERICA 31359 AP 767 03/31/2012 March A/P March PCard-Pastor 96.45 61,188.33 BANK OF AMERICA 31359 AP 767 03/31/2012 March A/P March PCards-Zieverink 6.99 61,195.32 BANK OF AMERICA 31359 AP _______________ Account: 135-65055-033-000 Hardware Totals: 282.68 61,195.32 ** 83,238.00 Budgeted 22,042.68 Remaining 74 % Used . glpdatb2 rgonzale Trophy Club Entities Page 65 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65085-033-000 Office Supplies 176.93 .00 176.93 _______________ Account: 135-65085-033-000 Office Supplies Totals: .00 176.93 ** 371.00 Budgeted 194.07 Remaining 48 % Used Account: 135-65090-033-000 Printer Supplies & Maintenance 767 03/31/2012 March A/P March PCards-Zieverink 2,998.38 75.00 3,073.38 BANK OF AMERICA 31359 AP _______________ Account: 135-65090-033-000 Printer Supplies & Maintenance Totals: 75.00 3,073.38 ** 5,732.00 Budgeted 2,658.62 Remaining 54 % Used Account: 135-69170-033-000 Copier Lease Installments 697 03/27/2012 March A/P March Copier 1,027.40 256.85 1,284.25 KYOCERA MITA AMERICA, INC. 31335 AP _______________ Account: 135-69170-033-000 Copier Lease Installments Totals: 256.85 1,284.25 ** 3,450.00 Budgeted 2,165.75 Remaining 37 % 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: ------------------------------------------------------------------------------------------------ 106,251.04 ** 193,391.00 Budgeted 87,139.96 Remaining 55 % Used . glpdatb2 rgonzale Trophy Club Entities Page 66 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-037-000 Workman's Compensation 861.00 .00 861.00 _______________ Account: 135-50045-037-000 Workman's Compensation Totals: .00 861.00 ** .00 Budgeted (861.00) Remaining 0 % Used Account: 135-55100-037-000 Building Maint & Supplies 697 03/27/2012 March A/P Rekey exterior doors 491.68 168.00 659.68 MICHAEL'S KEYS 31337 AP 697 03/27/2012 March A/P Rekey MUD Sec office 65.00 724.68 MICHAEL'S KEYS 31337 AP _______________ Account: 135-55100-037-000 Building Maint & Supplies Totals: 233.00 724.68 ** 29,577.00 Budgeted 28,852.32 Remaining 2 % Used Account: 135-55120-037-000 Cleaning Services 697 03/27/2012 March A/P March Janitorial Service 5,840.61 1,678.51 7,519.12 ABM JANITORIAL SERVICES, INC 31318 AP _______________ Account: 135-55120-037-000 Cleaning Services Totals: 1,678.51 7,519.12 ** 25,000.00 Budgeted 17,480.88 Remaining 30 % Used Account: 135-60020-037-000 Electricity 697 03/27/2012 March A/P Electricity 1/17-2/15 4,035.21 1,188.35 5,223.56 DIRECT ENERGY BUSINESS SVCS 31329 AP _______________ Account: 135-60020-037-000 Electricity Totals: 1,188.35 5,223.56 ** 21,940.00 Budgeted 16,716.44 Remaining 24 % Used Account: 135-60025-037-000 Water 697 03/27/2012 March A/P Feb Water 203.72 41.44 245.16 TROPHY CLUB MUD (WATER BILLS) 31353 AP 767 03/31/2012 March A/P March water 50.16 295.32 TROPHY CLUB MUD (WATER BILLS) 31385 AP _______________ Account: 135-60025-037-000 Water Totals: 91.60 295.32 ** 1,093.00 Budgeted 797.68 Remaining 27 % Used Account: 135-60030-037-000 Rent And/Or Usage 595 03/07/2012 March A/P March PS Bldg rent 5,492.55 1,098.51 6,591.06 TOWN OF TROPHY CLUB 31313 AP _______________ Account: 135-60030-037-000 Rent And/Or Usage Totals: 1,098.51 6,591.06 ** 13,182.00 Budgeted 6,590.94 Remaining 50 % Used . glpdatb2 rgonzale Trophy Club Entities Page 67 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60055-037-000 Insurance 735 03/28/2012 3/28/12 Deposits TML Refund Credit bal 28,589.50 (59.01) 28,530.49 GL 767 03/31/2012 March A/P Insurance deductible 1,756.24 30,286.73 TML INTERGOVERNMENTAL RISK 31378 AP _______________ Account: 135-60055-037-000 Insurance Totals: 1,697.23 30,286.73 ** 32,635.00 Budgeted 2,348.27 Remaining 93 % Used Account: 135-60360-037-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-037-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65095-037-000 Maintenance Supplies 697 03/27/2012 March A/P Feb PCards 618.92 30.78 649.70 JPMORGAN CHASE BANK NA 31334 AP 697 03/27/2012 March A/P Feb PCards 1.67 651.37 JPMORGAN CHASE BANK NA 31334 AP _______________ Account: 135-65095-037-000 Maintenance Supplies Totals: 32.45 651.37 ** 2,205.00 Budgeted 1,553.63 Remaining 30 % Used Account: 135-65097-037-000 Vending Machine Supplies 76.03 .00 76.03 _______________ Account: 135-65097-037-000 Vending Machine Supplies Totals: .00 76.03 ** 1,000.00 Budgeted 923.97 Remaining 8 % Used Department 37 Totals: ------------------------------------------------------------------------------------------------ 52,228.87 ** 129,132.00 Budgeted 76,903.13 Remaining 40 % Used . glpdatb2 rgonzale Trophy Club Entities Page 68 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 3/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 538 03/02/2012 PAYROLL 3/2/12 Salaries & Wages 31,190.18 3,284.69 34,474.87 PR 647 03/16/2012 PAYROLL 3/16/12 Salaries & Wages 3,275.79 37,750.66 PR 696 03/30/2012 PAYROLL 3/30/12 Salaries & Wages 3,291.67 41,042.33 PR _______________ Account: 135-50005-038-000 Salaries & Wages Totals: 9,852.15 41,042.33 ** 84,946.00 Budgeted 43,903.67 Remaining 48 % Used Account: 135-50010-038-000 Overtime 538 03/02/2012 PAYROLL 3/2/12 Overtime 205.90 6.60 212.50 PR 647 03/16/2012 PAYROLL 3/16/12 Overtime 9.96 222.46 PR 696 03/30/2012 PAYROLL 3/30/12 Overtime 10.77 233.23 PR _______________ Account: 135-50010-038-000 Overtime Totals: 27.33 233.23 ** 2,000.00 Budgeted 1,766.77 Remaining 12 % Used Account: 135-50016-038-000 Longevity 220.00 .00 220.00 _______________ Account: 135-50016-038-000 Longevity Totals: .00 220.00 ** 220.00 Budgeted .00 Remaining 100 % Used Account: 135-50020-038-000 Retirement 538 03/02/2012 PAYROLL 3/2/12 Retirement 4,665.14 454.84 5,119.98 PR 647 03/16/2012 PAYROLL 3/16/12 Retirement 454.10 5,574.08 PR 696 03/30/2012 PAYROLL 3/30/12 Retirement 456.39 6,030.47 PR _______________ Account: 135-50020-038-000 Retirement Totals: 1,365.33 6,030.47 ** 12,203.00 Budgeted 6,172.53 Remaining 49 % Used Account: 135-50026-038-000 Medical Insurance 538 03/02/2012 PAYROLL 3/2/12 Medical Insurance 4,621.12 462.17 5,083.29 PR 647 03/16/2012 PAYROLL 3/16/12 Medical Insurance 462.09 5,545.38 PR _______________ Account: 135-50026-038-000 Medical Insurance Totals: 924.26 5,545.38 ** 12,321.00 Budgeted 6,775.62 Remaining 45 % Used Account: 135-50027-038-000 Dental Insurance . glpdatb2 rgonzale Trophy Club Entities Page 69 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 538 03/02/2012 PAYROLL 3/2/12 Dental Insurance 458.23 45.83 504.06 PR 647 03/16/2012 PAYROLL 3/16/12 Dental Insurance 45.81 549.87 PR _______________ Account: 135-50027-038-000 Dental Insurance Totals: 91.64 549.87 ** 1,026.00 Budgeted 476.13 Remaining 54 % Used Account: 135-50028-038-000 Vision Insurance 538 03/02/2012 PAYROLL 3/2/12 Vision Insurance 108.13 10.81 118.94 PR 647 03/16/2012 PAYROLL 3/16/12 Vision Insurance 10.80 129.74 PR _______________ Account: 135-50028-038-000 Vision Insurance Totals: 21.61 129.74 ** 260.00 Budgeted 130.26 Remaining 50 % 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 538 03/02/2012 PAYROLL 3/2/12 Social Security Taxes 1,883.52 186.18 2,069.70 PR 647 03/16/2012 PAYROLL 3/16/12 Social Security Taxes 185.82 2,255.52 PR 696 03/30/2012 PAYROLL 3/30/12 Social Security Taxes 204.76 2,460.28 PR _______________ Account: 135-50030-038-000 Social Security Taxes Totals: 576.76 2,460.28 ** 5,404.00 Budgeted 2,943.72 Remaining 46 % Used Account: 135-50035-038-000 Medicare Taxes 538 03/02/2012 PAYROLL 3/2/12 Medicare Taxes 440.51 43.54 484.05 PR 647 03/16/2012 PAYROLL 3/16/12 Medicare Taxes 43.45 527.50 PR 696 03/30/2012 PAYROLL 3/30/12 Medicare Taxes 47.89 575.39 PR _______________ Account: 135-50035-038-000 Medicare Taxes Totals: 134.88 575.39 ** 1,264.00 Budgeted 688.61 Remaining 46 % Used Account: 135-50040-038-000 Unemployment Taxes 538 03/02/2012 PAYROLL 3/2/12 Unemployment Taxes 115.66 26.34 142.00 PR 647 03/16/2012 PAYROLL 3/16/12 Unemployment Taxes 26.29 168.29 PR . glpdatb2 rgonzale Trophy Club Entities Page 70 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 696 03/30/2012 PAYROLL 3/30/12 Unemployment Taxes 115.66 18.32 186.61 PR _______________ Account: 135-50040-038-000 Unemployment Taxes Totals: 70.95 186.61 ** 473.00 Budgeted 286.39 Remaining 39 % Used Account: 135-50045-038-000 Workman's Compensation 235.00 .00 235.00 _______________ Account: 135-50045-038-000 Workman's Compensation Totals: .00 235.00 ** 211.00 Budgeted (24.00) Remaining 111 % Used Account: 135-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 767 03/31/2012 March A/P March Utility bills 5,108.78 892.29 6,001.07 CSG SYSTEMS, INC. 31361 AP _______________ Account: 135-55205-038-000 Utility Billing Contract Totals: 892.29 6,001.07 ** 11,000.00 Budgeted 4,998.93 Remaining 55 % Used Account: 135-60005-038-000 Telephone 767 03/31/2012 March A/P March PCards-Zieverink 38.05 5.32 43.37 BANK OF AMERICA 31359 AP _______________ Account: 135-60005-038-000 Telephone Totals: 5.32 43.37 ** 100.00 Budgeted 56.63 Remaining 43 % Used Account: 135-60010-038-000 Communications/Pagers/Mobiles 767 03/31/2012 March A/P Cell phone 178.92 36.96 215.88 VERIZON WIRELESS 31387 AP _______________ Account: 135-60010-038-000 Communications/Pagers/Mobiles Totals: 36.96 215.88 ** 472.00 Budgeted 256.12 Remaining 46 % Used Account: 135-60035-038-000 Postage 767 03/31/2012 March A/P March Utility bills 7,100.14 1,374.50 8,474.64 CSG SYSTEMS, INC. 31361 AP . glpdatb2 rgonzale Trophy Club Entities Page 71 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60035-038-000 Postage Totals: 1,374.50 8,474.64 ** 18,000.00 Budgeted 9,525.36 Remaining 47 % Used Account: 135-60040-038-000 Service Charges & Fees 807 03/02/2012 Credit card fees/Mar 13,107.67 60.35 13,168.02 GL 807 03/02/2012 Credit card fees/Mar 9.99 13,178.01 GL 807 03/02/2012 Credit card fees/Mar 64.42 13,242.43 GL 807 03/02/2012 Credit card fees/Mar 721.54 13,963.97 GL 807 03/02/2012 Credit card fees/Mar 706.31 14,670.28 GL _______________ Account: 135-60040-038-000 Service Charges & Fees Totals: 1,562.61 14,670.28 ** 18,000.00 Budgeted 3,329.72 Remaining 82 % 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 697 03/27/2012 March A/P User Conf-McKnight, Gonzales, 225.00 225.00 STW INC 31349 AP _______________ Account: 135-60080-038-000 Schools & Training Totals: 225.00 225.00 ** 800.00 Budgeted 575.00 Remaining 28 % Used Account: 135-60100-038-000 Travel & per diem .00 .00 _______________ Account: 135-60100-038-000 Travel & per diem Totals: .00 .00 ** 605.00 Budgeted 605.00 Remaining 0 % Used Account: 135-60130-038-000 Reg Assessment Fee (5%) 25,071.20 .00 25,071.20 _______________ Account: 135-60130-038-000 Reg Assessment Fee (5%) Totals: .00 25,071.20 ** 22,500.00 Budgeted (2,571.20) Remaining 111 % Used . glpdatb2 rgonzale Trophy Club Entities Page 72 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 3/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-60245-038-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-038-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65085-038-000 Office Supplies 767 03/31/2012 March A/P Office Supplies 657.57 3.29 660.86 OFFICE DEPOT, INC 31369 AP _______________ Account: 135-65085-038-000 Office Supplies Totals: 3.29 660.86 ** 700.00 Budgeted 39.14 Remaining 94 % 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: ------------------------------------------------------------------------------------------------ 112,570.60 ** 197,430.00 Budgeted 84,859.40 Remaining 57 % Used . glpdatb2 rgonzale Trophy Club Entities Page 73 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/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 697 03/27/2012 March A/P Feb Legal/General 36,848.39 384.00 37,232.39 WHITAKER CHALK SWINDLE 31357 AP 697 03/27/2012 March A/P Feb Legal/Bond Refunding 1,376.00 38,608.39 WHITAKER CHALK SWINDLE 31357 AP 767 03/31/2012 March A/P March legal 5,887.15 44,495.54 THE LISTON LAW FIRM, P.C. 31376 AP _______________ Account: 135-55045-039-000 Legal Totals: 7,647.15 44,495.54 ** 55,000.00 Budgeted 10,504.46 Remaining 81 % 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 595 03/07/2012 March A/P 2nd qtr Budget allocation 8,533.65 2,540.89 11,074.54 DENTON CENTRAL APPRAISAL DISTR 31285 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,540.89 11,074.54 ** 20,000.00 Budgeted 8,925.46 Remaining 55 % Used Account: 135-55065-039-000 Tax Admin Fees 2,470.09 .00 2,470.09 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,470.09 ** 3,629.00 Budgeted 1,158.91 Remaining 68 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 2,277.85 .00 2,277.85 _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: .00 2,277.85 ** .00 Budgeted (2,277.85) Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 80,518.02 ** 98,829.00 Budgeted 18,310.98 Remaining 81 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 94,295.57 .00 Budgeted (94,295.57) Remaining 0 % Used Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 3/31/2012 ASSETS ASSETS CASH AND CASH IN BANK 6,120$ INVESTMENTS 803,340 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 31,760 TOTAL ASSETS 841,220$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 31,760$ TOTAL LIABILITIES 31,760 FUND BALANCE DESIGNATED FOR DEBT SERVICE 809,460 TOTAL LIABILITIES AND FUND BALANCE 841,220$ March 31, 2012 6/12 Months (50% of Fiscal Year) . glbase_tbam rgonzale Trophy Club Entities Page 21 09:56 04/20/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 3/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- 3,116.38- 535,123.34- 97.880 11,592.66- 533-40002-000-000 Property Taxes/Delinquent 3,947.00- 139.68 3,287.56 -83.293 7,234.56- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 250.73- 1,290.40- 25.721 3,726.60- Subtotal: 555,680.00- 555,680.00- 3,227.43- 533,126.18- 95.941 22,553.82- 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- 500.00- 746.59- 854.93- 170.986 354.93 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- 4,661.84 Subtotal: 308,500.00- 308,500.00- 5,408.43- 313,516.77- 101.626 5,016.77 Program number: 870,300.00- 870,300.00- 8,635.86- 852,762.95- 97.985 17,537.05- Department number: Revenues 870,300.00- 870,300.00- 8,635.86- 852,762.95- 97.985 17,537.05- Revenues Subtotal ----------- 870,300.00- 870,300.00- 8,635.86- 852,762.95- 97.985 17,537.05- . glbase_tbam rgonzale Trophy Club Entities Page 22 09:56 04/20/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 3/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 500.00 12.500 3,500.00 533-70025-051-000 Bond Interest Expense 301,300.00 301,300.00 150,650.00 50.000 150,650.00 533-70035-051-000 Bond Principal Payment 565,000.00 565,000.00 565,000.00 Subtotal: 870,300.00 870,300.00 151,150.00 17.368 719,150.00 Program number: 870,300.00 870,300.00 151,150.00 17.368 719,150.00 Department number: Administration 870,300.00 870,300.00 151,150.00 17.368 719,150.00 Expenditures Subtotal ----------- 870,300.00 870,300.00 151,150.00 17.368 719,150.00 Fund number: 533 MUD 1 I&S CONSOLIDATED 8,635.86- 701,612.95- 701,612.95 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club Entities Page 74 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 3/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 781 03/01/2012 Property Taxes/Assessments (532,006.96) (149.88) (532,156.84) GL 782 03/02/2012 Property Taxes/Assessments (205.15) (532,361.99) GL 783 03/05/2012 Property Taxes/Assessments (376.41) (532,738.40) GL 784 03/06/2012 Property Taxes/Assessments (151.13) (532,889.53) GL 785 03/07/2012 Property Taxes/Assessments (396.66) (533,286.19) GL 787 03/09/2012 Property Taxes/Assessments 524.54 (532,761.65) GL 788 03/12/2012 Property Taxes/Assessments (499.72) (533,261.37) GL 791 03/13/2012 Property Taxes/Assessments (260.41) (533,521.78) GL 792 03/14/2012 Property Taxes/Assessments (153.02) (533,674.80) GL 793 03/15/2012 Property Taxes/Assessments (.54) (533,675.34) GL 794 03/16/2012 Property Taxes/Assessments (66.94) (533,742.28) GL 795 03/19/2012 Property Taxes/Assessments (208.76) (533,951.04) GL 796 03/20/2012 Property Taxes/Assessments (40.50) (533,991.54) GL 797 03/21/2012 Property Taxes/Assessments (44.22) (534,035.76) GL 798 03/22/2012 Property Taxes/Assessments (26.78) (534,062.54) GL 799 03/23/2012 Property Taxes/Assessments (278.18) (534,340.72) GL 800 03/26/2012 Property Taxes/Assessments (250.53) (534,591.25) GL 801 03/27/2012 Property Taxes/Assessments (174.32) (534,765.57) GL 802 03/28/2012 Property Taxes/Assessments (112.59) (534,878.16) GL 803 03/29/2012 Property Taxes/Assessments (48.00) (534,926.16) GL 804 03/30/2012 Property Taxes/Assessments (197.18) (535,123.34) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (3,116.38) (535,123.34) ** (546,716.00) Budgeted (11,592.66) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 784 03/06/2012 Property Taxes/Assessments 3,147.88 95.88 3,243.76 GL 784 03/06/2012 Property Taxes/Assessments 152.67 3,396.43 GL 785 03/07/2012 Property Taxes/Assessments (77.56) 3,318.87 GL 785 03/07/2012 Property Taxes/Assessments (33.83) 3,285.04 GL 787 03/09/2012 Property Taxes/Assessments 19.24 3,304.28 GL 795 03/19/2012 Property Taxes/Assessments (16.72) 3,287.56 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: 139.68 3,287.56 ** (3,947.00) Budgeted (7,234.56) Remaining -83 % Used Account: 533-40015-000-000 Property Taxes/P & I 781 03/01/2012 Property Taxes/Assessments (1,039.67) (10.48) (1,050.15) GL 782 03/02/2012 Property Taxes/Assessments (18.00) (1,068.15) GL 783 03/05/2012 Property Taxes/Assessments (18.15) (1,086.30) GL . glpdatb2 rgonzale Trophy Club Entities Page 75 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 784 03/06/2012 Property Taxes/Assessments (1,039.67) (13.51) (1,099.81) GL 785 03/07/2012 Property Taxes/Assessments (45.36) (1,145.17) GL 785 03/07/2012 Property Taxes/Assessments (12.86) (1,158.03) GL 788 03/12/2012 Property Taxes/Assessments (29.07) (1,187.10) GL 791 03/13/2012 Property Taxes/Assessments (14.50) (1,201.60) GL 792 03/14/2012 Property Taxes/Assessments (13.77) (1,215.37) GL 793 03/15/2012 Property Taxes/Assessments (.05) (1,215.42) GL 794 03/16/2012 Property Taxes/Assessments (3.23) (1,218.65) GL 799 03/23/2012 Property Taxes/Assessments (22.16) (1,240.81) GL 800 03/26/2012 Property Taxes/Assessments (18.64) (1,259.45) GL 801 03/27/2012 Property Taxes/Assessments (10.35) (1,269.80) GL 802 03/28/2012 Property Taxes/Assessments (7.55) (1,277.35) GL 803 03/29/2012 Property Taxes/Assessments (2.03) (1,279.38) GL 804 03/30/2012 Property Taxes/Assessments (11.02) (1,290.40) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (250.73) (1,290.40) ** (5,017.00) Budgeted (3,726.60) Remaining 26 % 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 809 03/05/2012 Unl Tax Refunding 2012 Accrued Interest (108.34) (675.00) (783.34) GL 808 03/31/2012 March Bank Interest (71.59) (854.93) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (746.59) (854.93) ** (500.00) Budgeted 354.93 Remaining 171 % 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 809 03/05/2012 Unl Tax Refunding 2012 Use of Funds Add'l Proceeds (4,101.45) (4,101.45) GL . glpdatb2 rgonzale Trophy Club Entities Page 76 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 809 03/05/2012 Unl Tax Refunding 2012 Excess Cost of Issuance Funds (560.39) (4,661.84) GL _______________ Account: 533-49110-000-000 Premium on Bonds Sold Totals: (4,661.84) (4,661.84) ** .00 Budgeted 4,661.84 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (852,762.95) ** (870,300.00) Budgeted (17,537.05) Remaining 98 % Used . glpdatb2 rgonzale Trophy Club Entities Page 77 09:56 04/20/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 3/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 500.00 .00 500.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 500.00 ** 4,000.00 Budgeted 3,500.00 Remaining 13 % Used Account: 533-70025-051-000 Bond Interest Expense 150,650.00 .00 150,650.00 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 150,650.00 ** 301,300.00 Budgeted 150,650.00 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 565,000.00 Budgeted 565,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 151,150.00 ** 870,300.00 Budgeted 719,150.00 Remaining 17 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (701,612.95) .00 Budgeted 701,612.95 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (1,159,778.66) **** .00 Budgeted 1,159,778.66 Remaining 0 % Used ******* End of Report *********