Loading...
HomeMy WebLinkAboutDecember 2012 MUD Financials Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 12/31/2012 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 858,616 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 563,980 ACCOUNTS RECEIVABLE - PID EMER SERVICES 73,597 OTHER RECEIVABLES 24,351 TOTAL ASSETS 1,520,544$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 637,577$ ACCOUNTS PAYABLE 30,078 TOTAL LIABILITIES 667,655$ FUND BALANCE UNASSIGNED FUND BALANCE 852,889 TOTAL LIABILITIES AND FUND BALANCE 1,520,544$ December 31, 2012 3/12 Months (25% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 14:37 01/10/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/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- 162,194.35- 179,263.15- 71.112 72,820.85- 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- 428,488.43- 511,136.40- 48.663 539,212.60- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 509.78- 4,105.64- 70.787 1,694.36- 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- 129.40- 1,572.10- 34.936 2,927.90- Subtotal: 1,318,183.00- 1,318,183.00- 591,321.96- 696,083.73- 52.806 622,099.27- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 800.00- 13.333 5,200.00- Subtotal: 6,000.00- 6,000.00- 400.00- 800.00- 13.333 5,200.00- 122-43400-000-000 Fire Inspections 500.00- 500.00- 75.00- 150.00- 30.000 350.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- 150.00- 1.429 10,350.00- 122-49900-000-000 Miscellaneous Income 1,200.00- 1,200.00- 939.26- 1,464.26- 122.022 264.26 Subtotal: 1,200.00- 1,200.00- 939.26- 1,464.26- 122.022 264.26 Program number: 1,335,883.00- 1,335,883.00- 592,736.22- 698,497.99- 52.287 637,385.01- Department number: Fire Revenues 1,335,883.00- 1,335,883.00- 592,736.22- 698,497.99- 52.287 637,385.01- Revenues Subtotal ----------- 1,335,883.00- 1,335,883.00- 592,736.22- 698,497.99- 52.287 637,385.01- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 14:37 01/10/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 31,094.52 92,395.68 20.776 352,321.32 122-50010-045-000 Overtime 31,375.00 31,375.00 2,526.63 10,436.92 33.265 20,938.08 122-50011-045-000 DPS Holiday Pay 13,083.00 13,083.00 12,080.51 12,080.51 92.337 1,002.49 122-50016-045-000 Longevity 4,266.00 4,266.00 4,266.11 4,266.11 100.003 .11- 122-50017-045-000 Certification 4,896.00 4,896.00 575.00 1,725.00 35.233 3,171.00 122-50020-045-000 Retirement 69,242.00 69,242.00 6,918.35 17,948.34 25.921 51,293.66 122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,336.47 10,009.39 20.712 38,317.61 122-50027-045-000 Dental Insurance 3,635.00 3,635.00 311.98 935.87 25.746 2,699.13 122-50028-045-000 Vision Insurance 824.00 824.00 64.09 192.31 23.339 631.69 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 585.14 1,170.28 27.536 3,079.72 122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 2,942.86 7,653.17 24.770 23,243.83 122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 688.24 1,789.84 24.769 5,436.16 122-50040-045-000 Unemployment Taxes 1,481.00 1,481.00 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 150.45 150.45 22.289 524.55 122-50075-045-000 Tuition Reimbursement 1,500.00 1,500.00 1,500.00 Subtotal: 676,394.00 676,394.00 65,540.35 170,792.29 25.250 505,601.71 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 680.14 1,134.40 11.864 8,427.60 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 2,306.28 1,855.43 12.494 12,994.57 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 331.57 692.50 10.654 5,807.50 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 3,317.99 3,682.33 8.308 40,640.67 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.64 1,824.52 72.981 675.48 122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 1,341.21 2,199.82 35.671 3,967.18 122-60025-045-000 Water 1,400.00 1,400.00 164.26 459.04 32.789 940.96 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.35 54.60 54.600 45.40 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 400.00 7,405.91 98.745 94.09 122-60075-045-000 Meetings 75.00 75.00 75.00 122-60080-045-000 Schools & Training 5,000.00 5,000.00 325.00 855.00 17.100 4,145.00 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 4,800.00 4,800.00 237.60 812.19 16.921 3,987.81 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 2,198.94 52.356 2,001.06 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 14:37 01/10/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 360.00 513.73 27.038 1,386.27 122-60195-045-000 Flags & Repair 2,543.00 2,543.00 75.00 224.75 8.838 2,318.25 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 408.78 451.98 36.538 785.02 Subtotal: 359,088.00 359,088.00 3,555.84 18,185.84 5.064 340,902.16 122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 718.50 2,600.52 26.005 7,399.48 122-65010-045-000 Uniforms 4,357.00 4,357.00 8.50 291.75 6.696 4,065.25 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 230.88 230.88 4.618 4,769.12 122-65085-045-000 Office Supplies 1,200.00 1,200.00 20.71 1.726 1,179.29 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 94.32 300.94 10.806 2,484.06 122-65105-045-000 Printing 106.00 106.00 106.00 Subtotal: 32,048.00 32,048.00 1,052.20 3,444.80 10.749 28,603.20 122-69006-045-000 Grant Match 3,000.00 3,000.00 3,000.00 122-69008-045-000 Short Term Debt-Principal 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 73,466.38 196,105.26 14.680 1,139,777.74 Department number: Fire 1,335,883.00 1,335,883.00 73,466.38 196,105.26 14.680 1,139,777.74 Expenditures Subtotal ----------- 1,335,883.00 1,335,883.00 73,466.38 196,105.26 14.680 1,139,777.74 Fund number: 122 Trophy Club MUD Fire Dept. 519,269.84- 502,392.73- 502,392.73 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/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 559 12/03/2012 Property Taxes & Assessments (17,068.80) (2,287.40) (19,356.20) GL 560 12/04/2012 Property Taxes & Assessments (1,051.01) (20,407.21) GL 561 12/05/2012 Property Taxes & Assessments (1,831.10) (22,238.31) GL 562 12/06/2012 Property Taxes & Assessments (937.61) (23,175.92) GL 563 12/07/2012 Property Taxes & Assessments (1,823.70) (24,999.62) GL 564 12/10/2012 Property Taxes & Assessments (1,482.87) (26,482.49) GL 565 12/11/2012 Property Taxes & Assessments (1,232.92) (27,715.41) GL 566 12/12/2012 Property Taxes & Assessments (467.06) (28,182.47) GL 567 12/13/2012 Property Taxes & Assessments (125.29) (28,307.76) GL 568 12/14/2012 Property Taxes/Assessments (1,214.42) (29,522.18) GL 569 12/17/2012 Property Taxes/Assessments (453.81) (29,975.99) GL 570 12/18/2012 Property Taxes/Assessments (2,826.39) (32,802.38) GL 571 12/19/2012 Property Taxes/Assessments (15,440.85) (48,243.23) GL 572 12/20/2012 Property Taxes/Assessments (929.57) (49,172.80) GL 573 12/21/2012 Property Taxes/Assessments (3,967.31) (53,140.11) GL 574 12/27/2012 Property Taxes/Assessments (62,576.01) (115,716.12) GL 575 12/29/2012 Property Taxes/Assessments (4,599.89) (120,316.01) GL 576 12/31/2012 Property Taxes/Assessments (58,947.14) (179,263.15) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (162,194.35) (179,263.15) ** (252,084.00) Budgeted (72,820.85) Remaining 71 % 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 559 12/03/2012 Property Taxes & Assessments (82,647.97) (4,982.27) (87,630.24) GL 560 12/04/2012 Property Taxes & Assessments (3,688.92) (91,319.16) GL 561 12/05/2012 Property Taxes & Assessments (3,638.49) (94,957.65) GL 562 12/06/2012 Property Taxes & Assessments (2,993.39) (97,951.04) GL 563 12/07/2012 Property Taxes & Assessments (5,124.43) (103,075.47) GL 564 12/10/2012 Property Taxes & Assessments (4,966.61) (108,042.08) GL 565 12/11/2012 Property Taxes & Assessments (3,381.68) (111,423.76) GL 566 12/12/2012 Property Taxes & Assessments (2,016.90) (113,440.66) GL 567 12/13/2012 Property Taxes & Assessments (4,626.19) (118,066.85) GL 568 12/14/2012 Property Taxes/Assessments (2,743.80) (120,810.65) GL 569 12/17/2012 Property Taxes/Assessments (5,997.96) (126,808.61) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 570 12/18/2012 Property Taxes/Assessments (82,647.97) (10,204.56) (137,013.17) GL 571 12/19/2012 Property Taxes/Assessments (66,103.88) (203,117.05) GL 572 12/20/2012 Property Taxes/Assessments (5,088.66) (208,205.71) GL 573 12/21/2012 Property Taxes/Assessments (9,686.95) (217,892.66) GL 574 12/27/2012 Property Taxes/Assessments (117,998.59) (335,891.25) GL 575 12/29/2012 Property Taxes/Assessments (28,907.98) (364,799.23) GL 576 12/31/2012 Property Taxes/Assessments (146,337.17) (511,136.40) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (428,488.43) (511,136.40) ** (1,050,349.00) Budgeted (539,212.60) Remaining 49 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 561 12/05/2012 Property Taxes & Assessments (3,595.86) (88.49) (3,684.35) GL 572 12/20/2012 Property Taxes/Assessments (426.76) (4,111.11) GL 576 12/31/2012 Property Taxes/Assessments 5.47 (4,105.64) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (509.78) (4,105.64) ** (5,800.00) Budgeted (1,694.36) Remaining 71 % 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 561 12/05/2012 Property Taxes & Assessments (1,442.70) (31.25) (1,473.95) GL 572 12/20/2012 Property Taxes/Assessments (98.15) (1,572.10) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (129.40) (1,572.10) ** (4,500.00) Budgeted (2,927.90) Remaining 35 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 592 12/12/2012 Permits 12/12/12 (400.00) (400.00) (800.00) GL _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (800.00) ** (6,000.00) Budgeted (5,200.00) Remaining 13 % Used Account: 122-43400-000-000 Fire Inspections . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 592 12/12/2012 Permits 12/12/12 (75.00) (75.00) (150.00) GL _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (150.00) ** (500.00) Budgeted (350.00) Remaining 30 % 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 592 12/12/2012 Permits 12/12/12 (525.00) (525.00) (1,050.00) GL 589 12/31/2012 Clear 2010 P/R Liabilities (414.26) (1,464.26) GL _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (939.26) (1,464.26) ** (1,200.00) Budgeted 264.26 Remaining 122 % Used Department Totals: ------------------------------------------------------------------------------------------------ (698,497.99) ** (1,335,883.00) Budgeted (637,385.01) Remaining 52 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 609 12/07/2012 12/7/12 Payroll 61,301.16 15,512.11 76,813.27 GL 615 12/21/2012 12/21/12 Payroll 15,582.41 92,395.68 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 31,094.52 92,395.68 ** 444,717.00 Budgeted 352,321.32 Remaining 21 % Used Account: 122-50010-045-000 Overtime 615 12/21/2012 12/21/12 Payroll 7,910.29 2,526.63 10,436.92 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,526.63 10,436.92 ** 31,375.00 Budgeted 20,938.08 Remaining 33 % Used Account: 122-50011-045-000 DPS Holiday Pay 607 12/07/2012 Fire Holiday Pay 12,080.51 12,080.51 GL _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: 12,080.51 12,080.51 ** 13,083.00 Budgeted 1,002.49 Remaining 92 % Used Account: 122-50016-045-000 Longevity 610 12/13/2012 12/13/12 Fire Longevity 4,187.06 4,187.06 GL 614 12/19/2012 Fire Longevity Supplemental PR 79.05 4,266.11 GL _______________ Account: 122-50016-045-000 Longevity Totals: 4,266.11 4,266.11 ** 4,266.00 Budgeted (.11) Remaining 100 % Used Account: 122-50017-045-000 Certification 609 12/07/2012 12/7/12 Payroll 1,150.00 575.00 1,725.00 GL _______________ Account: 122-50017-045-000 Certification Totals: 575.00 1,725.00 ** 4,896.00 Budgeted 3,171.00 Remaining 35 % Used Account: 122-50020-045-000 Retirement 607 12/07/2012 Fire Holiday Pay 11,029.99 1,669.52 12,699.51 GL 609 12/07/2012 12/7/12 Payroll 2,178.82 14,878.33 GL 610 12/13/2012 12/13/12 Fire Longevity 578.65 15,456.98 GL 614 12/19/2012 Fire Longevity Supplemental PR 10.92 15,467.90 GL 615 12/21/2012 12/21/12 Payroll 2,480.44 17,948.34 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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-50020-045-000 Retirement Totals: 6,918.35 17,948.34 ** 69,242.00 Budgeted 51,293.66 Remaining 26 % Used Account: 122-50026-045-000 Medical Insurance 609 12/07/2012 12/7/12 Payroll 6,672.92 1,668.23 8,341.15 GL 615 12/21/2012 12/21/12 Payroll 1,668.24 10,009.39 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,336.47 10,009.39 ** 48,327.00 Budgeted 38,317.61 Remaining 21 % Used Account: 122-50027-045-000 Dental Insurance 609 12/07/2012 12/7/12 Payroll 623.89 155.98 779.87 GL 615 12/21/2012 12/21/12 Payroll 156.00 935.87 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 311.98 935.87 ** 3,635.00 Budgeted 2,699.13 Remaining 26 % Used Account: 122-50028-045-000 Vision Insurance 609 12/07/2012 12/7/12 Payroll 128.22 32.05 160.27 GL 615 12/21/2012 12/21/12 Payroll 32.04 192.31 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 64.09 192.31 ** 824.00 Budgeted 631.69 Remaining 23 % Used Account: 122-50029-045-000 Life Insurance & Other 609 12/07/2012 12/7/12 Payroll 585.14 292.58 877.72 GL 615 12/21/2012 12/21/12 Payroll 292.56 1,170.28 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 585.14 1,170.28 ** 4,250.00 Budgeted 3,079.72 Remaining 28 % Used Account: 122-50030-045-000 Social Security Taxes 607 12/07/2012 Fire Holiday Pay 4,710.31 748.98 5,459.29 GL 609 12/07/2012 12/7/12 Payroll 902.00 6,361.29 GL 610 12/13/2012 12/13/12 Fire Longevity 259.60 6,620.89 GL 614 12/19/2012 Fire Longevity Supplemental PR 4.90 6,625.79 GL 615 12/21/2012 12/21/12 Payroll 1,027.38 7,653.17 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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-50030-045-000 Social Security Taxes Totals: 2,942.86 7,653.17 ** 30,897.00 Budgeted 23,243.83 Remaining 25 % Used Account: 122-50035-045-000 Medicare Taxes 607 12/07/2012 Fire Holiday Pay 1,101.60 175.16 1,276.76 GL 609 12/07/2012 12/7/12 Payroll 210.95 1,487.71 GL 610 12/13/2012 12/13/12 Fire Longevity 60.71 1,548.42 GL 614 12/19/2012 Fire Longevity Supplemental PR 1.15 1,549.57 GL 615 12/21/2012 12/21/12 Payroll 240.27 1,789.84 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 688.24 1,789.84 ** 7,226.00 Budgeted 5,436.16 Remaining 25 % Used Account: 122-50040-045-000 Unemployment Taxes 38.42 .00 38.42 _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: .00 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 479 12/18/2012 Dec A/P C Conditt 114.75 114.75 MARY A CONNELL, ED.D., ABPP 32009 AP 479 12/18/2012 Dec A/P C Conditt 35.70 150.45 CARENOW CORPORATE 32000 AP _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: 150.45 150.45 ** 675.00 Budgeted 524.55 Remaining 22 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 550 12/05/2012 Dec A/P 10/6-11/5 PCards Hurd 454.26 34.63 488.89 JPMORGAN CHASE BANK NA 32029 AP 555 12/31/2012 Dec A/P Annual Maint for Cascade Syste 599.15 1,088.04 AUGUST INDUSTRIES, INC 32036 AP 555 12/31/2012 Dec A/P Rug Service 23.18 1,111.22 G & K SERVICES 32057 AP 555 12/31/2012 Dec A/P Rug service 23.18 1,134.40 G & K SERVICES 32057 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 680.14 1,134.40 ** 9,562.00 Budgeted 8,427.60 Remaining 12 % Used Account: 122-55090-045-000 Vehicle Maintenance 550 12/05/2012 Dec A/P 11/6-12/5 PCards Beck (450.85) 5.68 (445.17) JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 10/6-11/5 PCards Hurd 35.80 (409.37) JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 10/6-11/5 PCards Hurd 84.80 (324.57) JPMORGAN CHASE BANK NA 32029 AP 555 12/31/2012 Dec A/P Alternator and regulator 2,180.00 1,855.43 Alternator Service, Inc. 32031 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 2,306.28 1,855.43 ** 14,850.00 Budgeted 12,994.57 Remaining 12 % 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 550 12/05/2012 Dec A/P 10/6-11/5 PCards Thomas 360.93 26.06 386.99 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 10/6-11/5 PCards Thomas 157.83 544.82 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 10/6-11/5 PCards Thomas 267.68 812.50 JPMORGAN CHASE BANK NA 32029 AP 499 12/06/2012 Firefighters Cable/Dec (120.00) 692.50 GL _______________ Account: 122-55100-045-000 Building Maintenance Totals: 331.57 692.50 ** 6,500.00 Budgeted 5,807.50 Remaining 11 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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-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 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 609 12/07/2012 12/7/12 Payroll 1,607.88 76.50 1,684.38 GL 555 12/31/2012 Dec A/P Cell phones 140.14 1,824.52 VERIZON WIRELESS 32110 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 216.64 1,824.52 ** 2,500.00 Budgeted 675.48 Remaining 73 % Used Account: 122-60020-045-000 Electricity/Gas 472 12/18/2012 Dec A/P Balance due/Fire Station elect 858.61 430.14 1,288.75 HUDSON ENERGY 31996 AP 555 12/31/2012 Dec A/P Gas/Fire Station 100.62 1,389.37 ATMOS ENERGY 32035 AP 555 12/31/2012 Dec A/P Electricity 11/12-12/13/12 1,228.06 2,617.43 HUDSON ENERGY 32064 AP 577 12/31/2012 Town permits,gas,water,elec Fire Sta Electricity Oct-Nov (417.61) 2,199.82 GL _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 1,341.21 2,199.82 ** 6,167.00 Budgeted 3,967.18 Remaining 36 % Used Account: 122-60025-045-000 Water 479 12/18/2012 Dec A/P Nov Water 294.78 105.79 400.57 TROPHY CLUB MUD (WATER BILLS) 32025 AP 555 12/31/2012 Dec A/P Dec Water 6.36 406.93 TROPHY CLUB MUD (WATER BILLS) 32108 AP 555 12/31/2012 Dec A/P Dec Water 52.11 459.04 TROPHY CLUB MUD (WATER BILLS) 32108 AP _______________ Account: 122-60025-045-000 Water Totals: 164.26 459.04 ** 1,400.00 Budgeted 940.96 Remaining 33 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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-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 479 12/18/2012 Dec A/P Overnight shipments 27.25 27.35 54.60 FEDERAL EXPRESS CORP 32006 AP _______________ Account: 122-60035-045-000 Postage Totals: 27.35 54.60 ** 100.00 Budgeted 45.40 Remaining 55 % Used Account: 122-60055-045-000 Insurance 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 550 12/05/2012 Dec A/P 10/6-11/5 PCards Thomas 7,005.91 165.00 7,170.91 JPMORGAN CHASE BANK NA 32029 AP 479 12/18/2012 Dec A/P Incident Safety Officer Cert/H 85.00 7,255.91 TX COMM ON FIRE PROTECTION 32026 AP 555 12/31/2012 Dec A/P Dues & Memberships/2013 150.00 7,405.91 TX FIRE CHIEFS ASSOCIATION 32109 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 400.00 7,405.91 ** 7,500.00 Budgeted 94.09 Remaining 99 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 550 12/05/2012 Dec A/P 10/6-11/5 PCards Thomas 530.00 325.00 855.00 JPMORGAN CHASE BANK NA 32029 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 325.00 855.00 ** 5,000.00 Budgeted 4,145.00 Remaining 17 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem 550 12/05/2012 Dec A/P 11/6-12/5 PCards Sipes 574.59 237.60 812.19 JPMORGAN CHASE BANK NA 32029 AP _______________ Account: 122-60100-045-000 Travel & per diem Totals: 237.60 812.19 ** 4,800.00 Budgeted 3,987.81 Remaining 17 % 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 2,198.94 .00 2,198.94 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 2,198.94 ** 4,200.00 Budgeted 2,001.06 Remaining 52 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 479 12/18/2012 Dec A/P Fire Marshal Enforcement 153.73 180.00 333.73 THE PRODUCTIVITY CENTER 32021 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 555 12/31/2012 Dec A/P TCLEDDS Subscription renewal 153.73 180.00 513.73 THE PRODUCTIVITY CENTER 32106 AP _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 360.00 513.73 ** 1,900.00 Budgeted 1,386.27 Remaining 27 % Used Account: 122-60195-045-000 Flags & Repair 479 12/18/2012 Dec A/P Flag Repair/Nextel Tower 149.75 75.00 224.75 SYMONDS FLAGS & POLES 32016 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 75.00 224.75 ** 2,543.00 Budgeted 2,318.25 Remaining 9 % Used Account: 122-60245-045-000 Miscellaneous Expense 550 12/05/2012 Dec A/P 10/6-11/5 PCards Hurd 43.20 58.78 101.98 JPMORGAN CHASE BANK NA 32029 AP 555 12/31/2012 Dec A/P Cowboy Catering/Fire station B 350.00 451.98 ROBERT C CLOUD 32096 AP _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: 408.78 451.98 ** 1,237.00 Budgeted 785.02 Remaining 37 % Used Account: 122-65005-045-000 Fuel & Lube 620 12/31/2012 December Gas Log 1,882.02 718.50 2,600.52 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 718.50 2,600.52 ** 10,000.00 Budgeted 7,399.48 Remaining 26 % Used Account: 122-65010-045-000 Uniforms 479 12/18/2012 Dec A/P New hire uniform 283.25 8.50 291.75 GST PUBLIC SAFETY SUPPLY 32007 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 8.50 291.75 ** 4,357.00 Budgeted 4,065.25 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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-65030-045-000 Chemicals Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 555 12/31/2012 Dec A/P SCBA mask for E Sampson 230.88 230.88 MUNICIPAL EMERGENCY SERVICES 32084 AP _______________ Account: 122-65035-045-000 Small Tools Totals: 230.88 230.88 ** 5,000.00 Budgeted 4,769.12 Remaining 5 % Used Account: 122-65085-045-000 Office Supplies 20.71 .00 20.71 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 20.71 ** 1,200.00 Budgeted 1,179.29 Remaining 2 % Used Account: 122-65095-045-000 Maintenance Supplies 555 12/31/2012 Dec A/P 11/6-12/5 PCards-Schultz 206.62 81.36 287.98 JPMORGAN CHASE BANK NA 32065 AP 555 12/31/2012 Dec A/P 11/6-12/5 PCards-Schultz 12.96 300.94 JPMORGAN CHASE BANK NA 32065 AP _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 94.32 300.94 ** 2,785.00 Budgeted 2,484.06 Remaining 11 % 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-Principal . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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-69008-045-000 Short Term Debt-Principal Totals: .00 .00 ** 72,932.00 Budgeted 72,932.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 145,598.00 Budgeted 145,598.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 196,105.26 ** 1,335,883.00 Budgeted 1,139,777.74 Remaining 15 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (502,392.73) .00 Budgeted 502,392.73 Remaining 0 % Used Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 12/31/2012 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 531,662 INVESTMENTS 2,897,114 RESTRICTED ASSETS: INVESTMENTS 428,116 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 54,150 UTILITY AND OTHER ACCOUNTS RECEIVABLE 537,834 TOTAL ASSETS 4,449,276$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 54,150$ ACCOUNTS PAYABLE 558,688 CUSTOMER DEPOSITS 213,867 TOTAL LIABILITIES 826,705 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,850,787 TOTAL FUND BALANCE 3,622,571 TOTAL LIABILITIES AND FUND BALANCE 4,449,276$ December 31, 2012 3/12 Months (25% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 14:37 01/10/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/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- 40,747.59- 48,607.07- 48.664 51,276.93- 135-40002-000-000 Property Taxes/Delinquent 500.00- 500.00- 52.90- 712.43- 142.486 212.43 135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 43.11- 493.20- 41.100 706.80- Subtotal: 101,584.00- 101,584.00- 40,843.60- 49,812.70- 49.036 51,771.30- 135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 200,100.49- 753,170.45- 21.242 2,792,438.55- 135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 132,583.22- 415,365.61- 25.117 1,238,381.39- 135-47020-000-000 Standby 576.00- 576.00- 48.00- 149.90- 26.024 426.10- 135-47025-000-000 Penalties 64,580.00- 64,580.00- 4,789.46- 15,999.95- 24.775 48,580.05- 135-47030-000-000 Service Charges 11,625.00- 11,625.00- 1,303.00- 3,084.00- 26.529 8,541.00- 135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 100.00- 100.00- 5.556 1,700.00- 135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 300.00- 750.00- 14.423 4,450.00- 135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 5,785.00- 10,667.15- 13.751 66,907.85- 135-47400-000-000 Water-Out of Dist/Port Meters 12.71- 12.71- 12.71 Subtotal: 5,360,712.00- 5,360,712.00- 345,021.88- 1,199,299.77- 22.372 4,161,412.23- 135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 28,000.00- 99,300.00- 15.419 544,700.00- Subtotal: 644,000.00- 644,000.00- 28,000.00- 99,300.00- 15.419 544,700.00- 135-49010-000-000 Interest Income 5,500.00- 5,500.00- 534.07- 1,655.35- 30.097 3,844.65- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 2,668.06- 26.250 7,495.94- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,749.99- 25.000 5,250.01- 135-49030-000-000 Vending Revenue 350.00- 350.00- 14.08- 32.84- 9.383 317.16- 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,238.00- 14,458.00- 19.805 58,542.00- 135-49900-000-000 Miscellaneous Income 1,000.00- 1,000.00- 1,086.03- 2,792.09- 279.209 1,792.09 135-49901-000-000 Records Management Revenue 109.00- 109.00- 109.00 135-49905-000-000 Gas Well Revenue 200.00- 200.00- 153.97- 153.97- 76.985 46.03- Subtotal: 402,962.00- 402,962.00- 7,629.01- 23,619.30- 5.861 379,342.70- Program number: 6,509,258.00- 6,509,258.00- 421,494.49- 1,372,031.77- 21.078 5,137,226.23- Department number: Revenues 6,509,258.00- 6,509,258.00- 421,494.49- 1,372,031.77- 21.078 5,137,226.23- Revenues Subtotal ----------- 6,509,258.00- 6,509,258.00- 421,494.49- 1,372,031.77- 21.078 5,137,226.23- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 14:37 01/10/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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 12,879.11 35,169.12 16.486 178,151.88 135-50010-010-000 Overtime 13,250.00 13,250.00 969.28 4,393.87 33.161 8,856.13 135-50016-010-000 Longevity 3,080.00 3,080.00 3,080.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 300.00 900.00 17.647 4,200.00 135-50020-010-000 Retirement 32,725.00 32,725.00 1,955.31 31,641.11 96.688 1,083.89 135-50026-010-000 Medical Insurance 28,920.00 28,920.00 1,683.92 5,051.76 17.468 23,868.24 135-50027-010-000 Dental Insurance 2,091.00 2,091.00 132.78 398.34 19.050 1,692.66 135-50028-010-000 Vision Insurance 519.00 519.00 31.76 95.28 18.358 423.72 135-50029-010-000 Life Insurance & Other 1,204.00 1,204.00 286.80 573.60 47.641 630.40 135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 853.85 2,898.77 19.916 11,656.23 135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 199.69 677.94 19.916 2,726.06 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 19,292.50 90,988.79 27.930 234,784.21 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 10,009.23 20.018 39,990.77 135-55090-010-000 Vehicle Maintenance 3,700.00 3,700.00 107.22 566.61 15.314 3,133.39 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 220.24 1,767.04 60.932 1,132.96 135-55135-010-000 Lab Analysis 4,500.00 4,500.00 510.00 1,635.15 36.337 2,864.85 Subtotal: 64,100.00 64,100.00 837.46 13,978.03 21.807 50,121.97 135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 176.42 352.21 17.611 1,647.79 135-60020-010-000 Electricity 162,410.00 162,410.00 8,832.04 24,047.10 14.806 138,362.90 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 111.00 351.00 20.993 1,321.00 135-60090-010-000 Safety Program 500.00 500.00 500.00 135-60100-010-000 Travel & per diem 700.00 700.00 70.49 459.00 65.571 241.00 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 22.831 27,626.55 135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 141,040.87 303,957.46 14.985 1,724,489.54 135-60245-010-000 Miscellaneous Expenses 500.00 500.00 500.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 135.50 348.70 8.302 3,851.30 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 38.99 38.99 2.599 1,461.01 Subtotal: 2,239,129.00 2,239,129.00 150,405.31 337,727.91 15.083 1,901,401.09 135-65005-010-000 Fuel & Lube 17,661.00 17,661.00 1,006.95 2,925.49 16.565 14,735.51 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 14:37 01/10/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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 379.96 1,100.08 41.048 1,579.92 135-65030-010-000 Chemicals 6,200.00 6,200.00 251.98 971.61 15.671 5,228.39 135-65035-010-000 Small Tools 1,500.00 1,500.00 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 65.308 49,800.00 Subtotal: 173,591.00 173,591.00 1,638.89 99,014.37 57.039 74,576.63 135-69005-010-000 Capital Expenses 181,800.00 181,800.00 181,800.00 135-69008-010-000 Short Term Debt-Principal 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 22.174 210,131.00 135-69281-010-000 Capital Repair-Ground Storage 150,000.00 150,000.00 69,788.02 46.525 80,211.98 Subtotal: 1,018,837.00 1,018,837.00 129,657.02 12.726 889,179.98 Program number: 3,821,430.00 3,821,430.00 172,174.16 671,366.12 17.568 3,150,063.88 Department number: Water 3,821,430.00 3,821,430.00 172,174.16 671,366.12 17.568 3,150,063.88 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 14:37 01/10/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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,354.19 38,658.10 19.645 158,122.90 135-50010-020-000 Overtime 10,166.00 10,166.00 1,162.80 3,316.78 32.626 6,849.22 135-50016-020-000 Longevity 2,858.00 2,858.00 2,857.50 99.983 .50 135-50017-020-000 Certification 4,200.00 4,200.00 350.00 1,050.00 25.000 3,150.00 135-50020-020-000 Retirement 29,821.00 29,821.00 2,192.82 31,947.05 107.129 2,126.05- 135-50026-020-000 Medical Insurance 29,034.00 29,034.00 2,327.30 6,981.90 24.047 22,052.10 135-50027-020-000 Dental Insurance 2,112.00 2,112.00 175.34 526.02 24.906 1,585.98 135-50028-020-000 Vision Insurance 552.00 552.00 45.92 137.76 24.957 414.24 135-50029-020-000 Life Insurance & Other 920.00 920.00 311.58 623.16 67.735 296.84 135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 823.37 2,624.96 19.784 10,643.04 135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 192.55 613.89 19.784 2,489.11 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 21,935.87 92,276.12 31.068 204,733.88 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 7,132.59 24,471.07 61.178 15,528.93 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 857.12 857.12 42.856 1,142.88 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 6,574.75 10,432.41 69.549 4,567.59 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,981.75 5,560.25 18.534 24,439.75 Subtotal: 89,500.00 89,500.00 16,546.21 42,401.81 47.376 47,098.19 135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 2,700.00 279.42 513.11 19.004 2,186.89 135-60020-020-000 Electricity 153,045.00 153,045.00 11,290.39 27,510.16 17.975 125,534.84 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 161.45 32.290 338.55 135-60080-020-000 Schools & Training 3,272.00 3,272.00 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 256.41 606.06 43.290 793.94 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 74.050 51.90 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 345.15 345.15 69.030 154.85 Subtotal: 221,367.00 221,367.00 12,171.37 38,138.49 17.229 183,228.51 135-65005-020-000 Fuel & Lube 8,527.00 8,527.00 893.10 2,801.84 32.858 5,725.16 135-65010-020-000 Uniforms 2,574.00 2,574.00 283.47 773.70 30.058 1,800.30 135-65030-020-000 Chemicals 10,000.00 10,000.00 4,400.00 12,868.30 128.683 2,868.30- . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 14:37 01/10/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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 13.509 864.91 135-65040-020-000 Safety Equipment 250.00 250.00 30.37 30.37 12.148 219.63 135-65045-020-000 Lab Supplies 10,000.00 10,000.00 1,548.94 5,452.11 54.521 4,547.89 Subtotal: 32,351.00 32,351.00 7,155.88 22,061.41 68.194 10,289.59 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 57,809.33 194,877.83 18.749 844,550.17 Department number: Wastewater 1,039,428.00 1,039,428.00 57,809.33 194,877.83 18.749 844,550.17 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 14:37 01/10/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/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,314.48 30,940.31 19.773 125,534.69 135-50010-021-000 Overtime 7,297.00 7,297.00 1,506.18 2,689.72 36.861 4,607.28 135-50016-021-000 Longevity 3,818.00 3,818.00 3,817.50 99.987 .50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 450.00 25.000 1,350.00 135-50020-021-000 Retirement 23,574.00 23,574.00 1,792.55 25,037.95 106.210 1,463.95- 135-50026-021-000 Medical Insurance 20,198.00 20,198.00 1,683.08 5,049.24 24.999 15,148.76 135-50027-021-000 Dental Insurance 1,409.00 1,409.00 124.48 373.44 26.504 1,035.56 135-50028-021-000 Vision Insurance 357.00 357.00 29.72 89.16 24.975 267.84 135-50029-021-000 Life Insurance & Other 1,008.00 1,008.00 238.68 477.36 47.357 530.64 135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 749.63 2,394.21 22.798 8,107.79 135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 175.31 559.92 22.798 1,896.08 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 6.712 233.22 Subtotal: 233,059.00 233,059.00 17,764.11 75,243.59 32.285 157,815.41 135-55005-021-000 Engineering 1,500.00 1,500.00 2,450.00- 1,500.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 268.38 268.38 14.125 1,631.62 Subtotal: 38,400.00 38,400.00 2,181.62- 436.88 1.138 37,963.12 135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 217.70 435.20 12.434 3,064.80 135-60020-021-000 Electricity 18,705.00 18,705.00 1,254.92 2,943.57 15.737 15,761.43 135-60070-021-000 Dues & Memberships 250.00 250.00 111.00 44.400 139.00 135-60080-021-000 Schools & Training 826.00 826.00 55.00 385.00 46.610 441.00 135-60090-021-000 Safety Program 500.00 500.00 500.00 135-60100-021-000 Travel & per diem 450.00 450.00 109.90 197.04 43.787 252.96 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,637.52 4,071.81 11.860 30,259.19 135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 807.06 2,641.87 21.803 9,475.13 135-65010-021-000 Uniforms 2,220.00 2,220.00 119.05 934.13 42.078 1,285.87 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 4.667 1,430.00 135-65040-021-000 Safety Equipment 500.00 500.00 500.00 Subtotal: 23,837.00 23,837.00 926.11 3,646.00 15.296 20,191.00 135-69005-021-000 Capital Expenses 90,000.00 90,000.00 90,000.00 135-69008-021-000 Short Term Debt-Principal 40,260.00 40,260.00 40,260.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 14:37 01/10/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/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 18,146.12 83,398.28 18.135 376,488.72 Department number: Collection 459,887.00 459,887.00 18,146.12 83,398.28 18.135 376,488.72 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 14:37 01/10/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/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 700.00 2,100.00 21.000 7,900.00 135-50030-026-000 Social Security Taxes 620.00 620.00 43.40 130.20 21.000 489.80 135-50035-026-000 Medicare Taxes 145.00 145.00 10.15 30.45 21.000 114.55 135-50040-026-000 Unemployment Taxes 210.00 210.00 20.30 60.90 29.000 149.10 135-50045-026-000 Workman's Compensation 150.00 150.00 150.00 Subtotal: 11,125.00 11,125.00 773.85 2,321.55 20.868 8,803.45 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 156.97 222.97 18.581 977.03 135-60080-026-000 Schools & Training 4,000.00 4,000.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 156.97 802.97 5.197 14,647.03 Program number: 26,575.00 26,575.00 930.82 3,124.52 11.757 23,450.48 Department number: Board of Directors 26,575.00 26,575.00 930.82 3,124.52 11.757 23,450.48 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 14:37 01/10/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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,539.68 93,272.97 20.973 351,457.03 135-50010-030-000 Overtime 1,500.00 1,500.00 32.58 81.89 5.459 1,418.11 135-50016-030-000 Longevity 2,193.00 2,193.00 2,317.50 105.677 124.50- 135-50020-030-000 Retirement 60,441.00 60,441.00 4,506.36 58,236.82 96.353 2,204.18 135-50026-030-000 Medical Insurance 44,066.00 44,066.00 3,185.30 9,555.90 21.685 34,510.10 135-50027-030-000 Dental Insurance 3,379.00 3,379.00 288.72 866.16 25.634 2,512.84 135-50028-030-000 Vision Insurance 795.00 795.00 66.20 198.60 24.981 596.40 135-50029-030-000 Life Insurance & Other 2,500.00 2,500.00 584.92 1,169.84 46.794 1,330.16 135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 1,912.01 5,927.02 21.319 21,874.98 135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 447.17 1,386.16 21.319 5,115.84 135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 27.98 357.90 23.286 1,179.10 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 39.00 15.600 211.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 922.10 922.10 18.442 4,077.90 Subtotal: 601,526.00 601,526.00 45,513.02 175,162.86 29.120 426,363.14 135-55030-030-000 Software & Support 63,555.00 63,555.00 1,183.50 9,675.52 15.224 53,879.48 135-55070-030-000 Independent Labor 2,700.00 2,700.00 56.25 56.25 2.083 2,643.75 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 993.58 2,501.86 50.037 2,498.14 135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,852.23 5,342.91 26.450 14,857.09 135-55160-030-000 Professional Outside Services 15,000.00 15,000.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 496.74 2,064.02 18.764 8,935.98 Subtotal: 203,420.00 203,420.00 4,582.30 26,625.33 13.089 176,794.67 135-60005-030-000 Telephone 9,000.00 9,000.00 1,717.10 19.079 7,282.90 135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 327.04 804.08 22.492 2,770.92 135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 989.59 1,932.58 14.844 11,086.42 135-60025-030-000 Water 3,100.00 3,100.00 195.82 320.88 10.351 2,779.12 135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 3,295.53 25.000 9,886.47 135-60035-030-000 Postage 23,000.00 23,000.00 1,908.71 6,318.97 27.474 16,681.03 135-60040-030-000 Service Charges & Fees 18,000.00 18,000.00 2,255.25 7,636.71 42.426 10,363.29 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 8.15- 60,593.77 173.125 25,593.77- 135-60066-030-000 Publications/Books/Subscripts 750.00 750.00 558.22 74.429 191.78 135-60070-030-000 Dues & Memberships 2,400.00 2,400.00 250.00 900.00 37.500 1,500.00 135-60075-030-000 Meetings 250.00 250.00 30.00 118.00 47.200 132.00 135-60080-030-000 Schools & Training 5,500.00 5,500.00 120.00 570.00 10.364 4,930.00 135-60100-030-000 Travel & per diem 3,950.00 3,950.00 644.59 694.19 17.574 3,255.81 135-60110-030-000 Physicals/Testing 500.00 500.00 500.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 14:37 01/10/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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 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 2,060.00 2,325.00 93.000 175.00 Subtotal: 173,076.00 173,076.00 9,871.36 86,850.63 50.181 86,225.37 135-65010-030-000 Uniforms 1,635.00 1,635.00 624.12 38.172 1,010.88 135-65055-030-000 Hardware 20,188.00 20,188.00 6,288.27 31.149 13,899.73 135-65085-030-000 Office Supplies 8,200.00 8,200.00 1,852.62 22.593 6,347.38 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 389.00 900.00 15.701 4,832.00 135-65095-030-000 Maintenance Supplies 2,000.00 2,000.00 171.81 269.21 13.461 1,730.79 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 7.596 4,805.00 Subtotal: 43,455.00 43,455.00 560.81 10,329.22 23.770 33,125.78 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 513.70 1,027.40 29.780 2,422.60 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 513.70 1,027.40 3.384 29,333.60 Program number: 1,051,838.00 1,051,838.00 61,041.19 299,995.44 28.521 751,842.56 Department number: Administration 1,051,838.00 1,051,838.00 61,041.19 299,995.44 28.521 751,842.56 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 14:37 01/10/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/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 15,959.69 21,728.44 31.041 48,271.56 135-55055-039-000 Auditing 21,200.00 21,200.00 5,175.00 24.410 16,025.00 135-55060-039-000 Appraisal 15,100.00 15,100.00 1,943.16 4,265.90 28.251 10,834.10 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 110,100.00 110,100.00 17,902.85 31,169.34 28.310 78,930.66 Program number: 110,100.00 110,100.00 17,902.85 31,169.34 28.310 78,930.66 Department number: Non Departmental 110,100.00 110,100.00 17,902.85 31,169.34 28.310 78,930.66 Expenditures Subtotal ----------- 6,509,258.00 6,509,258.00 328,004.47 1,283,931.53 19.725 5,225,326.47 Fund number: 135 MUD 1 General Fund 93,490.02- 88,100.24- 88,100.24 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/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 559 12/03/2012 Property Taxes & Assessments (7,859.48) (473.79) (8,333.27) GL 560 12/04/2012 Property Taxes & Assessments (350.80) (8,684.07) GL 561 12/05/2012 Property Taxes & Assessments (346.01) (9,030.08) GL 562 12/06/2012 Property Taxes & Assessments (284.66) (9,314.74) GL 563 12/07/2012 Property Taxes & Assessments (487.31) (9,802.05) GL 564 12/10/2012 Property Taxes & Assessments (472.31) (10,274.36) GL 565 12/11/2012 Property Taxes & Assessments (321.58) (10,595.94) GL 566 12/12/2012 Property Taxes & Assessments (191.80) (10,787.74) GL 567 12/13/2012 Property Taxes & Assessments (439.93) (11,227.67) GL 568 12/14/2012 Property Taxes/Assessments (260.93) (11,488.60) GL 569 12/17/2012 Property Taxes/Assessments (570.38) (12,058.98) GL 570 12/18/2012 Property Taxes/Assessments (970.41) (13,029.39) GL 571 12/19/2012 Property Taxes/Assessments (6,286.23) (19,315.62) GL 572 12/20/2012 Property Taxes/Assessments (483.91) (19,799.53) GL 573 12/21/2012 Property Taxes/Assessments (921.19) (20,720.72) GL 574 12/27/2012 Property Taxes/Assessments (11,221.21) (31,941.93) GL 575 12/29/2012 Property Taxes/Assessments (2,749.04) (34,690.97) GL 576 12/31/2012 Property Taxes/Assessments (13,916.10) (48,607.07) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (40,747.59) (48,607.07) ** (99,884.00) Budgeted (51,276.93) Remaining 49 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 561 12/05/2012 Property Taxes & Assessments (659.53) (14.76) (674.29) GL 572 12/20/2012 Property Taxes/Assessments (38.63) (712.92) GL 576 12/31/2012 Property Taxes/Assessments .49 (712.43) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (52.90) (712.43) ** (500.00) Budgeted 212.43 Remaining 142 % Used Account: 135-40015-000-000 Property Taxes/P & I 559 12/03/2012 Property Taxes & Assessments (450.09) (11.96) (462.05) GL 561 12/05/2012 Property Taxes & Assessments (6.10) (468.15) GL 563 12/07/2012 Property Taxes & Assessments (5.50) (473.65) GL 566 12/12/2012 Property Taxes & Assessments (7.40) (481.05) GL 570 12/18/2012 Property Taxes/Assessments (3.26) (484.31) GL 572 12/20/2012 Property Taxes/Assessments (8.89) (493.20) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (43.11) (493.20) ** (1,200.00) Budgeted (706.80) Remaining 41 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/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 482 12/18/2012 UB 12/18/12 Adjustments UB20121218-20121218 User: (553,069.96) 12.71 (553,057.25) UB 546 12/31/2012 UB 12/31/12 billing UB20121231-20121231 User: (200,113.20) (753,170.45) UB _______________ Account: 135-47000-000-000 Water Totals: (200,100.49) (753,170.45) ** (3,545,609.00) Budgeted (2,792,438.55) Remaining 21 % Used Account: 135-47005-000-000 Sewer 482 12/18/2012 UB 12/18/12 Adjustments UB20121218-20121218 User: (282,782.39) 12.71 (282,769.68) UB 546 12/31/2012 UB 12/31/12 billing UB20121231-20121231 User: (129,935.88) (412,705.56) UB 636 12/31/2012 Recode Comm Sewer to Sewer (2,660.05) (415,365.61) GL _______________ Account: 135-47005-000-000 Sewer Totals: (132,583.22) (415,365.61) ** (1,653,747.00) Budgeted (1,238,381.39) Remaining 25 % Used Account: 135-47015-000-000 Commercial Sewer 546 12/31/2012 UB 12/31/12 billing UB20121231-20121231 User: (2,660.05) (2,660.05) UB 636 12/31/2012 Recode Comm Sewer to Sewer 2,660.05 .00 GL _______________ Account: 135-47015-000-000 Commercial Sewer Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-47020-000-000 Standby 605 12/05/2012 UB 12/05/2012 Adjustment UB20121205-20121205 User: (101.90) 6.00 (95.90) UB 546 12/31/2012 UB 12/31/12 billing UB20121231-20121231 User: (54.00) (149.90) UB _______________ Account: 135-47020-000-000 Standby Totals: (48.00) (149.90) ** (576.00) Budgeted (426.10) Remaining 26 % Used Account: 135-47025-000-000 Penalties 504 12/21/2012 UB 12/21/2012 Penalties UB20121221-20121221 User: (11,210.49) (4,712.65) (15,923.14) UB 532 12/28/2012 UB 12/28/2012 Adjustments UB20121228-20121228 User: 165.67 (15,757.47) UB 540 12/31/2012 UB 12/31/12 Adjustments UB20121231-20121231 User: 142.73 (15,614.74) UB 546 12/31/2012 UB 12/31/12 billing UB20121231-20121231 User: (385.21) (15,999.95) UB _______________ Account: 135-47025-000-000 Penalties Totals: (4,789.46) (15,999.95) ** (64,580.00) Budgeted (48,580.05) Remaining 25 % Used Account: 135-47030-000-000 Service Charges . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 606 12/01/2012 UB 11/02/2012 Adjustment UB20121102-20121102 User: (1,781.00) 25.00 (1,756.00) UB 384 12/01/2012 UB 12/1/12 Adjustment UB20121201-20121201 User: (25.00) (1,781.00) UB 439 12/03/2012 UB 12/3/12 Adjustments UB20121203-20121203 User: (25.00) (1,806.00) UB 369 12/06/2012 UB 12/6/12 Cut Off Fee UB20121206-20121206 User: (1,075.00) (2,881.00) UB 383 12/06/2012 UB 12/6/12 After Hours Fee UB20121206-20121206 User: (200.00) (3,081.00) UB 546 12/31/2012 UB 12/31/12 billing UB20121231-20121231 User: (3.00) (3,084.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,303.00) (3,084.00) ** (11,625.00) Budgeted (8,541.00) Remaining 27 % Used Account: 135-47035-000-000 Plumbing Inspections 591 12/11/2012 Permits 12/11/12 (50.00) (50.00) GL 596 12/21/2012 Permits 12/21/12 (50.00) (100.00) GL _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (100.00) ** (1,800.00) Budgeted (1,700.00) Remaining 6 % Used Account: 135-47045-000-000 Sewer Inspections 591 12/11/2012 Permits 12/11/12 (450.00) (150.00) (600.00) GL 596 12/21/2012 Permits 12/21/12 (150.00) (750.00) GL _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (750.00) ** (5,200.00) Budgeted (4,450.00) Remaining 14 % Used Account: 135-47070-000-000 TCCC Effluent Charges 579 12/31/2012 TCCC/Nov Effluent (4,882.15) (5,785.00) (10,667.15) GL _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (5,785.00) (10,667.15) ** (77,575.00) Budgeted (66,907.85) Remaining 14 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 546 12/31/2012 UB 12/31/12 billing UB20121231-20121231 User: (12.71) (12.71) UB _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: (12.71) (12.71) ** .00 Budgeted 12.71 Remaining 0 % Used Account: 135-48005-000-000 Utility Fees 590 12/05/2012 Permits 12/5/12 (71,300.00) (2,300.00) (73,600.00) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 619 12/06/2012 Correct JE 485/Deposit Reverse, incorrect amount (71,300.00) 323,204.94 249,604.94 GL 619 12/06/2012 Correct JE 485/Deposit Correct (323,604.94) (74,000.00) GL 633 12/10/2012 Permits 12/10/12 (2,300.00) (76,300.00) GL 592 12/12/2012 Permits 12/12/12 (2,300.00) (78,600.00) GL 593 12/13/2012 Permits 12/13/12 (6,900.00) (85,500.00) GL 594 12/17/2012 Permits 12/17/12 (2,300.00) (87,800.00) GL 595 12/18/2012 Permits 12/18/12 (2,300.00) (90,100.00) GL 596 12/21/2012 Permits 12/21/12 (9,200.00) (99,300.00) GL _______________ Account: 135-48005-000-000 Utility Fees Totals: (28,000.00) (99,300.00) ** (644,000.00) Budgeted (544,700.00) Remaining 15 % Used Account: 135-49010-000-000 Interest Income 597 12/31/2012 Dec Bank Interest (1,121.28) (71.65) (1,192.93) GL 597 12/31/2012 Dec Bank Interest (462.42) (1,655.35) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (534.07) (1,655.35) ** (5,500.00) Budgeted (3,844.65) Remaining 30 % Used Account: 135-49016-000-000 Cell Tower Revenue 486 12/06/2012 ATT cell tower lease (1,757.53) (910.53) (2,668.06) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (2,668.06) ** (10,164.00) Budgeted (7,495.94) Remaining 26 % Used Account: 135-49018-000-000 Building Rent Income 500 12/06/2012 Town Oct postage, rent, gaslog (1,166.66) (583.33) (1,749.99) GL _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,749.99) ** (7,000.00) Budgeted (5,250.01) Remaining 25 % Used Account: 135-49030-000-000 Vending Revenue 581 12/31/2012 Coffee $ (18.76) (14.08) (32.84) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (14.08) (32.84) ** (350.00) Budgeted (317.16) Remaining 9 % Used Account: 135-49035-000-000 Prior Year Reserves . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/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-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 590 12/05/2012 Permits 12/5/12 (10,220.00) (292.00) (10,512.00) GL 633 12/10/2012 Permits 12/10/12 (292.00) (10,804.00) GL 591 12/11/2012 Permits 12/11/12 (292.00) (11,096.00) GL 592 12/12/2012 Permits 12/12/12 (292.00) (11,388.00) GL 593 12/13/2012 Permits 12/13/12 (951.00) (12,339.00) GL 594 12/17/2012 Permits 12/17/12 (292.00) (12,631.00) GL 595 12/18/2012 Permits 12/18/12 (292.00) (12,923.00) GL 596 12/21/2012 Permits 12/21/12 (1,535.00) (14,458.00) GL _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (4,238.00) (14,458.00) ** (73,000.00) Budgeted (58,542.00) Remaining 20 % Used Account: 135-49900-000-000 Miscellaneous Income 544 12/01/2012 UB 12/1/12 Adjustments UB20121201-20121201 User: (1,706.06) (1,261.29) (2,967.35) UB 369 12/06/2012 UB 12/6/12 Cut Off Fee UB20121206-20121206 User: (25.00) (2,992.35) UB 501 12/06/2012 Tri Cty Elec/Patronage refund (230.50) (3,222.85) GL 595 12/18/2012 Permits 12/18/12 (75.00) (3,297.85) GL 546 12/31/2012 UB 12/31/12 billing UB20121231-20121231 User: 646.62 (2,651.23) UB 589 12/31/2012 Clear 2010 P/R Liabilities (140.86) (2,792.09) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (1,086.03) (2,792.09) ** (1,000.00) Budgeted 1,792.09 Remaining 279 % Used Account: 135-49901-000-000 Records Management Revenue 498 12/06/2012 ORR/Rose (109.00) (109.00) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (109.00) (109.00) ** .00 Budgeted 109.00 Remaining 0 % Used Account: 135-49905-000-000 Gas Well Revenue 580 12/31/2012 Vantage Energy/Gaswells (153.97) (153.97) GL _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: (153.97) (153.97) ** (200.00) Budgeted (46.03) Remaining 77 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department Totals: ------------------------------------------------------------------------------------------------ (1,372,031.77) ** (6,509,258.00) Budgeted (5,137,226.23) Remaining 21 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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 609 12/07/2012 12/7/12 Payroll 22,290.01 6,435.52 28,725.53 GL 615 12/21/2012 12/21/12 Payroll 6,443.59 35,169.12 GL _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 12,879.11 35,169.12 ** 213,321.00 Budgeted 178,151.88 Remaining 16 % Used Account: 135-50010-010-000 Overtime 609 12/07/2012 12/7/12 Payroll 3,424.59 209.30 3,633.89 GL 609 12/07/2012 12/7/12 Payroll 80.00 3,713.89 GL 615 12/21/2012 12/21/12 Payroll 599.98 4,313.87 GL 615 12/21/2012 12/21/12 Payroll 80.00 4,393.87 GL _______________ Account: 135-50010-010-000 Overtime Totals: 969.28 4,393.87 ** 13,250.00 Budgeted 8,856.13 Remaining 33 % Used Account: 135-50016-010-000 Longevity 3,080.00 .00 3,080.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,080.00 ** 3,080.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 609 12/07/2012 12/7/12 Payroll 600.00 300.00 900.00 GL _______________ Account: 135-50017-010-000 Certification Totals: 300.00 900.00 ** 5,100.00 Budgeted 4,200.00 Remaining 18 % Used Account: 135-50020-010-000 Retirement 609 12/07/2012 12/7/12 Payroll 29,685.80 970.82 30,656.62 GL 615 12/21/2012 12/21/12 Payroll 984.49 31,641.11 GL _______________ Account: 135-50020-010-000 Retirement Totals: 1,955.31 31,641.11 ** 32,725.00 Budgeted 1,083.89 Remaining 97 % Used Account: 135-50026-010-000 Medical Insurance 609 12/07/2012 12/7/12 Payroll 3,367.84 841.96 4,209.80 GL 615 12/21/2012 12/21/12 Payroll 841.96 5,051.76 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,683.92 5,051.76 ** 28,920.00 Budgeted 23,868.24 Remaining 17 % Used Account: 135-50027-010-000 Dental Insurance 609 12/07/2012 12/7/12 Payroll 265.56 66.39 331.95 GL 615 12/21/2012 12/21/12 Payroll 66.39 398.34 GL _______________ Account: 135-50027-010-000 Dental Insurance Totals: 132.78 398.34 ** 2,091.00 Budgeted 1,692.66 Remaining 19 % Used Account: 135-50028-010-000 Vision Insurance 609 12/07/2012 12/7/12 Payroll 63.52 15.88 79.40 GL 615 12/21/2012 12/21/12 Payroll 15.88 95.28 GL _______________ Account: 135-50028-010-000 Vision Insurance Totals: 31.76 95.28 ** 519.00 Budgeted 423.72 Remaining 18 % Used Account: 135-50029-010-000 Life Insurance & Other 609 12/07/2012 12/7/12 Payroll 286.80 143.40 430.20 GL 615 12/21/2012 12/21/12 Payroll 143.40 573.60 GL _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 286.80 573.60 ** 1,204.00 Budgeted 630.40 Remaining 48 % Used Account: 135-50030-010-000 Social Security Taxes 609 12/07/2012 12/7/12 Payroll 2,044.92 423.86 2,468.78 GL 615 12/21/2012 12/21/12 Payroll 429.99 2,898.77 GL _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 853.85 2,898.77 ** 14,555.00 Budgeted 11,656.23 Remaining 20 % Used Account: 135-50035-010-000 Medicare Taxes 609 12/07/2012 12/7/12 Payroll 478.25 99.13 577.38 GL 615 12/21/2012 12/21/12 Payroll 100.56 677.94 GL _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 199.69 677.94 ** 3,404.00 Budgeted 2,726.06 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-010-000 Unemployment Taxes .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 Account: 135-55080-010-000 Maintenance & Repairs 10,009.23 .00 10,009.23 _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: .00 10,009.23 ** 50,000.00 Budgeted 39,990.77 Remaining 20 % Used Account: 135-55090-010-000 Vehicle Maintenance . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 550 12/05/2012 Dec A/P 10/6-11/5 PCards McMahon 459.39 4.23 463.62 JPMORGAN CHASE BANK NA 32029 AP 555 12/31/2012 Dec A/P Batteries/Backhoe and vac trai 102.99 566.61 ROANOKE AUTO SUPPLY 32095 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 107.22 566.61 ** 3,700.00 Budgeted 3,133.39 Remaining 15 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 555 12/31/2012 Dec A/P Batteries/Backhoe and vac trai 1,546.80 220.24 1,767.04 ROANOKE AUTO SUPPLY 32095 AP _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 220.24 1,767.04 ** 2,900.00 Budgeted 1,132.96 Remaining 61 % Used Account: 135-55135-010-000 Lab Analysis 479 12/18/2012 Dec A/P Bac-T samples November 1,125.15 510.00 1,635.15 TARRANT CTY PUBLIC HEALTH LAB 32018 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 510.00 1,635.15 ** 4,500.00 Budgeted 2,864.85 Remaining 36 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 555 12/31/2012 Dec A/P Cell phones 175.79 176.42 352.21 VERIZON WIRELESS 32110 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 176.42 352.21 ** 2,000.00 Budgeted 1,647.79 Remaining 18 % Used Account: 135-60020-010-000 Electricity 479 12/18/2012 Dec A/P Electricity 11/9-12/12 15,215.06 89.77 15,304.83 HUDSON ENERGY 32008 AP 555 12/31/2012 Dec A/P Electricity 11/12-12/13 5,469.39 20,774.22 HUDSON ENERGY 32064 AP 555 12/31/2012 Dec A/P Electricity 11/12-12/13 3,272.88 24,047.10 HUDSON ENERGY 32064 AP _______________ Account: 135-60020-010-000 Electricity Totals: 8,832.04 24,047.10 ** 162,410.00 Budgeted 138,362.90 Remaining 15 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 550 12/05/2012 Dec A/P 11/6-12/5 PCards Slaght 240.00 111.00 351.00 JPMORGAN CHASE BANK NA 32029 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 111.00 351.00 ** 1,672.00 Budgeted 1,321.00 Remaining 21 % 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 609 12/07/2012 12/7/12 Payroll 388.51 24.42 412.93 GL 615 12/21/2012 12/21/12 Payroll 46.07 459.00 GL _______________ Account: 135-60100-010-000 Travel & per diem Totals: 70.49 459.00 ** 700.00 Budgeted 241.00 Remaining 66 % 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 8,173.45 .00 8,173.45 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 8,173.45 ** 35,800.00 Budgeted 27,626.55 Remaining 23 % Used Account: 135-60150-010-000 Wholesale Water . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 555 12/31/2012 Dec A/P November Wholesale water 162,916.59 141,040.87 303,957.46 CITY OF FORT WORTH 32040 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 141,040.87 303,957.46 ** 2,028,447.00 Budgeted 1,724,489.54 Remaining 15 % 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 550 12/05/2012 Dec A/P 10/6-11/5 PCards McMahon 213.20 27.50 240.70 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 11/6-12/5 PCard-Womack 108.00 348.70 JPMORGAN CHASE BANK NA 32029 AP _______________ Account: 135-60280-010-000 Property Maintenance Totals: 135.50 348.70 ** 4,200.00 Budgeted 3,851.30 Remaining 8 % Used 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 550 12/05/2012 Dec A/P 11/6-12/5 PCard-Womack 38.99 38.99 JPMORGAN CHASE BANK NA 32029 AP _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 38.99 38.99 ** 1,500.00 Budgeted 1,461.01 Remaining 3 % Used Account: 135-65005-010-000 Fuel & Lube 550 12/05/2012 Dec A/P 10/6-11/5 PCards McKnight 1,918.54 58.10 1,976.64 JPMORGAN CHASE BANK NA 32029 AP 620 12/31/2012 December Gas Log 948.85 2,925.49 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,006.95 2,925.49 ** 17,661.00 Budgeted 14,735.51 Remaining 17 % Used Account: 135-65010-010-000 Uniforms . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 550 12/05/2012 Dec A/P 10/6-11/5 PCards McMahon 720.12 379.96 1,100.08 JPMORGAN CHASE BANK NA 32029 AP _______________ Account: 135-65010-010-000 Uniforms Totals: 379.96 1,100.08 ** 2,680.00 Budgeted 1,579.92 Remaining 41 % Used Account: 135-65030-010-000 Chemicals 550 12/05/2012 Dec A/P 11/6-12/5 PCard-Womack 719.63 208.18 927.81 JPMORGAN CHASE BANK NA 32029 AP 555 12/31/2012 Dec A/P nitrite standard 43.80 971.61 HACH COMPANY 32060 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 251.98 971.61 ** 6,200.00 Budgeted 5,228.39 Remaining 16 % Used Account: 135-65035-010-000 Small Tools 267.19 .00 267.19 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 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 93,750.00 .00 93,750.00 _______________ Account: 135-65050-010-000 Meter Expense Totals: .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-Principal . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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-69008-010-000 Short Term Debt-Principal 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 59,869.00 .00 59,869.00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 59,869.00 ** 270,000.00 Budgeted 210,131.00 Remaining 22 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 69,788.02 .00 69,788.02 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 69,788.02 ** 150,000.00 Budgeted 80,211.98 Remaining 47 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 671,366.12 ** 3,821,430.00 Budgeted 3,150,063.88 Remaining 18 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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 609 12/07/2012 12/7/12 Payroll 24,303.91 7,081.22 31,385.13 GL 615 12/21/2012 12/21/12 Payroll 7,272.97 38,658.10 GL _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,354.19 38,658.10 ** 196,781.00 Budgeted 158,122.90 Remaining 20 % Used Account: 135-50010-020-000 Overtime 609 12/07/2012 12/7/12 Payroll 2,153.98 488.11 2,642.09 GL 609 12/07/2012 12/7/12 Payroll 80.00 2,722.09 GL 615 12/21/2012 12/21/12 Payroll 594.69 3,316.78 GL _______________ Account: 135-50010-020-000 Overtime Totals: 1,162.80 3,316.78 ** 10,166.00 Budgeted 6,849.22 Remaining 33 % Used Account: 135-50016-020-000 Longevity 2,857.50 .00 2,857.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,857.50 ** 2,858.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 609 12/07/2012 12/7/12 Payroll 700.00 350.00 1,050.00 GL _______________ Account: 135-50017-020-000 Certification Totals: 350.00 1,050.00 ** 4,200.00 Budgeted 3,150.00 Remaining 25 % Used Account: 135-50020-020-000 Retirement 609 12/07/2012 12/7/12 Payroll 29,754.23 1,105.51 30,859.74 GL 615 12/21/2012 12/21/12 Payroll 1,087.31 31,947.05 GL _______________ Account: 135-50020-020-000 Retirement Totals: 2,192.82 31,947.05 ** 29,821.00 Budgeted (2,126.05) Remaining 107 % Used Account: 135-50026-020-000 Medical Insurance 609 12/07/2012 12/7/12 Payroll 4,654.60 1,163.65 5,818.25 GL 615 12/21/2012 12/21/12 Payroll 1,163.65 6,981.90 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,327.30 6,981.90 ** 29,034.00 Budgeted 22,052.10 Remaining 24 % Used Account: 135-50027-020-000 Dental Insurance 609 12/07/2012 12/7/12 Payroll 350.68 87.67 438.35 GL 615 12/21/2012 12/21/12 Payroll 87.67 526.02 GL _______________ Account: 135-50027-020-000 Dental Insurance Totals: 175.34 526.02 ** 2,112.00 Budgeted 1,585.98 Remaining 25 % Used Account: 135-50028-020-000 Vision Insurance 609 12/07/2012 12/7/12 Payroll 91.84 22.96 114.80 GL 615 12/21/2012 12/21/12 Payroll 22.96 137.76 GL _______________ Account: 135-50028-020-000 Vision Insurance Totals: 45.92 137.76 ** 552.00 Budgeted 414.24 Remaining 25 % Used Account: 135-50029-020-000 Life Insurance & Other 609 12/07/2012 12/7/12 Payroll 311.58 155.79 467.37 GL 615 12/21/2012 12/21/12 Payroll 155.79 623.16 GL _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 311.58 623.16 ** 920.00 Budgeted 296.84 Remaining 68 % Used Account: 135-50030-020-000 Social Security Taxes 609 12/07/2012 12/7/12 Payroll 1,801.59 415.77 2,217.36 GL 615 12/21/2012 12/21/12 Payroll 407.60 2,624.96 GL _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 823.37 2,624.96 ** 13,268.00 Budgeted 10,643.04 Remaining 20 % Used Account: 135-50035-020-000 Medicare Taxes 609 12/07/2012 12/7/12 Payroll 421.34 97.23 518.57 GL 615 12/21/2012 12/21/12 Payroll 95.32 613.89 GL _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 192.55 613.89 ** 3,103.00 Budgeted 2,489.11 Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-020-000 Unemployment Taxes .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 .00 .00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 550 12/05/2012 Dec A/P 10/6-11/5 PCards Richey 17,338.48 16.69 17,355.17 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 11/6-12/5 PCards Schlielig 900.00 18,255.17 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 11/6-12/5 PCards Schlielig 2,287.00 20,542.17 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 11/6-12/5 PCards Schlielig 26.31 20,568.48 JPMORGAN CHASE BANK NA 32029 AP 555 12/31/2012 Dec A/P Rubber seals for belt press 604.59 21,173.07 ASHBROOK SIMON-HARTLEY 32032 AP 555 12/31/2012 Dec A/P Service on SC1000 Equipment 3,298.00 24,471.07 HACH COMPANY 32060 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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 Totals: 7,132.59 24,471.07 ** 40,000.00 Budgeted 15,528.93 Remaining 61 % Used Account: 135-55090-020-000 Vehicle Maintenance 550 12/05/2012 Dec A/P 11/6-12/5 PCard-Womack 39.75 39.75 JPMORGAN CHASE BANK NA 32029 AP 479 12/18/2012 Dec A/P State inspection/2 front tires 338.23 377.98 BLAGG TIRE & SERVICE 31998 AP 479 12/18/2012 Dec A/P Back right tire for Ford F350 126.85 504.83 BLAGG TIRE & SERVICE 31998 AP 555 12/31/2012 Dec A/P F350 maintenance 352.29 857.12 GRAPEVINE FORD LINCOLN 32058 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 857.12 857.12 ** 2,000.00 Budgeted 1,142.88 Remaining 43 % 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 479 12/18/2012 Dec A/P Sludge haul off 3,857.66 1,454.01 5,311.67 CHANEY ENVIRONMENTAL 32001 AP 555 12/31/2012 Dec A/P Sludge haul off 1,675.09 6,986.76 CHANEY ENVIRONMENTAL 32038 AP 555 12/31/2012 Dec A/P Sludge haul off 3,445.65 10,432.41 CHANEY ENVIRONMENTAL 32038 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 6,574.75 10,432.41 ** 15,000.00 Budgeted 4,567.59 Remaining 70 % Used Account: 135-55135-020-000 Lab Analysis 479 12/18/2012 Dec A/P Wet chem analysis 3,578.50 1,981.75 5,560.25 TALEM, INC 32017 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,981.75 5,560.25 ** 30,000.00 Budgeted 24,439.75 Remaining 19 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 555 12/31/2012 Dec A/P Cell phones 233.69 279.42 513.11 VERIZON WIRELESS 32110 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 279.42 513.11 ** 2,700.00 Budgeted 2,186.89 Remaining 19 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-020-000 Electricity 555 12/31/2012 Dec A/P Electricity 11/12-12/13 16,219.77 11,290.39 27,510.16 HUDSON ENERGY 32064 AP _______________ Account: 135-60020-020-000 Electricity Totals: 11,290.39 27,510.16 ** 153,045.00 Budgeted 125,534.84 Remaining 18 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 161.45 .00 161.45 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 161.45 ** 500.00 Budgeted 338.55 Remaining 32 % Used Account: 135-60080-020-000 Schools & Training 104.66 .00 104.66 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 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 609 12/07/2012 12/7/12 Payroll 349.65 93.24 442.89 GL 615 12/21/2012 12/21/12 Payroll 163.17 606.06 GL _______________ Account: 135-60100-020-000 Travel & per diem Totals: 256.41 606.06 ** 1,400.00 Budgeted 793.94 Remaining 43 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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-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 148.10 .00 148.10 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 148.10 ** 200.00 Budgeted 51.90 Remaining 74 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 550 12/05/2012 Dec A/P 11/6-12/5 PCards Schlielig 345.15 345.15 JPMORGAN CHASE BANK NA 32029 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 345.15 345.15 ** 500.00 Budgeted 154.85 Remaining 69 % Used Account: 135-65005-020-000 Fuel & Lube 550 12/05/2012 Dec A/P 10/6-11/5 PCards Richey 1,908.74 47.52 1,956.26 JPMORGAN CHASE BANK NA 32029 AP 620 12/31/2012 December Gas Log 845.58 2,801.84 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 893.10 2,801.84 ** 8,527.00 Budgeted 5,725.16 Remaining 33 % Used Account: 135-65010-020-000 Uniforms 550 12/05/2012 Dec A/P 11/6-12/5 PCards Schlielig 490.23 283.47 773.70 JPMORGAN CHASE BANK NA 32029 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 283.47 773.70 ** 2,574.00 Budgeted 1,800.30 Remaining 30 % Used Account: 135-65030-020-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 479 12/18/2012 Dec A/P 450 lb drum Clarifloc 8,468.30 540.00 9,008.30 POLYDYNE, INC 32014 AP 479 12/18/2012 Dec A/P 450 lb drum Clarifloc 540.00 9,548.30 POLYDYNE, INC 32014 AP 555 12/31/2012 Dec A/P Granular Hypochlorite 2,240.00 11,788.30 HARCROS CHEMICALS INC 32062 AP 555 12/31/2012 Dec A/P Clarifloc 1,080.00 12,868.30 POLYDYNE, INC 32094 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 4,400.00 12,868.30 ** 10,000.00 Budgeted (2,868.30) Remaining 129 % Used Account: 135-65035-020-000 Small Tools 135.09 .00 135.09 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 135.09 ** 1,000.00 Budgeted 864.91 Remaining 14 % Used Account: 135-65040-020-000 Safety Equipment 555 12/31/2012 Dec A/P Supplies for safety cabinet 30.37 30.37 CINTAS FAS LOCKBOX 636525 32039 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 30.37 30.37 ** 250.00 Budgeted 219.63 Remaining 12 % Used Account: 135-65045-020-000 Lab Supplies 550 12/05/2012 Dec A/P 11/6-12/5 PCards Schlielig 3,903.17 528.63 4,431.80 JPMORGAN CHASE BANK NA 32029 AP 555 12/31/2012 Dec A/P BOD Bottle rack, sensor cap, t 924.20 5,356.00 HACH COMPANY 32060 AP 555 12/31/2012 Dec A/P Water 96.11 5,452.11 OZARKA DIRECT 32090 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,548.94 5,452.11 ** 10,000.00 Budgeted 4,547.89 Remaining 55 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 20 Totals: ------------------------------------------------------------------------------------------------ 194,877.83 ** 1,039,428.00 Budgeted 844,550.17 Remaining 19 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/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 609 12/07/2012 12/7/12 Payroll 19,625.83 5,605.90 25,231.73 GL 615 12/21/2012 12/21/12 Payroll 5,708.58 30,940.31 GL _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,314.48 30,940.31 ** 156,475.00 Budgeted 125,534.69 Remaining 20 % Used Account: 135-50010-021-000 Overtime 609 12/07/2012 12/7/12 Payroll 1,183.54 1,002.26 2,185.80 GL 609 12/07/2012 12/7/12 Payroll 160.00 2,345.80 GL 615 12/21/2012 12/21/12 Payroll 263.92 2,609.72 GL 615 12/21/2012 12/21/12 Payroll 80.00 2,689.72 GL _______________ Account: 135-50010-021-000 Overtime Totals: 1,506.18 2,689.72 ** 7,297.00 Budgeted 4,607.28 Remaining 37 % Used Account: 135-50016-021-000 Longevity 3,817.50 .00 3,817.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 3,817.50 ** 3,818.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 609 12/07/2012 12/7/12 Payroll 300.00 150.00 450.00 GL _______________ Account: 135-50017-021-000 Certification Totals: 150.00 450.00 ** 1,800.00 Budgeted 1,350.00 Remaining 25 % Used Account: 135-50020-021-000 Retirement 609 12/07/2012 12/7/12 Payroll 23,245.40 956.09 24,201.49 GL 615 12/21/2012 12/21/12 Payroll 836.46 25,037.95 GL _______________ Account: 135-50020-021-000 Retirement Totals: 1,792.55 25,037.95 ** 23,574.00 Budgeted (1,463.95) Remaining 106 % Used Account: 135-50026-021-000 Medical Insurance 609 12/07/2012 12/7/12 Payroll 3,366.16 841.54 4,207.70 GL 615 12/21/2012 12/21/12 Payroll 841.54 5,049.24 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,683.08 5,049.24 ** 20,198.00 Budgeted 15,148.76 Remaining 25 % Used Account: 135-50027-021-000 Dental Insurance 609 12/07/2012 12/7/12 Payroll 248.96 62.24 311.20 GL 615 12/21/2012 12/21/12 Payroll 62.24 373.44 GL _______________ Account: 135-50027-021-000 Dental Insurance Totals: 124.48 373.44 ** 1,409.00 Budgeted 1,035.56 Remaining 27 % Used Account: 135-50028-021-000 Vision Insurance 609 12/07/2012 12/7/12 Payroll 59.44 14.86 74.30 GL 615 12/21/2012 12/21/12 Payroll 14.86 89.16 GL _______________ Account: 135-50028-021-000 Vision Insurance Totals: 29.72 89.16 ** 357.00 Budgeted 267.84 Remaining 25 % Used Account: 135-50029-021-000 Life Insurance & Other 609 12/07/2012 12/7/12 Payroll 238.68 119.34 358.02 GL 615 12/21/2012 12/21/12 Payroll 119.34 477.36 GL _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 238.68 477.36 ** 1,008.00 Budgeted 530.64 Remaining 47 % Used Account: 135-50030-021-000 Social Security Taxes 609 12/07/2012 12/7/12 Payroll 1,644.58 401.65 2,046.23 GL 615 12/21/2012 12/21/12 Payroll 347.98 2,394.21 GL _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 749.63 2,394.21 ** 10,502.00 Budgeted 8,107.79 Remaining 23 % Used Account: 135-50035-021-000 Medicare Taxes 609 12/07/2012 12/7/12 Payroll 384.61 93.93 478.54 GL 615 12/21/2012 12/21/12 Payroll 81.38 559.92 GL _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 175.31 559.92 ** 2,456.00 Budgeted 1,896.08 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-021-000 Unemployment Taxes .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 16.78 .00 16.78 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 16.78 ** 250.00 Budgeted 233.22 Remaining 7 % Used Account: 135-55005-021-000 Engineering 471 12/01/2012 Recode Deltatek to Assigned FB 2,450.00 (2,450.00) .00 GL _______________ Account: 135-55005-021-000 Engineering Totals: (2,450.00) .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % 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 479 12/18/2012 Dec A/P oil, filter, wiper blades 105.19 105.19 ROANOKE AUTO SUPPLY 32015 AP 479 12/18/2012 Dec A/P Starter 2002 Ford F350 163.19 268.38 ROANOKE AUTO SUPPLY 32015 AP _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: 268.38 268.38 ** 1,900.00 Budgeted 1,631.62 Remaining 14 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 555 12/31/2012 Dec A/P Cell phones 217.50 217.70 435.20 VERIZON WIRELESS 32110 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 217.70 435.20 ** 3,500.00 Budgeted 3,064.80 Remaining 12 % Used Account: 135-60020-021-000 Electricity 479 12/18/2012 Dec A/P Electricity 10/29-11/29 1,688.65 258.33 1,946.98 TRI COUNTY ELECTRIC 32024 AP 479 12/18/2012 Dec A/P Electricity 10/29-11/29 144.94 2,091.92 TRI COUNTY ELECTRIC 32024 AP 479 12/18/2012 Dec A/P Electricity 10/29-11/29 27.82 2,119.74 TRI COUNTY ELECTRIC 32024 AP 479 12/18/2012 Dec A/P Electricity 11/9-12/12 53.63 2,173.37 HUDSON ENERGY 32008 AP 555 12/31/2012 Dec A/P Electricity 11/12-12/13 615.78 2,789.15 HUDSON ENERGY 32064 AP 555 12/31/2012 Dec A/P Electricity 11/12-12/13 154.42 2,943.57 HUDSON ENERGY 32064 AP _______________ Account: 135-60020-021-000 Electricity Totals: 1,254.92 2,943.57 ** 18,705.00 Budgeted 15,761.43 Remaining 16 % Used Account: 135-60070-021-000 Dues & Memberships 111.00 .00 111.00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 111.00 ** 250.00 Budgeted 139.00 Remaining 44 % Used Account: 135-60080-021-000 Schools & Training 550 12/05/2012 Dec A/P 11/6-12/5 PCard-Womack 330.00 55.00 385.00 JPMORGAN CHASE BANK NA 32029 AP _______________ Account: 135-60080-021-000 Schools & Training Totals: 55.00 385.00 ** 826.00 Budgeted 441.00 Remaining 47 % 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 Account: 135-60100-021-000 Travel & per diem 609 12/07/2012 12/7/12 Payroll 87.14 93.80 180.94 GL 615 12/21/2012 12/21/12 Payroll 16.10 197.04 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/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 Totals: 109.90 197.04 ** 450.00 Budgeted 252.96 Remaining 44 % 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 620 12/31/2012 December Gas Log 1,834.81 807.06 2,641.87 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 807.06 2,641.87 ** 12,117.00 Budgeted 9,475.13 Remaining 22 % Used Account: 135-65010-021-000 Uniforms 550 12/05/2012 Dec A/P 11/6-12/5 PCard-Womack 815.08 119.05 934.13 JPMORGAN CHASE BANK NA 32029 AP _______________ Account: 135-65010-021-000 Uniforms Totals: 119.05 934.13 ** 2,220.00 Budgeted 1,285.87 Remaining 42 % 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 Account: 135-65035-021-000 Small Tools 70.00 .00 70.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-021-000 Small Tools Totals: .00 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-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 40,260.00 Budgeted 40,260.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 83,398.28 ** 459,887.00 Budgeted 376,488.72 Remaining 18 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/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 609 12/07/2012 12/7/12 Payroll 1,400.00 400.00 1,800.00 GL 615 12/21/2012 12/21/12 Payroll 300.00 2,100.00 GL _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 700.00 2,100.00 ** 10,000.00 Budgeted 7,900.00 Remaining 21 % Used Account: 135-50030-026-000 Social Security Taxes 609 12/07/2012 12/7/12 Payroll 86.80 24.80 111.60 GL 615 12/21/2012 12/21/12 Payroll 18.60 130.20 GL _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 43.40 130.20 ** 620.00 Budgeted 489.80 Remaining 21 % Used Account: 135-50035-026-000 Medicare Taxes 609 12/07/2012 12/7/12 Payroll 20.30 5.80 26.10 GL 615 12/21/2012 12/21/12 Payroll 4.35 30.45 GL _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 10.15 30.45 ** 145.00 Budgeted 114.55 Remaining 21 % Used Account: 135-50040-026-000 Unemployment Taxes 609 12/07/2012 12/7/12 Payroll 40.60 11.60 52.20 GL 615 12/21/2012 12/21/12 Payroll 8.70 60.90 GL _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 20.30 60.90 ** 210.00 Budgeted 149.10 Remaining 29 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships .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 550 12/05/2012 Dec A/P 10/6-11/5 PCards Gonzales 66.00 22.00 88.00 JPMORGAN CHASE BANK NA 32029 AP 479 12/18/2012 Dec A/P Legislative breakfast/McKnight 30.00 118.00 NORTHWEST METROPORT CHAMBER 32013 AP 555 12/31/2012 Dec A/P 11/6-12/5 PCards-Schultz 104.97 222.97 JPMORGAN CHASE BANK NA 32065 AP _______________ Account: 135-60075-026-000 Meetings Totals: 156.97 222.97 ** 1,200.00 Budgeted 977.03 Remaining 19 % Used Account: 135-60080-026-000 Schools & Training 580.00 .00 580.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .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: ------------------------------------------------------------------------------------------------ 3,124.52 ** 26,575.00 Budgeted 23,450.48 Remaining 12 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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 609 12/07/2012 12/7/12 Payroll 59,733.29 16,717.85 76,451.14 GL 615 12/21/2012 12/21/12 Payroll 16,821.83 93,272.97 GL _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 33,539.68 93,272.97 ** 444,730.00 Budgeted 351,457.03 Remaining 21 % Used Account: 135-50010-030-000 Overtime 609 12/07/2012 12/7/12 Payroll 49.31 19.38 68.69 GL 615 12/21/2012 12/21/12 Payroll 13.20 81.89 GL _______________ Account: 135-50010-030-000 Overtime Totals: 32.58 81.89 ** 1,500.00 Budgeted 1,418.11 Remaining 5 % Used Account: 135-50016-030-000 Longevity 2,317.50 .00 2,317.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 2,317.50 ** 2,193.00 Budgeted (124.50) Remaining 106 % Used Account: 135-50020-030-000 Retirement 609 12/07/2012 12/7/12 Payroll 53,730.46 2,253.79 55,984.25 GL 615 12/21/2012 12/21/12 Payroll 2,252.57 58,236.82 GL _______________ Account: 135-50020-030-000 Retirement Totals: 4,506.36 58,236.82 ** 60,441.00 Budgeted 2,204.18 Remaining 96 % Used Account: 135-50026-030-000 Medical Insurance 609 12/07/2012 12/7/12 Payroll 6,370.60 1,592.65 7,963.25 GL 615 12/21/2012 12/21/12 Payroll 1,592.65 9,555.90 GL _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,185.30 9,555.90 ** 44,066.00 Budgeted 34,510.10 Remaining 22 % Used Account: 135-50027-030-000 Dental Insurance 609 12/07/2012 12/7/12 Payroll 577.44 144.36 721.80 GL 615 12/21/2012 12/21/12 Payroll 144.36 866.16 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-030-000 Dental Insurance Totals: 288.72 866.16 ** 3,379.00 Budgeted 2,512.84 Remaining 26 % Used Account: 135-50028-030-000 Vision Insurance 609 12/07/2012 12/7/12 Payroll 132.40 33.10 165.50 GL 615 12/21/2012 12/21/12 Payroll 33.10 198.60 GL _______________ Account: 135-50028-030-000 Vision Insurance Totals: 66.20 198.60 ** 795.00 Budgeted 596.40 Remaining 25 % Used Account: 135-50029-030-000 Life Insurance & Other 609 12/07/2012 12/7/12 Payroll 584.92 292.46 877.38 GL 615 12/21/2012 12/21/12 Payroll 292.46 1,169.84 GL _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 584.92 1,169.84 ** 2,500.00 Budgeted 1,330.16 Remaining 47 % Used Account: 135-50030-030-000 Social Security Taxes 609 12/07/2012 12/7/12 Payroll 4,015.01 953.66 4,968.67 GL 615 12/21/2012 12/21/12 Payroll 958.35 5,927.02 GL _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,912.01 5,927.02 ** 27,802.00 Budgeted 21,874.98 Remaining 21 % Used Account: 135-50035-030-000 Medicare Taxes 609 12/07/2012 12/7/12 Payroll 938.99 223.03 1,162.02 GL 615 12/21/2012 12/21/12 Payroll 224.14 1,386.16 GL _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 447.17 1,386.16 ** 6,502.00 Budgeted 5,115.84 Remaining 21 % Used Account: 135-50040-030-000 Unemployment Taxes 609 12/07/2012 12/7/12 Payroll 329.92 12.44 342.36 GL 615 12/21/2012 12/21/12 Payroll 15.54 357.90 GL _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 27.98 357.90 ** 1,537.00 Budgeted 1,179.10 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-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 39.00 .00 39.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 39.00 ** 250.00 Budgeted 211.00 Remaining 16 % Used Account: 135-50070-030-000 Employee Relations 550 12/05/2012 Dec A/P 11/6-12/5 PCards Ard 6.80 6.80 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 10/6-11/5 PCards McKnight 18.25 25.05 JPMORGAN CHASE BANK NA 32029 AP 479 12/18/2012 Dec A/P Christmas hams 897.05 922.10 TOWN OF TROPHY CLUB 32023 AP _______________ Account: 135-50070-030-000 Employee Relations Totals: 922.10 922.10 ** 5,000.00 Budgeted 4,077.90 Remaining 18 % Used Account: 135-55030-030-000 Software & Support 479 12/18/2012 Dec A/P Check Scanner annual maintenan 8,492.02 577.50 9,069.52 TECHNIQUE DATA SYSTEMS INC 32019 AP 555 12/31/2012 Dec A/P STW UB support 606.00 9,675.52 STW INC 32101 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 1,183.50 9,675.52 ** 63,555.00 Budgeted 53,879.48 Remaining 15 % Used Account: 135-55070-030-000 Independent Labor 479 12/18/2012 Dec A/P Record MUD meeting 56.25 56.25 MIGUEL CRUZ 32010 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 56.25 56.25 ** 2,700.00 Budgeted 2,643.75 Remaining 2 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-55100-030-000 Building Maint & Supplies 550 12/05/2012 Dec A/P 10/6-11/5 PCards McMahon 1,508.28 49.54 1,557.82 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 10/6-11/5 PCards Richey 133.46 1,691.28 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 10/6-11/5 PCards Richey 21.43 1,712.71 JPMORGAN CHASE BANK NA 32029 AP 479 12/18/2012 Dec A/P Pest Control 175.00 1,887.71 Exclusive Pest Control 32005 AP 555 12/31/2012 Dec A/P 11/6-12/5 PCards-Schultz 51.94 1,939.65 JPMORGAN CHASE BANK NA 32065 AP 555 12/31/2012 Dec A/P 11/6-12/5 PCards-Schultz 248.00 2,187.65 JPMORGAN CHASE BANK NA 32065 AP 555 12/31/2012 Dec A/P Dec Service 280.60 2,468.25 G & K SERVICES 32057 AP 555 12/31/2012 Dec A/P Building maint 33.61 2,501.86 HOME DEPOT 32063 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 993.58 2,501.86 ** 5,000.00 Budgeted 2,498.14 Remaining 50 % Used Account: 135-55120-030-000 Cleaning Services 550 12/05/2012 Dec A/P 11/6-12/5 PCards Slaght 3,490.68 173.72 3,664.40 JPMORGAN CHASE BANK NA 32029 AP 479 12/18/2012 Dec A/P Dec Cleaning Services 1,678.51 5,342.91 ABM JANITORIAL SERVICES, INC 31997 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,852.23 5,342.91 ** 20,200.00 Budgeted 14,857.09 Remaining 26 % Used Account: 135-55160-030-000 Professional Outside Services 6,825.00 .00 6,825.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 479 12/18/2012 Dec A/P Nov Utility bill printing & ma 1,567.28 496.74 2,064.02 DP2 BILLING SOLUTIONS, LLC 32004 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 496.74 2,064.02 ** 11,000.00 Budgeted 8,935.98 Remaining 19 % Used Account: 135-60005-030-000 Telephone 1,717.10 .00 1,717.10 _______________ Account: 135-60005-030-000 Telephone Totals: .00 1,717.10 ** 9,000.00 Budgeted 7,282.90 Remaining 19 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 609 12/07/2012 12/7/12 Payroll 477.04 150.00 627.04 GL 555 12/31/2012 Dec A/P Cell phones 177.04 804.08 VERIZON WIRELESS 32110 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 327.04 804.08 ** 3,575.00 Budgeted 2,770.92 Remaining 22 % Used Account: 135-60020-030-000 Electricity/Gas 479 12/18/2012 Dec A/P Electricity 10/12-11/12 942.99 989.59 1,932.58 DIRECT ENERGY BUSINESS SVCS 32003 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 989.59 1,932.58 ** 13,019.00 Budgeted 11,086.42 Remaining 15 % Used Account: 135-60025-030-000 Water 479 12/18/2012 Dec A/P Nov Water 125.06 111.46 236.52 TROPHY CLUB MUD (WATER BILLS) 32025 AP 555 12/31/2012 Dec A/P Dec Water 84.36 320.88 TROPHY CLUB MUD (WATER BILLS) 32108 AP _______________ Account: 135-60025-030-000 Water Totals: 195.82 320.88 ** 3,100.00 Budgeted 2,779.12 Remaining 10 % Used Account: 135-60030-030-000 Rent And/Or Usage 479 12/18/2012 Dec A/P Dec Public Services buidling r 2,197.02 1,098.51 3,295.53 TOWN OF TROPHY CLUB 32022 AP _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: 1,098.51 3,295.53 ** 13,182.00 Budgeted 9,886.47 Remaining 25 % Used Account: 135-60035-030-000 Postage . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 479 12/18/2012 Dec A/P Overnight shipments 4,410.26 22.42 4,432.68 FEDERAL EXPRESS CORP 32006 AP 479 12/18/2012 Dec A/P Nov Utility bill printing & ma 1,720.90 6,153.58 DP2 BILLING SOLUTIONS, LLC 32004 AP 555 12/31/2012 Dec A/P Overnight paperwork to Commerc 31.89 6,185.47 FEDERAL EXPRESS CORP 32052 AP 555 12/31/2012 Dec A/P Postage meter lease 133.50 6,318.97 PITNEY BOWES INC 32093 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,908.71 6,318.97 ** 23,000.00 Budgeted 16,681.03 Remaining 27 % Used Account: 135-60040-030-000 Service Charges & Fees 598 12/04/2012 Credit card charges 5,381.46 2,005.25 7,386.71 GL 599 12/31/2012 Dec Bank Analysis Charge 250.00 7,636.71 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,255.25 7,636.71 ** 18,000.00 Budgeted 10,363.29 Remaining 42 % Used Account: 135-60050-030-000 Bad Debt Expense (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 550 12/05/2012 Dec A/P 10/6-11/5 PCards Gonzales 60,601.92 3.58 60,605.50 JPMORGAN CHASE BANK NA 32029 AP 555 12/31/2012 Dec A/P Blanket notary 23.27 60,628.77 CNA SURETY 32041 AP 578 12/31/2012 V Schinerer/Refund overpmt (35.00) 60,593.77 GL _______________ Account: 135-60055-030-000 Insurance Totals: (8.15) 60,593.77 ** 35,000.00 Budgeted (25,593.77) Remaining 173 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 558.22 .00 558.22 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 558.22 ** 750.00 Budgeted 191.78 Remaining 74 % Used Account: 135-60070-030-000 Dues & Memberships 479 12/18/2012 Dec A/P Membership 650.00 250.00 900.00 NORTHWEST METROPORT CHAMBER 32013 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 250.00 900.00 ** 2,400.00 Budgeted 1,500.00 Remaining 38 % Used Account: 135-60075-030-000 Meetings 479 12/18/2012 Dec A/P Legislative breakfast/McKnight 88.00 30.00 118.00 NORTHWEST METROPORT CHAMBER 32013 AP _______________ Account: 135-60075-030-000 Meetings Totals: 30.00 118.00 ** 250.00 Budgeted 132.00 Remaining 47 % Used Account: 135-60080-030-000 Schools & Training 479 12/18/2012 Dec A/P Symposium Registration/McKnigh 450.00 120.00 570.00 NCT CHAPTER OF TEXAS AWWA 32011 AP _______________ Account: 135-60080-030-000 Schools & Training Totals: 120.00 570.00 ** 5,500.00 Budgeted 4,930.00 Remaining 10 % Used Account: 135-60100-030-000 Travel & per diem 550 12/05/2012 Dec A/P 10/6-11/5 PCards McKnight 49.60 333.06 382.66 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 11/6-12/5 PCards Slaght 32.18 414.84 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 11/6-12/5 PCards Slaght 2.71 417.55 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 11/6-12/5 PCards Slaght 5.62 423.17 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 11/6-12/5 PCards Slaght 19.67 442.84 JPMORGAN CHASE BANK NA 32029 AP 550 12/05/2012 Dec A/P 11/6-12/5 PCards Slaght 248.40 691.24 JPMORGAN CHASE BANK NA 32029 AP 555 12/31/2012 Dec A/P Austin Tolls 2.95 694.19 Texas Tollways 32105 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 644.59 694.19 ** 3,950.00 Budgeted 3,255.81 Remaining 18 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/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-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 122.13 .00 122.13 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 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 550 12/05/2012 Dec A/P 10/6-11/5 PCards McKnight 265.00 2,060.00 2,325.00 JPMORGAN CHASE BANK NA 32029 AP _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 2,060.00 2,325.00 ** 2,500.00 Budgeted 175.00 Remaining 93 % Used Account: 135-65010-030-000 Uniforms 624.12 .00 624.12 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 624.12 ** 1,635.00 Budgeted 1,010.88 Remaining 38 % Used Account: 135-65055-030-000 Hardware 6,288.27 .00 6,288.27 _______________ Account: 135-65055-030-000 Hardware Totals: .00 6,288.27 ** 20,188.00 Budgeted 13,899.73 Remaining 31 % Used Account: 135-65085-030-000 Office Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,852.62 .00 1,852.62 _______________ Account: 135-65085-030-000 Office Supplies Totals: .00 1,852.62 ** 8,200.00 Budgeted 6,347.38 Remaining 23 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 555 12/31/2012 Dec A/P Printer supplies 511.00 91.00 602.00 SHI GOVERNMENT SOLUTIONS,INC 32097 AP 555 12/31/2012 Dec A/P Print & Toner cartridges 155.50 757.50 SHI GOVERNMENT SOLUTIONS,INC 32097 AP 555 12/31/2012 Dec A/P Toner cartridge 142.50 900.00 SHI GOVERNMENT SOLUTIONS,INC 32097 AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 389.00 900.00 ** 5,732.00 Budgeted 4,832.00 Remaining 16 % Used Account: 135-65095-030-000 Maintenance Supplies 550 12/05/2012 Dec A/P 11/6-12/5 PCards Huggins 97.40 40.23 137.63 JPMORGAN CHASE BANK NA 32029 AP 555 12/31/2012 Dec A/P 11/6-12/5 PCards-Schultz 131.58 269.21 JPMORGAN CHASE BANK NA 32065 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 171.81 269.21 ** 2,000.00 Budgeted 1,730.79 Remaining 13 % 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 395.00 .00 395.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 395.00 ** 5,200.00 Budgeted 4,805.00 Remaining 8 % Used Account: 135-69170-030-000 Copier Lease Installments 555 12/31/2012 Dec A/P Copier lease 513.70 513.70 1,027.40 KYOCERA MITA AMERICA, INC. 32070 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 513.70 1,027.40 ** 3,450.00 Budgeted 2,422.60 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69195-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 Department 30 Totals: ------------------------------------------------------------------------------------------------ 299,995.44 ** 1,051,838.00 Budgeted 751,842.56 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/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 479 12/18/2012 Dec A/P Nov legal 5,768.75 4,826.05 10,594.80 WHITAKER CHALK SWINDLE 32027 AP 479 12/18/2012 Dec A/P Legal/CCN 7,308.39 17,903.19 BOOTH, AHRENS & WERKENTHIN PC 31999 AP 479 12/18/2012 Dec A/P Nov Legal 3,217.50 21,120.69 THE LISTON LAW FIRM, P.C. 32020 AP 555 12/31/2012 Dec A/P Nov legal 607.75 21,728.44 BOOTH, AHRENS & WERKENTHIN PC 32037 AP _______________ Account: 135-55045-039-000 Legal Totals: 15,959.69 21,728.44 ** 70,000.00 Budgeted 48,271.56 Remaining 31 % Used Account: 135-55055-039-000 Auditing 5,175.00 .00 5,175.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 5,175.00 ** 21,200.00 Budgeted 16,025.00 Remaining 24 % Used Account: 135-55060-039-000 Appraisal 479 12/18/2012 Dec A/P 1st Qtr DCAD 2013 budget 2,322.74 1,943.16 4,265.90 DENTON CENTRAL APPRAISAL DISTR 32002 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,943.16 4,265.90 ** 15,100.00 Budgeted 10,834.10 Remaining 28 % 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: ------------------------------------------------------------------------------------------------ 31,169.34 ** 110,100.00 Budgeted 78,930.66 Remaining 28 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (88,100.24) .00 Budgeted 88,100.24 Remaining 0 % Used Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 12/31/2012 ASSETS ASSETS CASH AND CASH IN BANK 6,120$ INVESTMENTS 229,713 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 115,461 TOTAL ASSETS 351,294$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 115,461$ TOTAL LIABILITIES 115,461 FUND BALANCE ASSIGNED FUND BALANCE 235,833 TOTAL LIABILITIES AND FUND BALANCE 351,294$ December 31, 2012 3/12 Months (25% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 14:37 01/10/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 12/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- 80,341.63- 95,838.02- 48.664 101,101.98- 533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 265.83- 2,550.65- 65.401 1,349.35- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 68.64- 970.69- 19.348 4,046.31- Subtotal: 205,857.00- 205,857.00- 80,676.10- 99,359.36- 48.266 106,497.64- 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- 20.07- 56.77- 3.339 1,643.23- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- Subtotal: 309,700.00- 309,700.00- 20.07- 56.77- .018 309,643.23- Program number: 860,557.00- 860,557.00- 80,696.17- 99,416.13- 11.553 761,140.87- Department number: Revenues 860,557.00- 860,557.00- 80,696.17- 99,416.13- 11.553 761,140.87- Revenues Subtotal ----------- 860,557.00- 860,557.00- 80,696.17- 99,416.13- 11.553 761,140.87- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 14:37 01/10/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 12/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- 80,696.17- 99,416.13- 441.379 76,892.13 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 12/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 559 12/03/2012 Property Taxes & Assessments (15,496.39) (934.18) (16,430.57) GL 560 12/04/2012 Property Taxes & Assessments (691.67) (17,122.24) GL 561 12/05/2012 Property Taxes & Assessments (682.23) (17,804.47) GL 562 12/06/2012 Property Taxes & Assessments (561.27) (18,365.74) GL 563 12/07/2012 Property Taxes & Assessments (960.82) (19,326.56) GL 564 12/10/2012 Property Taxes & Assessments (931.23) (20,257.79) GL 565 12/11/2012 Property Taxes & Assessments (634.08) (20,891.87) GL 566 12/12/2012 Property Taxes & Assessments (378.16) (21,270.03) GL 567 12/13/2012 Property Taxes & Assessments (867.41) (22,137.44) GL 568 12/14/2012 Property Taxes/Assessments (514.46) (22,651.90) GL 569 12/17/2012 Property Taxes/Assessments (1,124.58) (23,776.48) GL 570 12/18/2012 Property Taxes/Assessments (1,913.34) (25,689.82) GL 571 12/19/2012 Property Taxes/Assessments (12,394.48) (38,084.30) GL 572 12/20/2012 Property Taxes/Assessments (954.10) (39,038.40) GL 573 12/21/2012 Property Taxes/Assessments (1,816.32) (40,854.72) GL 574 12/27/2012 Property Taxes/Assessments (22,124.67) (62,979.39) GL 575 12/29/2012 Property Taxes/Assessments (5,420.32) (68,399.71) GL 576 12/31/2012 Property Taxes/Assessments (27,438.31) (95,838.02) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (80,341.63) (95,838.02) ** (196,940.00) Budgeted (101,101.98) Remaining 49 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 561 12/05/2012 Property Taxes & Assessments (2,284.82) (50.42) (2,335.24) GL 572 12/20/2012 Property Taxes/Assessments (218.20) (2,553.44) GL 576 12/31/2012 Property Taxes/Assessments 2.79 (2,550.65) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (265.83) (2,550.65) ** (3,900.00) Budgeted (1,349.35) Remaining 65 % Used Account: 533-40015-000-000 Property Taxes/P & I 561 12/05/2012 Property Taxes & Assessments (902.05) (18.46) (920.51) GL 572 12/20/2012 Property Taxes/Assessments (50.18) (970.69) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (68.64) (970.69) ** (5,017.00) Budgeted (4,046.31) Remaining 19 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 12/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 533-48005-000-000 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 597 12/31/2012 Dec Bank Interest (36.70) (20.07) (56.77) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (20.07) (56.77) ** (1,700.00) Budgeted (1,643.23) Remaining 3 % 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: ------------------------------------------------------------------------------------------------ (99,416.13) ** (860,557.00) Budgeted (761,140.87) Remaining 12 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 14:38 01/10/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 12/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: ------------------------------------------------------------------------------------------------------ (99,416.13) (22,524.00) Budgeted 76,892.13 Remaining 441 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (689,909.10) **** (22,524.00) Budgeted 667,385.10 Remaining ########## ******* End of Report *********