Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
January 2012 MUD Financials
. glpdatb2 rgonzale Trophy Club Entities Page 1 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/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 362 01/03/2012 Property Taxes (96,096.32) (491.87) (96,588.19) GL 363 01/04/2012 Property Taxes (30,573.25) (127,161.44) GL 365 01/05/2012 Property Taxes (7,712.82) (134,874.26) GL 366 01/06/2012 Property Taxes (2,026.03) (136,900.29) GL 367 01/09/2012 Property Taxes (2,801.44) (139,701.73) GL 368 01/10/2012 Property Taxes (1,138.76) (140,840.49) GL 369 01/11/2012 Property Taxes (1,484.72) (142,325.21) GL 370 01/12/2012 Property Taxes (909.82) (143,235.03) GL 371 01/13/2012 Property Taxes (626.81) (143,861.84) GL 372 01/17/2012 Property Taxes (460.40) (144,322.24) GL 373 01/18/2012 Property Taxes (1,661.71) (145,983.95) GL 374 01/19/2012 Property Taxes (1,111.48) (147,095.43) GL 375 01/20/2012 Property Taxes (349.60) (147,445.03) GL 376 01/23/2012 Property Taxes (968.62) (148,413.65) GL 377 01/24/2012 Property Taxes (6,819.87) (155,233.52) GL 378 01/25/2012 Property Taxes (4,371.80) (159,605.32) GL 379 01/26/2012 Property Taxes (487.74) (160,093.06) GL 421 01/27/2012 Property Taxes (2,950.13) (163,043.19) GL 422 01/30/2012 Property Taxes (36.24) (163,079.43) GL 423 01/31/2012 Property Taxes (3,038.94) (166,118.37) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (70,022.05) (166,118.37) ** (193,233.00) Budgeted (27,114.63) Remaining 86 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent 365 01/05/2012 Property Taxes (7.75) (4,848.94) (4,856.69) GL _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (4,848.94) (4,856.69) ** (4,900.00) Budgeted (43.31) Remaining 99 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 362 01/03/2012 Property Taxes (402,828.01) (11,085.51) (413,913.52) GL 363 01/04/2012 Property Taxes (115,125.44) (529,038.96) GL 364 01/05/2012 Property Taxes (28,464.34) (557,503.30) GL 366 01/06/2012 Property Taxes (10,629.35) (568,132.65) GL 367 01/09/2012 Property Taxes (10,100.51) (578,233.16) GL 368 01/10/2012 Property Taxes (165,037.60) (743,270.76) GL 369 01/11/2012 Property Taxes (30,911.30) (774,182.06) GL 370 01/12/2012 Property Taxes (4,963.14) (779,145.20) GL 371 01/13/2012 Property Taxes (6,255.51) (785,400.71) GL . glpdatb2 rgonzale Trophy Club Entities Page 2 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 372 01/17/2012 Property Taxes (402,828.01) (10,822.50) (796,223.21) GL 373 01/18/2012 Property Taxes (8,726.89) (804,950.10) GL 374 01/19/2012 Property Taxes (15,580.84) (820,530.94) GL 375 01/20/2012 Property Taxes (3,511.99) (824,042.93) GL 376 01/23/2012 Property Taxes (7,793.25) (831,836.18) GL 377 01/24/2012 Property Taxes (20,072.61) (851,908.79) GL 378 01/25/2012 Property Taxes (41,757.25) (893,666.04) GL 379 01/26/2012 Property Taxes (4,789.15) (898,455.19) GL 421 01/27/2012 Property Taxes (13,969.71) (912,424.90) GL 422 01/30/2012 Property Taxes (7,485.42) (919,910.32) GL 423 01/31/2012 Property Taxes (20,528.05) (940,438.37) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (537,610.36) (940,438.37) ** (1,076,976.00) Budgeted (136,537.63) Remaining 87 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 365 01/05/2012 Property Taxes 5,772.76 (243.76) 5,529.00 GL 370 01/12/2012 Property Taxes (11.85) 5,517.15 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (255.61) 5,517.15 ** (5,603.00) Budgeted (11,120.15) Remaining -98 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 365 01/05/2012 Property Taxes (5.42) (695.58) (701.00) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (695.58) (701.00) ** (725.00) Budgeted (24.00) Remaining 97 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 365 01/05/2012 Property Taxes (308.31) (173.06) (481.37) GL 370 01/12/2012 Property Taxes (4.99) (486.36) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (178.05) (486.36) ** (7,500.00) Budgeted (7,013.64) Remaining 6 % Used Account: 122-42014-000-000 Fire Permits/Sprinkler 381 01/04/2012 Permits 1/4/12 (2,400.00) (1,600.00) (4,000.00) GL 427 01/30/2012 Permits 1/30/12 (400.00) (4,400.00) GL . glpdatb2 rgonzale Trophy Club Entities Page 3 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/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 Permits/Sprinkler Totals: (2,000.00) (4,400.00) ** (2,000.00) Budgeted 2,400.00 Remaining 220 % Used Account: 122-43400-000-000 Fire Inspections 381 01/04/2012 Permits 1/4/12 (450.00) (300.00) (750.00) GL 427 01/30/2012 Permits 1/30/12 (75.00) (825.00) GL _______________ Account: 122-43400-000-000 Fire Inspections Totals: (375.00) (825.00) ** (500.00) Budgeted 325.00 Remaining 165 % Used Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 461 01/06/2012 Denton County/FY12 Fire Pledge (10,000.00) (10,000.00) GL _______________ Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire Totals: (10,000.00) (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-43599-000-000 Misc Fire Revenue .00 .00 _______________ Account: 122-43599-000-000 Misc Fire Revenue Totals: .00 .00 ** (1,124.00) Budgeted (1,124.00) Remaining 0 % Used Account: 122-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (4,373.00) Budgeted (4,373.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 381 01/04/2012 Permits 1/4/12 (3,450.00) (2,100.00) (5,550.00) GL 381 01/04/2012 Permits 1/4/12 (100.00) (5,650.00) GL 425 01/27/2012 Permits 1/27/12 (100.00) (5,750.00) GL 427 01/30/2012 Permits 1/30/12 (525.00) (6,275.00) GL 426 01/31/2012 Permits 1/31/12 (100.00) (6,375.00) GL _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (2,925.00) (6,375.00) ** (5,000.00) Budgeted 1,375.00 Remaining 128 % Used . glpdatb2 rgonzale Trophy Club Entities Page 4 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/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,128,683.64) ** (1,311,934.00) Budgeted (183,250.36) Remaining 86 % Used . glpdatb2 rgonzale Trophy Club Entities Page 5 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/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 237 01/06/2012 PAYROLL 1/6/2012 Salaries & Wages 88,783.56 16,303.02 105,086.58 PR 332 01/20/2012 PAYROLL 1/20/12 Salaries & Wages 16,990.99 122,077.57 PR _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 33,294.01 122,077.57 ** 425,748.00 Budgeted 303,670.43 Remaining 29 % Used Account: 122-50010-045-000 Overtime 332 01/20/2012 PAYROLL 1/20/12 Overtime 12,292.97 4,679.36 16,972.33 PR _______________ Account: 122-50010-045-000 Overtime Totals: 4,679.36 16,972.33 ** 42,000.00 Budgeted 25,027.67 Remaining 40 % Used Account: 122-50011-045-000 DPS Holiday Pay 13,773.02 .00 13,773.02 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,773.02 ** 12,133.00 Budgeted (1,640.02) Remaining 114 % Used Account: 122-50016-045-000 Longevity 3,714.46 .00 3,714.46 _______________ Account: 122-50016-045-000 Longevity Totals: .00 3,714.46 ** 3,647.00 Budgeted (67.46) Remaining 102 % Used Account: 122-50017-045-000 Certification 332 01/20/2012 PAYROLL 1/20/12 Certification 1,569.10 494.70 2,063.80 PR _______________ Account: 122-50017-045-000 Certification Totals: 494.70 2,063.80 ** 4,073.00 Budgeted 2,009.20 Remaining 51 % Used Account: 122-50020-045-000 Retirement 237 01/06/2012 PAYROLL 1/6/2012 Retirement 17,623.98 2,147.19 19,771.17 PR 332 01/20/2012 PAYROLL 1/20/12 Retirement 2,936.15 22,707.32 PR _______________ Account: 122-50020-045-000 Retirement Totals: 5,083.34 22,707.32 ** 68,264.00 Budgeted 45,556.68 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club Entities Page 6 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/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 237 01/06/2012 PAYROLL 1/6/2012 Medical Insurance 10,019.26 1,663.53 11,682.79 PR 332 01/20/2012 PAYROLL 1/20/12 Medical Insurance 1,675.50 13,358.29 PR _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,339.03 13,358.29 ** 53,184.00 Budgeted 39,825.71 Remaining 25 % Used Account: 122-50027-045-000 Dental Insurance 237 01/06/2012 PAYROLL 1/6/2012 Dental Insurance 875.63 145.25 1,020.88 PR 332 01/20/2012 PAYROLL 1/20/12 Dental Insurance 146.50 1,167.38 PR _______________ Account: 122-50027-045-000 Dental Insurance Totals: 291.75 1,167.38 ** 3,288.00 Budgeted 2,120.62 Remaining 36 % Used Account: 122-50028-045-000 Vision Insurance 237 01/06/2012 PAYROLL 1/6/2012 Vision Insurance 197.79 32.83 230.62 PR 332 01/20/2012 PAYROLL 1/20/12 Vision Insurance 33.08 263.70 PR _______________ Account: 122-50028-045-000 Vision Insurance Totals: 65.91 263.70 ** 857.00 Budgeted 593.30 Remaining 31 % 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 237 01/06/2012 PAYROLL 1/6/2012 Social Security Taxes 7,385.54 917.99 8,303.53 PR 332 01/20/2012 PAYROLL 1/20/12 Social Security Taxes 1,280.80 9,584.33 PR _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,198.79 9,584.33 ** 30,231.00 Budgeted 20,646.67 Remaining 32 % Used Account: 122-50035-045-000 Medicare Taxes 237 01/06/2012 PAYROLL 1/6/2012 Medicare Taxes 1,727.30 214.69 1,941.99 PR 332 01/20/2012 PAYROLL 1/20/12 Medicare Taxes 299.61 2,241.60 PR . glpdatb2 rgonzale Trophy Club Entities Page 7 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 514.30 2,241.60 ** 7,070.00 Budgeted 4,828.40 Remaining 32 % Used Account: 122-50040-045-000 Unemployment Taxes 237 01/06/2012 PAYROLL 1/6/2012 Unemployment Taxes 46.29 130.44 176.73 PR 332 01/20/2012 PAYROLL 1/20/12 Unemployment Taxes 177.35 354.08 PR _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 307.79 354.08 ** 1,476.00 Budgeted 1,121.92 Remaining 24 % Used Account: 122-50045-045-000 Workman's Compensation 8,309.50 .00 8,309.50 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 8,309.50 ** 8,793.00 Budgeted 483.50 Remaining 95 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 52.45 .00 52.45 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 52.45 ** 675.00 Budgeted 622.55 Remaining 8 % Used Account: 122-55080-045-000 Maintenance & Repairs 476 01/31/2012 Jan A/P Jan PCard Purchases 79.21 905.00 984.21 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 905.00 984.21 ** 9,562.00 Budgeted 8,577.79 Remaining 10 % Used Account: 122-55090-045-000 Vehicle Maintenance 476 01/31/2012 Jan A/P Jan PCard Purchases 24.95 11.36 36.31 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 219.90 256.21 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 231.26 256.21 ** 14,850.00 Budgeted 14,593.79 Remaining 2 % Used Account: 122-55095-045-000 Equipment Maintenance . glpdatb2 rgonzale Trophy Club Entities Page 8 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 348 01/24/2012 Jan A/P Repair Generator gauge 129.00 1,020.94 1,149.94 HOLT CAT 31179 AP _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: 1,020.94 1,149.94 ** 9,808.00 Budgeted 8,658.06 Remaining 12 % Used Account: 122-55100-045-000 Building Maintenance 462 01/06/2012 Firefighters Cable 2,126.97 (120.00) 2,006.97 GL 476 01/31/2012 Jan A/P Jan PCard Purchases 159.94 2,166.91 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 19.99 2,186.90 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 169.95 2,356.85 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 151.06 2,507.91 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 127.12 2,635.03 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 122-55100-045-000 Building Maintenance Totals: 508.06 2,635.03 ** 11,000.00 Budgeted 8,364.97 Remaining 24 % Used Account: 122-55110-045-000 Maintenance-Radios .00 .00 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 .00 ** 1,103.00 Budgeted 1,103.00 Remaining 0 % Used Account: 122-55160-045-000 Professional Outside Services .00 .00 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 122-60005-045-000 Telephone 321 01/10/2012 Dec A/P Dec P Card SZ 11.09 3.67 14.76 BANK OF AMERICA 31172 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 6.19 20.95 BANK OF AMERICA 31212 AP _______________ Account: 122-60005-045-000 Telephone Totals: 9.86 20.95 ** 106.00 Budgeted 85.05 Remaining 20 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 435 01/31/2012 A/P Invoices Jan Cell phones 632.06 193.65 825.71 VERIZON WIRELESS 31251 AP . glpdatb2 rgonzale Trophy Club Entities Page 9 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 193.65 825.71 ** 4,411.00 Budgeted 3,585.29 Remaining 19 % Used Account: 122-60020-045-000 Electricity/Gas 411 01/31/2012 A/P Invoices Electricity 12/14/11-01/17/12 2,752.79 835.79 3,588.58 HUDSON ENERGY 31201 AP 435 01/31/2012 A/P Invoices FD Gas 12/22-1/20 300.38 3,888.96 ATMOS ENERGY 31209 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 1,136.17 3,888.96 ** 18,270.00 Budgeted 14,381.04 Remaining 21 % Used Account: 122-60025-045-000 Water 435 01/31/2012 A/P Invoices Jan Water 1,266.57 105.22 1,371.79 TROPHY CLUB MUD (WATER BILLS) 31250 AP 435 01/31/2012 A/P Invoices Jan Water 12.71 1,384.50 TROPHY CLUB MUD (WATER BILLS) 31250 AP _______________ Account: 122-60025-045-000 Water Totals: 117.93 1,384.50 ** 3,289.00 Budgeted 1,904.50 Remaining 42 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 308,000.00 Budgeted 308,000.00 Remaining 0 % Used Account: 122-60035-045-000 Postage 448 01/31/2012 January Postage Meter usage 10.59 1.76 12.35 GL _______________ Account: 122-60035-045-000 Postage Totals: 1.76 12.35 ** 97.00 Budgeted 84.65 Remaining 13 % Used Account: 122-60055-045-000 Insurance 8,078.00 .00 8,078.00 _______________ Account: 122-60055-045-000 Insurance Totals: .00 8,078.00 ** 20,974.00 Budgeted 12,896.00 Remaining 39 % Used Account: 122-60066-045-000 Publications/Books/Subscrips . glpdatb2 rgonzale Trophy Club Entities Page 10 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 401.00 Budgeted 401.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 476 01/31/2012 Jan A/P Jan PCard Purchases 5,921.34 209.00 6,130.34 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 209.00 6,130.34 ** 8,560.00 Budgeted 2,429.66 Remaining 72 % Used Account: 122-60080-045-000 Schools & Training 348 01/24/2012 Jan A/P Live Fire Training @ TCC for F 83.47 564.00 647.47 NORTH EAST FIRE DEPT ASSOC 31185 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 150.00 797.47 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 315.00 1,112.47 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 1,029.00 1,112.47 ** 6,946.00 Budgeted 5,833.53 Remaining 16 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem 476 01/31/2012 Jan A/P Jan PCard Purchases 1,620.88 11.55 1,632.43 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 122-60100-045-000 Travel & per diem Totals: 11.55 1,632.43 ** 6,788.00 Budgeted 5,155.57 Remaining 24 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 1,918.00 Budgeted 1,918.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising . glpdatb2 rgonzale Trophy Club Entities Page 11 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 156.00 Budgeted 156.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 339 01/19/2012 January A/P Custodian Attendant/Fire & Lif 624.91 105.00 729.91 NORTHWEST INDEPENDENT SCHOOL 31186 AP 406 01/24/2012 Void A/P Ck 31186/NISD Custodian Attendant/Fire & Lif (105.00) 624.91 NORTHWEST INDEPENDENT SCHOOL 31186 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 281.00 905.91 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 108.85 1,014.76 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 40.00 1,054.76 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 26.94 1,081.70 JPMORGAN CHASE BANK NA 31255 AP 411 01/31/2012 A/P Invoices Office Supplies 15.75 1,097.45 OFFICE DEPOT, INC 31203 AP 435 01/31/2012 A/P Invoices Office Supplies 14.71 1,112.16 OFFICE DEPOT, INC 31228 AP _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 487.25 1,112.16 ** 4,162.00 Budgeted 3,049.84 Remaining 27 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 361.00 .00 361.00 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 361.00 ** 1,900.00 Budgeted 1,539.00 Remaining 19 % Used Account: 122-60195-045-000 Flags & Repair 402.50 .00 402.50 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 402.50 ** 2,543.00 Budgeted 2,140.50 Remaining 16 % Used Account: 122-60245-045-000 Miscellaneous Expense 476 01/31/2012 Jan A/P Jan PCard Purchases 406.57 57.50 464.07 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 36.99 501.06 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 40.36 541.42 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 134.85 541.42 ** 1,237.00 Budgeted 695.58 Remaining 44 % Used Account: 122-65005-045-000 Fuel & Lube . glpdatb2 rgonzale Trophy Club Entities Page 12 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 449 01/31/2012 January Gas Log 688.87 665.42 1,354.29 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 665.42 1,354.29 ** 17,414.00 Budgeted 16,059.71 Remaining 8 % Used Account: 122-65010-045-000 Uniforms 406.50 .00 406.50 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 406.50 ** 4,357.00 Budgeted 3,950.50 Remaining 9 % Used Account: 122-65015-045-000 Protective Clothing 83.50 .00 83.50 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 83.50 ** 7,600.00 Budgeted 7,516.50 Remaining 1 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 1,545.00 Budgeted 1,545.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 476 01/31/2012 Jan A/P Jan PCard Purchases 454.71 15.25 469.96 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 122-65035-045-000 Small Tools Totals: 15.25 469.96 ** 8,371.00 Budgeted 7,901.04 Remaining 6 % Used Account: 122-65085-045-000 Office Supplies 435 01/31/2012 A/P Invoices Office Supplies 499.51 96.38 595.89 OFFICE DEPOT, INC 31228 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 33.15 629.04 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 129.53 629.04 ** 329.00 Budgeted (300.04) Remaining 191 % Used Account: 122-65095-045-000 Maintenance Supplies . glpdatb2 rgonzale Trophy Club Entities Page 13 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 435 01/31/2012 A/P Invoices Jan purchases 373.99 50.29 424.28 COSTCO WHOLESALE 31215 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 165.82 590.10 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 14.37 604.47 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 185.37 789.84 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 21.90 811.74 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 437.75 811.74 ** 2,785.00 Budgeted 1,973.26 Remaining 29 % 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 476 01/31/2012 Jan A/P Jan PCard Purchases 11,014.78 375.00 11,389.78 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 122-69035-045-000 Vehicles Totals: 375.00 11,389.78 ** 13,709.00 Budgeted 2,319.22 Remaining 83 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 41,890.00 Budgeted 41,890.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 14 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-69251-045-000 Engine 681 Payment .00 .00 _______________ Account: 122-69251-045-000 Engine 681 Payment Totals: .00 .00 ** 73,203.00 Budgeted 73,203.00 Remaining 0 % Used Account: 122-69255-045-000 Airpacks .00 .00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 13,865.00 Budgeted 13,865.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 263,337.59 ** 1,311,934.00 Budgeted 1,048,596.41 Remaining 20 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (865,346.05) .00 Budgeted 865,346.05 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 15 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/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 362 01/03/2012 Property Taxes (36,466.54) (1,003.53) (37,470.07) GL 363 01/04/2012 Property Taxes (10,421.88) (47,891.95) GL 364 01/05/2012 Property Taxes (2,576.77) (50,468.72) GL 366 01/06/2012 Property Taxes (962.24) (51,430.96) GL 367 01/09/2012 Property Taxes (914.36) (52,345.32) GL 368 01/10/2012 Property Taxes (14,940.25) (67,285.57) GL 369 01/11/2012 Property Taxes (2,798.29) (70,083.86) GL 370 01/12/2012 Property Taxes (449.29) (70,533.15) GL 371 01/13/2012 Property Taxes (566.29) (71,099.44) GL 372 01/17/2012 Property Taxes (979.72) (72,079.16) GL 373 01/18/2012 Property Taxes (790.01) (72,869.17) GL 374 01/19/2012 Property Taxes (1,410.48) (74,279.65) GL 375 01/20/2012 Property Taxes (317.93) (74,597.58) GL 376 01/23/2012 Property Taxes (705.49) (75,303.07) GL 377 01/24/2012 Property Taxes (1,817.10) (77,120.17) GL 378 01/25/2012 Property Taxes (3,780.13) (80,900.30) GL 379 01/26/2012 Property Taxes (433.54) (81,333.84) GL 421 01/27/2012 Property Taxes (1,264.63) (82,598.47) GL 422 01/30/2012 Property Taxes (677.63) (83,276.10) GL 423 01/31/2012 Property Taxes (1,858.33) (85,134.43) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (48,667.89) (85,134.43) ** (97,495.00) Budgeted (12,360.57) Remaining 87 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 365 01/05/2012 Property Taxes 726.28 (54.76) 671.52 GL 370 01/12/2012 Property Taxes (.95) 670.57 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (55.71) 670.57 ** (451.00) Budgeted (1,121.57) Remaining ########## Account: 135-40015-000-000 Property Taxes/P & I 362 01/03/2012 Property Taxes 334.51 (4.54) 329.97 GL 363 01/04/2012 Property Taxes (.42) 329.55 GL 365 01/05/2012 Property Taxes (38.88) 290.67 GL 367 01/09/2012 Property Taxes (6.01) 284.66 GL 370 01/12/2012 Property Taxes (.41) 284.25 GL 421 01/27/2012 Property Taxes (2.83) 281.42 GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (53.09) 281.42 ** (1,334.00) Budgeted (1,615.42) Remaining -21 % Used . glpdatb2 rgonzale Trophy Club Entities Page 16 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/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-43215-000-000 Insurance Settlement 463 01/13/2012 TML/Ins Hach Sampler (1,776.36) (1,776.36) GL 464 01/18/2012 TML/Ins Hach Sampler (2,222.64) (3,999.00) GL _______________ Account: 135-43215-000-000 Insurance Settlement Totals: (3,999.00) (3,999.00) ** .00 Budgeted 3,999.00 Remaining 0 % Used Account: 135-47000-000-000 Water 308 01/06/2012 UB 01/06/2012 Adjustments UB 20120106-20120106 User: (405,528.10) 12.20 (405,515.90) UB 324 01/11/2012 UB 01/11/2012 Credit Adjust. UB 20120111-20120111 User: (26.88) (405,542.78) UB 335 01/18/2012 UB 01/18/2012 Adjustments UB 20120118-20120118 User: 58.15 (405,484.63) UB 354 01/25/2012 UB 01/25/2012 Adjustments UB 20120125-20120125 User: 59.20 (405,425.43) UB 407 01/31/2012 UB 01/31/2012 Charge UB 20120131-20120131 User: (84,433.31) (489,858.74) UB 408 01/31/2012 UB 01/31/2012 Credit Adjust. UB 20120131-20120131 User: (3,757.07) (493,615.81) UB _______________ Account: 135-47000-000-000 Water Totals: (88,087.71) (493,615.81) ** (1,990,800.00) Budgeted (1,497,184.19) Remaining 25 % Used Account: 135-47005-000-000 Sewer 247 01/04/2012 UB 01/04/2012 Adjustments UB 20120104-20120104 User: (271,030.26) 12.71 (271,017.55) UB 308 01/06/2012 UB 01/06/2012 Adjustments UB 20120106-20120106 User: 12.20 (271,005.35) UB 324 01/11/2012 UB 01/11/2012 Credit Adjust. UB 20120111-20120111 User: 11.01 (270,994.34) UB 335 01/18/2012 UB 01/18/2012 Adjustments UB 20120118-20120118 User: 12.50 (270,981.84) UB 354 01/25/2012 UB 01/25/2012 Adjustments UB 20120125-20120125 User: 5.00 (270,976.84) UB 407 01/31/2012 UB 01/31/2012 Charge UB 20120131-20120131 User: (74,294.12) (345,270.96) UB 408 01/31/2012 UB 01/31/2012 Credit Adjust. UB 20120131-20120131 User: 2,410.32 (342,860.64) UB _______________ Account: 135-47005-000-000 Sewer Totals: (71,830.38) (342,860.64) ** (1,325,000.00) Budgeted (982,139.36) Remaining 26 % Used Account: 135-47010-000-000 Commercial Water 407 01/31/2012 UB 01/31/2012 Charge UB 20120131-20120131 User: (175,599.14) (29,659.38) (205,258.52) UB 408 01/31/2012 UB 01/31/2012 Credit Adjust. UB 20120131-20120131 User: 104.24 (205,154.28) UB _______________ Account: 135-47010-000-000 Commercial Water Totals: (29,555.14) (205,154.28) ** (825,000.00) Budgeted (619,845.72) Remaining 25 % Used Account: 135-47015-000-000 Commercial Sewer 407 01/31/2012 UB 01/31/2012 Charge UB 20120131-20120131 User: (71,203.37) (18,265.36) (89,468.73) UB . glpdatb2 rgonzale Trophy Club Entities Page 17 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 408 01/31/2012 UB 01/31/2012 Credit Adjust. UB 20120131-20120131 User: (71,203.37) 106.79 (89,361.94) UB _______________ Account: 135-47015-000-000 Commercial Sewer Totals: (18,158.57) (89,361.94) ** (360,000.00) Budgeted (270,638.06) Remaining 25 % Used Account: 135-47020-000-000 Standby 407 01/31/2012 UB 01/31/2012 Charge UB 20120131-20120131 User: (205.00) (72.00) (277.00) UB _______________ Account: 135-47020-000-000 Standby Totals: (72.00) (277.00) ** (775.00) Budgeted (498.00) Remaining 36 % Used Account: 135-47025-000-000 Penalties 247 01/04/2012 UB 01/04/2012 Adjustments UB 20120104-20120104 User: (20,048.93) 98.81 (19,950.12) UB 288 01/05/2012 UB 01/05/2012 Adjustments UB 20120105-20120105 User: 9.60 (19,940.52) UB 343 01/20/2012 UB 01/20/2012 Adjustments UB 20120120-20120120 User: 3,502.39 (16,438.13) UB 345 01/23/2012 UB 01/23/2012 Charge UB 20120123-20120123 User: (4,423.34) (20,861.47) UB 397 01/30/2012 UB 01/30/2012 Adjustments UB 20120130-20120130 User: 504.21 (20,357.26) UB 401 01/31/2012 UB 01/31/2012 Adjustments UB 20120131-20120131 User: 38.29 (20,318.97) UB 408 01/31/2012 UB 01/31/2012 Credit Adjust. UB 20120131-20120131 User: (550.00) (20,868.97) UB _______________ Account: 135-47025-000-000 Penalties Totals: (820.04) (20,868.97) ** (50,500.00) Budgeted (29,631.03) Remaining 41 % Used Account: 135-47030-000-000 Service Charges 311 01/03/2012 UB 1/3/12 ADJUSTMENTS UB 20120103-20120103 User: (4,176.66) (25.00) (4,201.66) UB 288 01/05/2012 UB 01/05/2012 Adjustments UB 20120105-20120105 User: (1,725.00) (5,926.66) UB 343 01/20/2012 UB 01/20/2012 Adjustments UB 20120120-20120120 User: (75.00) (6,001.66) UB 358 01/23/2012 UB 1/23/2012 Adjustments UB 20120123-20120123 User: (25.00) (6,026.66) UB 360 01/23/2012 UB 1/23/2012 Adjustments UB 20120123-20120123 User: (25.00) (6,051.66) UB 394 01/26/2012 UB 1/26/12 Adjustments UB 20120126-20120126 User: (25.00) (6,076.66) UB 407 01/31/2012 UB 01/31/2012 Charge UB 20120131-20120131 User: (3.00) (6,079.66) UB 408 01/31/2012 UB 01/31/2012 Credit Adjust. UB 20120131-20120131 User: 93.28 (5,986.38) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,809.72) (5,986.38) ** (17,500.00) Budgeted (11,513.62) Remaining 34 % Used Account: 135-47035-000-000 Plumbing Inspections 381 01/04/2012 Permits 1/4/12 (500.00) (100.00) (600.00) GL 387 01/20/2012 Permits 1/20/12 (50.00) (650.00) GL . glpdatb2 rgonzale Trophy Club Entities Page 18 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 425 01/27/2012 Permits 1/27/12 (500.00) (50.00) (700.00) GL 426 01/31/2012 Permits 1/31/12 (50.00) (750.00) GL _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (250.00) (750.00) ** (1,200.00) Budgeted (450.00) Remaining 63 % Used Account: 135-47045-000-000 Sewer Inspections 381 01/04/2012 Permits 1/4/12 (1,500.00) (300.00) (1,800.00) GL 387 01/20/2012 Permits 1/20/12 (150.00) (1,950.00) GL 425 01/27/2012 Permits 1/27/12 (150.00) (2,100.00) GL 426 01/31/2012 Permits 1/31/12 (150.00) (2,250.00) GL _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (750.00) (2,250.00) ** (4,500.00) Budgeted (2,250.00) Remaining 50 % Used Account: 135-47070-000-000 TCCC Effluent Charges (8,212.62) .00 (8,212.62) _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (8,212.62) ** (57,500.00) Budgeted (49,287.38) Remaining 14 % Used Account: 135-47270-000-000 Fire Line .00 .00 _______________ Account: 135-47270-000-000 Fire Line Totals: .00 .00 ** (5,000.00) Budgeted (5,000.00) Remaining 0 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 407 01/31/2012 UB 01/31/2012 Charge UB 20120131-20120131 User: (15,002.88) (219.68) (15,222.56) UB _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: (219.68) (15,222.56) ** (41,595.00) Budgeted (26,372.44) Remaining 37 % Used Account: 135-47405-000-000 Out of District Sewer 407 01/31/2012 UB 01/31/2012 Charge UB 20120131-20120131 User: (2,729.57) (850.23) (3,579.80) UB _______________ Account: 135-47405-000-000 Out of District Sewer Totals: (850.23) (3,579.80) ** (11,807.00) Budgeted (8,227.20) Remaining 30 % Used . glpdatb2 rgonzale Trophy Club Entities Page 19 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/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-47410-000-000 Out of Dist/Portable Penalties (28.31) .00 (28.31) _______________ Account: 135-47410-000-000 Out of Dist/Portable Penalties Totals: .00 (28.31) ** (300.00) Budgeted (271.69) Remaining 9 % Used Account: 135-47600-000-000 PID #1 Water 407 01/31/2012 UB 01/31/2012 Charge UB 20120131-20120131 User: (104,117.96) (21,747.05) (125,865.01) UB 408 01/31/2012 UB 01/31/2012 Credit Adjust. UB 20120131-20120131 User: (485.87) (126,350.88) UB _______________ Account: 135-47600-000-000 PID #1 Water Totals: (22,232.92) (126,350.88) ** (425,000.00) Budgeted (298,649.12) Remaining 30 % Used Account: 135-47605-000-000 PID #1 Sewer 407 01/31/2012 UB 01/31/2012 Charge UB 20120131-20120131 User: (53,880.86) (15,979.22) (69,860.08) UB 408 01/31/2012 UB 01/31/2012 Credit Adjust. UB 20120131-20120131 User: 416.97 (69,443.11) UB _______________ Account: 135-47605-000-000 PID #1 Sewer Totals: (15,562.25) (69,443.11) ** (185,000.00) Budgeted (115,556.89) Remaining 38 % Used Account: 135-48005-000-000 Utility Fees 380 01/03/2012 Permits 1/3/12 (184,780.00) (9,200.00) (193,980.00) GL 381 01/04/2012 Permits 1/4/12 (6,900.00) (200,880.00) GL 382 01/05/2012 Permits 1/5/12 (4,600.00) (205,480.00) GL 383 01/06/2012 Permits 1/6/12 (2,300.00) (207,780.00) GL 385 01/17/2012 Permits 1/17/12 (6,900.00) (214,680.00) GL 387 01/20/2012 Permits 1/20/12 (6,900.00) (221,580.00) GL 388 01/23/2012 Permits 1/23/12 (2,300.00) (223,880.00) GL 389 01/26/2012 Permits 1/26/12 (18,400.00) (242,280.00) GL 425 01/27/2012 Permits 1/27/12 (4,600.00) (246,880.00) GL 427 01/30/2012 Permits 1/30/12 (16,100.00) (262,980.00) GL 426 01/31/2012 Permits 1/31/12 (2,300.00) (265,280.00) GL _______________ Account: 135-48005-000-000 Utility Fees Totals: (80,500.00) (265,280.00) ** (338,880.00) Budgeted (73,600.00) Remaining 78 % Used Account: 135-49005-000-000 Loan Proceeds 469 01/18/2012 Revenue Note 2012 Proceeds (1,100,000.00) (1,100,000.00) GL . glpdatb2 rgonzale Trophy Club Entities Page 20 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49005-000-000 Loan Proceeds Totals: (1,100,000.00) (1,100,000.00) ** .00 Budgeted 1,100,000.00 Remaining 0 % Used Account: 135-49010-000-000 Interest Income 443 01/31/2012 Texpool Interest (1,038.32) (317.44) (1,355.76) GL 444 01/31/2012 FF Bank Interest (1.11) (1,356.87) GL 444 01/31/2012 FF Bank Interest (82.09) (1,438.96) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (400.64) (1,438.96) ** (4,500.00) Budgeted (3,061.04) Remaining 32 % Used Account: 135-49016-000-000 Cell Tower Revenue 457 01/03/2012 AT&T/Cell Tower revenue (2,541.00) (847.00) (3,388.00) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (847.00) (3,388.00) ** (10,164.00) Budgeted (6,776.00) Remaining 33 % Used Account: 135-49018-000-000 Building Rent Income 467 01/27/2012 Town Maint Barn rent/Jan (1,749.99) (583.33) (2,333.32) GL _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,333.32) ** (7,000.00) Budgeted (4,666.68) Remaining 33 % Used Account: 135-49030-000-000 Vending Revenue (32.50) .00 (32.50) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (32.50) ** (600.00) Budgeted (567.50) Remaining 5 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (265,707.00) Budgeted (265,707.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves . glpdatb2 rgonzale Trophy Club Entities Page 21 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (26,911.00) Budgeted (26,911.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 380 01/03/2012 Permits 1/3/12 (27,354.00) (1,168.00) (28,522.00) GL 381 01/04/2012 Permits 1/4/12 (1,460.00) (29,982.00) GL 382 01/05/2012 Permits 1/5/12 (584.00) (30,566.00) GL 383 01/06/2012 Permits 1/6/12 (292.00) (30,858.00) GL 384 01/10/2012 Permits 1/10/12 (3,986.07) (34,844.07) GL 385 01/17/2012 Permits 1/17/12 (876.00) (35,720.07) GL 387 01/20/2012 Permits 1/20/12 (1,168.00) (36,888.07) GL 388 01/23/2012 Permits 1/23/12 (292.00) (37,180.07) GL 389 01/26/2012 Permits 1/26/12 (2,336.00) (39,516.07) GL 425 01/27/2012 Permits 1/27/12 (876.00) (40,392.07) GL 427 01/30/2012 Permits 1/30/12 (2,044.00) (42,436.07) GL 426 01/31/2012 Permits 1/31/12 (584.00) (43,020.07) GL _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (15,666.07) (43,020.07) ** (64,000.00) Budgeted (20,979.93) Remaining 67 % Used Account: 135-49900-000-000 Miscellaneous Income 384 01/10/2012 Permits 1/10/12 (333.49) (25.00) (358.49) GL 386 01/19/2012 Permits 1/19/12 (75.00) (433.49) GL 465 01/27/2012 Constellation New Energy (2,294.62) (2,728.11) GL 476 01/31/2012 Jan A/P Permit deposited in MUD acct i 25.00 (2,703.11) TOWN OF TROPHY CLUB 31261 AP _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (2,369.62) (2,703.11) ** (10,000.00) Budgeted (7,296.89) Remaining 27 % Used Account: 135-49905-000-000 Gas Well Revenue 456 01/03/2012 Encana/Gas Well Revenue (48.62) (37.92) (86.54) GL 458 01/04/2012 Encana/Gas Well Revenue (36.46) (123.00) GL _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: (74.38) (123.00) ** (800.00) Budgeted (677.00) Remaining 15 % Used Department Totals: ------------------------------------------------------------------------------------------------ (2,890,462.70) ** (6,129,319.00) Budgeted (3,238,856.30) Remaining 47 % Used . glpdatb2 rgonzale Trophy Club Entities Page 22 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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 237 01/06/2012 PAYROLL 1/6/2012 Salaries & Wages 34,599.38 6,290.73 40,890.11 PR 332 01/20/2012 PAYROLL 1/20/12 Salaries & Wages 6,290.53 47,180.64 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 12,581.26 47,180.64 ** 199,759.00 Budgeted 152,578.36 Remaining 24 % Used Account: 135-50010-010-000 Overtime 237 01/06/2012 PAYROLL 1/6/2012 Overtime 3,064.49 1,292.58 4,357.07 PR 332 01/20/2012 PAYROLL 1/20/12 Overtime 517.87 4,874.94 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,810.45 4,874.94 ** 13,250.00 Budgeted 8,375.06 Remaining 37 % 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 332 01/20/2012 PAYROLL 1/20/12 Certification 450.00 150.00 600.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 150.00 600.00 ** 1,800.00 Budgeted 1,200.00 Remaining 33 % Used Account: 135-50020-010-000 Retirement 237 01/06/2012 PAYROLL 1/6/2012 Retirement 6,244.98 1,048.01 7,292.99 PR 332 01/20/2012 PAYROLL 1/20/12 Retirement 961.65 8,254.64 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,009.66 8,254.64 ** 25,508.00 Budgeted 17,253.36 Remaining 32 % Used Account: 135-50026-010-000 Medical Insurance 237 01/06/2012 PAYROLL 1/6/2012 Medical Insurance 5,651.82 941.97 6,593.79 PR 332 01/20/2012 PAYROLL 1/20/12 Medical Insurance 941.97 7,535.76 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,883.94 7,535.76 ** 22,607.00 Budgeted 15,071.24 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club Entities Page 23 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 237 01/06/2012 PAYROLL 1/6/2012 Dental Insurance 402.84 67.14 469.98 PR 332 01/20/2012 PAYROLL 1/20/12 Dental Insurance 67.14 537.12 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 134.28 537.12 ** 2,169.00 Budgeted 1,631.88 Remaining 25 % Used Account: 135-50028-010-000 Vision Insurance 237 01/06/2012 PAYROLL 1/6/2012 Vision Insurance 95.28 15.88 111.16 PR 332 01/20/2012 PAYROLL 1/20/12 Vision Insurance 15.88 127.04 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 31.76 127.04 ** 576.00 Budgeted 448.96 Remaining 22 % 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 237 01/06/2012 PAYROLL 1/6/2012 Social Security Taxes 2,574.63 443.55 3,018.18 PR 332 01/20/2012 PAYROLL 1/20/12 Social Security Taxes 404.79 3,422.97 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 848.34 3,422.97 ** 13,481.00 Budgeted 10,058.03 Remaining 25 % Used Account: 135-50035-010-000 Medicare Taxes 237 01/06/2012 PAYROLL 1/6/2012 Medicare Taxes 602.13 103.73 705.86 PR 332 01/20/2012 PAYROLL 1/20/12 Medicare Taxes 94.67 800.53 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 198.40 800.53 ** 3,153.00 Budgeted 2,352.47 Remaining 25 % Used Account: 135-50040-010-000 Unemployment Taxes 237 01/06/2012 PAYROLL 1/6/2012 Unemployment Taxes 60.67 60.67 PR 332 01/20/2012 PAYROLL 1/20/12 Unemployment Taxes 55.66 116.33 PR . glpdatb2 rgonzale Trophy Club Entities Page 24 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 116.33 116.33 ** 945.00 Budgeted 828.67 Remaining 12 % Used Account: 135-50045-010-000 Workman's Compensation 5,581.00 .00 5,581.00 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 5,581.00 ** 5,581.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations 47.59 .00 47.59 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 47.59 ** 350.00 Budgeted 302.41 Remaining 14 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55070-010-000 Independent Labor .00 .00 _______________ Account: 135-55070-010-000 Independent Labor Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 476 01/31/2012 Jan A/P Jan PCard Purchases 7,782.41 53.92 7,836.33 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 194.25 8,030.58 JPMORGAN CHASE BANK NA 31255 AP . glpdatb2 rgonzale Trophy Club Entities Page 25 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 476 01/31/2012 Jan A/P Jan PCard Purchases 7,782.41 25.08 8,055.66 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 148.93 8,204.59 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 284.60 8,489.19 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 708.75 9,197.94 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 66.77 9,264.71 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,482.30 9,264.71 ** 29,500.00 Budgeted 20,235.29 Remaining 31 % Used Account: 135-55090-010-000 Vehicle Maintenance 1,889.77 .00 1,889.77 _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 1,889.77 ** 3,380.00 Budgeted 1,490.23 Remaining 56 % Used Account: 135-55100-010-000 Building Maint & Supplies 471.85 .00 471.85 _______________ Account: 135-55100-010-000 Building Maint & Supplies Totals: .00 471.85 ** 750.00 Budgeted 278.15 Remaining 63 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 476 01/31/2012 Jan A/P Jan PCard Purchases 450.00 450.00 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 450.00 450.00 ** 2,900.00 Budgeted 2,450.00 Remaining 16 % Used Account: 135-55135-010-000 Lab Analysis 435 01/31/2012 A/P Invoices Water testing 540.00 200.00 740.00 TARRANT CTY PUBLIC HEALTH LAB 31247 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 200.00 740.00 ** 4,500.00 Budgeted 3,760.00 Remaining 16 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 435 01/31/2012 A/P Invoices Jan Cell phones 480.98 162.50 643.48 VERIZON WIRELESS 31251 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 162.50 643.48 ** 1,599.00 Budgeted 955.52 Remaining 40 % Used . glpdatb2 rgonzale Trophy Club Entities Page 26 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-010-000 Electricity 339 01/19/2012 January A/P Electricity 12/5-1/5 20,238.48 242.75 20,481.23 TRI COUNTY ELECTRIC 31193 AP 348 01/24/2012 Jan A/P Electricity 12/14-1/17 54.64 20,535.87 HUDSON ENERGY 31180 AP _______________ Account: 135-60020-010-000 Electricity Totals: 297.39 20,535.87 ** 162,000.00 Budgeted 141,464.13 Remaining 13 % Used Account: 135-60035-010-000 Postage 6.51 .00 6.51 _______________ Account: 135-60035-010-000 Postage Totals: .00 6.51 ** 500.00 Budgeted 493.49 Remaining 1 % Used Account: 135-60050-010-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-010-000 Bad Debt Expense Totals: .00 .00 ** 4,200.00 Budgeted 4,200.00 Remaining 0 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 476 01/31/2012 Jan A/P Jan PCard Purchases 446.00 315.00 761.00 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 315.00 761.00 ** 2,800.00 Budgeted 2,039.00 Remaining 27 % Used Account: 135-60090-010-000 Safety Program . glpdatb2 rgonzale Trophy Club Entities Page 27 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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-60090-010-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 237 01/06/2012 PAYROLL 1/6/2012 Travel & per diem 365.22 135.42 500.64 PR 332 01/20/2012 PAYROLL 1/20/12 Travel & per diem 76.04 576.68 PR _______________ Account: 135-60100-010-000 Travel & per diem Totals: 211.46 576.68 ** 3,200.00 Budgeted 2,623.32 Remaining 18 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60135-010-000 Annual Permit Fee 7,965.75 .00 7,965.75 _______________ Account: 135-60135-010-000 Annual Permit Fee Totals: .00 7,965.75 ** 6,600.00 Budgeted (1,365.75) Remaining 121 % Used Account: 135-60150-010-000 Bulk Water 435 01/31/2012 A/P Invoices Dec Bulk Water 279,934.37 88,876.39 368,810.76 CITY OF FORT WORTH 31213 AP _______________ Account: 135-60150-010-000 Bulk Water Totals: 88,876.39 368,810.76 ** 1,720,000.00 Budgeted 1,351,189.24 Remaining 21 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance . glpdatb2 rgonzale Trophy Club Entities Page 28 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 .00 ** 4,200.00 Budgeted 4,200.00 Remaining 0 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 299.99 .00 299.99 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 299.99 ** 1,500.00 Budgeted 1,200.01 Remaining 20 % Used Account: 135-65005-010-000 Fuel & Lube 449 01/31/2012 January Gas Log 3,230.60 1,424.41 4,655.01 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,424.41 4,655.01 ** 15,216.00 Budgeted 10,560.99 Remaining 31 % Used Account: 135-65010-010-000 Uniforms 476 01/31/2012 Jan A/P Jan PCard Purchases 753.18 270.97 1,024.15 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-65010-010-000 Uniforms Totals: 270.97 1,024.15 ** 3,690.00 Budgeted 2,665.85 Remaining 28 % Used Account: 135-65030-010-000 Chemicals 1,066.47 .00 1,066.47 _______________ Account: 135-65030-010-000 Chemicals Totals: .00 1,066.47 ** 6,200.00 Budgeted 5,133.53 Remaining 17 % Used Account: 135-65035-010-000 Small Tools 68.00 .00 68.00 . glpdatb2 rgonzale Trophy Club Entities Page 29 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-010-000 Small Tools Totals: .00 68.00 ** 2,500.00 Budgeted 2,432.00 Remaining 3 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 476 01/31/2012 Jan A/P Jan PCard Purchases 56,103.00 2,466.00 58,569.00 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 1,224.00 59,793.00 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 3,826.07 63,619.07 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 7,516.07 63,619.07 ** 85,000.00 Budgeted 21,380.93 Remaining 75 % Used Account: 135-65055-010-000 Hardware .00 .00 _______________ Account: 135-65055-010-000 Hardware Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65095-010-000 Maintenance Supplies 435 01/31/2012 A/P Invoices Jan purchases 6,811.54 91.88 6,903.42 COSTCO WHOLESALE 31215 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 85.00 6,988.42 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 3,161.66 10,150.08 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-65095-010-000 Maintenance Supplies Totals: 3,338.54 10,150.08 ** 32,000.00 Budgeted 21,849.92 Remaining 32 % Used Account: 135-65100-010-000 Copies .00 .00 _______________ Account: 135-65100-010-000 Copies Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 30 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65105-010-000 Printing 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 475 01/25/2012 Retainage/Phoenix App 4 494,747.19 17,143.00 511,890.19 GL 476 01/31/2012 Jan A/P Ground Storage Expansion App 4 325,717.00 837,607.19 PHOENIX FABRICATORS & ERECTORS AP _______________ Account: 135-69005-010-000 Capital Expenses Totals: 342,860.00 837,607.19 ** 888,432.00 Budgeted 50,824.81 Remaining 94 % Used Account: 135-69035-010-000 Vehicles 476 01/31/2012 Jan A/P Jan PCard Purchases 375.00 375.00 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-69035-010-000 Vehicles Totals: 375.00 375.00 ** 27,000.00 Budgeted 26,625.00 Remaining 1 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-69280-010-000 Capital Repairs .00 .00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** 24,000.00 Budgeted 24,000.00 Remaining 0 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 339 01/19/2012 January A/P Annual/Water Plant #1 East 69,788.02 31,028.52 100,816.54 UTILITY SERVICE CO, INC. 31195 AP _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: 31,028.52 100,816.54 ** 124,771.00 Budgeted 23,954.46 Remaining 81 % Used Account: 135-69295-010-000 Unexpected Maintenance . glpdatb2 rgonzale Trophy Club Entities Page 31 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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-69295-010-000 Unexpected Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-69305-010-000 Capital Leases .00 .00 _______________ Account: 135-69305-010-000 Capital Leases Totals: .00 .00 ** 11,490.00 Budgeted 11,490.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,513,554.94 ** 3,501,238.00 Budgeted 1,987,683.06 Remaining 43 % Used . glpdatb2 rgonzale Trophy Club Entities Page 32 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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 237 01/06/2012 PAYROLL 1/6/2012 Salaries & Wages 49,679.01 7,058.51 56,737.52 PR 332 01/20/2012 PAYROLL 1/20/12 Salaries & Wages 7,058.51 63,796.03 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,117.02 63,796.03 ** 182,147.00 Budgeted 118,350.97 Remaining 35 % Used Account: 135-50010-020-000 Overtime 237 01/06/2012 PAYROLL 1/6/2012 Overtime 3,207.94 110.72 3,318.66 PR 332 01/20/2012 PAYROLL 1/20/12 Overtime 644.41 3,963.07 PR _______________ Account: 135-50010-020-000 Overtime Totals: 755.13 3,963.07 ** 10,166.00 Budgeted 6,202.93 Remaining 39 % 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 332 01/20/2012 PAYROLL 1/20/12 Certification 450.00 125.00 575.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 125.00 575.00 ** 2,400.00 Budgeted 1,825.00 Remaining 24 % Used Account: 135-50020-020-000 Retirement 237 01/06/2012 PAYROLL 1/6/2012 Retirement 8,624.43 990.79 9,615.22 PR 332 01/20/2012 PAYROLL 1/20/12 Retirement 1,081.81 10,697.03 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,072.60 10,697.03 ** 27,816.00 Budgeted 17,118.97 Remaining 38 % Used Account: 135-50026-020-000 Medical Insurance 237 01/06/2012 PAYROLL 1/6/2012 Medical Insurance 6,367.00 1,072.69 7,439.69 PR 332 01/20/2012 PAYROLL 1/20/12 Medical Insurance 1,072.69 8,512.38 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,145.38 8,512.38 ** 30,805.00 Budgeted 22,292.62 Remaining 28 % Used . glpdatb2 rgonzale Trophy Club Entities Page 33 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 237 01/06/2012 PAYROLL 1/6/2012 Dental Insurance 488.26 82.68 570.94 PR 332 01/20/2012 PAYROLL 1/20/12 Dental Insurance 82.68 653.62 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 165.36 653.62 ** 1,981.00 Budgeted 1,327.38 Remaining 33 % Used Account: 135-50028-020-000 Vision Insurance 237 01/06/2012 PAYROLL 1/6/2012 Vision Insurance 121.56 20.60 142.16 PR 332 01/20/2012 PAYROLL 1/20/12 Vision Insurance 20.60 162.76 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 41.20 162.76 ** 552.00 Budgeted 389.24 Remaining 29 % 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 237 01/06/2012 PAYROLL 1/6/2012 Social Security Taxes 3,449.53 395.46 3,844.99 PR 332 01/20/2012 PAYROLL 1/20/12 Social Security Taxes 437.86 4,282.85 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 833.32 4,282.85 ** 8,597.00 Budgeted 4,314.15 Remaining 50 % Used Account: 135-50035-020-000 Medicare Taxes 237 01/06/2012 PAYROLL 1/6/2012 Medicare Taxes 806.72 92.49 899.21 PR 332 01/20/2012 PAYROLL 1/20/12 Medicare Taxes 102.39 1,001.60 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 194.88 1,001.60 ** 2,011.00 Budgeted 1,009.40 Remaining 50 % Used Account: 135-50040-020-000 Unemployment Taxes 237 01/06/2012 PAYROLL 1/6/2012 Unemployment Taxes 27.84 57.36 85.20 PR 332 01/20/2012 PAYROLL 1/20/12 Unemployment Taxes 62.62 147.82 PR . glpdatb2 rgonzale Trophy Club Entities Page 34 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 119.98 147.82 ** 567.00 Budgeted 419.18 Remaining 26 % Used Account: 135-50045-020-000 Workman's Compensation 2,685.00 .00 2,685.00 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 2,685.00 ** 2,685.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 30.45 .00 30.45 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 30.45 ** 200.00 Budgeted 169.55 Remaining 15 % Used Account: 135-50070-020-000 Employee Relations 20.00 .00 20.00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 20.00 ** 350.00 Budgeted 330.00 Remaining 6 % Used Account: 135-55070-020-000 Independent Labor 411 01/31/2012 A/P Invoices Repair cable at gate to WWTP 1,305.67 1,305.67 RAM COMM, INC 31204 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 1,305.67 1,305.67 ** 750.00 Budgeted (555.67) Remaining 174 % Used Account: 135-55080-020-000 Maintenance & Repairs 435 01/31/2012 A/P Invoices Antifreeze, bolts, nuts, stud 14,525.24 45.14 14,570.38 LANDMARK EQUIPMENT, INC 31222 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 70.04 14,640.42 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 79.23 14,719.65 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 476.36 15,196.01 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 82.09 15,278.10 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 752.86 15,278.10 ** 17,750.00 Budgeted 2,471.90 Remaining 86 % Used . glpdatb2 rgonzale Trophy Club Entities Page 35 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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 .00 .00 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 .00 ** 4,998.00 Budgeted 4,998.00 Remaining 0 % Used Account: 135-55100-020-000 Building Maint & Supplies .00 .00 _______________ Account: 135-55100-020-000 Building Maint & Supplies Totals: .00 .00 ** 1,400.00 Budgeted 1,400.00 Remaining 0 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 476 01/31/2012 Jan A/P Jan PCard Purchases 134.00 134.00 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 134.00 134.00 ** 2,950.00 Budgeted 2,816.00 Remaining 5 % Used Account: 135-55125-020-000 Dumpster Services 411 01/31/2012 A/P Invoices Sludge Haul off 9,137.50 537.50 9,675.00 CHANEY ENVIRONMENTAL 31198 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 537.50 9,675.00 ** 35,000.00 Budgeted 25,325.00 Remaining 28 % Used Account: 135-55135-020-000 Lab Analysis 313 01/09/2012 Jan A/P Lab Analysis 3,382.32 467.50 3,849.82 TALEM, INC 31167 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 467.50 3,849.82 ** 22,760.00 Budgeted 18,910.18 Remaining 17 % Used Account: 135-60005-020-000 Telephone 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 6.76 3.83 10.59 BANK OF AMERICA 31212 AP _______________ Account: 135-60005-020-000 Telephone Totals: 3.83 10.59 ** 100.00 Budgeted 89.41 Remaining 11 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club Entities Page 36 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 435 01/31/2012 A/P Invoices Jan Cell phones 651.43 236.80 888.23 VERIZON WIRELESS 31251 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 236.80 888.23 ** 3,000.00 Budgeted 2,111.77 Remaining 30 % Used Account: 135-60020-020-000 Electricity 23,307.74 .00 23,307.74 _______________ Account: 135-60020-020-000 Electricity Totals: .00 23,307.74 ** 205,000.00 Budgeted 181,692.26 Remaining 11 % Used Account: 135-60025-020-000 Water 435 01/31/2012 A/P Invoices Jan Water 876.32 261.41 1,137.73 TROPHY CLUB MUD (WATER BILLS) 31250 AP _______________ Account: 135-60025-020-000 Water Totals: 261.41 1,137.73 ** 1,900.00 Budgeted 762.27 Remaining 60 % Used Account: 135-60035-020-000 Postage .00 .00 _______________ Account: 135-60035-020-000 Postage Totals: .00 .00 ** 120.00 Budgeted 120.00 Remaining 0 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 438.17 .00 438.17 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 438.17 ** 500.00 Budgeted 61.83 Remaining 88 % Used Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 1,320.00 Budgeted 1,320.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 37 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 237 01/06/2012 PAYROLL 1/6/2012 Travel & per diem 489.51 23.31 512.82 PR 332 01/20/2012 PAYROLL 1/20/12 Travel & per diem 93.24 606.06 PR _______________ Account: 135-60100-020-000 Travel & per diem Totals: 116.55 606.06 ** 1,750.00 Budgeted 1,143.94 Remaining 35 % Used Account: 135-60105-020-000 Rent/Lease Equipment 901.30 .00 901.30 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 901.30 ** 200.00 Budgeted (701.30) Remaining 451 % Used Account: 135-60125-020-000 Advertising 987.36 .00 987.36 _______________ Account: 135-60125-020-000 Advertising Totals: .00 987.36 ** 1,000.00 Budgeted 12.64 Remaining 99 % Used Account: 135-60135-020-000 Annual Permit Fee 7,432.50 .00 7,432.50 _______________ Account: 135-60135-020-000 Annual Permit Fee Totals: .00 7,432.50 ** 7,500.00 Budgeted 67.50 Remaining 99 % Used Account: 135-60245-020-000 Miscellaneous Expenses 476 01/31/2012 Jan A/P Jan PCard Purchases 64.00 64.00 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: 64.00 64.00 ** 525.00 Budgeted 461.00 Remaining 12 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 38 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 525.00 Budgeted 525.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 449 01/31/2012 January Gas Log 754.48 462.71 1,217.19 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 462.71 1,217.19 ** 6,875.00 Budgeted 5,657.81 Remaining 18 % Used Account: 135-65010-020-000 Uniforms 476 01/31/2012 Jan A/P Jan PCard Purchases 645.96 270.97 916.93 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 270.97 916.93 ** 3,140.00 Budgeted 2,223.07 Remaining 29 % Used Account: 135-65030-020-000 Chemicals 2,557.57 .00 2,557.57 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 2,557.57 ** 13,180.00 Budgeted 10,622.43 Remaining 19 % Used Account: 135-65035-020-000 Small Tools .00 .00 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment 476 01/31/2012 Jan A/P Jan PCard Purchases 22.75 22.75 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 22.75 22.75 ** 925.00 Budgeted 902.25 Remaining 2 % Used Account: 135-65045-020-000 Lab Supplies 2,699.84 .00 2,699.84 . glpdatb2 rgonzale Trophy Club Entities Page 39 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65045-020-000 Lab Supplies Totals: .00 2,699.84 ** 19,160.00 Budgeted 16,460.16 Remaining 14 % Used Account: 135-65055-020-000 Hardware .00 .00 _______________ Account: 135-65055-020-000 Hardware Totals: .00 .00 ** 525.00 Budgeted 525.00 Remaining 0 % Used Account: 135-65085-020-000 Office Supplies 50.58 .00 50.58 _______________ Account: 135-65085-020-000 Office Supplies Totals: .00 50.58 ** 400.00 Budgeted 349.42 Remaining 13 % Used Account: 135-65095-020-000 Maintenance Supplies 435 01/31/2012 A/P Invoices Jan purchases 661.79 5.45 667.24 COSTCO WHOLESALE 31215 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 33.58 700.82 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 6.76 707.58 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 13.43 721.01 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 79.08 800.09 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Nitrile P.F. Blue Gloves 120.45 920.54 B & G CHEMICAL SALES 31254 AP _______________ Account: 135-65095-020-000 Maintenance Supplies Totals: 258.75 920.54 ** 8,860.00 Budgeted 7,939.46 Remaining 10 % 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 34,800.26 .00 34,800.26 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .00 34,800.26 ** 161,189.00 Budgeted 126,388.74 Remaining 22 % Used . glpdatb2 rgonzale Trophy Club Entities Page 40 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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-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: ------------------------------------------------------------------------------------------------ 209,704.54 ** 856,009.00 Budgeted 646,304.46 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club Entities Page 41 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/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 237 01/06/2012 PAYROLL 1/6/2012 Salaries & Wages 30,475.48 5,541.08 36,016.56 PR 332 01/20/2012 PAYROLL 1/20/12 Salaries & Wages 5,541.08 41,557.64 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,082.16 41,557.64 ** 145,481.00 Budgeted 103,923.36 Remaining 29 % Used Account: 135-50010-021-000 Overtime 237 01/06/2012 PAYROLL 1/6/2012 Overtime 2,278.07 263.70 2,541.77 PR 332 01/20/2012 PAYROLL 1/20/12 Overtime 333.19 2,874.96 PR _______________ Account: 135-50010-021-000 Overtime Totals: 596.89 2,874.96 ** 7,297.00 Budgeted 4,422.04 Remaining 39 % 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 332 01/20/2012 PAYROLL 1/20/12 Certification 375.00 125.00 500.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 125.00 500.00 ** 1,500.00 Budgeted 1,000.00 Remaining 33 % Used Account: 135-50020-021-000 Retirement 237 01/06/2012 PAYROLL 1/6/2012 Retirement 5,613.61 802.23 6,415.84 PR 332 01/20/2012 PAYROLL 1/20/12 Retirement 829.09 7,244.93 PR _______________ Account: 135-50020-021-000 Retirement Totals: 1,631.32 7,244.93 ** 21,074.00 Budgeted 13,829.07 Remaining 34 % Used Account: 135-50026-021-000 Medical Insurance 237 01/06/2012 PAYROLL 1/6/2012 Medical Insurance 5,108.04 851.34 5,959.38 PR 332 01/20/2012 PAYROLL 1/20/12 Medical Insurance 851.34 6,810.72 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,702.68 6,810.72 ** 22,983.00 Budgeted 16,172.28 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club Entities Page 42 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-021-000 Dental Insurance 237 01/06/2012 PAYROLL 1/6/2012 Dental Insurance 352.14 58.69 410.83 PR 332 01/20/2012 PAYROLL 1/20/12 Dental Insurance 58.69 469.52 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 117.38 469.52 ** 1,533.00 Budgeted 1,063.48 Remaining 31 % Used Account: 135-50028-021-000 Vision Insurance 237 01/06/2012 PAYROLL 1/6/2012 Vision Insurance 89.16 14.86 104.02 PR 332 01/20/2012 PAYROLL 1/20/12 Vision Insurance 14.86 118.88 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 29.72 118.88 ** 357.00 Budgeted 238.12 Remaining 33 % 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 237 01/06/2012 PAYROLL 1/6/2012 Social Security Taxes 2,281.00 330.41 2,611.41 PR 332 01/20/2012 PAYROLL 1/20/12 Social Security Taxes 342.46 2,953.87 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 672.87 2,953.87 ** 9,785.00 Budgeted 6,831.13 Remaining 30 % Used Account: 135-50035-021-000 Medicare Taxes 237 01/06/2012 PAYROLL 1/6/2012 Medicare Taxes 533.46 77.27 610.73 PR 332 01/20/2012 PAYROLL 1/20/12 Medicare Taxes 80.10 690.83 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 157.37 690.83 ** 2,288.00 Budgeted 1,597.17 Remaining 30 % Used Account: 135-50040-021-000 Unemployment Taxes 237 01/06/2012 PAYROLL 1/6/2012 Unemployment Taxes 46.44 46.44 PR 332 01/20/2012 PAYROLL 1/20/12 Unemployment Taxes 47.99 94.43 PR . glpdatb2 rgonzale Trophy Club Entities Page 43 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: 94.43 94.43 ** 567.00 Budgeted 472.57 Remaining 17 % Used Account: 135-50045-021-000 Workman's Compensation 3,056.00 .00 3,056.00 _______________ Account: 135-50045-021-000 Workman's Compensation Totals: .00 3,056.00 ** 3,056.00 Budgeted .00 Remaining 100 % Used Account: 135-50070-021-000 Employee Relations 19.97 .00 19.97 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 19.97 ** 250.00 Budgeted 230.03 Remaining 8 % Used Account: 135-55005-021-000 Engineering .00 .00 _______________ Account: 135-55005-021-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55070-021-000 Independent Labor .00 .00 _______________ Account: 135-55070-021-000 Independent Labor Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 2,815.85 .00 2,815.85 _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: .00 2,815.85 ** 23,700.00 Budgeted 20,884.15 Remaining 12 % Used Account: 135-55090-021-000 Vehicle Maintenance 130.00 .00 130.00 . glpdatb2 rgonzale Trophy Club Entities Page 44 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 130.00 ** 1,943.00 Budgeted 1,813.00 Remaining 7 % Used Account: 135-55100-021-000 Building Maint & Supplies .00 .00 _______________ Account: 135-55100-021-000 Building Maint & Supplies Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60005-021-000 Telephone 318 01/09/2012 Void A/P Check 31162/BOA Dec P Card purchases 11.18 (.19) 10.99 BANK OF AMERICA 31162 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases .19 11.18 BANK OF AMERICA 31212 AP _______________ Account: 135-60005-021-000 Telephone Totals: .00 11.18 ** 50.00 Budgeted 38.82 Remaining 22 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 240 01/03/2012 Jan A/P PID Inverted Siphon/Call out m 610.32 276.00 886.32 OMNISITE 31139 AP 435 01/31/2012 A/P Invoices Jan Cell phones 454.03 1,340.35 VERIZON WIRELESS 31251 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 730.03 1,340.35 ** 2,796.00 Budgeted 1,455.65 Remaining 48 % Used Account: 135-60020-021-000 Electricity 339 01/19/2012 January A/P Electricity 12/5-1/5 2,092.94 120.84 2,213.78 TRI COUNTY ELECTRIC 31193 AP 339 01/19/2012 January A/P Electricity 12/5-1/5 27.87 2,241.65 TRI COUNTY ELECTRIC 31193 AP _______________ Account: 135-60020-021-000 Electricity Totals: 148.71 2,241.65 ** 23,625.00 Budgeted 21,383.35 Remaining 9 % Used Account: 135-60025-021-000 Water .00 .00 _______________ Account: 135-60025-021-000 Water Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60035-021-000 Postage . glpdatb2 rgonzale Trophy Club Entities Page 45 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60035-021-000 Postage Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 255.00 Budgeted 255.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training .00 .00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 .00 ** 2,818.00 Budgeted 2,818.00 Remaining 0 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 237 01/06/2012 PAYROLL 1/6/2012 Travel & per diem 267.53 32.19 299.72 PR 332 01/20/2012 PAYROLL 1/20/12 Travel & per diem 35.52 335.24 PR _______________ Account: 135-60100-021-000 Travel & per diem Totals: 67.71 335.24 ** 1,500.00 Budgeted 1,164.76 Remaining 22 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 76,098.00 Budgeted 76,098.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club Entities Page 46 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60245-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 449 01/31/2012 January Gas Log 2,597.84 648.89 3,246.73 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 648.89 3,246.73 ** 11,700.00 Budgeted 8,453.27 Remaining 28 % Used Account: 135-65010-021-000 Uniforms 476 01/31/2012 Jan A/P Jan PCard Purchases 350.00 270.98 620.98 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-65010-021-000 Uniforms Totals: 270.98 620.98 ** 2,505.00 Budgeted 1,884.02 Remaining 25 % Used Account: 135-65030-021-000 Chemicals .00 .00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 .00 ** 12,500.00 Budgeted 12,500.00 Remaining 0 % Used Account: 135-65035-021-000 Small Tools .00 .00 _______________ 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 476 01/31/2012 Jan A/P Jan PCard Purchases 22.74 22.74 JPMORGAN CHASE BANK NA 31255 AP . glpdatb2 rgonzale Trophy Club Entities Page 47 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/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-021-000 Safety Equipment Totals: 22.74 22.74 ** 1,150.00 Budgeted 1,127.26 Remaining 2 % Used Account: 135-65055-021-000 Hardware 44.95 .00 44.95 _______________ Account: 135-65055-021-000 Hardware Totals: .00 44.95 ** 750.00 Budgeted 705.05 Remaining 6 % Used Account: 135-65095-021-000 Maintenance Supplies 435 01/31/2012 A/P Invoices Jan purchases 15.12 123.26 138.38 COSTCO WHOLESALE 31215 AP _______________ Account: 135-65095-021-000 Maintenance Supplies Totals: 123.26 138.38 ** 16,050.00 Budgeted 15,911.62 Remaining 1 % Used Account: 135-69005-021-000 Capital Expenses 31,991.00 .00 31,991.00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 31,991.00 ** 15,000.00 Budgeted (16,991.00) Remaining 213 % Used Account: 135-69280-021-000 Capital Repairs .00 .00 _______________ Account: 135-69280-021-000 Capital Repairs Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 112,878.30 ** 439,837.00 Budgeted 326,958.70 Remaining 26 % Used . glpdatb2 rgonzale Trophy Club Entities Page 48 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/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 237 01/06/2012 PAYROLL 1/6/2012 Salaries & Wages 1,300.00 500.00 1,800.00 PR 332 01/20/2012 PAYROLL 1/20/12 Salaries & Wages 500.00 2,300.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,000.00 2,300.00 ** 10,000.00 Budgeted 7,700.00 Remaining 23 % Used Account: 135-50030-026-000 Social Security Taxes 237 01/06/2012 PAYROLL 1/6/2012 Social Security Taxes 80.60 31.00 111.60 PR 332 01/20/2012 PAYROLL 1/20/12 Social Security Taxes 31.00 142.60 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 62.00 142.60 ** 620.00 Budgeted 477.40 Remaining 23 % Used Account: 135-50035-026-000 Medicare Taxes 237 01/06/2012 PAYROLL 1/6/2012 Medicare Taxes 18.85 7.25 26.10 PR 332 01/20/2012 PAYROLL 1/20/12 Medicare Taxes 7.25 33.35 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 14.50 33.35 ** 145.00 Budgeted 111.65 Remaining 23 % Used Account: 135-50040-026-000 Unemployment Taxes 237 01/06/2012 PAYROLL 1/6/2012 Unemployment Taxes 10.40 4.00 14.40 PR 332 01/20/2012 PAYROLL 1/20/12 Unemployment Taxes 4.00 18.40 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 8.00 18.40 ** 210.00 Budgeted 191.60 Remaining 9 % 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 339 01/19/2012 January A/P Water Smart Application Binder 26.11 26.11 FEDERAL EXPRESS CORP 31177 AP _______________ Account: 135-60035-026-000 Postage Totals: 26.11 26.11 ** .00 Budgeted (26.11) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 49 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 685.00 .00 685.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 685.00 ** 2,100.00 Budgeted 1,415.00 Remaining 33 % Used Account: 135-60075-026-000 Meetings 174.82 .00 174.82 _______________ Account: 135-60075-026-000 Meetings Totals: .00 174.82 ** 1,278.00 Budgeted 1,103.18 Remaining 14 % Used Account: 135-60080-026-000 Schools & Training 875.00 .00 875.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 875.00 ** 4,150.00 Budgeted 3,275.00 Remaining 21 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 6,199.00 Budgeted 6,199.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 3,200.00 Budgeted 3,200.00 Remaining 0 % Used Account: 135-65085-026-000 Office Supplies . glpdatb2 rgonzale Trophy Club Entities Page 50 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 8.90 .00 8.90 _______________ Account: 135-65085-026-000 Office Supplies Totals: .00 8.90 ** 50.00 Budgeted 41.10 Remaining 18 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 4,384.18 ** 28,122.00 Budgeted 23,737.82 Remaining 16 % Used . glpdatb2 rgonzale Trophy Club Entities Page 51 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 1/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 237 01/06/2012 PAYROLL 1/6/2012 Salaries & Wages 37,794.33 6,955.43 44,749.76 PR 332 01/20/2012 PAYROLL 1/20/12 Salaries & Wages 8,647.73 53,397.49 PR _______________ Account: 135-50005-027-000 Salaries & Wages Totals: 15,603.16 53,397.49 ** 236,831.00 Budgeted 183,433.51 Remaining 23 % Used Account: 135-50010-027-000 Overtime 237 01/06/2012 PAYROLL 1/6/2012 Overtime 841.30 139.67 980.97 PR 332 01/20/2012 PAYROLL 1/20/12 Overtime 8.58 989.55 PR _______________ Account: 135-50010-027-000 Overtime Totals: 148.25 989.55 ** 1,000.00 Budgeted 10.45 Remaining 99 % Used Account: 135-50016-027-000 Longevity 1,845.00 .00 1,845.00 _______________ Account: 135-50016-027-000 Longevity Totals: .00 1,845.00 ** 1,845.00 Budgeted .00 Remaining 100 % Used Account: 135-50020-027-000 Retirement 237 01/06/2012 PAYROLL 1/6/2012 Retirement 6,138.34 980.54 7,118.88 PR 332 01/20/2012 PAYROLL 1/20/12 Retirement 1,196.31 8,315.19 PR _______________ Account: 135-50020-027-000 Retirement Totals: 2,176.85 8,315.19 ** 33,471.00 Budgeted 25,155.81 Remaining 25 % Used Account: 135-50026-027-000 Medical Insurance 237 01/06/2012 PAYROLL 1/6/2012 Medical Insurance 3,744.65 663.42 4,408.07 PR 332 01/20/2012 PAYROLL 1/20/12 Medical Insurance 789.57 5,197.64 PR _______________ Account: 135-50026-027-000 Medical Insurance Totals: 1,452.99 5,197.64 ** 18,798.00 Budgeted 13,600.36 Remaining 28 % Used Account: 135-50027-027-000 Dental Insurance 237 01/06/2012 PAYROLL 1/6/2012 Dental Insurance 279.94 49.09 329.03 PR 332 01/20/2012 PAYROLL 1/20/12 Dental Insurance 60.81 389.84 PR . glpdatb2 rgonzale Trophy Club Entities Page 52 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-027-000 Dental Insurance Totals: 109.90 389.84 ** 1,242.00 Budgeted 852.16 Remaining 31 % Used Account: 135-50028-027-000 Vision Insurance 237 01/06/2012 PAYROLL 1/6/2012 Vision Insurance 70.82 12.52 83.34 PR 332 01/20/2012 PAYROLL 1/20/12 Vision Insurance 15.23 98.57 PR _______________ Account: 135-50028-027-000 Vision Insurance Totals: 27.75 98.57 ** 341.00 Budgeted 242.43 Remaining 29 % 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 237 01/06/2012 PAYROLL 1/6/2012 Social Security Taxes 2,402.34 417.83 2,820.17 PR 332 01/20/2012 PAYROLL 1/20/12 Social Security Taxes 507.86 3,328.03 PR _______________ Account: 135-50030-027-000 Social Security Taxes Totals: 925.69 3,328.03 ** 14,860.00 Budgeted 11,531.97 Remaining 22 % Used Account: 135-50035-027-000 Medicare Taxes 237 01/06/2012 PAYROLL 1/6/2012 Medicare Taxes 599.75 97.72 697.47 PR 332 01/20/2012 PAYROLL 1/20/12 Medicare Taxes 118.77 816.24 PR _______________ Account: 135-50035-027-000 Medicare Taxes Totals: 216.49 816.24 ** 3,475.00 Budgeted 2,658.76 Remaining 23 % Used Account: 135-50040-027-000 Unemployment Taxes 237 01/06/2012 PAYROLL 1/6/2012 Unemployment Taxes 9.97 56.78 66.75 PR 332 01/20/2012 PAYROLL 1/20/12 Unemployment Taxes 69.24 135.99 PR _______________ Account: 135-50040-027-000 Unemployment Taxes Totals: 126.02 135.99 ** 756.00 Budgeted 620.01 Remaining 18 % Used . glpdatb2 rgonzale Trophy Club Entities Page 53 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 1/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-027-000 Workman's Compensation 580.00 .00 580.00 _______________ Account: 135-50045-027-000 Workman's Compensation Totals: .00 580.00 ** 580.00 Budgeted .00 Remaining 100 % Used Account: 135-50070-027-000 Employee Relations 476 01/31/2012 Jan A/P Jan PCard Purchases 3,311.20 45.58 3,356.78 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 5.99 3,362.77 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 5.99 3,368.76 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-50070-027-000 Employee Relations Totals: 57.56 3,368.76 ** 5,000.00 Budgeted 1,631.24 Remaining 67 % Used Account: 135-55070-027-000 Independent Labor 339 01/19/2012 January A/P Record MUD meeting 75.00 30.00 105.00 MIGUEL CRUZ 31184 AP 411 01/31/2012 A/P Invoices Record MUD meeting 33.75 138.75 MIGUEL CRUZ 31202 AP _______________ Account: 135-55070-027-000 Independent Labor Totals: 63.75 138.75 ** 840.00 Budgeted 701.25 Remaining 17 % Used Account: 135-55075-027-000 Records Management .00 .00 _______________ Account: 135-55075-027-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55160-027-000 Professional Outside Services 95,384.68 .00 95,384.68 _______________ Account: 135-55160-027-000 Professional Outside Services Totals: .00 95,384.68 ** 176,870.00 Budgeted 81,485.32 Remaining 54 % Used Account: 135-60005-027-000 Telephone 318 01/09/2012 Void A/P Check 31162/BOA Dec P Card purchases 77.58 (21.43) 56.15 BANK OF AMERICA 31162 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 21.43 77.58 BANK OF AMERICA 31212 AP _______________ Account: 135-60005-027-000 Telephone Totals: .00 77.58 ** 300.00 Budgeted 222.42 Remaining 26 % Used . glpdatb2 rgonzale Trophy Club Entities Page 54 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60010-027-000 Communications/Pagers/Mobiles 435 01/31/2012 A/P Invoices Jan Cell phones 420.27 402.43 822.70 VERIZON WIRELESS 31251 AP _______________ Account: 135-60010-027-000 Communications/Pagers/Mobiles Totals: 402.43 822.70 ** 2,420.00 Budgeted 1,597.30 Remaining 34 % Used Account: 135-60035-027-000 Postage 459 01/04/2012 Postage 433.24 (.44) 432.80 GL 339 01/19/2012 January A/P Paperwork to McCall Parkhurst 27.93 460.73 FEDERAL EXPRESS CORP 31177 AP 348 01/24/2012 Jan A/P Overnight to Pam Liston 26.56 487.29 FEDERAL EXPRESS CORP 31177 AP 411 01/31/2012 A/P Invoices Overnight docs to Pam Liston 22.04 509.33 FEDERAL EXPRESS CORP 31200 AP 448 01/31/2012 January Postage Meter usage 15.76 525.09 GL _______________ Account: 135-60035-027-000 Postage Totals: 91.85 525.09 ** 1,000.00 Budgeted 474.91 Remaining 53 % Used Account: 135-60066-027-000 Publications/Books/Subscripts 114.75 .00 114.75 _______________ Account: 135-60066-027-000 Publications/Books/Subscripts Totals: .00 114.75 ** 450.00 Budgeted 335.25 Remaining 26 % Used Account: 135-60070-027-000 Dues & Memberships 421.05 .00 421.05 _______________ Account: 135-60070-027-000 Dues & Memberships Totals: .00 421.05 ** 1,742.00 Budgeted 1,320.95 Remaining 24 % Used Account: 135-60075-027-000 Meetings .00 .00 _______________ Account: 135-60075-027-000 Meetings Totals: .00 .00 ** 312.00 Budgeted 312.00 Remaining 0 % Used Account: 135-60080-027-000 Schools & Training 435 01/31/2012 A/P Invoices AWBD Conf/Scott 130.00 315.00 445.00 AWBD 31210 AP _______________ Account: 135-60080-027-000 Schools & Training Totals: 315.00 445.00 ** 2,555.00 Budgeted 2,110.00 Remaining 17 % Used . glpdatb2 rgonzale Trophy Club Entities Page 55 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60100-027-000 Travel & per diem 332 01/20/2012 PAYROLL 1/20/12 Travel & per diem 97.90 29.97 127.87 PR _______________ Account: 135-60100-027-000 Travel & per diem Totals: 29.97 127.87 ** 3,851.00 Budgeted 3,723.13 Remaining 3 % Used Account: 135-60115-027-000 Elections .00 .00 _______________ Account: 135-60115-027-000 Elections Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60125-027-000 Advertising .00 .00 _______________ Account: 135-60125-027-000 Advertising Totals: .00 .00 ** 4,700.00 Budgeted 4,700.00 Remaining 0 % Used Account: 135-60245-027-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-027-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-60270-027-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-027-000 4th of July Celebration Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60360-027-000 Furniture/Equipment < $5000 299.99 .00 299.99 _______________ Account: 135-60360-027-000 Furniture/Equipment < $5000 Totals: .00 299.99 ** 2,225.00 Budgeted 1,925.01 Remaining 13 % Used Account: 135-65085-027-000 Office Supplies . glpdatb2 rgonzale Trophy Club Entities Page 56 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 339 01/19/2012 January A/P Office Supplies 361.99 59.99 421.98 OFFICE DEPOT, INC 31187 AP 411 01/31/2012 A/P Invoices Office Supplies 16.80 438.78 OFFICE DEPOT, INC 31203 AP 411 01/31/2012 A/P Invoices Office Supplies 7.20 445.98 OFFICE DEPOT, INC 31203 AP 435 01/31/2012 A/P Invoices Office Supplies 87.05 533.03 OFFICE DEPOT, INC 31228 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 7.50 540.53 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 1.88 542.41 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-65085-027-000 Office Supplies Totals: 180.42 542.41 ** 2,450.00 Budgeted 1,907.59 Remaining 22 % Used Account: 135-65105-027-000 Printing 395.00 .00 395.00 _______________ Account: 135-65105-027-000 Printing Totals: .00 395.00 ** 515.00 Budgeted 120.00 Remaining 77 % Used Department 27 Totals: ------------------------------------------------------------------------------------------------ 177,757.17 ** 532,866.00 Budgeted 355,108.83 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club Entities Page 57 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 1/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 476 01/31/2012 Jan A/P Jan PCard Purchases 1,411.10 5.00 1,416.10 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 4.49 1,420.59 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 45.46 1,466.05 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 4.17 1,470.22 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-50070-028-000 Employee Relations Totals: 59.12 1,470.22 ** 1,967.00 Budgeted 496.78 Remaining 75 % Used Account: 135-50075-028-000 Tuition Reimbursement 411 01/31/2012 A/P Invoices Tuition Reimbursement 19.95 19.95 DONNIE GENE HURD II 31199 AP _______________ Account: 135-50075-028-000 Tuition Reimbursement Totals: 19.95 19.95 ** 1,561.00 Budgeted 1,541.05 Remaining 1 % Used Account: 135-60005-028-000 Telephone .00 .00 _______________ Account: 135-60005-028-000 Telephone Totals: .00 .00 ** 28.00 Budgeted 28.00 Remaining 0 % Used Account: 135-60035-028-000 Postage .00 .00 _______________ Account: 135-60035-028-000 Postage Totals: .00 .00 ** 106.00 Budgeted 106.00 Remaining 0 % Used Account: 135-60066-028-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-028-000 Publications/Books/Subscripts Totals: .00 .00 ** 485.00 Budgeted 485.00 Remaining 0 % Used Account: 135-60070-028-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-028-000 Dues & Memberships Totals: .00 .00 ** 555.00 Budgeted 555.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 58 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60075-028-000 Meetings .00 .00 _______________ Account: 135-60075-028-000 Meetings Totals: .00 .00 ** 138.00 Budgeted 138.00 Remaining 0 % Used Account: 135-60080-028-000 Schools & Training .00 .00 _______________ Account: 135-60080-028-000 Schools & Training Totals: .00 .00 ** 594.00 Budgeted 594.00 Remaining 0 % Used Account: 135-60100-028-000 Travel & per diem .00 .00 _______________ Account: 135-60100-028-000 Travel & per diem Totals: .00 .00 ** 8.00 Budgeted 8.00 Remaining 0 % Used Account: 135-60110-028-000 Physicals/Testing 105.00 .00 105.00 _______________ Account: 135-60110-028-000 Physicals/Testing Totals: .00 105.00 ** 1,560.00 Budgeted 1,455.00 Remaining 7 % Used Account: 135-65085-028-000 Office Supplies .00 .00 _______________ Account: 135-65085-028-000 Office Supplies Totals: .00 .00 ** 437.00 Budgeted 437.00 Remaining 0 % Used Account: 135-65105-028-000 Printing .00 .00 _______________ Account: 135-65105-028-000 Printing Totals: .00 .00 ** 116.00 Budgeted 116.00 Remaining 0 % Used Department 28 Totals: ------------------------------------------------------------------------------------------------ 1,595.17 ** 7,555.00 Budgeted 5,959.83 Remaining 21 % Used . glpdatb2 rgonzale Trophy Club Entities Page 59 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 1/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 237 01/06/2012 PAYROLL 1/6/2012 Salaries & Wages 20,617.63 3,750.00 24,367.63 PR 332 01/20/2012 PAYROLL 1/20/12 Salaries & Wages 2,942.31 27,309.94 PR _______________ Account: 135-50005-029-000 Salaries & Wages Totals: 6,692.31 27,309.94 ** 94,404.00 Budgeted 67,094.06 Remaining 29 % Used Account: 135-50010-029-000 Overtime 237 01/06/2012 PAYROLL 1/6/2012 Overtime 810.44 135.84 946.28 PR _______________ Account: 135-50010-029-000 Overtime Totals: 135.84 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 237 01/06/2012 PAYROLL 1/6/2012 Retirement 3,562.30 537.02 4,099.32 PR 332 01/20/2012 PAYROLL 1/20/12 Retirement 406.62 4,505.94 PR _______________ Account: 135-50020-029-000 Retirement Totals: 943.64 4,505.94 ** 13,612.00 Budgeted 9,106.06 Remaining 33 % Used Account: 135-50026-029-000 Medical Insurance 237 01/06/2012 PAYROLL 1/6/2012 Medical Insurance 2,764.74 340.29 3,105.03 PR 332 01/20/2012 PAYROLL 1/20/12 Medical Insurance 205.35 3,310.38 PR _______________ Account: 135-50026-029-000 Medical Insurance Totals: 545.64 3,310.38 ** 11,060.00 Budgeted 7,749.62 Remaining 30 % Used Account: 135-50027-029-000 Dental Insurance 237 01/06/2012 PAYROLL 1/6/2012 Dental Insurance 220.55 36.77 257.32 PR 332 01/20/2012 PAYROLL 1/20/12 Dental Insurance 24.51 281.83 PR _______________ Account: 135-50027-029-000 Dental Insurance Totals: 61.28 281.83 ** 773.00 Budgeted 491.17 Remaining 36 % Used . glpdatb2 rgonzale Trophy Club Entities Page 60 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 1/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 237 01/06/2012 PAYROLL 1/6/2012 Vision Insurance 37.48 6.25 43.73 PR 332 01/20/2012 PAYROLL 1/20/12 Vision Insurance 3.38 47.11 PR _______________ Account: 135-50028-029-000 Vision Insurance Totals: 9.63 47.11 ** 207.00 Budgeted 159.89 Remaining 23 % 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 237 01/06/2012 PAYROLL 1/6/2012 Social Security Taxes 1,355.07 220.68 1,575.75 PR 332 01/20/2012 PAYROLL 1/20/12 Social Security Taxes 169.27 1,745.02 PR _______________ Account: 135-50030-029-000 Social Security Taxes Totals: 389.95 1,745.02 ** 5,386.00 Budgeted 3,640.98 Remaining 32 % Used Account: 135-50035-029-000 Medicare Taxes 237 01/06/2012 PAYROLL 1/6/2012 Medicare Taxes 316.92 51.61 368.53 PR 332 01/20/2012 PAYROLL 1/20/12 Medicare Taxes 39.59 408.12 PR _______________ Account: 135-50035-029-000 Medicare Taxes Totals: 91.20 408.12 ** 1,260.00 Budgeted 851.88 Remaining 32 % Used Account: 135-50040-029-000 Unemployment Taxes 237 01/06/2012 PAYROLL 1/6/2012 Unemployment Taxes 31.08 31.08 PR 332 01/20/2012 PAYROLL 1/20/12 Unemployment Taxes 23.54 54.62 PR _______________ Account: 135-50040-029-000 Unemployment Taxes Totals: 54.62 54.62 ** 284.00 Budgeted 229.38 Remaining 19 % Used Account: 135-50045-029-000 Workman's Compensation 211.00 .00 211.00 _______________ Account: 135-50045-029-000 Workman's Compensation Totals: .00 211.00 ** 235.00 Budgeted 24.00 Remaining 90 % Used . glpdatb2 rgonzale Trophy Club Entities Page 61 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 1/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 437 01/31/2012 Jan A/P Invoices November Conv, support 973.50 973.50 STW INC 31245 AP _______________ Account: 135-55160-029-000 Professional Outside Services Totals: 973.50 973.50 ** 5,000.00 Budgeted 4,026.50 Remaining 19 % Used Account: 135-60005-029-000 Telephone 318 01/09/2012 Void A/P Check 31162/BOA Dec P Card purchases 31.37 (17.51) 13.86 BANK OF AMERICA 31162 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 17.51 31.37 BANK OF AMERICA 31212 AP _______________ Account: 135-60005-029-000 Telephone Totals: .00 31.37 ** 103.00 Budgeted 71.63 Remaining 30 % Used Account: 135-60010-029-000 Communications/Pagers/Mobiles 435 01/31/2012 A/P Invoices Jan Cell phones 149.97 51.85 201.82 VERIZON WIRELESS 31251 AP _______________ Account: 135-60010-029-000 Communications/Pagers/Mobiles Totals: 51.85 201.82 ** 683.00 Budgeted 481.18 Remaining 30 % Used Account: 135-60035-029-000 Postage 448 01/31/2012 January Postage Meter usage 59.84 37.15 96.99 GL _______________ Account: 135-60035-029-000 Postage Totals: 37.15 96.99 ** 700.00 Budgeted 603.01 Remaining 14 % Used Account: 135-60040-029-000 Service Charges & Fees 32.50 .00 32.50 _______________ Account: 135-60040-029-000 Service Charges & Fees Totals: .00 32.50 ** 79.00 Budgeted 46.50 Remaining 41 % Used Account: 135-60066-029-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-029-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-029-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club Entities Page 62 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60070-029-000 Dues & Memberships Totals: .00 .00 ** 660.00 Budgeted 660.00 Remaining 0 % Used Account: 135-60075-029-000 Meetings 22.00 .00 22.00 _______________ Account: 135-60075-029-000 Meetings Totals: .00 22.00 ** 300.00 Budgeted 278.00 Remaining 7 % Used Account: 135-60080-029-000 Schools & Training .00 .00 _______________ Account: 135-60080-029-000 Schools & Training Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60100-029-000 Travel & per diem 15.04 .00 15.04 _______________ Account: 135-60100-029-000 Travel & per diem Totals: .00 15.04 ** 1,500.00 Budgeted 1,484.96 Remaining 1 % 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 476 01/31/2012 Jan A/P Jan PCard Purchases 21.50 56.98 78.48 JPMORGAN CHASE BANK NA 31255 AP . glpdatb2 rgonzale Trophy Club Entities Page 63 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 1/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: 56.98 78.48 ** 849.00 Budgeted 770.52 Remaining 9 % 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: ------------------------------------------------------------------------------------------------ 42,094.44 ** 144,910.00 Budgeted 102,815.56 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club Entities Page 64 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 1/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 313 01/09/2012 Jan A/P Monthly Internet Service 16,729.56 326.69 17,056.25 BANDWIDTH.COM, INC. 31161 AP 318 01/09/2012 Void A/P Check 31162/BOA Dec P Card purchases (54.99) 17,001.26 BANK OF AMERICA 31162 AP 318 01/09/2012 Void A/P Check 31162/BOA 11/28-12/27 P Card Purchases (124.50) 16,876.76 BANK OF AMERICA 31162 AP 318 01/09/2012 Void A/P Check 31162/BOA 11/28-12/27 P Card Purchases (25.00) 16,851.76 BANK OF AMERICA 31162 AP 318 01/09/2012 Void A/P Check 31162/BOA 11/28-12/27 P Card Purchases (272.50) 16,579.26 BANK OF AMERICA 31162 AP 318 01/09/2012 Void A/P Check 31162/BOA Dec P Card purchases (13.49) 16,565.77 BANK OF AMERICA 31162 AP 318 01/09/2012 Void A/P Check 31162/BOA Dec P Card purchases (53.38) 16,512.39 BANK OF AMERICA 31162 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 25.00 16,537.39 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 9.99 16,547.38 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases .08 16,547.46 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 224.50 16,771.96 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 124.50 16,896.46 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 54.99 16,951.45 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 53.38 17,004.83 BANK OF AMERICA 31212 AP 437 01/31/2012 Jan A/P Invoices November Conv, support 7,792.21 24,797.04 STW INC 31245 AP _______________ Account: 135-55030-033-000 Software & Support Totals: 8,067.48 24,797.04 ** 64,149.00 Budgeted 39,351.96 Remaining 39 % 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 318 01/09/2012 Void A/P Check 31162/BOA Dec P Card purchases 2,862.33 (243.90) 2,618.43 BANK OF AMERICA 31162 AP 318 01/09/2012 Void A/P Check 31162/BOA Dec P Card purchases (367.83) 2,250.60 BANK OF AMERICA 31162 AP 453 01/27/2012 A/P Invoices 12/28-1/27 PCard Purchases-Ste 365.94 2,616.54 BANK OF AMERICA 31253 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 392.09 3,008.63 BANK OF AMERICA 31212 AP _______________ Account: 135-60005-033-000 Telephone Totals: 146.30 3,008.63 ** 6,540.00 Budgeted 3,531.37 Remaining 46 % Used Account: 135-60235-033-000 Security .00 .00 _______________ Account: 135-60235-033-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 65 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65055-033-000 Hardware 318 01/09/2012 Void A/P Check 31162/BOA 11/28-12/27 P Card Purchases 57,680.57 (175.25) 57,505.32 BANK OF AMERICA 31162 AP 318 01/09/2012 Void A/P Check 31162/BOA Dec P Card purchases (172.49) 57,332.83 BANK OF AMERICA 31162 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 45.79 57,378.62 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 8.99 57,387.61 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 47.32 57,434.93 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 24.37 57,459.30 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 31.13 57,490.43 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 59.25 57,549.68 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 95.62 57,645.30 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 151.48 57,796.78 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 3.90 57,800.68 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 1,773.45 59,574.13 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 432.85 60,006.98 BANK OF AMERICA 31212 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 128.98 60,135.96 BANK OF AMERICA 31212 AP _______________ Account: 135-65055-033-000 Hardware Totals: 2,455.39 60,135.96 ** 83,238.00 Budgeted 23,102.04 Remaining 72 % Used Account: 135-65085-033-000 Office Supplies 107.12 .00 107.12 _______________ Account: 135-65085-033-000 Office Supplies Totals: .00 107.12 ** 371.00 Budgeted 263.88 Remaining 29 % Used Account: 135-65090-033-000 Printer Supplies & Maintenance 339 01/19/2012 January A/P Printer drum 1,662.38 145.50 1,807.88 SHI GOVERNMENT SOLUTIONS,INC 31191 AP 348 01/24/2012 Jan A/P Printer drum kits 296.00 2,103.88 SHI GOVERNMENT SOLUTIONS,INC 31191 AP 348 01/24/2012 Jan A/P Printer toner 69.00 2,172.88 SHI GOVERNMENT SOLUTIONS,INC 31191 AP 411 01/31/2012 A/P Invoices Printer supplies/Toner cartrid 376.00 2,548.88 SHI GOVERNMENT SOLUTIONS,INC 31205 AP 411 01/31/2012 A/P Invoices Printer Supplies/Print cartrid 64.00 2,612.88 SHI GOVERNMENT SOLUTIONS,INC 31205 AP 411 01/31/2012 A/P Invoices Printer Supplies/drum, toner 144.00 2,756.88 SHI GOVERNMENT SOLUTIONS,INC 31205 AP _______________ Account: 135-65090-033-000 Printer Supplies & Maintenance Totals: 1,094.50 2,756.88 ** 5,732.00 Budgeted 2,975.12 Remaining 48 % Used Account: 135-69170-033-000 Copier Lease Installments 339 01/19/2012 January A/P Copier Lease 513.70 256.85 770.55 KYOCERA MITA AMERICA, INC. 31182 AP _______________ Account: 135-69170-033-000 Copier Lease Installments Totals: 256.85 770.55 ** 3,450.00 Budgeted 2,679.45 Remaining 22 % Used . glpdatb2 rgonzale Trophy Club Entities Page 66 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69195-033-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-033-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 26,911.00 Budgeted 26,911.00 Remaining 0 % Used Department 33 Totals: ------------------------------------------------------------------------------------------------ 91,951.18 ** 193,391.00 Budgeted 101,439.82 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club Entities Page 67 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-037-000 Workman's Compensation 861.00 .00 861.00 _______________ Account: 135-50045-037-000 Workman's Compensation Totals: .00 861.00 ** .00 Budgeted (861.00) Remaining 0 % Used Account: 135-55100-037-000 Building Maint & Supplies 491.68 .00 491.68 _______________ Account: 135-55100-037-000 Building Maint & Supplies Totals: .00 491.68 ** 29,577.00 Budgeted 29,085.32 Remaining 2 % Used Account: 135-55120-037-000 Cleaning Services 411 01/31/2012 A/P Invoices January Cleaning Services 3,906.58 1,678.51 5,585.09 ABM JANITORIAL SERVICES, INC 31197 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 255.52 5,840.61 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-55120-037-000 Cleaning Services Totals: 1,934.03 5,840.61 ** 25,000.00 Budgeted 19,159.39 Remaining 23 % Used Account: 135-60020-037-000 Electricity 2,693.25 .00 2,693.25 _______________ Account: 135-60020-037-000 Electricity Totals: .00 2,693.25 ** 21,940.00 Budgeted 19,246.75 Remaining 12 % Used Account: 135-60025-037-000 Water 435 01/31/2012 A/P Invoices Jan Water 166.86 36.86 203.72 TROPHY CLUB MUD (WATER BILLS) 31250 AP _______________ Account: 135-60025-037-000 Water Totals: 36.86 203.72 ** 1,093.00 Budgeted 889.28 Remaining 19 % Used Account: 135-60030-037-000 Rent And/Or Usage 240 01/03/2012 Jan A/P Jan Public Services Bldg rent 3,295.53 1,098.51 4,394.04 TOWN OF TROPHY CLUB 31153 AP _______________ Account: 135-60030-037-000 Rent And/Or Usage Totals: 1,098.51 4,394.04 ** 13,182.00 Budgeted 8,787.96 Remaining 33 % Used Account: 135-60055-037-000 Insurance . glpdatb2 rgonzale Trophy Club Entities Page 68 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 28,589.50 .00 28,589.50 _______________ Account: 135-60055-037-000 Insurance Totals: .00 28,589.50 ** 32,635.00 Budgeted 4,045.50 Remaining 88 % Used Account: 135-60360-037-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-037-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65095-037-000 Maintenance Supplies 435 01/31/2012 A/P Invoices Jan purchases 247.10 42.05 289.15 COSTCO WHOLESALE 31215 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 93.10 382.25 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 33.12 415.37 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 106.14 521.51 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 2.49 524.00 JPMORGAN CHASE BANK NA 31255 AP 476 01/31/2012 Jan A/P Jan PCard Purchases 44.29 568.29 JPMORGAN CHASE BANK NA 31255 AP _______________ Account: 135-65095-037-000 Maintenance Supplies Totals: 321.19 568.29 ** 2,205.00 Budgeted 1,636.71 Remaining 26 % Used Account: 135-65097-037-000 Vending Machine Supplies 435 01/31/2012 A/P Invoices Jan purchases 66.34 9.69 76.03 COSTCO WHOLESALE 31215 AP _______________ Account: 135-65097-037-000 Vending Machine Supplies Totals: 9.69 76.03 ** 1,000.00 Budgeted 923.97 Remaining 8 % Used Department 37 Totals: ------------------------------------------------------------------------------------------------ 43,718.12 ** 129,132.00 Budgeted 85,413.88 Remaining 34 % Used . glpdatb2 rgonzale Trophy Club Entities Page 69 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 1/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 237 01/06/2012 PAYROLL 1/6/2012 Salaries & Wages 18,088.50 3,291.00 21,379.50 PR 332 01/20/2012 PAYROLL 1/20/12 Salaries & Wages 3,261.78 24,641.28 PR _______________ Account: 135-50005-038-000 Salaries & Wages Totals: 6,552.78 24,641.28 ** 84,946.00 Budgeted 60,304.72 Remaining 29 % Used Account: 135-50010-038-000 Overtime 237 01/06/2012 PAYROLL 1/6/2012 Overtime 103.45 68.40 171.85 PR 332 01/20/2012 PAYROLL 1/20/12 Overtime 13.20 185.05 PR _______________ Account: 135-50010-038-000 Overtime Totals: 81.60 185.05 ** 2,000.00 Budgeted 1,814.95 Remaining 9 % 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 237 01/06/2012 PAYROLL 1/6/2012 Retirement 2,840.33 464.27 3,304.60 PR 332 01/20/2012 PAYROLL 1/20/12 Retirement 452.59 3,757.19 PR _______________ Account: 135-50020-038-000 Retirement Totals: 916.86 3,757.19 ** 12,203.00 Budgeted 8,445.81 Remaining 31 % Used Account: 135-50026-038-000 Medical Insurance 237 01/06/2012 PAYROLL 1/6/2012 Medical Insurance 2,773.07 462.18 3,235.25 PR 332 01/20/2012 PAYROLL 1/20/12 Medical Insurance 461.81 3,697.06 PR _______________ Account: 135-50026-038-000 Medical Insurance Totals: 923.99 3,697.06 ** 12,321.00 Budgeted 8,623.94 Remaining 30 % Used Account: 135-50027-038-000 Dental Insurance 237 01/06/2012 PAYROLL 1/6/2012 Dental Insurance 274.97 45.83 320.80 PR 332 01/20/2012 PAYROLL 1/20/12 Dental Insurance 45.79 366.59 PR . glpdatb2 rgonzale Trophy Club Entities Page 70 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 1/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.62 366.59 ** 1,026.00 Budgeted 659.41 Remaining 36 % Used Account: 135-50028-038-000 Vision Insurance 237 01/06/2012 PAYROLL 1/6/2012 Vision Insurance 64.88 10.82 75.70 PR 332 01/20/2012 PAYROLL 1/20/12 Vision Insurance 10.80 86.50 PR _______________ Account: 135-50028-038-000 Vision Insurance Totals: 21.62 86.50 ** 260.00 Budgeted 173.50 Remaining 33 % 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 237 01/06/2012 PAYROLL 1/6/2012 Social Security Taxes 1,136.33 190.40 1,326.73 PR 332 01/20/2012 PAYROLL 1/20/12 Social Security Taxes 185.19 1,511.92 PR _______________ Account: 135-50030-038-000 Social Security Taxes Totals: 375.59 1,511.92 ** 5,404.00 Budgeted 3,892.08 Remaining 28 % Used Account: 135-50035-038-000 Medicare Taxes 237 01/06/2012 PAYROLL 1/6/2012 Medicare Taxes 265.74 44.53 310.27 PR 332 01/20/2012 PAYROLL 1/20/12 Medicare Taxes 43.32 353.59 PR _______________ Account: 135-50035-038-000 Medicare Taxes Totals: 87.85 353.59 ** 1,264.00 Budgeted 910.41 Remaining 28 % Used Account: 135-50040-038-000 Unemployment Taxes 237 01/06/2012 PAYROLL 1/6/2012 Unemployment Taxes 10.02 26.87 36.89 PR 332 01/20/2012 PAYROLL 1/20/12 Unemployment Taxes 26.21 63.10 PR _______________ Account: 135-50040-038-000 Unemployment Taxes Totals: 53.08 63.10 ** 473.00 Budgeted 409.90 Remaining 13 % Used . glpdatb2 rgonzale Trophy Club Entities Page 71 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-038-000 Workman's Compensation 235.00 .00 235.00 _______________ Account: 135-50045-038-000 Workman's Compensation Totals: .00 235.00 ** 211.00 Budgeted (24.00) Remaining 111 % Used Account: 135-55070-038-000 Independent Labor .00 .00 _______________ Account: 135-55070-038-000 Independent Labor Totals: .00 .00 ** 800.00 Budgeted 800.00 Remaining 0 % Used Account: 135-55205-038-000 Utility Billing Contract 437 01/31/2012 Jan A/P Invoices January Utility Billing 3,030.43 936.88 3,967.31 CSG SYSTEMS, INC. 31216 AP _______________ Account: 135-55205-038-000 Utility Billing Contract Totals: 936.88 3,967.31 ** 11,000.00 Budgeted 7,032.69 Remaining 36 % Used Account: 135-60005-038-000 Telephone 318 01/09/2012 Void A/P Check 31162/BOA Dec P Card purchases 31.21 (3.20) 28.01 BANK OF AMERICA 31162 AP 435 01/31/2012 A/P Invoices 12/28-1/27 PCard Purchases 3.20 31.21 BANK OF AMERICA 31212 AP _______________ Account: 135-60005-038-000 Telephone Totals: .00 31.21 ** 100.00 Budgeted 68.79 Remaining 31 % Used Account: 135-60010-038-000 Communications/Pagers/Mobiles 435 01/31/2012 A/P Invoices Jan Cell phones 105.16 36.88 142.04 VERIZON WIRELESS 31251 AP _______________ Account: 135-60010-038-000 Communications/Pagers/Mobiles Totals: 36.88 142.04 ** 472.00 Budgeted 329.96 Remaining 30 % Used Account: 135-60035-038-000 Postage 437 01/31/2012 Jan A/P Invoices January Utility Billing 4,204.48 1,427.43 5,631.91 CSG SYSTEMS, INC. 31216 AP _______________ Account: 135-60035-038-000 Postage Totals: 1,427.43 5,631.91 ** 18,000.00 Budgeted 12,368.09 Remaining 31 % Used Account: 135-60040-038-000 Service Charges & Fees . glpdatb2 rgonzale Trophy Club Entities Page 72 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 445 01/31/2012 CC fees/Jan 8,960.88 9.37 8,970.25 GL 445 01/31/2012 CC fees/Jan 40.51 9,010.76 GL 445 01/31/2012 CC fees/Jan 35.00 9,045.76 GL 445 01/31/2012 CC fees/Jan 9.99 9,055.75 GL 445 01/31/2012 CC fees/Jan 2,096.21 11,151.96 GL _______________ Account: 135-60040-038-000 Service Charges & Fees Totals: 2,191.08 11,151.96 ** 18,000.00 Budgeted 6,848.04 Remaining 62 % Used Account: 135-60070-038-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-038-000 Dues & Memberships Totals: .00 .00 ** 71.00 Budgeted 71.00 Remaining 0 % Used Account: 135-60080-038-000 Schools & Training .00 .00 _______________ Account: 135-60080-038-000 Schools & Training Totals: .00 .00 ** 800.00 Budgeted 800.00 Remaining 0 % Used Account: 135-60100-038-000 Travel & per diem .00 .00 _______________ Account: 135-60100-038-000 Travel & per diem Totals: .00 .00 ** 605.00 Budgeted 605.00 Remaining 0 % Used Account: 135-60130-038-000 Reg Assessment Fee (5%) 25,071.20 .00 25,071.20 _______________ Account: 135-60130-038-000 Reg Assessment Fee (5%) Totals: .00 25,071.20 ** 22,500.00 Budgeted (2,571.20) Remaining 111 % Used Account: 135-60245-038-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-038-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 73 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65085-038-000 Office Supplies 339 01/19/2012 January A/P Office Supplies 75.92 6.64 82.56 OFFICE DEPOT, INC 31187 AP 411 01/31/2012 A/P Invoices Office Supplies 13.22 95.78 OFFICE DEPOT, INC 31203 AP 435 01/31/2012 A/P Invoices Office Supplies 49.28 145.06 OFFICE DEPOT, INC 31228 AP _______________ Account: 135-65085-038-000 Office Supplies Totals: 69.14 145.06 ** 700.00 Budgeted 554.94 Remaining 21 % 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: ------------------------------------------------------------------------------------------------ 81,257.97 ** 197,430.00 Budgeted 116,172.03 Remaining 41 % Used . glpdatb2 rgonzale Trophy Club Entities Page 74 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/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 339 01/19/2012 January A/P Bond Counsel/Revenue Note 2012 17,764.74 7,153.65 24,918.39 MCCALL, PARKHURST & HORTON LLP 31183 AP 411 01/31/2012 A/P Invoices January 2012 Legal 765.50 25,683.89 THE LISTON LAW FIRM, P.C. 31206 AP 411 01/31/2012 A/P Invoices February 2011 Legal 865.50 26,549.39 THE LISTON LAW FIRM, P.C. 31206 AP 411 01/31/2012 A/P Invoices June 2011 Legal 1,935.00 28,484.39 THE LISTON LAW FIRM, P.C. 31206 AP 411 01/31/2012 A/P Invoices October 2011 Legal 797.50 29,281.89 THE LISTON LAW FIRM, P.C. 31206 AP 411 01/31/2012 A/P Invoices Legal Nov 2010 1,907.25 31,189.14 THE LISTON LAW FIRM, P.C. 31206 AP 435 01/31/2012 A/P Invoices AWBD Conf/Liston 315.00 31,504.14 AWBD 31210 AP 476 01/31/2012 Jan A/P January Legal 1,682.75 33,186.89 WHITAKER CHALK SWINDLE 31263 AP _______________ Account: 135-55045-039-000 Legal Totals: 15,422.15 33,186.89 ** 55,000.00 Budgeted 21,813.11 Remaining 60 % Used Account: 135-55055-039-000 Auditing 435 01/31/2012 A/P Invoices Final payment/Audit 15,150.00 5,050.00 20,200.00 LAFOLLETT & COMPANY PLLC 31221 AP _______________ Account: 135-55055-039-000 Auditing Totals: 5,050.00 20,200.00 ** 20,200.00 Budgeted .00 Remaining 100 % Used Account: 135-55060-039-000 Appraisal 8,533.65 .00 8,533.65 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 8,533.65 ** 20,000.00 Budgeted 11,466.35 Remaining 43 % Used Account: 135-55065-039-000 Tax Admin Fees 2,451.63 .00 2,451.63 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,451.63 ** 3,629.00 Budgeted 1,177.37 Remaining 68 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 2,277.85 .00 2,277.85 _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: .00 2,277.85 ** .00 Budgeted (2,277.85) Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 66,650.02 ** 98,829.00 Budgeted 32,178.98 Remaining 67 % Used . glpdatb2 rgonzale Trophy Club Entities Page 75 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (544,916.67) .00 Budgeted 544,916.67 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 76 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 522 2010 GO/Fire Station Department: Revenues Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 522-49025-000-000 Auction Sales (22,570.00) .00 (22,570.00) _______________ Account: 522-49025-000-000 Auction Sales Totals: .00 (22,570.00) ** .00 Budgeted 22,570.00 Remaining 0 % Used Account: 522-49145-000-000 Intergov Transfer-General Fund (2,277.85) .00 (2,277.85) _______________ Account: 522-49145-000-000 Intergov Transfer-General Fund Totals: .00 (2,277.85) ** .00 Budgeted 2,277.85 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (24,847.85) ** .00 Budgeted 24,847.85 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 77 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 522 2010 GO/Fire Station Department: 65 Construction Program: Period Ending: 1/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 522-60031-065-000 Temporary Housing & Storage 41.58 .00 41.58 _______________ Account: 522-60031-065-000 Temporary Housing & Storage Totals: .00 41.58 ** .00 Budgeted (41.58) Remaining 0 % Used Department 65 Totals: ------------------------------------------------------------------------------------------------ 41.58 ** .00 Budgeted (41.58) Remaining 0 % Used Fund 522 Totals: ------------------------------------------------------------------------------------------------------ (24,806.27) .00 Budgeted 24,806.27 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 78 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 1/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 362 01/03/2012 Property Taxes (205,968.04) (5,668.06) (211,636.10) GL 363 01/04/2012 Property Taxes (58,864.20) (270,500.30) GL 364 01/05/2012 Property Taxes (14,553.96) (285,054.26) GL 366 01/06/2012 Property Taxes (5,434.85) (290,489.11) GL 367 01/09/2012 Property Taxes (5,164.44) (295,653.55) GL 368 01/10/2012 Property Taxes (84,384.48) (380,038.03) GL 369 01/11/2012 Property Taxes (15,805.11) (395,843.14) GL 370 01/12/2012 Property Taxes (2,537.70) (398,380.84) GL 371 01/13/2012 Property Taxes (3,198.49) (401,579.33) GL 372 01/17/2012 Property Taxes (5,533.59) (407,112.92) GL 373 01/18/2012 Property Taxes (4,462.07) (411,574.99) GL 374 01/19/2012 Property Taxes (7,966.60) (419,541.59) GL 375 01/20/2012 Property Taxes (1,795.69) (421,337.28) GL 376 01/23/2012 Property Taxes (3,984.68) (425,321.96) GL 377 01/24/2012 Property Taxes (10,263.18) (435,585.14) GL 378 01/25/2012 Property Taxes (21,350.68) (456,935.82) GL 379 01/26/2012 Property Taxes (2,448.68) (459,384.50) GL 421 01/27/2012 Property Taxes (7,142.77) (466,527.27) GL 422 01/30/2012 Property Taxes (3,827.38) (470,354.65) GL 423 01/31/2012 Property Taxes (10,496.11) (480,850.76) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (274,882.72) (480,850.76) ** (546,716.00) Budgeted (65,865.24) Remaining 88 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 365 01/05/2012 Property Taxes 3,894.05 (506.10) 3,387.95 GL 370 01/12/2012 Property Taxes (8.34) 3,379.61 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (514.44) 3,379.61 ** (3,947.00) Budgeted (7,326.61) Remaining -86 % Used Account: 533-40015-000-000 Property Taxes/P & I 365 01/05/2012 Property Taxes (227.34) (359.34) (586.68) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (359.34) (586.68) ** (5,017.00) Budgeted (4,430.32) Remaining 12 % Used Account: 533-48005-000-000 Utility Fees (6,120.00) .00 (6,120.00) . glpdatb2 rgonzale Trophy Club Entities Page 79 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 1/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-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 443 01/31/2012 Texpool Interest (30.06) (34.73) (64.79) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (34.73) (64.79) ** (500.00) Budgeted (435.21) Remaining 13 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (308,000.00) Budgeted (308,000.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (484,242.62) ** (870,300.00) Budgeted (386,057.38) Remaining 56 % Used . glpdatb2 rgonzale Trophy Club Entities Page 80 16:36 02/16/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 1/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 .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 .00 ** 301,300.00 Budgeted 301,300.00 Remaining 0 % 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: ------------------------------------------------------------------------------------------------ .00 ** 870,300.00 Budgeted 870,300.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (484,242.62) .00 Budgeted 484,242.62 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (1,919,311.61) **** .00 Budgeted 1,919,311.61 Remaining 0 % Used ******* End of Report *********