The URL can be used to link to this page

Home My WebLink AboutJuly 2012 MUD Financials Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 7/31/2012 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 848,893 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 25,489 ACCOUNTS RECEIVABLE - PID EMER SERVICES 58 OTHER RECEIVABLES 45,239 TOTAL ASSETS 919,679$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 25,547$ ACCOUNTS PAYABLE 248,960 TOTAL LIABILITIES 274,507$ FUND BALANCE ASSIGNED FUND BALANCE 23,101 UNASSIGNED FUND BALANCE 622,071 TOTAL LIABILITIES AND FUND BALANCE 919,679$ July 31, 2012 10/12 Months (83% of Fiscal Year) . glbase_tbam rgonzale Trophy Club Entities Page 1 10:45 08/08/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 193,233.00- 193,233.00- 629.66- 191,727.86- 99.221 1,505.14- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,900.00- 468.11- 7,346.12- 149.921 2,446.12 122-40010-000-000 Property Taxes/MUD Fire 1,076,976.00- 1,076,976.00- 3,698.90- 1,069,232.13- 99.281 7,743.87- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,603.00- 783.13- 4,643.15 -82.869 10,246.15- 122-40015-000-000 Property Taxes/Assessments P&I 725.00- 3.55- 2,249.18- 310.232 1,524.18 122-40020-000-000 Property Taxes/Fire P&I 7,500.00- 7,500.00- 471.81- 4,282.56- 57.101 3,217.44- 122-40970-000-000 Insurance Settlements 9,739.43- 9,739.43 Subtotal: 1,277,709.00- 1,288,937.00- 6,055.16- 1,279,934.13- 99.302 9,002.87- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 2,400.00- 9,600.00- 160.000 3,600.00 Subtotal: 6,000.00- 2,400.00- 9,600.00- 160.000 3,600.00 122-43400-000-000 Fire Inspections 500.00- 450.00- 1,800.00- 360.000 1,300.00 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 122-43599-000-000 Misc Fire Revenue 1,124.00- Subtotal: 11,124.00- 10,500.00- 450.00- 11,800.00- 112.381 1,300.00 122-49025-000-000 Auction Sales 1,902.50- 1,902.50 122-49035-000-000 Prior Year Reserves 23,101.00- 122-49900-000-000 Miscellaneous Income 9,122.00- 3,950.00- 15,146.95- 166.049 6,024.95 122-49901-000-000 Records Management 5.00- 5.00 Subtotal: 23,101.00- 9,122.00- 3,950.00- 17,054.45- 186.960 7,932.45 Program number: 1,311,934.00- 1,314,559.00- 12,855.16- 1,318,388.58- 100.291 3,829.58 Department number: Fire Revenues 1,311,934.00- 1,314,559.00- 12,855.16- 1,318,388.58- 100.291 3,829.58 Revenues Subtotal ----------- 1,311,934.00- 1,314,559.00- 12,855.16- 1,318,388.58- 100.291 3,829.58 . glbase_tbam rgonzale Trophy Club Entities Page 2 10:45 08/08/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 425,748.00 425,748.00 38,183.31 349,341.62 82.054 76,406.38 122-50010-045-000 Overtime 42,000.00 42,000.00 25,295.31 60.227 16,704.69 122-50011-045-000 DPS Holiday Pay 12,133.00 13,773.00 13,773.02 100.000 .02- 122-50016-045-000 Longevity 3,647.00 3,647.00 3,714.46 101.850 67.46- 122-50017-045-000 Certification 4,073.00 4,073.00 200.00 3,453.20 84.783 619.80 122-50020-045-000 Retirement 68,264.00 68,264.00 4,919.76 53,396.10 78.220 14,867.90 122-50026-045-000 Medical Insurance 53,184.00 53,184.00 3,473.56 33,570.75 63.122 19,613.25 122-50027-045-000 Dental Insurance 3,288.00 3,288.00 304.68 2,934.94 89.262 353.06 122-50028-045-000 Vision Insurance 857.00 857.00 34.52 628.76 73.368 228.24 122-50029-045-000 Life Insurance & Other 2,740.00 2,740.00 2,740.00 122-50030-045-000 Social Security Taxes 30,231.00 30,231.00 2,185.45 23,140.18 76.545 7,090.82 122-50035-045-000 Medicare Taxes 7,070.00 7,070.00 511.11 5,411.84 76.547 1,658.16 122-50040-045-000 Unemployment Taxes 1,476.00 1,476.00 73.75 720.64 48.824 755.36 122-50045-045-000 Workman's Compensation 8,793.00 9,209.00 8,779.02 95.331 429.98 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 89.00 13.185 586.00 Subtotal: 664,179.00 666,235.00 49,886.14 524,248.84 78.688 141,986.16 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 5,364.89 56.106 4,197.11 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 400.78 5,984.45 40.299 8,865.55 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 6,778.10 69.108 3,029.90 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 231.70 6,206.79 56.425 4,793.21 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 786.00 71.260 317.00 122-55160-045-000 Professional Outside Services 20,000.00 19,623.00 142.69 .727 19,480.31 Subtotal: 66,323.00 65,946.00 632.48 25,262.92 38.308 40,683.08 122-60005-045-000 Telephone 106.00 106.00 2.91 37.22 35.113 68.78 122-60010-045-000 Communications/Pagers/Mobiles 4,411.00 4,411.00 215.94 1,780.55 40.366 2,630.45 122-60020-045-000 Electricity/Gas 18,270.00 18,270.00 582.34 9,325.95 51.045 8,944.05 122-60025-045-000 Water 3,289.00 3,289.00 372.48 2,366.45 71.950 922.55 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 100.000 122-60035-045-000 Postage 97.00 97.00 4.00 42.55 43.866 54.45 122-60055-045-000 Insurance 20,974.00 20,974.00 8,078.00 38.514 12,896.00 122-60066-045-000 Publications/Books/Subscrips 401.00 401.00 401.00 122-60070-045-000 Dues & Memberships 8,560.00 8,560.00 6,650.34 77.691 1,909.66 122-60075-045-000 Meetings 75.00 22.00 29.333 53.00 122-60080-045-000 Schools & Training 6,946.00 6,946.00 1,240.00 3,134.17 45.122 3,811.83 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 6,788.00 6,788.00 2,918.34 42.993 3,869.66 122-60110-045-000 Physicals/Testing 1,918.00 1,918.00 1,918.00 122-60125-045-000 Advertising 156.00 156.00 156.00 122-60160-045-000 Programs & Special Projects 4,162.00 4,162.00 623.76 2,641.55 63.468 1,520.45 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 568.26 29.908 1,331.74 . glbase_tbam rgonzale Trophy Club Entities Page 3 10:45 08/08/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60195-045-000 Flags & Repair 2,543.00 2,543.00 1,684.85 66.254 858.15 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 3.57 824.91 66.686 412.09 Subtotal: 390,758.00 390,833.00 3,045.00 349,075.14 89.316 41,757.86 122-65005-045-000 Fuel & Lube 17,414.00 17,414.00 656.22 5,741.03 32.968 11,672.97 122-65010-045-000 Uniforms 4,357.00 4,357.00 624.68 3,535.78 81.152 821.22 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 427.00 6,900.50 90.796 699.50 122-65030-045-000 Chemicals 1,545.00 1,545.00 485.00 825.00 53.398 720.00 122-65035-045-000 Small Tools 8,371.00 8,371.00 55.95 1,752.14 20.931 6,618.86 122-65085-045-000 Office Supplies 329.00 1,200.00 632.64 52.720 567.36 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 434.94 1,864.69 66.955 920.31 122-65105-045-000 Printing 106.00 106.00 24.77 23.368 81.23 Subtotal: 42,507.00 43,378.00 2,683.79 21,276.55 49.049 22,101.45 122-69006-045-000 Grant Match 3,000.00 3,000.00 3,000.00 122-69035-045-000 Vehicles 13,709.00 13,709.00 13,333.09 97.258 375.91 122-69050-045-000 Radios 2,500.00 2,500.00 248.69 9.948 2,251.31 122-69195-045-000 GASB34/Reserve for Replacement 41,890.00 41,890.00 41,890.00 122-69251-045-000 Engine 681 Payment 73,203.00 73,203.00 500.00 4,851.65 6.628 68,351.35 122-69255-045-000 Airpacks 13,865.00 13,865.00 14,526.00 104.767 661.00- Subtotal: 148,167.00 148,167.00 500.00 32,959.43 22.245 115,207.57 Program number: 1,311,934.00 1,314,559.00 56,747.41 952,822.88 72.482 361,736.12 Department number: Fire 1,311,934.00 1,314,559.00 56,747.41 952,822.88 72.482 361,736.12 Expenditures Subtotal ----------- 1,311,934.00 1,314,559.00 56,747.41 952,822.88 72.482 361,736.12 Fund number: 122 Trophy Club MUD Fire Dept. 43,892.25 365,565.70- 365,565.70 . glpdatb2 rgonzale Trophy Club Entities Page 1 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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 1442 07/02/2012 Property Taxes/Assessments (191,098.20) (175.61) (191,273.81) GL 1443 07/03/2012 Property Tax/Assessments (90.77) (191,364.58) GL 1450 07/16/2012 Property Tax/Assessments (188.07) (191,552.65) GL 1452 07/19/2012 Property Tax/Assessments (70.51) (191,623.16) GL 1458 07/30/2012 Property Tax/Assessments (103.83) (191,726.99) GL 1459 07/31/2012 Property Tax/Assessments (.87) (191,727.86) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (629.66) (191,727.86) ** (193,233.00) Budgeted (1,505.14) Remaining 99 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 1442 07/02/2012 Property Taxes/Assessments (6,878.01) (468.11) (7,346.12) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (468.11) (7,346.12) ** (4,900.00) Budgeted 2,446.12 Remaining 150 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1442 07/02/2012 Property Taxes/Assessments (1,065,533.23) (635.66) (1,066,168.89) GL 1443 07/03/2012 Property Tax/Assessments (172.45) (1,066,341.34) GL 1444 07/05/2012 Property Tax/Assessments (121.39) (1,066,462.73) GL 1445 07/06/2012 Property Tax/Assessments (85.04) (1,066,547.77) GL 1446 07/09/2012 Property Tax/Assessments (197.84) (1,066,745.61) GL 1447 07/10/2012 Property Tax/Assessments (294.22) (1,067,039.83) GL 1448 07/12/2012 Property Tax/Assessments (249.80) (1,067,289.63) GL 1449 07/13/2012 Property Tax/Assessments (227.43) (1,067,517.06) GL 1450 07/16/2012 Property Tax/Assessments (474.00) (1,067,991.06) GL 1451 07/17/2012 Property Tax/Assessments (63.65) (1,068,054.71) GL 1453 07/20/2012 Property Tax/Assessments (114.56) (1,068,169.27) GL 1454 07/23/2012 Property Tax/Assessments (93.60) (1,068,262.87) GL 1455 07/24/2012 Property Tax/Assessments (183.07) (1,068,445.94) GL 1456 07/25/2012 Property Tax/Assessments (36.76) (1,068,482.70) GL 1457 07/27/2012 Property Tax/Assessments (75.70) (1,068,558.40) GL 1458 07/30/2012 Property Tax/Assessments (230.23) (1,068,788.63) GL 1459 07/31/2012 Property Tax/Assessments (443.50) (1,069,232.13) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,698.90) (1,069,232.13) ** (1,076,976.00) Budgeted (7,743.87) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent . glpdatb2 rgonzale Trophy Club Entities Page 2 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1442 07/02/2012 Property Taxes/Assessments 5,426.28 (314.96) 5,111.32 GL 1449 07/13/2012 Property Tax/Assessments (107.10) 5,004.22 GL 1450 07/16/2012 Property Tax/Assessments (361.07) 4,643.15 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (783.13) 4,643.15 ** (5,603.00) Budgeted (10,246.15) Remaining -83 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1442 07/02/2012 Property Taxes/Assessments (2,245.63) (3.41) (2,249.04) GL 1459 07/31/2012 Property Tax/Assessments (.14) (2,249.18) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (3.55) (2,249.18) ** (725.00) Budgeted 1,524.18 Remaining 310 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1442 07/02/2012 Property Taxes/Assessments (3,810.75) (64.15) (3,874.90) GL 1443 07/03/2012 Property Tax/Assessments (17.39) (3,892.29) GL 1447 07/10/2012 Property Tax/Assessments (30.75) (3,923.04) GL 1448 07/12/2012 Property Tax/Assessments (5.95) (3,928.99) GL 1449 07/13/2012 Property Tax/Assessments (66.24) (3,995.23) GL 1450 07/16/2012 Property Tax/Assessments (243.51) (4,238.74) GL 1455 07/24/2012 Property Tax/Assessments (13.31) (4,252.05) GL 1457 07/27/2012 Property Tax/Assessments (1.10) (4,253.15) GL 1459 07/31/2012 Property Tax/Assessments (29.41) (4,282.56) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (471.81) (4,282.56) ** (7,500.00) Budgeted (3,217.44) Remaining 57 % Used Account: 122-40970-000-000 Insurance Settlements (9,739.43) .00 (9,739.43) _______________ Account: 122-40970-000-000 Insurance Settlements Totals: .00 (9,739.43) ** .00 Budgeted 9,739.43 Remaining 0 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1464 07/10/2012 Permits 7/9/12 (7,200.00) (800.00) (8,000.00) GL 1466 07/13/2012 Permits 7/12/12 (1,200.00) (9,200.00) GL 1474 07/30/2012 Permits 7/27/12 (400.00) (9,600.00) GL . glpdatb2 rgonzale Trophy Club Entities Page 3 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/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-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (2,400.00) (9,600.00) ** (6,000.00) Budgeted 3,600.00 Remaining 160 % Used Account: 122-43400-000-000 Fire Inspections 1464 07/10/2012 Permits 7/9/12 (1,350.00) (150.00) (1,500.00) GL 1466 07/13/2012 Permits 7/12/12 (225.00) (1,725.00) GL 1474 07/30/2012 Permits 7/27/12 (75.00) (1,800.00) GL _______________ Account: 122-43400-000-000 Fire Inspections Totals: (450.00) (1,800.00) ** (500.00) Budgeted 1,300.00 Remaining 360 % Used Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49025-000-000 Auction Sales (1,902.50) .00 (1,902.50) _______________ Account: 122-49025-000-000 Auction Sales Totals: .00 (1,902.50) ** .00 Budgeted 1,902.50 Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 1464 07/10/2012 Permits 7/9/12 (11,196.95) (1,450.00) (12,646.95) GL 1466 07/13/2012 Permits 7/12/12 (1,575.00) (14,221.95) GL 1469 07/19/2012 Permits 7/18/12 (100.00) (14,321.95) GL 1473 07/26/2012 Permits 7/26/12 (100.00) (14,421.95) GL 1474 07/30/2012 Permits 7/27/12 (725.00) (15,146.95) GL _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (3,950.00) (15,146.95) ** (9,122.00) Budgeted 6,024.95 Remaining 166 % Used Account: 122-49901-000-000 Records Management (5.00) .00 (5.00) _______________ Account: 122-49901-000-000 Records Management Totals: .00 (5.00) ** .00 Budgeted 5.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 4 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department Totals: ------------------------------------------------------------------------------------------------ (1,318,388.58) ** (1,314,559.00) Budgeted 3,829.58 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club Entities Page 5 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 1392 07/06/2012 7/6 Payroll 311,158.31 20,671.71 331,830.02 GL 1391 07/20/2012 7/20 Payroll 17,511.60 349,341.62 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 38,183.31 349,341.62 ** 425,748.00 Budgeted 76,406.38 Remaining 82 % Used Account: 122-50010-045-000 Overtime 25,295.31 .00 25,295.31 _______________ Account: 122-50010-045-000 Overtime Totals: .00 25,295.31 ** 42,000.00 Budgeted 16,704.69 Remaining 60 % Used Account: 122-50011-045-000 DPS Holiday Pay 13,773.02 .00 13,773.02 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,773.02 ** 13,773.00 Budgeted (.02) Remaining 100 % Used Account: 122-50016-045-000 Longevity 3,714.46 .00 3,714.46 _______________ Account: 122-50016-045-000 Longevity Totals: .00 3,714.46 ** 3,647.00 Budgeted (67.46) Remaining 102 % Used Account: 122-50017-045-000 Certification 1391 07/20/2012 7/20 Payroll 3,253.20 200.00 3,453.20 GL _______________ Account: 122-50017-045-000 Certification Totals: 200.00 3,453.20 ** 4,073.00 Budgeted 619.80 Remaining 85 % Used Account: 122-50020-045-000 Retirement 1392 07/06/2012 7/6 Payroll 48,476.34 34.47 48,510.81 GL 1392 07/06/2012 7/6 Payroll 2,636.53 51,147.34 GL 1391 07/20/2012 7/20 Payroll 2,248.76 53,396.10 GL _______________ Account: 122-50020-045-000 Retirement Totals: 4,919.76 53,396.10 ** 68,264.00 Budgeted 14,867.90 Remaining 78 % Used . glpdatb2 rgonzale Trophy Club Entities Page 6 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 1392 07/06/2012 7/6 Payroll 30,097.19 1,736.80 31,833.99 GL 1391 07/20/2012 7/20 Payroll 1,736.76 33,570.75 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,473.56 33,570.75 ** 53,184.00 Budgeted 19,613.25 Remaining 63 % Used Account: 122-50027-045-000 Dental Insurance 1392 07/06/2012 7/6 Payroll 2,630.26 152.33 2,782.59 GL 1391 07/20/2012 7/20 Payroll 152.35 2,934.94 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 304.68 2,934.94 ** 3,288.00 Budgeted 353.06 Remaining 89 % Used Account: 122-50028-045-000 Vision Insurance 1391 07/20/2012 7/20 Payroll 594.24 34.52 628.76 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 34.52 628.76 ** 857.00 Budgeted 228.24 Remaining 73 % 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 1392 07/06/2012 7/6 Payroll 20,954.73 1,183.38 22,138.11 GL 1391 07/20/2012 7/20 Payroll 1,002.07 23,140.18 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,185.45 23,140.18 ** 30,231.00 Budgeted 7,090.82 Remaining 77 % Used Account: 122-50035-045-000 Medicare Taxes 1392 07/06/2012 7/6 Payroll 4,900.73 276.76 5,177.49 GL 1391 07/20/2012 7/20 Payroll 234.35 5,411.84 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 511.11 5,411.84 ** 7,070.00 Budgeted 1,658.16 Remaining 77 % Used . glpdatb2 rgonzale Trophy Club Entities Page 7 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-50040-045-000 Unemployment Taxes 1392 07/06/2012 7/6 Payroll 646.89 35.70 682.59 GL 1391 07/20/2012 7/20 Payroll 38.05 720.64 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 73.75 720.64 ** 1,476.00 Budgeted 755.36 Remaining 49 % Used Account: 122-50045-045-000 Workman's Compensation 8,779.02 .00 8,779.02 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 8,779.02 ** 9,209.00 Budgeted 429.98 Remaining 95 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 89.00 .00 89.00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 89.00 ** 675.00 Budgeted 586.00 Remaining 13 % Used Account: 122-55080-045-000 Maintenance & Repairs 5,364.89 .00 5,364.89 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 5,364.89 ** 9,562.00 Budgeted 4,197.11 Remaining 56 % Used Account: 122-55090-045-000 Vehicle Maintenance 1367 07/20/2012 July A/P 2 Batteries 5,583.67 222.00 5,805.67 INTERSTATE ALL BATTERY CENTER 31594 AP 1388 07/24/2012 July A/P June PCards - Hurd 134.15 5,939.82 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Hurd 44.63 5,984.45 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 400.78 5,984.45 ** 14,850.00 Budgeted 8,865.55 Remaining 40 % Used Account: 122-55095-045-000 Equipment Maintenance 6,778.10 .00 6,778.10 _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: .00 6,778.10 ** 9,808.00 Budgeted 3,029.90 Remaining 69 % Used . glpdatb2 rgonzale Trophy Club Entities Page 8 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-55100-045-000 Building Maintenance 1388 07/24/2012 July A/P June PCard - Schultz 5,975.09 46.36 6,021.45 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCard Jaramillo 24.37 6,045.82 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Thomas 152.56 6,198.38 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Thomas 128.41 6,326.79 JPMORGAN CHASE BANK NA 31627 AP 1475 07/25/2012 Fire Cable/July (120.00) 6,206.79 GL _______________ Account: 122-55100-045-000 Building Maintenance Totals: 231.70 6,206.79 ** 11,000.00 Budgeted 4,793.21 Remaining 56 % Used Account: 122-55110-045-000 Maintenance-Radios 786.00 .00 786.00 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 786.00 ** 1,103.00 Budgeted 317.00 Remaining 71 % Used Account: 122-55160-045-000 Professional Outside Services 142.69 .00 142.69 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 142.69 ** 19,623.00 Budgeted 19,480.31 Remaining 1 % Used Account: 122-60005-045-000 Telephone 1322 07/09/2012 July A/P 5/28-6/27/12 P Cards/Zieverink 34.31 2.91 37.22 BANK OF AMERICA 31589 AP _______________ Account: 122-60005-045-000 Telephone Totals: 2.91 37.22 ** 106.00 Budgeted 68.78 Remaining 35 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1391 07/20/2012 7/20 Payroll 1,564.61 75.00 1,639.61 GL 1388 07/24/2012 July A/P Mobiles 140.94 1,780.55 VERIZON WIRELESS 31659 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 215.94 1,780.55 ** 4,411.00 Budgeted 2,630.45 Remaining 40 % Used Account: 122-60020-045-000 Electricity/Gas 1388 07/24/2012 July A/P Gas Fire Station 6/14-7/2 8,743.61 582.34 9,325.95 HUDSON ENERGY 31625 AP . glpdatb2 rgonzale Trophy Club Entities Page 9 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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-60020-045-000 Electricity/Gas Totals: 582.34 9,325.95 ** 18,270.00 Budgeted 8,944.05 Remaining 51 % Used Account: 122-60025-045-000 Water 1367 07/20/2012 July A/P June water 1,993.97 175.32 2,169.29 TROPHY CLUB MUD (WATER BILLS) 31601 AP 1367 07/20/2012 July A/P June water 197.16 2,366.45 TROPHY CLUB MUD (WATER BILLS) 31601 AP _______________ Account: 122-60025-045-000 Water Totals: 372.48 2,366.45 ** 3,289.00 Budgeted 922.55 Remaining 72 % Used Account: 122-60030-045-000 Rent And/Or Usage 308,000.00 .00 308,000.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 308,000.00 ** 308,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 1462 07/31/2012 July postage meter usage 38.55 4.00 42.55 GL _______________ Account: 122-60035-045-000 Postage Totals: 4.00 42.55 ** 97.00 Budgeted 54.45 Remaining 44 % 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,650.34 .00 6,650.34 . glpdatb2 rgonzale Trophy Club Entities Page 10 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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,650.34 ** 8,560.00 Budgeted 1,909.66 Remaining 78 % Used Account: 122-60075-045-000 Meetings 22.00 .00 22.00 _______________ Account: 122-60075-045-000 Meetings Totals: .00 22.00 ** 75.00 Budgeted 53.00 Remaining 29 % Used Account: 122-60080-045-000 Schools & Training 1367 07/20/2012 July A/P Hurd/Increase from Advance to 1,894.17 255.00 2,149.17 TX COMM ON FIRE PROTECTION 31602 AP 1367 07/20/2012 July A/P Hards/Advanced Structure Fire 85.00 2,234.17 TX COMM ON FIRE PROTECTION 31602 AP 1388 07/24/2012 July A/P Wireless keyboard 437.00 2,671.17 SHI GOVERNMENT SOLUTIONS,INC 31647 AP 1388 07/24/2012 July A/P TIFMAS Wildland Fire Class 75.00 2,746.17 NEFDA 31638 AP 1388 07/24/2012 July A/P June PCards - Hurd 388.00 3,134.17 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 1,240.00 3,134.17 ** 6,946.00 Budgeted 3,811.83 Remaining 45 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem 2,918.34 .00 2,918.34 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 2,918.34 ** 6,788.00 Budgeted 3,869.66 Remaining 43 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 1,918.00 Budgeted 1,918.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 11 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 .00 .00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 156.00 Budgeted 156.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 1388 07/24/2012 July A/P June PCard - Schultz 2,017.79 29.65 2,047.44 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCard - Schultz 9.98 2,057.42 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Beck 3.74 2,061.16 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P Side Click pens 266.22 2,327.38 RIVER CITY SUPPLY, LLC 31643 AP 1388 07/24/2012 July A/P Mood Pencils 314.17 2,641.55 RIVER CITY SUPPLY, LLC 31643 AP _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 623.76 2,641.55 ** 4,162.00 Budgeted 1,520.45 Remaining 63 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 568.26 .00 568.26 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 568.26 ** 1,900.00 Budgeted 1,331.74 Remaining 30 % Used Account: 122-60195-045-000 Flags & Repair 1,684.85 .00 1,684.85 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 1,684.85 ** 2,543.00 Budgeted 858.15 Remaining 66 % Used Account: 122-60245-045-000 Miscellaneous Expense 1388 07/24/2012 July A/P June PCard - Schultz 821.34 3.57 824.91 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 3.57 824.91 ** 1,237.00 Budgeted 412.09 Remaining 67 % Used Account: 122-65005-045-000 Fuel & Lube 1510 07/01/2012 FD June Gas Log 5,084.81 656.22 5,741.03 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 656.22 5,741.03 ** 17,414.00 Budgeted 11,672.97 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club Entities Page 12 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/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 1367 07/20/2012 July A/P Uniforms 2,911.10 113.90 3,025.00 RON MONTGOMERY & ASSOC INC 31644 AP 1388 07/24/2012 July A/P June PCards - Thomas 75.00 3,100.00 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Thomas 435.78 3,535.78 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 624.68 3,535.78 ** 4,357.00 Budgeted 821.22 Remaining 81 % Used Account: 122-65015-045-000 Protective Clothing 1388 07/24/2012 July A/P June PCards - Hurd 6,473.50 387.00 6,860.50 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Hurd 40.00 6,900.50 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 427.00 6,900.50 ** 7,600.00 Budgeted 699.50 Remaining 91 % Used Account: 122-65030-045-000 Chemicals 1388 07/24/2012 July A/P June PCards - Hurd 340.00 150.00 490.00 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Hurd 335.00 825.00 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 122-65030-045-000 Chemicals Totals: 485.00 825.00 ** 1,545.00 Budgeted 720.00 Remaining 53 % Used Account: 122-65035-045-000 Small Tools 1388 07/24/2012 July A/P June PCards - Beck 1,696.19 29.97 1,726.16 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Hurd 25.98 1,752.14 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 122-65035-045-000 Small Tools Totals: 55.95 1,752.14 ** 8,371.00 Budgeted 6,618.86 Remaining 21 % Used Account: 122-65085-045-000 Office Supplies 632.64 .00 632.64 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 632.64 ** 1,200.00 Budgeted 567.36 Remaining 53 % Used Account: 122-65095-045-000 Maintenance Supplies 1388 07/24/2012 July A/P June PCards - Hurd 1,429.75 54.40 1,484.15 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Hurd 66.62 1,550.77 JPMORGAN CHASE BANK NA 31627 AP . glpdatb2 rgonzale Trophy Club Entities Page 13 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1388 07/24/2012 July A/P June PCards - Hurd 1,429.75 82.06 1,632.83 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Hurd 231.86 1,864.69 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 434.94 1,864.69 ** 2,785.00 Budgeted 920.31 Remaining 67 % Used Account: 122-65105-045-000 Printing 24.77 .00 24.77 _______________ Account: 122-65105-045-000 Printing Totals: .00 24.77 ** 106.00 Budgeted 81.23 Remaining 23 % Used Account: 122-69006-045-000 Grant Match .00 .00 _______________ Account: 122-69006-045-000 Grant Match Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 122-69035-045-000 Vehicles 13,333.09 .00 13,333.09 _______________ Account: 122-69035-045-000 Vehicles Totals: .00 13,333.09 ** 13,709.00 Budgeted 375.91 Remaining 97 % Used Account: 122-69050-045-000 Radios 248.69 .00 248.69 _______________ Account: 122-69050-045-000 Radios Totals: .00 248.69 ** 2,500.00 Budgeted 2,251.31 Remaining 10 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 41,890.00 Budgeted 41,890.00 Remaining 0 % Used Account: 122-69251-045-000 Engine 681 Payment . glpdatb2 rgonzale Trophy Club Entities Page 14 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1367 07/20/2012 July A/P Admin Fee/Fire Truck CO 4,351.65 500.00 4,851.65 ZIONS BANK 31604 AP _______________ Account: 122-69251-045-000 Engine 681 Payment Totals: 500.00 4,851.65 ** 73,203.00 Budgeted 68,351.35 Remaining 7 % Used Account: 122-69255-045-000 Airpacks 14,526.00 .00 14,526.00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 14,526.00 ** 13,865.00 Budgeted (661.00) Remaining 105 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 952,822.88 ** 1,314,559.00 Budgeted 361,736.12 Remaining 72 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (365,565.70) .00 Budgeted 365,565.70 Remaining 0 % Used Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 7/31/2012 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 800,586 INVESTMENTS 2,427,531 RESTRICTED ASSETS: INVESTMENTS 421,376 PREPAID EXPENSES 11,502 ADVALOREM PROPERTY TAXES RECEIVABLE 3,220 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,013,845 TOTAL ASSETS 4,678,460$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,220$ ACCOUNTS PAYABLE 588,611 CUSTOMER DEPOSITS 201,962 TOTAL LIABILITIES 793,793 FUND BALANCE NON-SPENDABLE FUND BALANCE 7,755 ASSIGNED/WATER REPLACEMENT 60,000 ASSIGNED/TECHNOLOGY REPLACEMENT 159,414 ASSIGNED FUND BALANCE 578,742 UNASSIGNED FUND BALANCE 3,078,756 TOTAL FUND BALANCE 3,884,667 TOTAL LIABILITIES AND FUND BALANCE 4,678,460$ July 31, 2012 10/12 Months (83% of Fiscal Year) . glbase_tbam rgonzale Trophy Club Entities Page 4 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 97,495.00- 97,495.00- 334.83- 96,793.59- 99.281 701.41- 135-40002-000-000 Property Taxes/Delinquent 451.00- 97.36- 560.19 -124.211 1,011.19- 135-40015-000-000 Property Taxes/P & I 1,334.00- 200.00- 53.50- 167.03- 83.515 32.97- Subtotal: 98,829.00- 98,146.00- 485.69- 96,400.43- 98.221 1,745.57- 135-43215-000-000 Insurance Settlement 3,999.00- 3,999.00- 100.000 Subtotal: 3,999.00- 3,999.00- 100.000 135-47000-000-000 Water 1,990,800.00- 1,990,800.00- 264,836.10- 1,359,165.69- 68.272 631,634.31- 135-47005-000-000 Sewer 1,325,000.00- 1,325,000.00- 109,324.33- 838,438.79- 63.278 486,561.21- 135-47010-000-000 Commercial Water 825,000.00- 825,000.00- 127,677.08- 608,661.53- 73.777 216,338.47- 135-47015-000-000 Commercial Sewer 360,000.00- 360,000.00- 25,021.29- 232,273.58- 64.520 127,726.42- 135-47020-000-000 Standby 775.00- 775.00- 66.00- 583.35- 75.271 191.65- 135-47025-000-000 Penalties 50,500.00- 45,000.00- 8,781.13- 44,927.32- 99.838 72.68- 135-47030-000-000 Service Charges 17,500.00- 15,000.00- 478.00- 9,507.48- 63.383 5,492.52- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,500.00- 400.00- 1,800.00- 120.000 300.00 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 1,200.00- 5,400.00- 120.000 900.00 135-47070-000-000 TCCC Effluent Charges 57,500.00- 75,000.00- 10,926.50- 41,027.49- 54.703 33,972.51- 135-47270-000-000 Fire Line 5,000.00- 135-47400-000-000 Water-Out of Dist/Port Meters 41,595.00- 41,595.00- 5,163.83- 32,998.36- 79.333 8,596.64- 135-47405-000-000 Out of District Sewer 11,807.00- 11,807.00- 1,352.47- 9,720.06- 82.325 2,086.94- 135-47410-000-000 Out of Dist/Portable Penalties 300.00- 100.00- 7.42- 41.45- 41.450 58.55- 135-47600-000-000 PID #1 Water 425,000.00- 500,000.00- 83,924.36- 434,464.03- 86.893 65,535.97- 135-47605-000-000 PID #1 Sewer 185,000.00- 250,000.00- 32,097.50- 211,575.00- 84.630 38,425.00- Subtotal: 5,301,477.00- 5,446,077.00- 671,256.01- 3,830,584.13- 70.337 1,615,492.87- 135-48005-000-000 Utility Fees 338,880.00- 621,000.00- 48,300.00- 550,480.00- 88.644 70,520.00- Subtotal: 338,880.00- 621,000.00- 48,300.00- 550,480.00- 88.644 70,520.00- 135-49005-000-000 Loan Proceeds 1,100,000.00- 1,100,000.00- 100.000 135-49010-000-000 Interest Income 4,500.00- 4,500.00- 587.86- 4,541.52- 100.923 41.52 135-49016-000-000 Cell Tower Revenue 10,164.00- 847.00- 8,470.00- 83.333 1,694.00- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,833.30- 83.333 1,166.70- 135-49025-000-000 Auction Sales 4,305.00- 4,305.00- 100.000 135-49030-000-000 Vending Revenue 600.00- 600.00- 439.24- 73.207 160.76- 135-49035-000-000 Prior Year Reserves 241,981.00- 135-49036-000-000 GASB Reserves 26,911.00- 103,966.00- 103,966.00- 135-49075-000-000 Oversize Meter Reimbursement 64,000.00- 77,800.00- 11,946.25- 89,691.05- 115.284 11,891.05 135-49900-000-000 Miscellaneous Income 10,000.00- 5,400.00- 5,418.82- 100.349 18.82 135-49905-000-000 Gas Well Revenue 800.00- 123.00- 123.00- 100.000 . glbase_tbam rgonzale Trophy Club Entities Page 5 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 355,792.00- 1,313,858.00- 13,964.44- 1,218,821.93- 92.767 95,036.07- Program number: 6,094,978.00- 7,483,080.00- 734,006.14- 5,700,285.49- 76.176 1,782,794.51- Department number: Revenues 6,094,978.00- 7,483,080.00- 734,006.14- 5,700,285.49- 76.176 1,782,794.51- Revenues Subtotal ----------- 6,094,978.00- 7,483,080.00- 734,006.14- 5,700,285.49- 76.176 1,782,794.51- . glbase_tbam rgonzale Trophy Club Entities Page 6 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 199,759.00 160,600.00 12,833.30 126,039.42 78.480 34,560.58 135-50010-010-000 Overtime 13,250.00 13,250.00 1,721.68 14,132.14 106.658 882.14- 135-50016-010-000 Longevity 2,620.00 2,620.00 2,620.00 100.000 135-50017-010-000 Certification 1,800.00 1,800.00 150.00 1,200.00 66.667 600.00 135-50020-010-000 Retirement 25,508.00 25,508.00 2,032.22 20,481.61 80.295 5,026.39 135-50026-010-000 Medical Insurance 22,607.00 22,607.00 1,642.80 17,086.49 75.581 5,520.51 135-50027-010-000 Dental Insurance 2,169.00 2,169.00 125.20 1,259.54 58.070 909.46 135-50028-010-000 Vision Insurance 576.00 576.00 31.76 308.61 53.578 267.39 135-50029-010-000 Life Insurance & Other 1,161.00 1,161.00 1,161.00 135-50030-010-000 Social Security Taxes 13,481.00 12,000.00 887.26 8,732.83 72.774 3,267.17 135-50035-010-000 Medicare Taxes 3,153.00 2,700.00 207.50 2,042.34 75.642 657.66 135-50040-010-000 Unemployment Taxes 945.00 945.00 288.00 30.476 657.00 135-50045-010-000 Workman's Compensation 5,581.00 5,581.00 5,581.00 100.000 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 350.00 350.00 118.64 33.897 231.36 Subtotal: 293,160.00 252,067.00 19,631.72 199,890.62 79.301 52,176.38 135-55005-010-000 Engineering 1,500.00 500.00 500.00 135-55070-010-000 Independent Labor 500.00 135-55080-010-000 Maintenance & Repairs 29,500.00 29,500.00 1,383.97 15,947.68 54.060 13,552.32 135-55090-010-000 Vehicle Maintenance 3,380.00 3,380.00 44.48 3,720.81 110.083 340.81- 135-55100-010-000 Building Maint & Supplies 750.00 750.00 2,771.42 3,243.27 432.436 2,493.27- 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 464.49 16.017 2,435.51 135-55135-010-000 Lab Analysis 4,500.00 4,500.00 420.95 2,145.95 47.688 2,354.05 Subtotal: 43,030.00 41,530.00 4,620.82 25,522.20 61.455 16,007.80 135-60010-010-000 Communications/Pagers/Mobiles 1,599.00 2,100.00 176.46 1,538.82 73.277 561.18 135-60020-010-000 Electricity 162,000.00 100,000.00 19,846.69 67,822.99 67.823 32,177.01 135-60035-010-000 Postage 500.00 688.00 687.40 99.913 .60 135-60050-010-000 Bad Debt Expense 4,200.00 4,200.00 6,252.82 6,252.82 148.877 2,052.82- 135-60066-010-000 Publications/Books/Subscripts 50.00 85.00 85.00 100.000 135-60070-010-000 Dues & Memberships 150.00 150.00 111.00 74.000 39.00 135-60080-010-000 Schools & Training 2,800.00 2,800.00 1,082.00 38.643 1,718.00 135-60090-010-000 Safety Program 500.00 500.00 500.00 135-60100-010-000 Travel & per diem 3,200.00 3,200.00 171.74 1,206.88 37.715 1,993.12 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 Annual Permit Fee 6,600.00 8,000.00 7,965.75 99.572 34.25 135-60150-010-000 Wholesale Water 1,720,000.00 1,720,000.00 978,469.06 56.888 741,530.94 135-60245-010-000 Miscellaneous Expenses 1,000.00 500.00 500.00 135-60280-010-000 Property Maintenance 4,200.00 2,200.00 27.91 408.29 18.559 1,791.71 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 550.76 550.76 27.538 1,449.24 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 1,500.00 299.99 19.999 1,200.01 . glbase_tbam rgonzale Trophy Club Entities Page 7 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 1,910,799.00 1,848,423.00 27,026.38 1,066,480.76 57.697 781,942.24 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 1,522.70 11,221.32 73.747 3,994.68 135-65010-010-000 Uniforms 3,690.00 3,690.00 1,400.99 37.967 2,289.01 135-65030-010-000 Chemicals 6,200.00 5,000.00 430.51 3,288.62 65.772 1,711.38 135-65035-010-000 Small Tools 2,500.00 1,500.00 203.00 13.533 1,297.00 135-65040-010-000 Safety Equipment 2,500.00 1,000.00 102.59 449.59 44.959 550.41 135-65050-010-000 Meter Expense 85,000.00 100,000.00 854.50 93,696.57 93.697 6,303.43 135-65055-010-000 Hardware 1,000.00 1,000.00 1,000.00 135-65085-010-000 Office Supplies 30.00 30.00 100.000 135-65095-010-000 Maintenance Supplies 32,000.00 32,000.00 2,908.09 14,586.31 45.582 17,413.69 135-65100-010-000 Copies 50.00 50.00 50.00 135-65105-010-000 Printing 150.00 150.00 58.50 39.000 91.50 Subtotal: 148,306.00 159,636.00 5,818.39 124,934.90 78.262 34,701.10 135-69005-010-000 Capital Expenses 888,432.00 1,455,600.00 29,422.04 1,305,208.14 89.668 150,391.86 135-69008-010-000 Short Term Debt Payments 421,050.00 34,350.45 34,350.45 8.158 386,699.55 135-69035-010-000 Vehicles 27,000.00 30,215.00 30,213.69 99.996 1.31 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 24,000.00 24,000.00 24,000.00 135-69281-010-000 Capital Repair-Ground Storage 124,771.00 100,817.00 100,816.54 100.000 .46 135-69295-010-000 Unexpected Maintenance 250.00 250.00 250.00 135-69305-010-000 Capital Leases 11,490.00 10,145.00 10,145.26 100.003 .26- Subtotal: 1,105,943.00 2,072,077.00 63,772.49 1,480,734.08 71.461 591,342.92 Program number: 3,501,238.00 4,373,733.00 120,869.80 2,897,562.56 66.249 1,476,170.44 Department number: Water 3,501,238.00 4,373,733.00 120,869.80 2,897,562.56 66.249 1,476,170.44 . glbase_tbam rgonzale Trophy Club Entities Page 8 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 182,147.00 182,147.00 14,020.84 155,619.14 85.436 26,527.86 135-50010-020-000 Overtime 10,166.00 10,166.00 946.97 10,131.81 99.664 34.19 135-50016-020-000 Longevity 3,976.00 3,976.00 3,975.00 99.975 1.00 135-50017-020-000 Certification 2,400.00 2,400.00 125.00 1,075.00 44.792 1,325.00 135-50020-020-000 Retirement 27,816.00 27,816.00 2,085.83 24,265.41 87.235 3,550.59 135-50026-020-000 Medical Insurance 30,805.00 30,805.00 2,360.69 21,757.18 70.629 9,047.82 135-50027-020-000 Dental Insurance 1,981.00 1,981.00 175.84 1,664.56 84.026 316.44 135-50028-020-000 Vision Insurance 552.00 552.00 45.92 416.50 75.453 135.50 135-50029-020-000 Life Insurance & Other 884.00 884.00 884.00 135-50030-020-000 Social Security Taxes 8,597.00 11,293.00 811.45 9,739.90 86.247 1,553.10 135-50035-020-000 Medicare Taxes 2,011.00 2,645.00 189.79 2,277.84 86.119 367.16 135-50040-020-000 Unemployment Taxes 567.00 567.00 125.94 459.15 80.979 107.85 135-50045-020-000 Workman's Compensation 2,685.00 2,685.00 2,685.00 100.000 135-50060-020-000 Pre-emp Physicals/Testing 200.00 115.45 57.725 84.55 135-50070-020-000 Employee Relations 350.00 350.00 64.45 18.414 285.55 Subtotal: 274,937.00 278,467.00 20,888.27 234,246.39 84.120 44,220.61 135-55070-020-000 Independent Labor 750.00 32,000.00 3,815.00 16,905.67 52.830 15,094.33 135-55080-020-000 Maintenance & Repairs 17,750.00 43,000.00 541.16 37,560.39 87.350 5,439.61 135-55090-020-000 Vehicle Maintenance 4,998.00 1,500.00 234.70 15.647 1,265.30 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 206.35 322.35 23.025 1,077.65 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 316.73 10.737 2,633.27 135-55125-020-000 Dumpster Services 35,000.00 35,000.00 3,762.50 32,250.00 92.143 2,750.00 135-55135-020-000 Lab Analysis 22,760.00 25,000.00 3,519.75 18,054.37 72.217 6,945.63 Subtotal: 85,608.00 140,850.00 11,844.76 105,644.21 75.005 35,205.79 135-60005-020-000 Telephone 100.00 3.90 22.62 22.620 77.38 135-60010-020-000 Communications/Pagers/Mobiles 3,000.00 3,000.00 265.48 1,993.08 66.436 1,006.92 135-60020-020-000 Electricity 205,000.00 110,000.00 11,310.54 65,725.16 59.750 44,274.84 135-60025-020-000 Water 1,900.00 1,900.00 74.46 1,721.52 90.606 178.48 135-60035-020-000 Postage 120.00 120.00 120.00 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 438.17 87.634 61.83 135-60080-020-000 Schools & Training 1,320.00 1,320.00 67.50 178.50 13.523 1,141.50 135-60090-020-000 Safety Program 200.00 200.00 116.45 58.225 83.55 135-60100-020-000 Travel & per diem 1,750.00 1,750.00 139.86 1,479.08 84.519 270.92 135-60105-020-000 Rent/Lease Equipment 200.00 200.00 901.30 450.650 701.30- 135-60125-020-000 Advertising 1,500.00 987.36 65.824 512.64 135-60135-020-000 Annual Permit Fee 7,500.00 7,500.00 7,432.50 99.100 67.50 135-60245-020-000 Miscellaneous Expenses 525.00 525.00 76.02 14.480 448.98 135-60285-020-000 Lawn Equipment & Maintenance 525.00 525.00 83.79 83.79 15.960 441.21 Subtotal: 222,540.00 129,140.00 11,945.53 81,155.55 62.843 47,984.45 . glbase_tbam rgonzale Trophy Club Entities Page 9 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 6,875.00 6,875.00 564.77 3,754.78 54.615 3,120.22 135-65010-020-000 Uniforms 3,140.00 3,140.00 1,118.93 35.635 2,021.07 135-65030-020-000 Chemicals 13,180.00 13,180.00 413.21 6,999.68 53.108 6,180.32 135-65035-020-000 Small Tools 1,260.00 1,260.00 5.94 .471 1,254.06 135-65040-020-000 Safety Equipment 925.00 925.00 80.68 103.43 11.182 821.57 135-65045-020-000 Lab Supplies 19,160.00 12,000.00 3,363.87 7,612.90 63.441 4,387.10 135-65055-020-000 Hardware 525.00 525.00 525.00 135-65085-020-000 Office Supplies 400.00 400.00 606.04 968.57 242.143 568.57- 135-65095-020-000 Maintenance Supplies 8,860.00 8,860.00 771.60 3,022.27 34.111 5,837.73 135-65115-020-000 Other Consumables 110.00 110.00 110.00 Subtotal: 54,435.00 47,275.00 5,800.17 23,586.50 49.892 23,688.50 135-69005-020-000 Capital Expenses 161,189.00 111,021.00 750.00 74,212.56 66.846 36,808.44 135-69008-020-000 Short Term Debt Payments 118,731.00 118,730.85 118,730.85 100.000 .15 135-69280-020-000 Capital Repairs 56,000.00 56,000.00 56,000.00 Subtotal: 217,189.00 285,752.00 119,480.85 192,943.41 67.521 92,808.59 Program number: 854,709.00 881,484.00 169,959.58 637,576.06 72.330 243,907.94 Department number: Wastewater 854,709.00 881,484.00 169,959.58 637,576.06 72.330 243,907.94 . glbase_tbam rgonzale Trophy Club Entities Page 10 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 145,481.00 145,481.00 11,311.69 112,446.70 77.293 33,034.30 135-50010-021-000 Overtime 7,297.00 7,297.00 742.20 7,670.09 105.113 373.09- 135-50016-021-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50017-021-000 Certification 1,500.00 1,500.00 100.00 950.00 63.333 550.00 135-50020-021-000 Retirement 21,074.00 21,074.00 1,679.66 17,756.38 84.257 3,317.62 135-50026-021-000 Medical Insurance 22,983.00 22,983.00 1,702.68 16,390.08 71.314 6,592.92 135-50027-021-000 Dental Insurance 1,533.00 1,533.00 117.38 1,132.31 73.862 400.69 135-50028-021-000 Vision Insurance 357.00 357.00 29.72 287.47 80.524 69.53 135-50029-021-000 Life Insurance & Other 978.00 978.00 978.00 135-50030-021-000 Social Security Taxes 9,785.00 9,785.00 694.57 7,351.50 75.130 2,433.50 135-50035-021-000 Medicare Taxes 2,288.00 2,288.00 162.43 1,719.30 75.144 568.70 135-50040-021-000 Unemployment Taxes 567.00 567.00 216.00 38.095 351.00 135-50045-021-000 Workman's Compensation 3,056.00 3,056.00 3,056.00 100.000 135-50070-021-000 Employee Relations 250.00 250.00 64.43 25.772 185.57 Subtotal: 220,697.00 220,697.00 16,540.33 172,587.76 78.201 48,109.24 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-021-000 Independent Labor 200.00 200.00 200.00 135-55080-021-000 Maintenance & Repairs 23,700.00 15,000.00 4,157.53 27.717 10,842.47 135-55085-021-000 Maintenance-Jet Trailer 330.03 330.03 330.03- 135-55090-021-000 Vehicle Maintenance 1,943.00 1,943.00 255.00 514.22 26.465 1,428.78 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 28,093.00 19,393.00 585.03 5,001.78 25.792 14,391.22 135-60005-021-000 Telephone 50.00 9.25 31.62 63.240 18.38 135-60010-021-000 Communications/Pagers/Mobiles 2,796.00 2,796.00 201.85 2,362.27 84.487 433.73 135-60020-021-000 Electricity 23,625.00 15,000.00 1,437.10 9,628.13 64.188 5,371.87 135-60025-021-000 Water 750.00 750.00 750.00 135-60035-021-000 Postage 150.00 150.00 150.00 135-60070-021-000 Dues & Memberships 255.00 255.00 255.00 135-60080-021-000 Schools & Training 2,818.00 2,818.00 111.00 3.939 2,707.00 135-60090-021-000 Safety Program 750.00 750.00 750.00 135-60100-021-000 Travel & per diem 1,500.00 1,500.00 116.00 616.09 41.073 883.91 135-60105-021-000 Rent/Lease Equipment 44,107.00 76,098.00 42,076.50 42,076.50 55.293 34,021.50 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60280-021-000 Property Maintenance 1,000.00 1,000.00 1,000.00 Subtotal: 77,851.00 101,267.00 43,840.70 54,825.61 54.140 46,441.39 135-65005-021-000 Fuel & Lube 11,700.00 11,700.00 677.41 7,094.68 60.638 4,605.32 135-65010-021-000 Uniforms 2,505.00 2,505.00 832.88 33.249 1,672.12 135-65030-021-000 Chemicals 12,500.00 6,500.00 2,616.00 40.246 3,884.00 . glbase_tbam rgonzale Trophy Club Entities Page 11 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00 135-65040-021-000 Safety Equipment 1,150.00 1,150.00 39.13 61.87 5.380 1,088.13 135-65055-021-000 Hardware 750.00 750.00 44.95 5.993 705.05 135-65095-021-000 Maintenance Supplies 16,050.00 6,050.00 352.64 5.829 5,697.36 Subtotal: 46,155.00 30,155.00 716.54 11,003.02 36.488 19,151.98 135-69005-021-000 Capital Expenses 15,000.00 15,000.00 31,991.00 213.273 16,991.00- 135-69035-021-000 Vehicles 1,001.25 1,001.25- 135-69280-021-000 Capital Repairs 20,000.00 80,000.00 80,000.00 Subtotal: 35,000.00 95,000.00 32,992.25 34.729 62,007.75 Program number: 407,796.00 466,512.00 61,682.60 276,410.42 59.250 190,101.58 Department number: Collection 407,796.00 466,512.00 61,682.60 276,410.42 59.250 190,101.58 . glbase_tbam rgonzale Trophy Club Entities Page 12 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 400.00 6,800.00 68.000 3,200.00 135-50030-026-000 Social Security Taxes 620.00 620.00 24.80 421.60 68.000 198.40 135-50035-026-000 Medicare Taxes 145.00 145.00 5.80 98.60 68.000 46.40 135-50040-026-000 Unemployment Taxes 210.00 210.00 11.60 62.80 29.905 147.20 135-50045-026-000 Workman's Compensation 120.00 120.00 120.00 100.000 Subtotal: 11,095.00 11,095.00 442.20 7,503.00 67.625 3,592.00 135-60035-026-000 Postage 50.00 26.11 52.220 23.89 135-60066-026-000 Publications/Books/Subscripts 50.00 135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 685.00 32.619 1,415.00 135-60075-026-000 Meetings 1,278.00 1,278.00 636.56 49.809 641.44 135-60080-026-000 Schools & Training 4,150.00 4,150.00 1,099.87 26.503 3,050.13 135-60100-026-000 Travel & per diem 6,199.00 6,199.00 32.19 .519 6,166.81 135-60245-026-000 Miscellaneous Expenses 3,200.00 3,200.00 100.00 1,217.69 38.053 1,982.31 Subtotal: 16,977.00 16,977.00 100.00 3,697.42 21.779 13,279.58 135-65085-026-000 Office Supplies 50.00 50.00 7.00 30.90 61.800 19.10 Subtotal: 50.00 50.00 7.00 30.90 61.800 19.10 Program number: 28,122.00 28,122.00 549.20 11,231.32 39.938 16,890.68 Department number: Board of Directors 28,122.00 28,122.00 549.20 11,231.32 39.938 16,890.68 . glbase_tbam rgonzale Trophy Club Entities Page 13 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-027-000 Salaries & Wages 236,831.00 236,831.00 13,252.64 215,089.60 90.820 21,741.40 135-50010-027-000 Overtime 1,000.00 1,028.00 13.97 1,124.91 109.427 96.91- 135-50016-027-000 Longevity 1,845.00 1,845.00 3,705.00 200.813 1,860.00- 135-50020-027-000 Retirement 33,471.00 33,471.00 1,711.56 30,523.79 91.195 2,947.21 135-50026-027-000 Medical Insurance 18,798.00 18,798.00 1,211.86 14,008.78 74.523 4,789.22 135-50027-027-000 Dental Insurance 1,242.00 1,242.00 98.04 1,101.17 88.661 140.83 135-50028-027-000 Vision Insurance 341.00 341.00 22.96 268.45 78.724 72.55 135-50029-027-000 Life Insurance & Other 1,337.00 1,337.00 1,337.00 135-50030-027-000 Social Security Taxes 14,860.00 14,860.00 743.53 12,997.41 87.466 1,862.59 135-50035-027-000 Medicare Taxes 3,475.00 3,475.00 173.90 3,077.61 88.564 397.39 135-50040-027-000 Unemployment Taxes 756.00 756.00 25.58 347.52 45.968 408.48 135-50045-027-000 Workman's Compensation 580.00 580.00 580.00 100.000 135-50060-027-000 Pre-emp Physicals/Testing 53.00 8.98 61.48 116.000 8.48- 135-50070-027-000 Employee Relations 5,000.00 5,000.00 495.79 4,118.67 82.373 881.33 Subtotal: 319,536.00 319,617.00 17,758.81 287,004.39 89.796 32,612.61 135-55070-027-000 Independent Labor 840.00 840.00 37.50 288.75 34.375 551.25 135-55075-027-000 Records Management 500.00 500.00 500.00 135-55160-027-000 Professional Outside Services 176,870.00 191,093.00 191,092.23 100.000 .77 Subtotal: 178,210.00 192,433.00 37.50 191,380.98 99.453 1,052.02 135-60005-027-000 Telephone 300.00 300.00 22.74 221.85 73.950 78.15 135-60010-027-000 Communications/Pagers/Mobiles 2,420.00 2,420.00 164.30 1,454.09 60.086 965.91 135-60035-027-000 Postage 2,400.00 44.00 1,891.74 78.823 508.26 135-60066-027-000 Publications/Books/Subscripts 450.00 450.00 17.00 371.15 82.478 78.85 135-60070-027-000 Dues & Memberships 1,742.00 1,742.00 827.05 47.477 914.95 135-60075-027-000 Meetings 312.00 312.00 42.44 13.603 269.56 135-60080-027-000 Schools & Training 2,555.00 2,555.00 1,405.00 54.990 1,150.00 135-60100-027-000 Travel & per diem 3,851.00 3,851.00 41.85 1,115.87 28.976 2,735.13 135-60115-027-000 Elections 2,500.00 2,500.00 1,918.83 2,531.32 101.253 31.32- 135-60125-027-000 Advertising 4,700.00 4,700.00 258.06 258.06 5.491 4,441.94 135-60245-027-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60270-027-000 4th of July Celebration 10,000.00 10,500.00 133.51 10,238.51 97.510 261.49 135-60360-027-000 Furniture/Equipment < $5000 2,225.00 2,225.00 1,616.99 72.674 608.01 Subtotal: 31,155.00 34,055.00 2,600.29 21,974.07 64.525 12,080.93 135-65085-027-000 Office Supplies 2,450.00 2,450.00 290.35 2,671.63 109.046 221.63- 135-65105-027-000 Printing 515.00 750.00 1,155.63 1,745.08 232.677 995.08- Subtotal: 2,965.00 3,200.00 1,445.98 4,416.71 138.022 1,216.71- . glbase_tbam rgonzale Trophy Club Entities Page 14 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Program number: 531,866.00 549,305.00 21,842.58 504,776.15 91.894 44,528.85 Department number: Manager's Office 531,866.00 549,305.00 21,842.58 504,776.15 91.894 44,528.85 . glbase_tbam rgonzale Trophy Club Entities Page 15 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50070-028-000 Employee Relations 1,967.00 1,967.00 1,478.72 75.176 488.28 135-50075-028-000 Tuition Reimbursement 1,561.00 1,561.00 219.42 14.056 1,341.58 Subtotal: 3,528.00 3,528.00 1,698.14 48.133 1,829.86 135-60005-028-000 Telephone 28.00 28.00 28.00 135-60035-028-000 Postage 106.00 106.00 22.23 20.972 83.77 135-60066-028-000 Publications/Books/Subscripts 485.00 485.00 485.00 135-60070-028-000 Dues & Memberships 555.00 555.00 555.00 135-60075-028-000 Meetings 138.00 138.00 138.00 135-60080-028-000 Schools & Training 594.00 594.00 594.00 135-60100-028-000 Travel & per diem 8.00 135-60110-028-000 Physicals/Testing 1,560.00 1,560.00 165.00 10.577 1,395.00 Subtotal: 3,474.00 3,466.00 187.23 5.402 3,278.77 135-65085-028-000 Office Supplies 437.00 437.00 437.00 135-65105-028-000 Printing 116.00 116.00 116.00 Subtotal: 553.00 553.00 553.00 Program number: 7,555.00 7,547.00 1,885.37 24.982 5,661.63 Department number: Human Resources 7,555.00 7,547.00 1,885.37 24.982 5,661.63 . glbase_tbam rgonzale Trophy Club Entities Page 16 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-029-000 Salaries & Wages 94,404.00 94,404.00 6,002.40 66,051.42 69.967 28,352.58 135-50010-029-000 Overtime 1,000.00 1,000.00 946.28 94.628 53.72 135-50016-029-000 Longevity 1,823.00 1,823.00 1,822.50 99.973 .50 135-50020-029-000 Retirement 13,612.00 13,612.00 829.54 9,857.22 72.416 3,754.78 135-50026-029-000 Medical Insurance 11,060.00 11,060.00 410.70 5,774.58 52.211 5,285.42 135-50027-029-000 Dental Insurance 773.00 773.00 49.02 575.95 74.508 197.05 135-50028-029-000 Vision Insurance 207.00 207.00 6.76 87.67 42.353 119.33 135-50029-029-000 Life Insurance & Other 567.00 567.00 567.00 135-50030-029-000 Social Security Taxes 5,386.00 5,386.00 345.84 3,987.89 74.042 1,398.11 135-50035-029-000 Medicare Taxes 1,260.00 1,260.00 80.88 932.65 74.020 327.35 135-50040-029-000 Unemployment Taxes 284.00 284.00 79.54 28.007 204.46 135-50045-029-000 Workman's Compensation 235.00 235.00 211.00 89.787 24.00 Subtotal: 130,611.00 130,611.00 7,725.14 90,326.70 69.157 40,284.30 135-55160-029-000 Professional Outside Services 5,000.00 5,000.00 1,105.50 22.110 3,894.50 Subtotal: 5,000.00 5,000.00 1,105.50 22.110 3,894.50 135-60005-029-000 Telephone 103.00 103.00 10.39 66.42 64.485 36.58 135-60010-029-000 Communications/Pagers/Mobiles 683.00 683.00 51.31 460.65 67.445 222.35 135-60035-029-000 Postage 700.00 700.00 28.75 259.64 37.091 440.36 135-60040-029-000 Service Charges & Fees 79.00 79.00 32.50 41.139 46.50 135-60066-029-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-029-000 Dues & Memberships 660.00 660.00 660.00 135-60075-029-000 Meetings 300.00 300.00 22.00 7.333 278.00 135-60080-029-000 Schools & Training 2,000.00 2,000.00 225.00 11.250 1,775.00 135-60100-029-000 Travel & per diem 1,500.00 40.00 27.81 69.525 12.19 135-60125-029-000 Advertising 1,210.00 1,210.00 1,210.00 135-60245-029-000 Miscellaneous Expenses 200.00 200.00 200.00 Subtotal: 7,935.00 6,475.00 90.45 1,094.02 16.896 5,380.98 135-65085-029-000 Office Supplies 849.00 849.00 148.52 17.494 700.48 135-65105-029-000 Printing 515.00 515.00 515.00 Subtotal: 1,364.00 1,364.00 148.52 10.889 1,215.48 Program number: 144,910.00 143,450.00 7,815.59 92,674.74 64.604 50,775.26 Department number: Finance 144,910.00 143,450.00 7,815.59 92,674.74 64.604 50,775.26 . glbase_tbam rgonzale Trophy Club Entities Page 17 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55030-033-000 Software & Support 64,149.00 64,149.00 2,832.85 59,782.63 93.193 4,366.37 135-55070-033-000 Independent Labor 1,650.00 1,650.00 375.00 22.727 1,275.00 Subtotal: 65,799.00 65,799.00 2,832.85 60,157.63 91.426 5,641.37 135-60005-033-000 Telephone 6,540.00 6,540.00 763.09 6,824.19 104.345 284.19- 135-60235-033-000 Security 1,350.00 1,350.00 276.25 682.85 50.581 667.15 Subtotal: 7,890.00 7,890.00 1,039.34 7,507.04 95.146 382.96 135-65055-033-000 Hardware 83,238.00 83,238.00 1,768.91 72,352.96 86.923 10,885.04 135-65085-033-000 Office Supplies 371.00 371.00 25.10 360.00 97.035 11.00 135-65090-033-000 Printer Supplies & Maintenance 5,732.00 5,732.00 2,129.79 5,702.67 99.488 29.33 Subtotal: 89,341.00 89,341.00 3,923.80 78,415.63 87.771 10,925.37 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 262.95 2,317.75 67.181 1,132.25 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 262.95 2,317.75 7.634 28,043.25 Program number: 193,391.00 193,391.00 8,058.94 148,398.05 76.735 44,992.95 Department number: Information Systems 193,391.00 193,391.00 8,058.94 148,398.05 76.735 44,992.95 . glbase_tbam rgonzale Trophy Club Entities Page 18 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-037-000 Salaries & Wages 31,512.00 135-50020-037-000 Retirement 4,412.00 135-50026-037-000 Medical Insurance 9,027.00 135-50027-037-000 Dental Insurance 549.00 135-50028-037-000 Vision Insurance 138.00 135-50029-037-000 Life Insurance & Other 228.00 135-50030-037-000 Social Security Taxes 1,954.00 135-50035-037-000 Medicare Taxes 457.00 46.85 46.85- 135-50040-037-000 Unemployment Taxes 189.00 135-50045-037-000 Workman's Compensation 861.00 861.00 861.00 100.000 135-50060-037-000 Pre-emp Physicals/Testing 250.00 Subtotal: 49,577.00 861.00 907.85 105.441 46.85- 135-55100-037-000 Building Maint & Supplies 5,000.00 20,478.00 4.80 1,384.28 6.760 19,093.72 135-55120-037-000 Cleaning Services 25,000.00 2,017.17 15,105.97 60.424 9,894.03 Subtotal: 5,000.00 45,478.00 2,021.97 16,490.25 36.260 28,987.75 135-60020-037-000 Electricity 21,940.00 21,940.00 1,084.59 9,319.33 42.476 12,620.67 135-60025-037-000 Water 1,093.00 1,093.00 176.16 557.40 50.997 535.60 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 10,985.10 83.334 2,196.90 135-60055-037-000 Insurance 32,635.00 32,635.00 3,243.76 33,630.49 103.050 995.49- 135-60360-037-000 Furniture/Equipment < $5000 2,500.00 4,750.00 4,750.00 Subtotal: 71,350.00 73,600.00 5,603.02 54,492.32 74.038 19,107.68 135-65095-037-000 Maintenance Supplies 2,205.00 2,205.00 876.65 39.757 1,328.35 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 80.03 8.003 919.97 Subtotal: 3,205.00 3,205.00 956.68 29.850 2,248.32 Program number: 129,132.00 123,144.00 7,624.99 72,847.10 59.156 50,296.90 Department number: Facilities Maintenance 129,132.00 123,144.00 7,624.99 72,847.10 59.156 50,296.90 . glbase_tbam rgonzale Trophy Club Entities Page 19 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-038-000 Salaries & Wages 84,946.00 84,946.00 7,590.63 66,333.38 78.089 18,612.62 135-50010-038-000 Overtime 2,000.00 2,000.00 24.99 300.08 15.004 1,699.92 135-50016-038-000 Longevity 220.00 220.00 220.00 100.000 135-50020-038-000 Retirement 12,203.00 12,203.00 930.60 9,392.40 76.968 2,810.60 135-50026-038-000 Medical Insurance 12,321.00 12,321.00 924.37 8,949.84 72.639 3,371.16 135-50027-038-000 Dental Insurance 1,026.00 1,026.00 91.66 888.08 86.558 137.92 135-50028-038-000 Vision Insurance 260.00 260.00 21.63 209.47 80.565 50.53 135-50029-038-000 Life Insurance & Other 604.00 604.00 604.00 135-50030-038-000 Social Security Taxes 5,404.00 5,404.00 436.39 3,911.26 72.377 1,492.74 135-50035-038-000 Medicare Taxes 1,264.00 1,264.00 102.07 867.91 68.664 396.09 135-50040-038-000 Unemployment Taxes 473.00 473.00 25.57 216.75 45.825 256.25 135-50045-038-000 Workman's Compensation 211.00 211.00 235.00 111.374 24.00- 135-50060-038-000 Pre-emp Physicals/Testing 35.00 8.97 26.47 75.629 8.53 Subtotal: 120,932.00 120,967.00 10,156.88 91,550.64 75.682 29,416.36 135-55070-038-000 Independent Labor 800.00 800.00 800.00 135-55205-038-000 Utility Billing Contract 11,000.00 11,000.00 966.59 8,738.22 79.438 2,261.78 Subtotal: 11,800.00 11,800.00 966.59 8,738.22 74.053 3,061.78 135-60005-038-000 Telephone 100.00 100.00 1.64 56.66 56.660 43.34 135-60010-038-000 Communications/Pagers/Mobiles 472.00 472.00 36.46 326.14 69.097 145.86 135-60035-038-000 Postage 18,000.00 18,000.00 1,527.69 12,716.73 70.649 5,283.27 135-60040-038-000 Service Charges & Fees 18,000.00 29,340.00 1,631.07 19,799.37 67.483 9,540.63 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 225.00 28.125 575.00 135-60100-038-000 Travel & per diem 605.00 605.00 605.00 135-60130-038-000 Reg Assessment Fee (5%) 22,500.00 25,100.00 25,071.20 99.885 28.80 135-60245-038-000 Miscellaneous Expenses 200.00 200.00 .01 .005 199.99 Subtotal: 60,748.00 74,688.00 3,196.86 58,195.11 77.918 16,492.89 135-65085-038-000 Office Supplies 700.00 700.00 670.19 95.741 29.81 135-65105-038-000 Printing 3,250.00 3,250.00 3,250.00 Subtotal: 3,950.00 3,950.00 670.19 16.967 3,279.81 Program number: 197,430.00 211,405.00 14,320.33 159,154.16 75.284 52,250.84 Department number: Utility Billing 197,430.00 211,405.00 14,320.33 159,154.16 75.284 52,250.84 . glbase_tbam rgonzale Trophy Club Entities Page 20 10:45 08/08/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 55,000.00 88,000.00 4,321.75 71,476.79 81.224 16,523.21 135-55055-039-000 Auditing 20,200.00 20,200.00 20,200.00 100.000 135-55060-039-000 Appraisal 20,000.00 20,000.00 13,615.43 68.077 6,384.57 135-55065-039-000 Tax Admin Fees 3,629.00 3,629.00 2,470.09 68.065 1,158.91 Subtotal: 98,829.00 131,829.00 4,321.75 107,762.31 81.744 24,066.69 135-60344-039-000 Intergov Trans Out (Fire CIP) 2,278.00 2,277.85 99.993 .15 Subtotal: 2,278.00 2,277.85 99.993 .15 Program number: 98,829.00 134,107.00 4,321.75 110,040.16 82.054 24,066.84 Department number: Non Departmental 98,829.00 134,107.00 4,321.75 110,040.16 82.054 24,066.84 Expenditures Subtotal ----------- 6,094,978.00 7,112,200.00 417,045.36 4,912,556.09 69.072 2,199,643.91 Fund number: 135 MUD 1 General Fund 370,880.00- 316,960.78- 787,729.40- 212.395 416,849.40 . glpdatb2 rgonzale Trophy Club Entities Page 15 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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 1442 07/02/2012 Property Taxes/Assessments (96,458.76) (57.54) (96,516.30) GL 1443 07/03/2012 Property Tax/Assessments (15.61) (96,531.91) GL 1444 07/05/2012 Property Tax/Assessments (10.99) (96,542.90) GL 1445 07/06/2012 Property Tax/Assessments (7.70) (96,550.60) GL 1446 07/09/2012 Property Tax/Assessments (17.91) (96,568.51) GL 1447 07/10/2012 Property Tax/Assessments (26.63) (96,595.14) GL 1448 07/12/2012 Property Tax/Assessments (22.61) (96,617.75) GL 1449 07/13/2012 Property Tax/Assessments (20.59) (96,638.34) GL 1450 07/16/2012 Property Tax/Assessments (42.91) (96,681.25) GL 1451 07/17/2012 Property Tax/Assessments (5.76) (96,687.01) GL 1453 07/20/2012 Property Tax/Assessments (10.37) (96,697.38) GL 1454 07/23/2012 Property Tax/Assessments (8.47) (96,705.85) GL 1455 07/24/2012 Property Tax/Assessments (16.57) (96,722.42) GL 1456 07/25/2012 Property Tax/Assessments (3.33) (96,725.75) GL 1457 07/27/2012 Property Tax/Assessments (6.85) (96,732.60) GL 1458 07/30/2012 Property Tax/Assessments (20.84) (96,753.44) GL 1459 07/31/2012 Property Tax/Assessments (40.15) (96,793.59) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (334.83) (96,793.59) ** (97,495.00) Budgeted (701.41) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1442 07/02/2012 Property Taxes/Assessments 657.55 (56.55) 601.00 GL 1449 07/13/2012 Property Tax/Assessments (8.62) 592.38 GL 1450 07/16/2012 Property Tax/Assessments (32.19) 560.19 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (97.36) 560.19 ** (451.00) Budgeted (1,011.19) Remaining ########## Account: 135-40015-000-000 Property Taxes/P & I 1442 07/02/2012 Property Taxes/Assessments (113.53) (5.81) (119.34) GL 1443 07/03/2012 Property Tax/Assessments (1.58) (120.92) GL 1447 07/10/2012 Property Tax/Assessments (2.79) (123.71) GL 1448 07/12/2012 Property Tax/Assessments (.54) (124.25) GL 1449 07/13/2012 Property Tax/Assessments (5.67) (129.92) GL 1450 07/16/2012 Property Tax/Assessments (22.52) (152.44) GL 1455 07/24/2012 Property Tax/Assessments (1.21) (153.65) GL 1455 07/24/2012 Property Tax/Assessments (9.81) (163.46) GL 1457 07/27/2012 Property Tax/Assessments (.10) (163.56) GL 1457 07/27/2012 Property Tax/Assessments (.81) (164.37) GL . glpdatb2 rgonzale Trophy Club Entities Page 16 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1459 07/31/2012 Property Tax/Assessments (113.53) (2.66) (167.03) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (53.50) (167.03) ** (200.00) Budgeted (32.97) Remaining 84 % Used Account: 135-43215-000-000 Insurance Settlement (3,999.00) .00 (3,999.00) _______________ Account: 135-43215-000-000 Insurance Settlement Totals: .00 (3,999.00) ** (3,999.00) Budgeted .00 Remaining 100 % Used Account: 135-47000-000-000 Water 1434 07/31/2012 UB 7/31/2012 Billing UB20120731-20120731 User: (1,094,329.59) (264,836.10) (1,359,165.69) UB _______________ Account: 135-47000-000-000 Water Totals: (264,836.10) (1,359,165.69) ** (1,990,800.00) Budgeted (631,634.31) Remaining 68 % Used Account: 135-47005-000-000 Sewer 1434 07/31/2012 UB 7/31/2012 Billing UB20120731-20120731 User: (729,114.46) (109,324.33) (838,438.79) UB _______________ Account: 135-47005-000-000 Sewer Totals: (109,324.33) (838,438.79) ** (1,325,000.00) Budgeted (486,561.21) Remaining 63 % Used Account: 135-47010-000-000 Commercial Water 1367 07/20/2012 July A/P Refund overcharge on Ind Park (480,984.45) 5,757.27 (475,227.18) TOWN OF TROPHY CLUB 31599 AP 1434 07/31/2012 UB 7/31/2012 Billing UB20120731-20120731 User: (133,434.35) (608,661.53) UB _______________ Account: 135-47010-000-000 Commercial Water Totals: (127,677.08) (608,661.53) ** (825,000.00) Budgeted (216,338.47) Remaining 74 % Used Account: 135-47015-000-000 Commercial Sewer 1367 07/20/2012 July A/P Refund overcharge on Ind Park (207,252.29) 5,759.77 (201,492.52) TOWN OF TROPHY CLUB 31599 AP 1434 07/31/2012 UB 7/31/2012 Billing UB20120731-20120731 User: (30,781.06) (232,273.58) UB _______________ Account: 135-47015-000-000 Commercial Sewer Totals: (25,021.29) (232,273.58) ** (360,000.00) Budgeted (127,726.42) Remaining 65 % Used Account: 135-47020-000-000 Standby . glpdatb2 rgonzale Trophy Club Entities Page 17 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1434 07/31/2012 UB 7/31/2012 Billing UB20120731-20120731 User: (517.35) (66.00) (583.35) UB _______________ Account: 135-47020-000-000 Standby Totals: (66.00) (583.35) ** (775.00) Budgeted (191.65) Remaining 75 % Used Account: 135-47025-000-000 Penalties 1376 07/23/2012 UB 7/23/12 Penalties UB20120723-20120723 User: (36,146.19) (2,571.32) (38,717.51) UB 1378 07/23/2012 UB 7/23/12 Penalties UB20120723-20120723 User: (6,187.87) (44,905.38) UB 1432 07/31/2012 UB 7/31/12 Penalty Adjustments UB20120731-20120731 User: 2,769.24 (42,136.14) UB 1434 07/31/2012 UB 7/31/2012 Billing UB20120731-20120731 User: (2,791.18) (44,927.32) UB _______________ Account: 135-47025-000-000 Penalties Totals: (8,781.13) (44,927.32) ** (45,000.00) Budgeted (72.68) Remaining 100 % Used Account: 135-47030-000-000 Service Charges 1315 07/02/2012 UB 7/2/12 Adjustments UB20120702-20120702 User: (9,029.48) (25.00) (9,054.48) UB 1327 07/10/2012 UB 7/10/12 Disconnect Fees UB20120710-20120710 User: (425.00) (9,479.48) UB 1419 07/20/2012 UB 7/20/12 Adjustments UB20120720-20120720 User: (25.00) (9,504.48) UB 1434 07/31/2012 UB 7/31/2012 Billing UB20120731-20120731 User: (3.00) (9,507.48) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (478.00) (9,507.48) ** (15,000.00) Budgeted (5,492.52) Remaining 63 % Used Account: 135-47035-000-000 Plumbing Inspections 1464 07/10/2012 Permits 7/9/12 (1,400.00) (200.00) (1,600.00) GL 1469 07/19/2012 Permits 7/18/12 (50.00) (1,650.00) GL 1473 07/26/2012 Permits 7/26/12 (50.00) (1,700.00) GL 1474 07/30/2012 Permits 7/27/12 (100.00) (1,800.00) GL _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (400.00) (1,800.00) ** (1,500.00) Budgeted 300.00 Remaining 120 % Used Account: 135-47045-000-000 Sewer Inspections 1464 07/10/2012 Permits 7/9/12 (4,200.00) (600.00) (4,800.00) GL 1469 07/19/2012 Permits 7/18/12 (150.00) (4,950.00) GL 1473 07/26/2012 Permits 7/26/12 (150.00) (5,100.00) GL 1474 07/30/2012 Permits 7/27/12 (300.00) (5,400.00) GL _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (1,200.00) (5,400.00) ** (4,500.00) Budgeted 900.00 Remaining 120 % Used . glpdatb2 rgonzale Trophy Club Entities Page 18 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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-47070-000-000 TCCC Effluent Charges 1477 07/25/2012 TCCC Effluent/June (30,100.99) (10,926.50) (41,027.49) GL _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (10,926.50) (41,027.49) ** (75,000.00) Budgeted (33,972.51) Remaining 55 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 1410 07/20/2012 UB 7/20/12 Adjustments UB20120720-20120720 User: (27,834.53) (200.00) (28,034.53) UB 1434 07/31/2012 UB 7/31/2012 Billing UB20120731-20120731 User: (4,963.83) (32,998.36) UB _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: (5,163.83) (32,998.36) ** (41,595.00) Budgeted (8,596.64) Remaining 79 % Used Account: 135-47405-000-000 Out of District Sewer 1434 07/31/2012 UB 7/31/2012 Billing UB20120731-20120731 User: (8,367.59) (1,352.47) (9,720.06) UB _______________ Account: 135-47405-000-000 Out of District Sewer Totals: (1,352.47) (9,720.06) ** (11,807.00) Budgeted (2,086.94) Remaining 82 % Used Account: 135-47410-000-000 Out of Dist/Portable Penalties 1376 07/23/2012 UB 7/23/12 Penalties UB20120723-20120723 User: (34.03) (2.34) (36.37) UB 1378 07/23/2012 UB 7/23/12 Penalties UB20120723-20120723 User: (5.08) (41.45) UB 1432 07/31/2012 UB 7/31/12 Penalty Adjustments UB20120731-20120731 User: 2.34 (39.11) UB 1434 07/31/2012 UB 7/31/2012 Billing UB20120731-20120731 User: (2.34) (41.45) UB _______________ Account: 135-47410-000-000 Out of Dist/Portable Penalties Totals: (7.42) (41.45) ** (100.00) Budgeted (58.55) Remaining 41 % Used Account: 135-47600-000-000 PID #1 Water 1434 07/31/2012 UB 7/31/2012 Billing UB20120731-20120731 User: (350,539.67) (83,924.36) (434,464.03) UB _______________ Account: 135-47600-000-000 PID #1 Water Totals: (83,924.36) (434,464.03) ** (500,000.00) Budgeted (65,535.97) Remaining 87 % Used Account: 135-47605-000-000 PID #1 Sewer 1434 07/31/2012 UB 7/31/2012 Billing UB20120731-20120731 User: (179,477.50) (32,097.50) (211,575.00) UB _______________ Account: 135-47605-000-000 PID #1 Sewer Totals: (32,097.50) (211,575.00) ** (250,000.00) Budgeted (38,425.00) Remaining 85 % Used . glpdatb2 rgonzale Trophy Club Entities Page 19 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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-48005-000-000 Utility Fees 1464 07/10/2012 Permits 7/9/12 (502,180.00) (6,900.00) (509,080.00) GL 1465 07/12/2012 Permits 7/11/12 (2,300.00) (511,380.00) GL 1466 07/13/2012 Permits 7/12/12 (9,200.00) (520,580.00) GL 1467 07/16/2012 Permits 7/13/12 (2,300.00) (522,880.00) GL 1468 07/17/2012 Permits 7/16/12 (9,200.00) (532,080.00) GL 1470 07/20/2012 Permits 7/19/12 (4,600.00) (536,680.00) GL 1471 07/24/2012 Permits 7/23/12 (2,300.00) (538,980.00) GL 1472 07/26/2012 Permits 7/25/12 (9,200.00) (548,180.00) GL 1474 07/30/2012 Permits 7/27/12 (2,300.00) (550,480.00) GL _______________ Account: 135-48005-000-000 Utility Fees Totals: (48,300.00) (550,480.00) ** (621,000.00) Budgeted (70,520.00) Remaining 89 % Used Account: 135-49005-000-000 Loan Proceeds (1,100,000.00) .00 (1,100,000.00) _______________ Account: 135-49005-000-000 Loan Proceeds Totals: .00 (1,100,000.00) ** (1,100,000.00) Budgeted .00 Remaining 100 % Used Account: 135-49010-000-000 Interest Income 1480 07/31/2012 July Bank Interest (3,953.66) (197.44) (4,151.10) GL 1480 07/31/2012 July Bank Interest (390.42) (4,541.52) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (587.86) (4,541.52) ** (4,500.00) Budgeted 41.52 Remaining 101 % Used Account: 135-49016-000-000 Cell Tower Revenue 1476 07/25/2012 AT&T Antenna lease (7,623.00) (847.00) (8,470.00) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (847.00) (8,470.00) ** (10,164.00) Budgeted (1,694.00) Remaining 83 % Used Account: 135-49018-000-000 Building Rent Income 1478 07/25/2012 Town-July postage, barn rent (5,249.97) (583.33) (5,833.30) GL _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,833.30) ** (7,000.00) Budgeted (1,166.70) Remaining 83 % Used . glpdatb2 rgonzale Trophy Club Entities Page 20 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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-49025-000-000 Auction Sales (4,305.00) .00 (4,305.00) _______________ Account: 135-49025-000-000 Auction Sales Totals: .00 (4,305.00) ** (4,305.00) Budgeted .00 Remaining 100 % Used Account: 135-49030-000-000 Vending Revenue (439.24) .00 (439.24) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (439.24) ** (600.00) Budgeted (160.76) Remaining 73 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (103,966.00) Budgeted (103,966.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1464 07/10/2012 Permits 7/9/12 (77,744.80) (2,044.00) (79,788.80) GL 1465 07/12/2012 Permits 7/11/12 (292.00) (80,080.80) GL 1466 07/13/2012 Permits 7/12/12 (1,168.00) (81,248.80) GL 1467 07/16/2012 Permits 7/13/12 (292.00) (81,540.80) GL 1468 07/17/2012 Permits 7/16/12 (1,168.00) (82,708.80) GL 1469 07/19/2012 Permits 7/18/12 (292.00) (83,000.80) GL 1470 07/20/2012 Permits 7/19/12 (1,854.00) (84,854.80) GL 1471 07/24/2012 Permits 7/23/12 (292.00) (85,146.80) GL 1472 07/26/2012 Permits 7/25/12 (1,168.00) (86,314.80) GL 1473 07/26/2012 Permits 7/26/12 (292.00) (86,606.80) GL 1474 07/30/2012 Permits 7/27/12 (3,084.25) (89,691.05) GL _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (11,946.25) (89,691.05) ** (77,800.00) Budgeted 11,891.05 Remaining 115 % Used Account: 135-49900-000-000 Miscellaneous Income (5,418.82) .00 (5,418.82) _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: .00 (5,418.82) ** (5,400.00) Budgeted 18.82 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club Entities Page 21 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 7/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-49905-000-000 Gas Well Revenue (123.00) .00 (123.00) _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 (123.00) ** (123.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (5,700,285.49) ** (7,483,080.00) Budgeted (1,782,794.51) Remaining 76 % Used . glpdatb2 rgonzale Trophy Club Entities Page 22 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/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 1392 07/06/2012 7/6 Payroll 113,206.12 6,416.64 119,622.76 GL 1391 07/20/2012 7/20 Payroll 6,416.66 126,039.42 GL _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 12,833.30 126,039.42 ** 160,600.00 Budgeted 34,560.58 Remaining 78 % Used Account: 135-50010-010-000 Overtime 1392 07/06/2012 7/6 Payroll 12,410.46 885.70 13,296.16 GL 1392 07/06/2012 7/6 Payroll 160.00 13,456.16 GL 1391 07/20/2012 7/20 Payroll 515.98 13,972.14 GL 1391 07/20/2012 7/20 Payroll 160.00 14,132.14 GL _______________ Account: 135-50010-010-000 Overtime Totals: 1,721.68 14,132.14 ** 13,250.00 Budgeted (882.14) Remaining 107 % 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 1391 07/20/2012 7/20 Payroll 1,050.00 150.00 1,200.00 GL _______________ Account: 135-50017-010-000 Certification Totals: 150.00 1,200.00 ** 1,800.00 Budgeted 600.00 Remaining 67 % Used Account: 135-50020-010-000 Retirement 1392 07/06/2012 7/6 Payroll 18,449.39 1,031.29 19,480.68 GL 1391 07/20/2012 7/20 Payroll 1,000.93 20,481.61 GL _______________ Account: 135-50020-010-000 Retirement Totals: 2,032.22 20,481.61 ** 25,508.00 Budgeted 5,026.39 Remaining 80 % Used Account: 135-50026-010-000 Medical Insurance 1392 07/06/2012 7/6 Payroll 15,443.69 821.40 16,265.09 GL 1391 07/20/2012 7/20 Payroll 821.40 17,086.49 GL . glpdatb2 rgonzale Trophy Club Entities Page 23 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,642.80 17,086.49 ** 22,607.00 Budgeted 5,520.51 Remaining 76 % Used Account: 135-50027-010-000 Dental Insurance 1392 07/06/2012 7/6 Payroll 1,134.34 62.60 1,196.94 GL 1391 07/20/2012 7/20 Payroll 62.60 1,259.54 GL _______________ Account: 135-50027-010-000 Dental Insurance Totals: 125.20 1,259.54 ** 2,169.00 Budgeted 909.46 Remaining 58 % Used Account: 135-50028-010-000 Vision Insurance 1392 07/06/2012 7/6 Payroll 276.85 15.88 292.73 GL 1391 07/20/2012 7/20 Payroll 15.88 308.61 GL _______________ Account: 135-50028-010-000 Vision Insurance Totals: 31.76 308.61 ** 576.00 Budgeted 267.39 Remaining 54 % 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 1392 07/06/2012 7/6 Payroll 7,845.57 450.44 8,296.01 GL 1391 07/20/2012 7/20 Payroll 436.82 8,732.83 GL _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 887.26 8,732.83 ** 12,000.00 Budgeted 3,267.17 Remaining 73 % Used Account: 135-50035-010-000 Medicare Taxes 1392 07/06/2012 7/6 Payroll 1,834.84 105.34 1,940.18 GL 1391 07/20/2012 7/20 Payroll 102.16 2,042.34 GL _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 207.50 2,042.34 ** 2,700.00 Budgeted 657.66 Remaining 76 % Used . glpdatb2 rgonzale Trophy Club Entities Page 24 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-010-000 Unemployment Taxes 288.00 .00 288.00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 288.00 ** 945.00 Budgeted 657.00 Remaining 30 % Used Account: 135-50045-010-000 Workman's Compensation 5,581.00 .00 5,581.00 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 5,581.00 ** 5,581.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations 118.64 .00 118.64 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 118.64 ** 350.00 Budgeted 231.36 Remaining 34 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1388 07/24/2012 July A/P PCards - McMahon 14,563.71 160.32 14,724.03 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - McMahon (15.00) 14,709.03 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - McMahon 212.87 14,921.90 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - McMahon 165.88 15,087.78 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - McMahon 859.90 15,947.68 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,383.97 15,947.68 ** 29,500.00 Budgeted 13,552.32 Remaining 54 % Used . glpdatb2 rgonzale Trophy Club Entities Page 25 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090-010-000 Vehicle Maintenance 1388 07/24/2012 July A/P PCards - McMahon 3,676.33 14.50 3,690.83 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Womack 29.98 3,720.81 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 44.48 3,720.81 ** 3,380.00 Budgeted (340.81) Remaining 110 % Used Account: 135-55100-010-000 Building Maint & Supplies 1388 07/24/2012 July A/P June PCards - Womack 471.85 2,771.42 3,243.27 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-55100-010-000 Building Maint & Supplies Totals: 2,771.42 3,243.27 ** 750.00 Budgeted (2,493.27) Remaining 432 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 464.49 .00 464.49 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 464.49 ** 2,900.00 Budgeted 2,435.51 Remaining 16 % Used Account: 135-55135-010-000 Lab Analysis 1367 07/20/2012 July A/P Lab analysis 1,725.00 260.00 1,985.00 TARRANT CTY PUBLIC HEALTH LAB 31652 AP 1388 07/24/2012 July A/P June PCards - Womack 160.95 2,145.95 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 420.95 2,145.95 ** 4,500.00 Budgeted 2,354.05 Remaining 48 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1388 07/24/2012 July A/P Mobiles 1,362.36 176.46 1,538.82 VERIZON WIRELESS 31659 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 176.46 1,538.82 ** 2,100.00 Budgeted 561.18 Remaining 73 % Used Account: 135-60020-010-000 Electricity 1367 07/20/2012 July A/P PID Elevated Tank 6/13-7/13 47,976.30 220.75 48,197.05 HUDSON ENERGY 31593 AP 1400 07/26/2012 July A/P Electricity 6/14-7/16 16,773.18 64,970.23 HUDSON ENERGY 31664 AP 1400 07/26/2012 July A/P Electricity 6/14-7/16 2,852.76 67,822.99 HUDSON ENERGY 31664 AP _______________ Account: 135-60020-010-000 Electricity Totals: 19,846.69 67,822.99 ** 100,000.00 Budgeted 32,177.01 Remaining 68 % Used . glpdatb2 rgonzale Trophy Club Entities Page 26 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60035-010-000 Postage 687.40 .00 687.40 _______________ Account: 135-60035-010-000 Postage Totals: .00 687.40 ** 688.00 Budgeted .60 Remaining 100 % Used Account: 135-60050-010-000 Bad Debt Expense 1433 07/31/2012 UB 7/31/12 Write Offs UB20120731-20120731 User: 6,252.82 6,252.82 UB _______________ Account: 135-60050-010-000 Bad Debt Expense Totals: 6,252.82 6,252.82 ** 4,200.00 Budgeted (2,052.82) Remaining 149 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 85.00 .00 85.00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 85.00 ** 85.00 Budgeted .00 Remaining 100 % Used Account: 135-60070-010-000 Dues & Memberships 111.00 .00 111.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 111.00 ** 150.00 Budgeted 39.00 Remaining 74 % Used Account: 135-60080-010-000 Schools & Training 1,082.00 .00 1,082.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 1,082.00 ** 2,800.00 Budgeted 1,718.00 Remaining 39 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem . glpdatb2 rgonzale Trophy Club Entities Page 27 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1392 07/06/2012 7/6 Payroll 1,035.14 48.84 1,083.98 GL 1391 07/20/2012 7/20 Payroll 102.68 1,186.66 GL 1388 07/24/2012 July A/P Tolls 20.22 1,206.88 NTTA 31639 AP _______________ Account: 135-60100-010-000 Travel & per diem Totals: 171.74 1,206.88 ** 3,200.00 Budgeted 1,993.12 Remaining 38 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60135-010-000 Annual Permit Fee 7,965.75 .00 7,965.75 _______________ Account: 135-60135-010-000 Annual Permit Fee Totals: .00 7,965.75 ** 8,000.00 Budgeted 34.25 Remaining 100 % Used Account: 135-60150-010-000 Wholesale Water 978,469.06 .00 978,469.06 _______________ Account: 135-60150-010-000 Wholesale Water Totals: .00 978,469.06 ** 1,720,000.00 Budgeted 741,530.94 Remaining 57 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 1388 07/24/2012 July A/P PCards - McMahon 380.38 27.91 408.29 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-60280-010-000 Property Maintenance Totals: 27.91 408.29 ** 2,200.00 Budgeted 1,791.71 Remaining 19 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance . glpdatb2 rgonzale Trophy Club Entities Page 28 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1388 07/24/2012 July A/P PCards - McMahon 396.97 396.97 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - McMahon (99.00) 297.97 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - McMahon 169.00 466.97 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey 60.47 527.44 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey 23.32 550.76 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 550.76 550.76 ** 2,000.00 Budgeted 1,449.24 Remaining 28 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 299.99 .00 299.99 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 299.99 ** 1,500.00 Budgeted 1,200.01 Remaining 20 % Used Account: 135-65005-010-000 Fuel & Lube 1397 07/01/2012 June Gas log 9,698.62 1,522.70 11,221.32 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,522.70 11,221.32 ** 15,216.00 Budgeted 3,994.68 Remaining 74 % Used Account: 135-65010-010-000 Uniforms 1,400.99 .00 1,400.99 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,400.99 ** 3,690.00 Budgeted 2,289.01 Remaining 38 % Used Account: 135-65030-010-000 Chemicals 1388 07/24/2012 July A/P PCards - McMahon 2,858.11 118.25 2,976.36 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Womack 312.26 3,288.62 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 430.51 3,288.62 ** 5,000.00 Budgeted 1,711.38 Remaining 66 % Used Account: 135-65035-010-000 Small Tools 203.00 .00 203.00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 203.00 ** 1,500.00 Budgeted 1,297.00 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club Entities Page 29 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65040-010-000 Safety Equipment 1388 07/24/2012 July A/P Bug Spray for Field personnel 347.00 39.14 386.14 COSTCO WHOLESALE 31615 AP 1388 07/24/2012 July A/P PCards - McMahon 63.45 449.59 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-65040-010-000 Safety Equipment Totals: 102.59 449.59 ** 1,000.00 Budgeted 550.41 Remaining 45 % Used Account: 135-65050-010-000 Meter Expense 1388 07/24/2012 July A/P June PCards - Womack 92,842.07 854.50 93,696.57 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 854.50 93,696.57 ** 100,000.00 Budgeted 6,303.43 Remaining 94 % Used Account: 135-65055-010-000 Hardware .00 .00 _______________ Account: 135-65055-010-000 Hardware Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65085-010-000 Office Supplies 30.00 .00 30.00 _______________ Account: 135-65085-010-000 Office Supplies Totals: .00 30.00 ** 30.00 Budgeted .00 Remaining 100 % Used Account: 135-65095-010-000 Maintenance Supplies 1388 07/24/2012 July A/P June PCards - Beck 11,678.22 205.50 11,883.72 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Beck (42.69) 11,841.03 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Beck 39.44 11,880.47 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Beck 13.37 11,893.84 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Beck 42.69 11,936.53 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Beck 226.84 12,163.37 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Womack 45.00 12,208.37 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Womack 1,818.48 14,026.85 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Womack 380.46 14,407.31 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Womack 179.00 14,586.31 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-65095-010-000 Maintenance Supplies Totals: 2,908.09 14,586.31 ** 32,000.00 Budgeted 17,413.69 Remaining 46 % Used . glpdatb2 rgonzale Trophy Club Entities Page 30 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65100-010-000 Copies .00 .00 _______________ Account: 135-65100-010-000 Copies Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 135-65105-010-000 Printing 58.50 .00 58.50 _______________ Account: 135-65105-010-000 Printing Totals: .00 58.50 ** 150.00 Budgeted 91.50 Remaining 39 % Used Account: 135-69005-010-000 Capital Expenses 1492 07/31/2012 July A/P Roundabout APP #3 1,275,786.10 60,583.87 1,336,369.97 CPS CIVIL, LLC 31668 AP 1494 07/31/2012 July Retainage/CPS Cival App 3 3,188.62 1,339,558.59 GL 1501 07/31/2012 Recode VFD final pmt/S T Debt (34,350.45) 1,305,208.14 GL _______________ Account: 135-69005-010-000 Capital Expenses Totals: 29,422.04 1,305,208.14 ** 1,455,600.00 Budgeted 150,391.86 Remaining 90 % Used Account: 135-69008-010-000 Short Term Debt Payments 1501 07/31/2012 Recode VFD final pmt/S T Debt 34,350.45 34,350.45 GL _______________ Account: 135-69008-010-000 Short Term Debt Payments Totals: 34,350.45 34,350.45 ** 421,050.00 Budgeted 386,699.55 Remaining 8 % Used Account: 135-69035-010-000 Vehicles 30,213.69 .00 30,213.69 _______________ Account: 135-69035-010-000 Vehicles Totals: .00 30,213.69 ** 30,215.00 Budgeted 1.31 Remaining 100 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 31 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69280-010-000 Capital Repairs .00 .00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** 24,000.00 Budgeted 24,000.00 Remaining 0 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 ** 100,817.00 Budgeted .46 Remaining 100 % Used Account: 135-69295-010-000 Unexpected Maintenance .00 .00 _______________ Account: 135-69295-010-000 Unexpected Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-69305-010-000 Capital Leases 10,145.26 .00 10,145.26 _______________ Account: 135-69305-010-000 Capital Leases Totals: .00 10,145.26 ** 10,145.00 Budgeted (.26) Remaining 100 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,897,562.56 ** 4,373,733.00 Budgeted 1,476,170.44 Remaining 66 % Used . glpdatb2 rgonzale Trophy Club Entities Page 32 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 1392 07/06/2012 7/6 Payroll 141,598.30 7,014.44 148,612.74 GL 1391 07/20/2012 7/20 Payroll 7,006.40 155,619.14 GL _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,020.84 155,619.14 ** 182,147.00 Budgeted 26,527.86 Remaining 85 % Used Account: 135-50010-020-000 Overtime 1392 07/06/2012 7/6 Payroll 9,184.84 498.83 9,683.67 GL 1392 07/06/2012 7/6 Payroll 80.00 9,763.67 GL 1391 07/20/2012 7/20 Payroll 288.14 10,051.81 GL 1391 07/20/2012 7/20 Payroll 80.00 10,131.81 GL _______________ Account: 135-50010-020-000 Overtime Totals: 946.97 10,131.81 ** 10,166.00 Budgeted 34.19 Remaining 100 % 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 1391 07/20/2012 7/20 Payroll 950.00 125.00 1,075.00 GL _______________ Account: 135-50017-020-000 Certification Totals: 125.00 1,075.00 ** 2,400.00 Budgeted 1,325.00 Remaining 45 % Used Account: 135-50020-020-000 Retirement 1392 07/06/2012 7/6 Payroll 22,179.58 1,049.39 23,228.97 GL 1391 07/20/2012 7/20 Payroll 1,036.44 24,265.41 GL _______________ Account: 135-50020-020-000 Retirement Totals: 2,085.83 24,265.41 ** 27,816.00 Budgeted 3,550.59 Remaining 87 % Used Account: 135-50026-020-000 Medical Insurance 1392 07/06/2012 7/6 Payroll 19,396.49 1,180.35 20,576.84 GL 1391 07/20/2012 7/20 Payroll 1,180.34 21,757.18 GL . glpdatb2 rgonzale Trophy Club Entities Page 33 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,360.69 21,757.18 ** 30,805.00 Budgeted 9,047.82 Remaining 71 % Used Account: 135-50027-020-000 Dental Insurance 1392 07/06/2012 7/6 Payroll 1,488.72 87.92 1,576.64 GL 1391 07/20/2012 7/20 Payroll 87.92 1,664.56 GL _______________ Account: 135-50027-020-000 Dental Insurance Totals: 175.84 1,664.56 ** 1,981.00 Budgeted 316.44 Remaining 84 % Used Account: 135-50028-020-000 Vision Insurance 1392 07/06/2012 7/6 Payroll 370.58 22.96 393.54 GL 1391 07/20/2012 7/20 Payroll 22.96 416.50 GL _______________ Account: 135-50028-020-000 Vision Insurance Totals: 45.92 416.50 ** 552.00 Budgeted 135.50 Remaining 75 % 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 1392 07/06/2012 7/6 Payroll 8,928.45 408.63 9,337.08 GL 1391 07/20/2012 7/20 Payroll 402.82 9,739.90 GL _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 811.45 9,739.90 ** 11,293.00 Budgeted 1,553.10 Remaining 86 % Used Account: 135-50035-020-000 Medicare Taxes 1392 07/06/2012 7/6 Payroll 2,088.05 95.57 2,183.62 GL 1391 07/20/2012 7/20 Payroll 94.22 2,277.84 GL _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 189.79 2,277.84 ** 2,645.00 Budgeted 367.16 Remaining 86 % Used . glpdatb2 rgonzale Trophy Club Entities Page 34 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 1392 07/06/2012 7/6 Payroll 333.21 62.97 396.18 GL 1391 07/20/2012 7/20 Payroll 62.97 459.15 GL _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 125.94 459.15 ** 567.00 Budgeted 107.85 Remaining 81 % Used Account: 135-50045-020-000 Workman's Compensation 2,685.00 .00 2,685.00 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 2,685.00 ** 2,685.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 115.45 .00 115.45 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 115.45 ** 200.00 Budgeted 84.55 Remaining 58 % Used Account: 135-50070-020-000 Employee Relations 64.45 .00 64.45 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 64.45 ** 350.00 Budgeted 285.55 Remaining 18 % Used Account: 135-55070-020-000 Independent Labor 1367 07/20/2012 July A/P WWTP Services 13,090.67 3,815.00 16,905.67 THE WALLACE GROUP, INC. 31596 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 3,815.00 16,905.67 ** 32,000.00 Budgeted 15,094.33 Remaining 53 % Used Account: 135-55080-020-000 Maintenance & Repairs 1388 07/24/2012 July A/P Repair Flow Meter & Aeration B 37,019.23 440.00 37,459.23 DHS AUTOMATION, INC 31618 AP 1388 07/24/2012 July A/P PCards - Richey 6.06 37,465.29 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey 12.03 37,477.32 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey 83.07 37,560.39 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 541.16 37,560.39 ** 43,000.00 Budgeted 5,439.61 Remaining 87 % Used . glpdatb2 rgonzale Trophy Club Entities Page 35 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/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 234.70 .00 234.70 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 234.70 ** 1,500.00 Budgeted 1,265.30 Remaining 16 % Used Account: 135-55100-020-000 Building Maint & Supplies 1388 07/24/2012 July A/P PCards - Richey 116.00 44.88 160.88 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey 91.12 252.00 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey 49.80 301.80 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey 49.80 351.60 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey (49.80) 301.80 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey 20.55 322.35 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-55100-020-000 Building Maint & Supplies Totals: 206.35 322.35 ** 1,400.00 Budgeted 1,077.65 Remaining 23 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 316.73 .00 316.73 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 316.73 ** 2,950.00 Budgeted 2,633.27 Remaining 11 % Used Account: 135-55125-020-000 Dumpster Services 1367 07/20/2012 July A/P Sludge haul off 28,487.50 537.50 29,025.00 CHANEY ENVIRONMENTAL 31612 AP 1367 07/20/2012 July A/P 2,687.50 31,712.50 CHANEY ENVIRONMENTAL 31612 AP 1367 07/20/2012 July A/P Sludge haul off 537.50 32,250.00 CHANEY ENVIRONMENTAL 31612 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,762.50 32,250.00 ** 35,000.00 Budgeted 2,750.00 Remaining 92 % Used Account: 135-55135-020-000 Lab Analysis 1367 07/20/2012 July A/P Lab analysis 14,534.62 1,080.00 15,614.62 HUTHER AND ASSOCIATES,INC 31626 AP 1388 07/24/2012 July A/P Testing 2,439.75 18,054.37 TALEM, INC 31651 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 3,519.75 18,054.37 ** 25,000.00 Budgeted 6,945.63 Remaining 72 % Used Account: 135-60005-020-000 Telephone . glpdatb2 rgonzale Trophy Club Entities Page 36 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1322 07/09/2012 July A/P 5/28-6/27/12 P Cards/Zieverink 18.72 3.90 22.62 BANK OF AMERICA 31589 AP _______________ Account: 135-60005-020-000 Telephone Totals: 3.90 22.62 ** 100.00 Budgeted 77.38 Remaining 23 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 1388 07/24/2012 July A/P Mobiles 1,727.60 265.48 1,993.08 VERIZON WIRELESS 31659 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 265.48 1,993.08 ** 3,000.00 Budgeted 1,006.92 Remaining 66 % Used Account: 135-60020-020-000 Electricity 1400 07/26/2012 July A/P Electricity 6/14-7/16 54,414.62 11,310.54 65,725.16 HUDSON ENERGY 31664 AP _______________ Account: 135-60020-020-000 Electricity Totals: 11,310.54 65,725.16 ** 110,000.00 Budgeted 44,274.84 Remaining 60 % Used Account: 135-60025-020-000 Water 1367 07/20/2012 July A/P June water 1,647.06 74.46 1,721.52 TROPHY CLUB MUD (WATER BILLS) 31601 AP _______________ Account: 135-60025-020-000 Water Totals: 74.46 1,721.52 ** 1,900.00 Budgeted 178.48 Remaining 91 % 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 1367 07/20/2012 July A/P Burchfield/Training book 111.00 67.50 178.50 CITY OF FORT WORTH 31591 AP . glpdatb2 rgonzale Trophy Club Entities Page 37 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60080-020-000 Schools & Training Totals: 67.50 178.50 ** 1,320.00 Budgeted 1,141.50 Remaining 14 % Used Account: 135-60090-020-000 Safety Program 116.45 .00 116.45 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 116.45 ** 200.00 Budgeted 83.55 Remaining 58 % Used Account: 135-60100-020-000 Travel & per diem 1392 07/06/2012 7/6 Payroll 1,339.22 69.93 1,409.15 GL 1391 07/20/2012 7/20 Payroll 69.93 1,479.08 GL _______________ Account: 135-60100-020-000 Travel & per diem Totals: 139.86 1,479.08 ** 1,750.00 Budgeted 270.92 Remaining 85 % 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,500.00 Budgeted 512.64 Remaining 66 % Used Account: 135-60135-020-000 Annual Permit Fee 7,432.50 .00 7,432.50 _______________ Account: 135-60135-020-000 Annual Permit Fee Totals: .00 7,432.50 ** 7,500.00 Budgeted 67.50 Remaining 99 % Used Account: 135-60245-020-000 Miscellaneous Expenses 76.02 .00 76.02 . glpdatb2 rgonzale Trophy Club Entities Page 38 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 76.02 ** 525.00 Budgeted 448.98 Remaining 14 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1388 07/24/2012 July A/P PCards - Richey 60.46 60.46 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey 23.33 83.79 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 83.79 83.79 ** 525.00 Budgeted 441.21 Remaining 16 % Used Account: 135-65005-020-000 Fuel & Lube 1397 07/01/2012 June Gas log 3,190.01 564.77 3,754.78 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 564.77 3,754.78 ** 6,875.00 Budgeted 3,120.22 Remaining 55 % Used Account: 135-65010-020-000 Uniforms 1,118.93 .00 1,118.93 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,118.93 ** 3,140.00 Budgeted 2,021.07 Remaining 36 % Used Account: 135-65030-020-000 Chemicals 1388 07/24/2012 July A/P PCards - Richey 6,586.47 149.11 6,735.58 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey 149.11 6,884.69 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey 114.99 6,999.68 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 413.21 6,999.68 ** 13,180.00 Budgeted 6,180.32 Remaining 53 % Used Account: 135-65035-020-000 Small Tools 5.94 .00 5.94 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 5.94 ** 1,260.00 Budgeted 1,254.06 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment . glpdatb2 rgonzale Trophy Club Entities Page 39 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1367 07/20/2012 July A/P Safety supplies 22.75 41.55 64.30 CINTAS FAS LOCKBOX 636525 31613 AP 1388 07/24/2012 July A/P Bug Spray for Field personnel 39.13 103.43 COSTCO WHOLESALE 31615 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 80.68 103.43 ** 925.00 Budgeted 821.57 Remaining 11 % Used Account: 135-65045-020-000 Lab Supplies 1367 07/20/2012 July A/P 4,249.03 159.54 4,408.57 USA BLUEBOOK 31603 AP 1367 07/20/2012 July A/P Lab supplies 135.27 4,543.84 USA BLUEBOOK 31603 AP 1367 07/20/2012 July A/P Lab supplies 199.03 4,742.87 USA BLUEBOOK 31603 AP 1367 07/20/2012 July A/P Credit adjustment (12.02) 4,730.85 USA BLUEBOOK 31603 AP 1388 07/24/2012 July A/P PCards - Richey 117.00 4,847.85 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - Richey 40.38 4,888.23 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Schlielig 19.99 4,908.22 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Schlielig 1,485.53 6,393.75 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Schlielig 66.00 6,459.75 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Schlielig 138.95 6,598.70 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Schlielig 1,014.20 7,612.90 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 3,363.87 7,612.90 ** 12,000.00 Budgeted 4,387.10 Remaining 63 % 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 1388 07/24/2012 July A/P Office Supplies 362.53 511.04 873.57 OFFICE DEPOT, INC 31640 AP 1388 07/24/2012 July A/P PCards - Richey 31.04 904.61 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Schlielig 63.96 968.57 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-65085-020-000 Office Supplies Totals: 606.04 968.57 ** 400.00 Budgeted (568.57) Remaining 242 % Used Account: 135-65095-020-000 Maintenance Supplies 1388 07/24/2012 July A/P PCards - Richey 2,250.67 172.40 2,423.07 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Schlielig 28.26 2,451.33 JPMORGAN CHASE BANK NA 31627 AP . glpdatb2 rgonzale Trophy Club Entities Page 40 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1388 07/24/2012 July A/P June PCards - Schlielig 2,250.67 135.60 2,586.93 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Schlielig (15.00) 2,571.93 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Schlielig 114.11 2,686.04 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Schlielig 5.98 2,692.02 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Womack 330.25 3,022.27 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-65095-020-000 Maintenance Supplies Totals: 771.60 3,022.27 ** 8,860.00 Budgeted 5,837.73 Remaining 34 % 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 1400 07/26/2012 July A/P Marshall Creek Sanitary Sewer 73,462.56 750.00 74,212.56 DELTATEK ENGINEERING 31663 AP _______________ Account: 135-69005-020-000 Capital Expenses Totals: 750.00 74,212.56 ** 111,021.00 Budgeted 36,808.44 Remaining 67 % Used Account: 135-69008-020-000 Short Term Debt Payments 1367 07/20/2012 July A/P Final payment Membrane filters 118,730.85 118,730.85 AMERICAN NATL BANK OF TX 31590 AP _______________ Account: 135-69008-020-000 Short Term Debt Payments Totals: 118,730.85 118,730.85 ** 118,731.00 Budgeted .15 Remaining 100 % Used Account: 135-69280-020-000 Capital Repairs .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 56,000.00 Budgeted 56,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 637,576.06 ** 881,484.00 Budgeted 243,907.94 Remaining 72 % Used . glpdatb2 rgonzale Trophy Club Entities Page 41 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/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 1392 07/06/2012 7/6 Payroll 101,135.01 5,659.78 106,794.79 GL 1391 07/20/2012 7/20 Payroll 5,651.91 112,446.70 GL _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,311.69 112,446.70 ** 145,481.00 Budgeted 33,034.30 Remaining 77 % Used Account: 135-50010-021-000 Overtime 1392 07/06/2012 7/6 Payroll 6,927.89 277.09 7,204.98 GL 1391 07/20/2012 7/20 Payroll 385.11 7,590.09 GL 1391 07/20/2012 7/20 Payroll 80.00 7,670.09 GL _______________ Account: 135-50010-021-000 Overtime Totals: 742.20 7,670.09 ** 7,297.00 Budgeted (373.09) Remaining 105 % 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 1391 07/20/2012 7/20 Payroll 850.00 100.00 950.00 GL _______________ Account: 135-50017-021-000 Certification Totals: 100.00 950.00 ** 1,500.00 Budgeted 550.00 Remaining 63 % Used Account: 135-50020-021-000 Retirement 1392 07/06/2012 7/6 Payroll 16,076.72 820.48 16,897.20 GL 1391 07/20/2012 7/20 Payroll 859.18 17,756.38 GL _______________ Account: 135-50020-021-000 Retirement Totals: 1,679.66 17,756.38 ** 21,074.00 Budgeted 3,317.62 Remaining 84 % Used Account: 135-50026-021-000 Medical Insurance 1392 07/06/2012 7/6 Payroll 14,687.40 851.34 15,538.74 GL 1391 07/20/2012 7/20 Payroll 851.34 16,390.08 GL . glpdatb2 rgonzale Trophy Club Entities Page 42 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,702.68 16,390.08 ** 22,983.00 Budgeted 6,592.92 Remaining 71 % Used Account: 135-50027-021-000 Dental Insurance 1392 07/06/2012 7/6 Payroll 1,014.93 58.69 1,073.62 GL 1391 07/20/2012 7/20 Payroll 58.69 1,132.31 GL _______________ Account: 135-50027-021-000 Dental Insurance Totals: 117.38 1,132.31 ** 1,533.00 Budgeted 400.69 Remaining 74 % Used Account: 135-50028-021-000 Vision Insurance 1392 07/06/2012 7/6 Payroll 257.75 14.86 272.61 GL 1391 07/20/2012 7/20 Payroll 14.86 287.47 GL _______________ Account: 135-50028-021-000 Vision Insurance Totals: 29.72 287.47 ** 357.00 Budgeted 69.53 Remaining 81 % 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 1392 07/06/2012 7/6 Payroll 6,656.93 338.60 6,995.53 GL 1391 07/20/2012 7/20 Payroll 355.97 7,351.50 GL _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 694.57 7,351.50 ** 9,785.00 Budgeted 2,433.50 Remaining 75 % Used Account: 135-50035-021-000 Medicare Taxes 1392 07/06/2012 7/6 Payroll 1,556.87 79.18 1,636.05 GL 1391 07/20/2012 7/20 Payroll 83.25 1,719.30 GL _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 162.43 1,719.30 ** 2,288.00 Budgeted 568.70 Remaining 75 % Used . glpdatb2 rgonzale Trophy Club Entities Page 43 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-021-000 Unemployment Taxes 216.00 .00 216.00 _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 216.00 ** 567.00 Budgeted 351.00 Remaining 38 % Used Account: 135-50045-021-000 Workman's Compensation 3,056.00 .00 3,056.00 _______________ Account: 135-50045-021-000 Workman's Compensation Totals: .00 3,056.00 ** 3,056.00 Budgeted .00 Remaining 100 % Used Account: 135-50070-021-000 Employee Relations 64.43 .00 64.43 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 64.43 ** 250.00 Budgeted 185.57 Remaining 26 % Used Account: 135-55005-021-000 Engineering .00 .00 _______________ Account: 135-55005-021-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55070-021-000 Independent Labor .00 .00 _______________ Account: 135-55070-021-000 Independent Labor Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 4,157.53 .00 4,157.53 _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: .00 4,157.53 ** 15,000.00 Budgeted 10,842.47 Remaining 28 % Used Account: 135-55085-021-000 Maintenance-Jet Trailer . glpdatb2 rgonzale Trophy Club Entities Page 44 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1388 07/24/2012 July A/P PCards - McMahon 330.03 330.03 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-55085-021-000 Maintenance-Jet Trailer Totals: 330.03 330.03 ** .00 Budgeted (330.03) Remaining 0 % Used Account: 135-55090-021-000 Vehicle Maintenance 1388 07/24/2012 July A/P Gap Vax 259.22 255.00 514.22 UNDERGROUND INC 31657 AP _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 255.00 514.22 ** 1,943.00 Budgeted 1,428.78 Remaining 26 % 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 1322 07/09/2012 July A/P 5/28-6/27/12 P Cards/Zieverink 22.37 9.25 31.62 BANK OF AMERICA 31589 AP _______________ Account: 135-60005-021-000 Telephone Totals: 9.25 31.62 ** 50.00 Budgeted 18.38 Remaining 63 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 1388 07/24/2012 July A/P Mobiles 2,160.42 201.85 2,362.27 VERIZON WIRELESS 31659 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 201.85 2,362.27 ** 2,796.00 Budgeted 433.73 Remaining 84 % Used Account: 135-60020-021-000 Electricity 1367 07/20/2012 July A/P Electricity 5/31-6/29 8,191.03 281.58 8,472.61 TRI COUNTY ELECTRIC 31600 AP 1367 07/20/2012 July A/P Electricity 5/31-6/29 165.40 8,638.01 TRI COUNTY ELECTRIC 31600 AP 1367 07/20/2012 July A/P Electricity 5/31-6/29 27.59 8,665.60 TRI COUNTY ELECTRIC 31600 AP 1367 07/20/2012 July A/P PID Lift Sta 8 6/13-7/12 39.10 8,704.70 HUDSON ENERGY 31593 AP 1388 07/24/2012 July A/P Electricity 6/14-7/17 676.00 9,380.70 HUDSON ENERGY 31625 AP 1400 07/26/2012 July A/P Electricity 6/14-7/16 247.43 9,628.13 HUDSON ENERGY 31664 AP _______________ Account: 135-60020-021-000 Electricity Totals: 1,437.10 9,628.13 ** 15,000.00 Budgeted 5,371.87 Remaining 64 % Used . glpdatb2 rgonzale Trophy Club Entities Page 45 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60025-021-000 Water .00 .00 _______________ Account: 135-60025-021-000 Water Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60035-021-000 Postage .00 .00 _______________ Account: 135-60035-021-000 Postage Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 255.00 Budgeted 255.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training 111.00 .00 111.00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 111.00 ** 2,818.00 Budgeted 2,707.00 Remaining 4 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 1392 07/06/2012 7/6 Payroll 500.09 3.33 503.42 GL 1391 07/20/2012 7/20 Payroll 112.67 616.09 GL _______________ Account: 135-60100-021-000 Travel & per diem Totals: 116.00 616.09 ** 1,500.00 Budgeted 883.91 Remaining 41 % Used Account: 135-60105-021-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club Entities Page 46 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1388 07/24/2012 July A/P GapVax principal & interest 42,076.50 42,076.50 FIRST FINANCIAL BANK 31623 AP _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: 42,076.50 42,076.50 ** 76,098.00 Budgeted 34,021.50 Remaining 55 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-60280-021-000 Property Maintenance .00 .00 _______________ Account: 135-60280-021-000 Property Maintenance Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 1397 07/01/2012 June Gas log 6,417.27 677.41 7,094.68 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 677.41 7,094.68 ** 11,700.00 Budgeted 4,605.32 Remaining 61 % Used Account: 135-65010-021-000 Uniforms 832.88 .00 832.88 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 832.88 ** 2,505.00 Budgeted 1,672.12 Remaining 33 % Used Account: 135-65030-021-000 Chemicals 2,616.00 .00 2,616.00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 2,616.00 ** 6,500.00 Budgeted 3,884.00 Remaining 40 % Used Account: 135-65035-021-000 Small Tools .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 47 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/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 1388 07/24/2012 July A/P Bug Spray for Field personnel 22.74 39.13 61.87 COSTCO WHOLESALE 31615 AP _______________ Account: 135-65040-021-000 Safety Equipment Totals: 39.13 61.87 ** 1,150.00 Budgeted 1,088.13 Remaining 5 % Used Account: 135-65055-021-000 Hardware 44.95 .00 44.95 _______________ Account: 135-65055-021-000 Hardware Totals: .00 44.95 ** 750.00 Budgeted 705.05 Remaining 6 % Used Account: 135-65095-021-000 Maintenance Supplies 352.64 .00 352.64 _______________ Account: 135-65095-021-000 Maintenance Supplies Totals: .00 352.64 ** 6,050.00 Budgeted 5,697.36 Remaining 6 % Used Account: 135-69005-021-000 Capital Expenses 31,991.00 .00 31,991.00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 31,991.00 ** 15,000.00 Budgeted (16,991.00) Remaining 213 % Used Account: 135-69035-021-000 Vehicles 1,001.25 .00 1,001.25 _______________ Account: 135-69035-021-000 Vehicles Totals: .00 1,001.25 ** .00 Budgeted (1,001.25) Remaining 0 % Used Account: 135-69280-021-000 Capital Repairs .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 48 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-69280-021-000 Capital Repairs Totals: .00 .00 ** 80,000.00 Budgeted 80,000.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 276,410.42 ** 466,512.00 Budgeted 190,101.58 Remaining 59 % Used . glpdatb2 rgonzale Trophy Club Entities Page 49 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/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 1392 07/06/2012 7/6 Payroll 6,400.00 400.00 6,800.00 GL _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 400.00 6,800.00 ** 10,000.00 Budgeted 3,200.00 Remaining 68 % Used Account: 135-50030-026-000 Social Security Taxes 1392 07/06/2012 7/6 Payroll 396.80 24.80 421.60 GL _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 24.80 421.60 ** 620.00 Budgeted 198.40 Remaining 68 % Used Account: 135-50035-026-000 Medicare Taxes 1392 07/06/2012 7/6 Payroll 92.80 5.80 98.60 GL _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 5.80 98.60 ** 145.00 Budgeted 46.40 Remaining 68 % Used Account: 135-50040-026-000 Unemployment Taxes 1392 07/06/2012 7/6 Payroll 51.20 11.60 62.80 GL _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 11.60 62.80 ** 210.00 Budgeted 147.20 Remaining 30 % Used Account: 135-50045-026-000 Workman's Compensation 120.00 .00 120.00 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 120.00 ** 120.00 Budgeted .00 Remaining 100 % Used Account: 135-60035-026-000 Postage 26.11 .00 26.11 _______________ Account: 135-60035-026-000 Postage Totals: .00 26.11 ** 50.00 Budgeted 23.89 Remaining 52 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club Entities Page 50 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 685.00 .00 685.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 685.00 ** 2,100.00 Budgeted 1,415.00 Remaining 33 % Used Account: 135-60075-026-000 Meetings 636.56 .00 636.56 _______________ Account: 135-60075-026-000 Meetings Totals: .00 636.56 ** 1,278.00 Budgeted 641.44 Remaining 50 % Used Account: 135-60080-026-000 Schools & Training 1,099.87 .00 1,099.87 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,099.87 ** 4,150.00 Budgeted 3,050.13 Remaining 27 % Used Account: 135-60100-026-000 Travel & per diem 32.19 .00 32.19 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 32.19 ** 6,199.00 Budgeted 6,166.81 Remaining 1 % Used Account: 135-60245-026-000 Miscellaneous Expenses 1406 07/27/2012 July A/P June PCards - Slaght 1,117.69 100.00 1,217.69 JPMORGAN CHASE BANK NA 31666 AP _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 100.00 1,217.69 ** 3,200.00 Budgeted 1,982.31 Remaining 38 % Used Account: 135-65085-026-000 Office Supplies 1406 07/27/2012 July A/P June PCards - Slaght 23.90 7.00 30.90 JPMORGAN CHASE BANK NA 31666 AP _______________ Account: 135-65085-026-000 Office Supplies Totals: 7.00 30.90 ** 50.00 Budgeted 19.10 Remaining 62 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 11,231.32 ** 28,122.00 Budgeted 16,890.68 Remaining 40 % Used . glpdatb2 rgonzale Trophy Club Entities Page 51 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 7/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 1392 07/06/2012 7/6 Payroll 201,836.96 6,545.47 208,382.43 GL 1391 07/20/2012 7/20 Payroll 6,707.17 215,089.60 GL _______________ Account: 135-50005-027-000 Salaries & Wages Totals: 13,252.64 215,089.60 ** 236,831.00 Budgeted 21,741.40 Remaining 91 % Used Account: 135-50010-027-000 Overtime 1391 07/20/2012 7/20 Payroll 1,110.94 13.97 1,124.91 GL _______________ Account: 135-50010-027-000 Overtime Totals: 13.97 1,124.91 ** 1,028.00 Budgeted (96.91) Remaining 109 % Used Account: 135-50016-027-000 Longevity 3,705.00 .00 3,705.00 _______________ Account: 135-50016-027-000 Longevity Totals: .00 3,705.00 ** 1,845.00 Budgeted (1,860.00) Remaining 201 % Used Account: 135-50020-027-000 Retirement 1392 07/06/2012 7/6 Payroll 28,812.23 855.78 29,668.01 GL 1391 07/20/2012 7/20 Payroll 855.78 30,523.79 GL _______________ Account: 135-50020-027-000 Retirement Totals: 1,711.56 30,523.79 ** 33,471.00 Budgeted 2,947.21 Remaining 91 % Used Account: 135-50026-027-000 Medical Insurance 1392 07/06/2012 7/6 Payroll 12,796.92 605.93 13,402.85 GL 1391 07/20/2012 7/20 Payroll 605.93 14,008.78 GL _______________ Account: 135-50026-027-000 Medical Insurance Totals: 1,211.86 14,008.78 ** 18,798.00 Budgeted 4,789.22 Remaining 75 % Used Account: 135-50027-027-000 Dental Insurance 1392 07/06/2012 7/6 Payroll 1,003.13 49.02 1,052.15 GL 1391 07/20/2012 7/20 Payroll 49.02 1,101.17 GL _______________ Account: 135-50027-027-000 Dental Insurance Totals: 98.04 1,101.17 ** 1,242.00 Budgeted 140.83 Remaining 89 % Used . glpdatb2 rgonzale Trophy Club Entities Page 52 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-027-000 Vision Insurance 1392 07/06/2012 7/6 Payroll 245.49 11.48 256.97 GL 1391 07/20/2012 7/20 Payroll 11.48 268.45 GL _______________ Account: 135-50028-027-000 Vision Insurance Totals: 22.96 268.45 ** 341.00 Budgeted 72.55 Remaining 79 % 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 1392 07/06/2012 7/6 Payroll 12,253.88 366.32 12,620.20 GL 1391 07/20/2012 7/20 Payroll 377.21 12,997.41 GL _______________ Account: 135-50030-027-000 Social Security Taxes Totals: 743.53 12,997.41 ** 14,860.00 Budgeted 1,862.59 Remaining 87 % Used Account: 135-50035-027-000 Medicare Taxes 1392 07/06/2012 7/6 Payroll 2,903.71 85.67 2,989.38 GL 1391 07/20/2012 7/20 Payroll 88.23 3,077.61 GL _______________ Account: 135-50035-027-000 Medicare Taxes Totals: 173.90 3,077.61 ** 3,475.00 Budgeted 397.39 Remaining 89 % Used Account: 135-50040-027-000 Unemployment Taxes 1392 07/06/2012 7/6 Payroll 321.94 10.24 332.18 GL 1391 07/20/2012 7/20 Payroll 15.34 347.52 GL _______________ Account: 135-50040-027-000 Unemployment Taxes Totals: 25.58 347.52 ** 756.00 Budgeted 408.48 Remaining 46 % Used Account: 135-50045-027-000 Workman's Compensation 580.00 .00 580.00 _______________ Account: 135-50045-027-000 Workman's Compensation Totals: .00 580.00 ** 580.00 Budgeted .00 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club Entities Page 53 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50060-027-000 Pre-emp Physicals/Testing 1388 07/24/2012 July A/P Pre-employment testing-Cook 52.50 8.98 61.48 FIRST CHECK APPLICANT SCREENIN 31622 AP _______________ Account: 135-50060-027-000 Pre-emp Physicals/Testing Totals: 8.98 61.48 ** 53.00 Budgeted (8.48) Remaining 116 % Used Account: 135-50070-027-000 Employee Relations 1388 07/24/2012 July A/P June PCard - Schultz 3,622.88 25.66 3,648.54 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P June PCards - Thomas 210.00 3,858.54 JPMORGAN CHASE BANK NA 31627 AP 1406 07/27/2012 July A/P June PCards - Slaght 22.89 3,881.43 JPMORGAN CHASE BANK NA 31666 AP 1406 07/27/2012 July A/P June PCards - Slaght 39.75 3,921.18 JPMORGAN CHASE BANK NA 31666 AP 1406 07/27/2012 July A/P June PCards - Slaght 42.49 3,963.67 JPMORGAN CHASE BANK NA 31666 AP 1406 07/27/2012 July A/P June PCards - Slaght 155.00 4,118.67 JPMORGAN CHASE BANK NA 31666 AP _______________ Account: 135-50070-027-000 Employee Relations Totals: 495.79 4,118.67 ** 5,000.00 Budgeted 881.33 Remaining 82 % Used Account: 135-55070-027-000 Independent Labor 1367 07/20/2012 July A/P Record MUD meeting 251.25 37.50 288.75 MIGUEL CRUZ 31636 AP _______________ Account: 135-55070-027-000 Independent Labor Totals: 37.50 288.75 ** 840.00 Budgeted 551.25 Remaining 34 % 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 191,092.23 .00 191,092.23 _______________ Account: 135-55160-027-000 Professional Outside Services Totals: .00 191,092.23 ** 191,093.00 Budgeted .77 Remaining 100 % Used Account: 135-60005-027-000 Telephone 1322 07/09/2012 July A/P 5/28-6/27/12 P Cards/Zieverink 199.11 22.74 221.85 BANK OF AMERICA 31589 AP . glpdatb2 rgonzale Trophy Club Entities Page 54 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60005-027-000 Telephone Totals: 22.74 221.85 ** 300.00 Budgeted 78.15 Remaining 74 % Used Account: 135-60010-027-000 Communications/Pagers/Mobiles 1391 07/20/2012 7/20 Payroll 1,289.79 75.00 1,364.79 GL 1388 07/24/2012 July A/P Mobiles 89.30 1,454.09 VERIZON WIRELESS 31659 AP _______________ Account: 135-60010-027-000 Communications/Pagers/Mobiles Totals: 164.30 1,454.09 ** 2,420.00 Budgeted 965.91 Remaining 60 % Used Account: 135-60035-027-000 Postage 1462 07/31/2012 July postage meter usage 1,847.74 44.00 1,891.74 GL _______________ Account: 135-60035-027-000 Postage Totals: 44.00 1,891.74 ** 2,400.00 Budgeted 508.26 Remaining 79 % Used Account: 135-60066-027-000 Publications/Books/Subscripts 1388 07/24/2012 July A/P Balance due/McKnight 354.15 17.00 371.15 AMERICAN WATER WORKS ASSOC 31607 AP _______________ Account: 135-60066-027-000 Publications/Books/Subscripts Totals: 17.00 371.15 ** 450.00 Budgeted 78.85 Remaining 82 % Used Account: 135-60070-027-000 Dues & Memberships 827.05 .00 827.05 _______________ Account: 135-60070-027-000 Dues & Memberships Totals: .00 827.05 ** 1,742.00 Budgeted 914.95 Remaining 47 % Used Account: 135-60075-027-000 Meetings 42.44 .00 42.44 _______________ Account: 135-60075-027-000 Meetings Totals: .00 42.44 ** 312.00 Budgeted 269.56 Remaining 14 % Used Account: 135-60080-027-000 Schools & Training 1,405.00 .00 1,405.00 . glpdatb2 rgonzale Trophy Club Entities Page 55 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60080-027-000 Schools & Training Totals: .00 1,405.00 ** 2,555.00 Budgeted 1,150.00 Remaining 55 % Used Account: 135-60100-027-000 Travel & per diem 1392 07/06/2012 7/6 Payroll 1,074.02 41.85 1,115.87 GL _______________ Account: 135-60100-027-000 Travel & per diem Totals: 41.85 1,115.87 ** 3,851.00 Budgeted 2,735.13 Remaining 29 % Used Account: 135-60115-027-000 Elections 1393 07/25/2012 July A/P May elections 612.49 1,918.83 2,531.32 DENTON COUNTY ELECTIONS 31661 AP _______________ Account: 135-60115-027-000 Elections Totals: 1,918.83 2,531.32 ** 2,500.00 Budgeted (31.32) Remaining 101 % Used Account: 135-60125-027-000 Advertising 1367 07/20/2012 July A/P Bank RFP 258.06 258.06 ALLIANCE REGIONAL NEWSPAPERS 31606 AP _______________ Account: 135-60125-027-000 Advertising Totals: 258.06 258.06 ** 4,700.00 Budgeted 4,441.94 Remaining 5 % 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 1388 07/24/2012 July A/P PCards - McKnight 10,105.00 14.44 10,119.44 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - McKnight 64.18 10,183.62 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - McKnight 16.00 10,199.62 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P PCards - McKnight 22.09 10,221.71 JPMORGAN CHASE BANK NA 31627 AP 1388 07/24/2012 July A/P Items for 4th of July MUD boot 16.80 10,238.51 LAURIE SLAGHT 31629 AP _______________ Account: 135-60270-027-000 4th of July Celebration Totals: 133.51 10,238.51 ** 10,500.00 Budgeted 261.49 Remaining 98 % Used . glpdatb2 rgonzale Trophy Club Entities Page 56 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 7/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-60360-027-000 Furniture/Equipment < $5000 1,616.99 .00 1,616.99 _______________ Account: 135-60360-027-000 Furniture/Equipment < $5000 Totals: .00 1,616.99 ** 2,225.00 Budgeted 608.01 Remaining 73 % Used Account: 135-65085-027-000 Office Supplies 1388 07/24/2012 July A/P Copier paper 2,381.28 71.30 2,452.58 OFFICE DEPOT, INC 31640 AP 1388 07/24/2012 July A/P Office Supplies 76.10 2,528.68 OFFICE DEPOT, INC 31640 AP 1388 07/24/2012 July A/P Office Supplies 3.99 2,532.67 OFFICE DEPOT, INC 31640 AP 1406 07/27/2012 July A/P Office Supplies 138.96 2,671.63 OFFICE DEPOT, INC 31667 AP _______________ Account: 135-65085-027-000 Office Supplies Totals: 290.35 2,671.63 ** 2,450.00 Budgeted (221.63) Remaining 109 % Used Account: 135-65105-027-000 Printing 1388 07/24/2012 July A/P June PCard - Schultz 589.45 1,155.63 1,745.08 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-65105-027-000 Printing Totals: 1,155.63 1,745.08 ** 750.00 Budgeted (995.08) Remaining 233 % Used Department 27 Totals: ------------------------------------------------------------------------------------------------ 504,776.15 ** 549,305.00 Budgeted 44,528.85 Remaining 92 % Used . glpdatb2 rgonzale Trophy Club Entities Page 57 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 7/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,478.72 .00 1,478.72 _______________ Account: 135-50070-028-000 Employee Relations Totals: .00 1,478.72 ** 1,967.00 Budgeted 488.28 Remaining 75 % Used Account: 135-50075-028-000 Tuition Reimbursement 219.42 .00 219.42 _______________ Account: 135-50075-028-000 Tuition Reimbursement Totals: .00 219.42 ** 1,561.00 Budgeted 1,341.58 Remaining 14 % Used Account: 135-60005-028-000 Telephone .00 .00 _______________ Account: 135-60005-028-000 Telephone Totals: .00 .00 ** 28.00 Budgeted 28.00 Remaining 0 % Used Account: 135-60035-028-000 Postage 22.23 .00 22.23 _______________ Account: 135-60035-028-000 Postage Totals: .00 22.23 ** 106.00 Budgeted 83.77 Remaining 21 % Used Account: 135-60066-028-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-028-000 Publications/Books/Subscripts Totals: .00 .00 ** 485.00 Budgeted 485.00 Remaining 0 % Used Account: 135-60070-028-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-028-000 Dues & Memberships Totals: .00 .00 ** 555.00 Budgeted 555.00 Remaining 0 % Used Account: 135-60075-028-000 Meetings . glpdatb2 rgonzale Trophy Club Entities Page 58 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60075-028-000 Meetings Totals: .00 .00 ** 138.00 Budgeted 138.00 Remaining 0 % Used Account: 135-60080-028-000 Schools & Training .00 .00 _______________ Account: 135-60080-028-000 Schools & Training Totals: .00 .00 ** 594.00 Budgeted 594.00 Remaining 0 % Used Account: 135-60110-028-000 Physicals/Testing 165.00 .00 165.00 _______________ Account: 135-60110-028-000 Physicals/Testing Totals: .00 165.00 ** 1,560.00 Budgeted 1,395.00 Remaining 11 % Used Account: 135-65085-028-000 Office Supplies .00 .00 _______________ Account: 135-65085-028-000 Office Supplies Totals: .00 .00 ** 437.00 Budgeted 437.00 Remaining 0 % Used Account: 135-65105-028-000 Printing .00 .00 _______________ Account: 135-65105-028-000 Printing Totals: .00 .00 ** 116.00 Budgeted 116.00 Remaining 0 % Used Department 28 Totals: ------------------------------------------------------------------------------------------------ 1,885.37 ** 7,547.00 Budgeted 5,661.63 Remaining 25 % Used . glpdatb2 rgonzale Trophy Club Entities Page 59 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 7/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 1392 07/06/2012 7/6 Payroll 60,049.02 3,001.20 63,050.22 GL 1391 07/20/2012 7/20 Payroll 3,001.20 66,051.42 GL _______________ Account: 135-50005-029-000 Salaries & Wages Totals: 6,002.40 66,051.42 ** 94,404.00 Budgeted 28,352.58 Remaining 70 % 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 1392 07/06/2012 7/6 Payroll 9,027.68 414.77 9,442.45 GL 1391 07/20/2012 7/20 Payroll 414.77 9,857.22 GL _______________ Account: 135-50020-029-000 Retirement Totals: 829.54 9,857.22 ** 13,612.00 Budgeted 3,754.78 Remaining 72 % Used Account: 135-50026-029-000 Medical Insurance 1392 07/06/2012 7/6 Payroll 5,363.88 205.35 5,569.23 GL 1391 07/20/2012 7/20 Payroll 205.35 5,774.58 GL _______________ Account: 135-50026-029-000 Medical Insurance Totals: 410.70 5,774.58 ** 11,060.00 Budgeted 5,285.42 Remaining 52 % Used Account: 135-50027-029-000 Dental Insurance 1392 07/06/2012 7/6 Payroll 526.93 24.51 551.44 GL 1391 07/20/2012 7/20 Payroll 24.51 575.95 GL _______________ Account: 135-50027-029-000 Dental Insurance Totals: 49.02 575.95 ** 773.00 Budgeted 197.05 Remaining 75 % Used . glpdatb2 rgonzale Trophy Club Entities Page 60 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 7/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 1392 07/06/2012 7/6 Payroll 80.91 3.38 84.29 GL 1391 07/20/2012 7/20 Payroll 3.38 87.67 GL _______________ Account: 135-50028-029-000 Vision Insurance Totals: 6.76 87.67 ** 207.00 Budgeted 119.33 Remaining 42 % 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 1392 07/06/2012 7/6 Payroll 3,642.05 172.92 3,814.97 GL 1391 07/20/2012 7/20 Payroll 172.92 3,987.89 GL _______________ Account: 135-50030-029-000 Social Security Taxes Totals: 345.84 3,987.89 ** 5,386.00 Budgeted 1,398.11 Remaining 74 % Used Account: 135-50035-029-000 Medicare Taxes 1392 07/06/2012 7/6 Payroll 851.77 40.44 892.21 GL 1391 07/20/2012 7/20 Payroll 40.44 932.65 GL _______________ Account: 135-50035-029-000 Medicare Taxes Totals: 80.88 932.65 ** 1,260.00 Budgeted 327.35 Remaining 74 % Used Account: 135-50040-029-000 Unemployment Taxes 79.54 .00 79.54 _______________ Account: 135-50040-029-000 Unemployment Taxes Totals: .00 79.54 ** 284.00 Budgeted 204.46 Remaining 28 % Used Account: 135-50045-029-000 Workman's Compensation 211.00 .00 211.00 _______________ Account: 135-50045-029-000 Workman's Compensation Totals: .00 211.00 ** 235.00 Budgeted 24.00 Remaining 90 % Used . glpdatb2 rgonzale Trophy Club Entities Page 61 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55160-029-000 Professional Outside Services 1,105.50 .00 1,105.50 _______________ Account: 135-55160-029-000 Professional Outside Services Totals: .00 1,105.50 ** 5,000.00 Budgeted 3,894.50 Remaining 22 % Used Account: 135-60005-029-000 Telephone 1322 07/09/2012 July A/P 5/28-6/27/12 P Cards/Zieverink 56.03 10.39 66.42 BANK OF AMERICA 31589 AP _______________ Account: 135-60005-029-000 Telephone Totals: 10.39 66.42 ** 103.00 Budgeted 36.58 Remaining 64 % Used Account: 135-60010-029-000 Communications/Pagers/Mobiles 1388 07/24/2012 July A/P Mobiles 409.34 51.31 460.65 VERIZON WIRELESS 31659 AP _______________ Account: 135-60010-029-000 Communications/Pagers/Mobiles Totals: 51.31 460.65 ** 683.00 Budgeted 222.35 Remaining 67 % Used Account: 135-60035-029-000 Postage 1462 07/31/2012 July postage meter usage 230.89 28.75 259.64 GL _______________ Account: 135-60035-029-000 Postage Totals: 28.75 259.64 ** 700.00 Budgeted 440.36 Remaining 37 % 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 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60070-029-000 Dues & Memberships Totals: .00 .00 ** 660.00 Budgeted 660.00 Remaining 0 % Used Account: 135-60075-029-000 Meetings 22.00 .00 22.00 _______________ Account: 135-60075-029-000 Meetings Totals: .00 22.00 ** 300.00 Budgeted 278.00 Remaining 7 % Used Account: 135-60080-029-000 Schools & Training 225.00 .00 225.00 _______________ Account: 135-60080-029-000 Schools & Training Totals: .00 225.00 ** 2,000.00 Budgeted 1,775.00 Remaining 11 % Used Account: 135-60100-029-000 Travel & per diem 27.81 .00 27.81 _______________ Account: 135-60100-029-000 Travel & per diem Totals: .00 27.81 ** 40.00 Budgeted 12.19 Remaining 70 % Used Account: 135-60125-029-000 Advertising .00 .00 _______________ Account: 135-60125-029-000 Advertising Totals: .00 .00 ** 1,210.00 Budgeted 1,210.00 Remaining 0 % Used Account: 135-60245-029-000 Miscellaneous Expenses .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 148.52 .00 148.52 . glpdatb2 rgonzale Trophy Club Entities Page 63 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65085-029-000 Office Supplies Totals: .00 148.52 ** 849.00 Budgeted 700.48 Remaining 17 % 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: ------------------------------------------------------------------------------------------------ 92,674.74 ** 143,450.00 Budgeted 50,775.26 Remaining 65 % Used . glpdatb2 rgonzale Trophy Club Entities Page 64 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 7/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 1322 07/09/2012 July A/P 5/28-6/27/12 P Cards/Zieverink 56,949.78 55.37 57,005.15 BANK OF AMERICA 31589 AP 1322 07/09/2012 July A/P 5/28-6/27/12 P Cards/Zieverink 53.38 57,058.53 BANK OF AMERICA 31589 AP 1322 07/09/2012 July A/P 5/28-6/27/12 PCards/Pastor 25.00 57,083.53 BANK OF AMERICA 31589 AP 1322 07/09/2012 July A/P 5/28-6/27/12 PCards/Pastor 13.52 57,097.05 BANK OF AMERICA 31589 AP 1388 07/24/2012 July A/P STW support 804.90 57,901.95 STW INC 31650 AP 1388 07/24/2012 July A/P Symantec Ghost Solution Suite 50.00 57,951.95 SHI GOVERNMENT SOLUTIONS,INC 31647 AP 1388 07/24/2012 July A/P Annual AV Support 512.50 58,464.45 SHI GOVERNMENT SOLUTIONS,INC 31647 AP 1388 07/24/2012 July A/P Connect Software renewal 989.04 59,453.49 BADGER METER, INC 31609 AP 1388 07/24/2012 July A/P PCards - Gonzales 329.14 59,782.63 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-55030-033-000 Software & Support Totals: 2,832.85 59,782.63 ** 64,149.00 Budgeted 4,366.37 Remaining 93 % 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 1322 07/09/2012 July A/P 5/28-6/27/12 P Cards/Zieverink 6,061.10 393.83 6,454.93 BANK OF AMERICA 31589 AP 1322 07/09/2012 July A/P 5/28-6/27/12 P Cards/Zieverink 369.26 6,824.19 BANK OF AMERICA 31589 AP _______________ Account: 135-60005-033-000 Telephone Totals: 763.09 6,824.19 ** 6,540.00 Budgeted (284.19) Remaining 104 % Used Account: 135-60235-033-000 Security 1367 07/20/2012 July A/P Keypads at Water & WWTP gates 406.60 276.25 682.85 Electronic Facility Systems 31592 AP _______________ Account: 135-60235-033-000 Security Totals: 276.25 682.85 ** 1,350.00 Budgeted 667.15 Remaining 51 % Used Account: 135-65055-033-000 Hardware 1388 07/24/2012 July A/P IPAD for testing 70,584.05 354.00 70,938.05 SHI GOVERNMENT SOLUTIONS,INC 31647 AP 1388 07/24/2012 July A/P Color printer/McKnight 694.91 71,632.96 SHI GOVERNMENT SOLUTIONS,INC 31647 AP 1388 07/24/2012 July A/P Repair Trophy Lake Marquee 720.00 72,352.96 ENTECH ASSOC/ENTECH SIGNS 31621 AP _______________ Account: 135-65055-033-000 Hardware Totals: 1,768.91 72,352.96 ** 83,238.00 Budgeted 10,885.04 Remaining 87 % Used . glpdatb2 rgonzale Trophy Club Entities Page 65 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 7/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 1388 07/24/2012 July A/P DVD+R 334.90 25.10 360.00 SHI GOVERNMENT SOLUTIONS,INC 31647 AP _______________ Account: 135-65085-033-000 Office Supplies Totals: 25.10 360.00 ** 371.00 Budgeted 11.00 Remaining 97 % Used Account: 135-65090-033-000 Printer Supplies & Maintenance 1322 07/09/2012 July A/P 5/28-6/27/12 P Cards/Zieverink 3,572.88 219.50 3,792.38 BANK OF AMERICA 31589 AP 1322 07/09/2012 July A/P 5/28-6/27/12 P Cards/Zieverink 259.50 4,051.88 BANK OF AMERICA 31589 AP 1388 07/24/2012 July A/P Toner for Color printers 639.50 4,691.38 SHI GOVERNMENT SOLUTIONS,INC 31647 AP 1388 07/24/2012 July A/P Toner for WWTP Color printer 380.36 5,071.74 SHI GOVERNMENT SOLUTIONS,INC 31647 AP 1388 07/24/2012 July A/P Toner for Adm & PW Color Print 411.50 5,483.24 SHI GOVERNMENT SOLUTIONS,INC 31647 AP 1388 07/24/2012 July A/P Toner for Fire Station Color p 102.00 5,585.24 SHI GOVERNMENT SOLUTIONS,INC 31647 AP 1388 07/24/2012 July A/P Toner cartridge for network pr 77.50 5,662.74 SHI GOVERNMENT SOLUTIONS,INC 31647 AP 1388 07/24/2012 July A/P Ink cartridge for Remit machin 39.93 5,702.67 TECHNIQUE DATA SYSTEMS INC 31653 AP _______________ Account: 135-65090-033-000 Printer Supplies & Maintenance Totals: 2,129.79 5,702.67 ** 5,732.00 Budgeted 29.33 Remaining 99 % Used Account: 135-69170-033-000 Copier Lease Installments 1388 07/24/2012 July A/P Copier Lease 2,054.80 262.95 2,317.75 KYOCERA MITA AMERICA, INC. 31628 AP _______________ Account: 135-69170-033-000 Copier Lease Installments Totals: 262.95 2,317.75 ** 3,450.00 Budgeted 1,132.25 Remaining 67 % 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: ------------------------------------------------------------------------------------------------ 148,398.05 ** 193,391.00 Budgeted 44,992.95 Remaining 77 % Used . glpdatb2 rgonzale Trophy Club Entities Page 66 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50035-037-000 Medicare Taxes 46.85 .00 46.85 _______________ Account: 135-50035-037-000 Medicare Taxes Totals: .00 46.85 ** .00 Budgeted (46.85) Remaining 0 % Used Account: 135-50045-037-000 Workman's Compensation 861.00 .00 861.00 _______________ Account: 135-50045-037-000 Workman's Compensation Totals: .00 861.00 ** 861.00 Budgeted .00 Remaining 100 % Used Account: 135-55100-037-000 Building Maint & Supplies 1388 07/24/2012 July A/P June PCard - Schultz 1,379.48 4.80 1,384.28 JPMORGAN CHASE BANK NA 31627 AP _______________ Account: 135-55100-037-000 Building Maint & Supplies Totals: 4.80 1,384.28 ** 20,478.00 Budgeted 19,093.72 Remaining 7 % Used Account: 135-55120-037-000 Cleaning Services 1367 07/20/2012 July A/P July Janitorial service 13,088.80 1,678.51 14,767.31 ABM JANITORIAL SERVICES, INC 31605 AP 1367 07/20/2012 July A/P AC Repair (Server room) 205.00 14,972.31 Metro Express Service 31595 AP 1406 07/27/2012 July A/P June PCards - Slaght 133.66 15,105.97 JPMORGAN CHASE BANK NA 31666 AP _______________ Account: 135-55120-037-000 Cleaning Services Totals: 2,017.17 15,105.97 ** 25,000.00 Budgeted 9,894.03 Remaining 60 % Used Account: 135-60020-037-000 Electricity 1367 07/20/2012 July A/P Electricity 5/15-6/16 8,234.74 1,084.59 9,319.33 DIRECT ENERGY BUSINESS SVCS 31619 AP _______________ Account: 135-60020-037-000 Electricity Totals: 1,084.59 9,319.33 ** 21,940.00 Budgeted 12,620.67 Remaining 42 % Used Account: 135-60025-037-000 Water 1367 07/20/2012 July A/P June water 381.24 176.16 557.40 TROPHY CLUB MUD (WATER BILLS) 31601 AP _______________ Account: 135-60025-037-000 Water Totals: 176.16 557.40 ** 1,093.00 Budgeted 535.60 Remaining 51 % Used . glpdatb2 rgonzale Trophy Club Entities Page 67 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60030-037-000 Rent And/Or Usage 1388 07/24/2012 July A/P July Rent/PS Bldg 9,886.59 1,098.51 10,985.10 TOWN OF TROPHY CLUB 31656 AP _______________ Account: 135-60030-037-000 Rent And/Or Usage Totals: 1,098.51 10,985.10 ** 13,182.00 Budgeted 2,196.90 Remaining 83 % Used Account: 135-60055-037-000 Insurance 1388 07/24/2012 July A/P Deductible/Carter 30,386.73 3,243.76 33,630.49 TML INTERGOVERNMENTAL RISK 31655 AP _______________ Account: 135-60055-037-000 Insurance Totals: 3,243.76 33,630.49 ** 32,635.00 Budgeted (995.49) Remaining 103 % Used Account: 135-60360-037-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-037-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 4,750.00 Budgeted 4,750.00 Remaining 0 % Used Account: 135-65095-037-000 Maintenance Supplies 876.65 .00 876.65 _______________ Account: 135-65095-037-000 Maintenance Supplies Totals: .00 876.65 ** 2,205.00 Budgeted 1,328.35 Remaining 40 % Used Account: 135-65097-037-000 Vending Machine Supplies 80.03 .00 80.03 _______________ Account: 135-65097-037-000 Vending Machine Supplies Totals: .00 80.03 ** 1,000.00 Budgeted 919.97 Remaining 8 % Used Department 37 Totals: ------------------------------------------------------------------------------------------------ 72,847.10 ** 123,144.00 Budgeted 50,296.90 Remaining 59 % Used . glpdatb2 rgonzale Trophy Club Entities Page 68 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 7/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 1392 07/06/2012 7/6 Payroll 58,742.75 3,717.09 62,459.84 GL 1391 07/20/2012 7/20 Payroll 3,873.54 66,333.38 GL _______________ Account: 135-50005-038-000 Salaries & Wages Totals: 7,590.63 66,333.38 ** 84,946.00 Budgeted 18,612.62 Remaining 78 % Used Account: 135-50010-038-000 Overtime 1392 07/06/2012 7/6 Payroll 275.09 3.47 278.56 GL 1391 07/20/2012 7/20 Payroll 21.52 300.08 GL _______________ Account: 135-50010-038-000 Overtime Totals: 24.99 300.08 ** 2,000.00 Budgeted 1,699.92 Remaining 15 % 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 1392 07/06/2012 7/6 Payroll 8,461.80 465.38 8,927.18 GL 1391 07/20/2012 7/20 Payroll 465.22 9,392.40 GL _______________ Account: 135-50020-038-000 Retirement Totals: 930.60 9,392.40 ** 12,203.00 Budgeted 2,810.60 Remaining 77 % Used Account: 135-50026-038-000 Medical Insurance 1392 07/06/2012 7/6 Payroll 8,025.47 462.18 8,487.65 GL 1391 07/20/2012 7/20 Payroll 462.19 8,949.84 GL _______________ Account: 135-50026-038-000 Medical Insurance Totals: 924.37 8,949.84 ** 12,321.00 Budgeted 3,371.16 Remaining 73 % Used Account: 135-50027-038-000 Dental Insurance 1392 07/06/2012 7/6 Payroll 796.42 45.83 842.25 GL 1391 07/20/2012 7/20 Payroll 45.83 888.08 GL . glpdatb2 rgonzale Trophy Club Entities Page 69 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 7/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.66 888.08 ** 1,026.00 Budgeted 137.92 Remaining 87 % Used Account: 135-50028-038-000 Vision Insurance 1392 07/06/2012 7/6 Payroll 187.84 10.82 198.66 GL 1391 07/20/2012 7/20 Payroll 10.81 209.47 GL _______________ Account: 135-50028-038-000 Vision Insurance Totals: 21.63 209.47 ** 260.00 Budgeted 50.53 Remaining 81 % 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 1392 07/06/2012 7/6 Payroll 3,474.87 212.79 3,687.66 GL 1391 07/20/2012 7/20 Payroll 223.60 3,911.26 GL _______________ Account: 135-50030-038-000 Social Security Taxes Totals: 436.39 3,911.26 ** 5,404.00 Budgeted 1,492.74 Remaining 72 % Used Account: 135-50035-038-000 Medicare Taxes 1392 07/06/2012 7/6 Payroll 765.84 49.78 815.62 GL 1391 07/20/2012 7/20 Payroll 52.29 867.91 GL _______________ Account: 135-50035-038-000 Medicare Taxes Totals: 102.07 867.91 ** 1,264.00 Budgeted 396.09 Remaining 69 % Used Account: 135-50040-038-000 Unemployment Taxes 1392 07/06/2012 7/6 Payroll 191.18 10.24 201.42 GL 1391 07/20/2012 7/20 Payroll 15.33 216.75 GL _______________ Account: 135-50040-038-000 Unemployment Taxes Totals: 25.57 216.75 ** 473.00 Budgeted 256.25 Remaining 46 % Used . glpdatb2 rgonzale Trophy Club Entities Page 70 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-038-000 Workman's Compensation 235.00 .00 235.00 _______________ Account: 135-50045-038-000 Workman's Compensation Totals: .00 235.00 ** 211.00 Budgeted (24.00) Remaining 111 % Used Account: 135-50060-038-000 Pre-emp Physicals/Testing 1388 07/24/2012 July A/P Pre-employment testing-Cook 17.50 8.97 26.47 FIRST CHECK APPLICANT SCREENIN 31622 AP _______________ Account: 135-50060-038-000 Pre-emp Physicals/Testing Totals: 8.97 26.47 ** 35.00 Budgeted 8.53 Remaining 76 % Used Account: 135-55070-038-000 Independent Labor .00 .00 _______________ Account: 135-55070-038-000 Independent Labor Totals: .00 .00 ** 800.00 Budgeted 800.00 Remaining 0 % Used Account: 135-55205-038-000 Utility Billing Contract 1367 07/20/2012 July A/P Utility bills printed and mail 7,771.63 966.59 8,738.22 CSG SYSTEMS, INC. 31616 AP _______________ Account: 135-55205-038-000 Utility Billing Contract Totals: 966.59 8,738.22 ** 11,000.00 Budgeted 2,261.78 Remaining 79 % Used Account: 135-60005-038-000 Telephone 1322 07/09/2012 July A/P 5/28-6/27/12 P Cards/Zieverink 55.02 1.64 56.66 BANK OF AMERICA 31589 AP _______________ Account: 135-60005-038-000 Telephone Totals: 1.64 56.66 ** 100.00 Budgeted 43.34 Remaining 57 % Used Account: 135-60010-038-000 Communications/Pagers/Mobiles 1388 07/24/2012 July A/P Mobiles 289.68 36.46 326.14 VERIZON WIRELESS 31659 AP _______________ Account: 135-60010-038-000 Communications/Pagers/Mobiles Totals: 36.46 326.14 ** 472.00 Budgeted 145.86 Remaining 69 % Used Account: 135-60035-038-000 Postage . glpdatb2 rgonzale Trophy Club Entities Page 71 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1367 07/20/2012 July A/P Utility bills printed and mail 11,189.04 1,527.69 12,716.73 CSG SYSTEMS, INC. 31616 AP _______________ Account: 135-60035-038-000 Postage Totals: 1,527.69 12,716.73 ** 18,000.00 Budgeted 5,283.27 Remaining 71 % Used Account: 135-60040-038-000 Service Charges & Fees 1482 07/03/2012 Bank CC & Online Fees 18,168.30 43.39 18,211.69 GL 1482 07/03/2012 Bank CC & Online Fees 69.00 18,280.69 GL 1482 07/03/2012 Bank CC & Online Fees 1,510.68 19,791.37 GL 1481 07/18/2012 Unidentified Bank Dep correcti 8.00 19,799.37 GL _______________ Account: 135-60040-038-000 Service Charges & Fees Totals: 1,631.07 19,799.37 ** 29,340.00 Budgeted 9,540.63 Remaining 67 % Used Account: 135-60070-038-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-038-000 Dues & Memberships Totals: .00 .00 ** 71.00 Budgeted 71.00 Remaining 0 % Used Account: 135-60080-038-000 Schools & Training 225.00 .00 225.00 _______________ Account: 135-60080-038-000 Schools & Training Totals: .00 225.00 ** 800.00 Budgeted 575.00 Remaining 28 % Used Account: 135-60100-038-000 Travel & per diem .00 .00 _______________ Account: 135-60100-038-000 Travel & per diem Totals: .00 .00 ** 605.00 Budgeted 605.00 Remaining 0 % Used Account: 135-60130-038-000 Reg Assessment Fee (5%) 25,071.20 .00 25,071.20 _______________ Account: 135-60130-038-000 Reg Assessment Fee (5%) Totals: .00 25,071.20 ** 25,100.00 Budgeted 28.80 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club Entities Page 72 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 7/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60245-038-000 Miscellaneous Expenses .01 .00 .01 _______________ Account: 135-60245-038-000 Miscellaneous Expenses Totals: .00 .01 ** 200.00 Budgeted 199.99 Remaining 0 % Used Account: 135-65085-038-000 Office Supplies 670.19 .00 670.19 _______________ Account: 135-65085-038-000 Office Supplies Totals: .00 670.19 ** 700.00 Budgeted 29.81 Remaining 96 % 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: ------------------------------------------------------------------------------------------------ 159,154.16 ** 211,405.00 Budgeted 52,250.84 Remaining 75 % Used . glpdatb2 rgonzale Trophy Club Entities Page 73 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 7/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 1367 07/20/2012 July A/P June legal 67,155.04 3,176.75 70,331.79 THE LISTON LAW FIRM, P.C. 31654 AP 1388 07/24/2012 July A/P June Legal 1,145.00 71,476.79 WHITAKER CHALK SWINDLE 31660 AP _______________ Account: 135-55045-039-000 Legal Totals: 4,321.75 71,476.79 ** 88,000.00 Budgeted 16,523.21 Remaining 81 % Used Account: 135-55055-039-000 Auditing 20,200.00 .00 20,200.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 20,200.00 ** 20,200.00 Budgeted .00 Remaining 100 % Used Account: 135-55060-039-000 Appraisal 13,615.43 .00 13,615.43 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 13,615.43 ** 20,000.00 Budgeted 6,384.57 Remaining 68 % Used Account: 135-55065-039-000 Tax Admin Fees 2,470.09 .00 2,470.09 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,470.09 ** 3,629.00 Budgeted 1,158.91 Remaining 68 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 2,277.85 .00 2,277.85 _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: .00 2,277.85 ** 2,278.00 Budgeted .15 Remaining 100 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 110,040.16 ** 134,107.00 Budgeted 24,066.84 Remaining 82 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (787,729.40) (370,880.00) Budgeted 416,849.40 Remaining 212 % Used Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 7/31/2012 ASSETS ASSETS CASH AND CASH IN BANK 6,120$ INVESTMENTS 816,182 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 19,694 TOTAL ASSETS 841,996$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 19,694$ TOTAL LIABILITIES 19,694 FUND BALANCE ASSIGNED FUND BALANCE 822,302 TOTAL LIABILITIES AND FUND BALANCE 841,996$ July 31, 2012 10/12 Months (83% of Fiscal Year) . glbase_tbam rgonzale Trophy Club Entities Page 21 10:45 08/08/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 550,663.00- 546,716.00- 1,891.30- 546,703.58- 99.998 12.42- 533-40002-000-000 Property Taxes/Delinquent 3,947.00- 686.25- 2,449.86 -62.069 6,396.86- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 324.79- 2,670.92- 53.237 2,346.08- Subtotal: 555,680.00- 555,680.00- 2,902.34- 546,924.64- 98.424 8,755.36- 533-48005-000-000 Utility Fees 6,120.00- 6,120.00- 6,120.00- 100.000 Subtotal: 6,120.00- 6,120.00- 6,120.00- 100.000 533-49010-000-000 Interest Income 500.00- 1,700.00- 91.17- 1,198.43- 70.496 501.57- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- 100.000 533-49110-000-000 Premium on Bonds Sold 4,661.84- 4,661.84 Subtotal: 308,500.00- 309,700.00- 91.17- 313,860.27- 101.343 4,160.27 Program number: 870,300.00- 871,500.00- 2,993.51- 866,904.91- 99.473 4,595.09- Department number: Revenues 870,300.00- 871,500.00- 2,993.51- 866,904.91- 99.473 4,595.09- Revenues Subtotal ----------- 870,300.00- 871,500.00- 2,993.51- 866,904.91- 99.473 4,595.09- . glbase_tbam rgonzale Trophy Club Entities Page 22 10:45 08/08/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 7/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 1,300.00 1,800.00 45.000 2,200.00 533-70025-051-000 Bond Interest Expense 301,300.00 301,300.00 150,650.00 50.000 150,650.00 533-70035-051-000 Bond Principal Payment 565,000.00 565,000.00 565,000.00 Subtotal: 870,300.00 870,300.00 1,300.00 152,450.00 17.517 717,850.00 Program number: 870,300.00 870,300.00 1,300.00 152,450.00 17.517 717,850.00 Department number: Administration 870,300.00 870,300.00 1,300.00 152,450.00 17.517 717,850.00 Expenditures Subtotal ----------- 870,300.00 870,300.00 1,300.00 152,450.00 17.517 717,850.00 Fund number: 533 MUD 1 I&S CONSOLIDATED 1,200.00- 1,693.51- 714,454.91- ############### 713,254.91 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club Entities Page 74 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 7/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 1442 07/02/2012 Property Taxes/Assessments (544,812.28) (325.03) (545,137.31) GL 1443 07/03/2012 Property Tax/Assessments (88.18) (545,225.49) GL 1444 07/05/2012 Property Tax/Assessments (62.06) (545,287.55) GL 1445 07/06/2012 Property Tax/Assessments (43.48) (545,331.03) GL 1446 07/09/2012 Property Tax/Assessments (101.15) (545,432.18) GL 1447 07/10/2012 Property Tax/Assessments (150.43) (545,582.61) GL 1448 07/12/2012 Property Tax/Assessments (127.73) (545,710.34) GL 1449 07/13/2012 Property Tax/Assessments (116.29) (545,826.63) GL 1450 07/16/2012 Property Tax/Assessments (242.35) (546,068.98) GL 1451 07/17/2012 Property Tax/Assessments (32.55) (546,101.53) GL 1453 07/20/2012 Property Tax/Assessments (58.57) (546,160.10) GL 1454 07/23/2012 Property Tax/Assessments (47.86) (546,207.96) GL 1455 07/24/2012 Property Tax/Assessments (93.62) (546,301.58) GL 1456 07/25/2012 Property Tax/Assessments (18.80) (546,320.38) GL 1457 07/27/2012 Property Tax/Assessments (38.70) (546,359.08) GL 1458 07/30/2012 Property Tax/Assessments (117.71) (546,476.79) GL 1459 07/31/2012 Property Tax/Assessments (226.79) (546,703.58) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,891.30) (546,703.58) ** (546,716.00) Budgeted (12.42) Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1442 07/02/2012 Property Taxes/Assessments 3,136.11 (284.84) 2,851.27 GL 1449 07/13/2012 Property Tax/Assessments (75.44) 2,775.83 GL 1450 07/16/2012 Property Tax/Assessments (325.97) 2,449.86 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (686.25) 2,449.86 ** (3,947.00) Budgeted (6,396.86) Remaining -62 % Used Account: 533-40015-000-000 Property Taxes/P & I 1442 07/02/2012 Property Taxes/Assessments (2,346.13) (32.79) (2,378.92) GL 1443 07/03/2012 Property Tax/Assessments (8.90) (2,387.82) GL 1447 07/10/2012 Property Tax/Assessments (15.73) (2,403.55) GL 1448 07/12/2012 Property Tax/Assessments (3.03) (2,406.58) GL 1449 07/13/2012 Property Tax/Assessments (40.06) (2,446.64) GL 1450 07/16/2012 Property Tax/Assessments (202.33) (2,648.97) GL 1455 07/24/2012 Property Tax/Assessments (5.93) (2,654.90) GL 1457 07/27/2012 Property Tax/Assessments (.50) (2,655.40) GL 1458 07/30/2012 Property Tax/Assessments (.50) (2,655.90) GL 1459 07/31/2012 Property Tax/Assessments (15.02) (2,670.92) GL . glpdatb2 rgonzale Trophy Club Entities Page 75 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 7/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-40015-000-000 Property Taxes/P & I Totals: (324.79) (2,670.92) ** (5,017.00) Budgeted (2,346.08) Remaining 53 % 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 1480 07/31/2012 July Bank Interest (1,107.26) (91.17) (1,198.43) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (91.17) (1,198.43) ** (1,700.00) Budgeted (501.57) Remaining 70 % Used Account: 533-49015-000-000 Lease/Rental Income (308,000.00) .00 (308,000.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (308,000.00) ** (308,000.00) Budgeted .00 Remaining 100 % Used Account: 533-49110-000-000 Premium on Bonds Sold (4,661.84) .00 (4,661.84) _______________ Account: 533-49110-000-000 Premium on Bonds Sold Totals: .00 (4,661.84) ** .00 Budgeted 4,661.84 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (866,904.91) ** (871,500.00) Budgeted (4,595.09) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club Entities Page 76 10:45 08/08/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 7/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 1490 07/19/2012 BNY Bond Admin fees TCMUD #2 Ref CIB Ser 05 500.00 300.00 800.00 GL 1490 07/19/2012 BNY Bond Admin fees TCMUD #2 Unl Tax Bonds 2003 1,000.00 1,800.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 1,300.00 1,800.00 ** 4,000.00 Budgeted 2,200.00 Remaining 45 % Used Account: 533-70025-051-000 Bond Interest Expense 150,650.00 .00 150,650.00 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 150,650.00 ** 301,300.00 Budgeted 150,650.00 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 565,000.00 Budgeted 565,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 152,450.00 ** 870,300.00 Budgeted 717,850.00 Remaining 18 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (714,454.91) (1,200.00) Budgeted 713,254.91 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (1,867,750.01) **** (372,080.00) Budgeted 1,495,670.01 Remaining 502 % Used ******* End of Report *********