Loading...
HomeMy WebLinkAboutNovember 2012 MUD Financials Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 11/30/2012 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 398,398 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 992,814 ACCOUNTS RECEIVABLE - PID EMER SERVICES 233,352 OTHER RECEIVABLES 26,733 TOTAL ASSETS 1,651,297$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 1,226,166$ ACCOUNTS PAYABLE 89,234 TOTAL LIABILITIES 1,315,400$ FUND BALANCE UNASSIGNED FUND BALANCE 335,897 TOTAL LIABILITIES AND FUND BALANCE 1,651,297$ November 30, 2012 2/12 Months (16.66% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 13:23 12/13/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 252,084.00- 252,084.00- 13,397.74- 17,068.80- 6.771 235,015.20- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700.00- 4,700.00- 5.36- .114 4,694.64- 122-40010-000-000 Property Taxes/MUD Fire 1,050,349.00- 1,050,349.00- 56,225.03- 82,647.97- 7.869 967,701.03- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 1,233.21- 3,595.86- 61.998 2,204.14- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 1.08- .144 748.92- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 849.27- 1,442.70- 32.060 3,057.30- Subtotal: 1,318,183.00- 1,318,183.00- 71,705.25- 104,761.77- 7.947 1,213,421.23- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 400.00- 6.667 5,600.00- Subtotal: 6,000.00- 6,000.00- 400.00- 400.00- 6.667 5,600.00- 122-43400-000-000 Fire Inspections 500.00- 500.00- 75.00- 75.00- 15.000 425.00- 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,500.00- 10,500.00- 75.00- 75.00- .714 10,425.00- 122-49900-000-000 Miscellaneous Income 1,200.00- 1,200.00- 525.00- 525.00- 43.750 675.00- Subtotal: 1,200.00- 1,200.00- 525.00- 525.00- 43.750 675.00- Program number: 1,335,883.00- 1,335,883.00- 72,705.25- 105,761.77- 7.917 1,230,121.23- Department number: Fire Revenues 1,335,883.00- 1,335,883.00- 72,705.25- 105,761.77- 7.917 1,230,121.23- Revenues Subtotal ----------- 1,335,883.00- 1,335,883.00- 72,705.25- 105,761.77- 7.917 1,230,121.23- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 13:23 12/13/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 444,717.00 444,717.00 38,431.76 61,301.16 13.784 383,415.84 122-50010-045-000 Overtime 31,375.00 31,375.00 5,357.95 7,910.29 25.212 23,464.71 122-50011-045-000 DPS Holiday Pay 13,083.00 13,083.00 13,083.00 122-50016-045-000 Longevity 4,266.00 4,266.00 4,266.00 122-50017-045-000 Certification 4,896.00 4,896.00 575.00 1,150.00 23.489 3,746.00 122-50020-045-000 Retirement 69,242.00 69,242.00 6,342.82 11,029.99 15.930 58,212.01 122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,336.41 6,672.92 13.808 41,654.08 122-50027-045-000 Dental Insurance 3,635.00 3,635.00 311.96 623.89 17.163 3,011.11 122-50028-045-000 Vision Insurance 824.00 824.00 64.11 128.22 15.561 695.78 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 585.14 585.14 13.768 3,664.86 122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 2,716.37 4,710.31 15.245 26,186.69 122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 635.24 1,101.60 15.245 6,124.40 122-50040-045-000 Unemployment Taxes 1,481.00 1,481.00 15.64 38.42 2.594 1,442.58 122-50045-045-000 Workman's Compensation 10,000.00 10,000.00 10,000.00 100.000 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 675.00 122-50075-045-000 Tuition Reimbursement 1,500.00 1,500.00 1,500.00 Subtotal: 676,394.00 676,394.00 58,372.40 105,251.94 15.561 571,142.06 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 162.26 454.26 4.751 9,107.74 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 723.42- 450.85- -3.036 15,300.85 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 9,808.00 122-55100-045-000 Building Maintenance 6,500.00 6,500.00 117.42 360.93 5.553 6,139.07 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 1,103.00 122-55160-045-000 Professional Outside Services 2,500.00 2,500.00 2,500.00 Subtotal: 44,323.00 44,323.00 443.74- 364.34 .822 43,958.66 122-60005-045-000 Telephone 106.00 106.00 13.01 12.274 92.99 122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 2,500.00 216.88 1,607.88 64.315 892.12 122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 475.97 858.61 13.923 5,308.39 122-60025-045-000 Water 1,400.00 1,400.00 294.78 294.78 21.056 1,105.22 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 122-60035-045-000 Postage 100.00 100.00 27.25 27.25 27.250 72.75 122-60055-045-000 Insurance 10,000.00 10,000.00 50.00 .500 9,950.00 122-60066-045-000 Publications/Books/Subscrips 410.00 410.00 410.00 122-60070-045-000 Dues & Memberships 7,500.00 7,500.00 185.00 7,005.91 93.412 494.09 122-60075-045-000 Meetings 75.00 75.00 75.00 122-60080-045-000 Schools & Training 5,000.00 5,000.00 530.00 530.00 10.600 4,470.00 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 4,800.00 4,800.00 574.59 574.59 11.971 4,225.41 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 150.00 150.00 122.35 81.567 27.65 122-60160-045-000 Programs & Special Projects 4,200.00 4,200.00 1,928.94 2,198.94 52.356 2,001.06 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 13:23 12/13/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 153.73 153.73 8.091 1,746.27 122-60195-045-000 Flags & Repair 2,543.00 2,543.00 149.75 5.889 2,393.25 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 43.20 3.492 1,193.80 Subtotal: 359,088.00 359,088.00 5,387.14 14,630.00 4.074 344,458.00 122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 1,882.02 1,882.02 18.820 8,117.98 122-65010-045-000 Uniforms 4,357.00 4,357.00 283.25 283.25 6.501 4,073.75 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 7,600.00 122-65030-045-000 Chemicals 1,000.00 1,000.00 1,000.00 122-65035-045-000 Small Tools 5,000.00 5,000.00 5,000.00 122-65085-045-000 Office Supplies 1,200.00 1,200.00 15.15 20.71 1.726 1,179.29 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 206.62 206.62 7.419 2,578.38 122-65105-045-000 Printing 106.00 106.00 106.00 Subtotal: 32,048.00 32,048.00 2,387.04 2,392.60 7.466 29,655.40 122-69006-045-000 Grant Match 3,000.00 3,000.00 3,000.00 122-69008-045-000 Short Term Debt Payments 72,932.00 72,932.00 72,932.00 122-69050-045-000 Radios 2,500.00 2,500.00 2,500.00 122-69195-045-000 GASB34/Reserve for Replacement 145,598.00 145,598.00 145,598.00 Subtotal: 224,030.00 224,030.00 224,030.00 Program number: 1,335,883.00 1,335,883.00 65,702.84 122,638.88 9.180 1,213,244.12 Department number: Fire 1,335,883.00 1,335,883.00 65,702.84 122,638.88 9.180 1,213,244.12 Expenditures Subtotal ----------- 1,335,883.00 1,335,883.00 65,702.84 122,638.88 9.180 1,213,244.12 Fund number: 122 Trophy Club MUD Fire Dept. 7,002.41- 16,877.11 16,877.11- . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/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 435 11/01/2012 Property Taxes/Assessments (3,671.06) (1,732.43) (5,403.49) GL 397 11/02/2012 Property Taxes/Assessments (437.30) (5,840.79) GL 399 11/05/2012 Property Taxes/Assessments (488.55) (6,329.34) GL 434 11/06/2012 Property Taxes/Assessments (749.85) (7,079.19) GL 402 11/08/2012 Property Taxes/Assessments (23.22) (7,102.41) GL 404 11/09/2012 Property Taxes/Assessments (1,765.22) (8,867.63) GL 407 11/13/2012 Property Taxes/Assessments (122.10) (8,989.73) GL 410 11/14/2012 Property Taxes/Assessments (1,000.78) (9,990.51) GL 412 11/15/2012 Property Taxes/Assessments (540.90) (10,531.41) GL 414 11/16/2012 Property Taxes/Assessments (435.66) (10,967.07) GL 416 11/19/2012 Property Taxes/Assessments (439.16) (11,406.23) GL 418 11/20/2012 Property Taxes/Assessments (389.31) (11,795.54) GL 420 11/21/2012 Property Taxes/Assessments (618.14) (12,413.68) GL 429 11/26/2012 Property Taxes/Assessments (2,076.08) (14,489.76) GL 430 11/27/2012 Property Taxes/Assessments (23.32) (14,513.08) GL 431 11/28/2012 Property Taxes/Assessments (514.28) (15,027.36) GL 432 11/29/2012 Property Taxes/Assessments (1,315.49) (16,342.85) GL 433 11/30/2012 Property Taxes/Assessments (725.95) (17,068.80) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (13,397.74) (17,068.80) ** (252,084.00) Budgeted (235,015.20) Remaining 7 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (5.36) .00 (5.36) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (5.36) ** (4,700.00) Budgeted (4,694.64) Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 435 11/01/2012 Property Taxes/Assessments (26,422.94) (2,097.45) (28,520.39) GL 396 11/02/2012 Property Taxes/Assessments (1,391.67) (29,912.06) GL 398 11/05/2012 Property Taxes/Assessments (1,388.30) (31,300.36) GL 434 11/06/2012 Property Taxes/Assessments (1,197.84) (32,498.20) GL 400 11/07/2012 Property Taxes/Assessments (22,390.29) (54,888.49) GL 401 11/08/2012 Property Taxes/Assessments (282.35) (55,170.84) GL 403 11/09/2012 Property Taxes/Assessments (660.89) (55,831.73) GL 405 11/13/2012 Property Taxes/Assessments (1,911.11) (57,742.84) GL 409 11/14/2012 Property Taxes/Assessments (2,469.00) (60,211.84) GL 411 11/15/2012 Property Taxes/Assessments (3,424.24) (63,636.08) GL 413 11/16/2012 Property Taxes/Assessments (1,235.78) (64,871.86) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 415 11/19/2012 Property Taxes/Assessments (26,422.94) (3,033.48) (67,905.34) GL 417 11/20/2012 Property Taxes/Assessments (1,014.76) (68,920.10) GL 419 11/21/2012 Property Taxes/Assessments (2,737.91) (71,658.01) GL 428 11/26/2012 Property Taxes/Assessments (4,276.10) (75,934.11) GL 430 11/27/2012 Property Taxes/Assessments (2,569.98) (78,504.09) GL 431 11/28/2012 Property Taxes/Assessments (1,373.54) (79,877.63) GL 432 11/29/2012 Property Taxes/Assessments (926.36) (80,803.99) GL 433 11/30/2012 Property Taxes/Assessments (1,843.98) (82,647.97) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (56,225.03) (82,647.97) ** (1,050,349.00) Budgeted (967,701.03) Remaining 8 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 400 11/07/2012 Property Taxes/Assessments (2,362.65) 2,594.92 232.27 GL 417 11/20/2012 Property Taxes/Assessments (3,692.49) (3,460.22) GL 431 11/28/2012 Property Taxes/Assessments (135.64) (3,595.86) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (1,233.21) (3,595.86) ** (5,800.00) Budgeted (2,204.14) Remaining 62 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I (1.08) .00 (1.08) _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 (1.08) ** (750.00) Budgeted (748.92) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 417 11/20/2012 Property Taxes/Assessments (593.43) (849.27) (1,442.70) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (849.27) (1,442.70) ** (4,500.00) Budgeted (3,057.30) Remaining 32 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 460 11/01/2012 Recode JE408/Fire Permits (400.00) (400.00) GL _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (400.00) ** (6,000.00) Budgeted (5,600.00) Remaining 7 % Used Account: 122-43400-000-000 Fire Inspections . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 460 11/01/2012 Recode JE408/Fire Permits (75.00) (75.00) GL _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (75.00) ** (500.00) Budgeted (425.00) Remaining 15 % Used Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire .00 .00 _______________ Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 408 11/01/2012 10/25 Permits-FD (1,000.00) (1,000.00) GL 460 11/01/2012 Recode JE408/Fire Permits 475.00 (525.00) GL _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (525.00) (525.00) ** (1,200.00) Budgeted (675.00) Remaining 44 % Used Department Totals: ------------------------------------------------------------------------------------------------ (105,761.77) ** (1,335,883.00) Budgeted (1,230,121.23) Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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 442 11/07/2012 Payroll 11/7/12 22,869.40 15,354.39 38,223.79 GL 443 11/21/2012 Payroll 11/21/12 16,677.37 54,901.16 GL 446 11/21/2012 Fire Stipend 11/21/12 6,400.00 61,301.16 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 38,431.76 61,301.16 ** 444,717.00 Budgeted 383,415.84 Remaining 14 % Used Account: 122-50010-045-000 Overtime 443 11/21/2012 Payroll 11/21/12 2,552.34 5,357.95 7,910.29 GL _______________ Account: 122-50010-045-000 Overtime Totals: 5,357.95 7,910.29 ** 31,375.00 Budgeted 23,464.71 Remaining 25 % Used Account: 122-50011-045-000 DPS Holiday Pay .00 .00 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 .00 ** 13,083.00 Budgeted 13,083.00 Remaining 0 % Used Account: 122-50016-045-000 Longevity .00 .00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 .00 ** 4,266.00 Budgeted 4,266.00 Remaining 0 % Used Account: 122-50017-045-000 Certification 442 11/07/2012 Payroll 11/7/12 575.00 575.00 1,150.00 GL _______________ Account: 122-50017-045-000 Certification Totals: 575.00 1,150.00 ** 4,896.00 Budgeted 3,746.00 Remaining 23 % Used Account: 122-50020-045-000 Retirement 442 11/07/2012 Payroll 11/7/12 4,687.17 2,178.82 6,865.99 GL 443 11/21/2012 Payroll 11/21/12 2,930.60 9,796.59 GL 446 11/21/2012 Fire Stipend 11/21/12 1,233.40 11,029.99 GL _______________ Account: 122-50020-045-000 Retirement Totals: 6,342.82 11,029.99 ** 69,242.00 Budgeted 58,212.01 Remaining 16 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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 442 11/07/2012 Payroll 11/7/12 3,336.51 1,668.22 5,004.73 GL 443 11/21/2012 Payroll 11/21/12 1,668.19 6,672.92 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,336.41 6,672.92 ** 48,327.00 Budgeted 41,654.08 Remaining 14 % Used Account: 122-50027-045-000 Dental Insurance 442 11/07/2012 Payroll 11/7/12 311.93 155.96 467.89 GL 443 11/21/2012 Payroll 11/21/12 156.00 623.89 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 311.96 623.89 ** 3,635.00 Budgeted 3,011.11 Remaining 17 % Used Account: 122-50028-045-000 Vision Insurance 442 11/07/2012 Payroll 11/7/12 64.11 32.06 96.17 GL 443 11/21/2012 Payroll 11/21/12 32.05 128.22 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 64.11 128.22 ** 824.00 Budgeted 695.78 Remaining 16 % Used Account: 122-50029-045-000 Life Insurance & Other 442 11/07/2012 Payroll 11/7/12 292.56 292.56 GL 443 11/21/2012 Payroll 11/21/12 292.58 585.14 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 585.14 585.14 ** 4,250.00 Budgeted 3,664.86 Remaining 14 % Used Account: 122-50030-045-000 Social Security Taxes 442 11/07/2012 Payroll 11/7/12 1,993.94 892.23 2,886.17 GL 443 11/21/2012 Payroll 11/21/12 1,270.79 4,156.96 GL 446 11/21/2012 Fire Stipend 11/21/12 553.35 4,710.31 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,716.37 4,710.31 ** 30,897.00 Budgeted 26,186.69 Remaining 15 % Used Account: 122-50035-045-000 Medicare Taxes 442 11/07/2012 Payroll 11/7/12 466.36 208.66 675.02 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 443 11/21/2012 Payroll 11/21/12 466.36 297.21 972.23 GL 446 11/21/2012 Fire Stipend 11/21/12 129.37 1,101.60 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 635.24 1,101.60 ** 7,226.00 Budgeted 6,124.40 Remaining 15 % Used Account: 122-50040-045-000 Unemployment Taxes 442 11/07/2012 Payroll 11/7/12 22.78 2.11 24.89 GL 443 11/21/2012 Payroll 11/21/12 13.53 38.42 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 15.64 38.42 ** 1,481.00 Budgeted 1,442.58 Remaining 3 % Used Account: 122-50045-045-000 Workman's Compensation 10,000.00 .00 10,000.00 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test .00 .00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 .00 ** 675.00 Budgeted 675.00 Remaining 0 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 259 11/18/2012 Nov A/P Rug Service 292.00 23.18 315.18 G & K SERVICES 31916 AP 259 11/18/2012 Nov A/P Rug Service/Fire Station 23.18 338.36 G & K SERVICES 31916 AP 259 11/18/2012 Nov A/P Rug Service 23.18 361.54 G & K SERVICES 31916 AP 259 11/18/2012 Nov A/P Rug Service 23.18 384.72 G & K SERVICES 31916 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 46.36 431.08 JPMORGAN CHASE BANK NA 31966 AP 335 11/30/2012 Nov A/P Rug service 23.18 454.26 G & K SERVICES 31970 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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-55080-045-000 Maintenance & Repairs Totals: 162.26 454.26 ** 9,562.00 Budgeted 9,107.74 Remaining 5 % Used Account: 122-55090-045-000 Vehicle Maintenance 427 11/26/2012 Siddons/Refund overbilling 272.57 (750.59) (478.02) GL 387 11/30/2012 Nov A/P Q-681 filter oil spin 27.17 (450.85) INDUSTRIAL POWER TRUCK & EQUIP 31984 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: (723.42) (450.85) ** 14,850.00 Budgeted 15,300.85 Remaining -3 % Used Account: 122-55095-045-000 Equipment Maintenance .00 .00 _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: .00 .00 ** 9,808.00 Budgeted 9,808.00 Remaining 0 % Used Account: 122-55100-045-000 Building Maintenance 259 11/18/2012 Nov A/P Pest Control/Fire Station 243.51 140.00 383.51 GANN'S PEST CONTROL 31917 AP 424 11/18/2012 FD Nov Cable (120.00) 263.51 GL 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Thomas 97.42 360.93 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 122-55100-045-000 Building Maintenance Totals: 117.42 360.93 ** 6,500.00 Budgeted 6,139.07 Remaining 6 % 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 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 122-60005-045-000 Telephone . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 13.01 .00 13.01 _______________ Account: 122-60005-045-000 Telephone Totals: .00 13.01 ** 106.00 Budgeted 92.99 Remaining 12 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 442 11/07/2012 Payroll 11/7/12 1,391.00 76.50 1,467.50 GL 259 11/18/2012 Nov A/P Oct Cells 140.38 1,607.88 VERIZON WIRELESS 31940 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 216.88 1,607.88 ** 2,500.00 Budgeted 892.12 Remaining 64 % Used Account: 122-60020-045-000 Electricity/Gas 303 11/27/2012 Nov A/P Electricity/Fire Station 10/12 382.64 417.61 800.25 HUDSON ENERGY 31955 AP 303 11/27/2012 Nov A/P Fire Station Gas 10/17-11/12 58.36 858.61 ATMOS ENERGY 31947 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 475.97 858.61 ** 6,167.00 Budgeted 5,308.39 Remaining 14 % Used Account: 122-60025-045-000 Water 259 11/18/2012 Nov A/P Water/October 294.78 294.78 TROPHY CLUB MUD (WATER BILLS) 31936 AP _______________ Account: 122-60025-045-000 Water Totals: 294.78 294.78 ** 1,400.00 Budgeted 1,105.22 Remaining 21 % 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 289 11/30/2012 November postage used 27.25 27.25 GL _______________ Account: 122-60035-045-000 Postage Totals: 27.25 27.25 ** 100.00 Budgeted 72.75 Remaining 27 % Used Account: 122-60055-045-000 Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 50.00 .00 50.00 _______________ Account: 122-60055-045-000 Insurance Totals: .00 50.00 ** 10,000.00 Budgeted 9,950.00 Remaining 1 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 410.00 Budgeted 410.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 259 11/18/2012 Nov A/P New Cert/Garrett Basic Wildlan 6,820.91 85.00 6,905.91 TX COMM ON FIRE PROTECTION 31937 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Sipes 100.00 7,005.91 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 185.00 7,005.91 ** 7,500.00 Budgeted 494.09 Remaining 93 % Used Account: 122-60075-045-000 Meetings .00 .00 _______________ Account: 122-60075-045-000 Meetings Totals: .00 .00 ** 75.00 Budgeted 75.00 Remaining 0 % Used Account: 122-60080-045-000 Schools & Training 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Sipes 530.00 530.00 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 530.00 530.00 ** 5,000.00 Budgeted 4,470.00 Remaining 11 % Used Account: 122-60096-045-000 Emergency Management 303 11/27/2012 Nov A/P Emergency Management dues 2013 1,000.00 1,000.00 N CENTRAL TX COG 31958 AP _______________ Account: 122-60096-045-000 Emergency Management Totals: 1,000.00 1,000.00 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 309 11/27/2012 Nov A/P 10/6-11/5 PCards/Hurd 574.59 574.59 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 122-60100-045-000 Travel & per diem Totals: 574.59 574.59 ** 4,800.00 Budgeted 4,225.41 Remaining 12 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 122.35 .00 122.35 _______________ Account: 122-60125-045-000 Advertising Totals: .00 122.35 ** 150.00 Budgeted 27.65 Remaining 82 % Used Account: 122-60160-045-000 Programs & Special Projects 259 11/18/2012 Nov A/P Bounce house for fire open hou 270.00 147.75 417.75 LET'S JUMP 31922 AP 303 11/27/2012 Nov A/P kids hats, pens, pencils, badg 1,475.16 1,892.91 ARTCRAFT & FOREMOST INC 31945 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Sipes 10.60 1,903.51 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Sipes 22.32 1,925.83 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 137.89 2,063.72 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 6.86 2,070.58 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 42.19 2,112.77 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 27.27 2,140.04 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 12.50 2,152.54 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Sipes 78.75 2,231.29 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Sipes (32.35) 2,198.94 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 1,928.94 2,198.94 ** 4,200.00 Budgeted 2,001.06 Remaining 52 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 259 11/18/2012 Nov A/P Fire Marshal Badges 153.73 153.73 ENTENMANN-ROVIN CO 31913 AP _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 153.73 153.73 ** 1,900.00 Budgeted 1,746.27 Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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-60195-045-000 Flags & Repair 149.75 .00 149.75 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 149.75 ** 2,543.00 Budgeted 2,393.25 Remaining 6 % Used Account: 122-60245-045-000 Miscellaneous Expense 43.20 .00 43.20 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 43.20 ** 1,237.00 Budgeted 1,193.80 Remaining 3 % Used Account: 122-65005-045-000 Fuel & Lube 309 11/27/2012 Nov A/P 10/6-11/5 PCards/Hurd 78.06 78.06 JPMORGAN CHASE BANK NA 31966 AP 323 11/28/2012 October Gas Log 1,035.26 1,113.32 GL 393 11/30/2012 Nov Gas Purchases 768.70 1,882.02 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 1,882.02 1,882.02 ** 10,000.00 Budgeted 8,117.98 Remaining 19 % Used Account: 122-65010-045-000 Uniforms 259 11/18/2012 Nov A/P 2 Uniform Shirts/Chief 69.50 69.50 PANDA EMBROIDERY 31923 AP 259 11/18/2012 Nov A/P Cancer Tshirts 213.75 283.25 THE TSHIRTGUYS.COM 31931 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 283.25 283.25 ** 4,357.00 Budgeted 4,073.75 Remaining 7 % Used Account: 122-65015-045-000 Protective Clothing .00 .00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 .00 ** 7,600.00 Budgeted 7,600.00 Remaining 0 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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-65035-045-000 Small Tools .00 .00 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 122-65085-045-000 Office Supplies 387 11/30/2012 Nov A/P Office Supplies 5.56 15.15 20.71 OFFICE DEPOT, INC 31989 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 15.15 20.71 ** 1,200.00 Budgeted 1,179.29 Remaining 2 % Used Account: 122-65095-045-000 Maintenance Supplies 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 206.62 206.62 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 206.62 206.62 ** 2,785.00 Budgeted 2,578.38 Remaining 7 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 106.00 Budgeted 106.00 Remaining 0 % 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-69008-045-000 Short Term Debt Payments .00 .00 _______________ Account: 122-69008-045-000 Short Term Debt Payments Totals: .00 .00 ** 72,932.00 Budgeted 72,932.00 Remaining 0 % Used Account: 122-69050-045-000 Radios . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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-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 ** 145,598.00 Budgeted 145,598.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 122,638.88 ** 1,335,883.00 Budgeted 1,213,244.12 Remaining 9 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ 16,877.11 .00 Budgeted (16,877.11) Remaining 0 % Used Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 11/30/2012 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 198,292 INVESTMENTS 2,723,449 RESTRICTED ASSETS: INVESTMENTS 429,371 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 94,935 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,057,329 TOTAL ASSETS 4,503,776$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 94,935$ ACCOUNTS PAYABLE 655,613 CUSTOMER DEPOSITS 215,122 TOTAL LIABILITIES 965,670 FUND BALANCE NON-SPENDABLE FUND BALANCE 2,463 ASSIGNED/WATER REPLACEMENT 90,000 ASSIGNED/TECHNOLOGY REPLACEMENT 82,359 ASSIGNED/FIRE DEPT REPLACEMENT 41,890 ASSIGNED FUND BALANCE 555,072 UNASSIGNED FUND BALANCE 2,766,322 TOTAL FUND BALANCE 3,538,106 TOTAL LIABILITIES AND FUND BALANCE 4,503,776$ November 30, 2012 2/12 Months (16.66% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 13:23 12/13/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,884.00- 99,884.00- 5,346.78- 7,859.48- 7.869 92,024.52- 135-40002-000-000 Property Taxes/Delinquent 500.00- 500.00- 404.85- 659.53- 131.906 159.53 135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 372.06- 450.09- 37.508 749.91- Subtotal: 101,584.00- 101,584.00- 6,123.69- 8,969.10- 8.829 92,614.90- 135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 286,485.61- 553,069.96- 15.599 2,992,539.04- 135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 151,094.73- 282,782.39- 17.099 1,370,964.61- 135-47020-000-000 Standby 576.00- 576.00- 54.00- 101.90- 17.691 474.10- 135-47025-000-000 Penalties 64,580.00- 64,580.00- 6,168.97- 11,210.49- 17.359 53,369.51- 135-47030-000-000 Service Charges 11,625.00- 11,625.00- 878.00- 1,781.00- 15.320 9,844.00- 135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 1,800.00- 135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 300.00- 450.00- 8.654 4,750.00- 135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 4,882.15- 4,882.15- 6.293 72,692.85- Subtotal: 5,360,712.00- 5,360,712.00- 449,863.46- 854,277.89- 15.936 4,506,434.11- 135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 29,900.00- 71,300.00- 11.071 572,700.00- Subtotal: 644,000.00- 644,000.00- 29,900.00- 71,300.00- 11.071 572,700.00- 135-49010-000-000 Interest Income 5,500.00- 5,500.00- 519.43- 1,121.28- 20.387 4,378.72- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 1,757.53- 17.292 8,406.47- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,166.66- 16.667 5,833.34- 135-49030-000-000 Vending Revenue 350.00- 350.00- 18.76- 18.76- 5.360 331.24- 135-49035-000-000 Prior Year Reserves 305,748.00- 305,748.00- 305,748.00- 135-49075-000-000 Oversize Meter Reimbursement 73,000.00- 73,000.00- 4,672.00- 10,220.00- 14.000 62,780.00- 135-49900-000-000 Miscellaneous Income 1,000.00- 1,000.00- 1,149.99- 1,706.06- 170.606 706.06 135-49905-000-000 Gas Well Revenue 200.00- 200.00- 200.00- Subtotal: 402,962.00- 402,962.00- 7,854.04- 15,990.29- 3.968 386,971.71- Program number: 6,509,258.00- 6,509,258.00- 493,741.19- 950,537.28- 14.603 5,558,720.72- Department number: Revenues 6,509,258.00- 6,509,258.00- 493,741.19- 950,537.28- 14.603 5,558,720.72- Revenues Subtotal ----------- 6,509,258.00- 6,509,258.00- 493,741.19- 950,537.28- 14.603 5,558,720.72- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 13:23 12/13/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 213,321.00 213,321.00 13,187.73 22,290.01 10.449 191,030.99 135-50010-010-000 Overtime 13,250.00 13,250.00 1,212.03 3,424.59 25.846 9,825.41 135-50016-010-000 Longevity 3,080.00 3,080.00 3,080.00 3,080.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 300.00 600.00 11.765 4,500.00 135-50020-010-000 Retirement 32,725.00 32,725.00 27,480.64 29,685.80 90.713 3,039.20 135-50026-010-000 Medical Insurance 28,920.00 28,920.00 1,683.92 3,367.84 11.645 25,552.16 135-50027-010-000 Dental Insurance 2,091.00 2,091.00 132.78 265.56 12.700 1,825.44 135-50028-010-000 Vision Insurance 519.00 519.00 31.76 63.52 12.239 455.48 135-50029-010-000 Life Insurance & Other 1,204.00 1,204.00 286.80 286.80 23.821 917.20 135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 1,078.98 2,044.92 14.050 12,510.08 135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 252.34 478.25 14.050 2,925.75 135-50040-010-000 Unemployment Taxes 945.00 945.00 945.00 135-50045-010-000 Workman's Compensation 6,109.00 6,109.00 6,109.00 100.000 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 350.00 350.00 350.00 Subtotal: 325,773.00 325,773.00 48,726.98 71,696.29 22.008 254,076.71 135-55005-010-000 Engineering 3,000.00 3,000.00 3,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 8,971.68 10,009.23 20.018 39,990.77 135-55090-010-000 Vehicle Maintenance 3,700.00 3,700.00 459.39 459.39 12.416 3,240.61 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 1,546.80 1,546.80 53.338 1,353.20 135-55135-010-000 Lab Analysis 4,500.00 4,500.00 1,125.15 1,125.15 25.003 3,374.85 Subtotal: 64,100.00 64,100.00 12,103.02 13,140.57 20.500 50,959.43 135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 175.79 175.79 8.790 1,824.21 135-60020-010-000 Electricity 162,410.00 162,410.00 9,813.13 15,215.06 9.368 147,194.94 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 135-60080-010-000 Schools & Training 1,672.00 1,672.00 240.00 240.00 14.354 1,432.00 135-60090-010-000 Safety Program 500.00 500.00 500.00 135-60100-010-000 Travel & per diem 700.00 700.00 239.21 388.51 55.501 311.49 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 TCEQ Fees & Permits 35,800.00 35,800.00 8,173.45 8,173.45 22.831 27,626.55 135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 162,916.59 162,916.59 8.032 1,865,530.41 135-60245-010-000 Miscellaneous Expenses 500.00 500.00 500.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 168.20 213.20 5.076 3,986.80 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 1,500.00 1,500.00 Subtotal: 2,239,129.00 2,239,129.00 181,726.37 187,322.60 8.366 2,051,806.40 135-65005-010-000 Fuel & Lube 17,661.00 17,661.00 1,890.84 1,918.54 10.863 15,742.46 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 13:23 12/13/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 2,680.00 2,680.00 720.12 720.12 26.870 1,959.88 135-65030-010-000 Chemicals 6,200.00 6,200.00 47.33 719.63 11.607 5,480.37 135-65035-010-000 Small Tools 1,500.00 1,500.00 267.19 267.19 17.813 1,232.81 135-65040-010-000 Safety Equipment 2,000.00 2,000.00 2,000.00 135-65050-010-000 Meter Expense 143,550.00 143,550.00 93,750.00 93,750.00 65.308 49,800.00 Subtotal: 173,591.00 173,591.00 96,675.48 97,375.48 56.095 76,215.52 135-69005-010-000 Capital Expenses 181,800.00 181,800.00 181,800.00 135-69008-010-000 Short Term Debt Payments 387,037.00 387,037.00 387,037.00 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 270,000.00 270,000.00 59,869.00 59,869.00 22.174 210,131.00 135-69281-010-000 Capital Repair-Ground Storage 150,000.00 150,000.00 69,788.02 69,788.02 46.525 80,211.98 Subtotal: 1,018,837.00 1,018,837.00 129,657.02 129,657.02 12.726 889,179.98 Program number: 3,821,430.00 3,821,430.00 468,888.87 499,191.96 13.063 3,322,238.04 Department number: Water 3,821,430.00 3,821,430.00 468,888.87 499,191.96 13.063 3,322,238.04 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 13:23 12/13/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 196,781.00 196,781.00 14,401.78 24,303.91 12.351 172,477.09 135-50010-020-000 Overtime 10,166.00 10,166.00 1,361.99 2,153.98 21.188 8,012.02 135-50016-020-000 Longevity 2,858.00 2,858.00 2,857.50 2,857.50 99.983 .50 135-50017-020-000 Certification 4,200.00 4,200.00 350.00 700.00 16.667 3,500.00 135-50020-020-000 Retirement 29,821.00 29,821.00 27,645.29 29,754.23 99.776 66.77 135-50026-020-000 Medical Insurance 29,034.00 29,034.00 2,327.30 4,654.60 16.032 24,379.40 135-50027-020-000 Dental Insurance 2,112.00 2,112.00 175.34 350.68 16.604 1,761.32 135-50028-020-000 Vision Insurance 552.00 552.00 45.92 91.84 16.638 460.16 135-50029-020-000 Life Insurance & Other 920.00 920.00 311.58 311.58 33.867 608.42 135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 1,015.85 1,801.59 13.578 11,466.41 135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 237.56 421.34 13.578 2,681.66 135-50040-020-000 Unemployment Taxes 756.00 756.00 756.00 135-50045-020-000 Workman's Compensation 2,939.00 2,939.00 2,939.00 100.000 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 150.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 297,010.00 297,010.00 50,730.11 70,340.25 23.683 226,669.75 135-55070-020-000 Independent Labor 1,000.00 1,000.00 1,000.00 135-55080-020-000 Maintenance & Repairs 40,000.00 40,000.00 9,713.49 17,338.48 43.346 22,661.52 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 2,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,080.96 72.064 419.04 135-55125-020-000 Dumpster Services 15,000.00 15,000.00 3,857.66 3,857.66 25.718 11,142.34 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,498.50 3,578.50 11.928 26,421.50 Subtotal: 89,500.00 89,500.00 16,069.65 25,855.60 28.889 63,644.40 135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 2,700.00 233.69 233.69 8.655 2,466.31 135-60020-020-000 Electricity 153,045.00 153,045.00 11,623.23 16,219.77 10.598 136,825.23 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 161.45 161.45 32.290 338.55 135-60080-020-000 Schools & Training 3,272.00 3,272.00 104.66 104.66 3.199 3,167.34 135-60090-020-000 Safety Program 250.00 250.00 250.00 135-60100-020-000 Travel & per diem 1,400.00 1,400.00 233.10 349.65 24.975 1,050.35 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 1,020.00 68.000 480.00 135-60125-020-000 Advertising 2,000.00 2,000.00 2,000.00 135-60135-020-000 TCEQ Fees & Permits 56,000.00 56,000.00 7,729.80 13.803 48,270.20 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 148.10 148.10 74.050 51.90 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 Subtotal: 221,367.00 221,367.00 12,504.23 25,967.12 11.730 195,399.88 135-65005-020-000 Fuel & Lube 8,527.00 8,527.00 1,908.74 1,908.74 22.385 6,618.26 135-65010-020-000 Uniforms 2,574.00 2,574.00 490.23 490.23 19.045 2,083.77 135-65030-020-000 Chemicals 10,000.00 10,000.00 2,220.00 8,468.30 84.683 1,531.70 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 13:23 12/13/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65035-020-000 Small Tools 1,000.00 1,000.00 135.09 135.09 13.509 864.91 135-65040-020-000 Safety Equipment 250.00 250.00 250.00 135-65045-020-000 Lab Supplies 10,000.00 10,000.00 47.91 3,903.17 39.032 6,096.83 Subtotal: 32,351.00 32,351.00 4,801.97 14,905.53 46.074 17,445.47 135-69005-020-000 Capital Expenses 241,200.00 241,200.00 241,200.00 135-69280-020-000 Capital Repairs 158,000.00 158,000.00 158,000.00 Subtotal: 399,200.00 399,200.00 399,200.00 Program number: 1,039,428.00 1,039,428.00 84,105.96 137,068.50 13.187 902,359.50 Department number: Wastewater 1,039,428.00 1,039,428.00 84,105.96 137,068.50 13.187 902,359.50 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 13:23 12/13/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 156,475.00 156,475.00 11,449.62 19,625.83 12.542 136,849.17 135-50010-021-000 Overtime 7,297.00 7,297.00 584.65 1,183.54 16.220 6,113.46 135-50016-021-000 Longevity 3,818.00 3,818.00 3,817.50 3,817.50 99.987 .50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 300.00 16.667 1,500.00 135-50020-021-000 Retirement 23,574.00 23,574.00 21,547.77 23,245.40 98.606 328.60 135-50026-021-000 Medical Insurance 20,198.00 20,198.00 1,683.08 3,366.16 16.666 16,831.84 135-50027-021-000 Dental Insurance 1,409.00 1,409.00 124.48 248.96 17.669 1,160.04 135-50028-021-000 Vision Insurance 357.00 357.00 29.72 59.44 16.650 297.56 135-50029-021-000 Life Insurance & Other 1,008.00 1,008.00 238.68 238.68 23.679 769.32 135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 937.55 1,644.58 15.660 8,857.42 135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 219.26 384.61 15.660 2,071.39 135-50040-021-000 Unemployment Taxes 567.00 567.00 567.00 135-50045-021-000 Workman's Compensation 3,348.00 3,348.00 3,348.00 100.000 135-50070-021-000 Employee Relations 250.00 250.00 16.78 16.78 6.712 233.22 Subtotal: 233,059.00 233,059.00 40,799.09 57,479.48 24.663 175,579.52 135-55005-021-000 Engineering 1,500.00 1,500.00 2,450.00 2,450.00 163.333 950.00- 135-55080-021-000 Maintenance & Repairs 35,000.00 35,000.00 168.50 .481 34,831.50 135-55090-021-000 Vehicle Maintenance 1,900.00 1,900.00 1,900.00 Subtotal: 38,400.00 38,400.00 2,450.00 2,618.50 6.819 35,781.50 135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 217.50 217.50 6.214 3,282.50 135-60020-021-000 Electricity 18,705.00 18,705.00 1,355.78 1,688.65 9.028 17,016.35 135-60070-021-000 Dues & Memberships 250.00 250.00 111.00 111.00 44.400 139.00 135-60080-021-000 Schools & Training 826.00 826.00 240.00 330.00 39.952 496.00 135-60090-021-000 Safety Program 500.00 500.00 500.00 135-60100-021-000 Travel & per diem 450.00 450.00 67.71 87.14 19.364 362.86 135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 34,331.00 34,331.00 1,991.99 2,434.29 7.091 31,896.71 135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 1,834.81 1,834.81 15.142 10,282.19 135-65010-021-000 Uniforms 2,220.00 2,220.00 815.08 815.08 36.715 1,404.92 135-65030-021-000 Chemicals 7,500.00 7,500.00 7,500.00 135-65035-021-000 Small Tools 1,500.00 1,500.00 70.00 70.00 4.667 1,430.00 135-65040-021-000 Safety Equipment 500.00 500.00 500.00 Subtotal: 23,837.00 23,837.00 2,719.89 2,719.89 11.410 21,117.11 135-69005-021-000 Capital Expenses 90,000.00 90,000.00 90,000.00 135-69008-021-000 Short Term Debt Payments 40,260.00 40,260.00 40,260.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 13:23 12/13/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 130,260.00 130,260.00 130,260.00 Program number: 459,887.00 459,887.00 47,960.97 65,252.16 14.189 394,634.84 Department number: Collection 459,887.00 459,887.00 47,960.97 65,252.16 14.189 394,634.84 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 13:23 12/13/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 900.00 1,400.00 14.000 8,600.00 135-50030-026-000 Social Security Taxes 620.00 620.00 55.80 86.80 14.000 533.20 135-50035-026-000 Medicare Taxes 145.00 145.00 13.05 20.30 14.000 124.70 135-50040-026-000 Unemployment Taxes 210.00 210.00 26.10 40.60 19.333 169.40 135-50045-026-000 Workman's Compensation 150.00 150.00 150.00 Subtotal: 11,125.00 11,125.00 994.95 1,547.70 13.912 9,577.30 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 2,100.00 135-60075-026-000 Meetings 1,200.00 1,200.00 44.00 66.00 5.500 1,134.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 580.00 580.00 14.500 3,420.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 3,000.00 3,000.00 3,000.00 Subtotal: 15,450.00 15,450.00 624.00 646.00 4.181 14,804.00 Program number: 26,575.00 26,575.00 1,618.95 2,193.70 8.255 24,381.30 Department number: Board of Directors 26,575.00 26,575.00 1,618.95 2,193.70 8.255 24,381.30 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 13:23 12/13/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 444,730.00 444,730.00 33,862.95 59,733.29 13.431 384,996.71 135-50010-030-000 Overtime 1,500.00 1,500.00 40.37 49.31 3.287 1,450.69 135-50016-030-000 Longevity 2,193.00 2,193.00 2,317.50 2,317.50 105.677 124.50- 135-50020-030-000 Retirement 60,441.00 60,441.00 49,204.98 53,730.46 88.897 6,710.54 135-50026-030-000 Medical Insurance 44,066.00 44,066.00 3,185.30 6,370.60 14.457 37,695.40 135-50027-030-000 Dental Insurance 3,379.00 3,379.00 288.72 577.44 17.089 2,801.56 135-50028-030-000 Vision Insurance 795.00 795.00 66.20 132.40 16.654 662.60 135-50029-030-000 Life Insurance & Other 2,500.00 2,500.00 584.92 584.92 23.397 1,915.08 135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 2,077.59 4,015.01 14.441 23,786.99 135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 485.88 938.99 14.442 5,563.01 135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 134.08 329.92 21.465 1,207.08 135-50045-030-000 Workman's Compensation 831.00 831.00 831.00 100.000 135-50060-030-000 Pre-emp Physicals/Testing 250.00 250.00 4.00 39.00 15.600 211.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 5,000.00 Subtotal: 601,526.00 601,526.00 92,252.49 129,649.84 21.553 471,876.16 135-55030-030-000 Software & Support 63,555.00 63,555.00 5,530.27 8,492.02 13.362 55,062.98 135-55070-030-000 Independent Labor 2,700.00 2,700.00 2,700.00 135-55075-030-000 Records Management 500.00 500.00 500.00 135-55100-030-000 Building Maint & Supplies 5,000.00 5,000.00 1,475.92 1,508.28 30.166 3,491.72 135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,812.17 3,490.68 17.281 16,709.32 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 6,825.00 6,825.00 45.500 8,175.00 135-55161-030-000 Outside Services-Town Semo 85,465.00 85,465.00 85,465.00 135-55165-030-000 Collection Fees 159.77 159.77- 135-55205-030-000 Utility Billing Contract 11,000.00 11,000.00 1,567.28 1,567.28 14.248 9,432.72 Subtotal: 203,420.00 203,420.00 17,210.64 22,043.03 10.836 181,376.97 135-60005-030-000 Telephone 9,000.00 9,000.00 377.76 1,717.10 19.079 7,282.90 135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 327.04 477.04 13.344 3,097.96 135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 942.99 942.99 7.243 12,076.01 135-60025-030-000 Water 3,100.00 3,100.00 125.06 125.06 4.034 2,974.94 135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 2,197.02 2,197.02 16.667 10,984.98 135-60035-030-000 Postage 23,000.00 23,000.00 3,757.60 4,410.26 19.175 18,589.74 135-60040-030-000 Service Charges & Fees 18,000.00 18,000.00 2,630.63 5,381.46 29.897 12,618.54 135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 1,056.53- -12.430 9,556.53 135-60055-030-000 Insurance 35,000.00 35,000.00 26,536.44 60,601.92 173.148 25,601.92- 135-60066-030-000 Publications/Books/Subscripts 750.00 750.00 109.00 558.22 74.429 191.78 135-60070-030-000 Dues & Memberships 2,400.00 2,400.00 550.00 650.00 27.083 1,750.00 135-60075-030-000 Meetings 250.00 250.00 88.00 35.200 162.00 135-60080-030-000 Schools & Training 5,500.00 5,500.00 450.00 450.00 8.182 5,050.00 135-60100-030-000 Travel & per diem 3,950.00 3,950.00 39.55 49.60 1.256 3,900.40 135-60110-030-000 Physicals/Testing 500.00 500.00 500.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 13:23 12/13/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 4,000.00 4,000.00 4,000.00 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 15,000.00 15,000.00 109.13 122.13 .814 14,877.87 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 265.00 10.600 2,235.00 Subtotal: 173,076.00 173,076.00 38,152.22 76,979.27 44.477 96,096.73 135-65010-030-000 Uniforms 1,635.00 1,635.00 624.12 624.12 38.172 1,010.88 135-65055-030-000 Hardware 20,188.00 20,188.00 549.38 6,288.27 31.149 13,899.73 135-65085-030-000 Office Supplies 8,200.00 8,200.00 1,036.47 1,852.62 22.593 6,347.38 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 285.00 511.00 8.915 5,221.00 135-65095-030-000 Maintenance Supplies 2,000.00 2,000.00 97.40 97.40 4.870 1,902.60 135-65097-030-000 Vending Machine Supplies 500.00 500.00 500.00 135-65105-030-000 Printing 5,200.00 5,200.00 395.00 395.00 7.596 4,805.00 Subtotal: 43,455.00 43,455.00 2,987.37 9,768.41 22.479 33,686.59 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 513.70 14.890 2,936.30 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 256.85 513.70 1.692 29,847.30 Program number: 1,051,838.00 1,051,838.00 150,859.57 238,954.25 22.718 812,883.75 Department number: Administration 1,051,838.00 1,051,838.00 150,859.57 238,954.25 22.718 812,883.75 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 13:23 12/13/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 70,000.00 70,000.00 5,768.75 5,768.75 8.241 64,231.25 135-55055-039-000 Auditing 21,200.00 21,200.00 5,175.00 5,175.00 24.410 16,025.00 135-55060-039-000 Appraisal 15,100.00 15,100.00 2,322.74 15.382 12,777.26 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 110,100.00 110,100.00 10,943.75 13,266.49 12.049 96,833.51 Program number: 110,100.00 110,100.00 10,943.75 13,266.49 12.049 96,833.51 Department number: Non Departmental 110,100.00 110,100.00 10,943.75 13,266.49 12.049 96,833.51 Expenditures Subtotal ----------- 6,509,258.00 6,509,258.00 764,378.07 955,927.06 14.686 5,553,330.94 Fund number: 135 MUD 1 General Fund 270,636.88 5,389.78 5,389.78- . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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 435 11/01/2012 Property Taxes/Assessments (2,512.70) (199.46) (2,712.16) GL 396 11/02/2012 Property Taxes/Assessments (132.34) (2,844.50) GL 398 11/05/2012 Property Taxes/Assessments (132.02) (2,976.52) GL 434 11/06/2012 Property Taxes/Assessments (113.91) (3,090.43) GL 400 11/07/2012 Property Taxes/Assessments (2,129.23) (5,219.66) GL 401 11/08/2012 Property Taxes/Assessments (26.85) (5,246.51) GL 403 11/09/2012 Property Taxes/Assessments (62.85) (5,309.36) GL 405 11/13/2012 Property Taxes/Assessments (181.74) (5,491.10) GL 409 11/14/2012 Property Taxes/Assessments (234.79) (5,725.89) GL 411 11/15/2012 Property Taxes/Assessments (325.63) (6,051.52) GL 413 11/16/2012 Property Taxes/Assessments (117.52) (6,169.04) GL 415 11/19/2012 Property Taxes/Assessments (288.47) (6,457.51) GL 417 11/20/2012 Property Taxes/Assessments (96.50) (6,554.01) GL 419 11/21/2012 Property Taxes/Assessments (260.37) (6,814.38) GL 428 11/26/2012 Property Taxes/Assessments (406.64) (7,221.02) GL 430 11/27/2012 Property Taxes/Assessments (244.40) (7,465.42) GL 431 11/28/2012 Property Taxes/Assessments (130.62) (7,596.04) GL 432 11/29/2012 Property Taxes/Assessments (88.09) (7,684.13) GL 433 11/30/2012 Property Taxes/Assessments (175.35) (7,859.48) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (5,346.78) (7,859.48) ** (99,884.00) Budgeted (92,024.52) Remaining 8 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 400 11/07/2012 Property Taxes/Assessments (254.68) 221.93 (32.75) GL 417 11/20/2012 Property Taxes/Assessments (609.08) (641.83) GL 431 11/28/2012 Property Taxes/Assessments (17.70) (659.53) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (404.85) (659.53) ** (500.00) Budgeted 159.53 Remaining 132 % Used Account: 135-40015-000-000 Property Taxes/P & I 400 11/07/2012 Property Taxes/Assessments (78.03) (104.53) (182.56) GL 409 11/14/2012 Property Taxes/Assessments (.68) (183.24) GL 413 11/16/2012 Property Taxes/Assessments (1.14) (184.38) GL 415 11/19/2012 Property Taxes/Assessments (125.61) (309.99) GL 417 11/20/2012 Property Taxes/Assessments (140.09) (450.08) GL 431 11/28/2012 Property Taxes/Assessments (.01) (450.09) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (372.06) (450.09) ** (1,200.00) Budgeted (749.91) Remaining 38 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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-47000-000-000 Water 320 11/27/2012 UB 11/27/12 Adjustments UB20121127-20121127 User: (266,584.35) 12.71 (266,571.64) UB 343 11/30/2012 UB 11/30/12 Billing UB20121130-20121130 User: (286,498.32) (553,069.96) UB _______________ Account: 135-47000-000-000 Water Totals: (286,485.61) (553,069.96) ** (3,545,609.00) Budgeted (2,992,539.04) Remaining 16 % Used Account: 135-47005-000-000 Sewer 320 11/27/2012 UB 11/27/12 Adjustments UB20121127-20121127 User: (131,687.66) 12.71 (131,674.95) UB 343 11/30/2012 UB 11/30/12 Billing UB20121130-20121130 User: (148,622.34) (280,297.29) UB 461 11/30/2012 Recode Comm Sewer to Seewr (2,485.10) (282,782.39) GL _______________ Account: 135-47005-000-000 Sewer Totals: (151,094.73) (282,782.39) ** (1,653,747.00) Budgeted (1,370,964.61) Remaining 17 % Used Account: 135-47015-000-000 Commercial Sewer 343 11/30/2012 UB 11/30/12 Billing UB20121130-20121130 User: (2,485.10) (2,485.10) UB 461 11/30/2012 Recode Comm Sewer to Seewr 2,485.10 .00 GL _______________ Account: 135-47015-000-000 Commercial Sewer Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-47020-000-000 Standby 343 11/30/2012 UB 11/30/12 Billing UB20121130-20121130 User: (47.90) (54.00) (101.90) UB _______________ Account: 135-47020-000-000 Standby Totals: (54.00) (101.90) ** (576.00) Budgeted (474.10) Remaining 18 % Used Account: 135-47025-000-000 Penalties 272 11/19/2012 UB 11/19/12 Adjustments UB20121119-20121119 User: (5,041.52) (27.56) (5,069.08) UB 286 11/21/2012 UB 11/21/2012 Penalties UB20121121-20121121 User: (6,058.41) (11,127.49) UB 320 11/27/2012 UB 11/27/12 Adjustments UB20121127-20121127 User: 4.63 (11,122.86) UB 329 11/28/2012 UB 11/28/2012 Adjustments UB20121128-20121128 User: 384.16 (10,738.70) UB 343 11/30/2012 UB 11/30/12 Billing UB20121130-20121130 User: (471.79) (11,210.49) UB _______________ Account: 135-47025-000-000 Penalties Totals: (6,168.97) (11,210.49) ** (64,580.00) Budgeted (53,369.51) Remaining 17 % Used Account: 135-47030-000-000 Service Charges . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 168 11/07/2012 UB 11/7/12 Cut Off List Fees UB20121107-20121107 User: (903.00) (800.00) (1,703.00) UB 279 11/09/2012 UB 11/9/12 Adjustments UB20121109-20121109 User: (25.00) (1,728.00) UB 281 11/13/2012 UB 11/13/12 Adjustment UB20121113-20121113 User: (25.00) (1,753.00) UB 324 11/21/2012 UB 11/21/12 Adjustments UB20121121-20121121 User: (25.00) (1,778.00) UB 343 11/30/2012 UB 11/30/12 Billing UB20121130-20121130 User: (3.00) (1,781.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (878.00) (1,781.00) ** (11,625.00) Budgeted (9,844.00) Remaining 15 % Used Account: 135-47035-000-000 Plumbing Inspections .00 .00 _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: .00 .00 ** (1,800.00) Budgeted (1,800.00) Remaining 0 % Used Account: 135-47045-000-000 Sewer Inspections 359 11/01/2012 Permits 11/1/12 (150.00) (150.00) (300.00) GL 353 11/19/2012 Permits 11/19/12 (150.00) (450.00) GL _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (450.00) ** (5,200.00) Budgeted (4,750.00) Remaining 9 % Used Account: 135-47070-000-000 TCCC Effluent Charges 425 11/26/2012 TCCC-Oct Effluent (4,882.15) (4,882.15) GL _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (4,882.15) (4,882.15) ** (77,575.00) Budgeted (72,692.85) Remaining 6 % Used Account: 135-48005-000-000 Utility Fees 348 11/06/2012 Permits 11/6/12 (41,400.00) (2,300.00) (43,700.00) GL 349 11/07/2012 Permits 11/7/12 (9,200.00) (52,900.00) GL 350 11/08/2012 Permits 11/8/12 (6,900.00) (59,800.00) GL 351 11/14/2012 Permits 11/14/12 (2,300.00) (62,100.00) GL 352 11/15/2012 Permits 11/15/12 (2,300.00) (64,400.00) GL 355 11/28/2012 Permits 11/28/12 (2,300.00) (66,700.00) GL 356 11/30/2012 Permits 11/30/12 (4,600.00) (71,300.00) GL _______________ Account: 135-48005-000-000 Utility Fees Totals: (29,900.00) (71,300.00) ** (644,000.00) Budgeted (572,700.00) Remaining 11 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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-49010-000-000 Interest Income 377 11/30/2012 Nov Bank Interest (601.85) (69.08) (670.93) GL 377 11/30/2012 Nov Bank Interest (450.35) (1,121.28) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (519.43) (1,121.28) ** (5,500.00) Budgeted (4,378.72) Remaining 20 % Used Account: 135-49016-000-000 Cell Tower Revenue 422 11/02/2012 AT&T Cell Tower (847.00) (910.53) (1,757.53) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (1,757.53) ** (10,164.00) Budgeted (8,406.47) Remaining 17 % Used Account: 135-49018-000-000 Building Rent Income 423 11/18/2012 Town 10/2011 gas,rent, Misc (583.33) (583.33) (1,166.66) GL _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,166.66) ** (7,000.00) Budgeted (5,833.34) Remaining 17 % Used Account: 135-49030-000-000 Vending Revenue 421 11/02/2012 Coffee $ (18.76) (18.76) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (18.76) (18.76) ** (350.00) Budgeted (331.24) Remaining 5 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (305,748.00) Budgeted (305,748.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 359 11/01/2012 Permits 11/1/12 (5,548.00) (292.00) (5,840.00) GL 348 11/06/2012 Permits 11/6/12 (292.00) (6,132.00) GL 349 11/07/2012 Permits 11/7/12 (1,168.00) (7,300.00) GL 350 11/08/2012 Permits 11/8/12 (876.00) (8,176.00) GL 351 11/14/2012 Permits 11/14/12 (292.00) (8,468.00) GL 352 11/15/2012 Permits 11/15/12 (292.00) (8,760.00) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 353 11/19/2012 Permits 11/19/12 (5,548.00) (292.00) (9,052.00) GL 354 11/26/2012 Permits 11/26/12 (292.00) (9,344.00) GL 355 11/28/2012 Permits 11/28/12 (292.00) (9,636.00) GL 356 11/30/2012 Permits 11/30/12 (584.00) (10,220.00) GL _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (4,672.00) (10,220.00) ** (73,000.00) Budgeted (62,780.00) Remaining 14 % Used Account: 135-49900-000-000 Miscellaneous Income 359 11/01/2012 Permits 11/1/12 (556.07) (50.00) (606.07) GL 423 11/18/2012 Town 10/2011 gas,rent, Misc (840.00) (1,446.07) GL 423 11/18/2012 Town 10/2011 gas,rent, Misc (109.99) (1,556.06) GL 353 11/19/2012 Permits 11/19/12 (50.00) (1,606.06) GL 426 11/26/2012 Oncor Refnd/Unclaimed Property (100.00) (1,706.06) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (1,149.99) (1,706.06) ** (1,000.00) Budgeted 706.06 Remaining 171 % Used Account: 135-49905-000-000 Gas Well Revenue .00 .00 _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 .00 ** (200.00) Budgeted (200.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (950,537.28) ** (6,509,258.00) Budgeted (5,558,720.72) Remaining 15 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 442 11/07/2012 Payroll 11/7/12 9,102.28 6,585.47 15,687.75 GL 443 11/21/2012 Payroll 11/21/12 6,602.26 22,290.01 GL 445 11/21/2012 MUD Longevity 11/21/12 3,080.00 25,370.01 GL 462 11/21/2012 Recode Longevity pay (3,080.00) 22,290.01 GL _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 13,187.73 22,290.01 ** 213,321.00 Budgeted 191,030.99 Remaining 10 % Used Account: 135-50010-010-000 Overtime 442 11/07/2012 Payroll 11/7/12 2,212.56 489.28 2,701.84 GL 442 11/07/2012 Payroll 11/7/12 80.00 2,781.84 GL 443 11/21/2012 Payroll 11/21/12 436.43 3,218.27 GL 443 11/21/2012 Payroll 11/21/12 160.00 3,378.27 GL 444 11/21/2012 Supplemental Payroll 11/21/12 46.32 3,424.59 GL _______________ Account: 135-50010-010-000 Overtime Totals: 1,212.03 3,424.59 ** 13,250.00 Budgeted 9,825.41 Remaining 26 % Used Account: 135-50016-010-000 Longevity 462 11/21/2012 Recode Longevity pay 3,080.00 3,080.00 GL _______________ Account: 135-50016-010-000 Longevity Totals: 3,080.00 3,080.00 ** 3,080.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 442 11/07/2012 Payroll 11/7/12 300.00 300.00 600.00 GL _______________ Account: 135-50017-010-000 Certification Totals: 300.00 600.00 ** 5,100.00 Budgeted 4,500.00 Remaining 12 % Used Account: 135-50020-010-000 Retirement 442 11/07/2012 Payroll 11/7/12 2,205.16 1,030.25 3,235.41 GL 443 11/21/2012 Payroll 11/21/12 994.87 4,230.28 GL 444 11/21/2012 Supplemental Payroll 11/21/12 6.40 4,236.68 GL 445 11/21/2012 MUD Longevity 11/21/12 425.66 4,662.34 GL 335 11/30/2012 Nov A/P Retirement Employer Contributi 25,023.46 29,685.80 TCDRS 31974 AP _______________ Account: 135-50020-010-000 Retirement Totals: 27,480.64 29,685.80 ** 32,725.00 Budgeted 3,039.20 Remaining 91 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50026-010-000 Medical Insurance 442 11/07/2012 Payroll 11/7/12 1,683.92 841.96 2,525.88 GL 443 11/21/2012 Payroll 11/21/12 841.96 3,367.84 GL _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,683.92 3,367.84 ** 28,920.00 Budgeted 25,552.16 Remaining 12 % Used Account: 135-50027-010-000 Dental Insurance 442 11/07/2012 Payroll 11/7/12 132.78 66.39 199.17 GL 443 11/21/2012 Payroll 11/21/12 66.39 265.56 GL _______________ Account: 135-50027-010-000 Dental Insurance Totals: 132.78 265.56 ** 2,091.00 Budgeted 1,825.44 Remaining 13 % Used Account: 135-50028-010-000 Vision Insurance 442 11/07/2012 Payroll 11/7/12 31.76 15.88 47.64 GL 443 11/21/2012 Payroll 11/21/12 15.88 63.52 GL _______________ Account: 135-50028-010-000 Vision Insurance Totals: 31.76 63.52 ** 519.00 Budgeted 455.48 Remaining 12 % Used Account: 135-50029-010-000 Life Insurance & Other 442 11/07/2012 Payroll 11/7/12 143.40 143.40 GL 443 11/21/2012 Payroll 11/21/12 143.40 286.80 GL _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 286.80 286.80 ** 1,204.00 Budgeted 917.20 Remaining 24 % Used Account: 135-50030-010-000 Social Security Taxes 442 11/07/2012 Payroll 11/7/12 965.94 450.51 1,416.45 GL 443 11/21/2012 Payroll 11/21/12 434.64 1,851.09 GL 444 11/21/2012 Supplemental Payroll 11/21/12 2.87 1,853.96 GL 445 11/21/2012 MUD Longevity 11/21/12 190.96 2,044.92 GL _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,078.98 2,044.92 ** 14,555.00 Budgeted 12,510.08 Remaining 14 % Used Account: 135-50035-010-000 Medicare Taxes . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 442 11/07/2012 Payroll 11/7/12 225.91 105.36 331.27 GL 443 11/21/2012 Payroll 11/21/12 101.65 432.92 GL 444 11/21/2012 Supplemental Payroll 11/21/12 .67 433.59 GL 445 11/21/2012 MUD Longevity 11/21/12 44.66 478.25 GL _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 252.34 478.25 ** 3,404.00 Budgeted 2,925.75 Remaining 14 % Used Account: 135-50040-010-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 .00 ** 945.00 Budgeted 945.00 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 6,109.00 .00 6,109.00 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 6,109.00 ** 6,109.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 .00 .00 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-010-000 Maintenance & Repairs 303 11/27/2012 Nov A/P Meters/Couplings 1,037.55 1,977.00 3,014.55 ATLAS UTILITY SUPPLY CO. 31946 AP 303 11/27/2012 Nov A/P 6" service saddles 108.18 3,122.73 ATLAS UTILITY SUPPLY CO. 31946 AP 303 11/27/2012 Nov A/P Misc Water repair parts 1,904.10 5,026.83 ATLAS UTILITY SUPPLY CO. 31946 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards/McMahon 229.39 5,256.22 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards/McMahon (163.40) 5,092.82 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards/McMahon 94.20 5,187.02 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 38.76 5,225.78 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 34.62 5,260.40 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 19.34 5,279.74 JPMORGAN CHASE BANK NA 31966 AP 387 11/30/2012 Nov A/P Concrete pours 1040 TC Dr, 13 2,360.00 7,639.74 Robert West Construction, Inc 31990 AP 387 11/30/2012 Nov A/P Repair on cylinder 2,369.49 10,009.23 HOLT CAT 31983 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 8,971.68 10,009.23 ** 50,000.00 Budgeted 39,990.77 Remaining 20 % Used Account: 135-55090-010-000 Vehicle Maintenance 259 11/18/2012 Nov A/P Ignition switch/water 2004 Che 226.18 226.18 WATSONS AUTOMOTIVE 31941 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards/McMahon 233.21 459.39 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 459.39 459.39 ** 3,700.00 Budgeted 3,240.61 Remaining 12 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 259 11/18/2012 Nov A/P 1,546.80 1,546.80 HOLT CAT 31918 AP _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 1,546.80 1,546.80 ** 2,900.00 Budgeted 1,353.20 Remaining 53 % Used Account: 135-55135-010-000 Lab Analysis 259 11/18/2012 Nov A/P Bac-T Samples 475.00 475.00 TARRANT CTY PUBLIC HEALTH LAB 31928 AP 303 11/27/2012 Nov A/P Asbestos testing 130.00 605.00 CRISP ANALYTICAL LABS, LLC 31951 AP 387 11/30/2012 Nov A/P Free ammonia reagent test set 520.15 1,125.15 HACH COMPANY 31982 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 1,125.15 1,125.15 ** 4,500.00 Budgeted 3,374.85 Remaining 25 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 259 11/18/2012 Nov A/P Oct Cells 175.79 175.79 VERIZON WIRELESS 31940 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-010-000 Communications/Pagers/Mobiles Totals: 175.79 175.79 ** 2,000.00 Budgeted 1,824.21 Remaining 9 % Used Account: 135-60020-010-000 Electricity 259 11/18/2012 Nov A/P Electricity 10/11-11/9 5,401.93 80.87 5,482.80 HUDSON ENERGY 31919 AP 303 11/27/2012 Nov A/P Electricity 10/11-11/12 5,708.65 11,191.45 HUDSON ENERGY 31955 AP 303 11/27/2012 Nov A/P Electricity 10/11-11/12 4,023.61 15,215.06 HUDSON ENERGY 31955 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,813.13 15,215.06 ** 162,410.00 Budgeted 147,194.94 Remaining 9 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.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 309 11/27/2012 Nov A/P 10/6-11/5 PCards/Slaght 240.00 240.00 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 240.00 240.00 ** 1,672.00 Budgeted 1,432.00 Remaining 14 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 442 11/07/2012 Payroll 11/7/12 149.30 187.59 336.89 GL 443 11/21/2012 Payroll 11/21/12 51.62 388.51 GL _______________ Account: 135-60100-010-000 Travel & per diem Totals: 239.21 388.51 ** 700.00 Budgeted 311.49 Remaining 56 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 259 11/18/2012 Nov A/P Water System Fee FY13 7,965.75 7,965.75 TX COMMISSION ENVIRONMENTAL QU 31938 AP 387 11/30/2012 Nov A/P Water testing per TCEQ 207.70 8,173.45 LOWER COLORADO RIVER AUTHORITY 31985 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 8,173.45 8,173.45 ** 35,800.00 Budgeted 27,626.55 Remaining 23 % Used Account: 135-60150-010-000 Wholesale Water 387 11/30/2012 Nov A/P Oct Wholesale Water 162,916.59 162,916.59 CITY OF FORT WORTH 31981 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 162,916.59 162,916.59 ** 2,028,447.00 Budgeted 1,865,530.41 Remaining 8 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 45.00 108.00 153.00 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 42.00 195.00 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 18.20 213.20 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-60280-010-000 Property Maintenance Totals: 168.20 213.20 ** 4,200.00 Budgeted 3,986.80 Remaining 5 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 323 11/28/2012 October Gas Log 27.70 1,124.47 1,152.17 GL 393 11/30/2012 Nov Gas Purchases 766.37 1,918.54 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,890.84 1,918.54 ** 17,661.00 Budgeted 15,742.46 Remaining 11 % Used Account: 135-65010-010-000 Uniforms 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 47.91 47.91 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 672.21 720.12 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-65010-010-000 Uniforms Totals: 720.12 720.12 ** 2,680.00 Budgeted 1,959.88 Remaining 27 % Used Account: 135-65030-010-000 Chemicals 309 11/27/2012 Nov A/P 10/6-11/5 PCards/McMahon 672.30 4.69 676.99 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 42.64 719.63 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 47.33 719.63 ** 6,200.00 Budgeted 5,480.37 Remaining 12 % Used Account: 135-65035-010-000 Small Tools 259 11/18/2012 Nov A/P Tool Kits 70.00 70.00 TEXAS FACILITIES COMMISSION 31929 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 8.99 78.99 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 188.20 267.19 JPMORGAN CHASE BANK NA 31966 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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: 267.19 267.19 ** 1,500.00 Budgeted 1,232.81 Remaining 18 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 303 11/27/2012 Nov A/P Meters/Couplings 45,000.00 45,000.00 ATLAS UTILITY SUPPLY CO. 31946 AP 387 11/30/2012 Nov A/P Meters & transmitters 48,750.00 93,750.00 ATLAS UTILITY SUPPLY CO. 31978 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 93,750.00 93,750.00 ** 143,550.00 Budgeted 49,800.00 Remaining 65 % Used Account: 135-69005-010-000 Capital Expenses .00 .00 _______________ Account: 135-69005-010-000 Capital Expenses Totals: .00 .00 ** 181,800.00 Budgeted 181,800.00 Remaining 0 % Used Account: 135-69008-010-000 Short Term Debt Payments .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt Payments Totals: .00 .00 ** 387,037.00 Budgeted 387,037.00 Remaining 0 % 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 387 11/30/2012 Nov A/P Electrical on Well #1 repair 285.00 285.00 CIRCLE R ELECTRIC CO 31980 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 387 11/30/2012 Nov A/P Well #1 Repair 59,584.00 59,869.00 MILLICAN WELL SERVICE, LLC 31986 AP _______________ Account: 135-69280-010-000 Capital Repairs Totals: 59,869.00 59,869.00 ** 270,000.00 Budgeted 210,131.00 Remaining 22 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 259 11/18/2012 Nov A/P Annual Maint on Ground Storage 69,788.02 69,788.02 UTILITY & ENVIRONMENTAL SVCS 31939 AP 322 11/18/2012 Void A/P ck 31939/wrong vendor Annual Maint on Ground Storage (69,788.02) .00 UTILITY & ENVIRONMENTAL SVCS 31939 AP 335 11/30/2012 Nov A/P Annual Maintenance on Ground S 69,788.02 69,788.02 UTILITY SERVICE CO, INC. 31975 AP _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: 69,788.02 69,788.02 ** 150,000.00 Budgeted 80,211.98 Remaining 47 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 499,191.96 ** 3,821,430.00 Budgeted 3,322,238.04 Remaining 13 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 442 11/07/2012 Payroll 11/7/12 9,902.13 7,161.86 17,063.99 GL 443 11/21/2012 Payroll 11/21/12 7,239.92 24,303.91 GL 445 11/21/2012 MUD Longevity 11/21/12 2,857.50 27,161.41 GL 462 11/21/2012 Recode Longevity pay (2,857.50) 24,303.91 GL _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,401.78 24,303.91 ** 196,781.00 Budgeted 172,477.09 Remaining 12 % Used Account: 135-50010-020-000 Overtime 442 11/07/2012 Payroll 11/7/12 791.99 445.81 1,237.80 GL 443 11/21/2012 Payroll 11/21/12 587.85 1,825.65 GL 443 11/21/2012 Payroll 11/21/12 160.00 1,985.65 GL 444 11/21/2012 Supplemental Payroll 11/21/12 168.33 2,153.98 GL _______________ Account: 135-50010-020-000 Overtime Totals: 1,361.99 2,153.98 ** 10,166.00 Budgeted 8,012.02 Remaining 21 % Used Account: 135-50016-020-000 Longevity 462 11/21/2012 Recode Longevity pay 2,857.50 2,857.50 GL _______________ Account: 135-50016-020-000 Longevity Totals: 2,857.50 2,857.50 ** 2,858.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 442 11/07/2012 Payroll 11/7/12 350.00 350.00 700.00 GL _______________ Account: 135-50017-020-000 Certification Totals: 350.00 700.00 ** 4,200.00 Budgeted 3,500.00 Remaining 17 % Used Account: 135-50020-020-000 Retirement 442 11/07/2012 Payroll 11/7/12 2,108.94 1,099.75 3,208.69 GL 443 11/21/2012 Payroll 11/21/12 1,103.91 4,312.60 GL 444 11/21/2012 Supplemental Payroll 11/21/12 23.26 4,335.86 GL 445 11/21/2012 MUD Longevity 11/21/12 394.91 4,730.77 GL 335 11/30/2012 Nov A/P Retirement Employer Contributi 25,023.46 29,754.23 TCDRS 31974 AP _______________ Account: 135-50020-020-000 Retirement Totals: 27,645.29 29,754.23 ** 29,821.00 Budgeted 66.77 Remaining 100 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50026-020-000 Medical Insurance 442 11/07/2012 Payroll 11/7/12 2,327.30 1,163.65 3,490.95 GL 443 11/21/2012 Payroll 11/21/12 1,163.65 4,654.60 GL _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,327.30 4,654.60 ** 29,034.00 Budgeted 24,379.40 Remaining 16 % Used Account: 135-50027-020-000 Dental Insurance 442 11/07/2012 Payroll 11/7/12 175.34 87.67 263.01 GL 443 11/21/2012 Payroll 11/21/12 87.67 350.68 GL _______________ Account: 135-50027-020-000 Dental Insurance Totals: 175.34 350.68 ** 2,112.00 Budgeted 1,761.32 Remaining 17 % Used Account: 135-50028-020-000 Vision Insurance 442 11/07/2012 Payroll 11/7/12 45.92 22.96 68.88 GL 443 11/21/2012 Payroll 11/21/12 22.96 91.84 GL _______________ Account: 135-50028-020-000 Vision Insurance Totals: 45.92 91.84 ** 552.00 Budgeted 460.16 Remaining 17 % Used Account: 135-50029-020-000 Life Insurance & Other 442 11/07/2012 Payroll 11/7/12 155.79 155.79 GL 443 11/21/2012 Payroll 11/21/12 155.79 311.58 GL _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 311.58 311.58 ** 920.00 Budgeted 608.42 Remaining 34 % Used Account: 135-50030-020-000 Social Security Taxes 442 11/07/2012 Payroll 11/7/12 785.74 413.19 1,198.93 GL 443 11/21/2012 Payroll 11/21/12 415.05 1,613.98 GL 444 11/21/2012 Supplemental Payroll 11/21/12 10.44 1,624.42 GL 445 11/21/2012 MUD Longevity 11/21/12 177.17 1,801.59 GL _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,015.85 1,801.59 ** 13,268.00 Budgeted 11,466.41 Remaining 14 % Used Account: 135-50035-020-000 Medicare Taxes . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 442 11/07/2012 Payroll 11/7/12 183.78 96.62 280.40 GL 443 11/21/2012 Payroll 11/21/12 97.07 377.47 GL 444 11/21/2012 Supplemental Payroll 11/21/12 2.44 379.91 GL 445 11/21/2012 MUD Longevity 11/21/12 41.43 421.34 GL _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 237.56 421.34 ** 3,103.00 Budgeted 2,681.66 Remaining 14 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 756.00 Budgeted 756.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 2,939.00 .00 2,939.00 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 2,939.00 ** 2,939.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 259 11/18/2012 Nov A/P Wastewater study 5,397.50 5,397.50 THE WALLACE GROUP, INC. 31932 AP 458 11/30/2012 Wallace Group/Assigned FB (5,397.50) .00 GL _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-020-000 Maintenance & Repairs 259 11/18/2012 Nov A/P Installation of scum pump 7,624.99 672.00 8,296.99 XYLEM WATER SOLUTIONS USA INC 31943 AP 259 11/18/2012 Nov A/P Repair of 10HP pump 3,931.00 12,227.99 XYLEM WATER SOLUTIONS USA INC 31943 AP 303 11/27/2012 Nov A/P Wiring #2 Blower motor, fix Bl 1,320.00 13,547.99 PUMP SOLUTIONS INC 31962 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Richey 759.09 14,307.08 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig (381.75) 13,925.33 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 3,988.00 17,913.33 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 640.05 18,553.38 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig (834.95) 17,718.43 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig (379.95) 17,338.48 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 9,713.49 17,338.48 ** 40,000.00 Budgeted 22,661.52 Remaining 43 % Used Account: 135-55090-020-000 Vehicle Maintenance .00 .00 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,080.96 .00 1,080.96 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,080.96 ** 1,500.00 Budgeted 419.04 Remaining 72 % Used Account: 135-55125-020-000 Dumpster Services 259 11/18/2012 Nov A/P Sudge Haul off 1,602.04 1,602.04 CHANEY ENVIRONMENTAL 31907 AP 259 11/18/2012 Nov A/P Sludge Haul off 754.06 2,356.10 CHANEY ENVIRONMENTAL 31907 AP 303 11/27/2012 Nov A/P Sludge haul off 779.96 3,136.06 CHANEY ENVIRONMENTAL 31949 AP 335 11/30/2012 Nov A/P Sludge haul off 721.60 3,857.66 CHANEY ENVIRONMENTAL 31968 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,857.66 3,857.66 ** 15,000.00 Budgeted 11,142.34 Remaining 26 % Used Account: 135-55135-020-000 Lab Analysis 259 11/18/2012 Nov A/P Wet Chem Analysis 1,080.00 2,448.50 3,528.50 TALEM, INC 31927 AP 259 11/18/2012 Nov A/P Special Creek Sampling 50.00 3,578.50 HUTHER AND ASSOCIATES,INC 31920 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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-55135-020-000 Lab Analysis Totals: 2,498.50 3,578.50 ** 30,000.00 Budgeted 26,421.50 Remaining 12 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 259 11/18/2012 Nov A/P Oct Cells 233.69 233.69 VERIZON WIRELESS 31940 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 233.69 233.69 ** 2,700.00 Budgeted 2,466.31 Remaining 9 % Used Account: 135-60020-020-000 Electricity 303 11/27/2012 Nov A/P Electricity 10/12-11/12 4,596.54 11,623.23 16,219.77 HUDSON ENERGY 31955 AP _______________ Account: 135-60020-020-000 Electricity Totals: 11,623.23 16,219.77 ** 153,045.00 Budgeted 136,825.23 Remaining 11 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 161.45 161.45 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: 161.45 161.45 ** 500.00 Budgeted 338.55 Remaining 32 % Used Account: 135-60080-020-000 Schools & Training 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 104.66 104.66 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-60080-020-000 Schools & Training Totals: 104.66 104.66 ** 3,272.00 Budgeted 3,167.34 Remaining 3 % Used Account: 135-60090-020-000 Safety Program .00 .00 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 442 11/07/2012 Payroll 11/7/12 116.55 46.62 163.17 GL 443 11/21/2012 Payroll 11/21/12 186.48 349.65 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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-020-000 Travel & per diem Totals: 233.10 349.65 ** 1,400.00 Budgeted 1,050.35 Remaining 25 % Used Account: 135-60105-020-000 Rent/Lease Equipment 1,020.00 .00 1,020.00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 1,020.00 ** 1,500.00 Budgeted 480.00 Remaining 68 % Used Account: 135-60125-020-000 Advertising .00 .00 _______________ Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 7,729.80 .00 7,729.80 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 7,729.80 ** 56,000.00 Budgeted 48,270.20 Remaining 14 % Used Account: 135-60245-020-000 Miscellaneous Expenses 259 11/18/2012 Nov A/P First aid supplies 20.42 20.42 CINTAS FAS LOCKBOX 636525 31908 AP 259 11/18/2012 Nov A/P First aid supplies 36.48 56.90 CINTAS FAS LOCKBOX 636525 31908 AP 259 11/18/2012 Nov A/P First aid supplies 44.59 101.49 CINTAS FAS LOCKBOX 636525 31908 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 43.03 144.52 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 3.58 148.10 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: 148.10 148.10 ** 200.00 Budgeted 51.90 Remaining 74 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65005-020-000 Fuel & Lube 323 11/28/2012 October Gas Log 1,056.42 1,056.42 GL 393 11/30/2012 Nov Gas Purchases 852.32 1,908.74 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,908.74 1,908.74 ** 8,527.00 Budgeted 6,618.26 Remaining 22 % Used Account: 135-65010-020-000 Uniforms 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Richey 183.99 183.99 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Richey 174.24 358.23 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 132.00 490.23 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 490.23 490.23 ** 2,574.00 Budgeted 2,083.77 Remaining 19 % Used Account: 135-65030-020-000 Chemicals 303 11/27/2012 Nov A/P 12 100# Granular HTH Pails 6,248.30 1,680.00 7,928.30 HARCROS CHEMICALS INC 31954 AP 335 11/30/2012 Nov A/P Drum Clarifloc 540.00 8,468.30 POLYDYNE, INC 31973 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 2,220.00 8,468.30 ** 10,000.00 Budgeted 1,531.70 Remaining 85 % Used Account: 135-65035-020-000 Small Tools 259 11/18/2012 Nov A/P Tool Kits 20.00 20.00 TEXAS FACILITIES COMMISSION 31929 AP 259 11/18/2012 Nov A/P Tool Kits 50.00 70.00 TEXAS FACILITIES COMMISSION 31929 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 65.09 135.09 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-65035-020-000 Small Tools Totals: 135.09 135.09 ** 1,000.00 Budgeted 864.91 Remaining 14 % Used Account: 135-65040-020-000 Safety Equipment .00 .00 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-65045-020-000 Lab Supplies 335 11/30/2012 Nov A/P Water for lab 3,855.26 47.91 3,903.17 OZARKA DIRECT 31972 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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: 47.91 3,903.17 ** 10,000.00 Budgeted 6,096.83 Remaining 39 % Used Account: 135-69005-020-000 Capital Expenses .00 .00 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .00 .00 ** 241,200.00 Budgeted 241,200.00 Remaining 0 % Used Account: 135-69280-020-000 Capital Repairs .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 158,000.00 Budgeted 158,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 137,068.50 ** 1,039,428.00 Budgeted 902,359.50 Remaining 13 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/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 442 11/07/2012 Payroll 11/7/12 8,176.21 5,822.74 13,998.95 GL 443 11/21/2012 Payroll 11/21/12 5,626.88 19,625.83 GL 445 11/21/2012 MUD Longevity 11/21/12 3,817.50 23,443.33 GL 462 11/21/2012 Recode Longevity pay (3,817.50) 19,625.83 GL _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,449.62 19,625.83 ** 156,475.00 Budgeted 136,849.17 Remaining 13 % Used Account: 135-50010-021-000 Overtime 442 11/07/2012 Payroll 11/7/12 598.89 264.65 863.54 GL 442 11/07/2012 Payroll 11/7/12 160.00 1,023.54 GL 443 11/21/2012 Payroll 11/21/12 160.00 1,183.54 GL _______________ Account: 135-50010-021-000 Overtime Totals: 584.65 1,183.54 ** 7,297.00 Budgeted 6,113.46 Remaining 16 % Used Account: 135-50016-021-000 Longevity 462 11/21/2012 Recode Longevity pay 3,817.50 3,817.50 GL _______________ Account: 135-50016-021-000 Longevity Totals: 3,817.50 3,817.50 ** 3,818.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 442 11/07/2012 Payroll 11/7/12 150.00 150.00 300.00 GL _______________ Account: 135-50017-021-000 Certification Totals: 150.00 300.00 ** 1,800.00 Budgeted 1,500.00 Remaining 17 % Used Account: 135-50020-021-000 Retirement 442 11/07/2012 Payroll 11/7/12 1,697.63 884.13 2,581.76 GL 443 11/21/2012 Payroll 11/21/12 799.75 3,381.51 GL 445 11/21/2012 MUD Longevity 11/21/12 527.58 3,909.09 GL 335 11/30/2012 Nov A/P Retirement Employer Contributi 19,336.31 23,245.40 TCDRS 31974 AP _______________ Account: 135-50020-021-000 Retirement Totals: 21,547.77 23,245.40 ** 23,574.00 Budgeted 328.60 Remaining 99 % Used Account: 135-50026-021-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 442 11/07/2012 Payroll 11/7/12 1,683.08 841.54 2,524.62 GL 443 11/21/2012 Payroll 11/21/12 841.54 3,366.16 GL _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,683.08 3,366.16 ** 20,198.00 Budgeted 16,831.84 Remaining 17 % Used Account: 135-50027-021-000 Dental Insurance 442 11/07/2012 Payroll 11/7/12 124.48 62.24 186.72 GL 443 11/21/2012 Payroll 11/21/12 62.24 248.96 GL _______________ Account: 135-50027-021-000 Dental Insurance Totals: 124.48 248.96 ** 1,409.00 Budgeted 1,160.04 Remaining 18 % Used Account: 135-50028-021-000 Vision Insurance 442 11/07/2012 Payroll 11/7/12 29.72 14.86 44.58 GL 443 11/21/2012 Payroll 11/21/12 14.86 59.44 GL _______________ Account: 135-50028-021-000 Vision Insurance Totals: 29.72 59.44 ** 357.00 Budgeted 297.56 Remaining 17 % Used Account: 135-50029-021-000 Life Insurance & Other 442 11/07/2012 Payroll 11/7/12 119.34 119.34 GL 443 11/21/2012 Payroll 11/21/12 119.34 238.68 GL _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 238.68 238.68 ** 1,008.00 Budgeted 769.32 Remaining 24 % Used Account: 135-50030-021-000 Social Security Taxes 442 11/07/2012 Payroll 11/7/12 707.03 369.36 1,076.39 GL 443 11/21/2012 Payroll 11/21/12 331.50 1,407.89 GL 445 11/21/2012 MUD Longevity 11/21/12 236.69 1,644.58 GL _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 937.55 1,644.58 ** 10,502.00 Budgeted 8,857.42 Remaining 16 % Used Account: 135-50035-021-000 Medicare Taxes 442 11/07/2012 Payroll 11/7/12 165.35 86.38 251.73 GL 443 11/21/2012 Payroll 11/21/12 77.53 329.26 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 445 11/21/2012 MUD Longevity 11/21/12 165.35 55.35 384.61 GL _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 219.26 384.61 ** 2,456.00 Budgeted 2,071.39 Remaining 16 % Used Account: 135-50040-021-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 .00 ** 567.00 Budgeted 567.00 Remaining 0 % Used Account: 135-50045-021-000 Workman's Compensation 3,348.00 .00 3,348.00 _______________ Account: 135-50045-021-000 Workman's Compensation Totals: .00 3,348.00 ** 3,348.00 Budgeted .00 Remaining 100 % Used Account: 135-50070-021-000 Employee Relations 309 11/27/2012 Nov A/P 10/6-11/5 PCards/Slaght 16.78 16.78 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-50070-021-000 Employee Relations Totals: 16.78 16.78 ** 250.00 Budgeted 233.22 Remaining 7 % Used Account: 135-55005-021-000 Engineering 259 11/18/2012 Nov A/P Marshall Creek Sanitary Sewer 2,450.00 2,450.00 DELTATEK ENGINEERING 31910 AP _______________ Account: 135-55005-021-000 Engineering Totals: 2,450.00 2,450.00 ** 1,500.00 Budgeted (950.00) Remaining 163 % Used Account: 135-55080-021-000 Maintenance & Repairs 168.50 .00 168.50 _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: .00 168.50 ** 35,000.00 Budgeted 34,831.50 Remaining 0 % Used Account: 135-55090-021-000 Vehicle Maintenance .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/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 .00 ** 1,900.00 Budgeted 1,900.00 Remaining 0 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 259 11/18/2012 Nov A/P Oct Cells 217.50 217.50 VERIZON WIRELESS 31940 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 217.50 217.50 ** 3,500.00 Budgeted 3,282.50 Remaining 6 % Used Account: 135-60020-021-000 Electricity 259 11/18/2012 Nov A/P Electricity 9/28-10/29 332.87 276.31 609.18 TRI COUNTY ELECTRIC 31935 AP 259 11/18/2012 Nov A/P Electricity 9/28-10/29 154.25 763.43 TRI COUNTY ELECTRIC 31935 AP 259 11/18/2012 Nov A/P Electricity 9/28-10/29 27.74 791.17 TRI COUNTY ELECTRIC 31935 AP 259 11/18/2012 Nov A/P Electricity 10/10-11/12 654.81 1,445.98 HUDSON ENERGY 31919 AP 259 11/18/2012 Nov A/P Electricity 10/11-11/9 50.02 1,496.00 HUDSON ENERGY 31919 AP 303 11/27/2012 Nov A/P Electricity 10/12-11/12 192.65 1,688.65 HUDSON ENERGY 31955 AP _______________ Account: 135-60020-021-000 Electricity Totals: 1,355.78 1,688.65 ** 18,705.00 Budgeted 17,016.35 Remaining 9 % Used Account: 135-60070-021-000 Dues & Memberships 309 11/27/2012 Nov A/P 10/6-11/5 PCards/Slaght 111.00 111.00 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-60070-021-000 Dues & Memberships Totals: 111.00 111.00 ** 250.00 Budgeted 139.00 Remaining 44 % Used Account: 135-60080-021-000 Schools & Training 309 11/27/2012 Nov A/P 10/6-11/5 PCards/Slaght 90.00 240.00 330.00 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-60080-021-000 Schools & Training Totals: 240.00 330.00 ** 826.00 Budgeted 496.00 Remaining 40 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/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-021-000 Travel & per diem 442 11/07/2012 Payroll 11/7/12 19.43 67.71 87.14 GL _______________ Account: 135-60100-021-000 Travel & per diem Totals: 67.71 87.14 ** 450.00 Budgeted 362.86 Remaining 19 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 323 11/28/2012 October Gas Log 1,112.12 1,112.12 GL 393 11/30/2012 Nov Gas Purchases 722.69 1,834.81 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 1,834.81 1,834.81 ** 12,117.00 Budgeted 10,282.19 Remaining 15 % Used Account: 135-65010-021-000 Uniforms 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 507.22 507.22 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 307.86 815.08 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-65010-021-000 Uniforms Totals: 815.08 815.08 ** 2,220.00 Budgeted 1,404.92 Remaining 37 % Used Account: 135-65030-021-000 Chemicals .00 .00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65035-021-000 Small Tools 259 11/18/2012 Nov A/P Tool Kits 70.00 70.00 TEXAS FACILITIES COMMISSION 31929 AP _______________ Account: 135-65035-021-000 Small Tools Totals: 70.00 70.00 ** 1,500.00 Budgeted 1,430.00 Remaining 5 % Used Account: 135-65040-021-000 Safety Equipment .00 .00 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-69005-021-000 Capital Expenses .00 .00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 .00 ** 90,000.00 Budgeted 90,000.00 Remaining 0 % Used Account: 135-69008-021-000 Short Term Debt Payments .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt Payments Totals: .00 .00 ** 40,260.00 Budgeted 40,260.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 65,252.16 ** 459,887.00 Budgeted 394,634.84 Remaining 14 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/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 442 11/07/2012 Payroll 11/7/12 500.00 900.00 1,400.00 GL _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 900.00 1,400.00 ** 10,000.00 Budgeted 8,600.00 Remaining 14 % Used Account: 135-50030-026-000 Social Security Taxes 442 11/07/2012 Payroll 11/7/12 31.00 55.80 86.80 GL _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 55.80 86.80 ** 620.00 Budgeted 533.20 Remaining 14 % Used Account: 135-50035-026-000 Medicare Taxes 442 11/07/2012 Payroll 11/7/12 7.25 13.05 20.30 GL _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 13.05 20.30 ** 145.00 Budgeted 124.70 Remaining 14 % Used Account: 135-50040-026-000 Unemployment Taxes 442 11/07/2012 Payroll 11/7/12 14.50 26.10 40.60 GL _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 26.10 40.60 ** 210.00 Budgeted 169.40 Remaining 19 % Used Account: 135-50045-026-000 Workman's Compensation .00 .00 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/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-026-000 Dues & Memberships Totals: .00 .00 ** 2,100.00 Budgeted 2,100.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings 309 11/27/2012 Nov A/P 10/6-11/5 PCards/Slaght 22.00 44.00 66.00 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-60075-026-000 Meetings Totals: 44.00 66.00 ** 1,200.00 Budgeted 1,134.00 Remaining 6 % Used Account: 135-60080-026-000 Schools & Training 259 11/18/2012 Nov A/P AWBD Winter Conf-Sanders 265.00 265.00 AWBD 31906 AP 259 11/18/2012 Nov A/P AWBD Winter Conf-Carr 315.00 580.00 AWBD 31906 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 580.00 580.00 ** 4,000.00 Budgeted 3,420.00 Remaining 15 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 2,193.70 ** 26,575.00 Budgeted 24,381.30 Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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-030-000 Salaries & Wages 442 11/07/2012 Payroll 11/7/12 25,870.34 16,964.89 42,835.23 GL 443 11/21/2012 Payroll 11/21/12 16,898.06 59,733.29 GL 445 11/21/2012 MUD Longevity 11/21/12 2,317.50 62,050.79 GL 462 11/21/2012 Recode Longevity pay (2,317.50) 59,733.29 GL _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 33,862.95 59,733.29 ** 444,730.00 Budgeted 384,996.71 Remaining 13 % Used Account: 135-50010-030-000 Overtime 442 11/07/2012 Payroll 11/7/12 8.94 40.37 49.31 GL _______________ Account: 135-50010-030-000 Overtime Totals: 40.37 49.31 ** 1,500.00 Budgeted 1,450.69 Remaining 3 % Used Account: 135-50016-030-000 Longevity 462 11/21/2012 Recode Longevity pay 2,317.50 2,317.50 GL _______________ Account: 135-50016-030-000 Longevity Totals: 2,317.50 2,317.50 ** 2,193.00 Budgeted (124.50) Remaining 106 % Used Account: 135-50020-030-000 Retirement 442 11/07/2012 Payroll 11/7/12 4,525.48 2,275.44 6,800.92 GL 443 11/21/2012 Payroll 11/21/12 2,249.48 9,050.40 GL 445 11/21/2012 MUD Longevity 11/21/12 320.29 9,370.69 GL 335 11/30/2012 Nov A/P Retirement Employer Contributi 44,359.77 53,730.46 TCDRS 31974 AP _______________ Account: 135-50020-030-000 Retirement Totals: 49,204.98 53,730.46 ** 60,441.00 Budgeted 6,710.54 Remaining 89 % Used Account: 135-50026-030-000 Medical Insurance 442 11/07/2012 Payroll 11/7/12 3,185.30 1,592.65 4,777.95 GL 443 11/21/2012 Payroll 11/21/12 1,592.65 6,370.60 GL _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,185.30 6,370.60 ** 44,066.00 Budgeted 37,695.40 Remaining 14 % Used Account: 135-50027-030-000 Dental Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 442 11/07/2012 Payroll 11/7/12 288.72 144.36 433.08 GL 443 11/21/2012 Payroll 11/21/12 144.36 577.44 GL _______________ Account: 135-50027-030-000 Dental Insurance Totals: 288.72 577.44 ** 3,379.00 Budgeted 2,801.56 Remaining 17 % Used Account: 135-50028-030-000 Vision Insurance 442 11/07/2012 Payroll 11/7/12 66.20 33.10 99.30 GL 443 11/21/2012 Payroll 11/21/12 33.10 132.40 GL _______________ Account: 135-50028-030-000 Vision Insurance Totals: 66.20 132.40 ** 795.00 Budgeted 662.60 Remaining 17 % Used Account: 135-50029-030-000 Life Insurance & Other 442 11/07/2012 Payroll 11/7/12 292.46 292.46 GL 443 11/21/2012 Payroll 11/21/12 292.46 584.92 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 584.92 584.92 ** 2,500.00 Budgeted 1,915.08 Remaining 23 % Used Account: 135-50030-030-000 Social Security Taxes 442 11/07/2012 Payroll 11/7/12 1,937.42 970.27 2,907.69 GL 443 11/21/2012 Payroll 11/21/12 963.63 3,871.32 GL 445 11/21/2012 MUD Longevity 11/21/12 143.69 4,015.01 GL _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,077.59 4,015.01 ** 27,802.00 Budgeted 23,786.99 Remaining 14 % Used Account: 135-50035-030-000 Medicare Taxes 442 11/07/2012 Payroll 11/7/12 453.11 226.92 680.03 GL 443 11/21/2012 Payroll 11/21/12 225.36 905.39 GL 445 11/21/2012 MUD Longevity 11/21/12 33.60 938.99 GL _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 485.88 938.99 ** 6,502.00 Budgeted 5,563.01 Remaining 14 % Used Account: 135-50040-030-000 Unemployment Taxes 442 11/07/2012 Payroll 11/7/12 195.84 93.76 289.60 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 443 11/21/2012 Payroll 11/21/12 195.84 40.32 329.92 GL _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 134.08 329.92 ** 1,537.00 Budgeted 1,207.08 Remaining 21 % Used Account: 135-50045-030-000 Workman's Compensation 831.00 .00 831.00 _______________ Account: 135-50045-030-000 Workman's Compensation Totals: .00 831.00 ** 831.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 259 11/18/2012 Nov A/P Pre employment testing/T Sisk 35.00 4.00 39.00 FIRST CHECK APPLICANT SCREENIN 31914 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 4.00 39.00 ** 250.00 Budgeted 211.00 Remaining 16 % Used Account: 135-50070-030-000 Employee Relations .00 .00 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-55030-030-000 Software & Support 259 11/18/2012 Nov A/P Annual Support-Attendance Ente 2,961.75 1,176.50 4,138.25 ASSOC TIME & PARKING CONTROLS 31905 AP 259 11/18/2012 Nov A/P OSSI Apps 374.88 4,513.13 SUNGARD PUBLIC SECTOR INC 31926 AP 303 11/27/2012 Nov A/P Annual Maintenance-Fuel Master 1,152.38 5,665.51 SYN-TECH SYSTEMS, INC 31964 AP 303 11/27/2012 Nov A/P Badger annual maint 450.00 6,115.51 BADGER METER, INC 31948 AP 303 11/27/2012 Nov A/P Annual Firewall maint 1,095.00 7,210.51 ACCLAIM NETWORKS LLC 31944 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Gonzales 302.75 7,513.26 JPMORGAN CHASE BANK NA 31966 AP 387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 35.94 7,549.20 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 69.99 7,619.19 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 79.68 7,698.87 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 25.00 7,723.87 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 53.38 7,777.25 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 55.37 7,832.62 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P Annual backup maintenance 659.40 8,492.02 SHI GOVERNMENT SOLUTIONS,INC 31991 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 5,530.27 8,492.02 ** 63,555.00 Budgeted 55,062.98 Remaining 13 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55070-030-000 Independent Labor .00 .00 _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 .00 ** 2,700.00 Budgeted 2,700.00 Remaining 0 % Used Account: 135-55075-030-000 Records Management .00 .00 _______________ Account: 135-55075-030-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-030-000 Maintenance & Repairs 303 11/27/2012 Nov A/P Annual Service Fire extinguish 74.75 74.75 KIMBROUGH FIRE EXTINQUISHER CO 31956 AP 311 11/27/2012 Void Ck 31956/Reissue to Town Annual Service Fire extinguish (74.75) .00 KIMBROUGH FIRE EXTINQUISHER CO 31956 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-55100-030-000 Building Maint & Supplies 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 32.36 3.97 36.33 JPMORGAN CHASE BANK NA 31966 AP 387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 43.95 80.28 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P Zoned Duct work, Thermostat, T 1,428.00 1,508.28 NORTH TX HEATING & AIR, INC 31988 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 1,475.92 1,508.28 ** 5,000.00 Budgeted 3,491.72 Remaining 30 % Used Account: 135-55120-030-000 Cleaning Services 259 11/18/2012 Nov A/P Nov Janitorial Services 1,678.51 1,678.51 3,357.02 ABM JANITORIAL SERVICES, INC 31904 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards/Slaght 133.66 3,490.68 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,812.17 3,490.68 ** 20,200.00 Budgeted 16,709.32 Remaining 17 % Used Account: 135-55160-030-000 Professional Outside Services 259 11/18/2012 Nov A/P Website Development 1,875.00 1,875.00 FOUR MAN FURNACE, INC. 31915 AP 303 11/27/2012 Nov A/P Website 4,950.00 6,825.00 FOUR MAN FURNACE, INC. 31953 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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-030-000 Professional Outside Services Totals: 6,825.00 6,825.00 ** 15,000.00 Budgeted 8,175.00 Remaining 46 % Used Account: 135-55161-030-000 Outside Services-Town Semo .00 .00 _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 .00 ** 85,465.00 Budgeted 85,465.00 Remaining 0 % Used Account: 135-55165-030-000 Collection Fees 159.77 .00 159.77 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 159.77 ** .00 Budgeted (159.77) Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 303 11/27/2012 Nov A/P October Utility bills 648.53 648.53 DP2 BILLING SOLUTIONS, LLC 31952 AP 335 11/30/2012 Nov A/P Final bill/Printing & mailing 918.75 1,567.28 CSG SYSTEMS, INC. 31969 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,567.28 1,567.28 ** 11,000.00 Budgeted 9,432.72 Remaining 14 % Used Account: 135-60005-030-000 Telephone 387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 1,339.34 377.76 1,717.10 BANK OF AMERICA 31979 AP _______________ Account: 135-60005-030-000 Telephone Totals: 377.76 1,717.10 ** 9,000.00 Budgeted 7,282.90 Remaining 19 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 442 11/07/2012 Payroll 11/7/12 150.00 150.00 300.00 GL 259 11/18/2012 Nov A/P Oct Cells 177.04 477.04 VERIZON WIRELESS 31940 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 327.04 477.04 ** 3,575.00 Budgeted 3,097.96 Remaining 13 % Used Account: 135-60020-030-000 Electricity/Gas . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 259 11/18/2012 Nov A/P Electricity 942.99 942.99 DIRECT ENERGY BUSINESS SVCS 31912 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 942.99 942.99 ** 13,019.00 Budgeted 12,076.01 Remaining 7 % Used Account: 135-60025-030-000 Water 259 11/18/2012 Nov A/P Water/October 125.06 125.06 TROPHY CLUB MUD (WATER BILLS) 31936 AP _______________ Account: 135-60025-030-000 Water Totals: 125.06 125.06 ** 3,100.00 Budgeted 2,974.94 Remaining 4 % Used Account: 135-60030-030-000 Rent And/Or Usage 303 11/27/2012 Nov A/P October Public Services buildi 1,098.51 1,098.51 TOWN OF TROPHY CLUB 31965 AP 303 11/27/2012 Nov A/P November Public Services buili 1,098.51 2,197.02 TOWN OF TROPHY CLUB 31965 AP _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: 2,197.02 2,197.02 ** 13,182.00 Budgeted 10,984.98 Remaining 17 % Used Account: 135-60035-030-000 Postage 303 11/27/2012 Nov A/P Postage meter lease 652.66 157.50 810.16 PITNEY BOWES INC 31961 AP 303 11/27/2012 Nov A/P October Utility bills 1,761.03 2,571.19 DP2 BILLING SOLUTIONS, LLC 31952 AP 335 11/30/2012 Nov A/P Final bill/Printing & mailing 1,429.46 4,000.65 CSG SYSTEMS, INC. 31969 AP 387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 12.17 4,012.82 BANK OF AMERICA 31979 AP 289 11/30/2012 November postage used 397.44 4,410.26 GL _______________ Account: 135-60035-030-000 Postage Totals: 3,757.60 4,410.26 ** 23,000.00 Budgeted 18,589.74 Remaining 19 % Used Account: 135-60040-030-000 Service Charges & Fees 378 11/02/2012 Credit Card & Online fees 2,750.83 73.71 2,824.54 GL 378 11/02/2012 Credit Card & Online fees 75.10 2,899.64 GL 378 11/02/2012 Credit Card & Online fees 2,231.82 5,131.46 GL 452 11/13/2012 FF Account Analysis/Oct 250.00 5,381.46 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,630.63 5,381.46 ** 18,000.00 Budgeted 12,618.54 Remaining 30 % Used Account: 135-60050-030-000 Bad Debt Expense . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (1,056.53) .00 (1,056.53) _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 (1,056.53) ** 8,500.00 Budgeted 9,556.53 Remaining -12 % Used Account: 135-60055-030-000 Insurance 387 11/30/2012 Nov A/P Additional premium due to rera 34,065.48 26,536.44 60,601.92 TML INTERGOVERNMENTAL RISK 31992 AP _______________ Account: 135-60055-030-000 Insurance Totals: 26,536.44 60,601.92 ** 35,000.00 Budgeted (25,601.92) Remaining 173 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Gonzales 449.22 109.00 558.22 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 109.00 558.22 ** 750.00 Budgeted 191.78 Remaining 74 % Used Account: 135-60070-030-000 Dues & Memberships 259 11/18/2012 Nov A/P Annual Dues 100.00 550.00 650.00 AWBD 31906 AP 303 11/27/2012 Nov A/P Balance due Notary bonds 33.07 683.07 CNA SURETY 31950 AP 358 11/27/2012 Void A/P Ck 31950/CNA Surety Balance due Notary bonds (33.07) 650.00 CNA SURETY 31950 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 550.00 650.00 ** 2,400.00 Budgeted 1,750.00 Remaining 27 % Used Account: 135-60075-030-000 Meetings 88.00 .00 88.00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 88.00 ** 250.00 Budgeted 162.00 Remaining 35 % Used Account: 135-60080-030-000 Schools & Training 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 450.00 450.00 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-60080-030-000 Schools & Training Totals: 450.00 450.00 ** 5,500.00 Budgeted 5,050.00 Remaining 8 % Used Account: 135-60100-030-000 Travel & per diem . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 443 11/21/2012 Payroll 11/21/12 10.05 23.31 33.36 GL 309 11/27/2012 Nov A/P 10/6-11/5 PCards McKnight 16.24 49.60 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 39.55 49.60 ** 3,950.00 Budgeted 3,900.40 Remaining 1 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 321 11/28/2012 Recode 2010 Encana Accrual 13.00 109.13 122.13 GL _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 109.13 122.13 ** 15,000.00 Budgeted 14,877.87 Remaining 1 % Used Account: 135-60270-030-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,500.00 Budgeted 10,500.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 265.00 .00 265.00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 265.00 ** 2,500.00 Budgeted 2,235.00 Remaining 11 % Used Account: 135-65010-030-000 Uniforms 259 11/18/2012 Nov A/P Uniform shirts/Admin 624.12 624.12 RON MONTGOMERY & ASSOC INC 31924 AP _______________ Account: 135-65010-030-000 Uniforms Totals: 624.12 624.12 ** 1,635.00 Budgeted 1,010.88 Remaining 38 % Used Account: 135-65055-030-000 Hardware 303 11/27/2012 Nov A/P Projector lamp 5,738.89 160.50 5,899.39 SHI GOVERNMENT SOLUTIONS,INC 31963 AP 303 11/27/2012 Nov A/P USB drives 42.00 5,941.39 SHI GOVERNMENT SOLUTIONS,INC 31963 AP 387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 85.80 6,027.19 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor (111.37) 5,915.82 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor (74.25) 5,841.57 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 7.48 5,849.05 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 47.82 5,896.87 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 128.95 6,025.82 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 50.97 6,076.79 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 119.99 6,196.78 BANK OF AMERICA 31979 AP 387 11/30/2012 Nov A/P 2TB portable hard drive 91.49 6,288.27 NEWEGG.COM 31987 AP _______________ Account: 135-65055-030-000 Hardware Totals: 549.38 6,288.27 ** 20,188.00 Budgeted 13,899.73 Remaining 31 % Used Account: 135-65085-030-000 Office Supplies 259 11/18/2012 Nov A/P Postcards for leak report 816.15 402.75 1,218.90 DESKTOP PUBLISHING SUPPLIES 31911 AP 303 11/27/2012 Nov A/P Office Supplies 74.22 1,293.12 OFFICE DEPOT, INC 31960 AP 303 11/27/2012 Nov A/P Office Supplies 53.55 1,346.67 OFFICE DEPOT, INC 31960 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 53.94 1,400.61 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 316.50 1,717.11 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 52.12 1,769.23 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 2.93 1,772.16 JPMORGAN CHASE BANK NA 31966 AP 335 11/30/2012 Nov A/P Office Supplies 80.46 1,852.62 OFFICE DEPOT, INC 31971 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 1,036.47 1,852.62 ** 8,200.00 Budgeted 6,347.38 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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-65090-030-000 Printer Supplies & Maintenance 259 11/18/2012 Nov A/P Printer supplies 226.00 285.00 511.00 SHI GOVERNMENT SOLUTIONS,INC 31925 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 285.00 511.00 ** 5,732.00 Budgeted 5,221.00 Remaining 9 % Used Account: 135-65095-030-000 Maintenance Supplies 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Huggins 49.18 49.18 JPMORGAN CHASE BANK NA 31966 AP 309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 48.22 97.40 JPMORGAN CHASE BANK NA 31966 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 97.40 97.40 ** 2,000.00 Budgeted 1,902.60 Remaining 5 % Used Account: 135-65097-030-000 Vending Machine Supplies .00 .00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-65105-030-000 Printing 259 11/18/2012 Nov A/P Magnets 395.00 395.00 CRESTVIEW PRINTING INC 31909 AP _______________ Account: 135-65105-030-000 Printing Totals: 395.00 395.00 ** 5,200.00 Budgeted 4,805.00 Remaining 8 % Used Account: 135-69170-030-000 Copier Lease Installments 303 11/27/2012 Nov A/P Copier lease 256.85 256.85 513.70 KYOCERA MITA AMERICA, INC. 31957 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 513.70 ** 3,450.00 Budgeted 2,936.30 Remaining 15 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 26,911.00 Budgeted 26,911.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 30 Totals: ------------------------------------------------------------------------------------------------ 238,954.25 ** 1,051,838.00 Budgeted 812,883.75 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/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 259 11/18/2012 Nov A/P October legal 1,634.75 1,634.75 WHITAKER CHALK SWINDLE 31942 AP 259 11/18/2012 Nov A/P October legal 4,134.00 5,768.75 THE LISTON LAW FIRM, P.C. 31930 AP _______________ Account: 135-55045-039-000 Legal Totals: 5,768.75 5,768.75 ** 70,000.00 Budgeted 64,231.25 Remaining 8 % Used Account: 135-55055-039-000 Auditing 259 11/18/2012 Nov A/P Interim audit fieldwork 5,175.00 5,175.00 LAFOLLETT & COMPANY PLLC 31921 AP _______________ Account: 135-55055-039-000 Auditing Totals: 5,175.00 5,175.00 ** 21,200.00 Budgeted 16,025.00 Remaining 24 % Used Account: 135-55060-039-000 Appraisal 2,322.74 .00 2,322.74 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 2,322.74 ** 15,100.00 Budgeted 12,777.26 Remaining 15 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 3,800.00 Budgeted 3,800.00 Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 13,266.49 ** 110,100.00 Budgeted 96,833.51 Remaining 12 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 5,389.78 .00 Budgeted (5,389.78) Remaining 0 % Used Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 11/30/2012 ASSETS ASSETS CASH AND CASH IN BANK 6,120$ INVESTMENTS 149,017 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 196,040 TOTAL ASSETS 351,177$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 196,040$ TOTAL LIABILITIES 196,040 FUND BALANCE ASSIGNED FUND BALANCE 155,137 TOTAL LIABILITIES AND FUND BALANCE 351,177$ November 30, 2012 2/12 Months (16.66% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 13:23 12/13/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 196,940.00- 196,940.00- 10,542.13- 15,496.39- 7.869 181,443.61- 533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 990.78- 2,284.82- 58.585 1,615.18- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 566.35- 902.05- 17.980 4,114.95- Subtotal: 205,857.00- 205,857.00- 12,099.26- 18,683.26- 9.076 187,173.74- 533-48005-000-000 Reserve Funds/PID Utility Fees 345,000.00- 345,000.00- 345,000.00- Subtotal: 345,000.00- 345,000.00- 345,000.00- 533-49010-000-000 Interest Income 1,700.00- 1,700.00- 18.16- 36.70- 2.159 1,663.30- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- Subtotal: 309,700.00- 309,700.00- 18.16- 36.70- .012 309,663.30- Program number: 860,557.00- 860,557.00- 12,117.42- 18,719.96- 2.175 841,837.04- Department number: Revenues 860,557.00- 860,557.00- 12,117.42- 18,719.96- 2.175 841,837.04- Revenues Subtotal ----------- 860,557.00- 860,557.00- 12,117.42- 18,719.96- 2.175 841,837.04- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 13:23 12/13/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 11/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 4,000.00 533-70025-051-000 Bond Interest Expense 229,033.00 229,033.00 229,033.00 533-70035-051-000 Bond Principal Payment 605,000.00 605,000.00 605,000.00 Subtotal: 838,033.00 838,033.00 838,033.00 Program number: 838,033.00 838,033.00 838,033.00 Department number: Administration 838,033.00 838,033.00 838,033.00 Expenditures Subtotal ----------- 838,033.00 838,033.00 838,033.00 Fund number: 533 MUD 1 I&S CONSOLIDATED 22,524.00- 22,524.00- 12,117.42- 18,719.96- 83.111 3,804.04- ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 11/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 435 11/01/2012 Property Taxes/Assessments (4,954.26) (393.27) (5,347.53) GL 396 11/02/2012 Property Taxes/Assessments (260.94) (5,608.47) GL 398 11/05/2012 Property Taxes/Assessments (260.30) (5,868.77) GL 434 11/06/2012 Property Taxes/Assessments (224.58) (6,093.35) GL 400 11/07/2012 Property Taxes/Assessments (4,198.18) (10,291.53) GL 401 11/08/2012 Property Taxes/Assessments (52.95) (10,344.48) GL 403 11/09/2012 Property Taxes/Assessments (123.91) (10,468.39) GL 405 11/13/2012 Property Taxes/Assessments (358.32) (10,826.71) GL 409 11/14/2012 Property Taxes/Assessments (462.93) (11,289.64) GL 411 11/15/2012 Property Taxes/Assessments (642.03) (11,931.67) GL 413 11/16/2012 Property Taxes/Assessments (231.71) (12,163.38) GL 415 11/19/2012 Property Taxes/Assessments (568.78) (12,732.16) GL 417 11/20/2012 Property Taxes/Assessments (190.27) (12,922.43) GL 419 11/21/2012 Property Taxes/Assessments (513.36) (13,435.79) GL 428 11/26/2012 Property Taxes/Assessments (801.75) (14,237.54) GL 430 11/27/2012 Property Taxes/Assessments (481.87) (14,719.41) GL 431 11/28/2012 Property Taxes/Assessments (257.53) (14,976.94) GL 432 11/29/2012 Property Taxes/Assessments (173.69) (15,150.63) GL 433 11/30/2012 Property Taxes/Assessments (345.76) (15,496.39) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (10,542.13) (15,496.39) ** (196,940.00) Budgeted (181,443.61) Remaining 8 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 400 11/07/2012 Property Taxes/Assessments (1,294.04) 1,575.81 281.77 GL 417 11/20/2012 Property Taxes/Assessments (2,462.43) (2,180.66) GL 431 11/28/2012 Property Taxes/Assessments (104.16) (2,284.82) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (990.78) (2,284.82) ** (3,900.00) Budgeted (1,615.18) Remaining 59 % Used Account: 533-40015-000-000 Property Taxes/P & I 417 11/20/2012 Property Taxes/Assessments (335.70) (566.36) (902.06) GL 431 11/28/2012 Property Taxes/Assessments .01 (902.05) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (566.35) (902.05) ** (5,017.00) Budgeted (4,114.95) Remaining 18 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 11/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: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (345,000.00) Budgeted (345,000.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 377 11/30/2012 Nov Bank Interest (18.54) (18.16) (36.70) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (18.16) (36.70) ** (1,700.00) Budgeted (1,663.30) Remaining 2 % 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: ------------------------------------------------------------------------------------------------ (18,719.96) ** (860,557.00) Budgeted (841,837.04) Remaining 2 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 58 13:23 12/13/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 11/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 ** 229,033.00 Budgeted 229,033.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 ** 605,000.00 Budgeted 605,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 838,033.00 Budgeted 838,033.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (18,719.96) (22,524.00) Budgeted (3,804.04) Remaining 83 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 3,546.93 **** (22,524.00) Budgeted (26,070.93) Remaining -16 % Used ******* End of Report *********