Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
February 2012 MUD Financials
. glpdatb2 rgonzale Trophy Club Entities Page 1 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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 424 02/01/2012 Property Taxes (166,118.37) (2,037.05) (168,155.42) GL 429 02/02/2012 Property Taxes (9,699.27) (177,854.69) GL 431 02/03/2012 Property Taxes (1,025.91) (178,880.60) GL 545 02/06/2012 Property Taxes (1,359.45) (180,240.05) GL 546 02/07/2012 Property Taxes (1,311.86) (181,551.91) GL 548 02/09/2012 Property Taxes (49.27) (181,601.18) GL 549 02/10/2012 Property Taxes (1,282.08) (182,883.26) GL 552 02/17/2012 Property Taxes (117.14) (183,000.40) GL 557 02/27/2012 Property Taxes (809.45) (183,809.85) GL 602 02/29/2012 Property Taxes (53.31) (183,863.16) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (17,744.79) (183,863.16) ** (193,233.00) Budgeted (9,369.84) Remaining 95 % 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 424 02/01/2012 Property Taxes (940,438.37) (4,114.59) (944,552.96) GL 429 02/02/2012 Property Taxes (33,208.71) (977,761.67) GL 431 02/03/2012 Property Taxes (20,952.37) (998,714.04) GL 545 02/06/2012 Property Taxes (14,825.10) (1,013,539.14) GL 546 02/07/2012 Property Taxes (10,329.09) (1,023,868.23) GL 547 02/08/2012 Property Taxes (1,086.11) (1,024,954.34) GL 548 02/09/2012 Property Taxes (1,597.50) (1,026,551.84) GL 549 02/10/2012 Property Taxes (6,949.78) (1,033,501.62) GL 550 02/14/2012 Property Taxes (436.92) (1,033,938.54) GL 551 02/16/2012 Property Taxes (735.09) (1,034,673.63) GL 553 02/21/2012 Property Taxes (1,048.24) (1,035,721.87) GL 554 02/22/2012 Property Taxes (432.50) (1,036,154.37) GL 555 02/23/2012 Property Taxes (162.52) (1,036,316.89) GL 557 02/27/2012 Property Taxes (282.32) (1,036,599.21) GL 601 02/28/2012 Property Taxes (2,642.32) (1,039,241.53) GL 602 02/29/2012 Property Taxes (1,247.02) (1,040,488.55) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (100,050.18) (1,040,488.55) ** (1,076,976.00) Budgeted (36,487.45) Remaining 97 % Used . glpdatb2 rgonzale Trophy Club Entities Page 2 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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-40011-000-000 Property Taxes/Fire-Delinquent 429 02/02/2012 Property Taxes 5,517.15 27.31 5,544.46 GL 546 02/07/2012 Property Taxes (.14) 5,544.32 GL 547 02/08/2012 Property Taxes (69.54) 5,474.78 GL 556 02/24/2012 Property Taxes (203.70) 5,271.08 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (246.07) 5,271.08 ** (5,603.00) Budgeted (10,874.08) Remaining -94 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 546 02/07/2012 Property Taxes (701.00) (4.06) (705.06) GL 548 02/09/2012 Property Taxes (3.45) (708.51) GL 549 02/10/2012 Property Taxes 3.45 (705.06) GL 552 02/17/2012 Property Taxes (8.20) (713.26) GL 557 02/27/2012 Property Taxes (56.66) (769.92) GL 602 02/29/2012 Property Taxes (3.73) (773.65) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (72.65) (773.65) ** (725.00) Budgeted 48.65 Remaining 107 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 424 02/01/2012 Property Taxes (486.36) (6.36) (492.72) GL 546 02/07/2012 Property Taxes (7.64) (500.36) GL 547 02/08/2012 Property Taxes (92.61) (592.97) GL 548 02/09/2012 Property Taxes (98.04) (691.01) GL 549 02/10/2012 Property Taxes (35.49) (726.50) GL 550 02/14/2012 Property Taxes (30.57) (757.07) GL 551 02/16/2012 Property Taxes (51.45) (808.52) GL 553 02/21/2012 Property Taxes (73.37) (881.89) GL 554 02/22/2012 Property Taxes (30.28) (912.17) GL 555 02/23/2012 Property Taxes (11.37) (923.54) GL 556 02/24/2012 Property Taxes (50.92) (974.46) GL 557 02/27/2012 Property Taxes (19.06) (993.52) GL 601 02/28/2012 Property Taxes (184.96) (1,178.48) GL 602 02/29/2012 Property Taxes (87.29) (1,265.77) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (779.41) (1,265.77) ** (7,500.00) Budgeted (6,234.23) Remaining 17 % Used Account: 122-42014-000-000 Fire Permits/Sprinkler . glpdatb2 rgonzale Trophy Club Entities Page 3 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 621 02/01/2012 Permits 2/1/12 (4,400.00) (400.00) (4,800.00) GL 625 02/15/2012 Permits 2/15/12 (800.00) (5,600.00) GL _______________ Account: 122-42014-000-000 Fire Permits/Sprinkler Totals: (1,200.00) (5,600.00) ** (2,000.00) Budgeted 3,600.00 Remaining 280 % Used Account: 122-43400-000-000 Fire Inspections 621 02/01/2012 Permits 2/1/12 (825.00) (75.00) (900.00) GL 625 02/15/2012 Permits 2/15/12 (150.00) (1,050.00) GL _______________ Account: 122-43400-000-000 Fire Inspections Totals: (225.00) (1,050.00) ** (500.00) Budgeted 550.00 Remaining 210 % 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 .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 621 02/01/2012 Permits 2/1/12 (6,375.00) (525.00) (6,900.00) GL 622 02/08/2012 Permits 2/8/12 (100.00) (7,000.00) GL 624 02/13/2012 Permits 2/13/12 (100.00) (7,100.00) GL 625 02/15/2012 Permits 2/15/12 (1,050.00) (8,150.00) GL 610 02/27/2012 TCWC Philanthropy Fire Grant (246.95) (8,396.95) GL . glpdatb2 rgonzale Trophy Club Entities Page 4 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/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-49900-000-000 Miscellaneous Income Totals: (2,021.95) (8,396.95) ** (5,000.00) Budgeted 3,396.95 Remaining 168 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,251,023.69) ** (1,311,934.00) Budgeted (60,910.31) Remaining 95 % Used . glpdatb2 rgonzale Trophy Club Entities Page 5 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 122,077.57 16,023.75 138,101.32 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 16,921.38 155,022.70 PR _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 32,945.13 155,022.70 ** 425,748.00 Budgeted 270,725.30 Remaining 36 % Used Account: 122-50010-045-000 Overtime 474 02/17/2012 PAYROLL 2/17/12 Overtime 16,972.33 2,850.32 19,822.65 PR _______________ Account: 122-50010-045-000 Overtime Totals: 2,850.32 19,822.65 ** 42,000.00 Budgeted 22,177.35 Remaining 47 % 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 474 02/17/2012 PAYROLL 2/17/12 Certification 2,063.80 494.70 2,558.50 PR _______________ Account: 122-50017-045-000 Certification Totals: 494.70 2,558.50 ** 4,073.00 Budgeted 1,514.50 Remaining 63 % Used Account: 122-50020-045-000 Retirement 400 02/03/2012 PAYROLL 2/3/12 Retirement 22,707.32 2,020.89 24,728.21 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 2,609.45 27,337.66 PR _______________ Account: 122-50020-045-000 Retirement Totals: 4,630.34 27,337.66 ** 68,264.00 Budgeted 40,926.34 Remaining 40 % Used . glpdatb2 rgonzale Trophy Club Entities Page 6 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 13,358.29 1,663.54 15,021.83 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 1,677.31 16,699.14 PR _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,340.85 16,699.14 ** 53,184.00 Budgeted 36,484.86 Remaining 31 % Used Account: 122-50027-045-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 1,167.38 145.25 1,312.63 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 146.72 1,459.35 PR _______________ Account: 122-50027-045-000 Dental Insurance Totals: 291.97 1,459.35 ** 3,288.00 Budgeted 1,828.65 Remaining 44 % Used Account: 122-50028-045-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 263.70 32.85 296.55 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 33.12 329.67 PR _______________ Account: 122-50028-045-000 Vision Insurance Totals: 65.97 329.67 ** 857.00 Budgeted 527.33 Remaining 38 % 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 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 9,584.33 900.67 10,485.00 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 1,163.00 11,648.00 PR _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,063.67 11,648.00 ** 30,231.00 Budgeted 18,583.00 Remaining 39 % Used Account: 122-50035-045-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 2,241.60 210.64 2,452.24 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 272.02 2,724.26 PR . glpdatb2 rgonzale Trophy Club Entities Page 7 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 482.66 2,724.26 ** 7,070.00 Budgeted 4,345.74 Remaining 39 % Used Account: 122-50040-045-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 354.08 109.16 463.24 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 94.47 557.71 PR _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 203.63 557.71 ** 1,476.00 Budgeted 918.29 Remaining 38 % Used Account: 122-50045-045-000 Workman's Compensation 8,309.50 .00 8,309.50 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 8,309.50 ** 8,793.00 Budgeted 483.50 Remaining 95 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 52.45 .00 52.45 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 52.45 ** 675.00 Budgeted 622.55 Remaining 8 % Used Account: 122-55080-045-000 Maintenance & Repairs 529 02/27/2012 Feb A/P Single Air test/Bauer Unit 984.21 244.00 1,228.21 AUGUST INDUSTRIES, INC 31265 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 244.00 1,228.21 ** 9,562.00 Budgeted 8,333.79 Remaining 13 % Used Account: 122-55090-045-000 Vehicle Maintenance 594 02/29/2012 Feb A/P Vehicle Maintenance 256.21 1,544.01 1,800.22 INDUSTRIAL POWER TRUCK & EQUIP 31292 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 1,544.01 1,800.22 ** 14,850.00 Budgeted 13,049.78 Remaining 12 % Used Account: 122-55095-045-000 Equipment Maintenance 477 02/16/2012 Feb A/P Equipment Maint 1,149.94 2,987.24 4,137.18 MUNICIPAL EMERGENCY SERVICES 31257 AP . glpdatb2 rgonzale Trophy Club Entities Page 8 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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 Totals: 2,987.24 4,137.18 ** 9,808.00 Budgeted 5,670.82 Remaining 42 % Used Account: 122-55100-045-000 Building Maintenance 436 02/09/2012 Feb A/P Invoices Quarterly pest control 2,635.03 140.00 2,775.03 GANN'S PEST CONTROL 31217 AP 604 02/10/2012 Firefighters Cable (120.00) 2,655.03 GL _______________ Account: 122-55100-045-000 Building Maintenance Totals: 20.00 2,655.03 ** 11,000.00 Budgeted 8,344.97 Remaining 24 % Used Account: 122-55110-045-000 Maintenance-Radios .00 .00 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 .00 ** 1,103.00 Budgeted 1,103.00 Remaining 0 % 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 594 02/29/2012 Feb A/P Feb PCard-Zieverink 20.95 1.33 22.28 BANK OF AMERICA 31281 AP _______________ Account: 122-60005-045-000 Telephone Totals: 1.33 22.28 ** 106.00 Budgeted 83.72 Remaining 21 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 825.71 192.46 1,018.17 VERIZON WIRELESS 31316 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 192.46 1,018.17 ** 4,411.00 Budgeted 3,392.83 Remaining 23 % Used Account: 122-60020-045-000 Electricity/Gas 529 02/27/2012 Feb A/P Electricity 1/17-2/15 3,888.96 748.08 4,637.04 HUDSON ENERGY 31272 AP . glpdatb2 rgonzale Trophy Club Entities Page 9 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 529 02/27/2012 Feb A/P Gas @ FD 1/20-2/20 3,888.96 265.99 4,903.03 ATMOS ENERGY 31264 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 1,014.07 4,903.03 ** 18,270.00 Budgeted 13,366.97 Remaining 27 % Used Account: 122-60025-045-000 Water 1,384.50 .00 1,384.50 _______________ Account: 122-60025-045-000 Water Totals: .00 1,384.50 ** 3,289.00 Budgeted 1,904.50 Remaining 42 % Used Account: 122-60030-045-000 Rent And/Or Usage 618 02/29/2012 FD Rent Transfer to M1 I&S 308,000.00 308,000.00 GL _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: 308,000.00 308,000.00 ** 308,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 12.35 .00 12.35 _______________ Account: 122-60035-045-000 Postage Totals: .00 12.35 ** 97.00 Budgeted 84.65 Remaining 13 % Used Account: 122-60055-045-000 Insurance 8,078.00 .00 8,078.00 _______________ Account: 122-60055-045-000 Insurance Totals: .00 8,078.00 ** 20,974.00 Budgeted 12,896.00 Remaining 39 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .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 6,130.34 .00 6,130.34 . glpdatb2 rgonzale Trophy Club Entities Page 10 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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-60070-045-000 Dues & Memberships Totals: .00 6,130.34 ** 8,560.00 Budgeted 2,429.66 Remaining 72 % Used Account: 122-60075-045-000 Meetings 594 02/29/2012 Feb A/P Chamber luncheon, N Sanders, 22.00 22.00 NORTHWEST METROPORT CHAMBER 31302 AP _______________ Account: 122-60075-045-000 Meetings Totals: 22.00 22.00 ** .00 Budgeted (22.00) Remaining 0 % Used Account: 122-60080-045-000 Schools & Training 1,112.47 .00 1,112.47 _______________ Account: 122-60080-045-000 Schools & Training Totals: .00 1,112.47 ** 6,946.00 Budgeted 5,833.53 Remaining 16 % 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 1,632.43 .00 1,632.43 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 1,632.43 ** 6,788.00 Budgeted 5,155.57 Remaining 24 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 1,918.00 Budgeted 1,918.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 11 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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-60125-045-000 Advertising Totals: .00 .00 ** 156.00 Budgeted 156.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 594 02/29/2012 Feb A/P Promotional items for Safety F 1,112.16 721.95 1,834.11 ARTCRAFT & FOREMOST INC 31280 AP _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 721.95 1,834.11 ** 4,162.00 Budgeted 2,327.89 Remaining 44 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 594 02/29/2012 Feb A/P Office supplies 361.00 24.58 385.58 OFFICE DEPOT, INC 31303 AP _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 24.58 385.58 ** 1,900.00 Budgeted 1,514.42 Remaining 20 % Used Account: 122-60195-045-000 Flags & Repair 477 02/16/2012 Feb A/P Flag repair 402.50 150.00 552.50 SYMONDS FLAGS & POLES 31260 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 150.00 552.50 ** 2,543.00 Budgeted 1,990.50 Remaining 22 % Used Account: 122-60245-045-000 Miscellaneous Expense 541.42 .00 541.42 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 541.42 ** 1,237.00 Budgeted 695.58 Remaining 44 % Used Account: 122-65005-045-000 Fuel & Lube 598 02/29/2012 Feb Gas Log 1,354.29 77.87 1,432.16 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 77.87 1,432.16 ** 17,414.00 Budgeted 15,981.84 Remaining 8 % Used Account: 122-65010-045-000 Uniforms 529 02/27/2012 Feb A/P Uniforms 406.50 651.10 1,057.60 RON MONTGOMERY & ASSOC INC 31276 AP . glpdatb2 rgonzale Trophy Club Entities Page 12 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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-65010-045-000 Uniforms Totals: 651.10 1,057.60 ** 4,357.00 Budgeted 3,299.40 Remaining 24 % 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 469.96 .00 469.96 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 469.96 ** 8,371.00 Budgeted 7,901.04 Remaining 6 % Used Account: 122-65085-045-000 Office Supplies 529 02/27/2012 Feb A/P Office Supplies 629.04 3.60 632.64 OFFICE DEPOT, INC 31275 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 3.60 632.64 ** 329.00 Budgeted (303.64) Remaining 192 % Used Account: 122-65095-045-000 Maintenance Supplies 811.74 .00 811.74 _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: .00 811.74 ** 2,785.00 Budgeted 1,973.26 Remaining 29 % Used Account: 122-65105-045-000 Printing 24.77 .00 24.77 . glpdatb2 rgonzale Trophy Club Entities Page 13 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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-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 529 02/27/2012 Feb A/P Lightbar for FD new pickup tru 11,389.78 1,870.74 13,260.52 WILDFIRE TRUCK & EQUIPMENT 31279 AP _______________ Account: 122-69035-045-000 Vehicles Totals: 1,870.74 13,260.52 ** 13,709.00 Budgeted 448.48 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 588 02/28/2012 Bond/CO Interest payments FIRE TRUCK SER 2007/AMEGY BK 4,351.65 4,351.65 GL _______________ Account: 122-69251-045-000 Engine 681 Payment Totals: 4,351.65 4,351.65 ** 73,203.00 Budgeted 68,851.35 Remaining 6 % Used Account: 122-69255-045-000 Airpacks .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 14 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/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-69255-045-000 Airpacks Totals: .00 .00 ** 13,865.00 Budgeted 13,865.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 632,583.43 ** 1,311,934.00 Budgeted 679,350.57 Remaining 48 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (618,440.26) .00 Budgeted 618,440.26 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 15 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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 424 02/01/2012 Property Taxes (85,134.43) (372.48) (85,506.91) GL 429 02/02/2012 Property Taxes (3,006.26) (88,513.17) GL 431 02/03/2012 Property Taxes (1,896.74) (90,409.91) GL 545 02/06/2012 Property Taxes (1,342.06) (91,751.97) GL 546 02/07/2012 Property Taxes (935.05) (92,687.02) GL 547 02/08/2012 Property Taxes (98.32) (92,785.34) GL 548 02/09/2012 Property Taxes (144.62) (92,929.96) GL 549 02/10/2012 Property Taxes (629.14) (93,559.10) GL 550 02/14/2012 Property Taxes (39.55) (93,598.65) GL 551 02/16/2012 Property Taxes (66.54) (93,665.19) GL 553 02/21/2012 Property Taxes (94.89) (93,760.08) GL 554 02/22/2012 Property Taxes (39.15) (93,799.23) GL 555 02/23/2012 Property Taxes (14.71) (93,813.94) GL 557 02/27/2012 Property Taxes (25.56) (93,839.50) GL 601 02/28/2012 Property Taxes (239.20) (94,078.70) GL 602 02/29/2012 Property Taxes (112.89) (94,191.59) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (9,057.16) (94,191.59) ** (97,495.00) Budgeted (3,303.41) Remaining 97 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 429 02/02/2012 Property Taxes 670.57 2.20 672.77 GL 546 02/07/2012 Property Taxes (.01) 672.76 GL 547 02/08/2012 Property Taxes (15.00) 657.76 GL 556 02/24/2012 Property Taxes (16.39) 641.37 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (29.20) 641.37 ** (451.00) Budgeted (1,092.37) Remaining ########## Account: 135-40015-000-000 Property Taxes/P & I 424 02/01/2012 Property Taxes 281.42 (.57) 280.85 GL 429 02/02/2012 Property Taxes (25.43) 255.42 GL 431 02/03/2012 Property Taxes (1.77) 253.65 GL 545 02/06/2012 Property Taxes (19.92) 233.73 GL 546 02/07/2012 Property Taxes (.70) 233.03 GL 547 02/08/2012 Property Taxes (16.18) 216.85 GL 547 02/08/2012 Property Taxes (18.23) 198.62 GL 548 02/09/2012 Property Taxes (8.87) 189.75 GL 549 02/10/2012 Property Taxes (3.21) 186.54 GL 550 02/14/2012 Property Taxes (2.77) 183.77 GL . glpdatb2 rgonzale Trophy Club Entities Page 16 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 551 02/16/2012 Property Taxes 281.42 (4.66) 179.11 GL 553 02/21/2012 Property Taxes (6.65) 172.46 GL 554 02/22/2012 Property Taxes (2.74) 169.72 GL 555 02/23/2012 Property Taxes (1.03) 168.69 GL 556 02/24/2012 Property Taxes (4.10) 164.59 GL 557 02/27/2012 Property Taxes (1.72) 162.87 GL 557 02/27/2012 Property Taxes (.35) 162.52 GL 601 02/28/2012 Property Taxes (16.74) 145.78 GL 602 02/29/2012 Property Taxes (7.90) 137.88 GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (143.54) 137.88 ** (1,334.00) Budgeted (1,471.88) Remaining -10 % 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 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (389,773.66) (86,555.01) (476,328.67) UB _______________ Account: 135-47000-000-000 Water Totals: (86,555.01) (476,328.67) ** (1,990,800.00) Budgeted (1,514,471.33) Remaining 24 % Used Account: 135-47005-000-000 Sewer 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (289,335.76) (72,355.82) (361,691.58) UB _______________ Account: 135-47005-000-000 Sewer Totals: (72,355.82) (361,691.58) ** (1,325,000.00) Budgeted (963,308.42) Remaining 27 % Used Account: 135-47010-000-000 Commercial Water 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (205,154.28) (32,513.98) (237,668.26) UB _______________ Account: 135-47010-000-000 Commercial Water Totals: (32,513.98) (237,668.26) ** (825,000.00) Budgeted (587,331.74) Remaining 29 % Used Account: 135-47015-000-000 Commercial Sewer . glpdatb2 rgonzale Trophy Club Entities Page 17 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (89,361.94) (20,476.55) (109,838.49) UB _______________ Account: 135-47015-000-000 Commercial Sewer Totals: (20,476.55) (109,838.49) ** (360,000.00) Budgeted (250,161.51) Remaining 31 % Used Account: 135-47020-000-000 Standby 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (251.00) (60.00) (311.00) UB _______________ Account: 135-47020-000-000 Standby Totals: (60.00) (311.00) ** (775.00) Budgeted (464.00) Remaining 40 % Used Account: 135-47025-000-000 Penalties 503 02/20/2012 UB 02/20/2012 Adjustments UB 20120220-20120220 User: (20,868.97) 85.01 (20,783.96) UB 510 02/21/2012 UB 02/21/2012 Penalties UB 20120221-20120221 User: (2,901.50) (23,685.46) UB 535 02/27/2012 UB 02/27/2012 Adjustments UB 20120227-20120227 User: 35.41 (23,650.05) UB 564 02/29/2012 UB 02/29/2012 Adjustments UB 20120229-20120229 User: 43.95 (23,606.10) UB 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (104.92) (23,711.02) UB _______________ Account: 135-47025-000-000 Penalties Totals: (2,842.05) (23,711.02) ** (50,500.00) Budgeted (26,788.98) Remaining 47 % Used Account: 135-47030-000-000 Service Charges 432 02/08/2012 UB 02/08/2012 Adjustments UB 20120208-20120208 User: (5,986.38) (675.00) (6,661.38) UB 527 02/23/2012 UB 2/23/12 ADJUSTMENTS UB 20120223-20120223 User: (25.00) (6,686.38) UB 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (3.00) (6,689.38) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (703.00) (6,689.38) ** (17,500.00) Budgeted (10,810.62) Remaining 38 % Used Account: 135-47035-000-000 Plumbing Inspections 622 02/08/2012 Permits 2/8/12 (750.00) (50.00) (800.00) GL 624 02/13/2012 Permits 2/13/12 (50.00) (850.00) GL _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (850.00) ** (1,200.00) Budgeted (350.00) Remaining 71 % Used Account: 135-47045-000-000 Sewer Inspections 622 02/08/2012 Permits 2/8/12 (2,250.00) (150.00) (2,400.00) GL . glpdatb2 rgonzale Trophy Club Entities Page 18 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 624 02/13/2012 Permits 2/13/12 (2,250.00) (150.00) (2,550.00) GL _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (2,550.00) ** (4,500.00) Budgeted (1,950.00) Remaining 57 % 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 535 02/27/2012 UB 02/27/2012 Adjustments UB 20120227-20120227 User: (15,222.56) (300.00) (15,522.56) UB 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (539.54) (16,062.10) UB _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: (839.54) (16,062.10) ** (41,595.00) Budgeted (25,532.90) Remaining 39 % Used Account: 135-47405-000-000 Out of District Sewer 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (3,579.80) (53,282.71) (56,862.51) UB _______________ Account: 135-47405-000-000 Out of District Sewer Totals: (53,282.71) (56,862.51) ** (11,807.00) Budgeted 45,055.51 Remaining 482 % 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 . glpdatb2 rgonzale Trophy Club Entities Page 19 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (126,350.88) (23,973.64) (150,324.52) UB _______________ Account: 135-47600-000-000 PID #1 Water Totals: (23,973.64) (150,324.52) ** (425,000.00) Budgeted (274,675.48) Remaining 35 % Used Account: 135-47605-000-000 PID #1 Sewer 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (69,443.11) (16,483.76) (85,926.87) UB _______________ Account: 135-47605-000-000 PID #1 Sewer Totals: (16,483.76) (85,926.87) ** (185,000.00) Budgeted (99,073.13) Remaining 46 % Used Account: 135-48005-000-000 Utility Fees 621 02/01/2012 Permits 2/1/12 (265,280.00) (9,200.00) (274,480.00) GL 623 02/09/2012 Permits 2/9/12 (9,200.00) (283,680.00) GL 625 02/15/2012 Permits 2/15/12 (6,900.00) (290,580.00) GL 626 02/20/2012 Permits 2/20/12 (2,300.00) (292,880.00) GL 628 02/22/2012 Permits 2/22/12 (4,600.00) (297,480.00) GL 629 02/23/2012 Permits 2/23/12 (4,600.00) (302,080.00) GL 630 02/28/2012 Permits 2/28/12 (6,900.00) (308,980.00) GL 631 02/29/2012 Permits 2/29/12 (6,900.00) (315,880.00) GL _______________ Account: 135-48005-000-000 Utility Fees Totals: (50,600.00) (315,880.00) ** (338,880.00) Budgeted (23,000.00) Remaining 93 % Used Account: 135-49005-000-000 Loan Proceeds (1,100,000.00) .00 (1,100,000.00) _______________ Account: 135-49005-000-000 Loan Proceeds Totals: .00 (1,100,000.00) ** .00 Budgeted 1,100,000.00 Remaining 0 % Used Account: 135-49010-000-000 Interest Income 616 02/29/2012 Feb Bank Interest (1,438.96) (356.18) (1,795.14) GL 616 02/29/2012 Feb Bank Interest (6.00) (1,801.14) GL 633 02/29/2012 Feb Bank Interest (74.51) (1,875.65) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (436.69) (1,875.65) ** (4,500.00) Budgeted (2,624.35) Remaining 42 % Used Account: 135-49016-000-000 Cell Tower Revenue . glpdatb2 rgonzale Trophy Club Entities Page 20 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 606 02/10/2012 AT&T Cell Tower/Feb (3,388.00) (847.00) (4,235.00) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (847.00) (4,235.00) ** (10,164.00) Budgeted (5,929.00) Remaining 42 % Used Account: 135-49018-000-000 Building Rent Income 609 02/27/2012 Town Maint Barn Rent/Feb (2,333.32) (583.33) (2,916.65) GL _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,916.65) ** (7,000.00) Budgeted (4,083.35) Remaining 42 % Used Account: 135-49030-000-000 Vending Revenue (32.50) .00 (32.50) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (32.50) ** (600.00) Budgeted (567.50) Remaining 5 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (265,707.00) Budgeted (265,707.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (26,911.00) Budgeted (26,911.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 621 02/01/2012 Permits 2/1/12 (43,020.07) (1,168.00) (44,188.07) GL 622 02/08/2012 Permits 2/8/12 (292.00) (44,480.07) GL 623 02/09/2012 Permits 2/9/12 (1,168.00) (45,648.07) GL 624 02/13/2012 Permits 2/13/12 (292.00) (45,940.07) GL 625 02/15/2012 Permits 2/15/12 (876.00) (46,816.07) GL 626 02/20/2012 Permits 2/20/12 (292.00) (47,108.07) GL 628 02/22/2012 Permits 2/22/12 (876.00) (47,984.07) GL 629 02/23/2012 Permits 2/23/12 (584.00) (48,568.07) GL . glpdatb2 rgonzale Trophy Club Entities Page 21 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 630 02/28/2012 Permits 2/28/12 (43,020.07) (876.00) (49,444.07) GL 594 02/29/2012 Feb A/P Reimb impact and oversize mete 1,082.27 (48,361.80) HYDRA HOTELS LLC DBA HAMPTON 31291 AP 631 02/29/2012 Permits 2/29/12 (876.00) (49,237.80) GL _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (6,217.73) (49,237.80) ** (64,000.00) Budgeted (14,762.20) Remaining 77 % Used Account: 135-49900-000-000 Miscellaneous Income (2,703.11) .00 (2,703.11) _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: .00 (2,703.11) ** (10,000.00) Budgeted (7,296.89) Remaining 27 % 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,111,470.38) ** (6,129,319.00) Budgeted (3,017,848.62) Remaining 51 % Used . glpdatb2 rgonzale Trophy Club Entities Page 22 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 47,180.64 6,337.33 53,517.97 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 6,290.73 59,808.70 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 12,628.06 59,808.70 ** 199,759.00 Budgeted 139,950.30 Remaining 30 % Used Account: 135-50010-010-000 Overtime 400 02/03/2012 PAYROLL 2/3/12 Overtime 4,874.94 237.56 5,112.50 PR 474 02/17/2012 PAYROLL 2/17/12 Overtime 820.90 5,933.40 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,058.46 5,933.40 ** 13,250.00 Budgeted 7,316.60 Remaining 45 % 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 474 02/17/2012 PAYROLL 2/17/12 Certification 600.00 150.00 750.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 150.00 750.00 ** 1,800.00 Budgeted 1,050.00 Remaining 42 % Used Account: 135-50020-010-000 Retirement 400 02/03/2012 PAYROLL 2/3/12 Retirement 8,254.64 908.65 9,163.29 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 1,003.56 10,166.85 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,912.21 10,166.85 ** 25,508.00 Budgeted 15,341.15 Remaining 40 % Used Account: 135-50026-010-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 7,535.76 941.97 8,477.73 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 941.97 9,419.70 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,883.94 9,419.70 ** 22,607.00 Budgeted 13,187.30 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club Entities Page 23 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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-010-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 537.12 67.14 604.26 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 67.14 671.40 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 134.28 671.40 ** 2,169.00 Budgeted 1,497.60 Remaining 31 % Used Account: 135-50028-010-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 127.04 15.88 142.92 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 15.88 158.80 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 31.76 158.80 ** 576.00 Budgeted 417.20 Remaining 28 % 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 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 3,422.97 381.00 3,803.97 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 423.61 4,227.58 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 804.61 4,227.58 ** 13,481.00 Budgeted 9,253.42 Remaining 31 % Used Account: 135-50035-010-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 800.53 89.11 889.64 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 99.06 988.70 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 188.17 988.70 ** 3,153.00 Budgeted 2,164.30 Remaining 31 % Used Account: 135-50040-010-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 116.33 52.60 168.93 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 55.42 224.35 PR . glpdatb2 rgonzale Trophy Club Entities Page 24 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 108.02 224.35 ** 945.00 Budgeted 720.65 Remaining 24 % 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 47.59 .00 47.59 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 47.59 ** 350.00 Budgeted 302.41 Remaining 14 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55070-010-000 Independent Labor .00 .00 _______________ Account: 135-55070-010-000 Independent Labor Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 9,264.71 .00 9,264.71 . glpdatb2 rgonzale Trophy Club Entities Page 25 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: .00 9,264.71 ** 29,500.00 Budgeted 20,235.29 Remaining 31 % Used Account: 135-55090-010-000 Vehicle Maintenance 1,889.77 .00 1,889.77 _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 1,889.77 ** 3,380.00 Budgeted 1,490.23 Remaining 56 % 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 450.00 .00 450.00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 450.00 ** 2,900.00 Budgeted 2,450.00 Remaining 16 % Used Account: 135-55135-010-000 Lab Analysis 740.00 .00 740.00 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 740.00 ** 4,500.00 Budgeted 3,760.00 Remaining 16 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 643.48 185.18 828.66 VERIZON WIRELESS 31316 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 185.18 828.66 ** 1,599.00 Budgeted 770.34 Remaining 52 % Used Account: 135-60020-010-000 Electricity 477 02/16/2012 Feb A/P Electricity 1/5-2/2 20,535.87 233.52 20,769.39 TRI COUNTY ELECTRIC 31262 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 179.09 20,948.48 HUDSON ENERGY 31272 AP . glpdatb2 rgonzale Trophy Club Entities Page 26 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 529 02/27/2012 Feb A/P Electricity 12/14-2/15 20,535.87 234.93 21,183.41 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 436.91 21,620.32 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 693.23 22,313.55 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 54.64 22,368.19 HUDSON ENERGY 31272 AP _______________ Account: 135-60020-010-000 Electricity Totals: 1,832.32 22,368.19 ** 162,000.00 Budgeted 139,631.81 Remaining 14 % 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 .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used 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 761.00 .00 761.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 761.00 ** 2,800.00 Budgeted 2,039.00 Remaining 27 % Used . glpdatb2 rgonzale Trophy Club Entities Page 27 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 400 02/03/2012 PAYROLL 2/3/12 Travel & per diem 576.68 24.43 601.11 PR 474 02/17/2012 PAYROLL 2/17/12 Travel & per diem 76.04 677.15 PR _______________ Account: 135-60100-010-000 Travel & per diem Totals: 100.47 677.15 ** 3,200.00 Budgeted 2,522.85 Remaining 21 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60135-010-000 Annual Permit Fee 7,965.75 .00 7,965.75 _______________ Account: 135-60135-010-000 Annual Permit Fee Totals: .00 7,965.75 ** 6,600.00 Budgeted (1,365.75) Remaining 121 % Used Account: 135-60150-010-000 Bulk Water 594 02/29/2012 Feb A/P January Bulk Water 368,810.76 93,641.40 462,452.16 CITY OF FORT WORTH 31282 AP _______________ Account: 135-60150-010-000 Bulk Water Totals: 93,641.40 462,452.16 ** 1,720,000.00 Budgeted 1,257,547.84 Remaining 27 % 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 . glpdatb2 rgonzale Trophy Club Entities Page 28 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 .00 ** 4,200.00 Budgeted 4,200.00 Remaining 0 % 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 598 02/29/2012 Feb Gas Log 4,655.01 300.48 4,955.49 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 300.48 4,955.49 ** 15,216.00 Budgeted 10,260.51 Remaining 33 % 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 . glpdatb2 rgonzale Trophy Club Entities Page 29 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-010-000 Small Tools Totals: .00 68.00 ** 2,500.00 Budgeted 2,432.00 Remaining 3 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % 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 _______________ 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 594 02/29/2012 Feb A/P Feb Purchases 10,150.08 15.99 10,166.07 COSTCO WHOLESALE 31283 AP 594 02/29/2012 Feb A/P Feb Purchases 56.50 10,222.57 COSTCO WHOLESALE 31283 AP _______________ Account: 135-65095-010-000 Maintenance Supplies Totals: 72.49 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 . glpdatb2 rgonzale Trophy Club Entities Page 30 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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-65105-010-000 Printing Totals: .00 58.50 ** 150.00 Budgeted 91.50 Remaining 39 % Used Account: 135-69005-010-000 Capital Expenses 529 02/27/2012 Feb A/P Ground Storage Expansion Note/ 837,607.19 3,818.95 841,426.14 FIRST FINANCIAL BANK 31270 AP 599 02/27/2012 Retainage/Phoenix App 5 3,707.00 845,133.14 GL 594 02/29/2012 Feb A/P Ground Storage Expansion App 5 70,433.00 915,566.14 PHOENIX FABRICATORS & ERECTORS 31304 AP _______________ Account: 135-69005-010-000 Capital Expenses Totals: 77,958.95 915,566.14 ** 888,432.00 Budgeted (27,134.14) Remaining 103 % Used Account: 135-69035-010-000 Vehicles 436 02/09/2012 Feb A/P Invoices 2012 Ford F250 VIN 1FT7W2A66CE 375.00 29,838.69 30,213.69 PHILPOTT MOTORS, LTD 31231 AP 529 02/27/2012 Feb A/P Lights/Adrian's truck 1,219.50 31,433.19 WILDFIRE TRUCK & EQUIPMENT 31279 AP 636 02/27/2012 Recode Wildfire inv/Ford F150 (1,219.50) 30,213.69 GL _______________ Account: 135-69035-010-000 Vehicles Totals: 29,838.69 30,213.69 ** 27,000.00 Budgeted (3,213.69) Remaining 112 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-69280-010-000 Capital Repairs .00 .00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** 24,000.00 Budgeted 24,000.00 Remaining 0 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 ** 124,771.00 Budgeted 23,954.46 Remaining 81 % Used . glpdatb2 rgonzale Trophy Club Entities Page 31 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/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-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 .00 .00 _______________ Account: 135-69305-010-000 Capital Leases Totals: .00 .00 ** 11,490.00 Budgeted 11,490.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,736,384.43 ** 3,501,238.00 Budgeted 1,764,853.57 Remaining 50 % Used . glpdatb2 rgonzale Trophy Club Entities Page 32 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 63,796.03 7,058.51 70,854.54 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 7,058.51 77,913.05 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,117.02 77,913.05 ** 182,147.00 Budgeted 104,233.95 Remaining 43 % Used Account: 135-50010-020-000 Overtime 400 02/03/2012 PAYROLL 2/3/12 Overtime 3,963.07 560.17 4,523.24 PR 474 02/17/2012 PAYROLL 2/17/12 Overtime 457.68 4,980.92 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,017.85 4,980.92 ** 10,166.00 Budgeted 5,185.08 Remaining 49 % 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 474 02/17/2012 PAYROLL 2/17/12 Certification 575.00 125.00 700.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 125.00 700.00 ** 2,400.00 Budgeted 1,700.00 Remaining 29 % Used Account: 135-50020-020-000 Retirement 400 02/03/2012 PAYROLL 2/3/12 Retirement 10,697.03 1,052.90 11,749.93 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 1,056.02 12,805.95 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,108.92 12,805.95 ** 27,816.00 Budgeted 15,010.05 Remaining 46 % Used Account: 135-50026-020-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 8,512.38 1,072.69 9,585.07 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 1,072.69 10,657.76 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,145.38 10,657.76 ** 30,805.00 Budgeted 20,147.24 Remaining 35 % Used . glpdatb2 rgonzale Trophy Club Entities Page 33 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-020-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 653.62 82.68 736.30 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 82.68 818.98 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 165.36 818.98 ** 1,981.00 Budgeted 1,162.02 Remaining 41 % Used Account: 135-50028-020-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 162.76 20.60 183.36 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 20.60 203.96 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 41.20 203.96 ** 552.00 Budgeted 348.04 Remaining 37 % 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 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 4,282.85 424.88 4,707.73 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 426.29 5,134.02 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 851.17 5,134.02 ** 8,597.00 Budgeted 3,462.98 Remaining 60 % Used Account: 135-50035-020-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 1,001.60 99.38 1,100.98 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 99.70 1,200.68 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 199.08 1,200.68 ** 2,011.00 Budgeted 810.32 Remaining 60 % Used Account: 135-50040-020-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 147.82 60.94 208.76 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 58.90 267.66 PR . glpdatb2 rgonzale Trophy Club Entities Page 34 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 119.84 267.66 ** 567.00 Budgeted 299.34 Remaining 47 % 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 20.00 .00 20.00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 20.00 ** 350.00 Budgeted 330.00 Remaining 6 % Used Account: 135-55070-020-000 Independent Labor 1,305.67 .00 1,305.67 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 1,305.67 ** 750.00 Budgeted (555.67) Remaining 174 % Used Account: 135-55080-020-000 Maintenance & Repairs 15,278.10 .00 15,278.10 _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: .00 15,278.10 ** 17,750.00 Budgeted 2,471.90 Remaining 86 % Used Account: 135-55090-020-000 Vehicle Maintenance 529 02/27/2012 Feb A/P Battery for Camera Van 194.95 194.95 INTERSTATE ALL BATTERY CENTER 31273 AP . glpdatb2 rgonzale Trophy Club Entities Page 35 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 194.95 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 134.00 .00 134.00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 134.00 ** 2,950.00 Budgeted 2,816.00 Remaining 5 % Used Account: 135-55125-020-000 Dumpster Services 9,675.00 .00 9,675.00 _______________ Account: 135-55125-020-000 Dumpster Services Totals: .00 9,675.00 ** 35,000.00 Budgeted 25,325.00 Remaining 28 % Used Account: 135-55135-020-000 Lab Analysis 436 02/09/2012 Feb A/P Invoices Wet Chemical Analysis 3,849.82 590.75 4,440.57 TALEM, INC 31246 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 590.75 4,440.57 ** 22,760.00 Budgeted 18,319.43 Remaining 20 % 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 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 888.23 236.55 1,124.78 VERIZON WIRELESS 31316 AP . glpdatb2 rgonzale Trophy Club Entities Page 36 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 236.55 1,124.78 ** 3,000.00 Budgeted 1,875.22 Remaining 37 % Used Account: 135-60020-020-000 Electricity 23,307.74 .00 23,307.74 _______________ Account: 135-60020-020-000 Electricity Totals: .00 23,307.74 ** 205,000.00 Budgeted 181,692.26 Remaining 11 % Used Account: 135-60025-020-000 Water 1,137.73 .00 1,137.73 _______________ Account: 135-60025-020-000 Water Totals: .00 1,137.73 ** 1,900.00 Budgeted 762.27 Remaining 60 % Used Account: 135-60035-020-000 Postage .00 .00 _______________ Account: 135-60035-020-000 Postage Totals: .00 .00 ** 120.00 Budgeted 120.00 Remaining 0 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 438.17 .00 438.17 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 438.17 ** 500.00 Budgeted 61.83 Remaining 88 % Used Account: 135-60080-020-000 Schools & Training .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 .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 37 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 400 02/03/2012 PAYROLL 2/3/12 Travel & per diem 606.06 69.93 675.99 PR 474 02/17/2012 PAYROLL 2/17/12 Travel & per diem 69.93 745.92 PR _______________ Account: 135-60100-020-000 Travel & per diem Totals: 139.86 745.92 ** 1,750.00 Budgeted 1,004.08 Remaining 43 % Used Account: 135-60105-020-000 Rent/Lease Equipment 901.30 .00 901.30 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 901.30 ** 200.00 Budgeted (701.30) Remaining 451 % Used Account: 135-60125-020-000 Advertising 987.36 .00 987.36 _______________ 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 . glpdatb2 rgonzale Trophy Club Entities Page 38 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 525.00 Budgeted 525.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 598 02/29/2012 Feb Gas Log 1,217.19 83.54 1,300.73 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 83.54 1,300.73 ** 6,875.00 Budgeted 5,574.27 Remaining 19 % Used Account: 135-65010-020-000 Uniforms 916.93 .00 916.93 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 916.93 ** 3,140.00 Budgeted 2,223.07 Remaining 29 % Used Account: 135-65030-020-000 Chemicals 2,557.57 .00 2,557.57 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 2,557.57 ** 13,180.00 Budgeted 10,622.43 Remaining 19 % 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 2,699.84 .00 2,699.84 . glpdatb2 rgonzale Trophy Club Entities Page 39 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-65045-020-000 Lab Supplies Totals: .00 2,699.84 ** 19,160.00 Budgeted 16,460.16 Remaining 14 % 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 594 02/29/2012 Feb A/P Feb Purchases 920.54 32.78 953.32 COSTCO WHOLESALE 31283 AP _______________ Account: 135-65095-020-000 Maintenance Supplies Totals: 32.78 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 529 02/27/2012 Feb A/P Electrical for new meters at W 34,800.26 6,855.00 41,655.26 DHS AUTOMATION, INC 31268 AP 529 02/27/2012 Feb A/P Coax & fittings for new meters 717.80 42,373.06 DHS AUTOMATION, INC 31268 AP 636 02/27/2012 Recode Wildfire inv/Ford F150 1,219.50 43,592.56 GL _______________ Account: 135-69005-020-000 Capital Expenses Totals: 8,792.30 43,592.56 ** 161,189.00 Budgeted 117,596.44 Remaining 27 % Used Account: 135-69280-020-000 Capital Repairs . glpdatb2 rgonzale Trophy Club Entities Page 40 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 56,000.00 Budgeted 56,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 240,666.09 ** 856,009.00 Budgeted 615,342.91 Remaining 28 % Used . glpdatb2 rgonzale Trophy Club Entities Page 41 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/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 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 41,557.64 5,541.08 47,098.72 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 5,541.08 52,639.80 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,082.16 52,639.80 ** 145,481.00 Budgeted 92,841.20 Remaining 36 % Used Account: 135-50010-021-000 Overtime 400 02/03/2012 PAYROLL 2/3/12 Overtime 2,874.96 532.46 3,407.42 PR 474 02/17/2012 PAYROLL 2/17/12 Overtime 13.77 3,421.19 PR _______________ Account: 135-50010-021-000 Overtime Totals: 546.23 3,421.19 ** 7,297.00 Budgeted 3,875.81 Remaining 47 % 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 474 02/17/2012 PAYROLL 2/17/12 Certification 500.00 125.00 625.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 125.00 625.00 ** 1,500.00 Budgeted 875.00 Remaining 42 % Used Account: 135-50020-021-000 Retirement 400 02/03/2012 PAYROLL 2/3/12 Retirement 7,244.93 839.36 8,084.29 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 784.97 8,869.26 PR _______________ Account: 135-50020-021-000 Retirement Totals: 1,624.33 8,869.26 ** 21,074.00 Budgeted 12,204.74 Remaining 42 % Used Account: 135-50026-021-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 6,810.72 851.34 7,662.06 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 851.34 8,513.40 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,702.68 8,513.40 ** 22,983.00 Budgeted 14,469.60 Remaining 37 % Used . glpdatb2 rgonzale Trophy Club Entities Page 42 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-021-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 469.52 58.69 528.21 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 58.69 586.90 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 117.38 586.90 ** 1,533.00 Budgeted 946.10 Remaining 38 % Used Account: 135-50028-021-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 118.88 14.86 133.74 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 14.86 148.60 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 29.72 148.60 ** 357.00 Budgeted 208.40 Remaining 42 % 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 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 2,953.87 347.09 3,300.96 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 322.65 3,623.61 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 669.74 3,623.61 ** 9,785.00 Budgeted 6,161.39 Remaining 37 % Used Account: 135-50035-021-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 690.83 81.17 772.00 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 75.46 847.46 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 156.63 847.46 ** 2,288.00 Budgeted 1,440.54 Remaining 37 % Used Account: 135-50040-021-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 94.43 48.60 143.03 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 37.07 180.10 PR . glpdatb2 rgonzale Trophy Club Entities Page 43 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: 85.67 180.10 ** 567.00 Budgeted 386.90 Remaining 32 % 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 19.97 .00 19.97 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 19.97 ** 250.00 Budgeted 230.03 Remaining 8 % 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 529 02/27/2012 Feb A/P Repairs WW Lift Pump #2 VFD, W 2,815.85 720.00 3,535.85 DHS AUTOMATION, INC 31268 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 720.00 3,535.85 ** 23,700.00 Budgeted 20,164.15 Remaining 15 % Used Account: 135-55090-021-000 Vehicle Maintenance 130.00 .00 130.00 . glpdatb2 rgonzale Trophy Club Entities Page 44 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 130.00 ** 1,943.00 Budgeted 1,813.00 Remaining 7 % 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 594 02/29/2012 Feb A/P Feb PCard-Zieverink 11.18 .74 11.92 BANK OF AMERICA 31281 AP _______________ Account: 135-60005-021-000 Telephone Totals: .74 11.92 ** 50.00 Budgeted 38.08 Remaining 24 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 1,340.35 204.24 1,544.59 VERIZON WIRELESS 31316 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 204.24 1,544.59 ** 2,796.00 Budgeted 1,251.41 Remaining 55 % Used Account: 135-60020-021-000 Electricity 477 02/16/2012 Feb A/P Electricity 1/5-2/2 2,241.65 119.50 2,361.15 TRI COUNTY ELECTRIC 31262 AP 477 02/16/2012 Feb A/P Electricity 1/5-2/2 27.58 2,388.73 TRI COUNTY ELECTRIC 31262 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 11.46 2,400.19 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 4.22 2,404.41 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 103.47 2,507.88 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 765.20 3,273.08 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 141.33 3,414.41 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 27.01 3,441.42 HUDSON ENERGY 31272 AP _______________ Account: 135-60020-021-000 Electricity Totals: 1,199.77 3,441.42 ** 23,625.00 Budgeted 20,183.58 Remaining 15 % Used Account: 135-60025-021-000 Water .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 45 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/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 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 400 02/03/2012 PAYROLL 2/3/12 Travel & per diem 335.24 51.62 386.86 PR _______________ Account: 135-60100-021-000 Travel & per diem Totals: 51.62 386.86 ** 1,500.00 Budgeted 1,113.14 Remaining 26 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 46 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/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 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 598 02/29/2012 Feb Gas Log 3,246.73 348.56 3,595.29 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 348.56 3,595.29 ** 11,700.00 Budgeted 8,104.71 Remaining 31 % Used Account: 135-65010-021-000 Uniforms 620.98 .00 620.98 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 620.98 ** 2,505.00 Budgeted 1,884.02 Remaining 25 % Used Account: 135-65030-021-000 Chemicals .00 .00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 .00 ** 12,500.00 Budgeted 12,500.00 Remaining 0 % Used Account: 135-65035-021-000 Small Tools .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 47 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-021-000 Small Tools Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-65040-021-000 Safety Equipment 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 594 02/29/2012 Feb A/P Feb Purchases 138.38 65.76 204.14 COSTCO WHOLESALE 31283 AP _______________ Account: 135-65095-021-000 Maintenance Supplies Totals: 65.76 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: ------------------------------------------------------------------------------------------------ 131,608.53 ** 439,837.00 Budgeted 308,228.47 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club Entities Page 48 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 2,300.00 700.00 3,000.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 700.00 3,000.00 ** 10,000.00 Budgeted 7,000.00 Remaining 30 % Used Account: 135-50030-026-000 Social Security Taxes 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 142.60 43.40 186.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 43.40 186.00 ** 620.00 Budgeted 434.00 Remaining 30 % Used Account: 135-50035-026-000 Medicare Taxes 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 33.35 10.15 43.50 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 10.15 43.50 ** 145.00 Budgeted 101.50 Remaining 30 % Used Account: 135-50040-026-000 Unemployment Taxes 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 18.40 5.60 24.00 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 5.60 24.00 ** 210.00 Budgeted 186.00 Remaining 11 % Used Account: 135-50045-026-000 Workman's Compensation 120.00 .00 120.00 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 120.00 ** 120.00 Budgeted .00 Remaining 100 % Used Account: 135-60035-026-000 Postage 26.11 .00 26.11 _______________ Account: 135-60035-026-000 Postage Totals: .00 26.11 ** .00 Budgeted (26.11) Remaining 0 % Used Account: 135-60066-026-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club Entities Page 49 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/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-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 594 02/29/2012 Feb A/P Chamber luncheon, N Sanders, 174.82 44.00 218.82 NORTHWEST METROPORT CHAMBER 31302 AP _______________ Account: 135-60075-026-000 Meetings Totals: 44.00 218.82 ** 1,278.00 Budgeted 1,059.18 Remaining 17 % 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 594 02/29/2012 Feb A/P Mileage reimbursement-AWBD 32.19 32.19 KEVIN CARR 31295 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 32.19 32.19 ** 6,199.00 Budgeted 6,166.81 Remaining 1 % Used Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 3,200.00 Budgeted 3,200.00 Remaining 0 % Used Account: 135-65085-026-000 Office Supplies 8.90 .00 8.90 . glpdatb2 rgonzale Trophy Club Entities Page 50 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65085-026-000 Office Supplies Totals: .00 8.90 ** 50.00 Budgeted 41.10 Remaining 18 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 5,219.52 ** 28,122.00 Budgeted 22,902.48 Remaining 19 % Used . glpdatb2 rgonzale Trophy Club Entities Page 51 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/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 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 53,397.49 8,700.96 62,098.45 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 8,647.73 70,746.18 PR 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Salaries & Wages 4,244.83 74,991.01 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Salaries & Wages 2,122.42 77,113.43 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Salaries & Wages 52,975.63 130,089.06 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Salaries & Wages 11,328.31 141,417.37 PR _______________ Account: 135-50005-027-000 Salaries & Wages Totals: 88,019.88 141,417.37 ** 236,831.00 Budgeted 95,413.63 Remaining 60 % Used Account: 135-50010-027-000 Overtime 400 02/03/2012 PAYROLL 2/3/12 Overtime 989.55 1.97 991.52 PR 474 02/17/2012 PAYROLL 2/17/12 Overtime 19.82 1,011.34 PR _______________ Account: 135-50010-027-000 Overtime Totals: 21.79 1,011.34 ** 1,000.00 Budgeted (11.34) Remaining 101 % Used Account: 135-50016-027-000 Longevity 542 02/29/2012 LONGEVITY - SCOTT 2/29/12 Longevity 1,845.00 1,860.00 3,705.00 PR _______________ Account: 135-50016-027-000 Longevity Totals: 1,860.00 3,705.00 ** 1,845.00 Budgeted (1,860.00) Remaining 201 % Used Account: 135-50020-027-000 Retirement 400 02/03/2012 PAYROLL 2/3/12 Retirement 8,315.19 1,202.76 9,517.95 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 1,197.83 10,715.78 PR 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Retirement 586.64 11,302.42 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Retirement 293.32 11,595.74 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Retirement 7,321.23 18,916.97 PR 542 02/29/2012 LONGEVITY - SCOTT 2/29/12 Retirement 257.05 19,174.02 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Retirement 1,565.57 20,739.59 PR _______________ Account: 135-50020-027-000 Retirement Totals: 12,424.40 20,739.59 ** 33,471.00 Budgeted 12,731.41 Remaining 62 % Used Account: 135-50026-027-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 5,197.64 803.95 6,001.59 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 768.55 6,770.14 PR . glpdatb2 rgonzale Trophy Club Entities Page 52 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Medical Insurance 5,197.64 205.35 6,975.49 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Medical Insurance 205.35 7,180.84 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Medical Insurance 205.35 7,386.19 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Medical Insurance 205.35 7,591.54 PR _______________ Account: 135-50026-027-000 Medical Insurance Totals: 2,393.90 7,591.54 ** 18,798.00 Budgeted 11,206.46 Remaining 40 % Used Account: 135-50027-027-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 389.84 61.71 451.55 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 59.50 511.05 PR 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Dental Insurance 14.21 525.26 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Dental Insurance 14.21 539.47 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Dental Insurance 14.21 553.68 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Dental Insurance 14.21 567.89 PR _______________ Account: 135-50027-027-000 Dental Insurance Totals: 178.05 567.89 ** 1,242.00 Budgeted 674.11 Remaining 46 % Used Account: 135-50028-027-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 98.57 15.48 114.05 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 14.84 128.89 PR 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Vision Insurance 3.38 132.27 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Vision Insurance 3.38 135.65 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Vision Insurance 3.38 139.03 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Vision Insurance 3.38 142.41 PR _______________ Account: 135-50028-027-000 Vision Insurance Totals: 43.84 142.41 ** 341.00 Budgeted 198.59 Remaining 42 % 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 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 3,328.03 510.22 3,838.25 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 509.35 4,347.60 PR . glpdatb2 rgonzale Trophy Club Entities Page 53 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Social Security Taxes 3,328.03 263.18 4,610.78 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Social Security Taxes 131.59 4,742.37 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Social Security Taxes 3,284.49 8,026.86 PR 542 02/29/2012 LONGEVITY - SCOTT 2/29/12 Social Security Taxes 115.32 8,142.18 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Social Security Taxes 702.35 8,844.53 PR _______________ Account: 135-50030-027-000 Social Security Taxes Totals: 5,516.50 8,844.53 ** 14,860.00 Budgeted 6,015.47 Remaining 60 % Used Account: 135-50035-027-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 816.24 119.29 935.53 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 119.12 1,054.65 PR 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Medicare Taxes 61.55 1,116.20 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Medicare Taxes 30.78 1,146.98 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Medicare Taxes 768.14 1,915.12 PR 542 02/29/2012 LONGEVITY - SCOTT 2/29/12 Medicare Taxes 26.97 1,942.09 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Medicare Taxes 164.26 2,106.35 PR _______________ Account: 135-50035-027-000 Medicare Taxes Totals: 1,290.11 2,106.35 ** 3,475.00 Budgeted 1,368.65 Remaining 61 % Used Account: 135-50040-027-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 135.99 39.75 175.74 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 32.28 208.02 PR _______________ Account: 135-50040-027-000 Unemployment Taxes Totals: 72.03 208.02 ** 756.00 Budgeted 547.98 Remaining 28 % 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 3,368.76 .00 3,368.76 _______________ Account: 135-50070-027-000 Employee Relations Totals: .00 3,368.76 ** 5,000.00 Budgeted 1,631.24 Remaining 67 % Used . glpdatb2 rgonzale Trophy Club Entities Page 54 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55070-027-000 Independent Labor 529 02/27/2012 Feb A/P Video Joint Session & MUD meet 138.75 41.25 180.00 MIGUEL CRUZ 31274 AP _______________ Account: 135-55070-027-000 Independent Labor Totals: 41.25 180.00 ** 840.00 Budgeted 660.00 Remaining 21 % 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 95,384.68 .00 95,384.68 _______________ Account: 135-55160-027-000 Professional Outside Services Totals: .00 95,384.68 ** 176,870.00 Budgeted 81,485.32 Remaining 54 % Used Account: 135-60005-027-000 Telephone 594 02/29/2012 Feb A/P Feb PCard-Zieverink 77.58 19.72 97.30 BANK OF AMERICA 31281 AP _______________ Account: 135-60005-027-000 Telephone Totals: 19.72 97.30 ** 300.00 Budgeted 202.70 Remaining 32 % Used Account: 135-60010-027-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 822.70 143.21 965.91 VERIZON WIRELESS 31316 AP _______________ Account: 135-60010-027-000 Communications/Pagers/Mobiles Totals: 143.21 965.91 ** 2,420.00 Budgeted 1,454.09 Remaining 40 % Used Account: 135-60035-027-000 Postage 413 02/01/2012 A/P Invoice Flat Rate Express Mail/Audit t 525.09 18.95 544.04 U.S. POSTAL SERVICE 31207 AP 594 02/29/2012 Feb A/P Overnight Docs to McCall Parkh 25.48 569.52 FEDERAL EXPRESS CORP 31287 AP _______________ Account: 135-60035-027-000 Postage Totals: 44.43 569.52 ** 1,000.00 Budgeted 430.48 Remaining 57 % Used Account: 135-60066-027-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club Entities Page 55 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 114.75 .00 114.75 _______________ Account: 135-60066-027-000 Publications/Books/Subscripts Totals: .00 114.75 ** 450.00 Budgeted 335.25 Remaining 26 % Used Account: 135-60070-027-000 Dues & Memberships 421.05 .00 421.05 _______________ Account: 135-60070-027-000 Dues & Memberships Totals: .00 421.05 ** 1,742.00 Budgeted 1,320.95 Remaining 24 % Used Account: 135-60075-027-000 Meetings .00 .00 _______________ Account: 135-60075-027-000 Meetings Totals: .00 .00 ** 312.00 Budgeted 312.00 Remaining 0 % Used Account: 135-60080-027-000 Schools & Training 445.00 .00 445.00 _______________ Account: 135-60080-027-000 Schools & Training Totals: .00 445.00 ** 2,555.00 Budgeted 2,110.00 Remaining 17 % Used Account: 135-60100-027-000 Travel & per diem 127.87 .00 127.87 _______________ Account: 135-60100-027-000 Travel & per diem Totals: .00 127.87 ** 3,851.00 Budgeted 3,723.13 Remaining 3 % 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 . glpdatb2 rgonzale Trophy Club Entities Page 56 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/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-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 529 02/27/2012 Feb A/P 4th of July donation 10,000.00 10,000.00 TOWN OF TROPHY CLUB 31278 AP _______________ Account: 135-60270-027-000 4th of July Celebration Totals: 10,000.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 529 02/27/2012 Feb A/P Office Supplies 542.41 45.14 587.55 OFFICE DEPOT, INC 31275 AP 594 02/29/2012 Feb A/P Office supplies 44.09 631.64 OFFICE DEPOT, INC 31303 AP 594 02/29/2012 Feb A/P Office supplies 69.64 701.28 OFFICE DEPOT, INC 31303 AP _______________ Account: 135-65085-027-000 Office Supplies Totals: 158.87 701.28 ** 2,450.00 Budgeted 1,748.72 Remaining 29 % Used Account: 135-65105-027-000 Printing 594 02/29/2012 Feb A/P Business Cards-J McKnight 395.00 68.00 463.00 FORMS ONE 31288 AP _______________ Account: 135-65105-027-000 Printing Totals: 68.00 463.00 ** 515.00 Budgeted 52.00 Remaining 90 % Used Department 27 Totals: ------------------------------------------------------------------------------------------------ 300,053.15 ** 532,866.00 Budgeted 232,812.85 Remaining 56 % Used . glpdatb2 rgonzale Trophy Club Entities Page 57 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 2/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 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 2/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 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 2/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 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 27,309.94 2,942.31 30,252.25 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 2,942.31 33,194.56 PR _______________ Account: 135-50005-029-000 Salaries & Wages Totals: 5,884.62 33,194.56 ** 94,404.00 Budgeted 61,209.44 Remaining 35 % 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 400 02/03/2012 PAYROLL 2/3/12 Retirement 4,505.94 406.63 4,912.57 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 406.63 5,319.20 PR _______________ Account: 135-50020-029-000 Retirement Totals: 813.26 5,319.20 ** 13,612.00 Budgeted 8,292.80 Remaining 39 % Used Account: 135-50026-029-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 3,310.38 205.35 3,515.73 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 205.35 3,721.08 PR _______________ Account: 135-50026-029-000 Medical Insurance Totals: 410.70 3,721.08 ** 11,060.00 Budgeted 7,338.92 Remaining 34 % Used Account: 135-50027-029-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 281.83 24.51 306.34 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 24.51 330.85 PR _______________ Account: 135-50027-029-000 Dental Insurance Totals: 49.02 330.85 ** 773.00 Budgeted 442.15 Remaining 43 % Used . glpdatb2 rgonzale Trophy Club Entities Page 60 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-029-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 47.11 3.38 50.49 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 3.38 53.87 PR _______________ Account: 135-50028-029-000 Vision Insurance Totals: 6.76 53.87 ** 207.00 Budgeted 153.13 Remaining 26 % 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 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 1,745.02 169.27 1,914.29 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 169.27 2,083.56 PR _______________ Account: 135-50030-029-000 Social Security Taxes Totals: 338.54 2,083.56 ** 5,386.00 Budgeted 3,302.44 Remaining 39 % Used Account: 135-50035-029-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 408.12 39.58 447.70 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 39.59 487.29 PR _______________ Account: 135-50035-029-000 Medicare Taxes Totals: 79.17 487.29 ** 1,260.00 Budgeted 772.71 Remaining 39 % Used Account: 135-50040-029-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 54.62 23.54 78.16 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 1.38 79.54 PR _______________ Account: 135-50040-029-000 Unemployment Taxes Totals: 24.92 79.54 ** 284.00 Budgeted 204.46 Remaining 28 % Used Account: 135-50045-029-000 Workman's Compensation 211.00 .00 211.00 _______________ Account: 135-50045-029-000 Workman's Compensation Totals: .00 211.00 ** 235.00 Budgeted 24.00 Remaining 90 % Used . glpdatb2 rgonzale Trophy Club Entities Page 61 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55160-029-000 Professional Outside Services 973.50 .00 973.50 _______________ Account: 135-55160-029-000 Professional Outside Services Totals: .00 973.50 ** 5,000.00 Budgeted 4,026.50 Remaining 19 % Used Account: 135-60005-029-000 Telephone 594 02/29/2012 Feb A/P Feb PCard-Zieverink 31.37 4.96 36.33 BANK OF AMERICA 31281 AP _______________ Account: 135-60005-029-000 Telephone Totals: 4.96 36.33 ** 103.00 Budgeted 66.67 Remaining 35 % Used Account: 135-60010-029-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 201.82 51.86 253.68 VERIZON WIRELESS 31316 AP _______________ Account: 135-60010-029-000 Communications/Pagers/Mobiles Totals: 51.86 253.68 ** 683.00 Budgeted 429.32 Remaining 37 % Used Account: 135-60035-029-000 Postage 96.99 .00 96.99 _______________ Account: 135-60035-029-000 Postage Totals: .00 96.99 ** 700.00 Budgeted 603.01 Remaining 14 % Used Account: 135-60040-029-000 Service Charges & Fees 32.50 .00 32.50 _______________ Account: 135-60040-029-000 Service Charges & Fees Totals: .00 32.50 ** 79.00 Budgeted 46.50 Remaining 41 % Used Account: 135-60066-029-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-029-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-029-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club Entities Page 62 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60070-029-000 Dues & Memberships Totals: .00 .00 ** 660.00 Budgeted 660.00 Remaining 0 % Used Account: 135-60075-029-000 Meetings 22.00 .00 22.00 _______________ Account: 135-60075-029-000 Meetings Totals: .00 22.00 ** 300.00 Budgeted 278.00 Remaining 7 % Used Account: 135-60080-029-000 Schools & Training .00 .00 _______________ Account: 135-60080-029-000 Schools & Training Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60100-029-000 Travel & per diem 400 02/03/2012 PAYROLL 2/3/12 Travel & per diem 15.04 12.77 27.81 PR _______________ Account: 135-60100-029-000 Travel & per diem Totals: 12.77 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 _______________ 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 594 02/29/2012 Feb A/P Office supplies 78.48 21.46 99.94 OFFICE DEPOT, INC 31303 AP . glpdatb2 rgonzale Trophy Club Entities Page 63 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65085-029-000 Office Supplies Totals: 21.46 99.94 ** 849.00 Budgeted 749.06 Remaining 12 % 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: ------------------------------------------------------------------------------------------------ 49,792.48 ** 144,910.00 Budgeted 95,117.52 Remaining 34 % Used . glpdatb2 rgonzale Trophy Club Entities Page 64 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 2/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 477 02/16/2012 Feb A/P Windows 7 license & drive shut 24,797.04 246.36 25,043.40 SHI GOVERNMENT SOLUTIONS,INC 31259 AP 529 02/27/2012 Feb A/P 1/2 Legistar program 3/1/12-2/ 4,459.68 29,503.08 GRANICUS, INC 31271 AP 594 02/29/2012 Feb A/P Feb PCard-Pastor 25.00 29,528.08 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Pastor 197.00 29,725.08 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Zieverink 54.99 29,780.07 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Zieverink 53.38 29,833.45 BANK OF AMERICA 31281 AP _______________ Account: 135-55030-033-000 Software & Support Totals: 5,036.41 29,833.45 ** 64,149.00 Budgeted 34,315.55 Remaining 47 % 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 594 02/29/2012 Feb A/P Feb PCard-Zieverink 3,008.63 393.65 3,402.28 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Zieverink 369.80 3,772.08 BANK OF AMERICA 31281 AP _______________ Account: 135-60005-033-000 Telephone Totals: 763.45 3,772.08 ** 6,540.00 Budgeted 2,767.92 Remaining 58 % Used Account: 135-60235-033-000 Security .00 .00 _______________ Account: 135-60235-033-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-65055-033-000 Hardware 477 02/16/2012 Feb A/P Head phones 60,135.96 78.40 60,214.36 SHI GOVERNMENT SOLUTIONS,INC 31259 AP 477 02/16/2012 Feb A/P Server UPS Harware, Printer su 189.26 60,403.62 SHI GOVERNMENT SOLUTIONS,INC 31259 AP 594 02/29/2012 Feb A/P Feb PCard-Pastor 45.21 60,448.83 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Pastor 7.74 60,456.57 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Pastor 111.27 60,567.84 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Zieverink 344.80 60,912.64 BANK OF AMERICA 31281 AP _______________ Account: 135-65055-033-000 Hardware Totals: 776.68 60,912.64 ** 83,238.00 Budgeted 22,325.36 Remaining 73 % Used . glpdatb2 rgonzale Trophy Club Entities Page 65 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 2/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 529 02/27/2012 Feb A/P Blank DVDs for meetings 107.12 42.90 150.02 SHI GOVERNMENT SOLUTIONS,INC 31277 AP 594 02/29/2012 Feb A/P Feb PCard-Zieverink 26.91 176.93 BANK OF AMERICA 31281 AP _______________ Account: 135-65085-033-000 Office Supplies Totals: 69.81 176.93 ** 371.00 Budgeted 194.07 Remaining 48 % Used Account: 135-65090-033-000 Printer Supplies & Maintenance 477 02/16/2012 Feb A/P Printer supplies 2,756.88 142.50 2,899.38 SHI GOVERNMENT SOLUTIONS,INC 31259 AP 594 02/29/2012 Feb A/P Toner Cartridges 99.00 2,998.38 SHI GOVERNMENT SOLUTIONS,INC 31307 AP _______________ Account: 135-65090-033-000 Printer Supplies & Maintenance Totals: 241.50 2,998.38 ** 5,732.00 Budgeted 2,733.62 Remaining 52 % Used Account: 135-69170-033-000 Copier Lease Installments 477 02/16/2012 Feb A/P Copier leases 770.55 256.85 1,027.40 KYOCERA MITA AMERICA, INC. 31256 AP _______________ Account: 135-69170-033-000 Copier Lease Installments Totals: 256.85 1,027.40 ** 3,450.00 Budgeted 2,422.60 Remaining 30 % 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: ------------------------------------------------------------------------------------------------ 99,095.88 ** 193,391.00 Budgeted 94,295.12 Remaining 51 % Used . glpdatb2 rgonzale Trophy Club Entities Page 66 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 2/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 491.68 .00 491.68 _______________ Account: 135-55100-037-000 Building Maint & Supplies Totals: .00 491.68 ** 29,577.00 Budgeted 29,085.32 Remaining 2 % Used Account: 135-55120-037-000 Cleaning Services 5,840.61 .00 5,840.61 _______________ Account: 135-55120-037-000 Cleaning Services Totals: .00 5,840.61 ** 25,000.00 Budgeted 19,159.39 Remaining 23 % Used Account: 135-60020-037-000 Electricity 529 02/27/2012 Feb A/P Electricity 12/14-1/17 2,693.25 1,341.96 4,035.21 DIRECT ENERGY BUSINESS SVCS 31269 AP _______________ Account: 135-60020-037-000 Electricity Totals: 1,341.96 4,035.21 ** 21,940.00 Budgeted 17,904.79 Remaining 18 % Used Account: 135-60025-037-000 Water 203.72 .00 203.72 _______________ Account: 135-60025-037-000 Water Totals: .00 203.72 ** 1,093.00 Budgeted 889.28 Remaining 19 % Used Account: 135-60030-037-000 Rent And/Or Usage 436 02/09/2012 Feb A/P Invoices Public Services Building rent 4,394.04 1,098.51 5,492.55 TOWN OF TROPHY CLUB 31248 AP _______________ Account: 135-60030-037-000 Rent And/Or Usage Totals: 1,098.51 5,492.55 ** 13,182.00 Budgeted 7,689.45 Remaining 42 % Used Account: 135-60055-037-000 Insurance . glpdatb2 rgonzale Trophy Club Entities Page 67 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 28,589.50 .00 28,589.50 _______________ Account: 135-60055-037-000 Insurance Totals: .00 28,589.50 ** 32,635.00 Budgeted 4,045.50 Remaining 88 % 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 594 02/29/2012 Feb A/P Feb Purchases 568.29 17.03 585.32 COSTCO WHOLESALE 31283 AP 594 02/29/2012 Feb A/P Feb Purchases 33.60 618.92 COSTCO WHOLESALE 31283 AP _______________ Account: 135-65095-037-000 Maintenance Supplies Totals: 50.63 618.92 ** 2,205.00 Budgeted 1,586.08 Remaining 28 % 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: ------------------------------------------------------------------------------------------------ 46,209.22 ** 129,132.00 Budgeted 82,922.78 Remaining 36 % Used . glpdatb2 rgonzale Trophy Club Entities Page 68 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 2/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 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 24,641.28 3,284.64 27,925.92 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 3,264.26 31,190.18 PR _______________ Account: 135-50005-038-000 Salaries & Wages Totals: 6,548.90 31,190.18 ** 84,946.00 Budgeted 53,755.82 Remaining 37 % Used Account: 135-50010-038-000 Overtime 400 02/03/2012 PAYROLL 2/3/12 Overtime 185.05 6.14 191.19 PR 474 02/17/2012 PAYROLL 2/17/12 Overtime 14.71 205.90 PR _______________ Account: 135-50010-038-000 Overtime Totals: 20.85 205.90 ** 2,000.00 Budgeted 1,794.10 Remaining 10 % 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 400 02/03/2012 PAYROLL 2/3/12 Retirement 3,757.19 454.78 4,211.97 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 453.17 4,665.14 PR _______________ Account: 135-50020-038-000 Retirement Totals: 907.95 4,665.14 ** 12,203.00 Budgeted 7,537.86 Remaining 38 % Used Account: 135-50026-038-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 3,697.06 462.17 4,159.23 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 461.89 4,621.12 PR _______________ Account: 135-50026-038-000 Medical Insurance Totals: 924.06 4,621.12 ** 12,321.00 Budgeted 7,699.88 Remaining 38 % Used Account: 135-50027-038-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 366.59 45.83 412.42 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 45.81 458.23 PR . glpdatb2 rgonzale Trophy Club Entities Page 69 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-038-000 Dental Insurance Totals: 91.64 458.23 ** 1,026.00 Budgeted 567.77 Remaining 45 % Used Account: 135-50028-038-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 86.50 10.82 97.32 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 10.81 108.13 PR _______________ Account: 135-50028-038-000 Vision Insurance Totals: 21.63 108.13 ** 260.00 Budgeted 151.87 Remaining 42 % 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 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 1,511.92 186.15 1,698.07 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 185.45 1,883.52 PR _______________ Account: 135-50030-038-000 Social Security Taxes Totals: 371.60 1,883.52 ** 5,404.00 Budgeted 3,520.48 Remaining 35 % Used Account: 135-50035-038-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 353.59 43.55 397.14 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 43.37 440.51 PR _______________ Account: 135-50035-038-000 Medicare Taxes Totals: 86.92 440.51 ** 1,264.00 Budgeted 823.49 Remaining 35 % Used Account: 135-50040-038-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 63.10 26.32 89.42 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 26.24 115.66 PR _______________ Account: 135-50040-038-000 Unemployment Taxes Totals: 52.56 115.66 ** 473.00 Budgeted 357.34 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club Entities Page 70 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-038-000 Workman's Compensation 235.00 .00 235.00 _______________ Account: 135-50045-038-000 Workman's Compensation Totals: .00 235.00 ** 211.00 Budgeted (24.00) Remaining 111 % Used Account: 135-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 594 02/29/2012 Feb A/P Feb Utility billing 3,967.31 1,141.47 5,108.78 CSG SYSTEMS, INC. 31284 AP _______________ Account: 135-55205-038-000 Utility Billing Contract Totals: 1,141.47 5,108.78 ** 11,000.00 Budgeted 5,891.22 Remaining 46 % Used Account: 135-60005-038-000 Telephone 594 02/29/2012 Feb A/P Feb PCard-Zieverink 31.21 6.84 38.05 BANK OF AMERICA 31281 AP _______________ Account: 135-60005-038-000 Telephone Totals: 6.84 38.05 ** 100.00 Budgeted 61.95 Remaining 38 % Used Account: 135-60010-038-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 142.04 36.88 178.92 VERIZON WIRELESS 31316 AP _______________ Account: 135-60010-038-000 Communications/Pagers/Mobiles Totals: 36.88 178.92 ** 472.00 Budgeted 293.08 Remaining 38 % Used Account: 135-60035-038-000 Postage 594 02/29/2012 Feb A/P Feb Utility billing 5,631.91 1,468.23 7,100.14 CSG SYSTEMS, INC. 31284 AP _______________ Account: 135-60035-038-000 Postage Totals: 1,468.23 7,100.14 ** 18,000.00 Budgeted 10,899.86 Remaining 39 % Used Account: 135-60040-038-000 Service Charges & Fees . glpdatb2 rgonzale Trophy Club Entities Page 71 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 580 02/02/2012 Credit Card/Online fees 11,151.96 24.04 11,176.00 GL 580 02/02/2012 Credit Card/Online fees 34.60 11,210.60 GL 580 02/02/2012 Credit Card/Online fees 35.00 11,245.60 GL 580 02/02/2012 Credit Card/Online fees 9.99 11,255.59 GL 580 02/02/2012 Credit Card/Online fees 1,852.08 13,107.67 GL _______________ Account: 135-60040-038-000 Service Charges & Fees Totals: 1,955.71 13,107.67 ** 18,000.00 Budgeted 4,892.33 Remaining 73 % 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 .00 .00 _______________ Account: 135-60080-038-000 Schools & Training Totals: .00 .00 ** 800.00 Budgeted 800.00 Remaining 0 % Used Account: 135-60100-038-000 Travel & per diem .00 .00 _______________ Account: 135-60100-038-000 Travel & per diem Totals: .00 .00 ** 605.00 Budgeted 605.00 Remaining 0 % Used Account: 135-60130-038-000 Reg Assessment Fee (5%) 25,071.20 .00 25,071.20 _______________ Account: 135-60130-038-000 Reg Assessment Fee (5%) Totals: .00 25,071.20 ** 22,500.00 Budgeted (2,571.20) Remaining 111 % Used Account: 135-60245-038-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-038-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 72 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 2/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-038-000 Office Supplies 529 02/27/2012 Feb A/P New credit card machine for fr 145.06 512.51 657.57 CENTURY BANKCARD SVCS TX LLC 31266 AP _______________ Account: 135-65085-038-000 Office Supplies Totals: 512.51 657.57 ** 700.00 Budgeted 42.43 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: ------------------------------------------------------------------------------------------------ 95,405.72 ** 197,430.00 Budgeted 102,024.28 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club Entities Page 73 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/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 594 02/29/2012 Feb A/P February legal 33,186.89 3,661.50 36,848.39 THE LISTON LAW FIRM, P.C. 31312 AP _______________ Account: 135-55045-039-000 Legal Totals: 3,661.50 36,848.39 ** 55,000.00 Budgeted 18,151.61 Remaining 67 % 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 8,533.65 .00 8,533.65 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 8,533.65 ** 20,000.00 Budgeted 11,466.35 Remaining 43 % Used Account: 135-55065-039-000 Tax Admin Fees 529 02/27/2012 Feb A/P Tax statements mailed 2,451.63 18.46 2,470.09 DENTON COUNTY TAX OFFICE 31267 AP _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: 18.46 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: ------------------------------------------------------------------------------------------------ 70,329.98 ** 98,829.00 Budgeted 28,499.02 Remaining 71 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (335,110.21) .00 Budgeted 335,110.21 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 74 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 2/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 424 02/01/2012 Property Taxes (480,850.76) (2,103.84) (482,954.60) GL 429 02/02/2012 Property Taxes (16,979.74) (499,934.34) GL 431 02/03/2012 Property Taxes (10,713.03) (510,647.37) GL 545 02/06/2012 Property Taxes (7,580.16) (518,227.53) GL 546 02/07/2012 Property Taxes (5,281.39) (523,508.92) GL 547 02/08/2012 Property Taxes (555.35) (524,064.27) GL 548 02/09/2012 Property Taxes (816.81) (524,881.08) GL 549 02/10/2012 Property Taxes (3,553.45) (528,434.53) GL 550 02/14/2012 Property Taxes (223.39) (528,657.92) GL 551 02/16/2012 Property Taxes (375.86) (529,033.78) GL 553 02/21/2012 Property Taxes (535.97) (529,569.75) GL 554 02/22/2012 Property Taxes (221.13) (529,790.88) GL 555 02/23/2012 Property Taxes (83.09) (529,873.97) GL 557 02/27/2012 Property Taxes (144.34) (530,018.31) GL 601 02/28/2012 Property Taxes (1,351.03) (531,369.34) GL 602 02/29/2012 Property Taxes (637.62) (532,006.96) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (51,156.20) (532,006.96) ** (546,716.00) Budgeted (14,709.04) Remaining 97 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 429 02/02/2012 Property Taxes 3,379.61 19.24 3,398.85 GL 546 02/07/2012 Property Taxes (.10) 3,398.75 GL 547 02/08/2012 Property Taxes (107.38) 3,291.37 GL 556 02/24/2012 Property Taxes (143.49) 3,147.88 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (231.73) 3,147.88 ** (3,947.00) Budgeted (7,094.88) Remaining -80 % Used Account: 533-40015-000-000 Property Taxes/P & I 424 02/01/2012 Property Taxes (586.68) (3.26) (589.94) GL 546 02/07/2012 Property Taxes (3.92) (593.86) GL 547 02/08/2012 Property Taxes (93.90) (687.76) GL 548 02/09/2012 Property Taxes (50.11) (737.87) GL 549 02/10/2012 Property Taxes (18.15) (756.02) GL 550 02/14/2012 Property Taxes (15.65) (771.67) GL 551 02/16/2012 Property Taxes (26.31) (797.98) GL 553 02/21/2012 Property Taxes (37.52) (835.50) GL 554 02/22/2012 Property Taxes (15.48) (850.98) GL 555 02/23/2012 Property Taxes (5.81) (856.79) GL . glpdatb2 rgonzale Trophy Club Entities Page 75 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 556 02/24/2012 Property Taxes (586.68) (35.88) (892.67) GL 557 02/27/2012 Property Taxes (7.79) (900.46) GL 601 02/28/2012 Property Taxes (94.57) (995.03) GL 602 02/29/2012 Property Taxes (44.64) (1,039.67) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (452.99) (1,039.67) ** (5,017.00) Budgeted (3,977.33) Remaining 21 % 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 616 02/29/2012 Feb Bank Interest (64.79) (43.55) (108.34) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (43.55) (108.34) ** (500.00) Budgeted (391.66) Remaining 22 % Used Account: 533-49015-000-000 Lease/Rental Income 618 02/29/2012 FD Rent Transfer to M1 I&S (308,000.00) (308,000.00) GL _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: (308,000.00) (308,000.00) ** (308,000.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (844,127.09) ** (870,300.00) Budgeted (26,172.91) Remaining 97 % Used . glpdatb2 rgonzale Trophy Club Entities Page 76 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 2/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 581 02/16/2012 Series 2010/Adm fees MUD1 Series 2010 500.00 500.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 500.00 500.00 ** 4,000.00 Budgeted 3,500.00 Remaining 13 % Used Account: 533-70025-051-000 Bond Interest Expense 588 02/28/2012 Bond/CO Interest payments M2 REF CIB SER 05 34,342.50 34,342.50 GL 588 02/28/2012 Bond/CO Interest payments M1 UT BONDS, 2010 40,366.25 74,708.75 GL 588 02/28/2012 Bond/CO Interest payments M2 UT BD 2002 59,333.75 134,042.50 GL 588 02/28/2012 Bond/CO Interest payments M2 SERIES 2003 16,607.50 150,650.00 GL _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: 150,650.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: ------------------------------------------------------------------------------------------------------ (692,977.09) .00 Budgeted 692,977.09 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (1,646,527.56) **** .00 Budgeted 1,646,527.56 Remaining 0 % Used ******* End of Report *********