Loading...
HomeMy WebLinkAboutJanuary Financials Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 1/31/2013 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 1,177,287 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 293,450 ACCOUNTS RECEIVABLE - PID EMER SERVICES 34,232 OTHER RECEIVABLES 24,659 TOTAL ASSETS 1,529,628$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 327,682$ ACCOUNTS PAYABLE 84,231 TOTAL LIABILITIES 411,913$ FUND BALANCE UNASSIGNED FUND BALANCE 1,117,715 TOTAL LIABILITIES AND FUND BALANCE 1,529,628$ January 31, 2013 4/12 Months (33.3% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 17:19 02/14/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2013 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- 39,365.25- 218,628.40- 86.728 33,455.60- 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- 279,298.15- 790,434.55- 75.254 259,914.45- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 430.02 3,675.62- 63.373 2,124.38- 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- 2.18- 1,574.28- 34.984 2,925.72- Subtotal: 1,318,183.00- 1,318,183.00- 318,235.56- 1,014,319.29- 76.948 303,863.71- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 1,200.00- 20.000 4,800.00- Subtotal: 6,000.00- 6,000.00- 400.00- 1,200.00- 20.000 4,800.00- 122-43400-000-000 Fire Inspections 500.00- 500.00- 75.00- 225.00- 45.000 275.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,500.00- 10,500.00- 10,075.00- 10,225.00- 97.381 275.00- 122-49900-000-000 Miscellaneous Income 1,200.00- 1,200.00- 525.00- 1,989.26- 165.772 789.26 Subtotal: 1,200.00- 1,200.00- 525.00- 1,989.26- 165.772 789.26 Program number: 1,335,883.00- 1,335,883.00- 329,235.56- 1,027,733.55- 76.933 308,149.45- Department number: Fire Revenues 1,335,883.00- 1,335,883.00- 329,235.56- 1,027,733.55- 76.933 308,149.45- Revenues Subtotal ----------- 1,335,883.00- 1,335,883.00- 329,235.56- 1,027,733.55- 76.933 308,149.45- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 17:19 02/14/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2013 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 33,622.98 126,018.66 28.337 318,698.34 122-50010-045-000 Overtime 31,375.00 31,375.00 2,750.02 13,186.94 42.030 18,188.06 122-50011-045-000 DPS Holiday Pay 13,083.00 13,083.00 12,080.51 92.337 1,002.49 122-50016-045-000 Longevity 4,266.00 4,266.00 4,266.11 100.003 .11- 122-50017-045-000 Certification 4,896.00 4,896.00 293.25 2,018.25 41.222 2,877.75 122-50020-045-000 Retirement 69,242.00 69,242.00 5,031.72 22,980.06 33.188 46,261.94 122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,551.15 13,560.54 28.060 34,766.46 122-50027-045-000 Dental Insurance 3,635.00 3,635.00 327.35 1,263.22 34.752 2,371.78 122-50028-045-000 Vision Insurance 824.00 824.00 67.52 259.83 31.533 564.17 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 605.52 1,775.80 41.784 2,474.20 122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 2,082.51 9,735.68 31.510 21,161.32 122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 487.02 2,276.86 31.509 4,949.14 122-50040-045-000 Unemployment Taxes 1,481.00 1,481.00 1,063.31 1,101.73 74.391 379.27 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 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 49,882.35 220,674.64 32.625 455,719.36 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 1,182.05 2,316.45 24.226 7,245.55 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 133.62 1,989.05 13.394 12,860.95 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 244.50 937.00 14.415 5,563.00 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 1,560.17 5,242.50 11.828 39,080.50 122-60005-045-000 Telephone 106.00 106.00 7.47 20.48 19.321 85.52 122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 2,500.00 76.50 1,901.02 76.041 598.98 122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 75.57 2,275.39 36.896 3,891.61 122-60025-045-000 Water 1,400.00 1,400.00 87.42 546.46 39.033 853.54 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 54.60 54.600 45.40 122-60055-045-000 Insurance 10,000.00 10,000.00 9,950.00 10,000.00 100.000 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 280.00 7,685.91 102.479 185.91- 122-60075-045-000 Meetings 75.00 75.00 75.00 122-60080-045-000 Schools & Training 5,000.00 5,000.00 564.00 1,419.00 28.380 3,581.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 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 17:19 02/14/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2013 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 180.00- 333.73 17.565 1,566.27 122-60195-045-000 Flags & Repair 2,543.00 2,543.00 224.75 8.838 2,318.25 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 451.98 36.538 785.02 Subtotal: 359,088.00 359,088.00 10,860.96 29,046.80 8.089 330,041.20 122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 631.72 3,232.24 32.322 6,767.76 122-65010-045-000 Uniforms 4,357.00 4,357.00 553.88 845.63 19.409 3,511.37 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 65.00 65.00 .855 7,535.00 122-65030-045-000 Chemicals 1,000.00 1,000.00 402.00 402.00 40.200 598.00 122-65035-045-000 Small Tools 5,000.00 5,000.00 26.50 257.38 5.148 4,742.62 122-65085-045-000 Office Supplies 1,200.00 1,200.00 59.74 80.45 6.704 1,119.55 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 352.95 653.89 23.479 2,131.11 122-65105-045-000 Printing 106.00 106.00 106.00 Subtotal: 32,048.00 32,048.00 2,091.79 5,536.59 17.276 26,511.41 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 13.61 13.61 .544 2,486.39 122-69195-045-000 GASB34/Reserve for Replacement 145,598.00 145,598.00 145,598.00 Subtotal: 224,030.00 224,030.00 13.61 13.61 .006 224,016.39 Program number: 1,335,883.00 1,335,883.00 64,408.88 260,514.14 19.501 1,075,368.86 Department number: Fire 1,335,883.00 1,335,883.00 64,408.88 260,514.14 19.501 1,075,368.86 Expenditures Subtotal ----------- 1,335,883.00 1,335,883.00 64,408.88 260,514.14 19.501 1,075,368.86 Fund number: 122 Trophy Club MUD Fire Dept. 264,826.68- 767,219.41- 767,219.41 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2013 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 771 01/02/2013 Property Taxes/Assessments (179,263.15) (1,091.83) (180,354.98) GL 772 01/03/2013 Property Taxes/Assessments (3,905.15) (184,260.13) GL 773 01/04/2013 Property Taxes/Assessments (1,445.70) (185,705.83) GL 776 01/07/2013 Property Taxes/Assessments (2,205.55) (187,911.38) GL 777 01/08/2013 Property Taxes/Assessments (7,562.39) (195,473.77) GL 784 01/09/2013 Property Taxes/Assessments (646.97) (196,120.74) GL 785 01/10/2013 Property Taxes/Assessments (1,102.81) (197,223.55) GL 786 01/11/2013 Property Taxes/Assessments (2,385.63) (199,609.18) GL 787 01/14/2013 Property Taxes/Assessments (3,113.48) (202,722.66) GL 788 01/15/2013 Property Taxes/Assessments (1,000.25) (203,722.91) GL 790 01/16/2013 Property Taxes/Assessments (357.23) (204,080.14) GL 789 01/17/2013 Property Taxes/Assessments (1,686.51) (205,766.65) GL 791 01/18/2013 Property Taxes/Assessments (1.56) (205,768.21) GL 792 01/22/2013 Property Taxes/Assessments (1,152.90) (206,921.11) GL 793 01/23/2013 Property Taxes/Assessments (1,975.81) (208,896.92) GL 794 01/24/2013 Property Taxes/Assessments (1,539.46) (210,436.38) GL 795 01/25/2013 Property Taxes/Assessments (1,799.77) (212,236.15) GL 796 01/28/2013 Property Taxes/Assessments (2,695.50) (214,931.65) GL 797 01/29/2013 Property Taxes/Assessments (1,865.69) (216,797.34) GL 798 01/30/2013 Property Taxes/Assessments (1,831.06) (218,628.40) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (39,365.25) (218,628.40) ** (252,084.00) Budgeted (33,455.60) Remaining 87 % 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 771 01/02/2013 Property Taxes/Assessments (511,136.40) (9,221.57) (520,357.97) GL 772 01/03/2013 Property Taxes/Assessments (28,145.14) (548,503.11) GL 773 01/04/2013 Property Taxes/Assessments (22,073.08) (570,576.19) GL 776 01/07/2013 Property Taxes/Assessments (9,222.84) (579,799.03) GL 777 01/08/2013 Property Taxes/Assessments (17,262.00) (597,061.03) GL 784 01/09/2013 Property Taxes/Assessments (3,264.77) (600,325.80) GL 785 01/10/2013 Property Taxes/Assessments (10,270.70) (610,596.50) GL 786 01/11/2013 Property Taxes/Assessments (8,910.46) (619,506.96) GL 787 01/14/2013 Property Taxes/Assessments (20,790.75) (640,297.71) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 788 01/15/2013 Property Taxes/Assessments (511,136.40) (13,757.58) (654,055.29) GL 790 01/16/2013 Property Taxes/Assessments (5,499.26) (659,554.55) GL 789 01/17/2013 Property Taxes/Assessments (16,623.65) (676,178.20) GL 791 01/18/2013 Property Taxes/Assessments (18,138.81) (694,317.01) GL 792 01/22/2013 Property Taxes/Assessments (4,258.27) (698,575.28) GL 793 01/23/2013 Property Taxes/Assessments (8,772.72) (707,348.00) GL 794 01/24/2013 Property Taxes/Assessments (23,598.22) (730,946.22) GL 795 01/25/2013 Property Taxes/Assessments (11,580.53) (742,526.75) GL 796 01/28/2013 Property Taxes/Assessments (23,323.44) (765,850.19) GL 797 01/29/2013 Property Taxes/Assessments (20,572.07) (786,422.26) GL 798 01/30/2013 Property Taxes/Assessments (4,012.29) (790,434.55) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (279,298.15) (790,434.55) ** (1,050,349.00) Budgeted (259,914.45) Remaining 75 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 797 01/29/2013 Property Taxes/Assessments (4,105.64) (4.66) (4,110.30) GL 813 01/31/2013 Jan A/P FKA2 shortage due to refund 434.68 (3,675.62) DENTON COUNTY TAX OFFICE 32177 AP _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 430.02 (3,675.62) ** (5,800.00) Budgeted (2,124.38) Remaining 63 % 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 797 01/29/2013 Property Taxes/Assessments (1,572.10) (2.18) (1,574.28) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (2.18) (1,574.28) ** (4,500.00) Budgeted (2,925.72) Remaining 35 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 878 01/31/2013 January A/R billed to Town AR 20130130-20130131 User: (800.00) (400.00) (1,200.00) AR _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (1,200.00) ** (6,000.00) Budgeted (4,800.00) Remaining 20 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-43400-000-000 Fire Inspections 878 01/31/2013 January A/R billed to Town AR 20130130-20130131 User: (150.00) (75.00) (225.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (225.00) ** (500.00) Budgeted (275.00) Remaining 45 % Used Account: 122-43415-000-000 Denton County Pledge-Fire 684 01/19/2013 Denton County Fire Pledge (10,000.00) (10,000.00) GL _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: (10,000.00) (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49900-000-000 Miscellaneous Income 878 01/31/2013 January A/R billed to Town AR 20130130-20130131 User: (1,464.26) (525.00) (1,989.26) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (525.00) (1,989.26) ** (1,200.00) Budgeted 789.26 Remaining 166 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,027,733.55) ** (1,335,883.00) Budgeted (308,149.45) Remaining 77 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2013 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 755 01/04/2013 Payroll 1/4/13 92,395.68 16,522.31 108,917.99 GL 837 01/18/2013 Payroll 1/18/13 17,100.67 126,018.66 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 33,622.98 126,018.66 ** 444,717.00 Budgeted 318,698.34 Remaining 28 % Used Account: 122-50010-045-000 Overtime 837 01/18/2013 Payroll 1/18/13 10,436.92 2,750.02 13,186.94 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,750.02 13,186.94 ** 31,375.00 Budgeted 18,188.06 Remaining 42 % Used Account: 122-50011-045-000 DPS Holiday Pay 12,080.51 .00 12,080.51 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 12,080.51 ** 13,083.00 Budgeted 1,002.49 Remaining 92 % Used Account: 122-50016-045-000 Longevity 4,266.11 .00 4,266.11 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,266.11 ** 4,266.00 Budgeted (.11) Remaining 100 % Used Account: 122-50017-045-000 Certification 755 01/04/2013 Payroll 1/4/13 1,725.00 293.25 2,018.25 GL _______________ Account: 122-50017-045-000 Certification Totals: 293.25 2,018.25 ** 4,896.00 Budgeted 2,877.75 Remaining 41 % Used Account: 122-50020-045-000 Retirement 755 01/04/2013 Payroll 1/4/13 17,948.34 2,341.92 20,290.26 GL 837 01/18/2013 Payroll 1/18/13 2,689.80 22,980.06 GL _______________ Account: 122-50020-045-000 Retirement Totals: 5,031.72 22,980.06 ** 69,242.00 Budgeted 46,261.94 Remaining 33 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 755 01/04/2013 Payroll 1/4/13 10,009.39 1,775.58 11,784.97 GL 837 01/18/2013 Payroll 1/18/13 1,775.57 13,560.54 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,551.15 13,560.54 ** 48,327.00 Budgeted 34,766.46 Remaining 28 % Used Account: 122-50027-045-000 Dental Insurance 755 01/04/2013 Payroll 1/4/13 935.87 163.65 1,099.52 GL 837 01/18/2013 Payroll 1/18/13 163.70 1,263.22 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 327.35 1,263.22 ** 3,635.00 Budgeted 2,371.78 Remaining 35 % Used Account: 122-50028-045-000 Vision Insurance 755 01/04/2013 Payroll 1/4/13 192.31 33.76 226.07 GL 837 01/18/2013 Payroll 1/18/13 33.76 259.83 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 67.52 259.83 ** 824.00 Budgeted 564.17 Remaining 32 % Used Account: 122-50029-045-000 Life Insurance & Other 755 01/04/2013 Payroll 1/4/13 1,170.28 302.76 1,473.04 GL 837 01/18/2013 Payroll 1/18/13 302.76 1,775.80 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 605.52 1,775.80 ** 4,250.00 Budgeted 2,474.20 Remaining 42 % Used Account: 122-50030-045-000 Social Security Taxes 755 01/04/2013 Payroll 1/4/13 7,653.17 947.16 8,600.33 GL 837 01/18/2013 Payroll 1/18/13 1,135.35 9,735.68 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,082.51 9,735.68 ** 30,897.00 Budgeted 21,161.32 Remaining 32 % Used Account: 122-50035-045-000 Medicare Taxes 755 01/04/2013 Payroll 1/4/13 1,789.84 221.51 2,011.35 GL 837 01/18/2013 Payroll 1/18/13 265.51 2,276.86 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 487.02 2,276.86 ** 7,226.00 Budgeted 4,949.14 Remaining 32 % Used Account: 122-50040-045-000 Unemployment Taxes 755 01/04/2013 Payroll 1/4/13 38.42 487.66 526.08 GL 837 01/18/2013 Payroll 1/18/13 575.65 1,101.73 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 1,063.31 1,101.73 ** 1,481.00 Budgeted 379.27 Remaining 74 % 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 150.45 .00 150.45 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 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 Account: 122-55080-045-000 Maintenance & Repairs 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Hurd 1,134.40 76.00 1,210.40 JPMORGAN CHASE BANK NA 32120 AP 720 01/27/2013 Jan A/P Mats-Fire station 23.18 1,233.58 G & K SERVICES 32134 AP 720 01/27/2013 Jan A/P Mats-Fire station 23.18 1,256.76 G & K SERVICES 32134 AP 720 01/27/2013 Jan A/P STRAPS FOR SCBA MASKS 113.69 1,370.45 MUNICIPAL EMERGENCY SERVICES 32140 AP 813 01/31/2013 Jan A/P NFPA Aerial and ground ladder 946.00 2,316.45 CONSOLIDATED FLEET SERVICES 32174 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,182.05 2,316.45 ** 9,562.00 Budgeted 7,245.55 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55090-045-000 Vehicle Maintenance 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Hurd 1,855.43 42.57 1,898.00 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Hurd 91.05 1,989.05 JPMORGAN CHASE BANK NA 32120 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 133.62 1,989.05 ** 14,850.00 Budgeted 12,860.95 Remaining 13 % 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 583 01/05/2013 Jan Cable/Firefighters 692.50 (120.00) 572.50 GL 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Jaramillo 72.99 645.49 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Thomas 133.68 779.17 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Thomas 157.83 937.00 JPMORGAN CHASE BANK NA 32120 AP _______________ Account: 122-55100-045-000 Building Maintenance Totals: 244.50 937.00 ** 6,500.00 Budgeted 5,563.00 Remaining 14 % Used Account: 122-55110-045-000 Maintenance-Radios .00 .00 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 .00 ** 1,103.00 Budgeted 1,103.00 Remaining 0 % Used Account: 122-55160-045-000 Professional Outside Services .00 .00 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 122-60005-045-000 Telephone 640 01/10/2013 Jan A/P PCards 11/28-12/27 Zieverink 13.01 7.47 20.48 BANK OF AMERICA 32115 AP _______________ Account: 122-60005-045-000 Telephone Totals: 7.47 20.48 ** 106.00 Budgeted 85.52 Remaining 19 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60010-045-000 Communications/Pagers/Mobiles 755 01/04/2013 Payroll 1/4/13 1,824.52 76.50 1,901.02 GL _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 76.50 1,901.02 ** 2,500.00 Budgeted 598.98 Remaining 76 % Used Account: 122-60020-045-000 Electricity/Gas 686 01/19/2013 Town Inv 2013-003/Dec Electricity/Fire Station 2,199.82 (398.96) 1,800.86 GL 702 01/23/2013 Correction to Inv 1762/Town AR 20130123-20130123 User: (438.38) 1,362.48 AR 720 01/27/2013 Jan A/P Electricity 12/13-1/14 8.24 1,370.72 HUDSON ENERGY 32135 AP 720 01/27/2013 Jan A/P Electricity 12/13-1/14 438.38 1,809.10 HUDSON ENERGY 32135 AP 720 01/27/2013 Jan A/P Gas Fire Station 12/18-1/17 233.15 2,042.25 ATMOS ENERGY 32124 AP 720 01/27/2013 Jan A/P Gas Fire Station 12/18-1/17 233.14 2,275.39 ATMOS ENERGY 32124 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 75.57 2,275.39 ** 6,167.00 Budgeted 3,891.61 Remaining 37 % Used Account: 122-60025-045-000 Water 813 01/31/2013 Jan A/P Jan water 459.04 162.12 621.16 TROPHY CLUB MUD (WATER BILLS) 32201 AP 813 01/31/2013 Jan A/P Jan water 12.71 633.87 TROPHY CLUB MUD (WATER BILLS) 32201 AP 878 01/31/2013 January A/R billed to Town AR 20130130-20130131 User: (87.41) 546.46 AR _______________ Account: 122-60025-045-000 Water Totals: 87.42 546.46 ** 1,400.00 Budgeted 853.54 Remaining 39 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 308,000.00 Budgeted 308,000.00 Remaining 0 % Used Account: 122-60035-045-000 Postage 54.60 .00 54.60 _______________ Account: 122-60035-045-000 Postage Totals: .00 54.60 ** 100.00 Budgeted 45.40 Remaining 55 % Used Account: 122-60055-045-000 Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 753 01/31/2013 Allocate FD TML Ins pd by MUD 50.00 9,950.00 10,000.00 GL _______________ Account: 122-60055-045-000 Insurance Totals: 9,950.00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % 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 813 01/31/2013 Jan A/P Annual dues 7,405.91 280.00 7,685.91 DENTON CO FIRE CHIEFS ASSOC 32175 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 280.00 7,685.91 ** 7,500.00 Budgeted (185.91) Remaining 102 % 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 813 01/31/2013 Jan A/P TCCC Live fire training 855.00 564.00 1,419.00 NORTH EAST FIRE DEPT ASSOC 32188 AP _______________ Account: 122-60080-045-000 Schools & Training Totals: 564.00 1,419.00 ** 5,000.00 Budgeted 3,581.00 Remaining 28 % 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 812.19 .00 812.19 . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 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 687 01/04/2013 Void A/P Ck 32106/dupe pmt TCLEDDS Subscription renewal 513.73 (180.00) 333.73 THE PRODUCTIVITY CENTER 32106 AP _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: (180.00) 333.73 ** 1,900.00 Budgeted 1,566.27 Remaining 18 % Used Account: 122-60195-045-000 Flags & Repair 224.75 .00 224.75 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 224.75 ** 2,543.00 Budgeted 2,318.25 Remaining 9 % Used Account: 122-60245-045-000 Miscellaneous Expense 451.98 .00 451.98 . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 451.98 ** 1,237.00 Budgeted 785.02 Remaining 37 % Used Account: 122-65005-045-000 Fuel & Lube 804 01/31/2013 January Gas log 2,600.52 631.72 3,232.24 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 631.72 3,232.24 ** 10,000.00 Budgeted 6,767.76 Remaining 32 % Used Account: 122-65010-045-000 Uniforms 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Beck 291.75 209.00 500.75 JPMORGAN CHASE BANK NA 32120 AP 720 01/27/2013 Jan A/P Shirt/Peters, Conditt 89.73 590.48 MUNICIPAL EMERGENCY SERVICES 32141 AP 813 01/31/2013 Jan A/P Fire fighter pants/Conditt 255.15 845.63 GST PUBLIC SAFETY SUPPLY 32182 AP _______________ Account: 122-65010-045-000 Uniforms Totals: 553.88 845.63 ** 4,357.00 Budgeted 3,511.37 Remaining 19 % Used Account: 122-65015-045-000 Protective Clothing 720 01/27/2013 Jan A/P Gloves/C Cloud 65.00 65.00 CASCO INDUSTRIES INC 32127 AP _______________ Account: 122-65015-045-000 Protective Clothing Totals: 65.00 65.00 ** 7,600.00 Budgeted 7,535.00 Remaining 1 % Used Account: 122-65030-045-000 Chemicals 720 01/27/2013 Jan A/P Fire suppresion foam 402.00 402.00 CASCO INDUSTRIES INC 32127 AP _______________ Account: 122-65030-045-000 Chemicals Totals: 402.00 402.00 ** 1,000.00 Budgeted 598.00 Remaining 40 % Used Account: 122-65035-045-000 Small Tools 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Hurd 230.88 26.50 257.38 JPMORGAN CHASE BANK NA 32120 AP _______________ Account: 122-65035-045-000 Small Tools Totals: 26.50 257.38 ** 5,000.00 Budgeted 4,742.62 Remaining 5 % Used Account: 122-65085-045-000 Office Supplies . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 720 01/27/2013 Jan A/P Office Supplies 20.71 67.69 88.40 OFFICE DEPOT, INC 32142 AP 720 01/27/2013 Jan A/P Legal paper returned (52.49) 35.91 OFFICE DEPOT, INC 32142 AP 720 01/27/2013 Jan A/P Office Supplies 36.12 72.03 OFFICE DEPOT, INC 32142 AP 720 01/27/2013 Jan A/P Office Supplies 8.42 80.45 OFFICE DEPOT, INC 32142 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 59.74 80.45 ** 1,200.00 Budgeted 1,119.55 Remaining 7 % Used Account: 122-65095-045-000 Maintenance Supplies 715 01/25/2013 Jan A/P 12/6-1/5 PCards-Schultz 300.94 210.66 511.60 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards-Schultz 142.29 653.89 JPMORGAN CHASE BANK NA 32120 AP _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: 352.95 653.89 ** 2,785.00 Budgeted 2,131.11 Remaining 23 % 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 .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 720 01/27/2013 Jan A/P Ship radios 13.61 13.61 FEDERAL EXPRESS CORP 32133 AP _______________ Account: 122-69050-045-000 Radios Totals: 13.61 13.61 ** 2,500.00 Budgeted 2,486.39 Remaining 1 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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: ------------------------------------------------------------------------------------------------ 260,514.14 ** 1,335,883.00 Budgeted 1,075,368.86 Remaining 20 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (767,219.41) .00 Budgeted 767,219.41 Remaining 0 % Used Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 1/31/2013 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 189,606 INVESTMENTS 2,621,733 RESTRICTED ASSETS: INVESTMENTS 430,441 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 27,589 UTILITY AND OTHER ACCOUNTS RECEIVABLE 508,079 TOTAL ASSETS 3,777,848$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 27,589$ ACCOUNTS PAYABLE 480,092 CUSTOMER DEPOSITS 216,192 TOTAL LIABILITIES 723,873 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,282,191 TOTAL FUND BALANCE 3,053,975 TOTAL LIABILITIES AND FUND BALANCE 3,777,848$ January 31, 2013 4/12 Months (33.3% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 17:19 02/14/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2013 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- 26,560.16- 75,167.23- 75.255 24,716.77- 135-40002-000-000 Property Taxes/Delinquent 500.00- 500.00- 106.93 605.50- 121.100 105.50 135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 26.96- 520.16- 43.347 679.84- Subtotal: 101,584.00- 101,584.00- 26,480.19- 76,292.89- 75.103 25,291.11- 135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 170,881.30- 924,051.75- 26.062 2,621,557.25- 135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 130,998.94- 546,364.55- 33.038 1,107,382.45- 135-47020-000-000 Standby 576.00- 576.00- 149.90- 26.024 426.10- 135-47025-000-000 Penalties 64,580.00- 64,580.00- 3,273.17- 19,273.12- 29.844 45,306.88- 135-47030-000-000 Service Charges 11,625.00- 11,625.00- 1,319.52- 4,403.52- 37.880 7,221.48- 135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 150.00- 250.00- 13.889 1,550.00- 135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 450.00- 1,200.00- 23.077 4,000.00- 135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 1,911.00- 12,578.15- 16.214 64,996.85- 135-47400-000-000 Water-Out of Dist/Port Meters 12.71 Subtotal: 5,360,712.00- 5,360,712.00- 308,971.22- 1,508,270.99- 28.136 3,852,441.01- 135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 18,000.00- 117,300.00- 18.214 526,700.00- Subtotal: 644,000.00- 644,000.00- 18,000.00- 117,300.00- 18.214 526,700.00- 135-49010-000-000 Interest Income 5,500.00- 5,500.00- 422.53- 2,077.88- 37.780 3,422.12- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 3,578.59- 35.208 6,585.41- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 2,333.32- 33.333 4,666.68- 135-49030-000-000 Vending Revenue 350.00- 350.00- 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- 3,487.00- 17,945.00- 24.582 55,055.00- 135-49900-000-000 Miscellaneous Income 1,000.00- 1,000.00- 3,331.33- 6,123.42- 612.342 5,123.42 135-49901-000-000 Records Management Revenue 109.00- 109.00 135-49905-000-000 Gas Well Revenue 200.00- 200.00- 153.97- 76.985 46.03- Subtotal: 402,962.00- 402,962.00- 8,734.72- 32,354.02- 8.029 370,607.98- Program number: 6,509,258.00- 6,509,258.00- 362,186.13- 1,734,217.90- 26.642 4,775,040.10- Department number: Revenues 6,509,258.00- 6,509,258.00- 362,186.13- 1,734,217.90- 26.642 4,775,040.10- Revenues Subtotal ----------- 6,509,258.00- 6,509,258.00- 362,186.13- 1,734,217.90- 26.642 4,775,040.10- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 17:19 02/14/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2013 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,929.34 48,098.46 22.547 165,222.54 135-50010-010-000 Overtime 13,250.00 13,250.00 1,542.42 5,936.29 44.802 7,313.71 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 975.00 1,875.00 36.765 3,225.00 135-50020-010-000 Retirement 32,725.00 32,725.00 1,844.60 33,485.71 102.325 760.71- 135-50026-010-000 Medical Insurance 28,920.00 28,920.00 2,113.96 7,165.72 24.778 21,754.28 135-50027-010-000 Dental Insurance 2,091.00 2,091.00 145.51 543.85 26.009 1,547.15 135-50028-010-000 Vision Insurance 519.00 519.00 33.79 129.07 24.869 389.93 135-50029-010-000 Life Insurance & Other 1,204.00 1,204.00 15.75 589.35 48.949 614.65 135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 936.01 3,834.78 26.347 10,720.22 135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 218.92 896.86 26.347 2,507.14 135-50040-010-000 Unemployment Taxes 945.00 945.00 261.16 261.16 27.636 683.84 135-50045-010-000 Workman's Compensation 6,109.00 6,109.00 5,335.00 11,444.00 187.330 5,335.00- 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 26,351.46 117,340.25 36.019 208,432.75 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 4,318.21 14,327.44 28.655 35,672.56 135-55090-010-000 Vehicle Maintenance 3,700.00 3,700.00 117.97 684.58 18.502 3,015.42 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 1,767.04 60.932 1,132.96 135-55135-010-000 Lab Analysis 4,500.00 4,500.00 320.00 1,955.15 43.448 2,544.85 Subtotal: 64,100.00 64,100.00 4,756.18 18,734.21 29.227 45,365.79 135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 352.21 17.611 1,647.79 135-60020-010-000 Electricity 162,410.00 162,410.00 9,048.69 33,095.79 20.378 129,314.21 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 150.00 100.000 135-60080-010-000 Schools & Training 1,672.00 1,672.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 92.69 551.69 78.813 148.31 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 32,351.30 40,524.75 113.198 4,724.75- 135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 114,365.94 418,323.40 20.623 1,610,123.60 135-60245-010-000 Miscellaneous Expenses 500.00 500.00 500.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 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 2.599 1,461.01 Subtotal: 2,239,129.00 2,239,129.00 156,008.62 493,736.53 22.050 1,745,392.47 135-65005-010-000 Fuel & Lube 17,661.00 17,661.00 835.11 3,760.60 21.293 13,900.40 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 17:19 02/14/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2013 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 517.74 1,617.82 60.366 1,062.18 135-65030-010-000 Chemicals 6,200.00 6,200.00 360.17 1,331.78 21.480 4,868.22 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 3,643.00 97,393.00 67.846 46,157.00 Subtotal: 173,591.00 173,591.00 5,356.02 104,370.39 60.124 69,220.61 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 31,028.52 100,816.54 67.211 49,183.46 Subtotal: 1,018,837.00 1,018,837.00 31,028.52 160,685.54 15.771 858,151.46 Program number: 3,821,430.00 3,821,430.00 223,500.80 894,866.92 23.417 2,926,563.08 Department number: Water 3,821,430.00 3,821,430.00 223,500.80 894,866.92 23.417 2,926,563.08 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 17:19 02/14/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2013 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,356.30 53,014.40 26.941 143,766.60 135-50010-020-000 Overtime 10,166.00 10,166.00 1,559.61 4,876.39 47.968 5,289.61 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 700.00 1,750.00 41.667 2,450.00 135-50020-020-000 Retirement 29,821.00 29,821.00 1,970.42 33,917.47 113.737 4,096.47- 135-50026-020-000 Medical Insurance 29,034.00 29,034.00 3,293.23 10,275.13 35.390 18,758.87 135-50027-020-000 Dental Insurance 2,112.00 2,112.00 226.46 752.48 35.629 1,359.52 135-50028-020-000 Vision Insurance 552.00 552.00 57.40 195.16 35.355 356.84 135-50029-020-000 Life Insurance & Other 920.00 920.00 21.00 644.16 70.017 275.84 135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 885.20 3,510.16 26.456 9,757.84 135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 207.03 820.92 26.456 2,282.08 135-50040-020-000 Unemployment Taxes 756.00 756.00 273.05 273.05 36.118 482.95 135-50045-020-000 Workman's Compensation 2,939.00 2,939.00 4,914.00 7,853.00 267.200 4,914.00- 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 28,463.70 120,739.82 40.652 176,270.18 135-55070-020-000 Independent Labor 1,000.00 1,000.00 34,875.00 34,875.00 3,487.500 33,875.00- 135-55080-020-000 Maintenance & Repairs 40,000.00 40,000.00 6,719.69 31,190.76 77.977 8,809.24 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 305.86 1,162.98 58.149 837.02 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 5,943.21 16,375.62 109.171 1,375.62- 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,777.75 7,338.00 24.460 22,662.00 Subtotal: 89,500.00 89,500.00 49,621.51 92,023.32 102.819 2,523.32- 135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 2,700.00 513.11 19.004 2,186.89 135-60020-020-000 Electricity 153,045.00 153,045.00 11,803.92 39,314.08 25.688 113,730.92 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 111.00 215.66 6.591 3,056.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 210.21 816.27 58.305 583.73 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 69.030 154.85 Subtotal: 221,367.00 221,367.00 12,125.13 50,263.62 22.706 171,103.38 135-65005-020-000 Fuel & Lube 8,527.00 8,527.00 1,179.49 3,981.33 46.691 4,545.67 135-65010-020-000 Uniforms 2,574.00 2,574.00 773.70 30.058 1,800.30 135-65030-020-000 Chemicals 10,000.00 10,000.00 2,157.22 15,025.52 150.255 5,025.52- . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 17:19 02/14/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2013 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 58.95 194.04 19.404 805.96 135-65040-020-000 Safety Equipment 250.00 250.00 34.70 65.07 26.028 184.93 135-65045-020-000 Lab Supplies 10,000.00 10,000.00 652.68 6,104.79 61.048 3,895.21 Subtotal: 32,351.00 32,351.00 4,083.04 26,144.45 80.815 6,206.55 135-69005-020-000 Capital Expenses 241,200.00 241,200.00 400,085.29 400,085.29 165.873 158,885.29- 135-69280-020-000 Capital Repairs 158,000.00 158,000.00 158,000.00 Subtotal: 399,200.00 399,200.00 400,085.29 400,085.29 100.222 885.29- Program number: 1,039,428.00 1,039,428.00 494,378.67 689,256.50 66.311 350,171.50 Department number: Wastewater 1,039,428.00 1,039,428.00 494,378.67 689,256.50 66.311 350,171.50 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 17:19 02/14/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2013 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,533.89 42,474.20 27.144 114,000.80 135-50010-021-000 Overtime 7,297.00 7,297.00 1,361.42 4,051.14 55.518 3,245.86 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 250.00 700.00 38.889 1,100.00 135-50020-021-000 Retirement 23,574.00 23,574.00 1,555.80 26,593.75 112.810 3,019.75- 135-50026-021-000 Medical Insurance 20,198.00 20,198.00 2,321.55 7,370.79 36.493 12,827.21 135-50027-021-000 Dental Insurance 1,409.00 1,409.00 159.88 533.32 37.851 875.68 135-50028-021-000 Vision Insurance 357.00 357.00 32.56 121.72 34.095 235.28 135-50029-021-000 Life Insurance & Other 1,008.00 1,008.00 5.25 482.61 47.878 525.39 135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 745.57 3,139.78 29.897 7,362.22 135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 174.36 734.28 29.897 1,721.72 135-50040-021-000 Unemployment Taxes 567.00 567.00 214.27 214.27 37.790 352.73 135-50045-021-000 Workman's Compensation 3,348.00 3,348.00 3,791.00 7,139.00 213.232 3,791.00- 135-50070-021-000 Employee Relations 250.00 250.00 16.78 6.712 233.22 Subtotal: 233,059.00 233,059.00 22,145.55 97,389.14 41.787 135,669.86 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55080-021-000 Maintenance & Repairs 35,000.00 35,000.00 85.59 254.09 .726 34,745.91 135-55090-021-000 Vehicle Maintenance 1,900.00 1,900.00 268.38 14.125 1,631.62 Subtotal: 38,400.00 38,400.00 85.59 522.47 1.361 37,877.53 135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 276.00 711.20 20.320 2,788.80 135-60020-021-000 Electricity 18,705.00 18,705.00 2,402.98 5,346.55 28.584 13,358.45 135-60070-021-000 Dues & Memberships 250.00 250.00 139.00 250.00 100.000 135-60080-021-000 Schools & Training 826.00 826.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 98.29 295.33 65.629 154.67 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 2,916.27 6,988.08 20.355 27,342.92 135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 848.49 3,490.36 28.805 8,626.64 135-65010-021-000 Uniforms 2,220.00 2,220.00 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 848.49 4,494.49 18.855 19,342.51 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 17:19 02/14/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2013 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 25,995.90 109,394.18 23.787 350,492.82 Department number: Collection 459,887.00 459,887.00 25,995.90 109,394.18 23.787 350,492.82 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 17:19 02/14/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2013 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 2,100.00 21.000 7,900.00 135-50030-026-000 Social Security Taxes 620.00 620.00 130.20 21.000 489.80 135-50035-026-000 Medicare Taxes 145.00 145.00 30.45 21.000 114.55 135-50040-026-000 Unemployment Taxes 210.00 210.00 60.90 29.000 149.10 135-50045-026-000 Workman's Compensation 150.00 150.00 15.70 15.70 10.467 134.30 Subtotal: 11,125.00 11,125.00 15.70 2,337.25 21.009 8,787.75 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 35.00 35.00 1.667 2,065.00 135-60075-026-000 Meetings 1,200.00 1,200.00 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 1,020.56 1,020.56 20.411 3,979.44 135-60245-026-000 Miscellaneous Expenses 3,000.00 3,000.00 60.00 60.00 2.000 2,940.00 Subtotal: 15,450.00 15,450.00 1,115.56 1,918.53 12.418 13,531.47 Program number: 26,575.00 26,575.00 1,131.26 4,255.78 16.014 22,319.22 Department number: Board of Directors 26,575.00 26,575.00 1,131.26 4,255.78 16.014 22,319.22 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 17:19 02/14/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2013 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,039.74 126,312.71 28.402 318,417.29 135-50010-030-000 Overtime 1,500.00 1,500.00 62.29 144.18 9.612 1,355.82 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 3,840.39 62,077.21 102.707 1,636.21- 135-50026-030-000 Medical Insurance 44,066.00 44,066.00 4,388.10 13,944.00 31.643 30,122.00 135-50027-030-000 Dental Insurance 3,379.00 3,379.00 386.34 1,252.50 37.067 2,126.50 135-50028-030-000 Vision Insurance 795.00 795.00 82.45 281.05 35.352 513.95 135-50029-030-000 Life Insurance & Other 2,500.00 2,500.00 36.75 1,206.59 48.264 1,293.41 135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 1,903.17 7,830.19 28.164 19,971.81 135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 445.10 1,831.26 28.165 4,670.74 135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 533.51 891.41 57.997 645.59 135-50045-030-000 Workman's Compensation 831.00 831.00 708.00 1,539.00 185.199 708.00- 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 1,615.37 2,537.47 50.749 2,462.53 Subtotal: 601,526.00 601,526.00 47,041.21 222,204.07 36.940 379,321.93 135-55030-030-000 Software & Support 63,555.00 63,555.00 4,794.40 14,469.92 22.768 49,085.08 135-55070-030-000 Independent Labor 2,700.00 2,700.00 63.75 120.00 4.444 2,580.00 135-55075-030-000 Records Management 500.00 500.00 500.00 135-55100-030-000 Building Maint & Supplies 5,000.00 5,000.00 263.78- 2,238.08 44.762 2,761.92 135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,818.81 7,161.72 35.454 13,038.28 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 60,318.00 60,318.00 70.576 25,147.00 135-55165-030-000 Collection Fees 159.77 159.77- 135-55205-030-000 Utility Billing Contract 11,000.00 11,000.00 34.73 2,098.75 19.080 8,901.25 Subtotal: 203,420.00 203,420.00 66,765.91 93,391.24 45.911 110,028.76 135-60005-030-000 Telephone 9,000.00 9,000.00 885.07 2,602.17 28.913 6,397.83 135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 300.00 1,104.08 30.883 2,470.92 135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 1,079.31 3,011.89 23.135 10,007.11 135-60025-030-000 Water 3,100.00 3,100.00 67.86 388.74 12.540 2,711.26 135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 515.18 3,810.71 28.908 9,371.29 135-60035-030-000 Postage 23,000.00 23,000.00 3,823.99 10,142.96 44.100 12,857.04 135-60040-030-000 Service Charges & Fees 18,000.00 18,000.00 2,377.43 10,014.14 55.634 7,985.86 135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 1,752.00 695.47 8.182 7,804.53 135-60055-030-000 Insurance 35,000.00 35,000.00 9,950.00- 50,643.77 144.696 15,643.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 2,991.95 3,891.95 162.165 1,491.95- 135-60075-030-000 Meetings 250.00 250.00 35.89 153.89 61.556 96.11 135-60080-030-000 Schools & Training 5,500.00 5,500.00 570.00 10.364 4,930.00 135-60100-030-000 Travel & per diem 3,950.00 3,950.00 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 17:19 02/14/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2013 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 .57 122.70 .818 14,877.30 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60281-030-000 Park Expenses 16,430.72 16,430.72 16,430.72- 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,325.00 93.000 175.00 Subtotal: 173,076.00 173,076.00 20,309.97 107,160.60 61.915 65,915.40 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 4,141.95 10,430.22 51.665 9,757.78 135-65085-030-000 Office Supplies 8,200.00 8,200.00 676.00 2,528.62 30.837 5,671.38 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 900.00 15.701 4,832.00 135-65095-030-000 Maintenance Supplies 2,000.00 2,000.00 445.95 715.16 35.758 1,284.84 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 5,263.90 15,593.12 35.883 27,861.88 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 1,284.25 37.225 2,165.75 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 256.85 1,284.25 4.230 29,076.75 Program number: 1,051,838.00 1,051,838.00 139,637.84 439,633.28 41.797 612,204.72 Department number: Administration 1,051,838.00 1,051,838.00 139,637.84 439,633.28 41.797 612,204.72 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 17:19 02/14/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2013 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 33,446.45 55,174.89 78.821 14,825.11 135-55055-039-000 Auditing 21,200.00 21,200.00 10,350.00 15,525.00 73.231 5,675.00 135-55060-039-000 Appraisal 15,100.00 15,100.00 4,265.90 28.251 10,834.10 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,340.98 2,340.98 61.605 1,459.02 Subtotal: 110,100.00 110,100.00 46,137.43 77,306.77 70.215 32,793.23 Program number: 110,100.00 110,100.00 46,137.43 77,306.77 70.215 32,793.23 Department number: Non Departmental 110,100.00 110,100.00 46,137.43 77,306.77 70.215 32,793.23 Expenditures Subtotal ----------- 6,509,258.00 6,509,258.00 930,781.90 2,214,713.43 34.024 4,294,544.57 Fund number: 135 MUD 1 General Fund 568,595.77 480,495.53 480,495.53- . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2013 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 771 01/02/2013 Property Taxes/Assessments (48,607.07) (876.94) (49,484.01) GL 772 01/03/2013 Property Taxes/Assessments (2,676.49) (52,160.50) GL 773 01/04/2013 Property Taxes/Assessments (2,099.06) (54,259.56) GL 776 01/07/2013 Property Taxes/Assessments (877.06) (55,136.62) GL 777 01/08/2013 Property Taxes/Assessments (1,641.55) (56,778.17) GL 784 01/09/2013 Property Taxes/Assessments (310.47) (57,088.64) GL 785 01/10/2013 Property Taxes/Assessments (976.70) (58,065.34) GL 786 01/11/2013 Property Taxes/Assessments (847.35) (58,912.69) GL 787 01/14/2013 Property Taxes/Assessments (1,977.12) (60,889.81) GL 788 01/15/2013 Property Taxes/Assessments (1,308.29) (62,198.10) GL 790 01/16/2013 Property Taxes/Assessments (522.96) (62,721.06) GL 789 01/17/2013 Property Taxes/Assessments (1,580.84) (64,301.90) GL 791 01/18/2013 Property Taxes/Assessments (1,724.93) (66,026.83) GL 792 01/22/2013 Property Taxes/Assessments (404.95) (66,431.78) GL 793 01/23/2013 Property Taxes/Assessments (834.25) (67,266.03) GL 794 01/24/2013 Property Taxes/Assessments (2,244.10) (69,510.13) GL 795 01/25/2013 Property Taxes/Assessments (1,101.26) (70,611.39) GL 796 01/28/2013 Property Taxes/Assessments (2,217.97) (72,829.36) GL 797 01/29/2013 Property Taxes/Assessments (1,956.32) (74,785.68) GL 798 01/30/2013 Property Taxes/Assessments (381.55) (75,167.23) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (26,560.16) (75,167.23) ** (99,884.00) Budgeted (24,716.77) Remaining 75 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 797 01/29/2013 Property Taxes/Assessments (712.43) (1.16) (713.59) GL 813 01/31/2013 Jan A/P FKA2 shortage due to refund 108.09 (605.50) DENTON COUNTY TAX OFFICE 32177 AP _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 106.93 (605.50) ** (500.00) Budgeted 105.50 Remaining 121 % Used Account: 135-40015-000-000 Property Taxes/P & I 773 01/04/2013 Property Taxes/Assessments (493.20) (4.15) (497.35) GL 787 01/14/2013 Property Taxes/Assessments (1.14) (498.49) GL 788 01/15/2013 Property Taxes/Assessments (6.71) (505.20) GL 794 01/24/2013 Property Taxes/Assessments (.54) (505.74) GL 795 01/25/2013 Property Taxes/Assessments (13.86) (519.60) GL 797 01/29/2013 Property Taxes/Assessments (.55) (520.15) GL 851 01/31/2013 Bank Rec adjustments .01 (520.14) GL 865 01/31/2013 Bank Rec adjustments (.02) (520.16) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (26.96) (520.16) ** (1,200.00) Budgeted (679.84) Remaining 43 % Used Account: 135-47000-000-000 Water 764 01/31/2013 UB 01/31/2013 Charge UB20130131-20130131 User: (753,170.45) (165,781.67) (918,952.12) UB 765 01/31/2013 UB 01/31/2013 Credit Adjustmts UB20130131-20130131 User: (4,899.66) (923,851.78) UB 884 01/31/2013 Recode Out of Dist Port Meters (199.97) (924,051.75) GL _______________ Account: 135-47000-000-000 Water Totals: (170,881.30) (924,051.75) ** (3,545,609.00) Budgeted (2,621,557.25) Remaining 26 % Used Account: 135-47005-000-000 Sewer 764 01/31/2013 UB 01/31/2013 Charge UB20130131-20130131 User: (415,365.61) (134,176.47) (549,542.08) UB 765 01/31/2013 UB 01/31/2013 Credit Adjustmts UB20130131-20130131 User: 3,177.53 (546,364.55) UB _______________ Account: 135-47005-000-000 Sewer Totals: (130,998.94) (546,364.55) ** (1,653,747.00) Budgeted (1,107,382.45) Remaining 33 % Used Account: 135-47020-000-000 Standby (149.90) .00 (149.90) _______________ Account: 135-47020-000-000 Standby Totals: .00 (149.90) ** (576.00) Budgeted (426.10) Remaining 26 % Used Account: 135-47025-000-000 Penalties 673 01/16/2013 UB 01/16/2013 Adjustment UB20130116-20130116 User: (15,999.95) 12.81 (15,987.14) UB 699 01/22/2013 UB 1/22/13 Penalties UB20130122-20130122 User: (3,272.63) (19,259.77) UB 747 01/29/2013 UB 01/29/2013 Adjustments UB20130129-20130129 User: 123.73 (19,136.04) UB 764 01/31/2013 UB 01/31/2013 Charge UB20130131-20130131 User: (115.31) (19,251.35) UB 765 01/31/2013 UB 01/31/2013 Credit Adjustmts UB20130131-20130131 User: (21.77) (19,273.12) UB _______________ Account: 135-47025-000-000 Penalties Totals: (3,273.17) (19,273.12) ** (64,580.00) Budgeted (45,306.88) Remaining 30 % Used Account: 135-47030-000-000 Service Charges 627 01/09/2013 UB 1/09/2013 Disconnect Fee UB20130109-20130109 User: (3,084.00) (975.00) (4,059.00) UB 644 01/09/2013 UB 1/9/13 Adjustments UB20130109-20130109 User: (300.00) (4,359.00) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 662 01/09/2013 UB 1/09/13 Adjustments UB20130109-20130109 User: (3,084.00) (25.00) (4,384.00) UB 664 01/10/2013 UB 1/10/13 Adjustments UB20130110-20130110 User: (25.00) (4,409.00) UB 733 01/11/2013 UB 1/11/13 Adjustments UB20130111-20130111 User: (25.00) (4,434.00) UB 673 01/16/2013 UB 01/16/2013 Adjustment UB20130116-20130116 User: 25.00 (4,409.00) UB 735 01/24/2013 UB 1/24/13 Adjustment UB20130124-20130124 User: (25.00) (4,434.00) UB 737 01/25/2013 UB 1/25/13 Adjustment UB20130125-20130125 User: (25.00) (4,459.00) UB 764 01/31/2013 UB 01/31/2013 Charge UB20130131-20130131 User: (3.00) (4,462.00) UB 765 01/31/2013 UB 01/31/2013 Credit Adjustmts UB20130131-20130131 User: 58.48 (4,403.52) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,319.52) (4,403.52) ** (11,625.00) Budgeted (7,221.48) Remaining 38 % Used Account: 135-47035-000-000 Plumbing Inspections 878 01/31/2013 January A/R billed to Town AR 20130130-20130131 User: (100.00) (150.00) (250.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (250.00) ** (1,800.00) Budgeted (1,550.00) Remaining 14 % Used Account: 135-47045-000-000 Sewer Inspections 878 01/31/2013 January A/R billed to Town AR 20130130-20130131 User: (750.00) (450.00) (1,200.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (1,200.00) ** (5,200.00) Budgeted (4,000.00) Remaining 23 % Used Account: 135-47070-000-000 TCCC Effluent Charges 709 01/23/2013 TCCC-Dec Effluent (10,667.15) (1,911.00) (12,578.15) GL _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (1,911.00) (12,578.15) ** (77,575.00) Budgeted (64,996.85) Remaining 16 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 666 01/16/2013 UB 1/16/13 Adjustment UB20130116-20130116 User: (12.71) (100.00) (112.71) UB 765 01/31/2013 UB 01/31/2013 Credit Adjustmts UB20130131-20130131 User: (87.26) (199.97) UB 884 01/31/2013 Recode Out of Dist Port Meters 199.97 .00 GL _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: 12.71 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-48005-000-000 Utility Fees . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 878 01/31/2013 January A/R billed to Town AR 20130130-20130131 User: (99,300.00) (18,400.00) (117,700.00) AR 883 01/31/2013 Correct JE485, 619 (323,204.94) (440,904.94) GL 883 01/31/2013 Correct JE485, 619 323,604.94 (117,300.00) GL _______________ Account: 135-48005-000-000 Utility Fees Totals: (18,000.00) (117,300.00) ** (644,000.00) Budgeted (526,700.00) Remaining 18 % Used Account: 135-49010-000-000 Interest Income 799 01/31/2013 Bank Interest/January (1,655.35) (66.77) (1,722.12) GL 799 01/31/2013 Bank Interest/January (355.76) (2,077.88) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (422.53) (2,077.88) ** (5,500.00) Budgeted (3,422.12) Remaining 38 % Used Account: 135-49016-000-000 Cell Tower Revenue 582 01/05/2013 AT&T Cell Tower Revenue (2,668.06) (910.53) (3,578.59) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (3,578.59) ** (10,164.00) Budgeted (6,585.41) Remaining 35 % Used Account: 135-49018-000-000 Building Rent Income 686 01/19/2013 Town Inv 2013-003/Dec Jan Maint Barn rent (1,749.99) (583.33) (2,333.32) GL _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,333.32) ** (7,000.00) Budgeted (4,666.68) Remaining 33 % Used Account: 135-49030-000-000 Vending Revenue (32.84) .00 (32.84) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (32.84) ** (350.00) Budgeted (317.16) Remaining 9 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (305,748.00) Budgeted (305,748.00) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49075-000-000 Oversize Meter Reimbursement 878 01/31/2013 January A/R billed to Town AR 20130130-20130131 User: (14,458.00) (3,487.00) (17,945.00) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (3,487.00) (17,945.00) ** (73,000.00) Budgeted (55,055.00) Remaining 25 % Used Account: 135-49900-000-000 Miscellaneous Income 685 01/19/2013 Constellation Energy EILS (2,792.09) (3,331.29) (6,123.38) GL 851 01/31/2013 Bank Rec adjustments (.04) (6,123.42) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (3,331.33) (6,123.42) ** (1,000.00) Budgeted 5,123.42 Remaining 612 % Used Account: 135-49901-000-000 Records Management Revenue (109.00) .00 (109.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (109.00) ** .00 Budgeted 109.00 Remaining 0 % Used Account: 135-49905-000-000 Gas Well Revenue (153.97) .00 (153.97) _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 (153.97) ** (200.00) Budgeted (46.03) Remaining 77 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,734,217.90) ** (6,509,258.00) Budgeted (4,775,040.10) Remaining 27 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2013 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 755 01/04/2013 Payroll 1/4/13 35,169.12 6,357.94 41,527.06 GL 656 01/18/2013 1/18/13 Payroll Salaries & Wages 5,863.89 47,390.95 PR 837 01/18/2013 Payroll 1/18/13 707.51 48,098.46 GL _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 12,929.34 48,098.46 ** 213,321.00 Budgeted 165,222.54 Remaining 23 % Used Account: 135-50010-010-000 Overtime 755 01/04/2013 Payroll 1/4/13 4,393.87 160.00 4,553.87 GL 755 01/04/2013 Payroll 1/4/13 1,019.91 5,573.78 GL 834 01/04/2013 Supplemental P/R 1/4/13 80.00 5,653.78 GL 656 01/18/2013 1/18/13 Payroll Overtime 202.51 5,856.29 PR 837 01/18/2013 Payroll 1/18/13 80.00 5,936.29 GL _______________ Account: 135-50010-010-000 Overtime Totals: 1,542.42 5,936.29 ** 13,250.00 Budgeted 7,313.71 Remaining 45 % 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 755 01/04/2013 Payroll 1/4/13 900.00 300.00 1,200.00 GL 832 01/04/2013 Supplemental P/R 1/4/13 300.00 1,500.00 GL 656 01/18/2013 1/18/13 Payroll Certification 375.00 1,875.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 975.00 1,875.00 ** 5,100.00 Budgeted 3,225.00 Remaining 37 % Used Account: 135-50020-010-000 Retirement 755 01/04/2013 Payroll 1/4/13 31,641.11 1,102.00 32,743.11 GL 832 01/04/2013 Supplemental P/R 1/4/13 42.18 32,785.29 GL 834 01/04/2013 Supplemental P/R 1/4/13 11.25 32,796.54 GL 656 01/18/2013 1/18/13 Payroll Retirement 578.44 33,374.98 PR 837 01/18/2013 Payroll 1/18/13 110.73 33,485.71 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50020-010-000 Retirement Totals: 1,844.60 33,485.71 ** 32,725.00 Budgeted (760.71) Remaining 102 % Used Account: 135-50026-010-000 Medical Insurance 755 01/04/2013 Payroll 1/4/13 5,051.76 1,057.00 6,108.76 GL 656 01/18/2013 1/18/13 Payroll Medical Insurance 1,056.96 7,165.72 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,113.96 7,165.72 ** 28,920.00 Budgeted 21,754.28 Remaining 25 % Used Account: 135-50027-010-000 Dental Insurance 755 01/04/2013 Payroll 1/4/13 398.34 72.76 471.10 GL 656 01/18/2013 1/18/13 Payroll Dental Insurance 72.75 543.85 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 145.51 543.85 ** 2,091.00 Budgeted 1,547.15 Remaining 26 % Used Account: 135-50028-010-000 Vision Insurance 755 01/04/2013 Payroll 1/4/13 95.28 16.84 112.12 GL 656 01/18/2013 1/18/13 Payroll Vision Insurance 16.95 129.07 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 33.79 129.07 ** 519.00 Budgeted 389.93 Remaining 25 % Used Account: 135-50029-010-000 Life Insurance & Other 720 01/27/2013 Jan A/P FSA Monthly Admin 573.60 15.75 589.35 Discovery Benefits 32131 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 15.75 589.35 ** 1,204.00 Budgeted 614.65 Remaining 49 % Used Account: 135-50030-010-000 Social Security Taxes 755 01/04/2013 Payroll 1/4/13 2,898.77 475.10 3,373.87 GL 832 01/04/2013 Supplemental P/R 1/4/13 18.60 3,392.47 GL 834 01/04/2013 Supplemental P/R 1/4/13 4.96 3,397.43 GL 656 01/18/2013 1/18/13 Payroll Social Security Taxes 388.52 3,785.95 PR 837 01/18/2013 Payroll 1/18/13 48.83 3,834.78 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 936.01 3,834.78 ** 14,555.00 Budgeted 10,720.22 Remaining 26 % Used Account: 135-50035-010-000 Medicare Taxes 755 01/04/2013 Payroll 1/4/13 677.94 111.11 789.05 GL 832 01/04/2013 Supplemental P/R 1/4/13 4.35 793.40 GL 834 01/04/2013 Supplemental P/R 1/4/13 1.16 794.56 GL 656 01/18/2013 1/18/13 Payroll Medicare Taxes 90.88 885.44 PR 837 01/18/2013 Payroll 1/18/13 11.42 896.86 GL _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 218.92 896.86 ** 3,404.00 Budgeted 2,507.14 Remaining 26 % Used Account: 135-50040-010-000 Unemployment Taxes 755 01/04/2013 Payroll 1/4/13 227.30 227.30 GL 832 01/04/2013 Supplemental P/R 1/4/13 8.70 236.00 GL 834 01/04/2013 Supplemental P/R 1/4/13 2.32 238.32 GL 837 01/18/2013 Payroll 1/18/13 22.84 261.16 GL _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 261.16 261.16 ** 945.00 Budgeted 683.84 Remaining 28 % Used Account: 135-50045-010-000 Workman's Compensation 720 01/27/2013 Jan A/P 1/1/13-9/30/13 Workers Comp 6,109.00 5,335.00 11,444.00 TML INTERGOVERNMENTAL RISK 32154 AP _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 5,335.00 11,444.00 ** 6,109.00 Budgeted (5,335.00) Remaining 187 % 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 . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50070-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 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Beck 10,009.23 11.57 10,020.80 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Womack 29.84 10,050.64 JPMORGAN CHASE BANK NA 32120 AP 720 01/27/2013 Jan A/P 4 large 100# gauges 246.00 10,296.64 MILLICAN WELL SERVICE, LLC 32139 AP 813 01/31/2013 Jan A/P Meter boxes 1,600.00 11,896.64 ATLAS UTILITY SUPPLY CO. 32171 AP 813 01/31/2013 Jan A/P Meters & Misc Brass fittings 1,241.04 13,137.68 ATLAS UTILITY SUPPLY CO. 32171 AP 813 01/31/2013 Jan A/P 1" compression couplings 205.56 13,343.24 ATLAS UTILITY SUPPLY CO. 32171 AP 813 01/31/2013 Jan A/P RTV Silicone 11.38 13,354.62 ROANOKE AUTO SUPPLY 32193 AP 813 01/31/2013 Jan A/P Metal detector 972.82 14,327.44 HD SUPPLY FACILITIES MAINT LTD 32183 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 4,318.21 14,327.44 ** 50,000.00 Budgeted 35,672.56 Remaining 29 % Used Account: 135-55090-010-000 Vehicle Maintenance 720 01/27/2013 Jan A/P Battery, toggle switch, switch 566.61 129.97 696.58 ROANOKE AUTO SUPPLY 32146 AP 720 01/27/2013 Jan A/P Battery Core deposit (12.00) 684.58 ROANOKE AUTO SUPPLY 32146 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 117.97 684.58 ** 3,700.00 Budgeted 3,015.42 Remaining 19 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1,767.04 .00 1,767.04 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,767.04 ** 2,900.00 Budgeted 1,132.96 Remaining 61 % Used Account: 135-55135-010-000 Lab Analysis 720 01/27/2013 Jan A/P Lab analysis 1,635.15 320.00 1,955.15 TARRANT CTY PUBLIC HEALTH LAB 32150 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55135-010-000 Lab Analysis Totals: 320.00 1,955.15 ** 4,500.00 Budgeted 2,544.85 Remaining 43 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 352.21 .00 352.21 _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: .00 352.21 ** 2,000.00 Budgeted 1,647.79 Remaining 18 % Used Account: 135-60020-010-000 Electricity 720 01/27/2013 Jan A/P Electricity 12/13-1/14 24,047.10 6,349.89 30,396.99 HUDSON ENERGY 32135 AP 720 01/27/2013 Jan A/P Electricity-Town elevated tank 84.46 30,481.45 HUDSON ENERGY 32135 AP 720 01/27/2013 Jan A/P Water plant/pump #5 2,614.34 33,095.79 HUDSON ENERGY 32135 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,048.69 33,095.79 ** 162,410.00 Budgeted 129,314.21 Remaining 20 % Used Account: 135-60050-010-000 Bad Debt Expense 694 01/01/2013 UB 1/1/13 Write Offs UB20130101-20130101 User: 117.06 117.06 UB 885 01/31/2013 Recode Bad Debt expense (117.06) .00 GL _______________ Account: 135-60050-010-000 Bad Debt Expense Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships 813 01/31/2013 Jan A/P Utility member dues 150.00 150.00 Texas Rural Water Assoc 32197 AP _______________ Account: 135-60070-010-000 Dues & Memberships Totals: 150.00 150.00 ** 150.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-010-000 Schools & Training . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 351.00 .00 351.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .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 755 01/04/2013 Payroll 1/4/13 459.00 84.36 543.36 GL 837 01/18/2013 Payroll 1/18/13 8.33 551.69 GL _______________ Account: 135-60100-010-000 Travel & per diem Totals: 92.69 551.69 ** 700.00 Budgeted 148.31 Remaining 79 % 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 715 01/25/2013 Jan A/P Revenue & Regulatory Assessmen 8,173.45 25,408.80 33,582.25 TX COMMISSION ENVIRONMENTAL QU 32123 AP 715 01/25/2013 Jan A/P 8/1/12-1/1/13 Municipal/Public 6,942.50 40,524.75 North Texas Groundwater 32121 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 32,351.30 40,524.75 ** 35,800.00 Budgeted (4,724.75) Remaining 113 % Used Account: 135-60150-010-000 Wholesale Water 813 01/31/2013 Jan A/P December Wholesale water 303,957.46 114,365.94 418,323.40 CITY OF FORT WORTH 32173 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 114,365.94 418,323.40 ** 2,028,447.00 Budgeted 1,610,123.60 Remaining 21 % Used Account: 135-60245-010-000 Miscellaneous Expenses . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 348.70 .00 348.70 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 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 38.99 .00 38.99 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 38.99 ** 1,500.00 Budgeted 1,461.01 Remaining 3 % Used Account: 135-65005-010-000 Fuel & Lube 720 01/27/2013 Jan A/P Balance due/Gas tank repair (T 2,925.49 27.70 2,953.19 SYN-TECH SYSTEMS, INC 32148 AP 804 01/31/2013 January Gas log 807.41 3,760.60 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 835.11 3,760.60 ** 17,661.00 Budgeted 13,900.40 Remaining 21 % Used Account: 135-65010-010-000 Uniforms 715 01/25/2013 Jan A/P 12/6-1/5 PCards - McMahon 1,100.08 127.94 1,228.02 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - McMahon 304.85 1,532.87 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Womack 33.98 1,566.85 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Womack 50.97 1,617.82 JPMORGAN CHASE BANK NA 32120 AP _______________ Account: 135-65010-010-000 Uniforms Totals: 517.74 1,617.82 ** 2,680.00 Budgeted 1,062.18 Remaining 60 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65030-010-000 Chemicals 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Womack 971.61 2.99 974.60 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Womack 208.18 1,182.78 JPMORGAN CHASE BANK NA 32120 AP 813 01/31/2013 Jan A/P Nitrogen 143.00 1,325.78 ALLIED WELDING SUPPLY, INC 32170 AP 813 01/31/2013 Jan A/P Cylinder rental 6.00 1,331.78 ALLIED WELDING SUPPLY, INC 32170 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 360.17 1,331.78 ** 6,200.00 Budgeted 4,868.22 Remaining 21 % 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 813 01/31/2013 Jan A/P Meters & Misc Brass fittings 93,750.00 3,643.00 97,393.00 ATLAS UTILITY SUPPLY CO. 32171 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 3,643.00 97,393.00 ** 143,550.00 Budgeted 46,157.00 Remaining 68 % 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 .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 387,037.00 Budgeted 387,037.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2013 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-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 720 01/27/2013 Jan A/P Capital repair-storage tank 69,788.02 31,028.52 100,816.54 UTILITY SERVICE CO, INC. 32159 AP _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: 31,028.52 100,816.54 ** 150,000.00 Budgeted 49,183.46 Remaining 67 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 894,866.92 ** 3,821,430.00 Budgeted 2,926,563.08 Remaining 23 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2013 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 755 01/04/2013 Payroll 1/4/13 38,658.10 7,198.06 45,856.16 GL 656 01/18/2013 1/18/13 Payroll Salaries & Wages 6,442.41 52,298.57 PR 837 01/18/2013 Payroll 1/18/13 715.83 53,014.40 GL _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,356.30 53,014.40 ** 196,781.00 Budgeted 143,766.60 Remaining 27 % Used Account: 135-50010-020-000 Overtime 755 01/04/2013 Payroll 1/4/13 3,316.78 160.00 3,476.78 GL 755 01/04/2013 Payroll 1/4/13 831.47 4,308.25 GL 834 01/04/2013 Supplemental P/R 1/4/13 160.00 4,468.25 GL 656 01/18/2013 1/18/13 Payroll Overtime 408.14 4,876.39 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,559.61 4,876.39 ** 10,166.00 Budgeted 5,289.61 Remaining 48 % 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 755 01/04/2013 Payroll 1/4/13 1,050.00 350.00 1,400.00 GL 656 01/18/2013 1/18/13 Payroll Certification 350.00 1,750.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 1,750.00 ** 4,200.00 Budgeted 2,450.00 Remaining 42 % Used Account: 135-50020-020-000 Retirement 755 01/04/2013 Payroll 1/4/13 31,947.05 1,200.66 33,147.71 GL 834 01/04/2013 Supplemental P/R 1/4/13 22.50 33,170.21 GL 656 01/18/2013 1/18/13 Payroll Retirement 646.61 33,816.82 PR 837 01/18/2013 Payroll 1/18/13 100.65 33,917.47 GL _______________ Account: 135-50020-020-000 Retirement Totals: 1,970.42 33,917.47 ** 29,821.00 Budgeted (4,096.47) Remaining 114 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2013 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 755 01/04/2013 Payroll 1/4/13 6,981.90 1,646.62 8,628.52 GL 656 01/18/2013 1/18/13 Payroll Medical Insurance 1,646.61 10,275.13 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,293.23 10,275.13 ** 29,034.00 Budgeted 18,758.87 Remaining 35 % Used Account: 135-50027-020-000 Dental Insurance 755 01/04/2013 Payroll 1/4/13 526.02 113.24 639.26 GL 656 01/18/2013 1/18/13 Payroll Dental Insurance 113.22 752.48 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 226.46 752.48 ** 2,112.00 Budgeted 1,359.52 Remaining 36 % Used Account: 135-50028-020-000 Vision Insurance 755 01/04/2013 Payroll 1/4/13 137.76 28.72 166.48 GL 656 01/18/2013 1/18/13 Payroll Vision Insurance 28.68 195.16 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 57.40 195.16 ** 552.00 Budgeted 356.84 Remaining 35 % Used Account: 135-50029-020-000 Life Insurance & Other 720 01/27/2013 Jan A/P FSA Monthly Admin 623.16 21.00 644.16 Discovery Benefits 32131 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 21.00 644.16 ** 920.00 Budgeted 275.84 Remaining 70 % Used Account: 135-50030-020-000 Social Security Taxes 755 01/04/2013 Payroll 1/4/13 2,624.96 456.96 3,081.92 GL 834 01/04/2013 Supplemental P/R 1/4/13 9.92 3,091.84 GL 656 01/18/2013 1/18/13 Payroll Social Security Taxes 373.94 3,465.78 PR 837 01/18/2013 Payroll 1/18/13 44.38 3,510.16 GL _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 885.20 3,510.16 ** 13,268.00 Budgeted 9,757.84 Remaining 26 % Used Account: 135-50035-020-000 Medicare Taxes 755 01/04/2013 Payroll 1/4/13 613.89 106.87 720.76 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 834 01/04/2013 Supplemental P/R 1/4/13 613.89 2.32 723.08 GL 656 01/18/2013 1/18/13 Payroll Medicare Taxes 87.46 810.54 PR 837 01/18/2013 Payroll 1/18/13 10.38 820.92 GL _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 207.03 820.92 ** 3,103.00 Budgeted 2,282.08 Remaining 26 % Used Account: 135-50040-020-000 Unemployment Taxes 755 01/04/2013 Payroll 1/4/13 247.64 247.64 GL 834 01/04/2013 Supplemental P/R 1/4/13 4.64 252.28 GL 837 01/18/2013 Payroll 1/18/13 20.77 273.05 GL _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 273.05 273.05 ** 756.00 Budgeted 482.95 Remaining 36 % Used Account: 135-50045-020-000 Workman's Compensation 720 01/27/2013 Jan A/P 1/1/13-9/30/13 Workers Comp 2,939.00 4,914.00 7,853.00 TML INTERGOVERNMENTAL RISK 32154 AP _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 4,914.00 7,853.00 ** 2,939.00 Budgeted (4,914.00) Remaining 267 % 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 720 01/27/2013 Jan A/P WW plant study 14,250.00 14,250.00 THE WALLACE GROUP, INC. 32153 AP 813 01/31/2013 Jan A/P Wastewater study 20,625.00 34,875.00 THE WALLACE GROUP, INC. 32198 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 34,875.00 34,875.00 ** 1,000.00 Budgeted (33,875.00) Remaining ########## . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2013 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 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Schlielig 24,471.07 205.72 24,676.79 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Schlielig 903.28 25,580.07 JPMORGAN CHASE BANK NA 32120 AP 720 01/27/2013 Jan A/P Liberator Bacterial Treatment 737.69 26,317.76 United Laboratories 32158 AP 813 01/31/2013 Jan A/P Crane truck, compression lugs 3,019.50 29,337.26 PUMP SOLUTIONS INC 32192 AP 813 01/31/2013 Jan A/P Check Generator 465.00 29,802.26 ENTECH SALES AND SERVICE INC 32178 AP 813 01/31/2013 Jan A/P Calibration of all flow meters 1,388.50 31,190.76 Prime Controls, LP 32191 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 6,719.69 31,190.76 ** 40,000.00 Budgeted 8,809.24 Remaining 78 % Used Account: 135-55090-020-000 Vehicle Maintenance 720 01/27/2013 Jan A/P Battery/2013 CYOT 857.12 98.95 956.07 BLAGG TIRE & SERVICE 32125 AP 813 01/31/2013 Jan A/P Tire 2001 Ford F350 116.89 1,072.96 BLAGG TIRE & SERVICE 32172 AP 813 01/31/2013 Jan A/P Mini trachoe battery 90.02 1,162.98 BLAGG TIRE & SERVICE 32172 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 305.86 1,162.98 ** 2,000.00 Budgeted 837.02 Remaining 58 % 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 813 01/31/2013 Jan A/P Sludge haul off 10,432.41 1,811.91 12,244.32 L.H. CHANEY MATERIALS, INC. 32186 AP 813 01/31/2013 Jan A/P Sludge haul off 4,131.30 16,375.62 L.H. CHANEY MATERIALS, INC. 32186 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 5,943.21 16,375.62 ** 15,000.00 Budgeted (1,375.62) Remaining 109 % Used Account: 135-55135-020-000 Lab Analysis 720 01/27/2013 Jan A/P Wet Chem. analysis 5,560.25 1,777.75 7,338.00 TALEM, INC 32149 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,777.75 7,338.00 ** 30,000.00 Budgeted 22,662.00 Remaining 24 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 513.11 .00 513.11 _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: .00 513.11 ** 2,700.00 Budgeted 2,186.89 Remaining 19 % Used Account: 135-60020-020-000 Electricity 720 01/27/2013 Jan A/P Electricity 12/13-1/14 27,510.16 11,803.92 39,314.08 HUDSON ENERGY 32135 AP _______________ Account: 135-60020-020-000 Electricity Totals: 11,803.92 39,314.08 ** 153,045.00 Budgeted 113,730.92 Remaining 26 % 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 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Slaght 104.66 111.00 215.66 JPMORGAN CHASE BANK NA 32120 AP _______________ Account: 135-60080-020-000 Schools & Training Totals: 111.00 215.66 ** 3,272.00 Budgeted 3,056.34 Remaining 7 % 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 755 01/04/2013 Payroll 1/4/13 606.06 186.48 792.54 GL 656 01/18/2013 1/18/13 Payroll Travel & per diem 23.73 816.27 PR _______________ Account: 135-60100-020-000 Travel & per diem Totals: 210.21 816.27 ** 1,400.00 Budgeted 583.73 Remaining 58 % Used Account: 135-60105-020-000 Rent/Lease Equipment . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,020.00 .00 1,020.00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 1,020.00 ** 1,500.00 Budgeted 480.00 Remaining 68 % Used Account: 135-60125-020-000 Advertising .00 .00 _______________ Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 7,729.80 .00 7,729.80 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 7,729.80 ** 56,000.00 Budgeted 48,270.20 Remaining 14 % Used Account: 135-60245-020-000 Miscellaneous Expenses 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 345.15 .00 345.15 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 345.15 ** 500.00 Budgeted 154.85 Remaining 69 % Used Account: 135-65005-020-000 Fuel & Lube 804 01/31/2013 January Gas log 2,801.84 1,179.49 3,981.33 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,179.49 3,981.33 ** 8,527.00 Budgeted 4,545.67 Remaining 47 % Used Account: 135-65010-020-000 Uniforms 773.70 .00 773.70 . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-020-000 Uniforms Totals: .00 773.70 ** 2,574.00 Budgeted 1,800.30 Remaining 30 % Used Account: 135-65030-020-000 Chemicals 720 01/27/2013 Jan A/P Polymer, liberator Bacterial t 12,868.30 1,077.22 13,945.52 United Laboratories 32158 AP 813 01/31/2013 Jan A/P Belt Press Polymer 1,080.00 15,025.52 POLYDYNE, INC 32190 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 2,157.22 15,025.52 ** 10,000.00 Budgeted (5,025.52) Remaining 150 % Used Account: 135-65035-020-000 Small Tools 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Schlielig 135.09 58.95 194.04 JPMORGAN CHASE BANK NA 32120 AP _______________ Account: 135-65035-020-000 Small Tools Totals: 58.95 194.04 ** 1,000.00 Budgeted 805.96 Remaining 19 % Used Account: 135-65040-020-000 Safety Equipment 720 01/27/2013 Jan A/P Medical supplies 30.37 34.70 65.07 CINTAS FAS LOCKBOX 636525 32128 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 34.70 65.07 ** 250.00 Budgeted 184.93 Remaining 26 % Used Account: 135-65045-020-000 Lab Supplies 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Schlielig 5,452.11 72.29 5,524.40 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Schlielig 155.19 5,679.59 JPMORGAN CHASE BANK NA 32120 AP 720 01/27/2013 Jan A/P Water 47.83 5,727.42 OZARKA DIRECT 32143 AP 813 01/31/2013 Jan A/P Sample bottles for E Coli 377.37 6,104.79 IDEXX DISTRIBUTION, INC 32184 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 652.68 6,104.79 ** 10,000.00 Budgeted 3,895.21 Remaining 61 % Used Account: 135-69005-020-000 Capital Expenses 669 01/16/2013 Jan A/P Earnest money/Land 1,000.00 1,000.00 SENDERA TITLE - JEANIE ACORD 32116 AP 820 01/30/2013 Cashier's ck for land purchase 399,085.29 400,085.29 GL _______________ Account: 135-69005-020-000 Capital Expenses Totals: 400,085.29 400,085.29 ** 241,200.00 Budgeted (158,885.29) Remaining 166 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69280-020-000 Capital Repairs .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 158,000.00 Budgeted 158,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 689,256.50 ** 1,039,428.00 Budgeted 350,171.50 Remaining 66 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2013 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 755 01/04/2013 Payroll 1/4/13 30,940.31 5,692.88 36,633.19 GL 656 01/18/2013 1/18/13 Payroll Salaries & Wages 5,195.61 41,828.80 PR 837 01/18/2013 Payroll 1/18/13 645.40 42,474.20 GL _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,533.89 42,474.20 ** 156,475.00 Budgeted 114,000.80 Remaining 27 % Used Account: 135-50010-021-000 Overtime 755 01/04/2013 Payroll 1/4/13 2,689.72 790.49 3,480.21 GL 755 01/04/2013 Payroll 1/4/13 80.00 3,560.21 GL 656 01/18/2013 1/18/13 Payroll Overtime 410.93 3,971.14 PR 837 01/18/2013 Payroll 1/18/13 80.00 4,051.14 GL _______________ Account: 135-50010-021-000 Overtime Totals: 1,361.42 4,051.14 ** 7,297.00 Budgeted 3,245.86 Remaining 56 % 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 755 01/04/2013 Payroll 1/4/13 450.00 100.00 550.00 GL 656 01/18/2013 1/18/13 Payroll Certification 150.00 700.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 250.00 700.00 ** 1,800.00 Budgeted 1,100.00 Remaining 39 % Used Account: 135-50020-021-000 Retirement 755 01/04/2013 Payroll 1/4/13 25,037.95 936.87 25,974.82 GL 656 01/18/2013 1/18/13 Payroll Retirement 516.94 26,491.76 PR 837 01/18/2013 Payroll 1/18/13 101.99 26,593.75 GL _______________ Account: 135-50020-021-000 Retirement Totals: 1,555.80 26,593.75 ** 23,574.00 Budgeted (3,019.75) Remaining 113 % Used Account: 135-50026-021-000 Medical Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 755 01/04/2013 Payroll 1/4/13 5,049.24 1,160.78 6,210.02 GL 656 01/18/2013 1/18/13 Payroll Medical Insurance 1,160.77 7,370.79 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 2,321.55 7,370.79 ** 20,198.00 Budgeted 12,827.21 Remaining 36 % Used Account: 135-50027-021-000 Dental Insurance 755 01/04/2013 Payroll 1/4/13 373.44 79.95 453.39 GL 656 01/18/2013 1/18/13 Payroll Dental Insurance 79.93 533.32 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 159.88 533.32 ** 1,409.00 Budgeted 875.68 Remaining 38 % Used Account: 135-50028-021-000 Vision Insurance 755 01/04/2013 Payroll 1/4/13 89.16 16.27 105.43 GL 656 01/18/2013 1/18/13 Payroll Vision Insurance 16.29 121.72 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 32.56 121.72 ** 357.00 Budgeted 235.28 Remaining 34 % Used Account: 135-50029-021-000 Life Insurance & Other 720 01/27/2013 Jan A/P FSA Monthly Admin 477.36 5.25 482.61 Discovery Benefits 32131 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 5.25 482.61 ** 1,008.00 Budgeted 525.39 Remaining 48 % Used Account: 135-50030-021-000 Social Security Taxes 755 01/04/2013 Payroll 1/4/13 2,394.21 378.40 2,772.61 GL 656 01/18/2013 1/18/13 Payroll Social Security Taxes 322.19 3,094.80 PR 837 01/18/2013 Payroll 1/18/13 44.98 3,139.78 GL _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 745.57 3,139.78 ** 10,502.00 Budgeted 7,362.22 Remaining 30 % Used Account: 135-50035-021-000 Medicare Taxes 755 01/04/2013 Payroll 1/4/13 559.92 88.50 648.42 GL 656 01/18/2013 1/18/13 Payroll Medicare Taxes 75.35 723.77 PR 837 01/18/2013 Payroll 1/18/13 10.51 734.28 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 174.36 734.28 ** 2,456.00 Budgeted 1,721.72 Remaining 30 % Used Account: 135-50040-021-000 Unemployment Taxes 755 01/04/2013 Payroll 1/4/13 193.23 193.23 GL 837 01/18/2013 Payroll 1/18/13 21.04 214.27 GL _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: 214.27 214.27 ** 567.00 Budgeted 352.73 Remaining 38 % Used Account: 135-50045-021-000 Workman's Compensation 720 01/27/2013 Jan A/P 1/1/13-9/30/13 Workers Comp 3,348.00 3,791.00 7,139.00 TML INTERGOVERNMENTAL RISK 32154 AP _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 3,791.00 7,139.00 ** 3,348.00 Budgeted (3,791.00) Remaining 213 % 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 .00 .00 _______________ Account: 135-55005-021-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 720 01/27/2013 Jan A/P Gasket-Diaphragm 1 1/4" 168.50 85.59 254.09 SMITH PUMP COMPANY, INC. 32147 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 85.59 254.09 ** 35,000.00 Budgeted 34,745.91 Remaining 1 % Used Account: 135-55090-021-000 Vehicle Maintenance 268.38 .00 268.38 . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 268.38 ** 1,900.00 Budgeted 1,631.62 Remaining 14 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 556 01/04/2013 Jan A/P PID Inverted Siphon yearly cal 435.20 276.00 711.20 OMNISITE 32088 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 276.00 711.20 ** 3,500.00 Budgeted 2,788.80 Remaining 20 % Used Account: 135-60020-021-000 Electricity 702 01/23/2013 Correction to Inv 1762/Town AR 20130123-20130123 User: 2,943.57 438.38 3,381.95 AR 701 01/23/2013 A/R Billing/Town AR 20130123-20130123 User: (883.24) 2,498.71 AR 720 01/27/2013 Jan A/P Electricity 11/29-12/31/12 260.64 2,759.35 TRI COUNTY ELECTRIC 32156 AP 720 01/27/2013 Jan A/P Electricity 11/29-12/31/12 149.28 2,908.63 TRI COUNTY ELECTRIC 32156 AP 720 01/27/2013 Jan A/P Electricity 11/29-12/31/12 29.17 2,937.80 TRI COUNTY ELECTRIC 32156 AP 720 01/27/2013 Jan A/P Electricity 12/13-1/14 762.35 3,700.15 HUDSON ENERGY 32135 AP 720 01/27/2013 Jan A/P Electricity 12/13-1/14 1,599.22 5,299.37 HUDSON ENERGY 32135 AP 720 01/27/2013 Jan A/P Electricity PID Lift sta 12/12 47.18 5,346.55 HUDSON ENERGY 32135 AP _______________ Account: 135-60020-021-000 Electricity Totals: 2,402.98 5,346.55 ** 18,705.00 Budgeted 13,358.45 Remaining 29 % Used Account: 135-60070-021-000 Dues & Memberships 813 01/31/2013 Jan A/P Utility member dues 111.00 139.00 250.00 Texas Rural Water Assoc 32197 AP _______________ Account: 135-60070-021-000 Dues & Memberships Totals: 139.00 250.00 ** 250.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-021-000 Schools & Training 385.00 .00 385.00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 385.00 ** 826.00 Budgeted 441.00 Remaining 47 % Used Account: 135-60090-021-000 Safety Program .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 755 01/04/2013 Payroll 1/4/13 197.04 29.42 226.46 GL 656 01/18/2013 1/18/13 Payroll Travel & per diem 65.54 292.00 PR 837 01/18/2013 Payroll 1/18/13 3.33 295.33 GL _______________ Account: 135-60100-021-000 Travel & per diem Totals: 98.29 295.33 ** 450.00 Budgeted 154.67 Remaining 66 % 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 804 01/31/2013 January Gas log 2,641.87 848.49 3,490.36 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 848.49 3,490.36 ** 12,117.00 Budgeted 8,626.64 Remaining 29 % Used Account: 135-65010-021-000 Uniforms 934.13 .00 934.13 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 934.13 ** 2,220.00 Budgeted 1,285.87 Remaining 42 % Used Account: 135-65030-021-000 Chemicals . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 1/2013 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-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 _______________ 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: ------------------------------------------------------------------------------------------------ 109,394.18 ** 459,887.00 Budgeted 350,492.82 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2013 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 2,100.00 .00 2,100.00 _______________ Account: 135-50005-026-000 Salaries & Wages Totals: .00 2,100.00 ** 10,000.00 Budgeted 7,900.00 Remaining 21 % Used Account: 135-50030-026-000 Social Security Taxes 130.20 .00 130.20 _______________ Account: 135-50030-026-000 Social Security Taxes Totals: .00 130.20 ** 620.00 Budgeted 489.80 Remaining 21 % Used Account: 135-50035-026-000 Medicare Taxes 30.45 .00 30.45 _______________ Account: 135-50035-026-000 Medicare Taxes Totals: .00 30.45 ** 145.00 Budgeted 114.55 Remaining 21 % Used Account: 135-50040-026-000 Unemployment Taxes 60.90 .00 60.90 _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: .00 60.90 ** 210.00 Budgeted 149.10 Remaining 29 % Used Account: 135-50045-026-000 Workman's Compensation 720 01/27/2013 Jan A/P 1/1/13-9/30/13 Workers Comp 15.70 15.70 TML INTERGOVERNMENTAL RISK 32154 AP _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 15.70 15.70 ** 150.00 Budgeted 134.30 Remaining 10 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 720 01/27/2013 Jan A/P Adm fee 35.00 35.00 TX SOCIAL SECURITY PROGRAM 32157 AP _______________ Account: 135-60070-026-000 Dues & Memberships Totals: 35.00 35.00 ** 2,100.00 Budgeted 2,065.00 Remaining 2 % Used Account: 135-60075-026-000 Meetings 222.97 .00 222.97 _______________ Account: 135-60075-026-000 Meetings Totals: .00 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 813 01/31/2013 Jan A/P AWBD Conference reimbursement 510.28 510.28 KEVIN CARR 32185 AP 827 01/31/2013 Jan A/P AWBD Conference Reimbursement 510.28 1,020.56 KEVIN CARR 32221 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 1,020.56 1,020.56 ** 5,000.00 Budgeted 3,979.44 Remaining 20 % Used Account: 135-60245-026-000 Miscellaneous Expenses 715 01/25/2013 Jan A/P 12/6-1/5 PCards-Schultz 60.00 60.00 JPMORGAN CHASE BANK NA 32120 AP _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 60.00 60.00 ** 3,000.00 Budgeted 2,940.00 Remaining 2 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 4,255.78 ** 26,575.00 Budgeted 22,319.22 Remaining 16 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2013 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 755 01/04/2013 Payroll 1/4/13 93,272.97 16,689.78 109,962.75 GL 656 01/18/2013 1/18/13 Payroll Salaries & Wages 14,642.68 124,605.43 PR 837 01/18/2013 Payroll 1/18/13 1,707.28 126,312.71 GL _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 33,039.74 126,312.71 ** 444,730.00 Budgeted 318,417.29 Remaining 28 % Used Account: 135-50010-030-000 Overtime 656 01/18/2013 1/18/13 Payroll Overtime 81.89 62.29 144.18 PR _______________ Account: 135-50010-030-000 Overtime Totals: 62.29 144.18 ** 1,500.00 Budgeted 1,355.82 Remaining 10 % 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 755 01/04/2013 Payroll 1/4/13 58,236.82 2,288.27 60,525.09 GL 656 01/18/2013 1/18/13 Payroll Retirement 1,320.50 61,845.59 PR 837 01/18/2013 Payroll 1/18/13 231.62 62,077.21 GL _______________ Account: 135-50020-030-000 Retirement Totals: 3,840.39 62,077.21 ** 60,441.00 Budgeted (1,636.21) Remaining 103 % Used Account: 135-50026-030-000 Medical Insurance 755 01/04/2013 Payroll 1/4/13 9,555.90 2,194.07 11,749.97 GL 656 01/18/2013 1/18/13 Payroll Medical Insurance 2,194.03 13,944.00 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,388.10 13,944.00 ** 44,066.00 Budgeted 30,122.00 Remaining 32 % Used Account: 135-50027-030-000 Dental Insurance 755 01/04/2013 Payroll 1/4/13 866.16 193.19 1,059.35 GL 656 01/18/2013 1/18/13 Payroll Dental Insurance 193.15 1,252.50 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2013 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: 386.34 1,252.50 ** 3,379.00 Budgeted 2,126.50 Remaining 37 % Used Account: 135-50028-030-000 Vision Insurance 755 01/04/2013 Payroll 1/4/13 198.60 41.21 239.81 GL 656 01/18/2013 1/18/13 Payroll Vision Insurance 41.24 281.05 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.45 281.05 ** 795.00 Budgeted 513.95 Remaining 35 % Used Account: 135-50029-030-000 Life Insurance & Other 720 01/27/2013 Jan A/P FSA Monthly Admin 1,169.84 36.75 1,206.59 Discovery Benefits 32131 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 36.75 1,206.59 ** 2,500.00 Budgeted 1,293.41 Remaining 48 % Used Account: 135-50030-030-000 Social Security Taxes 755 01/04/2013 Payroll 1/4/13 5,927.02 960.19 6,887.21 GL 656 01/18/2013 1/18/13 Payroll Social Security Taxes 837.13 7,724.34 PR 837 01/18/2013 Payroll 1/18/13 105.85 7,830.19 GL _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,903.17 7,830.19 ** 27,802.00 Budgeted 19,971.81 Remaining 28 % Used Account: 135-50035-030-000 Medicare Taxes 755 01/04/2013 Payroll 1/4/13 1,386.16 224.56 1,610.72 GL 656 01/18/2013 1/18/13 Payroll Medicare Taxes 195.78 1,806.50 PR 837 01/18/2013 Payroll 1/18/13 24.76 1,831.26 GL _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 445.10 1,831.26 ** 6,502.00 Budgeted 4,670.74 Remaining 28 % Used Account: 135-50040-030-000 Unemployment Taxes 755 01/04/2013 Payroll 1/4/13 357.90 484.00 841.90 GL 837 01/18/2013 Payroll 1/18/13 49.51 891.41 GL _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 533.51 891.41 ** 1,537.00 Budgeted 645.59 Remaining 58 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2013 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 720 01/27/2013 Jan A/P 1/1/13-9/30/13 Workers Comp 831.00 708.00 1,539.00 TML INTERGOVERNMENTAL RISK 32154 AP _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 708.00 1,539.00 ** 831.00 Budgeted (708.00) Remaining 185 % 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 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Ard 922.10 583.78 1,505.88 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Ard 169.94 1,675.82 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Ard 57.94 1,733.76 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Ard 539.89 2,273.65 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Ard (9.57) 2,264.08 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Ard 273.39 2,537.47 JPMORGAN CHASE BANK NA 32120 AP _______________ Account: 135-50070-030-000 Employee Relations Totals: 1,615.37 2,537.47 ** 5,000.00 Budgeted 2,462.53 Remaining 51 % Used Account: 135-55030-030-000 Software & Support 640 01/10/2013 Jan A/P PCards 11/28-12/27 Pastor 9,675.52 35.94 9,711.46 BANK OF AMERICA 32115 AP 640 01/10/2013 Jan A/P PCards 11/28-12/27 Pastor 25.00 9,736.46 BANK OF AMERICA 32115 AP 640 01/10/2013 Jan A/P PCards 11/28-12/27 Zieverink 55.37 9,791.83 BANK OF AMERICA 32115 AP 640 01/10/2013 Jan A/P PCards 11/28-12/27 Zieverink 53.38 9,845.21 BANK OF AMERICA 32115 AP 715 01/25/2013 Jan A/P ISP Charges 307.76 10,152.97 TOWN OF TROPHY CLUB 32122 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Gonzales 305.50 10,458.47 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Gonzales 302.75 10,761.22 JPMORGAN CHASE BANK NA 32120 AP 813 01/31/2013 Jan A/P 3708.70 3,708.70 14,469.92 STW INC 32194 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 4,794.40 14,469.92 ** 63,555.00 Budgeted 49,085.08 Remaining 23 % Used Account: 135-55070-030-000 Independent Labor 720 01/27/2013 Jan A/P Record MUD meeting 56.25 63.75 120.00 MIGUEL CRUZ 32138 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55070-030-000 Independent Labor Totals: 63.75 120.00 ** 2,700.00 Budgeted 2,580.00 Remaining 4 % Used Account: 135-55075-030-000 Records Management .00 .00 _______________ Account: 135-55075-030-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55100-030-000 Building Maint & Supplies 556 01/04/2013 Jan A/P Keys for front cash drawer and 2,501.86 58.90 2,560.76 MICHAEL'S KEYS 32083 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Womack 13.99 2,574.75 JPMORGAN CHASE BANK NA 32120 AP 878 01/31/2013 January A/R billed to Town AR 20130130-20130131 User: (336.67) 2,238.08 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: (263.78) 2,238.08 ** 5,000.00 Budgeted 2,761.92 Remaining 45 % Used Account: 135-55120-030-000 Cleaning Services 556 01/04/2013 Jan A/P January cleaning services 5,342.91 1,678.51 7,021.42 ABM JANITORIAL SERVICES, INC 32030 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Slaght 140.30 7,161.72 JPMORGAN CHASE BANK NA 32120 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,818.81 7,161.72 ** 20,200.00 Budgeted 13,038.28 Remaining 35 % 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 813 01/31/2013 Jan A/P Semo agreement 60,318.00 60,318.00 TOWN OF TROPHY CLUB 32200 AP _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: 60,318.00 60,318.00 ** 85,465.00 Budgeted 25,147.00 Remaining 71 % Used Account: 135-55165-030-000 Collection Fees . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 720 01/27/2013 Jan A/P Printing of December water bil 2,064.02 405.96 2,469.98 DP2 BILLING SOLUTIONS, LLC 32132 AP 720 01/27/2013 Jan A/P Credit memo (20.00) 2,449.98 DP2 BILLING SOLUTIONS, LLC 32132 AP 879 01/31/2013 January A/R billed to Town AR 20130130-20130131 User: (351.23) 2,098.75 AR _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 34.73 2,098.75 ** 11,000.00 Budgeted 8,901.25 Remaining 19 % Used Account: 135-60005-030-000 Telephone 640 01/10/2013 Jan A/P PCards 11/28-12/27 Zieverink 1,717.10 395.24 2,112.34 BANK OF AMERICA 32115 AP 640 01/10/2013 Jan A/P PCards 11/28-12/27 Zieverink 116.86 2,229.20 BANK OF AMERICA 32115 AP 640 01/10/2013 Jan A/P PCards 11/28-12/27 Zieverink 372.97 2,602.17 BANK OF AMERICA 32115 AP _______________ Account: 135-60005-030-000 Telephone Totals: 885.07 2,602.17 ** 9,000.00 Budgeted 6,397.83 Remaining 29 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 755 01/04/2013 Payroll 1/4/13 804.08 150.00 954.08 GL 656 01/18/2013 1/18/13 Payroll Communications/Pagers/Mobiles 150.00 1,104.08 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 300.00 1,104.08 ** 3,575.00 Budgeted 2,470.92 Remaining 31 % Used Account: 135-60020-030-000 Electricity/Gas 720 01/27/2013 Jan A/P Electricity MUD/PS Bldg 11/12- 1,932.58 1,079.31 3,011.89 TOWN OF TROPHY CLUB 32155 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,079.31 3,011.89 ** 13,019.00 Budgeted 10,007.11 Remaining 23 % Used Account: 135-60025-030-000 Water 813 01/31/2013 Jan A/P Jan water 320.88 135.72 456.60 TROPHY CLUB MUD (WATER BILLS) 32201 AP 878 01/31/2013 January A/R billed to Town AR 20130130-20130131 User: (67.86) 388.74 AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60025-030-000 Water Totals: 67.86 388.74 ** 3,100.00 Budgeted 2,711.26 Remaining 13 % Used Account: 135-60030-030-000 Rent And/Or Usage 556 01/04/2013 Jan A/P January Public Services Rent 3,295.53 1,098.51 4,394.04 TOWN OF TROPHY CLUB 32107 AP 701 01/23/2013 A/R Billing/Town AR 20130123-20130123 User: (583.33) 3,810.71 AR _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: 515.18 3,810.71 ** 13,182.00 Budgeted 9,371.29 Remaining 29 % Used Account: 135-60035-030-000 Postage 541 01/02/2013 Jan A/P Leak postcard mailing 6,318.97 566.32 6,885.29 U.S. POSTAL SERVICE 32028 AP 720 01/27/2013 Jan A/P Overnight shipments 73.26 6,958.55 FEDERAL EXPRESS CORP 32133 AP 720 01/27/2013 Jan A/P Postage 19.99 6,978.54 PURCHASE POWER 32145 AP 720 01/27/2013 Jan A/P Printing of December water bil 1,653.68 8,632.22 DP2 BILLING SOLUTIONS, LLC 32132 AP 748 01/30/2013 Jan A/P Postage for meter 1,500.00 10,132.22 RESERVE ACCOUNT 32162 AP 813 01/31/2013 Jan A/P Overnight shipments 10.74 10,142.96 FEDERAL EXPRESS CORP 32179 AP _______________ Account: 135-60035-030-000 Postage Totals: 3,823.99 10,142.96 ** 23,000.00 Budgeted 12,857.04 Remaining 44 % Used Account: 135-60040-030-000 Service Charges & Fees 800 01/03/2013 Online, Credit card fees 7,636.71 81.86 7,718.57 GL 800 01/03/2013 Online, Credit card fees 75.40 7,793.97 GL 800 01/03/2013 Online, Credit card fees 1,920.17 9,714.14 GL 802 01/10/2013 FF Account Analysis/January 250.00 9,964.14 GL 813 01/31/2013 Jan A/P Tier Two 50.00 10,014.14 TIER TWO CHEMICAL REPORTING 32199 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 2,377.43 10,014.14 ** 18,000.00 Budgeted 7,985.86 Remaining 56 % Used Account: 135-60050-030-000 Bad Debt Expense 694 01/01/2013 UB 1/1/13 Write Offs UB20130101-20130101 User: (1,056.53) 1,710.59 654.06 UB 743 01/29/2013 UB 01/29/2013 Remit Payments UB20130129-20130129 User: MSCH (75.65) 578.41 UB 885 01/31/2013 Recode Bad Debt expense 117.06 695.47 GL _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: 1,752.00 695.47 ** 8,500.00 Budgeted 7,804.53 Remaining 8 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60055-030-000 Insurance 753 01/31/2013 Allocate FD TML Ins pd by MUD 60,593.77 (9,950.00) 50,643.77 GL _______________ Account: 135-60055-030-000 Insurance Totals: (9,950.00) 50,643.77 ** 35,000.00 Budgeted (15,643.77) Remaining 145 % 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 813 01/31/2013 Jan A/P Utility member dues 900.00 2,991.95 3,891.95 Texas Rural Water Assoc 32197 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 2,991.95 3,891.95 ** 2,400.00 Budgeted (1,491.95) Remaining 162 % Used Account: 135-60075-030-000 Meetings 715 01/25/2013 Jan A/P 12/6-1/5 PCards - McKnight 118.00 35.89 153.89 JPMORGAN CHASE BANK NA 32120 AP _______________ Account: 135-60075-030-000 Meetings Totals: 35.89 153.89 ** 250.00 Budgeted 96.11 Remaining 62 % Used Account: 135-60080-030-000 Schools & Training 570.00 .00 570.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 570.00 ** 5,500.00 Budgeted 4,930.00 Remaining 10 % Used Account: 135-60100-030-000 Travel & per diem 694.19 .00 694.19 _______________ Account: 135-60100-030-000 Travel & per diem Totals: .00 694.19 ** 3,950.00 Budgeted 3,255.81 Remaining 18 % Used Account: 135-60110-030-000 Physicals/Testing . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2013 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-60110-030-000 Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 851 01/31/2013 Bank Rec adjustments 122.13 .56 122.69 GL 851 01/31/2013 Bank Rec adjustments .01 122.70 GL _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .57 122.70 ** 15,000.00 Budgeted 14,877.30 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-60281-030-000 Park Expenses 813 01/31/2013 Jan A/P Oct-Dec Harmony Park expenses 16,430.72 16,430.72 TOWN OF TROPHY CLUB 32200 AP _______________ Account: 135-60281-030-000 Park Expenses Totals: 16,430.72 16,430.72 ** .00 Budgeted (16,430.72) Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2,325.00 .00 2,325.00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .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 640 01/10/2013 Jan A/P PCards 11/28-12/27 Pastor 6,288.27 104.99 6,393.26 BANK OF AMERICA 32115 AP 640 01/10/2013 Jan A/P PCards 11/28-12/27 Pastor 2,182.56 8,575.82 BANK OF AMERICA 32115 AP 640 01/10/2013 Jan A/P PCards 11/28-12/27 Pastor 101.91 8,677.73 BANK OF AMERICA 32115 AP 640 01/10/2013 Jan A/P PCards 11/28-12/27 Pastor 1,752.49 10,430.22 BANK OF AMERICA 32115 AP _______________ Account: 135-65055-030-000 Hardware Totals: 4,141.95 10,430.22 ** 20,188.00 Budgeted 9,757.78 Remaining 52 % Used Account: 135-65085-030-000 Office Supplies 640 01/10/2013 Jan A/P PCards 11/28-12/27 Pastor 1,852.62 149.50 2,002.12 BANK OF AMERICA 32115 AP 720 01/27/2013 Jan A/P Office Supplies 278.39 2,280.51 OFFICE DEPOT, INC 32142 AP 720 01/27/2013 Jan A/P Office Supplies 238.61 2,519.12 OFFICE DEPOT, INC 32142 AP 720 01/27/2013 Jan A/P Lock kits returned (86.97) 2,432.15 OFFICE DEPOT, INC 32142 AP 720 01/27/2013 Jan A/P Office Supplies 21.46 2,453.61 OFFICE DEPOT, INC 32142 AP 720 01/27/2013 Jan A/P Office Supplies 124.98 2,578.59 OFFICE DEPOT, INC 32142 AP 720 01/27/2013 Jan A/P Office Supplies 4.21 2,582.80 OFFICE DEPOT, INC 32142 AP 878 01/31/2013 January A/R billed to Town AR 20130130-20130131 User: (54.18) 2,528.62 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 676.00 2,528.62 ** 8,200.00 Budgeted 5,671.38 Remaining 31 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 900.00 .00 900.00 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 900.00 ** 5,732.00 Budgeted 4,832.00 Remaining 16 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65095-030-000 Maintenance Supplies 715 01/25/2013 Jan A/P 12/6-1/5 PCards-Schultz 269.21 120.58 389.79 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards-Schultz 214.19 603.98 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards-Schultz 10.79 614.77 JPMORGAN CHASE BANK NA 32120 AP 715 01/25/2013 Jan A/P 12/6-1/5 PCards - Huggins 40.21 654.98 JPMORGAN CHASE BANK NA 32120 AP 720 01/27/2013 Jan A/P Gloves & supplies 60.18 715.16 COSTCO WHOLESALE 32130 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 445.95 715.16 ** 2,000.00 Budgeted 1,284.84 Remaining 36 % 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 715 01/25/2013 Jan A/P Copier lease 1,027.40 256.85 1,284.25 TOWN OF TROPHY CLUB 32122 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 1,284.25 ** 3,450.00 Budgeted 2,165.75 Remaining 37 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 26,911.00 Budgeted 26,911.00 Remaining 0 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 439,633.28 ** 1,051,838.00 Budgeted 612,204.72 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 1/2013 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 720 01/27/2013 Jan A/P December legal 21,728.44 10,314.40 32,042.84 WHITAKER CHALK SWINDLE 32160 AP 720 01/27/2013 Jan A/P December legal 366.50 32,409.34 WHITAKER CHALK SWINDLE 32160 AP 720 01/27/2013 Jan A/P December legal 17,155.55 49,564.89 BOOTH, AHRENS & WERKENTHIN PC 32126 AP 720 01/27/2013 Jan A/P December legal 4,840.00 54,404.89 THE LISTON LAW FIRM, P.C. 32152 AP 813 01/31/2013 Jan A/P Legal 770.00 55,174.89 FREEMAN & CORBETT 32180 AP _______________ Account: 135-55045-039-000 Legal Totals: 33,446.45 55,174.89 ** 70,000.00 Budgeted 14,825.11 Remaining 79 % Used Account: 135-55055-039-000 Auditing 720 01/27/2013 Jan A/P Complete Field work 5,175.00 10,350.00 15,525.00 LAFOLLETT & COMPANY PLLC 32136 AP _______________ Account: 135-55055-039-000 Auditing Totals: 10,350.00 15,525.00 ** 21,200.00 Budgeted 5,675.00 Remaining 73 % Used Account: 135-55060-039-000 Appraisal 4,265.90 .00 4,265.90 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 4,265.90 ** 15,100.00 Budgeted 10,834.10 Remaining 28 % Used Account: 135-55065-039-000 Tax Admin Fees 813 01/31/2013 Jan A/P Tax statements 2,340.98 2,340.98 DENTON COUNTY TAX OFFICE 32176 AP _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: 2,340.98 2,340.98 ** 3,800.00 Budgeted 1,459.02 Remaining 62 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 77,306.77 ** 110,100.00 Budgeted 32,793.23 Remaining 70 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 480,495.53 .00 Budgeted (480,495.53) Remaining 0 % Used Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 1/31/2013 ASSETS ASSETS CASH AND CASH IN BANK 6,120$ INVESTMENTS 282,107 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 63,090 TOTAL ASSETS 351,317$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE 274$ DEFERRED REVENUE 63,090$ TOTAL LIABILITIES 63,364 FUND BALANCE ASSIGNED FUND BALANCE 287,953 TOTAL LIABILITIES AND FUND BALANCE 351,317$ January 31, 2013 4/12 Months (33.3% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 17:19 02/14/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 1/2013 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- 52,368.28- 148,206.30- 75.255 48,733.70- 533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 270.77 2,279.88- 58.458 1,620.12- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 1.38- 972.07- 19.376 4,044.93- Subtotal: 205,857.00- 205,857.00- 52,098.89- 151,458.25- 73.574 54,398.75- 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.29- 77.06- 4.533 1,622.94- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- Subtotal: 309,700.00- 309,700.00- 20.29- 77.06- .025 309,622.94- Program number: 860,557.00- 860,557.00- 52,119.18- 151,535.31- 17.609 709,021.69- Department number: Revenues 860,557.00- 860,557.00- 52,119.18- 151,535.31- 17.609 709,021.69- Revenues Subtotal ----------- 860,557.00- 860,557.00- 52,119.18- 151,535.31- 17.609 709,021.69- . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 17:19 02/14/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 1/2013 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- 52,119.18- 151,535.31- 672.773 129,011.31 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 1/2013 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 771 01/02/2013 Property Taxes/Assessments (95,838.02) (1,729.03) (97,567.05) GL 772 01/03/2013 Property Taxes/Assessments (5,277.14) (102,844.19) GL 773 01/04/2013 Property Taxes/Assessments (4,138.72) (106,982.91) GL 776 01/07/2013 Property Taxes/Assessments (1,729.26) (108,712.17) GL 777 01/08/2013 Property Taxes/Assessments (3,236.65) (111,948.82) GL 784 01/09/2013 Property Taxes/Assessments (612.15) (112,560.97) GL 785 01/10/2013 Property Taxes/Assessments (1,925.74) (114,486.71) GL 786 01/11/2013 Property Taxes/Assessments (1,670.71) (116,157.42) GL 787 01/14/2013 Property Taxes/Assessments (3,898.31) (120,055.73) GL 788 01/15/2013 Property Taxes/Assessments (2,579.55) (122,635.28) GL 790 01/16/2013 Property Taxes/Assessments (1,031.12) (123,666.40) GL 789 01/17/2013 Property Taxes/Assessments (3,116.97) (126,783.37) GL 791 01/18/2013 Property Taxes/Assessments (3,401.02) (130,184.39) GL 792 01/22/2013 Property Taxes/Assessments (798.41) (130,982.80) GL 793 01/23/2013 Property Taxes/Assessments (1,644.86) (132,627.66) GL 794 01/24/2013 Property Taxes/Assessments (4,424.64) (137,052.30) GL 795 01/25/2013 Property Taxes/Assessments (2,171.34) (139,223.64) GL 796 01/28/2013 Property Taxes/Assessments (4,373.13) (143,596.77) GL 797 01/29/2013 Property Taxes/Assessments (3,857.25) (147,454.02) GL 798 01/30/2013 Property Taxes/Assessments (752.28) (148,206.30) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (52,368.28) (148,206.30) ** (196,940.00) Budgeted (48,733.70) Remaining 75 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 797 01/29/2013 Property Taxes/Assessments (2,550.65) (2.93) (2,553.58) GL 813 01/31/2013 Jan A/P FKA2 shortage due to refund 273.70 (2,279.88) DENTON COUNTY TAX OFFICE 32177 AP _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: 270.77 (2,279.88) ** (3,900.00) Budgeted (1,620.12) Remaining 58 % Used Account: 533-40015-000-000 Property Taxes/P & I 797 01/29/2013 Property Taxes/Assessments (970.69) (1.38) (972.07) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (1.38) (972.07) ** (5,017.00) Budgeted (4,044.93) Remaining 19 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 1/2013 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 799 01/31/2013 Bank Interest/January (56.77) (20.29) (77.06) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (20.29) (77.06) ** (1,700.00) Budgeted (1,622.94) Remaining 5 % 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: ------------------------------------------------------------------------------------------------ (151,535.31) ** (860,557.00) Budgeted (709,021.69) Remaining 18 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 17:20 02/14/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 1/2013 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: ------------------------------------------------------------------------------------------------------ (151,535.31) (22,524.00) Budgeted 129,011.31 Remaining 673 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (438,259.19) **** (22,524.00) Budgeted 415,735.19 Remaining ########## ******* End of Report *********